Fresh Products

product_list

Prairies

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 ('226', '227', '228', '229', '230', '232', '233', '234', '235', '236', '237', '238', '239', '240', '241', '242', '243', '244', '245', '246', '247', '248', '250', '251', '254', '255', '256', '257', '260', '261', '262', '263', '269', '272', '273', '274', '275', '276', '282', '283', '284', '285', '286', '287', '289', '290', '291', '292', '293', '294', '295', '296', '297', '298', '299', '300', '301', '302', '304', '305', '306', '307', '308', '309', '310', '311', '312', '313', '315', '319', '320', '321', '322', '323', '324', '654', '668', '669', '670', '677', '678', '680', '681', '682', '683', '684', '685', '686', '687', '688', '689', '690', '691', '692', '693', '694', '695', '696', '697', '698', '699', '700', '701', '702', '703', '704', '705', '706', '707', '708', '709', '710', '711', '712', '713', '714', '715', '716', '717', '718', '719', '720', '721', '722', '723', '724', '725', '726', '727', '728', '729', '730', '731', '732', '733', '734', '735', '736', '737', '738', '739', '740', '741', '742', '743', '744', '745', '746', '747', '748', '749', '750', '751', '752', '753', '754', '755', '756', '757', '758', '759', '760', '761', '762', '763', '764', '765', '766', '767', '768', '769', '770', '771', '772', '773', '774', '775', '776', '777', '778', '779', '780', '781', '782', '783', '784', '785', '788', '789', '790', '805', '806', '808', '816', '818', '819', '837', '842', '844', '858', '859', '878', '881', '882', '883', '890', '891', '895', '897', '898', '899', '961', '1016', '1017', '1018', '1019', '1060', '363', '513', '362', '585', '586', '361', '360') 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