SELECT * 
  FROM jos_session 
  WHERE session_id = 'p6nd6sot5i6ddb1q2ojqsaqpc6'
DELETE 
  FROM jos_session 
  WHERE ( TIME < '1762230170' )
SELECT * 
  FROM jos_session 
  WHERE session_id = 'p6nd6sot5i6ddb1q2ojqsaqpc6'
INSERT INTO `jos_session` ( `session_id`,`time`,`username`,`gid`,`guest`,`client_id` ) 
  VALUES ( 'p6nd6sot5i6ddb1q2ojqsaqpc6','1762230770','','0','1','0' )
SELECT * 
  FROM jos_components 
  WHERE parent = 0
SELECT folder AS TYPE, element AS name, params 
  FROM jos_plugins 
  WHERE published >= 1 
  AND access <= 0 
  ORDER BY ordering
SELECT `enabled` 
  FROM `jos_components` 
  WHERE `link` = "option=com_akeeba"
SELECT m.*, c.`option` AS component 
  FROM jos_menu AS m 
  LEFT JOIN jos_components AS c 
  ON m.componentid = c.id 
  WHERE m.published = 1 
  ORDER BY m.sublevel, m.parent, m.ordering
SELECT template 
  FROM jos_templates_menu 
  WHERE client_id = 0 
  AND (menuid = 0 OR menuid = 68) 
  ORDER BY menuid DESC 
  LIMIT 0, 1
SELECT a.id, a.title, a.alias, a.title_alias, a.introtext, a.fulltext, a.sectionid, a.state, a.catid, a.created, a.created_by, a.created_by_alias, a.modified, a.modified_by, a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.images, a.attribs, a.urls, a.metakey, a.metadesc, a.access, CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(':', a.id, a.alias) ELSE a.id END AS slug, CASE WHEN CHAR_LENGTH(cc.alias) THEN CONCAT_WS(":", cc.id, cc.alias) ELSE cc.id END AS catslug, CHAR_LENGTH( a.`fulltext` ) AS readmore, u.name AS author, u.usertype, g.name AS groups, u.email AS author_email, cc.title AS category, s.title AS SECTION, s.ordering AS s_ordering, cc.ordering AS cc_ordering, a.ordering AS a_ordering, f.ordering AS f_ordering 
  FROM jos_content AS a 
  INNER JOIN jos_content_frontpage AS f 
  ON f.content_id = a.id 
  LEFT JOIN jos_categories AS cc 
  ON cc.id = a.catid 
  LEFT JOIN jos_sections AS s 
  ON s.id = a.sectionid 
  LEFT JOIN jos_users AS u 
  ON u.id = a.created_by 
  LEFT JOIN jos_groups AS g 
  ON a.access = g.id 
  WHERE 1 
  AND a.access <= 0 
  AND a.state = 1 
  AND (( cc.published = 1 
  AND s.published = 1 ) OR ( a.catid = 0 
  AND a.sectionid = 0 ) ) 
  AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2025-11-04 04:32:50' ) 
  AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2025-11-04 04:32:50' ) 
  ORDER BY  a.ordering 
  LIMIT 0, 5
SELECT a.id, a.title, a.alias, a.title_alias, a.introtext, a.fulltext, a.sectionid, a.state, a.catid, a.created, a.created_by, a.created_by_alias, a.modified, a.modified_by, a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.images, a.attribs, a.urls, a.metakey, a.metadesc, a.access, CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(':', a.id, a.alias) ELSE a.id END AS slug, CASE WHEN CHAR_LENGTH(cc.alias) THEN CONCAT_WS(":", cc.id, cc.alias) ELSE cc.id END AS catslug, CHAR_LENGTH( a.`fulltext` ) AS readmore, u.name AS author, u.usertype, g.name AS groups, u.email AS author_email, cc.title AS category, s.title AS SECTION, s.ordering AS s_ordering, cc.ordering AS cc_ordering, a.ordering AS a_ordering, f.ordering AS f_ordering 
  FROM jos_content AS a 
  INNER JOIN jos_content_frontpage AS f 
  ON f.content_id = a.id 
  LEFT JOIN jos_categories AS cc 
  ON cc.id = a.catid 
  LEFT JOIN jos_sections AS s 
  ON s.id = a.sectionid 
  LEFT JOIN jos_users AS u 
  ON u.id = a.created_by 
  LEFT JOIN jos_groups AS g 
  ON a.access = g.id 
  WHERE 1 
  AND a.access <= 0 
  AND a.state = 1 
  AND (( cc.published = 1 
  AND s.published = 1 ) OR ( a.catid = 0 
  AND a.sectionid = 0 ) ) 
  AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2025-11-04 04:32:50' ) 
  AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2025-11-04 04:32:50' ) 
  ORDER BY  a.ordering
SELECT group_id,group_name,group_level 
  FROM `jos_vm_auth_group` 
  ORDER BY group_level
SELECT jos_vm_shopper_group.shopper_group_id, show_price_including_tax, `default`, shopper_group_discount 
                
  FROM `jos_vm_shopper_group` 
  WHERE jos_vm_shopper_group.vendor_id='1' 
  AND `default`='1'
SELECT `name` 
  FROM `jos_core_acl_aro_groups` 
  WHERE `id` =29
SELECT `lft`, `rgt` 
  FROM `jos_core_acl_aro_groups` 
  WHERE `name`='Public Frontend'
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 3 
  AND 12
  GROUP BY g1.name
  ORDER BY g1.lft
SELECT `lft`, `rgt` 
  FROM `jos_core_acl_aro_groups` 
  WHERE `name`='Public Backend'
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
SELECT vendor_id, vendor_min_pov,vendor_name,vendor_store_name,contact_email,vendor_full_image, vendor_freeshipping,
                                        vendor_address_1,vendor_address_2, vendor_url, vendor_city, vendor_state, vendor_country, country_2_code, country_3_code,
                                        vendor_zip, vendor_phone, vendor_store_desc, vendor_currency, vendor_currency_display_style,
                                        vendor_accepted_currencies, vendor_address_format, vendor_date_format, state_name
                                
  FROM (`jos_vm_vendor` v, `jos_vm_country` c)
                                
  LEFT JOIN jos_vm_state s 
  ON (v.vendor_state=s.state_2_code 
  AND s.country_id=c.country_id)
                                
  WHERE `v`.`vendor_id`=1
                                
  AND (`v`.`vendor_country`=`c`.`country_2_code` OR `v`.`vendor_country`=`c`.`country_3_code`);
SELECT id, title, module, POSITION, content, showtitle, control, params 
  FROM jos_modules AS m 
  LEFT JOIN jos_modules_menu AS mm 
  ON mm.moduleid = m.id 
  WHERE m.published = 1 
  AND m.access <= 0 
  AND m.client_id = 0 
  AND ( mm.menuid = 68 OR mm.menuid = 0 ) 
  ORDER BY POSITION, ordering
SELECT category_name, category_id, category_child_id 
  FROM jos_vm_category AS a, jos_vm_category_xref AS b 
  WHERE a.category_publish='Y' 
  AND  b.category_parent_id='0' 
  AND a.category_id=b.category_child_id 
  ORDER BY category_parent_id, list_order, category_name ASC
SELECT id 
  FROM jos_menu 
  WHERE link='index.php?option=com_virtuemart' 
  AND published=1
SELECT category_child_id 
  FROM jos_vm_category_xref 
  WHERE category_parent_id='6'
SELECT category_name, category_id, category_child_id 
  FROM jos_vm_category AS a, jos_vm_category_xref AS b 
  WHERE a.category_publish='Y' 
  AND  b.category_parent_id='6' 
  AND a.category_id=b.category_child_id 
  ORDER BY category_parent_id, list_order, category_name ASC
SELECT category_child_id 
  FROM jos_vm_category_xref 
  WHERE category_parent_id='24'
SELECT category_child_id 
  FROM jos_vm_category_xref 
  WHERE category_parent_id='25'
