select p.products_id, p.products_image, p.products_tax_class_id, p.products_price, p.products_quantity, p.products_last_modified, pd.products_name, p2c.categories_id, (select customers_group_price from products_groups where products_id = p.products_id AND customers_group_id = '0' LIMIT 1) as customers_group_price, (select specials_new_products_price FROM specials where products_id = p.products_id AND customers_group_id = '0' AND status=1 LIMIT 1) as specials_new_products_price, (select threshold FROM free_gifts where products_id = p.products_id AND customers_group_id = '0' LIMIT 1) as threshold, (select IF(status =1 AND expires_date>now(),1,0) as st FROM specials where products_id = p.products_id AND customers_group_id = '0' LIMIT 1) as specstat from products p LEFT JOIN products_to_categories p2c ON (p.products_id = p2c.products_id) LEFT JOIN products_description pd ON (p.products_id = pd.products_id) LEFT JOIN categories c ON (p2c.categories_id = c.categories_id) LEFT JOIN categories_description cd ON (cd.categories_id = c.categories_id) WHERE p.products_status = 1 AND p.products_quantity>0 AND pd.products_name > '' AND pd.language_id = 4 AND cd.language_id = 4 AND p2c.categories_id NOT IN(41,147,57,167,148,151,153,149,150,152,154,188,169,168,189,32,144,103,185,105,136,146,138,140,52,97,184) and DATEDIFF(now() , p.products_date_added)<21 GROUP BY p.products_id order by p.products_date_added DESC, pd.products_name
NULL

0 /home/devtaam/www/includes/functions/general_antal.php(398): stackTrace()
1 /home/devtaam/www/products_new.php(42): i_test('select p.produc...')
2 {main}