2013-May-22 03:18:41 1064 : 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 'or pc.portal_id = 17)
AND co.user_id = ''
group BY c.id
having cnt > 0
' at line 11
Select c.* , count(cc.category_id) as cnt
from categories c left join coupons_categories cc on c.id = cc.category_id
right join coupons co on cc.coupon_id = co.id
left join portal_coupons pc on pc.coupon_id = co.id
where
1
and co.start_date <= CURDATE()
AND co.end_date >= CURDATE()
AND co.enabled = 1
AND co.user_id = 0
AND (pc.portal_id is null or pc.portal_id = or pc.portal_id = 17)
AND co.user_id = ''
group BY c.id
having cnt > 0
order by position;
2013-May-22 03:18:41 1064 : 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 'or pc.portal_id = 17)' at line 1
select count(coupons.id) from coupons left join portal_coupons pc on pc.coupon_id = coupons.id where coupons.start_date <= CURDATE() AND coupons.user_id = '' AND coupons.end_date >= CURDATE() AND coupons.enabled = 1 and (pc.portal_id is null or pc.portal_id = or pc.portal_id = 17) Warning: Invalid argument supplied for foreach() in /home/webs/gutschein/blocks/small_search.php on line 242
Warning: Invalid argument supplied for foreach() in /home/webs/gutschein/blocks/small_search.php on line 254 Gutschein.at
