Fatal error: Uncaught Exception: Error: Table 'gcity.oc_tmp_product' doesn't exist<br />Error No: 1146<br />SELECT
COUNT(DISTINCT p.product_id) AS total,
category_id
FROM oc_product_to_category p2c
LEFT JOIN oc_tmp_product p ON (p2c.product_id = p.product_id)
WHERE
p.status = 1
AND p.quantity > 0
AND p.display_in_cat = 1
AND p.date_available <= NOW()
AND (p2c.category_id = 65
OR p2c.category_id = 73
OR p2c.category_id = 72
OR p2c.category_id = 78
OR p2c.category_id = 79
OR p2c.category_id = 59
OR p2c.category_id = 80)
GROUP BY category_id in /var/www/gcity08/data/www/gcity08.ru/system/storage/modification2/system/library/db/mysqli.php:52
Stack trace:
#0 /var/www/gcity08/data/www/gcity08.ru/system/storage/modification2/system/library/db.php(21): DB\MySQLi->query('SELECT \r\n\t\t\t\tCO...')
#1 / in /var/www/gcity08/data/www/gcity08.ru/system/storage/modification2/system/library/db/mysqli.php on line 52