Notice: Error: Table 'propmr.hr_product_to_type' doesn't exist
Error No: 1146
SELECT DISTINCT SQL_CALC_FOUND_ROWS p.product_id, (SELECT AVG(rating) AS total FROM hr_review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating FROM hr_product_to_category p2c LEFT JOIN hr_product p ON (p2c.product_id = p.product_id) LEFT JOIN hr_product_to_type p2t ON (p2t.product_id = p2c.product_id) LEFT JOIN hr_product_description pd ON (p.product_id = pd.product_id) WHERE pd.language_id = '1' AND p.status = '1' AND ( p2c.category_id = '11') GROUP BY p.product_id ORDER BY CASE WHEN p.date_available >= '2018-06-25 07:14:00' THEN 1 END DESC, CASE WHEN p.date_available < '2018-06-25 07:14:00' THEN 2 END DESC, p.date_modified DESC, p.product_id DESC LIMIT 0,10 in /var/www/strejnev/data/www/map.propmr.ru/system/database/mysql.php on line 50