FROM #__hikashop_product_category AS a LEFT JOIN #__hikashop_product AS b ON a.product_id=b.product_id LEFT JOIN #__hikashop_category AS man ON b.product_manufacturer_id = man.category_id WHERE (b.product_published = 1) AND (b.product_type = 'main') AND (a.category_id IN (24,25,26,27,114,93)) AND ((b.product_access = 'all' OR b.product_access LIKE '%,9,%')) ORDER BY man.category_ordering, CAST(CONCAT(IFNULL(b.product_size,''),IFNULL(b.product_size_inch,''),IFNULL(b.product_length_mm,''),IFNULL(b.product_thickness,''),IFNULL(b.product_length_m,'')) AS decimal(10,2)) ASC
