A Database Error Occurred

Error Number: 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 ') GROUP BY p.id, pva.product_id, pva.attribute_id, pva.type_id ORDER by p.id DES' at line 1

SELECT p.title, p.slug, p.price, p.featured_image, p.featured_image_hover, pv.id AS variant_id, pv.title AS variant_title, pv.featured_image AS variant_featured_image, pv.featured_image_hover AS variant_featured_image_hover FROM cms_shop_products p LEFT JOIN cms_shop_product_variants AS pv ON pv.product_id = p.id AND pv.rev_type = 'live' AND pv.rev_lang_id = 1 AND pv.deleted = 0 LEFT JOIN cms_shop_product_variants_attributes AS pva ON pva.variant_id = pv.id AND pva.type_id = 1 INNER JOIN cms_shop_products_categories pc ON pc.product_id = p.id WHERE p.published > 0 AND p.published < UNIX_TIMESTAMP() AND (p.unpublished = 0 OR p.unpublished > UNIX_TIMESTAMP()) AND p.rev_type = 'live' AND p.deleted = 0 AND p.rev_lang_id = 1 AND pv.id IN (SELECT pva.variant_id FROM cms_shop_product_variants_attributes AS pva WHERE pva.variant_id = pv.id AND pva.type_id = 1 AND pva.attribute_id IN (31) GROUP BY pva.product_id) AND pc.category_id IN () GROUP BY p.id, pva.product_id, pva.attribute_id, pva.type_id ORDER by p.id DESC LIMIT 0,16

Filename: /var/www/perfectlysimple.dk/public_html/modules/shop/controllers/shop.php

Line Number: 126