Artisan
No valid database connection Got error 28 from storage engine SQL=SELECT *, CONVERT(`jos_vm_product`.`product_sku`, UNSIGNED) AS `skunum` FROM `jos_vm_product_category_xref`, `jos_vm_product`, `jos_vm_category`, `jos_vm_category_xref`
WHERE `jos_vm_product_category_xref`.`product_id` IN ('1171', '1095', '1105', '1093', '1100', '1097', '1170', '1099', '1104', '1094', '1096', '1101', '1103', '1102', '1091', '1092', '1098', '1065', '1071', '1072')
AND `jos_vm_product`.`product_id` = `jos_vm_product_category_xref`.`product_id`
AND `jos_vm_product`.`product_publish` = 'Y'
AND `jos_vm_product_category_xref`.`category_id` NOT IN ('2','5','6','7','8','9','0','833','835','836','838','840','843','850','855','866')
AND `jos_vm_category`.`category_id` = `jos_vm_product_category_xref`.`category_id`
AND `jos_vm_category_xref`.`category_child_id` = `jos_vm_product_category_xref`.`category_id`
AND `jos_vm_category`.`category_publish` = 'Y'
ORDER BY `jos_vm_category`.`list_order` ASC, `skunum` ASC