SELECT category_child_id 
  FROM jos_vm_category_xref 
  WHERE category_parent_id='8'
SELECT category_child_id 
  FROM jos_vm_category_xref 
  WHERE category_parent_id='9'
SELECT category_child_id 
  FROM jos_vm_category_xref 
  WHERE category_parent_id='10'
SELECT category_child_id 
  FROM jos_vm_category_xref 
  WHERE category_parent_id='11'
SELECT category_child_id 
  FROM jos_vm_category_xref 
  WHERE category_parent_id='12'
SELECT category_child_id 
  FROM jos_vm_category_xref 
  WHERE category_parent_id='13'
SELECT category_child_id 
  FROM jos_vm_category_xref 
  WHERE category_parent_id='14'
SELECT category_child_id 
  FROM jos_vm_category_xref 
  WHERE category_parent_id='15'
SELECT category_child_id 
  FROM jos_vm_category_xref 
  WHERE category_parent_id='16'
SELECT category_child_id 
  FROM jos_vm_category_xref 
  WHERE category_parent_id='17'
SELECT category_child_id 
  FROM jos_vm_category_xref 
  WHERE category_parent_id='22'
SELECT category_child_id 
  FROM jos_vm_category_xref 
  WHERE category_parent_id='23'
SELECT category_child_id 
  FROM jos_vm_category_xref 
  WHERE category_parent_id='26'
SELECT category_child_id 
  FROM jos_vm_category_xref 
  WHERE category_parent_id='18'
SELECT category_child_id 
  FROM jos_vm_category_xref 
  WHERE category_parent_id='19'
SELECT category_child_id 
  FROM jos_vm_category_xref 
  WHERE category_parent_id='20'
SELECT a.category_child_id AS id,a.category_parent_id AS parent, b.category_name AS name 
  FROM jos_vm_category_xref AS a, jos_vm_category AS b 
  WHERE b.category_publish = 'Y' 
  AND b.category_id = a.category_child_id 
  ORDER BY b.list_order, b.category_name
SELECT id, params 
  FROM jos_menu 
  WHERE link='index.php?option=com_virtuemart' 
  AND published=1
SELECT a.*, CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(":", a.id, a.alias) ELSE a.id END AS slug, CASE WHEN CHAR_LENGTH(cc.name) THEN CONCAT_WS(":", cc.id, cc.name) ELSE cc.id END AS catslug 
  FROM jos_content AS a 
  INNER JOIN jos_categories AS cc 
  ON cc.id = a.catid 
  INNER JOIN jos_sections AS s 
  ON s.id = a.sectionid 
  WHERE a.state = 1  
  AND a.access <= 0 
  AND cc.access <= 0 
  AND s.access <= 0 
  AND (a.publish_up = "0000-00-00 00:00:00" OR a.publish_up <= "2025-11-04 04:32:50" )  
  AND (a.publish_down = "0000-00-00 00:00:00" OR a.publish_down >= "2025-11-04 04:32:50" ) 
  AND cc.id = 102 
  AND cc.SECTION = s.id 
  AND cc.published = 1 
  AND s.published = 1 
  ORDER BY a.ordering
SELECT DISTINCT product_sku 
  FROM jos_vm_product, jos_vm_product_category_xref, jos_vm_category 
  WHERE product_parent_id=''
  AND jos_vm_product.product_id=jos_vm_product_category_xref.product_id 
  AND jos_vm_category.category_id=jos_vm_product_category_xref.category_id 
  AND jos_vm_product.product_publish='Y' 
  ORDER BY jos_vm_product.product_id DESC 
  LIMIT 0, 12
SELECT product_id, product_name, product_parent_id, product_thumb_image 
  FROM jos_vm_product 
  WHERE product_sku='PN0094'
SELECT category_id 
  FROM `jos_vm_product_category_xref` 
  WHERE product_id=111
SELECT
                                `jos_vm_product`.`product_parent_id` AS product_parent_id,
                                `jos_vm_category`.`category_flypage`
                        
  FROM
                                `jos_vm_product`
                        
  LEFT JOIN `jos_vm_product_category_xref` 
  ON `jos_vm_product_category_xref`.`product_id` = `jos_vm_product`.`product_id`
                        
  LEFT JOIN `jos_vm_category` 
  ON `jos_vm_product_category_xref`.`category_id` = `jos_vm_category`.`category_id`
                        
  WHERE `jos_vm_product`.`product_id`='111'
SELECT product_id, product_name, product_parent_id, product_thumb_image 
  FROM jos_vm_product 
  WHERE product_sku='PN0121'
SELECT category_id 
  FROM `jos_vm_product_category_xref` 
  WHERE product_id=110
SELECT
                                `jos_vm_product`.`product_parent_id` AS product_parent_id,
                                `jos_vm_category`.`category_flypage`
                        
  FROM
                                `jos_vm_product`
                        
  LEFT JOIN `jos_vm_product_category_xref` 
  ON `jos_vm_product_category_xref`.`product_id` = `jos_vm_product`.`product_id`
                        
  LEFT JOIN `jos_vm_category` 
  ON `jos_vm_product_category_xref`.`category_id` = `jos_vm_category`.`category_id`
                        
  WHERE `jos_vm_product`.`product_id`='110'
SELECT product_id, product_name, product_parent_id, product_thumb_image 
  FROM jos_vm_product 
  WHERE product_sku='PN0047'
SELECT category_id 
  FROM `jos_vm_product_category_xref` 
  WHERE product_id=109
SELECT
                                `jos_vm_product`.`product_parent_id` AS product_parent_id,
                                `jos_vm_category`.`category_flypage`
                        
  FROM
                                `jos_vm_product`
                        
  LEFT JOIN `jos_vm_product_category_xref` 
  ON `jos_vm_product_category_xref`.`product_id` = `jos_vm_product`.`product_id`
                        
  LEFT JOIN `jos_vm_category` 
  ON `jos_vm_product_category_xref`.`category_id` = `jos_vm_category`.`category_id`
                        
  WHERE `jos_vm_product`.`product_id`='109'
SELECT product_id, product_name, product_parent_id, product_thumb_image 
  FROM jos_vm_product 
  WHERE product_sku='FL0340'
SELECT category_id 
  FROM `jos_vm_product_category_xref` 
  WHERE product_id=108
SELECT
                                `jos_vm_product`.`product_parent_id` AS product_parent_id,
                                `jos_vm_category`.`category_flypage`
                        
  FROM
                                `jos_vm_product`
                        
  LEFT JOIN `jos_vm_product_category_xref` 
  ON `jos_vm_product_category_xref`.`product_id` = `jos_vm_product`.`product_id`
                        
  LEFT JOIN `jos_vm_category` 
  ON `jos_vm_product_category_xref`.`category_id` = `jos_vm_category`.`category_id`
                        
  WHERE `jos_vm_product`.`product_id`='108'
SELECT product_id, product_name, product_parent_id, product_thumb_image 
  FROM jos_vm_product 
  WHERE product_sku='FL0373'
SELECT category_id 
  FROM `jos_vm_product_category_xref` 
  WHERE product_id=107
SELECT
                                `jos_vm_product`.`product_parent_id` AS product_parent_id,
                                `jos_vm_category`.`category_flypage`
                        
  FROM
                                `jos_vm_product`
                        
  LEFT JOIN `jos_vm_product_category_xref` 
  ON `jos_vm_product_category_xref`.`product_id` = `jos_vm_product`.`product_id`
                        
  LEFT JOIN `jos_vm_category` 
  ON `jos_vm_product_category_xref`.`category_id` = `jos_vm_category`.`category_id`
                        
  WHERE `jos_vm_product`.`product_id`='107'
SELECT product_id, product_name, product_parent_id, product_thumb_image 
  FROM jos_vm_product 
  WHERE product_sku='FL0342'
SELECT category_id 
  FROM `jos_vm_product_category_xref` 
  WHERE product_id=106
