Warning: mysql_query(): Unable to save result set in /home/netshops/public_html/system/database/mysql.php on line 66Error: Table 'shop1product' is marked as crashed and should be repaired
Error No: 1194
SELECT pc.category_id, COUNT(DISTINCT pc.product_id) AS pcount FROM shop1product_to_category AS pc LEFT JOIN shop1product AS p ON pc.product_id = p.product_id WHERE p.quantity > 0 AND p.variant=0 GROUP BY pc.category_id