6 vmdebug exeSortSearchListQuery my $limitStart 0 $limit 9 q Var1: SELECT p.`virtuemart_product_id`
FROM `ijtng_virtuemart_products` as p
LEFT JOIN `ijtng_virtuemart_product_shoppergroups` as ps ON p.`virtuemart_product_id` = `ps`.`virtuemart_product_id`
LEFT JOIN `ijtng_virtuemart_product_categories` as pc ON p.`virtuemart_product_id` = `pc`.`virtuemart_product_id`
LEFT JOIN `ijtng_virtuemart_categories` as c ON c.`virtuemart_category_id` = `pc`.`virtuemart_category_id`
LEFT JOIN `ijtng_virtuemart_product_prices` as pp ON p.`virtuemart_product_id` = pp.`virtuemart_product_id`
WHERE ( `pc`.`virtuemart_category_id` in ('46','1','2','3','4','5','6','7','8','9','10','53','58','63','68','11','12','13','14','15','16','17','18','47','48','49','136','20','21','22','23','24','25','26','27','28','52','57','62','67','194','195','29','30','31','32','34','35','55','60','65','70','150','36','37','38','51','56','61','66','81','137','138','139','140','39','42','44','54','59','64','69','82','83','93','71','72','74','75','76','79','80','94','95','97','102','135','152','169','170','179','193','73','113','114','115','116','190','77','78','103','111','151','162','186','209','84','85','86','96','89','90','91','92','101','105','109','110','141','149','161','164','200','201','204','205','206','207','211','98','99','100','104','108','155','156','157','178','196','197','199','202','212','106','107','112','185','117','118','120','121','122','123','124','125','126','127','128','129','130','131','132','133','134','168','142','143','144','145','146','153','154','158','159','160','163','171','172','173','174','175','176','203','165','166','167','177','187','188','198','210','213','191','189','192','208','216','46') AND `c`.`published` = 1 AND ( `ps`.`virtuemart_shoppergroup_id`= "1" OR `ps`.`virtuemart_shoppergroup_id` IS NULL ) AND p.`product_special`="1" AND p.`published`="1" )
group by p.`virtuemart_product_id`
ORDER BY p.`created_on` DESC, p.`virtuemart_product_id` DESC