SELECT
                                `jos_vm_product`.`product_parent_id` AS product_parent_id,
                                `jos_vm_category`.`category_flypage`
                        
  FROM
                                `jos_vm_product`
                        
  LEFT JOIN `jos_vm_product_category_xref` 
  ON `jos_vm_product_category_xref`.`product_id` = `jos_vm_product`.`product_id`
                        
  LEFT JOIN `jos_vm_category` 
  ON `jos_vm_product_category_xref`.`category_id` = `jos_vm_category`.`category_id`
                        
  WHERE `jos_vm_product`.`product_id`='106'
SELECT product_id, product_name, product_parent_id, product_thumb_image 
  FROM jos_vm_product 
  WHERE product_sku='FL0349'
SELECT category_id 
  FROM `jos_vm_product_category_xref` 
  WHERE product_id=105
SELECT
                                `jos_vm_product`.`product_parent_id` AS product_parent_id,
                                `jos_vm_category`.`category_flypage`
                        
  FROM
                                `jos_vm_product`
                        
  LEFT JOIN `jos_vm_product_category_xref` 
  ON `jos_vm_product_category_xref`.`product_id` = `jos_vm_product`.`product_id`
                        
  LEFT JOIN `jos_vm_category` 
  ON `jos_vm_product_category_xref`.`category_id` = `jos_vm_category`.`category_id`
                        
  WHERE `jos_vm_product`.`product_id`='105'
SELECT product_id, product_name, product_parent_id, product_thumb_image 
  FROM jos_vm_product 
  WHERE product_sku='MD0194'
SELECT category_id 
  FROM `jos_vm_product_category_xref` 
  WHERE product_id=104
SELECT
                                `jos_vm_product`.`product_parent_id` AS product_parent_id,
                                `jos_vm_category`.`category_flypage`
                        
  FROM
                                `jos_vm_product`
                        
  LEFT JOIN `jos_vm_product_category_xref` 
  ON `jos_vm_product_category_xref`.`product_id` = `jos_vm_product`.`product_id`
                        
  LEFT JOIN `jos_vm_category` 
  ON `jos_vm_product_category_xref`.`category_id` = `jos_vm_category`.`category_id`
                        
  WHERE `jos_vm_product`.`product_id`='104'
SELECT product_id, product_name, product_parent_id, product_thumb_image 
  FROM jos_vm_product 
  WHERE product_sku='MP1103'
SELECT category_id 
  FROM `jos_vm_product_category_xref` 
  WHERE product_id=103
SELECT
                                `jos_vm_product`.`product_parent_id` AS product_parent_id,
                                `jos_vm_category`.`category_flypage`
                        
  FROM
                                `jos_vm_product`
                        
  LEFT JOIN `jos_vm_product_category_xref` 
  ON `jos_vm_product_category_xref`.`product_id` = `jos_vm_product`.`product_id`
                        
  LEFT JOIN `jos_vm_category` 
  ON `jos_vm_product_category_xref`.`category_id` = `jos_vm_category`.`category_id`
                        
  WHERE `jos_vm_product`.`product_id`='103'
SELECT product_id, product_name, product_parent_id, product_thumb_image 
  FROM jos_vm_product 
  WHERE product_sku='MP0948'
SELECT category_id 
  FROM `jos_vm_product_category_xref` 
  WHERE product_id=102
SELECT
                                `jos_vm_product`.`product_parent_id` AS product_parent_id,
                                `jos_vm_category`.`category_flypage`
                        
  FROM
                                `jos_vm_product`
                        
  LEFT JOIN `jos_vm_product_category_xref` 
  ON `jos_vm_product_category_xref`.`product_id` = `jos_vm_product`.`product_id`
                        
  LEFT JOIN `jos_vm_category` 
  ON `jos_vm_product_category_xref`.`category_id` = `jos_vm_category`.`category_id`
                        
  WHERE `jos_vm_product`.`product_id`='102'
SELECT product_id, product_name, product_parent_id, product_thumb_image 
  FROM jos_vm_product 
  WHERE product_sku='DP0156'
SELECT category_id 
  FROM `jos_vm_product_category_xref` 
  WHERE product_id=101
SELECT
                                `jos_vm_product`.`product_parent_id` AS product_parent_id,
                                `jos_vm_category`.`category_flypage`
                        
  FROM
                                `jos_vm_product`
                        
  LEFT JOIN `jos_vm_product_category_xref` 
  ON `jos_vm_product_category_xref`.`product_id` = `jos_vm_product`.`product_id`
                        
  LEFT JOIN `jos_vm_category` 
  ON `jos_vm_product_category_xref`.`category_id` = `jos_vm_category`.`category_id`
                        
  WHERE `jos_vm_product`.`product_id`='101'
SELECT product_id, product_name, product_parent_id, product_thumb_image 
  FROM jos_vm_product 
  WHERE product_sku='DP0131'
SELECT category_id 
  FROM `jos_vm_product_category_xref` 
  WHERE product_id=100
SELECT
                                `jos_vm_product`.`product_parent_id` AS product_parent_id,
                                `jos_vm_category`.`category_flypage`
                        
  FROM
                                `jos_vm_product`
                        
  LEFT JOIN `jos_vm_product_category_xref` 
  ON `jos_vm_product_category_xref`.`product_id` = `jos_vm_product`.`product_id`
                        
  LEFT JOIN `jos_vm_category` 
  ON `jos_vm_product_category_xref`.`category_id` = `jos_vm_category`.`category_id`
                        
  WHERE `jos_vm_product`.`product_id`='100'
SELECT a.*, CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(":", a.id, a.alias) ELSE a.id END AS slug, CASE WHEN CHAR_LENGTH(cc.name) THEN CONCAT_WS(":", cc.id, cc.name) ELSE cc.id END AS catslug 
  FROM jos_content AS a 
  INNER JOIN jos_categories AS cc 
  ON cc.id = a.catid 
  INNER JOIN jos_sections AS s 
  ON s.id = a.sectionid 
  WHERE a.state = 1  
  AND a.access <= 0 
  AND cc.access <= 0 
  AND s.access <= 0 
  AND (a.publish_up = "0000-00-00 00:00:00" OR a.publish_up <= "2025-11-04 04:32:50" )  
  AND (a.publish_down = "0000-00-00 00:00:00" OR a.publish_down >= "2025-11-04 04:32:50" ) 
  AND cc.id = 102 
  AND cc.SECTION = s.id 
  AND cc.published = 1 
  AND s.published = 1 
  ORDER BY a.ordering
SELECT DISTINCT product_sku 
  FROM jos_vm_product 
  WHERE (jos_vm_product.product_parent_id='' OR jos_vm_product.product_parent_id='0') 
  AND vendor_id='1' 
  AND jos_vm_product.product_publish='Y' 
  AND jos_vm_product.product_special='Y' 
  ORDER BY RAND() 
  LIMIT 0, 12
SELECT product_id, product_name, product_parent_id, product_thumb_image 
  FROM jos_vm_product 
  WHERE product_sku='SP0268'
SELECT category_id 
  FROM `jos_vm_product_category_xref` 
  WHERE product_id=98
SELECT
                                `jos_vm_product`.`product_parent_id` AS product_parent_id,
                                `jos_vm_category`.`category_flypage`
                        
  FROM
                                `jos_vm_product`
                        
  LEFT JOIN `jos_vm_product_category_xref` 
  ON `jos_vm_product_category_xref`.`product_id` = `jos_vm_product`.`product_id`
                        
  LEFT JOIN `jos_vm_category` 
  ON `jos_vm_product_category_xref`.`category_id` = `jos_vm_category`.`category_id`
                        
  WHERE `jos_vm_product`.`product_id`='98'
SELECT product_id, product_name, product_parent_id, product_thumb_image 
  FROM jos_vm_product 
  WHERE product_sku='PN0121'
SELECT category_id 
  FROM `jos_vm_product_category_xref` 
  WHERE product_id=110
SELECT product_id, product_name, product_parent_id, product_thumb_image 
  FROM jos_vm_product 
  WHERE product_sku='FP1229'
SELECT category_id 
  FROM `jos_vm_product_category_xref` 
  WHERE product_id=49
