Maritimes
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', '226', '233', '234', '238', '254', '255', '256', '257', '258', '259', '273', '306', '312', '364', '365', '369', '370', '373', '374', '375', '376', '377', '379', '380', '382', '383', '384', '387', '388', '391', '392', '393', '394', '395', '396', '397', '398', '399', '400', '401', '402', '403', '404', '406', '407', '408', '409', '410', '411', '413', '414', '416', '417', '422', '439', '441', '442', '443', '444', '445', '446', '447', '454', '457', '458', '459', '460', '461', '471', '472', '474', '481', '482', '483', '487', '489', '490', '491', '492', '493', '494', '496', '497', '498', '501', '502', '503', '504', '506', '507', '508', '509', '510', '511', '522', '523', '524', '525', '526', '527', '528', '529', '530', '531', '532', '533', '534', '535', '536', '537', '538', '539', '540', '541', '542', '543', '544', '545', '546', '547', '816', '842', '844', '848', '878', '881', '890', '891', '895', '897', '898', '903', '904', '905', '909', '910', '921', '923', '924', '926', '927', '935', '936', '943', '944', '954', '971', '1018', '1019', '980', '977', '21', '974', '973', '22', '985', '986', '984', '982', '981', '983')
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