Ontario
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 ('104', '428', '233', '234', '244', '254', '256', '257', '258', '259', '292', '294', '306', '307', '312', '313', '325', '326', '327', '328', '329', '330', '332', '333', '334', '335', '336', '337', '338', '339', '340', '341', '342', '343', '344', '345', '346', '347', '348', '349', '1054', '1052', '354', '356', '357', '358', '359', '1053', '391', '422', '1051', '513', '548', '549', '550', '551', '552', '553', '556', '557', '559', '564', '565', '566', '567', '568', '569', '570', '571', '572', '573', '574', '575', '577', '578', '579', '580', '581', '585', '586', '590', '591', '592', '593', '594', '595', '596', '597', '598', '599', '600', '601', '602', '604', '605', '606', '607', '608', '609', '610', '611', '612', '613', '614', '615', '616', '617', '618', '619', '620', '621', '622', '623', '624', '625', '626', '627', '628', '634', '638', '639', '641', '643', '644', '645', '646', '647', '255', '876', '878', '879', '881', '882', '883', '884', '378', '311', '893', '894', '896', '897', '898', '899', '900', '1018', '1019', '1068', '895', '1055', '1070', '1067', '1066', '1065', '1069', '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')
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