SELECT
                                `jos_vm_product`.`product_parent_id` AS product_parent_id,
                                `jos_vm_category`.`category_flypage`
                        
  FROM
                                `jos_vm_product`
                        
  LEFT JOIN `jos_vm_product_category_xref` 
  ON `jos_vm_product_category_xref`.`product_id` = `jos_vm_product`.`product_id`
                        
  LEFT JOIN `jos_vm_category` 
  ON `jos_vm_product_category_xref`.`category_id` = `jos_vm_category`.`category_id`
                        
  WHERE `jos_vm_product`.`product_id`='49'
SELECT product_id, product_name, product_parent_id, product_thumb_image 
  FROM jos_vm_product 
  WHERE product_sku='GN0500'
SELECT category_id 
  FROM `jos_vm_product_category_xref` 
  WHERE product_id=92
SELECT
                                `jos_vm_product`.`product_parent_id` AS product_parent_id,
                                `jos_vm_category`.`category_flypage`
                        
  FROM
                                `jos_vm_product`
                        
  LEFT JOIN `jos_vm_product_category_xref` 
  ON `jos_vm_product_category_xref`.`product_id` = `jos_vm_product`.`product_id`
                        
  LEFT JOIN `jos_vm_category` 
  ON `jos_vm_product_category_xref`.`category_id` = `jos_vm_category`.`category_id`
                        
  WHERE `jos_vm_product`.`product_id`='92'
SELECT product_id, product_name, product_parent_id, product_thumb_image 
  FROM jos_vm_product 
  WHERE product_sku='LP1269'
SELECT category_id 
  FROM `jos_vm_product_category_xref` 
  WHERE product_id=67
SELECT
                                `jos_vm_product`.`product_parent_id` AS product_parent_id,
                                `jos_vm_category`.`category_flypage`
                        
  FROM
                                `jos_vm_product`
                        
  LEFT JOIN `jos_vm_product_category_xref` 
  ON `jos_vm_product_category_xref`.`product_id` = `jos_vm_product`.`product_id`
                        
  LEFT JOIN `jos_vm_category` 
  ON `jos_vm_product_category_xref`.`category_id` = `jos_vm_category`.`category_id`
                        
  WHERE `jos_vm_product`.`product_id`='67'
SELECT product_id, product_name, product_parent_id, product_thumb_image 
  FROM jos_vm_product 
  WHERE product_sku='PH0291'
SELECT category_id 
  FROM `jos_vm_product_category_xref` 
  WHERE product_id=89
SELECT
                                `jos_vm_product`.`product_parent_id` AS product_parent_id,
                                `jos_vm_category`.`category_flypage`
                        
  FROM
                                `jos_vm_product`
                        
  LEFT JOIN `jos_vm_product_category_xref` 
  ON `jos_vm_product_category_xref`.`product_id` = `jos_vm_product`.`product_id`
                        
  LEFT JOIN `jos_vm_category` 
  ON `jos_vm_product_category_xref`.`category_id` = `jos_vm_category`.`category_id`
                        
  WHERE `jos_vm_product`.`product_id`='89'
SELECT product_id, product_name, product_parent_id, product_thumb_image 
  FROM jos_vm_product 
  WHERE product_sku='GN0453'
SELECT category_id 
  FROM `jos_vm_product_category_xref` 
  WHERE product_id=96
SELECT
                                `jos_vm_product`.`product_parent_id` AS product_parent_id,
                                `jos_vm_category`.`category_flypage`
                        
  FROM
                                `jos_vm_product`
                        
  LEFT JOIN `jos_vm_product_category_xref` 
  ON `jos_vm_product_category_xref`.`product_id` = `jos_vm_product`.`product_id`
                        
  LEFT JOIN `jos_vm_category` 
  ON `jos_vm_product_category_xref`.`category_id` = `jos_vm_category`.`category_id`
                        
  WHERE `jos_vm_product`.`product_id`='96'
SELECT product_id, product_name, product_parent_id, product_thumb_image 
  FROM jos_vm_product 
  WHERE product_sku='FP2144'
SELECT category_id 
  FROM `jos_vm_product_category_xref` 
  WHERE product_id=46
SELECT
                                `jos_vm_product`.`product_parent_id` AS product_parent_id,
                                `jos_vm_category`.`category_flypage`
                        
  FROM
                                `jos_vm_product`
                        
  LEFT JOIN `jos_vm_product_category_xref` 
  ON `jos_vm_product_category_xref`.`product_id` = `jos_vm_product`.`product_id`
                        
  LEFT JOIN `jos_vm_category` 
  ON `jos_vm_product_category_xref`.`category_id` = `jos_vm_category`.`category_id`
                        
  WHERE `jos_vm_product`.`product_id`='46'
SELECT product_id, product_name, product_parent_id, product_thumb_image 
  FROM jos_vm_product 
  WHERE product_sku='LN0058'
SELECT category_id 
  FROM `jos_vm_product_category_xref` 
  WHERE product_id=35
SELECT
                                `jos_vm_product`.`product_parent_id` AS product_parent_id,
                                `jos_vm_category`.`category_flypage`
                        
  FROM
                                `jos_vm_product`
                        
  LEFT JOIN `jos_vm_product_category_xref` 
  ON `jos_vm_product_category_xref`.`product_id` = `jos_vm_product`.`product_id`
                        
  LEFT JOIN `jos_vm_category` 
  ON `jos_vm_product_category_xref`.`category_id` = `jos_vm_category`.`category_id`
                        
  WHERE `jos_vm_product`.`product_id`='35'
SELECT product_id, product_name, product_parent_id, product_thumb_image 
  FROM jos_vm_product 
  WHERE product_sku='FP1945'
SELECT category_id 
  FROM `jos_vm_product_category_xref` 
  WHERE product_id=84
SELECT
                                `jos_vm_product`.`product_parent_id` AS product_parent_id,
                                `jos_vm_category`.`category_flypage`
                        
  FROM
                                `jos_vm_product`
                        
  LEFT JOIN `jos_vm_product_category_xref` 
  ON `jos_vm_product_category_xref`.`product_id` = `jos_vm_product`.`product_id`
                        
  LEFT JOIN `jos_vm_category` 
  ON `jos_vm_product_category_xref`.`category_id` = `jos_vm_category`.`category_id`
                        
  WHERE `jos_vm_product`.`product_id`='84'
SELECT product_id, product_name, product_parent_id, product_thumb_image 
  FROM jos_vm_product 
  WHERE product_sku='LN0020'
SELECT category_id 
  FROM `jos_vm_product_category_xref` 
  WHERE product_id=29
SELECT
                                `jos_vm_product`.`product_parent_id` AS product_parent_id,
                                `jos_vm_category`.`category_flypage`
                        
  FROM
                                `jos_vm_product`
                        
  LEFT JOIN `jos_vm_product_category_xref` 
  ON `jos_vm_product_category_xref`.`product_id` = `jos_vm_product`.`product_id`
                        
  LEFT JOIN `jos_vm_category` 
  ON `jos_vm_product_category_xref`.`category_id` = `jos_vm_category`.`category_id`
                        
  WHERE `jos_vm_product`.`product_id`='29'
SELECT product_id, product_name, product_parent_id, product_thumb_image 
  FROM jos_vm_product 
  WHERE product_sku='GN0329'
SELECT category_id 
  FROM `jos_vm_product_category_xref` 
  WHERE product_id=90
SELECT
                                `jos_vm_product`.`product_parent_id` AS product_parent_id,
                                `jos_vm_category`.`category_flypage`
                        
  FROM
                                `jos_vm_product`
                        
  LEFT JOIN `jos_vm_product_category_xref` 
  ON `jos_vm_product_category_xref`.`product_id` = `jos_vm_product`.`product_id`
                        
  LEFT JOIN `jos_vm_category` 
  ON `jos_vm_product_category_xref`.`category_id` = `jos_vm_category`.`category_id`
                        
  WHERE `jos_vm_product`.`product_id`='90'
