SELECT p.ID as ID FROM products AS p INNER JOIN category_relationships as cr_pc ON cr_pc.object_id=p.ID WHERE p.deleted=0 AND p.is_available=1 AND p.status=0 AND p.image_id!=0 AND p.shop_id=27 AND p.product_overview=1 AND cr_pc.category_class='Product_Category' AND cr_pc.category_id=5617 AND cr_pc.object_class='Product' GROUP BY p.ID ORDER BY p.modified DESC, p.ID DESC LIMIT 0, 6
