Newsletters

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '( 1, 'color-green', 'color-red') AS `__class__Lettre-info`, `Lettre-info` AS `Le' at line 1 (4)
SELECT @IF( 1, 'color-green', 'color-red') AS `__class__Lettre-info`, `Lettre-info` AS `Lettre-info`, `Utilisateurs` AS `Utilisateurs`, `Nombre` AS `Nombre`, `Abonnement` AS `Abonnement`
FROM (SELECT 'color-red' AS '__class__Lettre-info', post.post_title AS 'Lettre-info'
  , GROUP_CONCAT(user.display_name, '<', user.user_email, '>') AS Utilisateurs
  , COUNT(user.ID) AS Nombre
  , JSON_UNQUOTE(JSON_EXTRACT(@TAX_TERMS_period, CONCAT("$[0].\"", `meta_value`, "\""))) AS Abonnement
  FROM wor6483_2_posts post
  INNER JOIN wor6483_usermeta meta
  ON meta.meta_key = CONCAT( @agdpnl_subscr, post.ID) 
  INNER JOIN wor6483_users user
  ON user.ID = meta.user_id
  WHERE ( '' = '' OR post.ID = '' )
  AND post.post_type = @post_type
  AND ( '|publish|' = '' OR post.post_status IN ( 'publish' ) )
  AND NOT ( '1' AND meta.meta_value = 'none' )
  GROUP BY post.post_title, JSON_UNQUOTE(JSON_EXTRACT(@TAX_TERMS_period, CONCAT("$[0].\"", `meta_value`, "\"")))
  ORDER BY post.post_title, Abonnement) _render