SELECT * 
  FROM jos_session 
  WHERE session_id = 'p6nd6sot5i6ddb1q2ojqsaqpc6'
DELETE 
  FROM jos_session 
  WHERE ( TIME < '1762230170' )
SELECT * 
  FROM jos_session 
  WHERE session_id = 'p6nd6sot5i6ddb1q2ojqsaqpc6'
INSERT INTO `jos_session` ( `session_id`,`time`,`username`,`gid`,`guest`,`client_id` ) 
  VALUES ( 'p6nd6sot5i6ddb1q2ojqsaqpc6','1762230770','','0','1','0' )
SELECT * 
  FROM jos_components 
  WHERE parent = 0
SELECT folder AS TYPE, element AS name, params 
  FROM jos_plugins 
  WHERE published >= 1 
  AND access <= 0 
  ORDER BY ordering
SELECT `enabled` 
  FROM `jos_components` 
  WHERE `link` = "option=com_akeeba"
SELECT m.*, c.`option` AS component 
  FROM jos_menu AS m 
  LEFT JOIN jos_components AS c 
  ON m.componentid = c.id 
  WHERE m.published = 1 
  ORDER BY m.sublevel, m.parent, m.ordering
SELECT template 
  FROM jos_templates_menu 
  WHERE client_id = 0 
  AND (menuid = 0 OR menuid = 68) 
  ORDER BY menuid DESC 
  LIMIT 0, 1
SELECT a.id, a.title, a.alias, a.title_alias, a.introtext, a.fulltext, a.sectionid, a.state, a.catid, a.created, a.created_by, a.created_by_alias, a.modified, a.modified_by, a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.images, a.attribs, a.urls, a.metakey, a.metadesc, a.access, CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(':', a.id, a.alias) ELSE a.id END AS slug, CASE WHEN CHAR_LENGTH(cc.alias) THEN CONCAT_WS(":", cc.id, cc.alias) ELSE cc.id END AS catslug, CHAR_LENGTH( a.`fulltext` ) AS readmore, u.name AS author, u.usertype, g.name AS groups, u.email AS author_email, cc.title AS category, s.title AS SECTION, s.ordering AS s_ordering, cc.ordering AS cc_ordering, a.ordering AS a_ordering, f.ordering AS f_ordering 
  FROM jos_content AS a 
  INNER JOIN jos_content_frontpage AS f 
  ON f.content_id = a.id 
  LEFT JOIN jos_categories AS cc 
  ON cc.id = a.catid 
  LEFT JOIN jos_sections AS s 
  ON s.id = a.sectionid 
  LEFT JOIN jos_users AS u 
  ON u.id = a.created_by 
  LEFT JOIN jos_groups AS g 
  ON a.access = g.id 
  WHERE 1 
  AND a.access <= 0 
  AND a.state = 1 
  AND (( cc.published = 1 
  AND s.published = 1 ) OR ( a.catid = 0 
  AND a.sectionid = 0 ) ) 
  AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2025-11-04 04:32:50' ) 
  AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2025-11-04 04:32:50' ) 
  ORDER BY  a.ordering 
  LIMIT 0, 5
SELECT a.id, a.title, a.alias, a.title_alias, a.introtext, a.fulltext, a.sectionid, a.state, a.catid, a.created, a.created_by, a.created_by_alias, a.modified, a.modified_by, a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.images, a.attribs, a.urls, a.metakey, a.metadesc, a.access, CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(':', a.id, a.alias) ELSE a.id END AS slug, CASE WHEN CHAR_LENGTH(cc.alias) THEN CONCAT_WS(":", cc.id, cc.alias) ELSE cc.id END AS catslug, CHAR_LENGTH( a.`fulltext` ) AS readmore, u.name AS author, u.usertype, g.name AS groups, u.email AS author_email, cc.title AS category, s.title AS SECTION, s.ordering AS s_ordering, cc.ordering AS cc_ordering, a.ordering AS a_ordering, f.ordering AS f_ordering 
  FROM jos_content AS a 
  INNER JOIN jos_content_frontpage AS f 
  ON f.content_id = a.id 
  LEFT JOIN jos_categories AS cc 
  ON cc.id = a.catid 
  LEFT JOIN jos_sections AS s 
  ON s.id = a.sectionid 
  LEFT JOIN jos_users AS u 
  ON u.id = a.created_by 
  LEFT JOIN jos_groups AS g 
  ON a.access = g.id 
  WHERE 1 
  AND a.access <= 0 
  AND a.state = 1 
  AND (( cc.published = 1 
  AND s.published = 1 ) OR ( a.catid = 0 
  AND a.sectionid = 0 ) ) 
  AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2025-11-04 04:32:50' ) 
  AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2025-11-04 04:32:50' ) 
  ORDER BY  a.ordering
SELECT group_id,group_name,group_level 
  FROM `jos_vm_auth_group` 
  ORDER BY group_level
SELECT jos_vm_shopper_group.shopper_group_id, show_price_including_tax, `default`, shopper_group_discount 
                
  FROM `jos_vm_shopper_group` 
  WHERE jos_vm_shopper_group.vendor_id='1' 
  AND `default`='1'
SELECT `name` 
  FROM `jos_core_acl_aro_groups` 
  WHERE `id` =29
SELECT `lft`, `rgt` 
  FROM `jos_core_acl_aro_groups` 
  WHERE `name`='Public Frontend'
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 3 
  AND 12
  GROUP BY g1.name
  ORDER BY g1.lft
SELECT `lft`, `rgt` 
  FROM `jos_core_acl_aro_groups` 
  WHERE `name`='Public Backend'
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
SELECT vendor_id, vendor_min_pov,vendor_name,vendor_store_name,contact_email,vendor_full_image, vendor_freeshipping,
                                        vendor_address_1,vendor_address_2, vendor_url, vendor_city, vendor_state, vendor_country, country_2_code, country_3_code,
                                        vendor_zip, vendor_phone, vendor_store_desc, vendor_currency, vendor_currency_display_style,
                                        vendor_accepted_currencies, vendor_address_format, vendor_date_format, state_name
                                
  FROM (`jos_vm_vendor` v, `jos_vm_country` c)
                                
  LEFT JOIN jos_vm_state s 
  ON (v.vendor_state=s.state_2_code 
  AND s.country_id=c.country_id)
                                
  WHERE `v`.`vendor_id`=1
                                
  AND (`v`.`vendor_country`=`c`.`country_2_code` OR `v`.`vendor_country`=`c`.`country_3_code`);
SELECT id, title, module, POSITION, content, showtitle, control, params 
  FROM jos_modules AS m 
  LEFT JOIN jos_modules_menu AS mm 
  ON mm.moduleid = m.id 
  WHERE m.published = 1 
  AND m.access <= 0 
  AND m.client_id = 0 
  AND ( mm.menuid = 68 OR mm.menuid = 0 ) 
  ORDER BY POSITION, ordering
SELECT category_name, category_id, category_child_id 
  FROM jos_vm_category AS a, jos_vm_category_xref AS b 
  WHERE a.category_publish='Y' 
  AND  b.category_parent_id='0' 
  AND a.category_id=b.category_child_id 
  ORDER BY category_parent_id, list_order, category_name ASC
SELECT id 
  FROM jos_menu 
  WHERE link='index.php?option=com_virtuemart' 
  AND published=1
SELECT category_child_id 
  FROM jos_vm_category_xref 
  WHERE category_parent_id='6'
SELECT category_name, category_id, category_child_id 
  FROM jos_vm_category AS a, jos_vm_category_xref AS b 
  WHERE a.category_publish='Y' 
  AND  b.category_parent_id='6' 
  AND a.category_id=b.category_child_id 
  ORDER BY category_parent_id, list_order, category_name ASC
SELECT category_child_id 
  FROM jos_vm_category_xref 
  WHERE category_parent_id='24'
SELECT category_child_id 
  FROM jos_vm_category_xref 
  WHERE category_parent_id='25'
