No valid database connection Got error 28 from storage engine SQL=SELECT g1.id, g1.name, COUNT(g2.name) AS level FROM jos_core_acl_aro_groups AS g1 INNER JOIN jos_core_acl_aro_groups AS g2 ON g1.lft BETWEEN g2.lft AND g2.rgt WHERE g1.lft BETWEEN 13 AND 20 GROUP BY g1.name ORDER BY g1.lft
No valid database connection Got error 28 from storage engine SQL=SELECT COUNT(DISTINCT `jos_vm_product`.`product_sku`) as num_rows FROM (`jos_vm_product`, `jos_vm_category`,`jos_vm_category_xref`, `jos_vm_product_category_xref`,`jos_vm_shopper_group`) LEFT JOIN `jos_vm_product_price` ON `jos_vm_product`.`product_id` = `jos_vm_product_price`.`product_id` LEFT JOIN ( SELECT `reference_field` , `reference_id` , `value` FROM `jos_jf_content` WHERE `reference_table` = 'vm_product' AND `published` = 1 ) AS trad ON `jos_vm_product`.`product_id` = `trad`.`reference_id`
WHERE `jos_vm_product_category_xref`.`category_id`=`jos_vm_category`.`category_id`
AND (`jos_vm_product_category_xref`.`category_id`='24' OR (`jos_vm_category_xref`.`category_parent_id`='24' AND `jos_vm_category_xref`.`category_child_id`= `jos_vm_product_category_xref`.`category_id` ) )
AND `jos_vm_product`.`product_id`=`jos_vm_product_category_xref`.`product_id`
AND `jos_vm_product`.`product_parent_id`='0'
AND `product_publish`='Y'
AND ((
`jos_vm_shopper_group`.`shopper_group_id`=`jos_vm_product_price`.`shopper_group_id`
) OR (`jos_vm_product_price`.`product_id` IS NULL))
No valid database connection Got error 28 from storage engine SQL=SELECT DISTINCT `product_name`,`products_per_row`,`category_browsepage`,`category_flypage`,`jos_vm_product`.`product_id`,`jos_vm_category`.`category_id`,`product_full_image`,`product_thumb_image`,`product_s_desc`,`product_parent_id`,`product_publish`,`product_in_stock`,`product_sku` FROM (`jos_vm_product`, `jos_vm_category`, `jos_vm_product_category_xref`,`jos_vm_category_xref`,`jos_vm_shopper_group`) LEFT JOIN `jos_vm_product_price` ON `jos_vm_product`.`product_id` = `jos_vm_product_price`.`product_id` LEFT JOIN ( SELECT `reference_field` , `reference_id` , `value` FROM `jos_jf_content` WHERE `reference_table` = 'vm_product' AND `published` = 1 ) AS trad ON `jos_vm_product`.`product_id` = `trad`.`reference_id` WHERE `jos_vm_product_category_xref`.`category_id`=`jos_vm_category`.`category_id` AND (`jos_vm_product_category_xref`.`category_id`='24' OR (`jos_vm_category_xref`.`category_parent_id`='24' AND `jos_vm_category_xref`.`category_child_id`= `jos_vm_product_category_xref`.`category_id` ) ) AND `jos_vm_product`.`product_id`=`jos_vm_product_category_xref`.`product_id` AND `jos_vm_product`.`product_parent_id`='0' AND `product_publish`='Y' AND (( `jos_vm_shopper_group`.`shopper_group_id`=`jos_vm_product_price`.`shopper_group_id` ) OR (`jos_vm_product_price`.`product_id` IS NULL)) GROUP BY `jos_vm_product`.`product_sku` ORDER BY `jos_vm_product`.`product_name` LIMIT 0, 20
No valid database connection Got error 28 from storage engine SQL=SELECT DISTINCT `product_name`,`products_per_row`,`category_browsepage`,`category_flypage`,`jos_vm_product`.`product_id`,`jos_vm_category`.`category_id`,`product_full_image`,`product_thumb_image`,`product_s_desc`,`product_parent_id`,`product_publish`,`product_in_stock`,`product_sku` FROM (`jos_vm_product`, `jos_vm_category`, `jos_vm_product_category_xref`,`jos_vm_category_xref`,`jos_vm_shopper_group`) LEFT JOIN `jos_vm_product_price` ON `jos_vm_product`.`product_id` = `jos_vm_product_price`.`product_id` LEFT JOIN ( SELECT `reference_field` , `reference_id` , `value` FROM `jos_jf_content` WHERE `reference_table` = 'vm_product' AND `published` = 1 ) AS trad ON `jos_vm_product`.`product_id` = `trad`.`reference_id` WHERE `jos_vm_product_category_xref`.`category_id`=`jos_vm_category`.`category_id` AND (`jos_vm_product_category_xref`.`category_id`='24' OR (`jos_vm_category_xref`.`category_parent_id`='24' AND `jos_vm_category_xref`.`category_child_id`= `jos_vm_product_category_xref`.`category_id` ) ) AND `jos_vm_product`.`product_id`=`jos_vm_product_category_xref`.`product_id` AND `jos_vm_product`.`product_parent_id`='0' AND `product_publish`='Y' AND (( `jos_vm_shopper_group`.`shopper_group_id`=`jos_vm_product_price`.`shopper_group_id` ) OR (`jos_vm_product_price`.`product_id` IS NULL)) GROUP BY `jos_vm_product`.`product_sku` ORDER BY `jos_vm_product`.`product_name` LIMIT 0, 20
No valid database connection Got error 28 from storage engine SQL=SELECT category_id, category_description, category_name,category_child_id as cid, category_parent_id as pid,list_order, category_publish
FROM jos_vm_category, jos_vm_category_xref WHERE jos_vm_category.category_publish='Y' AND jos_vm_category.category_id=jos_vm_category_xref.category_child_id ORDER BY jos_vm_category.list_order ASC, jos_vm_category.category_name ASC
List All Products |