#0 Db::query( SELECT `p`.`id`, `p`.`id_supplier`, `p`.`price`,`p`.on_order FROM `products` AS `p` INNER JOIN `category_product` AS `cp` ON `p`.`id`=`cp`.`id_product` INNER JOIN `product_suppliers` AS `ps` ON `p`.`id_supplier`=`ps`.`id` WHERE `p`.`is_sale`=0 AND `p`.`active`=1 AND ( ( `pcs`.`id_product` IS NOT NULL ) OR ( `p`.`is_sale`=1 AND `p`.`sale_is_sold`=0 ) OR `p`.`id_supplier`=19 OR (p.price_1<>0 and p.price_2<>0 and p.price_3<>0 ) ) AND `cp`.`id_category` IN ?a GROUP BY `p`.`id` ORDER BY ps.archive,`p`.`on_order` ASC, `p`.`sort` ASC, `p`.`price` ASC, `p`.`id` DESC , Array ([0] => Array ([0] => 88)), /home/poshvu.ru/public_html/www/class/Product.php, 1958) called at [/home/poshvu.ru/public_html/www/class/Product.php:1958] #1 site_Product::get_list_products_by_filters(Array ([83] => Array ([0] => 88),[category] => Array ([0] => 871,[1] => 6,[2] => 1006,[3] => 1022)), Array ([sort_popular] => populardown), , , 1, , category, Array (), , 1, 40, , , , , Array ([0] => 1007,[1] => 1006,[2] => 1022,[3] => 6,[4] => 871,[5] => 6,[6] => 1006,[7] => 1022), 1, , ) called at [/home/poshvu.ru/public_html/www/services/category_main.php:334] #2 require(/home/poshvu.ru/public_html/www/services/category_main.php) called at [/home/poshvu.ru/public_html/www/services/category.php:230] #3 include_once(/home/poshvu.ru/public_html/www/services/category.php) called at [/home/poshvu.ru/public_html/www/index.php:239]
MySQL mini debug
MySQL query error in file /home/poshvu.ru/public_html/www/services/category.php:230.
MySQL error (#1054): Unknown column 'pcs.id_product' in 'where clause'
Callstack:

SELECT `p`.`id`, `p`.`id_supplier`, `p`.`price`,`p`.on_order FROM `products` AS `p` INNER JOIN `category_product` AS `cp` ON `p`.`id`=`cp`.`id_product` INNER JOIN `product_suppliers` AS `ps` ON `p`.`id_supplier`=`ps`.`id` WHERE `p`.`is_sale`=0 AND `p`.`active`=1 AND ( ( `pcs`.`id_product` IS NOT NULL ) OR ( `p`.`is_sale`=1 AND `p`.`sale_is_sold`=0 ) OR `p`.`id_supplier`=19 OR (p.price_1<>0 and p.price_2<>0 and p.price_3<>0 ) ) AND `cp`.`id_category` IN ("88") GROUP BY `p`.`id` ORDER BY ps.archive,`p`.`on_order` ASC, `p`.`sort` ASC, `p`.`price` ASC, `p`.`id` DESC #0 Db::query( SELECT `p`.`id`, `p`.`id_supplier`, `p`.`price`,`p`.on_order FROM `products` AS `p` INNER JOIN `category_product` AS `cp` ON `p`.`id`=`cp`.`id_product` INNER JOIN `product_suppliers` AS `ps` ON `p`.`id_supplier`=`ps`.`id` WHERE `p`.`is_sale`=0 AND `p`.`active`=1 AND ( ( `pcs`.`id_product` IS NOT NULL ) OR ( `p`.`is_sale`=1 AND `p`.`sale_is_sold`=0 ) OR `p`.`id_supplier`=19 OR (p.price_1<>0 and p.price_2<>0 and p.price_3<>0 ) ) AND `cp`.`id_category` IN ?a GROUP BY `p`.`id` ORDER BY ps.archive,`p`.`on_order` ASC, `p`.`sort` ASC, `p`.`price` ASC, `p`.`id` DESC , Array ([0] => Array ([0] => 88)), /home/poshvu.ru/public_html/www/class/Product.php, 1958) called at [/home/poshvu.ru/public_html/www/class/Product.php:1958] #1 site_Product::get_list_products_by_filters(Array ([83] => Array ([0] => 88),[category] => Array ([0] => 871,[1] => 6,[2] => 1006,[3] => 1022)), Array ([sort_popular] => populardown), , , 1, , category, Array (), , 1, 40, , , , , Array ([0] => 1007,[1] => 1006,[2] => 1022,[3] => 6,[4] => 871,[5] => 6,[6] => 1006,[7] => 1022), 1, , ) called at [/home/poshvu.ru/public_html/www/services/category_main.php:334] #2 require(/home/poshvu.ru/public_html/www/services/category_main.php) called at [/home/poshvu.ru/public_html/www/services/category.php:230] #3 include_once(/home/poshvu.ru/public_html/www/services/category.php) called at [/home/poshvu.ru/public_html/www/index.php:239]