SELECT category_child_id 
  FROM jos_vm_category_xref 
  WHERE category_parent_id='8'
SELECT category_child_id 
  FROM jos_vm_category_xref 
  WHERE category_parent_id='9'
SELECT category_child_id 
  FROM jos_vm_category_xref 
  WHERE category_parent_id='10'
SELECT category_child_id 
  FROM jos_vm_category_xref 
  WHERE category_parent_id='11'
SELECT category_child_id 
  FROM jos_vm_category_xref 
  WHERE category_parent_id='12'
SELECT category_child_id 
  FROM jos_vm_category_xref 
  WHERE category_parent_id='13'
SELECT category_child_id 
  FROM jos_vm_category_xref 
  WHERE category_parent_id='14'
SELECT category_child_id 
  FROM jos_vm_category_xref 
  WHERE category_parent_id='15'
SELECT category_child_id 
  FROM jos_vm_category_xref 
  WHERE category_parent_id='16'
SELECT category_child_id 
  FROM jos_vm_category_xref 
  WHERE category_parent_id='17'
SELECT category_child_id 
  FROM jos_vm_category_xref 
  WHERE category_parent_id='22'
SELECT category_child_id 
  FROM jos_vm_category_xref 
  WHERE category_parent_id='23'
SELECT category_child_id 
  FROM jos_vm_category_xref 
  WHERE category_parent_id='26'
SELECT category_child_id 
  FROM jos_vm_category_xref 
  WHERE category_parent_id='18'
SELECT category_child_id 
  FROM jos_vm_category_xref 
  WHERE category_parent_id='19'
SELECT category_child_id 
  FROM jos_vm_category_xref 
  WHERE category_parent_id='20'
SELECT a.category_child_id AS id,a.category_parent_id AS parent, b.category_name AS name 
  FROM jos_vm_category_xref AS a, jos_vm_category AS b 
  WHERE b.category_publish = 'Y' 
  AND b.category_id = a.category_child_id 
  ORDER BY b.list_order, b.category_name
SELECT id, params 
  FROM jos_menu 
  WHERE link='index.php?option=com_virtuemart' 
  AND published=1
SELECT a.*, CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(":", a.id, a.alias) ELSE a.id END AS slug, CASE WHEN CHAR_LENGTH(cc.name) THEN CONCAT_WS(":", cc.id, cc.name) ELSE cc.id END AS catslug 
  FROM jos_content AS a 
  INNER JOIN jos_categories AS cc 
  ON cc.id = a.catid 
  INNER JOIN jos_sections AS s 
  ON s.id = a.sectionid 
  WHERE a.state = 1  
  AND a.access <= 0 
  AND cc.access <= 0 
  AND s.access <= 0 
  AND (a.publish_up = "0000-00-00 00:00:00" OR a.publish_up <= "2025-11-04 04:32:50" )  
  AND (a.publish_down = "0000-00-00 00:00:00" OR a.publish_down >= "2025-11-04 04:32:50" ) 
  AND cc.id = 102 
  AND cc.SECTION = s.id 
  AND cc.published = 1 
  AND s.published = 1 
  ORDER BY a.ordering
SELECT DISTINCT product_sku 
  FROM jos_vm_product, jos_vm_product_category_xref, jos_vm_category 
  WHERE product_parent_id=''
  AND jos_vm_product.product_id=jos_vm_product_category_xref.product_id 
  AND jos_vm_category.category_id=jos_vm_product_category_xref.category_id 
  AND jos_vm_product.product_publish='Y' 
  ORDER BY jos_vm_product.product_id DESC 
  LIMIT 0, 12
SELECT product_id, product_name, product_parent_id, product_thumb_image 
  FROM jos_vm_product 
  WHERE product_sku='PN0094'
SELECT category_id 
  FROM `jos_vm_product_category_xref` 
  WHERE product_id=111
SELECT
                                `jos_vm_product`.`product_parent_id` AS product_parent_id,
                                `jos_vm_category`.`category_flypage`
                        
  FROM
                                `jos_vm_product`
                        
  LEFT JOIN `jos_vm_product_category_xref` 
  ON `jos_vm_product_category_xref`.`product_id` = `jos_vm_product`.`product_id`
                        
  LEFT JOIN `jos_vm_category` 
  ON `jos_vm_product_category_xref`.`category_id` = `jos_vm_category`.`category_id`
                        
  WHERE `jos_vm_product`.`product_id`='111'
SELECT product_id, product_name, product_parent_id, product_thumb_image 
  FROM jos_vm_product 
  WHERE product_sku='PN0121'
SELECT category_id 
  FROM `jos_vm_product_category_xref` 
  WHERE product_id=110
SELECT
                                `jos_vm_product`.`product_parent_id` AS product_parent_id,
                                `jos_vm_category`.`category_flypage`
                        
  FROM
                                `jos_vm_product`
                        
  LEFT JOIN `jos_vm_product_category_xref` 
  ON `jos_vm_product_category_xref`.`product_id` = `jos_vm_product`.`product_id`
                        
  LEFT JOIN `jos_vm_category` 
  ON `jos_vm_product_category_xref`.`category_id` = `jos_vm_category`.`category_id`
                        
  WHERE `jos_vm_product`.`product_id`='110'
SELECT product_id, product_name, product_parent_id, product_thumb_image 
  FROM jos_vm_product 
  WHERE product_sku='PN0047'
SELECT category_id 
  FROM `jos_vm_product_category_xref` 
  WHERE product_id=109
SELECT
                                `jos_vm_product`.`product_parent_id` AS product_parent_id,
                                `jos_vm_category`.`category_flypage`
                        
  FROM
                                `jos_vm_product`
                        
  LEFT JOIN `jos_vm_product_category_xref` 
  ON `jos_vm_product_category_xref`.`product_id` = `jos_vm_product`.`product_id`
                        
  LEFT JOIN `jos_vm_category` 
  ON `jos_vm_product_category_xref`.`category_id` = `jos_vm_category`.`category_id`
                        
  WHERE `jos_vm_product`.`product_id`='109'
SELECT product_id, product_name, product_parent_id, product_thumb_image 
  FROM jos_vm_product 
  WHERE product_sku='FL0340'
SELECT category_id 
  FROM `jos_vm_product_category_xref` 
  WHERE product_id=108
SELECT
                                `jos_vm_product`.`product_parent_id` AS product_parent_id,
                                `jos_vm_category`.`category_flypage`
                        
  FROM
                                `jos_vm_product`
                        
  LEFT JOIN `jos_vm_product_category_xref` 
  ON `jos_vm_product_category_xref`.`product_id` = `jos_vm_product`.`product_id`
                        
  LEFT JOIN `jos_vm_category` 
  ON `jos_vm_product_category_xref`.`category_id` = `jos_vm_category`.`category_id`
                        
  WHERE `jos_vm_product`.`product_id`='108'
SELECT product_id, product_name, product_parent_id, product_thumb_image 
  FROM jos_vm_product 
  WHERE product_sku='FL0373'
SELECT category_id 
  FROM `jos_vm_product_category_xref` 
  WHERE product_id=107
SELECT
                                `jos_vm_product`.`product_parent_id` AS product_parent_id,
                                `jos_vm_category`.`category_flypage`
                        
  FROM
                                `jos_vm_product`
                        
  LEFT JOIN `jos_vm_product_category_xref` 
  ON `jos_vm_product_category_xref`.`product_id` = `jos_vm_product`.`product_id`
                        
  LEFT JOIN `jos_vm_category` 
  ON `jos_vm_product_category_xref`.`category_id` = `jos_vm_category`.`category_id`
                        
  WHERE `jos_vm_product`.`product_id`='107'
SELECT product_id, product_name, product_parent_id, product_thumb_image 
  FROM jos_vm_product 
  WHERE product_sku='FL0342'
SELECT category_id 
  FROM `jos_vm_product_category_xref` 
  WHERE product_id=106
