Notice: Error: Table 'sportmayak.product' doesn't exist
Error No: 1146
SELECT SQL_CALC_FOUND_ROWS p.*,pd.*,COUNT(r.`rating`)AS reviews ,r.`rating` ,(SELECT ps.`price` FROM `product_special` ps WHERE ps.`product_id`=p.`product_id` AND ((ps.`date_start`='0000-00-00' OR ps.`date_start`<='2020-02-25')AND(ps.`date_end`='0000-00-00' OR ps.`date_end`>='2020-02-25')AND(ps.`customer_group_id`=1)) ORDER BY ps.`priority`,ps.`price` LIMIT 1)AS special ,p.`stock_status_id` AS stock_status ,IF(((ps.`date_start`='0000-00-00' OR ps.`date_start`<='2020-02-25')AND(ps.`date_end`='0000-00-00' OR ps.`date_end`>='2020-02-25')AND(ps.`customer_group_id`=1)),ps.`price`,p.`price`) AS price_sort FROM `product` p LEFT JOIN `product_special` AS ps ON(p.`product_id`=ps.`product_id` AND ps.`customer_group_id`=1) JOIN `product_description` pd ON(p.`product_id`=pd.`product_id`) LEFT JOIN `review` AS r ON(p.`product_id`=r.`product_id`) WHERE p.`manufacturer_id`=69 AND p.`status`=1 AND pd.`language_id`=1 GROUP BY p.`product_id` ORDER BY p.sort_order ASC LIMIT 0,36 in /var/www/www-root/data/www/sportmayak.ru/system/database/mysqliz.php on line 53