SELECT
promo_campaigns.campaign_code_title,
promo_campaigns.campaign_validfrom,
promo_campaigns.campaign_validto,
promo_campaigns.campaign_id,
promo_campaigns.campaign_slag_title,
if(promo_campaigns.campaign_type = 4,1,0) AS codeyes,
promo_campaigns.campaign_details,
promo_campaigns.campaign_code,
promo_campaigns.campaign_type,
promo_campaigns.campaign_promo_url,
category_id,
promo_campaigns.campaign_retailer_order
FROM
promo_campaigns
WHERE
promo_campaigns.campaign_status = '1' AND
promo_campaigns.campaign_validfrom <= '2012-05-21' AND
promo_campaigns.retailerbrand_id =  AND
promo_campaigns.campaign_validto >=  '2012-05-21'
ORDER BY
case when promo_campaigns.campaign_retailer_order in('', '0') then 1 else 0 end,promo_campaigns.campaign_retailer_order ASC,codeyes DESC,promo_campaigns.campaign_validfrom DESC<p>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 'AND
promo_campaigns.campaign_validto >=  '2012-05-21'
ORDER BY
case when prom' at line 19