Database error: Invalid SQL: SELECT DISTINCT p.property_id, p.range, pt.property_title, pt.property_name, pt.property_prefix, pt.property_suffix, pt.type, pdv.value, pdv.id as pdvid, pdv.value as pdvid2, pdv.property_id as pdvid3 FROM (rm_rus_catalog_properties p, rm_rus_catalog_properties_table pt) LEFT JOIN rm_rus_catalog_properties_def_values pdv ON p.property_id = pdv.property_id WHERE p.property_id = pt.id AND pdv.id NOT IN(0) and p.group_id = and p.property_id IN(SELECT jpv.property_id FROM rm_rus_catalog_property_values jpv LEFT JOIN rm_rus_catalog_products cp ON cp.id = jpv.product_id WHERE jpv.group_id= and cp.active<>0 ) ORDER BY p.property_id, pdv.value
MySQL Error: 1064 (You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'and p.property_id IN(SELECT jpv.property_id FROM rm_rus_catalog_property_value' at line 6)
Session halted.