Unknown column 'p.created_on' in 'ORDER BY' SQL=SELECT SQL_CALC_FOUND_ROWS nt3.* FROM ( SELECT nt.virtuemart_product_id, nt.product_parent_id, nt.product_sku, CASE WHEN (nt.parent_special = 0 OR nt.parent_special IS NULL ) THEN nt.product_special ELSE nt.parent_special END AS product_special, max(nt.product_special) as featured, MAX(nt.created_on) as created_on, SUM(nt.product_sales) as product_sales, nt.viewd_count, nt.product_unit, nt.product_in_stock, nt.product_c_availability, CASE WHEN (nt.parent_name = '' OR nt.parent_name IS NULL ) THEN nt.product_name ELSE nt.parent_name END AS product_name , CASE WHEN (nt.product_s_desc = '' OR nt.product_s_desc IS NULL ) THEN nt.pparent_s_desc ELSE nt.product_s_desc END AS product_sdesc, max(nt.clerance) as clerance, nt.rating, CASE WHEN (nt.pparent_img_alt_text = '' OR nt.pparent_img_alt_text IS NULL ) THEN nt.img_alt_text ELSE nt.pparent_img_alt_text END AS img_alt_text, CASE WHEN (nt.pparent_lthumb_image_url = '' OR nt.pparent_lthumb_image_url IS NULL) THEN nt.lthumb_image_url ELSE nt.pparent_lthumb_image_url END AS detail_image_url, CASE WHEN (nt.virtuemart_manufacturer_id IS NULL OR nt.virtuemart_manufacturer_id = '') THEN nt.pparent_virtuemart_manufacturer_id ELSE nt.virtuemart_manufacturer_id END AS virtuemart_manufacturer_id, nt.virtuemart_category_id, nt.virtuemart_shoppergroup_id, min(cast(cstpce_1.sales_price as decimal(10, 2))) as minimum_price , max(cast(cstpce_1.sales_price as decimal(10, 2))) as maximum_price, max(cast(cstpce_1.discount_percent as decimal(10, 2))) as discount, cstpce_1.regular_price, cstpce_1.sales_price FROM ( SELECT p.virtuemart_product_id, p.product_parent_id, p.product_sku, p.product_special, p.created_on, p.product_sales, p.viewd_count, p.product_unit, p.product_in_stock, p.product_c_availability, p2.product_special as parent_special, pengb.product_name,pengb2.product_name as parent_name, pengb.product_s_desc, pengb2.product_s_desc as pparent_s_desc, pclce.clerance, pr.rating, med.img_alt_text, med.lthumb_image_url, med2.img_alt_text AS pparent_img_alt_text, med2.lthumb_image_url AS pparent_lthumb_image_url, pman.virtuemart_manufacturer_id, pman2.virtuemart_manufacturer_id AS pparent_virtuemart_manufacturer_id, pc.virtuemart_category_id, CASE WHEN pspg.virtuemart_shoppergroup_id IS NULL THEN p.published ELSE pspg.virtuemart_shoppergroup_id END AS virtuemart_shoppergroup_id FROM `jos_virtuemart_products` AS p JOIN `jos_virtuemart_product_categories` AS pc ON p.virtuemart_product_id = pc.virtuemart_product_id LEFT JOIN `jos_virtuemart_ratings` AS pr ON (pr.virtuemart_product_id = p.product_parent_id AND pr.published = 1) LEFT JOIN jos_virtuemart_product_medias AS pmed ON (pmed.virtuemart_product_id = p.virtuemart_product_id AND pmed.ordering = 1) LEFT JOIN jos_virtuemart_product_more_imgs AS med ON (med.virtuemart_media_id = pmed.virtuemart_media_id) JOIN jos_virtuemart_products AS p2 ON (p2.virtuemart_product_id = p.product_parent_id AND p.product_parent_id != 0) LEFT JOIN `jos_virtuemart_product_manufacturers` AS pman ON pman.virtuemart_product_id = p.virtuemart_product_id LEFT JOIN `jos_virtuemart_product_manufacturers` AS pman2 ON pman2.virtuemart_product_id = p2.virtuemart_product_id LEFT JOIN `jos_virtuemart_products_en_gb` AS pengb ON pengb.virtuemart_product_id = p.virtuemart_product_id LEFT JOIN `jos_virtuemart_products_en_gb` AS pengb2 ON pengb2.virtuemart_product_id = p2.virtuemart_product_id LEFT JOIN jos_virtuemart_product_medias AS pmed2 ON (pmed2.virtuemart_product_id = p2.virtuemart_product_id AND pmed2.ordering = 1) LEFT JOIN jos_virtuemart_product_more_imgs AS med2 ON med2.virtuemart_media_id = pmed2.virtuemart_media_id LEFT JOIN jos_virtuemart_product_clerance AS pclce ON pclce.virtuemart_product_id = p.virtuemart_product_id LEFT JOIN jos_virtuemart_product_shoppergroups AS pspg ON pspg.virtuemart_product_id = p.virtuemart_product_id WHERE pc.virtuemart_category_id IN(295,306) AND p.published = 1 AND p2.published = 1 AND (pspg.virtuemart_shoppergroup_id = 1 OR pspg.virtuemart_shoppergroup_id IS NULL ) ORDER BY p.product_special DESC, p.created_on DESC, p.viewd_count DESC, p.product_sales DESC, pr.rating DESC ) AS nt JOIN jos_virtuemart_product_custprices as cstpce ON (cstpce.virtuemart_product_id = nt.virtuemart_product_id AND cstpce.shopper_group_id = 1 )LEFT JOIN jos_virtuemart_product_custprices as cstpce_1 ON (cstpce_1.virtuemart_product_id = nt.virtuemart_product_id AND cstpce_1.shopper_group_id = 1 AND ((nt.product_c_availability= 'Available' AND nt.product_in_stock >0) OR (nt.product_c_availability= 'Contact For Availability') OR (nt.product_c_availability= 'Pre Order') ) ) GROUP BY nt.product_parent_id UNION SELECT nt2.*, cstpce_1.sales_price as minimum_price , cstpce_1.sales_price as maximum_price, cstpce_1.discount_percent as discount, cstpce_1.regular_price, cstpce_1.sales_price FROM ( SELECT p.virtuemart_product_id, p.product_parent_id, p.product_sku, p.product_special, p.product_special as featured, p.created_on, p.product_sales, p.viewd_count, p.product_unit, p.product_in_stock, p.product_c_availability, pengb.product_name, pengb.product_s_desc, pclce.clerance, pr.rating, med.img_alt_text, med.lthumb_image_url, pman.virtuemart_manufacturer_id, pc.virtuemart_category_id, CASE WHEN pspg.virtuemart_shoppergroup_id IS NULL THEN p.published ELSE pspg.virtuemart_shoppergroup_id END AS virtuemart_shoppergroup_id FROM `jos_virtuemart_products` AS p JOIN `jos_virtuemart_product_categories` AS pc ON p.virtuemart_product_id = pc.virtuemart_product_id LEFT JOIN `jos_virtuemart_ratings` AS pr ON (pr.virtuemart_product_id = p.virtuemart_product_id AND pr.published = 1) LEFT JOIN jos_virtuemart_product_medias AS pmed ON ( pmed.virtuemart_product_id = p.virtuemart_product_id AND pmed.ordering = 1 ) LEFT JOIN jos_virtuemart_product_more_imgs AS med ON (med.virtuemart_media_id = pmed.virtuemart_media_id) LEFT JOIN `jos_virtuemart_product_manufacturers` AS pman ON pman.virtuemart_product_id = p.virtuemart_product_id LEFT JOIN `jos_virtuemart_products_en_gb` AS pengb ON pengb.virtuemart_product_id = p.virtuemart_product_id LEFT JOIN jos_virtuemart_product_clerance AS pclce ON pclce.virtuemart_product_id = p.virtuemart_product_id LEFT JOIN jos_virtuemart_product_shoppergroups AS pspg ON pspg.virtuemart_product_id = p.virtuemart_product_id WHERE pc.virtuemart_category_id IN(295,306) AND p.published = 1 AND p.product_parent_id = 0 AND p.virtuemart_product_id NOT IN(SELECT product_parent_id FROM `jos_virtuemart_products`) AND (pspg.virtuemart_shoppergroup_id = 1 OR pspg.virtuemart_shoppergroup_id IS NULL ) ORDER BY p.product_special DESC, p.created_on DESC, p.viewd_count DESC, p.product_sales DESC, pr.rating DESC ) AS nt2 JOIN jos_virtuemart_product_custprices as cstpce ON (cstpce.virtuemart_product_id = nt2.virtuemart_product_id AND cstpce.shopper_group_id = 1 ) LEFT JOIN jos_virtuemart_product_custprices as cstpce_1 ON (cstpce_1.virtuemart_product_id = nt2.virtuemart_product_id AND cstpce_1.shopper_group_id = 1 AND ((nt2.product_c_availability= 'Available' AND nt2.product_in_stock >0) OR (nt2.product_c_availability= 'Contact For Availability') OR (nt2.product_c_availability= 'Pre Order') )) ) AS nt3 WHERE nt3.virtuemart_product_id != '' AND nt3.virtuemart_manufacturer_id IN(62) GROUP BY nt3.virtuemart_product_id ORDER BY nt3.product_special DESC, p.created_on DESC, p.viewd_count DESC, p.product_sales DESC, p.rating DESC LIMIT 0, 15