SELECT p.`products_id`, pl.`products_name`, pl.`products_depict`, p.`products_model`, p.`products_price`, p.`products_status`, pc.`categories_name`, pt.`type_name`, p.`products_first_image` FROM `products_to_categories` ptc LEFT JOIN `products` p ON ptc.`products_id`=p.`products_id` LEFT JOIN `products_lang` pl ON p.`products_id` = pl.`products_id` LEFT JOIN `categories_description` AS pc ON pc.`categories_id` = p.`master_categories_id` LEFT JOIN `product_types` pt ON p.`products_type` = pt.`type_id` WHERE pl.`language_id` = 1 AND p.`data_status` = 0 AND p.products_status=1 AND p.products_id NOT IN (SELECT products_id FROM specials WHERE (`expires_date`>=CURDATE() and `specials_date_available`<=CURDATE()) AND activate=1) AND ptc.`categories_id` IN (35) ORDER BY pl.products_hot desc LIMIT -15,15
#0 /mnt/www/menglu_testnew/lib/QfPHP/db/Adapter/pdo/mysql.class.php(291): qf_db_Adapter_pdo_mysql->query(' SELECT???p.`pr...')
#1 /mnt/www/menglu_testnew/lib/comm/productViewHelper.class.php(540): qf_db_Adapter_pdo_mysql->SelectLimit(' SELECT???p.`pr...', 23, '%E9%87%8C%E8%BE...', 15)
#2 /mnt/www/menglu_testnew/frontproject/controllers/goods/goodsController.class.php(58): productViewHelper->fetchAllPage(Array, '%E9%87%8C%E8%BE...', 15)
#3 [internal function]: goodsController->showlist()
#4 /mnt/www/menglu_testnew/lib/QfPHP/controller/qfController.class.php(97): ReflectionMethod->invoke(Object(goodsController))
#5 /mnt/www/menglu_testnew/lib/QfPHP/application/qfApplication.class.php(63): qfController->router()
#6 /mnt/www/menglu_testnew/index.php(17): qfApplication::run('prod')
#7 {main}