We're having trouble creating advanced filter in CB List. This query works fine in phpmyAdmin:
SELECT * FROM ducati_comprofiler
LEFT JOIN ducati_users ON(ducati_comprofiler.id=ducati_users.id)
LEFT JOIN ducati_cbsubs_subscriptions ON(ducati_comprofiler.id=ducati_cbsubs_subscriptions.user_id)
WHERE SUBSTRING(ducati_cbsubs_subscriptions.expiry_date,1,4)=2011
How should it look in advanced filter? This doesn't work either:
( SELECT '*' FROM `ducati_comprofiler`
LEFT JOIN `ducati_users` ON(`ducati_comprofiler.id`=`ducati_users.id`)
LEFT JOIN `ducati_cbsubs_subscriptions` ON(`ducati_comprofiler.id`=`ducati_cbsubs_subscriptions.user_id`)
WHERE SUBSTRING(`ducati_cbsubs_subscriptions.expiry_date`,1,4)='2011' )