SELECT
suggest.product_id,
suggest.name,
suggest.description,
opc.pgv_product_group_id,
c.id AS price_id,
c.amount, ot.code
FROM
ordered_products_cache opc
JOIN product suggest ON ( opc.ordered_product_id = suggest.product_id )
JOIN price c ON ( suggest.product_id = c.product_id AND c.enabled_ind AND c.start_vol = '1' AND ( NOW() BETWEEN c.start_dte AND c.end_dte ) )
JOIN purchase_option po ON ( c.product_id = po.product_id AND c.option_type_id = po.option_type_id AND ( NOW() BETWEEN po.publish_dte AND po.unpublish_dte ) AND po.active )
JOIN option_type ot ON ( po.option_type_id = ot.id AND ot.code NOT LIKE 'GUEST%' AND ot.code NOT LIKE 'EVENT%' )
JOIN member_type mt ON ( c.member_type_id = mt.id AND mt.type = 'Member' )
WHERE
opc.product_product_id IN ( )
AND opc.pgv_product_group_id <> '52'
GROUP BY opc.ordered_product_id
LIMIT 4
DBError #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 ')
AND opc.pgv_product_group_id <> '52'
GROUP BY opc.ordered_product' at line 16
in Engine |