SELECT
                                `jos_vm_product`.`product_parent_id` AS product_parent_id,
                                `jos_vm_category`.`category_flypage`
                        
  FROM
                                `jos_vm_product`
                        
  LEFT JOIN `jos_vm_product_category_xref` 
  ON `jos_vm_product_category_xref`.`product_id` = `jos_vm_product`.`product_id`
                        
  LEFT JOIN `jos_vm_category` 
  ON `jos_vm_product_category_xref`.`category_id` = `jos_vm_category`.`category_id`
                        
  WHERE `jos_vm_product`.`product_id`='106'
SELECT product_id, product_name, product_parent_id, product_thumb_image 
  FROM jos_vm_product 
  WHERE product_sku='FL0349'
SELECT category_id 
  FROM `jos_vm_product_category_xref` 
  WHERE product_id=105
SELECT
                                `jos_vm_product`.`product_parent_id` AS product_parent_id,
                                `jos_vm_category`.`category_flypage`
                        
  FROM
                                `jos_vm_product`
                        
  LEFT JOIN `jos_vm_product_category_xref` 
  ON `jos_vm_product_category_xref`.`product_id` = `jos_vm_product`.`product_id`
                        
  LEFT JOIN `jos_vm_category` 
  ON `jos_vm_product_category_xref`.`category_id` = `jos_vm_category`.`category_id`
                        
  WHERE `jos_vm_product`.`product_id`='105'
SELECT product_id, product_name, product_parent_id, product_thumb_image 
  FROM jos_vm_product 
  WHERE product_sku='MD0194'
SELECT category_id 
  FROM `jos_vm_product_category_xref` 
  WHERE product_id=104
SELECT
                                `jos_vm_product`.`product_parent_id` AS product_parent_id,
                                `jos_vm_category`.`category_flypage`
                        
  FROM
                                `jos_vm_product`
                        
  LEFT JOIN `jos_vm_product_category_xref` 
  ON `jos_vm_product_category_xref`.`product_id` = `jos_vm_product`.`product_id`
                        
  LEFT JOIN `jos_vm_category` 
  ON `jos_vm_product_category_xref`.`category_id` = `jos_vm_category`.`category_id`
                        
  WHERE `jos_vm_product`.`product_id`='104'
SELECT product_id, product_name, product_parent_id, product_thumb_image 
  FROM jos_vm_product 
  WHERE product_sku='MP1103'
SELECT category_id 
  FROM `jos_vm_product_category_xref` 
  WHERE product_id=103
SELECT
                                `jos_vm_product`.`product_parent_id` AS product_parent_id,
                                `jos_vm_category`.`category_flypage`
                        
  FROM
                                `jos_vm_product`
                        
  LEFT JOIN `jos_vm_product_category_xref` 
  ON `jos_vm_product_category_xref`.`product_id` = `jos_vm_product`.`product_id`
                        
  LEFT JOIN `jos_vm_category` 
  ON `jos_vm_product_category_xref`.`category_id` = `jos_vm_category`.`category_id`
                        
  WHERE `jos_vm_product`.`product_id`='103'
SELECT product_id, product_name, product_parent_id, product_thumb_image 
  FROM jos_vm_product 
  WHERE product_sku='MP0948'
SELECT category_id 
  FROM `jos_vm_product_category_xref` 
  WHERE product_id=102
SELECT
                                `jos_vm_product`.`product_parent_id` AS product_parent_id,
                                `jos_vm_category`.`category_flypage`
                        
  FROM
                                `jos_vm_product`
                        
  LEFT JOIN `jos_vm_product_category_xref` 
  ON `jos_vm_product_category_xref`.`product_id` = `jos_vm_product`.`product_id`
                        
  LEFT JOIN `jos_vm_category` 
  ON `jos_vm_product_category_xref`.`category_id` = `jos_vm_category`.`category_id`
                        
  WHERE `jos_vm_product`.`product_id`='102'
SELECT product_id, product_name, product_parent_id, product_thumb_image 
  FROM jos_vm_product 
  WHERE product_sku='DP0156'
SELECT category_id 
  FROM `jos_vm_product_category_xref` 
  WHERE product_id=101
SELECT
                                `jos_vm_product`.`product_parent_id` AS product_parent_id,
                                `jos_vm_category`.`category_flypage`
                        
  FROM
                                `jos_vm_product`
                        
  LEFT JOIN `jos_vm_product_category_xref` 
  ON `jos_vm_product_category_xref`.`product_id` = `jos_vm_product`.`product_id`
                        
  LEFT JOIN `jos_vm_category` 
  ON `jos_vm_product_category_xref`.`category_id` = `jos_vm_category`.`category_id`
                        
  WHERE `jos_vm_product`.`product_id`='101'
SELECT product_id, product_name, product_parent_id, product_thumb_image 
  FROM jos_vm_product 
  WHERE product_sku='DP0131'
SELECT category_id 
  FROM `jos_vm_product_category_xref` 
  WHERE product_id=100
SELECT
                                `jos_vm_product`.`product_parent_id` AS product_parent_id,
                                `jos_vm_category`.`category_flypage`
                        
  FROM
                                `jos_vm_product`
                        
  LEFT JOIN `jos_vm_product_category_xref` 
  ON `jos_vm_product_category_xref`.`product_id` = `jos_vm_product`.`product_id`
                        
  LEFT JOIN `jos_vm_category` 
  ON `jos_vm_product_category_xref`.`category_id` = `jos_vm_category`.`category_id`
                        
  WHERE `jos_vm_product`.`product_id`='100'
SELECT a.*, CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(":", a.id, a.alias) ELSE a.id END AS slug, CASE WHEN CHAR_LENGTH(cc.name) THEN CONCAT_WS(":", cc.id, cc.name) ELSE cc.id END AS catslug 
  FROM jos_content AS a 
  INNER JOIN jos_categories AS cc 
  ON cc.id = a.catid 
  INNER JOIN jos_sections AS s 
  ON s.id = a.sectionid 
  WHERE a.state = 1  
  AND a.access <= 0 
  AND cc.access <= 0 
  AND s.access <= 0 
  AND (a.publish_up = "0000-00-00 00:00:00" OR a.publish_up <= "2025-11-04 04:32:50" )  
  AND (a.publish_down = "0000-00-00 00:00:00" OR a.publish_down >= "2025-11-04 04:32:50" ) 
  AND cc.id = 102 
  AND cc.SECTION = s.id 
  AND cc.published = 1 
  AND s.published = 1 
  ORDER BY a.ordering
SELECT DISTINCT product_sku 
  FROM jos_vm_product 
  WHERE (jos_vm_product.product_parent_id='' OR jos_vm_product.product_parent_id='0') 
  AND vendor_id='1' 
  AND jos_vm_product.product_publish='Y' 
  AND jos_vm_product.product_special='Y' 
  ORDER BY RAND() 
  LIMIT 0, 12
SELECT product_id, product_name, product_parent_id, product_thumb_image 
  FROM jos_vm_product 
  WHERE product_sku='SP0268'
SELECT category_id 
  FROM `jos_vm_product_category_xref` 
  WHERE product_id=98
SELECT
                                `jos_vm_product`.`product_parent_id` AS product_parent_id,
                                `jos_vm_category`.`category_flypage`
                        
  FROM
                                `jos_vm_product`
                        
  LEFT JOIN `jos_vm_product_category_xref` 
  ON `jos_vm_product_category_xref`.`product_id` = `jos_vm_product`.`product_id`
                        
  LEFT JOIN `jos_vm_category` 
  ON `jos_vm_product_category_xref`.`category_id` = `jos_vm_category`.`category_id`
                        
  WHERE `jos_vm_product`.`product_id`='98'
SELECT product_id, product_name, product_parent_id, product_thumb_image 
  FROM jos_vm_product 
  WHERE product_sku='PN0121'
SELECT category_id 
  FROM `jos_vm_product_category_xref` 
  WHERE product_id=110
SELECT product_id, product_name, product_parent_id, product_thumb_image 
  FROM jos_vm_product 
  WHERE product_sku='FP1229'
SELECT category_id 
  FROM `jos_vm_product_category_xref` 
  WHERE product_id=49
SELECT
                                `jos_vm_product`.`product_parent_id` AS product_parent_id,
                                `jos_vm_category`.`category_flypage`
                        
  FROM
                                `jos_vm_product`
                        
  LEFT JOIN `jos_vm_product_category_xref` 
  ON `jos_vm_product_category_xref`.`product_id` = `jos_vm_product`.`product_id`
                        
  LEFT JOIN `jos_vm_category` 
  ON `jos_vm_product_category_xref`.`category_id` = `jos_vm_category`.`category_id`
                        
  WHERE `jos_vm_product`.`product_id`='49'
SELECT product_id, product_name, product_parent_id, product_thumb_image 
  FROM jos_vm_product 
  WHERE product_sku='GN0500'
SELECT category_id 
  FROM `jos_vm_product_category_xref` 
  WHERE product_id=92
SELECT
                                `jos_vm_product`.`product_parent_id` AS product_parent_id,
                                `jos_vm_category`.`category_flypage`
                        
  FROM
                                `jos_vm_product`
                        
  LEFT JOIN `jos_vm_product_category_xref` 
  ON `jos_vm_product_category_xref`.`product_id` = `jos_vm_product`.`product_id`
                        
  LEFT JOIN `jos_vm_category` 
  ON `jos_vm_product_category_xref`.`category_id` = `jos_vm_category`.`category_id`
                        
  WHERE `jos_vm_product`.`product_id`='92'
SELECT product_id, product_name, product_parent_id, product_thumb_image 
  FROM jos_vm_product 
  WHERE product_sku='LP1269'
SELECT category_id 
  FROM `jos_vm_product_category_xref` 
  WHERE product_id=67
SELECT
                                `jos_vm_product`.`product_parent_id` AS product_parent_id,
                                `jos_vm_category`.`category_flypage`
                        
  FROM
                                `jos_vm_product`
                        
  LEFT JOIN `jos_vm_product_category_xref` 
  ON `jos_vm_product_category_xref`.`product_id` = `jos_vm_product`.`product_id`
                        
  LEFT JOIN `jos_vm_category` 
  ON `jos_vm_product_category_xref`.`category_id` = `jos_vm_category`.`category_id`
                        
  WHERE `jos_vm_product`.`product_id`='67'
SELECT product_id, product_name, product_parent_id, product_thumb_image 
  FROM jos_vm_product 
  WHERE product_sku='PH0291'
SELECT category_id 
  FROM `jos_vm_product_category_xref` 
  WHERE product_id=89
SELECT
                                `jos_vm_product`.`product_parent_id` AS product_parent_id,
                                `jos_vm_category`.`category_flypage`
                        
  FROM
                                `jos_vm_product`
                        
  LEFT JOIN `jos_vm_product_category_xref` 
  ON `jos_vm_product_category_xref`.`product_id` = `jos_vm_product`.`product_id`
                        
  LEFT JOIN `jos_vm_category` 
  ON `jos_vm_product_category_xref`.`category_id` = `jos_vm_category`.`category_id`
                        
  WHERE `jos_vm_product`.`product_id`='89'
SELECT product_id, product_name, product_parent_id, product_thumb_image 
  FROM jos_vm_product 
  WHERE product_sku='GN0453'
SELECT category_id 
  FROM `jos_vm_product_category_xref` 
  WHERE product_id=96
SELECT
                                `jos_vm_product`.`product_parent_id` AS product_parent_id,
                                `jos_vm_category`.`category_flypage`
                        
  FROM
                                `jos_vm_product`
                        
  LEFT JOIN `jos_vm_product_category_xref` 
  ON `jos_vm_product_category_xref`.`product_id` = `jos_vm_product`.`product_id`
                        
  LEFT JOIN `jos_vm_category` 
  ON `jos_vm_product_category_xref`.`category_id` = `jos_vm_category`.`category_id`
                        
  WHERE `jos_vm_product`.`product_id`='96'
SELECT product_id, product_name, product_parent_id, product_thumb_image 
  FROM jos_vm_product 
  WHERE product_sku='FP2144'
SELECT category_id 
  FROM `jos_vm_product_category_xref` 
  WHERE product_id=46
SELECT
                                `jos_vm_product`.`product_parent_id` AS product_parent_id,
                                `jos_vm_category`.`category_flypage`
                        
  FROM
                                `jos_vm_product`
                        
  LEFT JOIN `jos_vm_product_category_xref` 
  ON `jos_vm_product_category_xref`.`product_id` = `jos_vm_product`.`product_id`
                        
  LEFT JOIN `jos_vm_category` 
  ON `jos_vm_product_category_xref`.`category_id` = `jos_vm_category`.`category_id`
                        
  WHERE `jos_vm_product`.`product_id`='46'
SELECT product_id, product_name, product_parent_id, product_thumb_image 
  FROM jos_vm_product 
  WHERE product_sku='LN0058'
SELECT category_id 
  FROM `jos_vm_product_category_xref` 
  WHERE product_id=35
SELECT
                                `jos_vm_product`.`product_parent_id` AS product_parent_id,
                                `jos_vm_category`.`category_flypage`
                        
  FROM
                                `jos_vm_product`
                        
  LEFT JOIN `jos_vm_product_category_xref` 
  ON `jos_vm_product_category_xref`.`product_id` = `jos_vm_product`.`product_id`
                        
  LEFT JOIN `jos_vm_category` 
  ON `jos_vm_product_category_xref`.`category_id` = `jos_vm_category`.`category_id`
                        
  WHERE `jos_vm_product`.`product_id`='35'
SELECT product_id, product_name, product_parent_id, product_thumb_image 
  FROM jos_vm_product 
  WHERE product_sku='FP1945'
SELECT category_id 
  FROM `jos_vm_product_category_xref` 
  WHERE product_id=84
SELECT
                                `jos_vm_product`.`product_parent_id` AS product_parent_id,
                                `jos_vm_category`.`category_flypage`
                        
  FROM
                                `jos_vm_product`
                        
  LEFT JOIN `jos_vm_product_category_xref` 
  ON `jos_vm_product_category_xref`.`product_id` = `jos_vm_product`.`product_id`
                        
  LEFT JOIN `jos_vm_category` 
  ON `jos_vm_product_category_xref`.`category_id` = `jos_vm_category`.`category_id`
                        
  WHERE `jos_vm_product`.`product_id`='84'
SELECT product_id, product_name, product_parent_id, product_thumb_image 
  FROM jos_vm_product 
  WHERE product_sku='LN0020'
SELECT category_id 
  FROM `jos_vm_product_category_xref` 
  WHERE product_id=29
SELECT
                                `jos_vm_product`.`product_parent_id` AS product_parent_id,
                                `jos_vm_category`.`category_flypage`
                        
  FROM
                                `jos_vm_product`
                        
  LEFT JOIN `jos_vm_product_category_xref` 
  ON `jos_vm_product_category_xref`.`product_id` = `jos_vm_product`.`product_id`
                        
  LEFT JOIN `jos_vm_category` 
  ON `jos_vm_product_category_xref`.`category_id` = `jos_vm_category`.`category_id`
                        
  WHERE `jos_vm_product`.`product_id`='29'
SELECT product_id, product_name, product_parent_id, product_thumb_image 
  FROM jos_vm_product 
  WHERE product_sku='GN0329'
SELECT category_id 
  FROM `jos_vm_product_category_xref` 
  WHERE product_id=90
SELECT
                                `jos_vm_product`.`product_parent_id` AS product_parent_id,
                                `jos_vm_category`.`category_flypage`
                        
  FROM
                                `jos_vm_product`
                        
  LEFT JOIN `jos_vm_product_category_xref` 
  ON `jos_vm_product_category_xref`.`product_id` = `jos_vm_product`.`product_id`
                        
  LEFT JOIN `jos_vm_category` 
  ON `jos_vm_product_category_xref`.`category_id` = `jos_vm_category`.`category_id`
                        
  WHERE `jos_vm_product`.`product_id`='90'