Išparduodamos prekės
Išparduodamos sandelyje užsigulėjusios prekės, prekių kiekis ribotas
Kuo originalesnis atradimas...
...tuo akivaizdesnis jis atrodo vėliau.
Išparduodamos sandelyje užsigulėjusios prekės, prekių kiekis ribotas
Norėdami gauti greitą atsakymą apie Jus dominančią prekę rašykite:
info@infolaina.lt
vmcart ⇒ O:8:"stdClass":24:{s:8:"products";a:0:{}s:8:"vendorId";i:1;s:21:"lastVisitedCategoryId";i:0;s:28:"virtuemart_shipmentmethod_id";i:0;s:27:"virtuemart_paymentmethod_id";i:0;s:25:"automaticSelectedShipment";b:0;s:24:"automaticSelectedPayment";b:0;s:12:"order_number";N;s:2:"BT";i:0;s:2:"ST";i:0;s:11:"tosAccepted";N;s:16:"customer_comment";s:0:"";s:10:"couponCode";s:0:"";s:20:"_triesValidateCoupon";a:0:{}s:14:"order_language";s:0:"";s:8:"cartData";N;s:5:"lists";N;s:14:"pricesCurrency";N;s:15:"paymentCurrency";N;s:11:"_inCheckOut";b:0;s:14:"_dataValidated";b:0;s:12:"_confirmDone";b:0;s:10:"STsameAsBT";b:1;s:15:"customer_number";s:7:"nonreg_";}
Application 0.000 seconds (+0.000); 0.92 MB (+0.921) - afterLoad
Application 0.039 seconds (+0.038); 5.02 MB (+4.102) - afterInitialise
Application 0.041 seconds (+0.003); 5.57 MB (+0.546) - afterRoute
Application 0.074 seconds (+0.033); 8.25 MB (+2.681) - beforeRenderModule mod_virtuemart_product (Akcijines prekes)
Application 0.345 seconds (+0.271); 16.25 MB (+7.997) - afterRenderModule mod_virtuemart_product (Akcijines prekes)
Application 0.354 seconds (+0.009); 16.66 MB (+0.414) - afterDispatch
Application 0.357 seconds (+0.002); 16.76 MB (+0.100) - beforeRenderModule mod_menu (Main Menu - Russian)
Application 0.359 seconds (+0.003); 16.81 MB (+0.051) - afterRenderModule mod_menu (Main Menu - Russian)
Application 0.359 seconds (+0.000); 16.81 MB (-0.005) - beforeRenderModule mod_menu (Main Menu - Lietuvių)
Application 0.364 seconds (+0.005); 16.89 MB (+0.082) - afterRenderModule mod_menu (Main Menu - Lietuvių)
Application 0.365 seconds (+0.002); 16.89 MB (-0.004) - beforeRenderModule mod_custom (Sprendimas)
Application 0.367 seconds (+0.002); 16.89 MB (+0.007) - afterRenderModule mod_custom (Sprendimas)
Application 0.368 seconds (+0.000); 16.89 MB (-0.003) - beforeRenderModule mod_footer (Footer)
Application 0.370 seconds (+0.002); 16.90 MB (+0.009) - afterRenderModule mod_footer (Footer)
Application 0.370 seconds (+0.000); 16.89 MB (-0.004) - beforeRenderModule mod_custom (Susisiekime)
Application 0.370 seconds (+0.000); 16.90 MB (+0.005) - afterRenderModule mod_custom (Susisiekime)
Application 0.370 seconds (+0.000); 16.90 MB (-0.002) - beforeRenderModule mod_menu (Naudinga)
Application 0.372 seconds (+0.002); 16.91 MB (+0.017) - afterRenderModule mod_menu (Naudinga)
Application 0.372 seconds (+0.000); 16.91 MB (-0.006) - beforeRenderModule mod_menu (Naujienos)
Application 0.373 seconds (+0.001); 16.92 MB (+0.012) - afterRenderModule mod_menu (Naujienos)
Application 0.373 seconds (+0.000); 16.91 MB (-0.006) - beforeRenderModule mod_custom (Baneris akcija)
Application 0.373 seconds (+0.000); 16.92 MB (+0.005) - afterRenderModule mod_custom (Baneris akcija)
Application 0.373 seconds (+0.000); 16.91 MB (-0.003) - beforeRenderModule mod_custom (Baneris akcija (2))
Application 0.373 seconds (+0.000); 16.92 MB (+0.005) - afterRenderModule mod_custom (Baneris akcija (2))
Application 0.373 seconds (+0.000); 16.91 MB (-0.003) - beforeRenderModule mod_custom (Baneris akcija (3))
Application 0.373 seconds (+0.000); 16.92 MB (+0.005) - afterRenderModule mod_custom (Baneris akcija (3))
Application 0.373 seconds (+0.000); 16.92 MB (-0.003) - beforeRenderModule mod_custom (Baneris akcija (4))
Application 0.374 seconds (+0.000); 16.92 MB (+0.004) - afterRenderModule mod_custom (Baneris akcija (4))
Application 0.374 seconds (+0.000); 16.92 MB (-0.003) - beforeRenderModule mod_custom (Baneris akcija (5))
Application 0.374 seconds (+0.000); 16.92 MB (+0.004) - afterRenderModule mod_custom (Baneris akcija (5))
Application 0.374 seconds (+0.000); 16.93 MB (+0.011) - beforeRenderModule mod_vp_flexslider (Slider LT pirmame)
Application 0.375 seconds (+0.001); 16.97 MB (+0.035) - afterRenderModule mod_vp_flexslider (Slider LT pirmame)
Application 0.375 seconds (+0.000); 16.94 MB (-0.032) - beforeRenderModule mod_search (Search)
Application 0.379 seconds (+0.004); 16.96 MB (+0.026) - afterRenderModule mod_search (Search)
Application 0.379 seconds (+0.000); 16.95 MB (-0.008) - beforeRenderModule mod_menu (Navigation)
Application 0.379 seconds (+0.000); 16.96 MB (+0.006) - afterRenderModule mod_menu (Navigation)
Application 0.379 seconds (+0.000); 16.95 MB (-0.006) - beforeRenderModule mod_virtuemart_cart (VM - Shopping cart)
Application 0.535 seconds (+0.156); 24.66 MB (+7.709) - afterRenderModule mod_virtuemart_cart (VM - Shopping cart)
Application 0.536 seconds (+0.000); 24.66 MB (-0.003) - beforeRenderModule mod_custom (Sukis)
Application 0.536 seconds (+0.000); 24.66 MB (+0.004) - afterRenderModule mod_custom (Sukis)
Application 0.536 seconds (+0.000); 24.66 MB (-0.003) - beforeRenderModule mod_custom (Logo)
Application 0.537 seconds (+0.001); 24.67 MB (+0.011) - afterRenderModule mod_custom (Logo)
Application 0.537 seconds (+0.000); 24.67 MB (-0.003) - beforeRenderModule mod_custom (Home icon)
Application 0.537 seconds (+0.000); 24.67 MB (+0.004) - afterRenderModule mod_custom (Home icon)
Application 0.537 seconds (+0.000); 24.67 MB (-0.002) - beforeRenderModule mod_languages (Language)
Application 0.544 seconds (+0.007); 24.88 MB (+0.205) - afterRenderModule mod_languages (Language)
Application 0.544 seconds (+0.000); 24.87 MB (-0.006) - beforeRenderModule mod_custom (Informacija Infolaina)
Application 0.544 seconds (+0.000); 24.87 MB (+0.004) - afterRenderModule mod_custom (Informacija Infolaina)
Application 0.554 seconds (+0.010); 25.04 MB (+0.169) - afterRender
25.01 MB (26,228,240 Bytes)
SELECT `data`
FROM `lelwf_session`
WHERE `session_id` = 'enj988kmj2b5ghafmd7quh27l0'
DELETE
FROM `lelwf_session`
WHERE `time` < '1736819501'
SELECT `session_id`
FROM `lelwf_session`
WHERE `session_id` = 'enj988kmj2b5ghafmd7quh27l0'
LIMIT 0, 1
INSERT INTO `lelwf_session`
(`session_id`, `client_id`, `time`)
VALUES
('enj988kmj2b5ghafmd7quh27l0', 0, '1736823101')
SELECT extension_id AS id, element AS "option", params, enabled
FROM lelwf_extensions
WHERE `type` = 'component'
AND `element` = 'com_users'
SELECT b.id
FROM lelwf_usergroups AS a
LEFT JOIN lelwf_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
WHERE a.id = 1
SELECT id, rules
FROM `lelwf_viewlevels`
SELECT folder AS type, element AS name, params
FROM lelwf_extensions
WHERE enabled >= 1
AND type ='plugin'
AND state >= 0
AND access IN (1,1)
ORDER BY ordering
SELECT *
FROM lelwf_languages
WHERE published=1
ORDER BY ordering ASC
SELECT extension_id AS id, element AS "option", params, enabled
FROM lelwf_extensions
WHERE `type` = 'component'
AND `element` = 'com_languages'
SELECT COUNT(*)
FROM `lelwf_menu`
WHERE home = 1
AND published = 1
AND client_id = 0
SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.type, m.level, m.language,m.browserNav, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component
FROM lelwf_menu AS m
LEFT JOIN lelwf_extensions AS e
ON m.component_id = e.extension_id
WHERE m.published = 1
AND m.parent_id > 0
AND m.client_id = 0
ORDER BY m.lft
SELECT extension_id AS id, element AS "option", params, enabled
FROM lelwf_extensions
WHERE `type` = 'component'
AND `element` = 'com_content'
SELECT id, home, template, s.params
FROM lelwf_template_styles as s
LEFT JOIN lelwf_extensions as e
ON e.element=s.template
AND e.type='template'
AND e.client_id=s.client_id
WHERE s.client_id = 0
AND e.enabled = 1
SELECT a.rules
FROM lelwf_assets AS a
WHERE (a.id = 1)
GROUP BY a.id, a.rules, a.lft
SELECT b.rules
FROM lelwf_assets AS a
LEFT JOIN lelwf_assets AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
WHERE (a.name = 'com_content')
GROUP BY b.id, b.rules, b.lft
ORDER BY b.lft
SELECT a.id, a.asset_id, a.title, a.alias, a.title_alias, a.introtext, a.fulltext,
CASE WHEN badcats.id is null THEN a.state ELSE 0 END AS state, a.mask, a.catid, a.created, a.created_by, a.created_by_alias,
CASE WHEN a.modified = 0 THEN a.created ELSE a.modified END as modified, a.modified_by, a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.images, a.urls, a.attribs, a.version, a.parentid, a.ordering, a.metakey, a.metadesc, a.access, a.hits, a.metadata, a.featured, a.language, a.xreference,c.title AS category_title, c.alias AS category_alias, c.access AS category_access,u.name AS author,(
SELECT MAX(contact.id) AS id
FROM lelwf_contact_details AS contact
WHERE contact.published = 1
AND contact.user_id = a.created_by
AND (contact.language in ('lt-LT','*') OR contact.language IS NULL)) as contactid,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count
FROM lelwf_content AS a
LEFT JOIN lelwf_categories AS c
on c.id = a.catid
LEFT JOIN lelwf_users AS u
on u.id = a.created_by
LEFT JOIN lelwf_categories as parent
ON parent.id = c.parent_id
LEFT JOIN lelwf_content_rating AS v
ON a.id = v.content_id
LEFT
OUTER JOIN (SELECT cat.id as id
FROM lelwf_categories AS cat JOIN lelwf_categories AS parent
ON cat.lft BETWEEN parent.lft
AND parent.rgt
WHERE parent.extension = 'com_content'
AND parent.published <= 0
GROUP BY cat.id) AS badcats
ON badcats.id = c.id
WHERE a.language in ('lt-LT','*')
AND a.id = 28
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2025-01-14 02:51:41')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2025-01-14 02:51:41')
AND (a.state = 1 OR a.state =2)
SELECT c.*,
CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
FROM lelwf_categories as c
LEFT JOIN lelwf_categories AS s
ON (s.lft < c.lft
AND s.rgt > c.rgt
AND c.language in ('lt-LT','*')) OR (s.lft >= c.lft
AND s.rgt <= c.rgt)
LEFT JOIN (SELECT cat.id as id
FROM lelwf_categories AS cat JOIN lelwf_categories AS parent
ON cat.lft BETWEEN parent.lft
AND parent.rgt
WHERE parent.extension = 'com_content'
AND parent.published != 1
GROUP BY cat.id) AS badcats
ON badcats.id = c.id
WHERE (c.extension='com_content' OR c.extension='system')
AND c.access IN (1,1)
AND c.published = 1
AND s.id=14
AND badcats.id is null
GROUP BY c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
c.path, c.published, c.rgt, c.title, c.modified_user_id
ORDER BY c.lft
SELECT a.sef AS sef,a.lang_code AS lang_code
FROM lelwf_languages AS a
SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM lelwf_modules AS m
LEFT JOIN lelwf_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN lelwf_extensions AS e
ON e.element = m.module
AND e.client_id = m.client_id
WHERE m.published = 1
AND e.enabled = 1
AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2025-01-14 02:51:41')
AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2025-01-14 02:51:41')
AND m.access IN (1,1)
AND m.client_id = 0
AND (mm.menuid = 254 OR mm.menuid <= 0)
AND m.language IN ('lt-LT','*')
ORDER BY m.position, m.ordering
SHOW TABLES LIKE "lelwf_virtuemart_configs"
SELECT `config`
FROM `lelwf_virtuemart_configs`
WHERE `virtuemart_config_id` = "1";
SHOW FULL COLUMNS
FROM `lelwf_assets`
SELECT id
FROM lelwf_assets
WHERE parent_id = 0
SELECT b.rules
FROM lelwf_assets AS a
LEFT JOIN lelwf_assets AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
WHERE (a.id = 1)
GROUP BY b.id, b.rules, b.lft
ORDER BY b.lft
SELECT `virtuemart_shoppergroup_id`
FROM `lelwf_virtuemart_vmuser_shoppergroups`
WHERE `virtuemart_user_id` = "0"
SELECT *
FROM `lelwf_virtuemart_shoppergroups`
WHERE `default` = "2"
AND (`virtuemart_vendor_id` = "1" OR `shared` = "1")
AND `published`="1"
SELECT p.`virtuemart_product_id`
FROM `lelwf_virtuemart_products` as p
INNER JOIN `lelwf_virtuemart_products_lt_lt` as l using (`virtuemart_product_id`)
LEFT JOIN `lelwf_virtuemart_product_shoppergroups` as ps
ON p.`virtuemart_product_id` = `ps`.`virtuemart_product_id`
LEFT JOIN `lelwf_virtuemart_product_categories` as pc
ON p.`virtuemart_product_id` = `pc`.`virtuemart_product_id`
WHERE ( p.`published`="1"
AND `pc`.`virtuemart_category_id` > 0
AND ( `ps`.`virtuemart_shoppergroup_id`= "1" OR `ps`.`virtuemart_shoppergroup_id` IS NULL )
AND p.`product_special`="1" )
group by p.`virtuemart_product_id`
ORDER BY RAND() ASC
LIMIT 0, 100
SELECT `lelwf_virtuemart_products`.* ,`lelwf_virtuemart_products_lt_lt`.* ,`lelwf_virtuemart_product_manufacturers`.`virtuemart_manufacturer_id` ,`lelwf_virtuemart_product_customfields`.`virtuemart_customfield_id`
FROM `lelwf_virtuemart_products`
INNER JOIN `lelwf_virtuemart_products_lt_lt` using (`virtuemart_product_id`)
LEFT JOIN `lelwf_virtuemart_product_manufacturers`
on `lelwf_virtuemart_product_manufacturers`.`virtuemart_product_id`=`lelwf_virtuemart_products`.`virtuemart_product_id`
LEFT JOIN `lelwf_virtuemart_product_customfields`
on `lelwf_virtuemart_product_customfields`.`virtuemart_product_id`=`lelwf_virtuemart_products`.`virtuemart_product_id`
WHERE `lelwf_virtuemart_products`.`virtuemart_product_id` = "1302"
SELECT `virtuemart_media_id`
FROM `lelwf_virtuemart_product_medias`
WHERE `virtuemart_product_id` = "1302"
ORDER BY `ordering`
SELECT `virtuemart_shoppergroup_id`
FROM `lelwf_virtuemart_product_shoppergroups`
WHERE `virtuemart_product_id` = "1302"
SELECT *
FROM `lelwf_virtuemart_product_prices`
WHERE `virtuemart_product_id` = "1302"
AND ( `virtuemart_shoppergroup_id` ="1" OR `virtuemart_shoppergroup_id` IS NULL OR `virtuemart_shoppergroup_id`="0")
AND ( (`product_price_publish_up` IS NULL OR `product_price_publish_up` = "0000-00-00 00:00:00" OR `product_price_publish_up` <= "2025-01-14 02:51:41" )
AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2025-01-14 02:51:41" ) )
AND( (`price_quantity_start` IS NULL OR `price_quantity_start`="0" OR `price_quantity_start` <= 1)
AND (`price_quantity_end` IS NULL OR `price_quantity_end`="0" OR `price_quantity_end` >= 1) )
SELECT pc.`virtuemart_category_id`
FROM `lelwf_virtuemart_product_categories` as pc
WHERE pc.`virtuemart_product_id` = 1302
SELECT pc.`virtuemart_category_id`
FROM `lelwf_virtuemart_product_categories` as pc
LEFT JOIN `lelwf_virtuemart_categories` as c
ON c.`virtuemart_category_id` = pc.`virtuemart_category_id`
WHERE pc.`virtuemart_product_id` = 1302
AND `published`=1
ORDER BY `c`.`ordering` ASC
SELECT `ordering`,`id`
FROM `lelwf_virtuemart_product_categories`
WHERE `virtuemart_product_id` = "1302"
and `virtuemart_category_id`= "66"
SELECT `lelwf_virtuemart_categories`.* ,`lelwf_virtuemart_categories_lt_lt`.*
FROM `lelwf_virtuemart_categories`
INNER JOIN `lelwf_virtuemart_categories_lt_lt` using (`virtuemart_category_id`)
WHERE `lelwf_virtuemart_categories`.`virtuemart_category_id` = "66"
SELECT `vendor_currency`,`currency_code_3`,`currency_numeric_code`
FROM `lelwf_virtuemart_vendors` AS v
LEFT JOIN `lelwf_virtuemart_currencies` AS c
ON virtuemart_currency_id = vendor_currency
WHERE v.`virtuemart_vendor_id`="1"
SELECT *
FROM `lelwf_virtuemart_currencies`
WHERE `virtuemart_currency_id`="47"
SELECT `price_display`,`custom_price_display`
FROM `lelwf_virtuemart_shoppergroups` AS `sg`
WHERE `sg`.`default` = "2"
SELECT *
FROM `lelwf_virtuemart_shoppergroups`
WHERE `default` = "2"
AND (`virtuemart_vendor_id` = "1" OR `shared` = "1")
AND `published`="1"
SELECT *
FROM lelwf_virtuemart_calcs
WHERE
`calc_kind` IN ('Marge','Tax','VatTax','DBTax','DATax' )
AND `published`="1"
AND (`virtuemart_vendor_id`="1" OR `shared`="1" )
AND ( ( publish_up = "0000-00-00 00:00:00" OR publish_up <= "2025-01-14 02:51:41" )
AND ( publish_down = "0000-00-00 00:00:00" OR publish_down >= "2025-01-14 02:51:41" )
OR `for_override` = "1" )
SELECT extension_id AS id, element AS "option", params, enabled
FROM lelwf_extensions
WHERE `type` = 'component'
AND `element` = 'com_virtuemart'
SELECT *
FROM `lelwf_menu`
where `link` like "index.php?option=com_virtuemart%"
and client_id=0
and published=1
and (language="*" or language = "lt-LT" )
SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
FROM lelwf_virtuemart_category_categories AS `xref`
WHERE `xref`.`category_child_id`= 66
SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
FROM lelwf_virtuemart_category_categories AS `xref`
WHERE `xref`.`category_child_id`= 61
SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
FROM lelwf_virtuemart_category_categories AS `xref`
WHERE `xref`.`category_child_id`= 55
SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
FROM lelwf_virtuemart_category_categories AS `xref`
WHERE `xref`.`category_child_id`= 50
SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
FROM lelwf_virtuemart_category_categories AS `xref`
WHERE `xref`.`category_child_id`= 66
SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
FROM lelwf_virtuemart_category_categories AS `xref`
WHERE `xref`.`category_child_id`= 61
SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
FROM lelwf_virtuemart_category_categories AS `xref`
WHERE `xref`.`category_child_id`= 55
SELECT `slug` as name
FROM `lelwf_virtuemart_categories_lt_lt`
WHERE `virtuemart_category_id`=55
SELECT `slug` as name
FROM `lelwf_virtuemart_categories_lt_lt`
WHERE `virtuemart_category_id`=61
SELECT `slug` as name
FROM `lelwf_virtuemart_categories_lt_lt`
WHERE `virtuemart_category_id`=66
SELECT `slug`
FROM `lelwf_virtuemart_products_lt_lt`
WHERE `virtuemart_product_id` = 1302
SELECT `lelwf_virtuemart_products`.* ,`lelwf_virtuemart_products_lt_lt`.* ,`lelwf_virtuemart_product_manufacturers`.`virtuemart_manufacturer_id` ,`lelwf_virtuemart_product_customfields`.`virtuemart_customfield_id`
FROM `lelwf_virtuemart_products`
INNER JOIN `lelwf_virtuemart_products_lt_lt` using (`virtuemart_product_id`)
LEFT JOIN `lelwf_virtuemart_product_manufacturers`
on `lelwf_virtuemart_product_manufacturers`.`virtuemart_product_id`=`lelwf_virtuemart_products`.`virtuemart_product_id`
LEFT JOIN `lelwf_virtuemart_product_customfields`
on `lelwf_virtuemart_product_customfields`.`virtuemart_product_id`=`lelwf_virtuemart_products`.`virtuemart_product_id`
WHERE `lelwf_virtuemart_products`.`virtuemart_product_id` = "135"
SELECT `virtuemart_media_id`
FROM `lelwf_virtuemart_product_medias`
WHERE `virtuemart_product_id` = "135"
ORDER BY `ordering`
SELECT `virtuemart_shoppergroup_id`
FROM `lelwf_virtuemart_product_shoppergroups`
WHERE `virtuemart_product_id` = "135"
SELECT *
FROM `lelwf_virtuemart_product_prices`
WHERE `virtuemart_product_id` = "135"
AND ( `virtuemart_shoppergroup_id` ="1" OR `virtuemart_shoppergroup_id` IS NULL OR `virtuemart_shoppergroup_id`="0")
AND ( (`product_price_publish_up` IS NULL OR `product_price_publish_up` = "0000-00-00 00:00:00" OR `product_price_publish_up` <= "2025-01-14 02:51:41" )
AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2025-01-14 02:51:41" ) )
AND( (`price_quantity_start` IS NULL OR `price_quantity_start`="0" OR `price_quantity_start` <= 1)
AND (`price_quantity_end` IS NULL OR `price_quantity_end`="0" OR `price_quantity_end` >= 1) )
SELECT pc.`virtuemart_category_id`
FROM `lelwf_virtuemart_product_categories` as pc
WHERE pc.`virtuemart_product_id` = 135
SELECT pc.`virtuemart_category_id`
FROM `lelwf_virtuemart_product_categories` as pc
LEFT JOIN `lelwf_virtuemart_categories` as c
ON c.`virtuemart_category_id` = pc.`virtuemart_category_id`
WHERE pc.`virtuemart_product_id` = 135
AND `published`=1
ORDER BY `c`.`ordering` ASC
SELECT `ordering`,`id`
FROM `lelwf_virtuemart_product_categories`
WHERE `virtuemart_product_id` = "135"
and `virtuemart_category_id`= "80"
SELECT `lelwf_virtuemart_categories`.* ,`lelwf_virtuemart_categories_lt_lt`.*
FROM `lelwf_virtuemart_categories`
INNER JOIN `lelwf_virtuemart_categories_lt_lt` using (`virtuemart_category_id`)
WHERE `lelwf_virtuemart_categories`.`virtuemart_category_id` = "80"
SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
FROM lelwf_virtuemart_category_categories AS `xref`
WHERE `xref`.`category_child_id`= 80
SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
FROM lelwf_virtuemart_category_categories AS `xref`
WHERE `xref`.`category_child_id`= 76
SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
FROM lelwf_virtuemart_category_categories AS `xref`
WHERE `xref`.`category_child_id`= 50
SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
FROM lelwf_virtuemart_category_categories AS `xref`
WHERE `xref`.`category_child_id`= 80
SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
FROM lelwf_virtuemart_category_categories AS `xref`
WHERE `xref`.`category_child_id`= 76
SELECT `slug` as name
FROM `lelwf_virtuemart_categories_lt_lt`
WHERE `virtuemart_category_id`=76
SELECT `slug` as name
FROM `lelwf_virtuemart_categories_lt_lt`
WHERE `virtuemart_category_id`=80
SELECT `slug`
FROM `lelwf_virtuemart_products_lt_lt`
WHERE `virtuemart_product_id` = 135
SELECT `lelwf_virtuemart_products`.* ,`lelwf_virtuemart_products_lt_lt`.* ,`lelwf_virtuemart_product_manufacturers`.`virtuemart_manufacturer_id` ,`lelwf_virtuemart_product_customfields`.`virtuemart_customfield_id`
FROM `lelwf_virtuemart_products`
INNER JOIN `lelwf_virtuemart_products_lt_lt` using (`virtuemart_product_id`)
LEFT JOIN `lelwf_virtuemart_product_manufacturers`
on `lelwf_virtuemart_product_manufacturers`.`virtuemart_product_id`=`lelwf_virtuemart_products`.`virtuemart_product_id`
LEFT JOIN `lelwf_virtuemart_product_customfields`
on `lelwf_virtuemart_product_customfields`.`virtuemart_product_id`=`lelwf_virtuemart_products`.`virtuemart_product_id`
WHERE `lelwf_virtuemart_products`.`virtuemart_product_id` = "769"
SELECT `virtuemart_media_id`
FROM `lelwf_virtuemart_product_medias`
WHERE `virtuemart_product_id` = "769"
ORDER BY `ordering`
SELECT `virtuemart_shoppergroup_id`
FROM `lelwf_virtuemart_product_shoppergroups`
WHERE `virtuemart_product_id` = "769"
SELECT *
FROM `lelwf_virtuemart_product_prices`
WHERE `virtuemart_product_id` = "769"
AND ( `virtuemart_shoppergroup_id` ="1" OR `virtuemart_shoppergroup_id` IS NULL OR `virtuemart_shoppergroup_id`="0")
AND ( (`product_price_publish_up` IS NULL OR `product_price_publish_up` = "0000-00-00 00:00:00" OR `product_price_publish_up` <= "2025-01-14 02:51:41" )
AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2025-01-14 02:51:41" ) )
AND( (`price_quantity_start` IS NULL OR `price_quantity_start`="0" OR `price_quantity_start` <= 1)
AND (`price_quantity_end` IS NULL OR `price_quantity_end`="0" OR `price_quantity_end` >= 1) )
SELECT pc.`virtuemart_category_id`
FROM `lelwf_virtuemart_product_categories` as pc
WHERE pc.`virtuemart_product_id` = 769
SELECT pc.`virtuemart_category_id`
FROM `lelwf_virtuemart_product_categories` as pc
LEFT JOIN `lelwf_virtuemart_categories` as c
ON c.`virtuemart_category_id` = pc.`virtuemart_category_id`
WHERE pc.`virtuemart_product_id` = 769
AND `published`=1
ORDER BY `c`.`ordering` ASC
SELECT `ordering`,`id`
FROM `lelwf_virtuemart_product_categories`
WHERE `virtuemart_product_id` = "769"
and `virtuemart_category_id`= "80"
SELECT `slug`
FROM `lelwf_virtuemart_products_lt_lt`
WHERE `virtuemart_product_id` = 769
SELECT `lelwf_virtuemart_products`.* ,`lelwf_virtuemart_products_lt_lt`.* ,`lelwf_virtuemart_product_manufacturers`.`virtuemart_manufacturer_id` ,`lelwf_virtuemart_product_customfields`.`virtuemart_customfield_id`
FROM `lelwf_virtuemart_products`
INNER JOIN `lelwf_virtuemart_products_lt_lt` using (`virtuemart_product_id`)
LEFT JOIN `lelwf_virtuemart_product_manufacturers`
on `lelwf_virtuemart_product_manufacturers`.`virtuemart_product_id`=`lelwf_virtuemart_products`.`virtuemart_product_id`
LEFT JOIN `lelwf_virtuemart_product_customfields`
on `lelwf_virtuemart_product_customfields`.`virtuemart_product_id`=`lelwf_virtuemart_products`.`virtuemart_product_id`
WHERE `lelwf_virtuemart_products`.`virtuemart_product_id` = "1300"
SELECT `virtuemart_media_id`
FROM `lelwf_virtuemart_product_medias`
WHERE `virtuemart_product_id` = "1300"
ORDER BY `ordering`
SELECT `virtuemart_shoppergroup_id`
FROM `lelwf_virtuemart_product_shoppergroups`
WHERE `virtuemart_product_id` = "1300"
SELECT *
FROM `lelwf_virtuemart_product_prices`
WHERE `virtuemart_product_id` = "1300"
AND ( `virtuemart_shoppergroup_id` ="1" OR `virtuemart_shoppergroup_id` IS NULL OR `virtuemart_shoppergroup_id`="0")
AND ( (`product_price_publish_up` IS NULL OR `product_price_publish_up` = "0000-00-00 00:00:00" OR `product_price_publish_up` <= "2025-01-14 02:51:41" )
AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2025-01-14 02:51:41" ) )
AND( (`price_quantity_start` IS NULL OR `price_quantity_start`="0" OR `price_quantity_start` <= 1)
AND (`price_quantity_end` IS NULL OR `price_quantity_end`="0" OR `price_quantity_end` >= 1) )
SELECT pc.`virtuemart_category_id`
FROM `lelwf_virtuemart_product_categories` as pc
WHERE pc.`virtuemart_product_id` = 1300
SELECT pc.`virtuemart_category_id`
FROM `lelwf_virtuemart_product_categories` as pc
LEFT JOIN `lelwf_virtuemart_categories` as c
ON c.`virtuemart_category_id` = pc.`virtuemart_category_id`
WHERE pc.`virtuemart_product_id` = 1300
AND `published`=1
ORDER BY `c`.`ordering` ASC
SELECT `ordering`,`id`
FROM `lelwf_virtuemart_product_categories`
WHERE `virtuemart_product_id` = "1300"
and `virtuemart_category_id`= "66"
SELECT `slug`
FROM `lelwf_virtuemart_products_lt_lt`
WHERE `virtuemart_product_id` = 1300
SELECT `lelwf_virtuemart_products`.* ,`lelwf_virtuemart_products_lt_lt`.* ,`lelwf_virtuemart_product_manufacturers`.`virtuemart_manufacturer_id` ,`lelwf_virtuemart_product_customfields`.`virtuemart_customfield_id`
FROM `lelwf_virtuemart_products`
INNER JOIN `lelwf_virtuemart_products_lt_lt` using (`virtuemart_product_id`)
LEFT JOIN `lelwf_virtuemart_product_manufacturers`
on `lelwf_virtuemart_product_manufacturers`.`virtuemart_product_id`=`lelwf_virtuemart_products`.`virtuemart_product_id`
LEFT JOIN `lelwf_virtuemart_product_customfields`
on `lelwf_virtuemart_product_customfields`.`virtuemart_product_id`=`lelwf_virtuemart_products`.`virtuemart_product_id`
WHERE `lelwf_virtuemart_products`.`virtuemart_product_id` = "951"
SELECT `virtuemart_media_id`
FROM `lelwf_virtuemart_product_medias`
WHERE `virtuemart_product_id` = "951"
ORDER BY `ordering`
SELECT `virtuemart_shoppergroup_id`
FROM `lelwf_virtuemart_product_shoppergroups`
WHERE `virtuemart_product_id` = "951"
SELECT *
FROM `lelwf_virtuemart_product_prices`
WHERE `virtuemart_product_id` = "951"
AND ( `virtuemart_shoppergroup_id` ="1" OR `virtuemart_shoppergroup_id` IS NULL OR `virtuemart_shoppergroup_id`="0")
AND ( (`product_price_publish_up` IS NULL OR `product_price_publish_up` = "0000-00-00 00:00:00" OR `product_price_publish_up` <= "2025-01-14 02:51:41" )
AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2025-01-14 02:51:41" ) )
AND( (`price_quantity_start` IS NULL OR `price_quantity_start`="0" OR `price_quantity_start` <= 1)
AND (`price_quantity_end` IS NULL OR `price_quantity_end`="0" OR `price_quantity_end` >= 1) )
SELECT pc.`virtuemart_category_id`
FROM `lelwf_virtuemart_product_categories` as pc
WHERE pc.`virtuemart_product_id` = 951
SELECT pc.`virtuemart_category_id`
FROM `lelwf_virtuemart_product_categories` as pc
LEFT JOIN `lelwf_virtuemart_categories` as c
ON c.`virtuemart_category_id` = pc.`virtuemart_category_id`
WHERE pc.`virtuemart_product_id` = 951
AND `published`=1
ORDER BY `c`.`ordering` ASC
SELECT `ordering`,`id`
FROM `lelwf_virtuemart_product_categories`
WHERE `virtuemart_product_id` = "951"
and `virtuemart_category_id`= "166"
SELECT `lelwf_virtuemart_categories`.* ,`lelwf_virtuemart_categories_lt_lt`.*
FROM `lelwf_virtuemart_categories`
INNER JOIN `lelwf_virtuemart_categories_lt_lt` using (`virtuemart_category_id`)
WHERE `lelwf_virtuemart_categories`.`virtuemart_category_id` = "166"
SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
FROM lelwf_virtuemart_category_categories AS `xref`
WHERE `xref`.`category_child_id`= 166
SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
FROM lelwf_virtuemart_category_categories AS `xref`
WHERE `xref`.`category_child_id`= 77
SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
FROM lelwf_virtuemart_category_categories AS `xref`
WHERE `xref`.`category_child_id`= 50
SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
FROM lelwf_virtuemart_category_categories AS `xref`
WHERE `xref`.`category_child_id`= 166
SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
FROM lelwf_virtuemart_category_categories AS `xref`
WHERE `xref`.`category_child_id`= 77
SELECT `slug` as name
FROM `lelwf_virtuemart_categories_lt_lt`
WHERE `virtuemart_category_id`=77
SELECT `slug` as name
FROM `lelwf_virtuemart_categories_lt_lt`
WHERE `virtuemart_category_id`=166
SELECT `slug`
FROM `lelwf_virtuemart_products_lt_lt`
WHERE `virtuemart_product_id` = 951
SELECT `lelwf_virtuemart_products`.* ,`lelwf_virtuemart_products_lt_lt`.* ,`lelwf_virtuemart_product_manufacturers`.`virtuemart_manufacturer_id` ,`lelwf_virtuemart_product_customfields`.`virtuemart_customfield_id`
FROM `lelwf_virtuemart_products`
INNER JOIN `lelwf_virtuemart_products_lt_lt` using (`virtuemart_product_id`)
LEFT JOIN `lelwf_virtuemart_product_manufacturers`
on `lelwf_virtuemart_product_manufacturers`.`virtuemart_product_id`=`lelwf_virtuemart_products`.`virtuemart_product_id`
LEFT JOIN `lelwf_virtuemart_product_customfields`
on `lelwf_virtuemart_product_customfields`.`virtuemart_product_id`=`lelwf_virtuemart_products`.`virtuemart_product_id`
WHERE `lelwf_virtuemart_products`.`virtuemart_product_id` = "318"
SELECT `virtuemart_media_id`
FROM `lelwf_virtuemart_product_medias`
WHERE `virtuemart_product_id` = "318"
ORDER BY `ordering`
SELECT `virtuemart_shoppergroup_id`
FROM `lelwf_virtuemart_product_shoppergroups`
WHERE `virtuemart_product_id` = "318"
SELECT *
FROM `lelwf_virtuemart_product_prices`
WHERE `virtuemart_product_id` = "318"
AND ( `virtuemart_shoppergroup_id` ="1" OR `virtuemart_shoppergroup_id` IS NULL OR `virtuemart_shoppergroup_id`="0")
AND ( (`product_price_publish_up` IS NULL OR `product_price_publish_up` = "0000-00-00 00:00:00" OR `product_price_publish_up` <= "2025-01-14 02:51:41" )
AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2025-01-14 02:51:41" ) )
AND( (`price_quantity_start` IS NULL OR `price_quantity_start`="0" OR `price_quantity_start` <= 1)
AND (`price_quantity_end` IS NULL OR `price_quantity_end`="0" OR `price_quantity_end` >= 1) )
SELECT pc.`virtuemart_category_id`
FROM `lelwf_virtuemart_product_categories` as pc
WHERE pc.`virtuemart_product_id` = 318
SELECT pc.`virtuemart_category_id`
FROM `lelwf_virtuemart_product_categories` as pc
LEFT JOIN `lelwf_virtuemart_categories` as c
ON c.`virtuemart_category_id` = pc.`virtuemart_category_id`
WHERE pc.`virtuemart_product_id` = 318
AND `published`=1
ORDER BY `c`.`ordering` ASC
SELECT `ordering`,`id`
FROM `lelwf_virtuemart_product_categories`
WHERE `virtuemart_product_id` = "318"
and `virtuemart_category_id`= "159"
SELECT `lelwf_virtuemart_categories`.* ,`lelwf_virtuemart_categories_lt_lt`.*
FROM `lelwf_virtuemart_categories`
INNER JOIN `lelwf_virtuemart_categories_lt_lt` using (`virtuemart_category_id`)
WHERE `lelwf_virtuemart_categories`.`virtuemart_category_id` = "159"
SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
FROM lelwf_virtuemart_category_categories AS `xref`
WHERE `xref`.`category_child_id`= 159
SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
FROM lelwf_virtuemart_category_categories AS `xref`
WHERE `xref`.`category_child_id`= 45
SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
FROM lelwf_virtuemart_category_categories AS `xref`
WHERE `xref`.`category_child_id`= 50
SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
FROM lelwf_virtuemart_category_categories AS `xref`
WHERE `xref`.`category_child_id`= 159
SELECT `slug` as name
FROM `lelwf_virtuemart_categories_lt_lt`
WHERE `virtuemart_category_id`=159
SELECT `slug`
FROM `lelwf_virtuemart_products_lt_lt`
WHERE `virtuemart_product_id` = 318
SELECT `lelwf_virtuemart_products`.* ,`lelwf_virtuemart_products_lt_lt`.* ,`lelwf_virtuemart_product_manufacturers`.`virtuemart_manufacturer_id` ,`lelwf_virtuemart_product_customfields`.`virtuemart_customfield_id`
FROM `lelwf_virtuemart_products`
INNER JOIN `lelwf_virtuemart_products_lt_lt` using (`virtuemart_product_id`)
LEFT JOIN `lelwf_virtuemart_product_manufacturers`
on `lelwf_virtuemart_product_manufacturers`.`virtuemart_product_id`=`lelwf_virtuemart_products`.`virtuemart_product_id`
LEFT JOIN `lelwf_virtuemart_product_customfields`
on `lelwf_virtuemart_product_customfields`.`virtuemart_product_id`=`lelwf_virtuemart_products`.`virtuemart_product_id`
WHERE `lelwf_virtuemart_products`.`virtuemart_product_id` = "895"
SELECT `virtuemart_media_id`
FROM `lelwf_virtuemart_product_medias`
WHERE `virtuemart_product_id` = "895"
ORDER BY `ordering`
SELECT `virtuemart_shoppergroup_id`
FROM `lelwf_virtuemart_product_shoppergroups`
WHERE `virtuemart_product_id` = "895"
SELECT *
FROM `lelwf_virtuemart_product_prices`
WHERE `virtuemart_product_id` = "895"
AND ( `virtuemart_shoppergroup_id` ="1" OR `virtuemart_shoppergroup_id` IS NULL OR `virtuemart_shoppergroup_id`="0")
AND ( (`product_price_publish_up` IS NULL OR `product_price_publish_up` = "0000-00-00 00:00:00" OR `product_price_publish_up` <= "2025-01-14 02:51:41" )
AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2025-01-14 02:51:41" ) )
AND( (`price_quantity_start` IS NULL OR `price_quantity_start`="0" OR `price_quantity_start` <= 1)
AND (`price_quantity_end` IS NULL OR `price_quantity_end`="0" OR `price_quantity_end` >= 1) )
SELECT pc.`virtuemart_category_id`
FROM `lelwf_virtuemart_product_categories` as pc
WHERE pc.`virtuemart_product_id` = 895
SELECT pc.`virtuemart_category_id`
FROM `lelwf_virtuemart_product_categories` as pc
LEFT JOIN `lelwf_virtuemart_categories` as c
ON c.`virtuemart_category_id` = pc.`virtuemart_category_id`
WHERE pc.`virtuemart_product_id` = 895
AND `published`=1
ORDER BY `c`.`ordering` ASC
SELECT `ordering`,`id`
FROM `lelwf_virtuemart_product_categories`
WHERE `virtuemart_product_id` = "895"
and `virtuemart_category_id`= "83"
SELECT `lelwf_virtuemart_categories`.* ,`lelwf_virtuemart_categories_lt_lt`.*
FROM `lelwf_virtuemart_categories`
INNER JOIN `lelwf_virtuemart_categories_lt_lt` using (`virtuemart_category_id`)
WHERE `lelwf_virtuemart_categories`.`virtuemart_category_id` = "83"
SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
FROM lelwf_virtuemart_category_categories AS `xref`
WHERE `xref`.`category_child_id`= 83
SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
FROM lelwf_virtuemart_category_categories AS `xref`
WHERE `xref`.`category_child_id`= 50
SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
FROM lelwf_virtuemart_category_categories AS `xref`
WHERE `xref`.`category_child_id`= 83
SELECT `slug` as name
FROM `lelwf_virtuemart_categories_lt_lt`
WHERE `virtuemart_category_id`=83
SELECT `slug`
FROM `lelwf_virtuemart_products_lt_lt`
WHERE `virtuemart_product_id` = 895
SELECT `lelwf_virtuemart_products`.* ,`lelwf_virtuemart_products_lt_lt`.* ,`lelwf_virtuemart_product_manufacturers`.`virtuemart_manufacturer_id` ,`lelwf_virtuemart_product_customfields`.`virtuemart_customfield_id`
FROM `lelwf_virtuemart_products`
INNER JOIN `lelwf_virtuemart_products_lt_lt` using (`virtuemart_product_id`)
LEFT JOIN `lelwf_virtuemart_product_manufacturers`
on `lelwf_virtuemart_product_manufacturers`.`virtuemart_product_id`=`lelwf_virtuemart_products`.`virtuemart_product_id`
LEFT JOIN `lelwf_virtuemart_product_customfields`
on `lelwf_virtuemart_product_customfields`.`virtuemart_product_id`=`lelwf_virtuemart_products`.`virtuemart_product_id`
WHERE `lelwf_virtuemart_products`.`virtuemart_product_id` = "134"
SELECT `virtuemart_media_id`
FROM `lelwf_virtuemart_product_medias`
WHERE `virtuemart_product_id` = "134"
ORDER BY `ordering`
SELECT `virtuemart_shoppergroup_id`
FROM `lelwf_virtuemart_product_shoppergroups`
WHERE `virtuemart_product_id` = "134"
SELECT *
FROM `lelwf_virtuemart_product_prices`
WHERE `virtuemart_product_id` = "134"
AND ( `virtuemart_shoppergroup_id` ="1" OR `virtuemart_shoppergroup_id` IS NULL OR `virtuemart_shoppergroup_id`="0")
AND ( (`product_price_publish_up` IS NULL OR `product_price_publish_up` = "0000-00-00 00:00:00" OR `product_price_publish_up` <= "2025-01-14 02:51:41" )
AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2025-01-14 02:51:41" ) )
AND( (`price_quantity_start` IS NULL OR `price_quantity_start`="0" OR `price_quantity_start` <= 1)
AND (`price_quantity_end` IS NULL OR `price_quantity_end`="0" OR `price_quantity_end` >= 1) )
SELECT pc.`virtuemart_category_id`
FROM `lelwf_virtuemart_product_categories` as pc
WHERE pc.`virtuemart_product_id` = 134
SELECT pc.`virtuemart_category_id`
FROM `lelwf_virtuemart_product_categories` as pc
LEFT JOIN `lelwf_virtuemart_categories` as c
ON c.`virtuemart_category_id` = pc.`virtuemart_category_id`
WHERE pc.`virtuemart_product_id` = 134
AND `published`=1
ORDER BY `c`.`ordering` ASC
SELECT `ordering`,`id`
FROM `lelwf_virtuemart_product_categories`
WHERE `virtuemart_product_id` = "134"
and `virtuemart_category_id`= "80"
SELECT `slug`
FROM `lelwf_virtuemart_products_lt_lt`
WHERE `virtuemart_product_id` = 134
SELECT `lelwf_virtuemart_products`.* ,`lelwf_virtuemart_products_lt_lt`.* ,`lelwf_virtuemart_product_manufacturers`.`virtuemart_manufacturer_id` ,`lelwf_virtuemart_product_customfields`.`virtuemart_customfield_id`
FROM `lelwf_virtuemart_products`
INNER JOIN `lelwf_virtuemart_products_lt_lt` using (`virtuemart_product_id`)
LEFT JOIN `lelwf_virtuemart_product_manufacturers`
on `lelwf_virtuemart_product_manufacturers`.`virtuemart_product_id`=`lelwf_virtuemart_products`.`virtuemart_product_id`
LEFT JOIN `lelwf_virtuemart_product_customfields`
on `lelwf_virtuemart_product_customfields`.`virtuemart_product_id`=`lelwf_virtuemart_products`.`virtuemart_product_id`
WHERE `lelwf_virtuemart_products`.`virtuemart_product_id` = "1496"
SELECT `virtuemart_media_id`
FROM `lelwf_virtuemart_product_medias`
WHERE `virtuemart_product_id` = "1496"
ORDER BY `ordering`
SELECT `virtuemart_shoppergroup_id`
FROM `lelwf_virtuemart_product_shoppergroups`
WHERE `virtuemart_product_id` = "1496"
SELECT *
FROM `lelwf_virtuemart_product_prices`
WHERE `virtuemart_product_id` = "1496"
AND ( `virtuemart_shoppergroup_id` ="1" OR `virtuemart_shoppergroup_id` IS NULL OR `virtuemart_shoppergroup_id`="0")
AND ( (`product_price_publish_up` IS NULL OR `product_price_publish_up` = "0000-00-00 00:00:00" OR `product_price_publish_up` <= "2025-01-14 02:51:41" )
AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2025-01-14 02:51:41" ) )
AND( (`price_quantity_start` IS NULL OR `price_quantity_start`="0" OR `price_quantity_start` <= 1)
AND (`price_quantity_end` IS NULL OR `price_quantity_end`="0" OR `price_quantity_end` >= 1) )
SELECT pc.`virtuemart_category_id`
FROM `lelwf_virtuemart_product_categories` as pc
WHERE pc.`virtuemart_product_id` = 1496
SELECT pc.`virtuemart_category_id`
FROM `lelwf_virtuemart_product_categories` as pc
LEFT JOIN `lelwf_virtuemart_categories` as c
ON c.`virtuemart_category_id` = pc.`virtuemart_category_id`
WHERE pc.`virtuemart_product_id` = 1496
AND `published`=1
ORDER BY `c`.`ordering` ASC
SELECT `ordering`,`id`
FROM `lelwf_virtuemart_product_categories`
WHERE `virtuemart_product_id` = "1496"
and `virtuemart_category_id`= "78"
SELECT `lelwf_virtuemart_categories`.* ,`lelwf_virtuemart_categories_lt_lt`.*
FROM `lelwf_virtuemart_categories`
INNER JOIN `lelwf_virtuemart_categories_lt_lt` using (`virtuemart_category_id`)
WHERE `lelwf_virtuemart_categories`.`virtuemart_category_id` = "78"
SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
FROM lelwf_virtuemart_category_categories AS `xref`
WHERE `xref`.`category_child_id`= 78
SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
FROM lelwf_virtuemart_category_categories AS `xref`
WHERE `xref`.`category_child_id`= 76
SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
FROM lelwf_virtuemart_category_categories AS `xref`
WHERE `xref`.`category_child_id`= 50
SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
FROM lelwf_virtuemart_category_categories AS `xref`
WHERE `xref`.`category_child_id`= 78
SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
FROM lelwf_virtuemart_category_categories AS `xref`
WHERE `xref`.`category_child_id`= 76
SELECT `slug` as name
FROM `lelwf_virtuemart_categories_lt_lt`
WHERE `virtuemart_category_id`=78
SELECT `slug`
FROM `lelwf_virtuemart_products_lt_lt`
WHERE `virtuemart_product_id` = 1496
SELECT `lelwf_virtuemart_products`.* ,`lelwf_virtuemart_products_lt_lt`.* ,`lelwf_virtuemart_product_manufacturers`.`virtuemart_manufacturer_id` ,`lelwf_virtuemart_product_customfields`.`virtuemart_customfield_id`
FROM `lelwf_virtuemart_products`
INNER JOIN `lelwf_virtuemart_products_lt_lt` using (`virtuemart_product_id`)
LEFT JOIN `lelwf_virtuemart_product_manufacturers`
on `lelwf_virtuemart_product_manufacturers`.`virtuemart_product_id`=`lelwf_virtuemart_products`.`virtuemart_product_id`
LEFT JOIN `lelwf_virtuemart_product_customfields`
on `lelwf_virtuemart_product_customfields`.`virtuemart_product_id`=`lelwf_virtuemart_products`.`virtuemart_product_id`
WHERE `lelwf_virtuemart_products`.`virtuemart_product_id` = "417"
SELECT `virtuemart_media_id`
FROM `lelwf_virtuemart_product_medias`
WHERE `virtuemart_product_id` = "417"
ORDER BY `ordering`
SELECT `virtuemart_shoppergroup_id`
FROM `lelwf_virtuemart_product_shoppergroups`
WHERE `virtuemart_product_id` = "417"
SELECT *
FROM `lelwf_virtuemart_product_prices`
WHERE `virtuemart_product_id` = "417"
AND ( `virtuemart_shoppergroup_id` ="1" OR `virtuemart_shoppergroup_id` IS NULL OR `virtuemart_shoppergroup_id`="0")
AND ( (`product_price_publish_up` IS NULL OR `product_price_publish_up` = "0000-00-00 00:00:00" OR `product_price_publish_up` <= "2025-01-14 02:51:41" )
AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2025-01-14 02:51:41" ) )
AND( (`price_quantity_start` IS NULL OR `price_quantity_start`="0" OR `price_quantity_start` <= 1)
AND (`price_quantity_end` IS NULL OR `price_quantity_end`="0" OR `price_quantity_end` >= 1) )
SELECT pc.`virtuemart_category_id`
FROM `lelwf_virtuemart_product_categories` as pc
WHERE pc.`virtuemart_product_id` = 417
SELECT pc.`virtuemart_category_id`
FROM `lelwf_virtuemart_product_categories` as pc
LEFT JOIN `lelwf_virtuemart_categories` as c
ON c.`virtuemart_category_id` = pc.`virtuemart_category_id`
WHERE pc.`virtuemart_product_id` = 417
AND `published`=1
ORDER BY `c`.`ordering` ASC
SELECT `ordering`,`id`
FROM `lelwf_virtuemart_product_categories`
WHERE `virtuemart_product_id` = "417"
and `virtuemart_category_id`= "64"
SELECT `lelwf_virtuemart_categories`.* ,`lelwf_virtuemart_categories_lt_lt`.*
FROM `lelwf_virtuemart_categories`
INNER JOIN `lelwf_virtuemart_categories_lt_lt` using (`virtuemart_category_id`)
WHERE `lelwf_virtuemart_categories`.`virtuemart_category_id` = "64"
SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
FROM lelwf_virtuemart_category_categories AS `xref`
WHERE `xref`.`category_child_id`= 64
SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
FROM lelwf_virtuemart_category_categories AS `xref`
WHERE `xref`.`category_child_id`= 61
SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
FROM lelwf_virtuemart_category_categories AS `xref`
WHERE `xref`.`category_child_id`= 55
SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
FROM lelwf_virtuemart_category_categories AS `xref`
WHERE `xref`.`category_child_id`= 50
SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
FROM lelwf_virtuemart_category_categories AS `xref`
WHERE `xref`.`category_child_id`= 64
SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
FROM lelwf_virtuemart_category_categories AS `xref`
WHERE `xref`.`category_child_id`= 61
SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
FROM lelwf_virtuemart_category_categories AS `xref`
WHERE `xref`.`category_child_id`= 55
SELECT `slug` as name
FROM `lelwf_virtuemart_categories_lt_lt`
WHERE `virtuemart_category_id`=64
SELECT `slug`
FROM `lelwf_virtuemart_products_lt_lt`
WHERE `virtuemart_product_id` = 417
SELECT `lelwf_virtuemart_products`.* ,`lelwf_virtuemart_products_lt_lt`.* ,`lelwf_virtuemart_product_manufacturers`.`virtuemart_manufacturer_id` ,`lelwf_virtuemart_product_customfields`.`virtuemart_customfield_id`
FROM `lelwf_virtuemart_products`
INNER JOIN `lelwf_virtuemart_products_lt_lt` using (`virtuemart_product_id`)
LEFT JOIN `lelwf_virtuemart_product_manufacturers`
on `lelwf_virtuemart_product_manufacturers`.`virtuemart_product_id`=`lelwf_virtuemart_products`.`virtuemart_product_id`
LEFT JOIN `lelwf_virtuemart_product_customfields`
on `lelwf_virtuemart_product_customfields`.`virtuemart_product_id`=`lelwf_virtuemart_products`.`virtuemart_product_id`
WHERE `lelwf_virtuemart_products`.`virtuemart_product_id` = "1340"
SELECT `virtuemart_media_id`
FROM `lelwf_virtuemart_product_medias`
WHERE `virtuemart_product_id` = "1340"
ORDER BY `ordering`
SELECT `virtuemart_shoppergroup_id`
FROM `lelwf_virtuemart_product_shoppergroups`
WHERE `virtuemart_product_id` = "1340"
SELECT *
FROM `lelwf_virtuemart_product_prices`
WHERE `virtuemart_product_id` = "1340"
AND ( `virtuemart_shoppergroup_id` ="1" OR `virtuemart_shoppergroup_id` IS NULL OR `virtuemart_shoppergroup_id`="0")
AND ( (`product_price_publish_up` IS NULL OR `product_price_publish_up` = "0000-00-00 00:00:00" OR `product_price_publish_up` <= "2025-01-14 02:51:41" )
AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2025-01-14 02:51:41" ) )
AND( (`price_quantity_start` IS NULL OR `price_quantity_start`="0" OR `price_quantity_start` <= 1)
AND (`price_quantity_end` IS NULL OR `price_quantity_end`="0" OR `price_quantity_end` >= 1) )
SELECT pc.`virtuemart_category_id`
FROM `lelwf_virtuemart_product_categories` as pc
WHERE pc.`virtuemart_product_id` = 1340
SELECT pc.`virtuemart_category_id`
FROM `lelwf_virtuemart_product_categories` as pc
LEFT JOIN `lelwf_virtuemart_categories` as c
ON c.`virtuemart_category_id` = pc.`virtuemart_category_id`
WHERE pc.`virtuemart_product_id` = 1340
AND `published`=1
ORDER BY `c`.`ordering` ASC
SELECT `ordering`,`id`
FROM `lelwf_virtuemart_product_categories`
WHERE `virtuemart_product_id` = "1340"
and `virtuemart_category_id`= "165"
SELECT `lelwf_virtuemart_categories`.* ,`lelwf_virtuemart_categories_lt_lt`.*
FROM `lelwf_virtuemart_categories`
INNER JOIN `lelwf_virtuemart_categories_lt_lt` using (`virtuemart_category_id`)
WHERE `lelwf_virtuemart_categories`.`virtuemart_category_id` = "165"
SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
FROM lelwf_virtuemart_category_categories AS `xref`
WHERE `xref`.`category_child_id`= 165
SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
FROM lelwf_virtuemart_category_categories AS `xref`
WHERE `xref`.`category_child_id`= 50
SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
FROM lelwf_virtuemart_category_categories AS `xref`
WHERE `xref`.`category_child_id`= 165
SELECT `slug` as name
FROM `lelwf_virtuemart_categories_lt_lt`
WHERE `virtuemart_category_id`=165
SELECT `slug`
FROM `lelwf_virtuemart_products_lt_lt`
WHERE `virtuemart_product_id` = 1340
SELECT `lelwf_virtuemart_products`.* ,`lelwf_virtuemart_products_lt_lt`.* ,`lelwf_virtuemart_product_manufacturers`.`virtuemart_manufacturer_id` ,`lelwf_virtuemart_product_customfields`.`virtuemart_customfield_id`
FROM `lelwf_virtuemart_products`
INNER JOIN `lelwf_virtuemart_products_lt_lt` using (`virtuemart_product_id`)
LEFT JOIN `lelwf_virtuemart_product_manufacturers`
on `lelwf_virtuemart_product_manufacturers`.`virtuemart_product_id`=`lelwf_virtuemart_products`.`virtuemart_product_id`
LEFT JOIN `lelwf_virtuemart_product_customfields`
on `lelwf_virtuemart_product_customfields`.`virtuemart_product_id`=`lelwf_virtuemart_products`.`virtuemart_product_id`
WHERE `lelwf_virtuemart_products`.`virtuemart_product_id` = "1299"
SELECT `virtuemart_media_id`
FROM `lelwf_virtuemart_product_medias`
WHERE `virtuemart_product_id` = "1299"
ORDER BY `ordering`
SELECT `virtuemart_shoppergroup_id`
FROM `lelwf_virtuemart_product_shoppergroups`
WHERE `virtuemart_product_id` = "1299"
SELECT *
FROM `lelwf_virtuemart_product_prices`
WHERE `virtuemart_product_id` = "1299"
AND ( `virtuemart_shoppergroup_id` ="1" OR `virtuemart_shoppergroup_id` IS NULL OR `virtuemart_shoppergroup_id`="0")
AND ( (`product_price_publish_up` IS NULL OR `product_price_publish_up` = "0000-00-00 00:00:00" OR `product_price_publish_up` <= "2025-01-14 02:51:41" )
AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2025-01-14 02:51:41" ) )
AND( (`price_quantity_start` IS NULL OR `price_quantity_start`="0" OR `price_quantity_start` <= 1)
AND (`price_quantity_end` IS NULL OR `price_quantity_end`="0" OR `price_quantity_end` >= 1) )
SELECT pc.`virtuemart_category_id`
FROM `lelwf_virtuemart_product_categories` as pc
WHERE pc.`virtuemart_product_id` = 1299
SELECT pc.`virtuemart_category_id`
FROM `lelwf_virtuemart_product_categories` as pc
LEFT JOIN `lelwf_virtuemart_categories` as c
ON c.`virtuemart_category_id` = pc.`virtuemart_category_id`
WHERE pc.`virtuemart_product_id` = 1299
AND `published`=1
ORDER BY `c`.`ordering` ASC
SELECT `ordering`,`id`
FROM `lelwf_virtuemart_product_categories`
WHERE `virtuemart_product_id` = "1299"
and `virtuemart_category_id`= "66"
SELECT `slug`
FROM `lelwf_virtuemart_products_lt_lt`
WHERE `virtuemart_product_id` = 1299
SELECT `lelwf_virtuemart_products`.* ,`lelwf_virtuemart_products_lt_lt`.* ,`lelwf_virtuemart_product_manufacturers`.`virtuemart_manufacturer_id` ,`lelwf_virtuemart_product_customfields`.`virtuemart_customfield_id`
FROM `lelwf_virtuemart_products`
INNER JOIN `lelwf_virtuemart_products_lt_lt` using (`virtuemart_product_id`)
LEFT JOIN `lelwf_virtuemart_product_manufacturers`
on `lelwf_virtuemart_product_manufacturers`.`virtuemart_product_id`=`lelwf_virtuemart_products`.`virtuemart_product_id`
LEFT JOIN `lelwf_virtuemart_product_customfields`
on `lelwf_virtuemart_product_customfields`.`virtuemart_product_id`=`lelwf_virtuemart_products`.`virtuemart_product_id`
WHERE `lelwf_virtuemart_products`.`virtuemart_product_id` = "1113"
SELECT `virtuemart_media_id`
FROM `lelwf_virtuemart_product_medias`
WHERE `virtuemart_product_id` = "1113"
ORDER BY `ordering`
SELECT `virtuemart_shoppergroup_id`
FROM `lelwf_virtuemart_product_shoppergroups`
WHERE `virtuemart_product_id` = "1113"
SELECT *
FROM `lelwf_virtuemart_product_prices`
WHERE `virtuemart_product_id` = "1113"
AND ( `virtuemart_shoppergroup_id` ="1" OR `virtuemart_shoppergroup_id` IS NULL OR `virtuemart_shoppergroup_id`="0")
AND ( (`product_price_publish_up` IS NULL OR `product_price_publish_up` = "0000-00-00 00:00:00" OR `product_price_publish_up` <= "2025-01-14 02:51:41" )
AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2025-01-14 02:51:41" ) )
AND( (`price_quantity_start` IS NULL OR `price_quantity_start`="0" OR `price_quantity_start` <= 1)
AND (`price_quantity_end` IS NULL OR `price_quantity_end`="0" OR `price_quantity_end` >= 1) )
SELECT pc.`virtuemart_category_id`
FROM `lelwf_virtuemart_product_categories` as pc
WHERE pc.`virtuemart_product_id` = 1113
SELECT pc.`virtuemart_category_id`
FROM `lelwf_virtuemart_product_categories` as pc
LEFT JOIN `lelwf_virtuemart_categories` as c
ON c.`virtuemart_category_id` = pc.`virtuemart_category_id`
WHERE pc.`virtuemart_product_id` = 1113
AND `published`=1
ORDER BY `c`.`ordering` ASC
SELECT `ordering`,`id`
FROM `lelwf_virtuemart_product_categories`
WHERE `virtuemart_product_id` = "1113"
and `virtuemart_category_id`= "122"
SELECT `lelwf_virtuemart_categories`.* ,`lelwf_virtuemart_categories_lt_lt`.*
FROM `lelwf_virtuemart_categories`
INNER JOIN `lelwf_virtuemart_categories_lt_lt` using (`virtuemart_category_id`)
WHERE `lelwf_virtuemart_categories`.`virtuemart_category_id` = "122"
SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
FROM lelwf_virtuemart_category_categories AS `xref`
WHERE `xref`.`category_child_id`= 122
SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
FROM lelwf_virtuemart_category_categories AS `xref`
WHERE `xref`.`category_child_id`= 104
SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
FROM lelwf_virtuemart_category_categories AS `xref`
WHERE `xref`.`category_child_id`= 48
SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
FROM lelwf_virtuemart_category_categories AS `xref`
WHERE `xref`.`category_child_id`= 50
SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
FROM lelwf_virtuemart_category_categories AS `xref`
WHERE `xref`.`category_child_id`= 122
SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
FROM lelwf_virtuemart_category_categories AS `xref`
WHERE `xref`.`category_child_id`= 104
SELECT `slug` as name
FROM `lelwf_virtuemart_categories_lt_lt`
WHERE `virtuemart_category_id`=104
SELECT `slug` as name
FROM `lelwf_virtuemart_categories_lt_lt`
WHERE `virtuemart_category_id`=122
SELECT `slug`
FROM `lelwf_virtuemart_products_lt_lt`
WHERE `virtuemart_product_id` = 1113
SELECT `lelwf_virtuemart_products`.* ,`lelwf_virtuemart_products_lt_lt`.* ,`lelwf_virtuemart_product_manufacturers`.`virtuemart_manufacturer_id` ,`lelwf_virtuemart_product_customfields`.`virtuemart_customfield_id`
FROM `lelwf_virtuemart_products`
INNER JOIN `lelwf_virtuemart_products_lt_lt` using (`virtuemart_product_id`)
LEFT JOIN `lelwf_virtuemart_product_manufacturers`
on `lelwf_virtuemart_product_manufacturers`.`virtuemart_product_id`=`lelwf_virtuemart_products`.`virtuemart_product_id`
LEFT JOIN `lelwf_virtuemart_product_customfields`
on `lelwf_virtuemart_product_customfields`.`virtuemart_product_id`=`lelwf_virtuemart_products`.`virtuemart_product_id`
WHERE `lelwf_virtuemart_products`.`virtuemart_product_id` = "1014"
SELECT `virtuemart_media_id`
FROM `lelwf_virtuemart_product_medias`
WHERE `virtuemart_product_id` = "1014"
ORDER BY `ordering`
SELECT `virtuemart_shoppergroup_id`
FROM `lelwf_virtuemart_product_shoppergroups`
WHERE `virtuemart_product_id` = "1014"
SELECT *
FROM `lelwf_virtuemart_product_prices`
WHERE `virtuemart_product_id` = "1014"
AND ( `virtuemart_shoppergroup_id` ="1" OR `virtuemart_shoppergroup_id` IS NULL OR `virtuemart_shoppergroup_id`="0")
AND ( (`product_price_publish_up` IS NULL OR `product_price_publish_up` = "0000-00-00 00:00:00" OR `product_price_publish_up` <= "2025-01-14 02:51:41" )
AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2025-01-14 02:51:41" ) )
AND( (`price_quantity_start` IS NULL OR `price_quantity_start`="0" OR `price_quantity_start` <= 1)
AND (`price_quantity_end` IS NULL OR `price_quantity_end`="0" OR `price_quantity_end` >= 1) )
SELECT pc.`virtuemart_category_id`
FROM `lelwf_virtuemart_product_categories` as pc
WHERE pc.`virtuemart_product_id` = 1014
SELECT pc.`virtuemart_category_id`
FROM `lelwf_virtuemart_product_categories` as pc
LEFT JOIN `lelwf_virtuemart_categories` as c
ON c.`virtuemart_category_id` = pc.`virtuemart_category_id`
WHERE pc.`virtuemart_product_id` = 1014
AND `published`=1
ORDER BY `c`.`ordering` ASC
SELECT `ordering`,`id`
FROM `lelwf_virtuemart_product_categories`
WHERE `virtuemart_product_id` = "1014"
and `virtuemart_category_id`= "82"
SELECT `lelwf_virtuemart_categories`.* ,`lelwf_virtuemart_categories_lt_lt`.*
FROM `lelwf_virtuemart_categories`
INNER JOIN `lelwf_virtuemart_categories_lt_lt` using (`virtuemart_category_id`)
WHERE `lelwf_virtuemart_categories`.`virtuemart_category_id` = "82"
SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
FROM lelwf_virtuemart_category_categories AS `xref`
WHERE `xref`.`category_child_id`= 82
SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
FROM lelwf_virtuemart_category_categories AS `xref`
WHERE `xref`.`category_child_id`= 76
SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
FROM lelwf_virtuemart_category_categories AS `xref`
WHERE `xref`.`category_child_id`= 50
SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
FROM lelwf_virtuemart_category_categories AS `xref`
WHERE `xref`.`category_child_id`= 82
SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
FROM lelwf_virtuemart_category_categories AS `xref`
WHERE `xref`.`category_child_id`= 76
SELECT `slug` as name
FROM `lelwf_virtuemart_categories_lt_lt`
WHERE `virtuemart_category_id`=82
SELECT `slug`
FROM `lelwf_virtuemart_products_lt_lt`
WHERE `virtuemart_product_id` = 1014
SELECT `lelwf_virtuemart_products`.* ,`lelwf_virtuemart_products_lt_lt`.* ,`lelwf_virtuemart_product_manufacturers`.`virtuemart_manufacturer_id` ,`lelwf_virtuemart_product_customfields`.`virtuemart_customfield_id`
FROM `lelwf_virtuemart_products`
INNER JOIN `lelwf_virtuemart_products_lt_lt` using (`virtuemart_product_id`)
LEFT JOIN `lelwf_virtuemart_product_manufacturers`
on `lelwf_virtuemart_product_manufacturers`.`virtuemart_product_id`=`lelwf_virtuemart_products`.`virtuemart_product_id`
LEFT JOIN `lelwf_virtuemart_product_customfields`
on `lelwf_virtuemart_product_customfields`.`virtuemart_product_id`=`lelwf_virtuemart_products`.`virtuemart_product_id`
WHERE `lelwf_virtuemart_products`.`virtuemart_product_id` = "1579"
SELECT `virtuemart_media_id`
FROM `lelwf_virtuemart_product_medias`
WHERE `virtuemart_product_id` = "1579"
ORDER BY `ordering`
SELECT `virtuemart_shoppergroup_id`
FROM `lelwf_virtuemart_product_shoppergroups`
WHERE `virtuemart_product_id` = "1579"
SELECT *
FROM `lelwf_virtuemart_product_prices`
WHERE `virtuemart_product_id` = "1579"
AND ( `virtuemart_shoppergroup_id` ="1" OR `virtuemart_shoppergroup_id` IS NULL OR `virtuemart_shoppergroup_id`="0")
AND ( (`product_price_publish_up` IS NULL OR `product_price_publish_up` = "0000-00-00 00:00:00" OR `product_price_publish_up` <= "2025-01-14 02:51:41" )
AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2025-01-14 02:51:41" ) )
AND( (`price_quantity_start` IS NULL OR `price_quantity_start`="0" OR `price_quantity_start` <= 1)
AND (`price_quantity_end` IS NULL OR `price_quantity_end`="0" OR `price_quantity_end` >= 1) )
SELECT pc.`virtuemart_category_id`
FROM `lelwf_virtuemart_product_categories` as pc
WHERE pc.`virtuemart_product_id` = 1579
SELECT pc.`virtuemart_category_id`
FROM `lelwf_virtuemart_product_categories` as pc
LEFT JOIN `lelwf_virtuemart_categories` as c
ON c.`virtuemart_category_id` = pc.`virtuemart_category_id`
WHERE pc.`virtuemart_product_id` = 1579
AND `published`=1
ORDER BY `c`.`ordering` ASC
SELECT `ordering`,`id`
FROM `lelwf_virtuemart_product_categories`
WHERE `virtuemart_product_id` = "1579"
and `virtuemart_category_id`= "83"
SELECT `slug`
FROM `lelwf_virtuemart_products_lt_lt`
WHERE `virtuemart_product_id` = 1579
SELECT `lelwf_virtuemart_products`.* ,`lelwf_virtuemart_products_lt_lt`.* ,`lelwf_virtuemart_product_manufacturers`.`virtuemart_manufacturer_id` ,`lelwf_virtuemart_product_customfields`.`virtuemart_customfield_id`
FROM `lelwf_virtuemart_products`
INNER JOIN `lelwf_virtuemart_products_lt_lt` using (`virtuemart_product_id`)
LEFT JOIN `lelwf_virtuemart_product_manufacturers`
on `lelwf_virtuemart_product_manufacturers`.`virtuemart_product_id`=`lelwf_virtuemart_products`.`virtuemart_product_id`
LEFT JOIN `lelwf_virtuemart_product_customfields`
on `lelwf_virtuemart_product_customfields`.`virtuemart_product_id`=`lelwf_virtuemart_products`.`virtuemart_product_id`
WHERE `lelwf_virtuemart_products`.`virtuemart_product_id` = "1301"
SELECT `virtuemart_media_id`
FROM `lelwf_virtuemart_product_medias`
WHERE `virtuemart_product_id` = "1301"
ORDER BY `ordering`
SELECT `virtuemart_shoppergroup_id`
FROM `lelwf_virtuemart_product_shoppergroups`
WHERE `virtuemart_product_id` = "1301"
SELECT *
FROM `lelwf_virtuemart_product_prices`
WHERE `virtuemart_product_id` = "1301"
AND ( `virtuemart_shoppergroup_id` ="1" OR `virtuemart_shoppergroup_id` IS NULL OR `virtuemart_shoppergroup_id`="0")
AND ( (`product_price_publish_up` IS NULL OR `product_price_publish_up` = "0000-00-00 00:00:00" OR `product_price_publish_up` <= "2025-01-14 02:51:41" )
AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2025-01-14 02:51:41" ) )
AND( (`price_quantity_start` IS NULL OR `price_quantity_start`="0" OR `price_quantity_start` <= 1)
AND (`price_quantity_end` IS NULL OR `price_quantity_end`="0" OR `price_quantity_end` >= 1) )
SELECT pc.`virtuemart_category_id`
FROM `lelwf_virtuemart_product_categories` as pc
WHERE pc.`virtuemart_product_id` = 1301
SELECT pc.`virtuemart_category_id`
FROM `lelwf_virtuemart_product_categories` as pc
LEFT JOIN `lelwf_virtuemart_categories` as c
ON c.`virtuemart_category_id` = pc.`virtuemart_category_id`
WHERE pc.`virtuemart_product_id` = 1301
AND `published`=1
ORDER BY `c`.`ordering` ASC
SELECT `ordering`,`id`
FROM `lelwf_virtuemart_product_categories`
WHERE `virtuemart_product_id` = "1301"
and `virtuemart_category_id`= "66"
SELECT `slug`
FROM `lelwf_virtuemart_products_lt_lt`
WHERE `virtuemart_product_id` = 1301
SELECT `lelwf_virtuemart_products`.* ,`lelwf_virtuemart_products_lt_lt`.* ,`lelwf_virtuemart_product_manufacturers`.`virtuemart_manufacturer_id` ,`lelwf_virtuemart_product_customfields`.`virtuemart_customfield_id`
FROM `lelwf_virtuemart_products`
INNER JOIN `lelwf_virtuemart_products_lt_lt` using (`virtuemart_product_id`)
LEFT JOIN `lelwf_virtuemart_product_manufacturers`
on `lelwf_virtuemart_product_manufacturers`.`virtuemart_product_id`=`lelwf_virtuemart_products`.`virtuemart_product_id`
LEFT JOIN `lelwf_virtuemart_product_customfields`
on `lelwf_virtuemart_product_customfields`.`virtuemart_product_id`=`lelwf_virtuemart_products`.`virtuemart_product_id`
WHERE `lelwf_virtuemart_products`.`virtuemart_product_id` = "245"
SELECT `virtuemart_media_id`
FROM `lelwf_virtuemart_product_medias`
WHERE `virtuemart_product_id` = "245"
ORDER BY `ordering`
SELECT `virtuemart_shoppergroup_id`
FROM `lelwf_virtuemart_product_shoppergroups`
WHERE `virtuemart_product_id` = "245"
SELECT *
FROM `lelwf_virtuemart_product_prices`
WHERE `virtuemart_product_id` = "245"
AND ( `virtuemart_shoppergroup_id` ="1" OR `virtuemart_shoppergroup_id` IS NULL OR `virtuemart_shoppergroup_id`="0")
AND ( (`product_price_publish_up` IS NULL OR `product_price_publish_up` = "0000-00-00 00:00:00" OR `product_price_publish_up` <= "2025-01-14 02:51:41" )
AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2025-01-14 02:51:41" ) )
AND( (`price_quantity_start` IS NULL OR `price_quantity_start`="0" OR `price_quantity_start` <= 1)
AND (`price_quantity_end` IS NULL OR `price_quantity_end`="0" OR `price_quantity_end` >= 1) )
SELECT pc.`virtuemart_category_id`
FROM `lelwf_virtuemart_product_categories` as pc
WHERE pc.`virtuemart_product_id` = 245
SELECT pc.`virtuemart_category_id`
FROM `lelwf_virtuemart_product_categories` as pc
LEFT JOIN `lelwf_virtuemart_categories` as c
ON c.`virtuemart_category_id` = pc.`virtuemart_category_id`
WHERE pc.`virtuemart_product_id` = 245
AND `published`=1
ORDER BY `c`.`ordering` ASC
SELECT `ordering`,`id`
FROM `lelwf_virtuemart_product_categories`
WHERE `virtuemart_product_id` = "245"
and `virtuemart_category_id`= "127"
SELECT `lelwf_virtuemart_categories`.* ,`lelwf_virtuemart_categories_lt_lt`.*
FROM `lelwf_virtuemart_categories`
INNER JOIN `lelwf_virtuemart_categories_lt_lt` using (`virtuemart_category_id`)
WHERE `lelwf_virtuemart_categories`.`virtuemart_category_id` = "127"
SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
FROM lelwf_virtuemart_category_categories AS `xref`
WHERE `xref`.`category_child_id`= 127
SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
FROM lelwf_virtuemart_category_categories AS `xref`
WHERE `xref`.`category_child_id`= 106
SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
FROM lelwf_virtuemart_category_categories AS `xref`
WHERE `xref`.`category_child_id`= 48
SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
FROM lelwf_virtuemart_category_categories AS `xref`
WHERE `xref`.`category_child_id`= 50
SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
FROM lelwf_virtuemart_category_categories AS `xref`
WHERE `xref`.`category_child_id`= 127
SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
FROM lelwf_virtuemart_category_categories AS `xref`
WHERE `xref`.`category_child_id`= 106
SELECT `slug` as name
FROM `lelwf_virtuemart_categories_lt_lt`
WHERE `virtuemart_category_id`=106
SELECT `slug` as name
FROM `lelwf_virtuemart_categories_lt_lt`
WHERE `virtuemart_category_id`=127
SELECT `slug`
FROM `lelwf_virtuemart_products_lt_lt`
WHERE `virtuemart_product_id` = 245
SELECT `lelwf_virtuemart_products`.* ,`lelwf_virtuemart_products_lt_lt`.* ,`lelwf_virtuemart_product_manufacturers`.`virtuemart_manufacturer_id` ,`lelwf_virtuemart_product_customfields`.`virtuemart_customfield_id`
FROM `lelwf_virtuemart_products`
INNER JOIN `lelwf_virtuemart_products_lt_lt` using (`virtuemart_product_id`)
LEFT JOIN `lelwf_virtuemart_product_manufacturers`
on `lelwf_virtuemart_product_manufacturers`.`virtuemart_product_id`=`lelwf_virtuemart_products`.`virtuemart_product_id`
LEFT JOIN `lelwf_virtuemart_product_customfields`
on `lelwf_virtuemart_product_customfields`.`virtuemart_product_id`=`lelwf_virtuemart_products`.`virtuemart_product_id`
WHERE `lelwf_virtuemart_products`.`virtuemart_product_id` = "337"
SELECT `virtuemart_media_id`
FROM `lelwf_virtuemart_product_medias`
WHERE `virtuemart_product_id` = "337"
ORDER BY `ordering`
SELECT `virtuemart_shoppergroup_id`
FROM `lelwf_virtuemart_product_shoppergroups`
WHERE `virtuemart_product_id` = "337"
SELECT *
FROM `lelwf_virtuemart_product_prices`
WHERE `virtuemart_product_id` = "337"
AND ( `virtuemart_shoppergroup_id` ="1" OR `virtuemart_shoppergroup_id` IS NULL OR `virtuemart_shoppergroup_id`="0")
AND ( (`product_price_publish_up` IS NULL OR `product_price_publish_up` = "0000-00-00 00:00:00" OR `product_price_publish_up` <= "2025-01-14 02:51:41" )
AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2025-01-14 02:51:41" ) )
AND( (`price_quantity_start` IS NULL OR `price_quantity_start`="0" OR `price_quantity_start` <= 1)
AND (`price_quantity_end` IS NULL OR `price_quantity_end`="0" OR `price_quantity_end` >= 1) )
SELECT pc.`virtuemart_category_id`
FROM `lelwf_virtuemart_product_categories` as pc
WHERE pc.`virtuemart_product_id` = 337
SELECT pc.`virtuemart_category_id`
FROM `lelwf_virtuemart_product_categories` as pc
LEFT JOIN `lelwf_virtuemart_categories` as c
ON c.`virtuemart_category_id` = pc.`virtuemart_category_id`
WHERE pc.`virtuemart_product_id` = 337
AND `published`=1
ORDER BY `c`.`ordering` ASC
SELECT `ordering`,`id`
FROM `lelwf_virtuemart_product_categories`
WHERE `virtuemart_product_id` = "337"
and `virtuemart_category_id`= "120"
SELECT `lelwf_virtuemart_categories`.* ,`lelwf_virtuemart_categories_lt_lt`.*
FROM `lelwf_virtuemart_categories`
INNER JOIN `lelwf_virtuemart_categories_lt_lt` using (`virtuemart_category_id`)
WHERE `lelwf_virtuemart_categories`.`virtuemart_category_id` = "120"
SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
FROM lelwf_virtuemart_category_categories AS `xref`
WHERE `xref`.`category_child_id`= 120
SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
FROM lelwf_virtuemart_category_categories AS `xref`
WHERE `xref`.`category_child_id`= 102
SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
FROM lelwf_virtuemart_category_categories AS `xref`
WHERE `xref`.`category_child_id`= 48
SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
FROM lelwf_virtuemart_category_categories AS `xref`
WHERE `xref`.`category_child_id`= 50
SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
FROM lelwf_virtuemart_category_categories AS `xref`
WHERE `xref`.`category_child_id`= 120
SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
FROM lelwf_virtuemart_category_categories AS `xref`
WHERE `xref`.`category_child_id`= 102
SELECT `slug` as name
FROM `lelwf_virtuemart_categories_lt_lt`
WHERE `virtuemart_category_id`=102
SELECT `slug` as name
FROM `lelwf_virtuemart_categories_lt_lt`
WHERE `virtuemart_category_id`=120
SELECT `slug`
FROM `lelwf_virtuemart_products_lt_lt`
WHERE `virtuemart_product_id` = 337
SELECT `lelwf_virtuemart_products`.* ,`lelwf_virtuemart_products_lt_lt`.* ,`lelwf_virtuemart_product_manufacturers`.`virtuemart_manufacturer_id` ,`lelwf_virtuemart_product_customfields`.`virtuemart_customfield_id`
FROM `lelwf_virtuemart_products`
INNER JOIN `lelwf_virtuemart_products_lt_lt` using (`virtuemart_product_id`)
LEFT JOIN `lelwf_virtuemart_product_manufacturers`
on `lelwf_virtuemart_product_manufacturers`.`virtuemart_product_id`=`lelwf_virtuemart_products`.`virtuemart_product_id`
LEFT JOIN `lelwf_virtuemart_product_customfields`
on `lelwf_virtuemart_product_customfields`.`virtuemart_product_id`=`lelwf_virtuemart_products`.`virtuemart_product_id`
WHERE `lelwf_virtuemart_products`.`virtuemart_product_id` = "1558"
SELECT `virtuemart_media_id`
FROM `lelwf_virtuemart_product_medias`
WHERE `virtuemart_product_id` = "1558"
ORDER BY `ordering`
SELECT `virtuemart_shoppergroup_id`
FROM `lelwf_virtuemart_product_shoppergroups`
WHERE `virtuemart_product_id` = "1558"
SELECT *
FROM `lelwf_virtuemart_product_prices`
WHERE `virtuemart_product_id` = "1558"
AND ( `virtuemart_shoppergroup_id` ="1" OR `virtuemart_shoppergroup_id` IS NULL OR `virtuemart_shoppergroup_id`="0")
AND ( (`product_price_publish_up` IS NULL OR `product_price_publish_up` = "0000-00-00 00:00:00" OR `product_price_publish_up` <= "2025-01-14 02:51:41" )
AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2025-01-14 02:51:41" ) )
AND( (`price_quantity_start` IS NULL OR `price_quantity_start`="0" OR `price_quantity_start` <= 1)
AND (`price_quantity_end` IS NULL OR `price_quantity_end`="0" OR `price_quantity_end` >= 1) )
SELECT pc.`virtuemart_category_id`
FROM `lelwf_virtuemart_product_categories` as pc
WHERE pc.`virtuemart_product_id` = 1558
SELECT pc.`virtuemart_category_id`
FROM `lelwf_virtuemart_product_categories` as pc
LEFT JOIN `lelwf_virtuemart_categories` as c
ON c.`virtuemart_category_id` = pc.`virtuemart_category_id`
WHERE pc.`virtuemart_product_id` = 1558
AND `published`=1
ORDER BY `c`.`ordering` ASC
SELECT `ordering`,`id`
FROM `lelwf_virtuemart_product_categories`
WHERE `virtuemart_product_id` = "1558"
and `virtuemart_category_id`= "82"
SELECT `slug`
FROM `lelwf_virtuemart_products_lt_lt`
WHERE `virtuemart_product_id` = 1558
SELECT `lelwf_virtuemart_products`.* ,`lelwf_virtuemart_products_lt_lt`.* ,`lelwf_virtuemart_product_manufacturers`.`virtuemart_manufacturer_id` ,`lelwf_virtuemart_product_customfields`.`virtuemart_customfield_id`
FROM `lelwf_virtuemart_products`
INNER JOIN `lelwf_virtuemart_products_lt_lt` using (`virtuemart_product_id`)
LEFT JOIN `lelwf_virtuemart_product_manufacturers`
on `lelwf_virtuemart_product_manufacturers`.`virtuemart_product_id`=`lelwf_virtuemart_products`.`virtuemart_product_id`
LEFT JOIN `lelwf_virtuemart_product_customfields`
on `lelwf_virtuemart_product_customfields`.`virtuemart_product_id`=`lelwf_virtuemart_products`.`virtuemart_product_id`
WHERE `lelwf_virtuemart_products`.`virtuemart_product_id` = "386"
SELECT `virtuemart_media_id`
FROM `lelwf_virtuemart_product_medias`
WHERE `virtuemart_product_id` = "386"
ORDER BY `ordering`
SELECT `virtuemart_shoppergroup_id`
FROM `lelwf_virtuemart_product_shoppergroups`
WHERE `virtuemart_product_id` = "386"
SELECT *
FROM `lelwf_virtuemart_product_prices`
WHERE `virtuemart_product_id` = "386"
AND ( `virtuemart_shoppergroup_id` ="1" OR `virtuemart_shoppergroup_id` IS NULL OR `virtuemart_shoppergroup_id`="0")
AND ( (`product_price_publish_up` IS NULL OR `product_price_publish_up` = "0000-00-00 00:00:00" OR `product_price_publish_up` <= "2025-01-14 02:51:41" )
AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2025-01-14 02:51:41" ) )
AND( (`price_quantity_start` IS NULL OR `price_quantity_start`="0" OR `price_quantity_start` <= 1)
AND (`price_quantity_end` IS NULL OR `price_quantity_end`="0" OR `price_quantity_end` >= 1) )
SELECT pc.`virtuemart_category_id`
FROM `lelwf_virtuemart_product_categories` as pc
WHERE pc.`virtuemart_product_id` = 386
SELECT pc.`virtuemart_category_id`
FROM `lelwf_virtuemart_product_categories` as pc
LEFT JOIN `lelwf_virtuemart_categories` as c
ON c.`virtuemart_category_id` = pc.`virtuemart_category_id`
WHERE pc.`virtuemart_product_id` = 386
AND `published`=1
ORDER BY `c`.`ordering` ASC
SELECT `ordering`,`id`
FROM `lelwf_virtuemart_product_categories`
WHERE `virtuemart_product_id` = "386"
and `virtuemart_category_id`= "146"
SELECT `lelwf_virtuemart_categories`.* ,`lelwf_virtuemart_categories_lt_lt`.*
FROM `lelwf_virtuemart_categories`
INNER JOIN `lelwf_virtuemart_categories_lt_lt` using (`virtuemart_category_id`)
WHERE `lelwf_virtuemart_categories`.`virtuemart_category_id` = "146"
SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
FROM lelwf_virtuemart_category_categories AS `xref`
WHERE `xref`.`category_child_id`= 146
SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
FROM lelwf_virtuemart_category_categories AS `xref`
WHERE `xref`.`category_child_id`= 117
SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
FROM lelwf_virtuemart_category_categories AS `xref`
WHERE `xref`.`category_child_id`= 44
SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
FROM lelwf_virtuemart_category_categories AS `xref`
WHERE `xref`.`category_child_id`= 50
SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
FROM lelwf_virtuemart_category_categories AS `xref`
WHERE `xref`.`category_child_id`= 146
SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
FROM lelwf_virtuemart_category_categories AS `xref`
WHERE `xref`.`category_child_id`= 117
SELECT `slug` as name
FROM `lelwf_virtuemart_categories_lt_lt`
WHERE `virtuemart_category_id`=117
SELECT `slug` as name
FROM `lelwf_virtuemart_categories_lt_lt`
WHERE `virtuemart_category_id`=146
SELECT `slug`
FROM `lelwf_virtuemart_products_lt_lt`
WHERE `virtuemart_product_id` = 386
SELECT `lelwf_virtuemart_products`.* ,`lelwf_virtuemart_products_lt_lt`.* ,`lelwf_virtuemart_product_manufacturers`.`virtuemart_manufacturer_id` ,`lelwf_virtuemart_product_customfields`.`virtuemart_customfield_id`
FROM `lelwf_virtuemart_products`
INNER JOIN `lelwf_virtuemart_products_lt_lt` using (`virtuemart_product_id`)
LEFT JOIN `lelwf_virtuemart_product_manufacturers`
on `lelwf_virtuemart_product_manufacturers`.`virtuemart_product_id`=`lelwf_virtuemart_products`.`virtuemart_product_id`
LEFT JOIN `lelwf_virtuemart_product_customfields`
on `lelwf_virtuemart_product_customfields`.`virtuemart_product_id`=`lelwf_virtuemart_products`.`virtuemart_product_id`
WHERE `lelwf_virtuemart_products`.`virtuemart_product_id` = "1067"
SELECT `virtuemart_media_id`
FROM `lelwf_virtuemart_product_medias`
WHERE `virtuemart_product_id` = "1067"
ORDER BY `ordering`
SELECT `virtuemart_shoppergroup_id`
FROM `lelwf_virtuemart_product_shoppergroups`
WHERE `virtuemart_product_id` = "1067"
SELECT *
FROM `lelwf_virtuemart_product_prices`
WHERE `virtuemart_product_id` = "1067"
AND ( `virtuemart_shoppergroup_id` ="1" OR `virtuemart_shoppergroup_id` IS NULL OR `virtuemart_shoppergroup_id`="0")
AND ( (`product_price_publish_up` IS NULL OR `product_price_publish_up` = "0000-00-00 00:00:00" OR `product_price_publish_up` <= "2025-01-14 02:51:41" )
AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2025-01-14 02:51:41" ) )
AND( (`price_quantity_start` IS NULL OR `price_quantity_start`="0" OR `price_quantity_start` <= 1)
AND (`price_quantity_end` IS NULL OR `price_quantity_end`="0" OR `price_quantity_end` >= 1) )
SELECT pc.`virtuemart_category_id`
FROM `lelwf_virtuemart_product_categories` as pc
WHERE pc.`virtuemart_product_id` = 1067
SELECT pc.`virtuemart_category_id`
FROM `lelwf_virtuemart_product_categories` as pc
LEFT JOIN `lelwf_virtuemart_categories` as c
ON c.`virtuemart_category_id` = pc.`virtuemart_category_id`
WHERE pc.`virtuemart_product_id` = 1067
AND `published`=1
ORDER BY `c`.`ordering` ASC
SELECT `ordering`,`id`
FROM `lelwf_virtuemart_product_categories`
WHERE `virtuemart_product_id` = "1067"
and `virtuemart_category_id`= "171"
SELECT `lelwf_virtuemart_categories`.* ,`lelwf_virtuemart_categories_lt_lt`.*
FROM `lelwf_virtuemart_categories`
INNER JOIN `lelwf_virtuemart_categories_lt_lt` using (`virtuemart_category_id`)
WHERE `lelwf_virtuemart_categories`.`virtuemart_category_id` = "171"
SELECT `virtuemart_category_id`
FROM lelwf_virtuemart_calc_categories
WHERE `virtuemart_calc_id`="1"
SELECT `virtuemart_shoppergroup_id`
FROM lelwf_virtuemart_calc_shoppergroups
WHERE `virtuemart_calc_id`="1"
SELECT `virtuemart_country_id`
FROM lelwf_virtuemart_calc_countries
WHERE `virtuemart_calc_id`="1"
SELECT `virtuemart_state_id`
FROM lelwf_virtuemart_calc_states
WHERE `virtuemart_calc_id`="1"
SELECT `virtuemart_manufacturer_id`
FROM lelwf_virtuemart_calc_manufacturers
WHERE `virtuemart_calc_id`="1"
SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
FROM lelwf_virtuemart_category_categories AS `xref`
WHERE `xref`.`category_child_id`= 171
SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
FROM lelwf_virtuemart_category_categories AS `xref`
WHERE `xref`.`category_child_id`= 83
SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
FROM lelwf_virtuemart_category_categories AS `xref`
WHERE `xref`.`category_child_id`= 50
SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
FROM lelwf_virtuemart_category_categories AS `xref`
WHERE `xref`.`category_child_id`= 171
SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
FROM lelwf_virtuemart_category_categories AS `xref`
WHERE `xref`.`category_child_id`= 83
SELECT `slug` as name
FROM `lelwf_virtuemart_categories_lt_lt`
WHERE `virtuemart_category_id`=171
SELECT `slug`
FROM `lelwf_virtuemart_products_lt_lt`
WHERE `virtuemart_product_id` = 1067
SELECT `lelwf_virtuemart_products`.* ,`lelwf_virtuemart_products_lt_lt`.* ,`lelwf_virtuemart_product_manufacturers`.`virtuemart_manufacturer_id` ,`lelwf_virtuemart_product_customfields`.`virtuemart_customfield_id`
FROM `lelwf_virtuemart_products`
INNER JOIN `lelwf_virtuemart_products_lt_lt` using (`virtuemart_product_id`)
LEFT JOIN `lelwf_virtuemart_product_manufacturers`
on `lelwf_virtuemart_product_manufacturers`.`virtuemart_product_id`=`lelwf_virtuemart_products`.`virtuemart_product_id`
LEFT JOIN `lelwf_virtuemart_product_customfields`
on `lelwf_virtuemart_product_customfields`.`virtuemart_product_id`=`lelwf_virtuemart_products`.`virtuemart_product_id`
WHERE `lelwf_virtuemart_products`.`virtuemart_product_id` = "220"
SELECT `virtuemart_media_id`
FROM `lelwf_virtuemart_product_medias`
WHERE `virtuemart_product_id` = "220"
ORDER BY `ordering`
SELECT `virtuemart_shoppergroup_id`
FROM `lelwf_virtuemart_product_shoppergroups`
WHERE `virtuemart_product_id` = "220"
SELECT *
FROM `lelwf_virtuemart_product_prices`
WHERE `virtuemart_product_id` = "220"
AND ( `virtuemart_shoppergroup_id` ="1" OR `virtuemart_shoppergroup_id` IS NULL OR `virtuemart_shoppergroup_id`="0")
AND ( (`product_price_publish_up` IS NULL OR `product_price_publish_up` = "0000-00-00 00:00:00" OR `product_price_publish_up` <= "2025-01-14 02:51:41" )
AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2025-01-14 02:51:41" ) )
AND( (`price_quantity_start` IS NULL OR `price_quantity_start`="0" OR `price_quantity_start` <= 1)
AND (`price_quantity_end` IS NULL OR `price_quantity_end`="0" OR `price_quantity_end` >= 1) )
SELECT pc.`virtuemart_category_id`
FROM `lelwf_virtuemart_product_categories` as pc
WHERE pc.`virtuemart_product_id` = 220
SELECT pc.`virtuemart_category_id`
FROM `lelwf_virtuemart_product_categories` as pc
LEFT JOIN `lelwf_virtuemart_categories` as c
ON c.`virtuemart_category_id` = pc.`virtuemart_category_id`
WHERE pc.`virtuemart_product_id` = 220
AND `published`=1
ORDER BY `c`.`ordering` ASC
SELECT `ordering`,`id`
FROM `lelwf_virtuemart_product_categories`
WHERE `virtuemart_product_id` = "220"
and `virtuemart_category_id`= "97"
SELECT `lelwf_virtuemart_categories`.* ,`lelwf_virtuemart_categories_lt_lt`.*
FROM `lelwf_virtuemart_categories`
INNER JOIN `lelwf_virtuemart_categories_lt_lt` using (`virtuemart_category_id`)
WHERE `lelwf_virtuemart_categories`.`virtuemart_category_id` = "97"
SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
FROM lelwf_virtuemart_category_categories AS `xref`
WHERE `xref`.`category_child_id`= 97
SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
FROM lelwf_virtuemart_category_categories AS `xref`
WHERE `xref`.`category_child_id`= 92
SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
FROM lelwf_virtuemart_category_categories AS `xref`
WHERE `xref`.`category_child_id`= 43
SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
FROM lelwf_virtuemart_category_categories AS `xref`
WHERE `xref`.`category_child_id`= 50
SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
FROM lelwf_virtuemart_category_categories AS `xref`
WHERE `xref`.`category_child_id`= 97
SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
FROM lelwf_virtuemart_category_categories AS `xref`
WHERE `xref`.`category_child_id`= 92
SELECT `slug` as name
FROM `lelwf_virtuemart_categories_lt_lt`
WHERE `virtuemart_category_id`=92
SELECT `slug` as name
FROM `lelwf_virtuemart_categories_lt_lt`
WHERE `virtuemart_category_id`=97
SELECT `slug`
FROM `lelwf_virtuemart_products_lt_lt`
WHERE `virtuemart_product_id` = 220
SELECT `lelwf_virtuemart_products`.* ,`lelwf_virtuemart_products_lt_lt`.* ,`lelwf_virtuemart_product_manufacturers`.`virtuemart_manufacturer_id` ,`lelwf_virtuemart_product_customfields`.`virtuemart_customfield_id`
FROM `lelwf_virtuemart_products`
INNER JOIN `lelwf_virtuemart_products_lt_lt` using (`virtuemart_product_id`)
LEFT JOIN `lelwf_virtuemart_product_manufacturers`
on `lelwf_virtuemart_product_manufacturers`.`virtuemart_product_id`=`lelwf_virtuemart_products`.`virtuemart_product_id`
LEFT JOIN `lelwf_virtuemart_product_customfields`
on `lelwf_virtuemart_product_customfields`.`virtuemart_product_id`=`lelwf_virtuemart_products`.`virtuemart_product_id`
WHERE `lelwf_virtuemart_products`.`virtuemart_product_id` = "595"
SELECT `virtuemart_media_id`
FROM `lelwf_virtuemart_product_medias`
WHERE `virtuemart_product_id` = "595"
ORDER BY `ordering`
SELECT `virtuemart_shoppergroup_id`
FROM `lelwf_virtuemart_product_shoppergroups`
WHERE `virtuemart_product_id` = "595"
SELECT *
FROM `lelwf_virtuemart_product_prices`
WHERE `virtuemart_product_id` = "595"
AND ( `virtuemart_shoppergroup_id` ="1" OR `virtuemart_shoppergroup_id` IS NULL OR `virtuemart_shoppergroup_id`="0")
AND ( (`product_price_publish_up` IS NULL OR `product_price_publish_up` = "0000-00-00 00:00:00" OR `product_price_publish_up` <= "2025-01-14 02:51:41" )
AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2025-01-14 02:51:41" ) )
AND( (`price_quantity_start` IS NULL OR `price_quantity_start`="0" OR `price_quantity_start` <= 1)
AND (`price_quantity_end` IS NULL OR `price_quantity_end`="0" OR `price_quantity_end` >= 1) )
SELECT pc.`virtuemart_category_id`
FROM `lelwf_virtuemart_product_categories` as pc
WHERE pc.`virtuemart_product_id` = 595
SELECT pc.`virtuemart_category_id`
FROM `lelwf_virtuemart_product_categories` as pc
LEFT JOIN `lelwf_virtuemart_categories` as c
ON c.`virtuemart_category_id` = pc.`virtuemart_category_id`
WHERE pc.`virtuemart_product_id` = 595
AND `published`=1
ORDER BY `c`.`ordering` ASC
SELECT `ordering`,`id`
FROM `lelwf_virtuemart_product_categories`
WHERE `virtuemart_product_id` = "595"
and `virtuemart_category_id`= "122"
SELECT `slug`
FROM `lelwf_virtuemart_products_lt_lt`
WHERE `virtuemart_product_id` = 595
SELECT `lelwf_virtuemart_products`.* ,`lelwf_virtuemart_products_lt_lt`.* ,`lelwf_virtuemart_product_manufacturers`.`virtuemart_manufacturer_id` ,`lelwf_virtuemart_product_customfields`.`virtuemart_customfield_id`
FROM `lelwf_virtuemart_products`
INNER JOIN `lelwf_virtuemart_products_lt_lt` using (`virtuemart_product_id`)
LEFT JOIN `lelwf_virtuemart_product_manufacturers`
on `lelwf_virtuemart_product_manufacturers`.`virtuemart_product_id`=`lelwf_virtuemart_products`.`virtuemart_product_id`
LEFT JOIN `lelwf_virtuemart_product_customfields`
on `lelwf_virtuemart_product_customfields`.`virtuemart_product_id`=`lelwf_virtuemart_products`.`virtuemart_product_id`
WHERE `lelwf_virtuemart_products`.`virtuemart_product_id` = "936"
SELECT `virtuemart_media_id`
FROM `lelwf_virtuemart_product_medias`
WHERE `virtuemart_product_id` = "936"
ORDER BY `ordering`
SELECT `virtuemart_shoppergroup_id`
FROM `lelwf_virtuemart_product_shoppergroups`
WHERE `virtuemart_product_id` = "936"
SELECT *
FROM `lelwf_virtuemart_product_prices`
WHERE `virtuemart_product_id` = "936"
AND ( `virtuemart_shoppergroup_id` ="1" OR `virtuemart_shoppergroup_id` IS NULL OR `virtuemart_shoppergroup_id`="0")
AND ( (`product_price_publish_up` IS NULL OR `product_price_publish_up` = "0000-00-00 00:00:00" OR `product_price_publish_up` <= "2025-01-14 02:51:41" )
AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2025-01-14 02:51:41" ) )
AND( (`price_quantity_start` IS NULL OR `price_quantity_start`="0" OR `price_quantity_start` <= 1)
AND (`price_quantity_end` IS NULL OR `price_quantity_end`="0" OR `price_quantity_end` >= 1) )
SELECT pc.`virtuemart_category_id`
FROM `lelwf_virtuemart_product_categories` as pc
WHERE pc.`virtuemart_product_id` = 936
SELECT pc.`virtuemart_category_id`
FROM `lelwf_virtuemart_product_categories` as pc
LEFT JOIN `lelwf_virtuemart_categories` as c
ON c.`virtuemart_category_id` = pc.`virtuemart_category_id`
WHERE pc.`virtuemart_product_id` = 936
AND `published`=1
ORDER BY `c`.`ordering` ASC
SELECT `ordering`,`id`
FROM `lelwf_virtuemart_product_categories`
WHERE `virtuemart_product_id` = "936"
and `virtuemart_category_id`= "173"
SELECT `lelwf_virtuemart_categories`.* ,`lelwf_virtuemart_categories_lt_lt`.*
FROM `lelwf_virtuemart_categories`
INNER JOIN `lelwf_virtuemart_categories_lt_lt` using (`virtuemart_category_id`)
WHERE `lelwf_virtuemart_categories`.`virtuemart_category_id` = "173"
SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
FROM lelwf_virtuemart_category_categories AS `xref`
WHERE `xref`.`category_child_id`= 173
SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
FROM lelwf_virtuemart_category_categories AS `xref`
WHERE `xref`.`category_child_id`= 83
SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
FROM lelwf_virtuemart_category_categories AS `xref`
WHERE `xref`.`category_child_id`= 50
SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
FROM lelwf_virtuemart_category_categories AS `xref`
WHERE `xref`.`category_child_id`= 173
SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
FROM lelwf_virtuemart_category_categories AS `xref`
WHERE `xref`.`category_child_id`= 83
SELECT `slug` as name
FROM `lelwf_virtuemart_categories_lt_lt`
WHERE `virtuemart_category_id`=173
SELECT `slug`
FROM `lelwf_virtuemart_products_lt_lt`
WHERE `virtuemart_product_id` = 936
SELECT `lelwf_virtuemart_products`.* ,`lelwf_virtuemart_products_lt_lt`.* ,`lelwf_virtuemart_product_manufacturers`.`virtuemart_manufacturer_id` ,`lelwf_virtuemart_product_customfields`.`virtuemart_customfield_id`
FROM `lelwf_virtuemart_products`
INNER JOIN `lelwf_virtuemart_products_lt_lt` using (`virtuemart_product_id`)
LEFT JOIN `lelwf_virtuemart_product_manufacturers`
on `lelwf_virtuemart_product_manufacturers`.`virtuemart_product_id`=`lelwf_virtuemart_products`.`virtuemart_product_id`
LEFT JOIN `lelwf_virtuemart_product_customfields`
on `lelwf_virtuemart_product_customfields`.`virtuemart_product_id`=`lelwf_virtuemart_products`.`virtuemart_product_id`
WHERE `lelwf_virtuemart_products`.`virtuemart_product_id` = "844"
SELECT `virtuemart_media_id`
FROM `lelwf_virtuemart_product_medias`
WHERE `virtuemart_product_id` = "844"
ORDER BY `ordering`
SELECT `virtuemart_shoppergroup_id`
FROM `lelwf_virtuemart_product_shoppergroups`
WHERE `virtuemart_product_id` = "844"
SELECT *
FROM `lelwf_virtuemart_product_prices`
WHERE `virtuemart_product_id` = "844"
AND ( `virtuemart_shoppergroup_id` ="1" OR `virtuemart_shoppergroup_id` IS NULL OR `virtuemart_shoppergroup_id`="0")
AND ( (`product_price_publish_up` IS NULL OR `product_price_publish_up` = "0000-00-00 00:00:00" OR `product_price_publish_up` <= "2025-01-14 02:51:41" )
AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2025-01-14 02:51:41" ) )
AND( (`price_quantity_start` IS NULL OR `price_quantity_start`="0" OR `price_quantity_start` <= 1)
AND (`price_quantity_end` IS NULL OR `price_quantity_end`="0" OR `price_quantity_end` >= 1) )
SELECT pc.`virtuemart_category_id`
FROM `lelwf_virtuemart_product_categories` as pc
WHERE pc.`virtuemart_product_id` = 844
SELECT pc.`virtuemart_category_id`
FROM `lelwf_virtuemart_product_categories` as pc
LEFT JOIN `lelwf_virtuemart_categories` as c
ON c.`virtuemart_category_id` = pc.`virtuemart_category_id`
WHERE pc.`virtuemart_product_id` = 844
AND `published`=1
ORDER BY `c`.`ordering` ASC
SELECT `ordering`,`id`
FROM `lelwf_virtuemart_product_categories`
WHERE `virtuemart_product_id` = "844"
and `virtuemart_category_id`= "171"
SELECT `slug`
FROM `lelwf_virtuemart_products_lt_lt`
WHERE `virtuemart_product_id` = 844
SELECT `lelwf_virtuemart_products`.* ,`lelwf_virtuemart_products_lt_lt`.* ,`lelwf_virtuemart_product_manufacturers`.`virtuemart_manufacturer_id` ,`lelwf_virtuemart_product_customfields`.`virtuemart_customfield_id`
FROM `lelwf_virtuemart_products`
INNER JOIN `lelwf_virtuemart_products_lt_lt` using (`virtuemart_product_id`)
LEFT JOIN `lelwf_virtuemart_product_manufacturers`
on `lelwf_virtuemart_product_manufacturers`.`virtuemart_product_id`=`lelwf_virtuemart_products`.`virtuemart_product_id`
LEFT JOIN `lelwf_virtuemart_product_customfields`
on `lelwf_virtuemart_product_customfields`.`virtuemart_product_id`=`lelwf_virtuemart_products`.`virtuemart_product_id`
WHERE `lelwf_virtuemart_products`.`virtuemart_product_id` = "1311"
SELECT `virtuemart_media_id`
FROM `lelwf_virtuemart_product_medias`
WHERE `virtuemart_product_id` = "1311"
ORDER BY `ordering`
SELECT `virtuemart_shoppergroup_id`
FROM `lelwf_virtuemart_product_shoppergroups`
WHERE `virtuemart_product_id` = "1311"
SELECT *
FROM `lelwf_virtuemart_product_prices`
WHERE `virtuemart_product_id` = "1311"
AND ( `virtuemart_shoppergroup_id` ="1" OR `virtuemart_shoppergroup_id` IS NULL OR `virtuemart_shoppergroup_id`="0")
AND ( (`product_price_publish_up` IS NULL OR `product_price_publish_up` = "0000-00-00 00:00:00" OR `product_price_publish_up` <= "2025-01-14 02:51:41" )
AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2025-01-14 02:51:41" ) )
AND( (`price_quantity_start` IS NULL OR `price_quantity_start`="0" OR `price_quantity_start` <= 1)
AND (`price_quantity_end` IS NULL OR `price_quantity_end`="0" OR `price_quantity_end` >= 1) )
SELECT pc.`virtuemart_category_id`
FROM `lelwf_virtuemart_product_categories` as pc
WHERE pc.`virtuemart_product_id` = 1311
SELECT pc.`virtuemart_category_id`
FROM `lelwf_virtuemart_product_categories` as pc
LEFT JOIN `lelwf_virtuemart_categories` as c
ON c.`virtuemart_category_id` = pc.`virtuemart_category_id`
WHERE pc.`virtuemart_product_id` = 1311
AND `published`=1
ORDER BY `c`.`ordering` ASC
SELECT `ordering`,`id`
FROM `lelwf_virtuemart_product_categories`
WHERE `virtuemart_product_id` = "1311"
and `virtuemart_category_id`= "83"
SELECT `slug`
FROM `lelwf_virtuemart_products_lt_lt`
WHERE `virtuemart_product_id` = 1311
SELECT `lelwf_virtuemart_products`.* ,`lelwf_virtuemart_products_lt_lt`.* ,`lelwf_virtuemart_product_manufacturers`.`virtuemart_manufacturer_id` ,`lelwf_virtuemart_product_customfields`.`virtuemart_customfield_id`
FROM `lelwf_virtuemart_products`
INNER JOIN `lelwf_virtuemart_products_lt_lt` using (`virtuemart_product_id`)
LEFT JOIN `lelwf_virtuemart_product_manufacturers`
on `lelwf_virtuemart_product_manufacturers`.`virtuemart_product_id`=`lelwf_virtuemart_products`.`virtuemart_product_id`
LEFT JOIN `lelwf_virtuemart_product_customfields`
on `lelwf_virtuemart_product_customfields`.`virtuemart_product_id`=`lelwf_virtuemart_products`.`virtuemart_product_id`
WHERE `lelwf_virtuemart_products`.`virtuemart_product_id` = "319"
SELECT `virtuemart_media_id`
FROM `lelwf_virtuemart_product_medias`
WHERE `virtuemart_product_id` = "319"
ORDER BY `ordering`
SELECT `virtuemart_shoppergroup_id`
FROM `lelwf_virtuemart_product_shoppergroups`
WHERE `virtuemart_product_id` = "319"
SELECT *
FROM `lelwf_virtuemart_product_prices`
WHERE `virtuemart_product_id` = "319"
AND ( `virtuemart_shoppergroup_id` ="1" OR `virtuemart_shoppergroup_id` IS NULL OR `virtuemart_shoppergroup_id`="0")
AND ( (`product_price_publish_up` IS NULL OR `product_price_publish_up` = "0000-00-00 00:00:00" OR `product_price_publish_up` <= "2025-01-14 02:51:41" )
AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2025-01-14 02:51:41" ) )
AND( (`price_quantity_start` IS NULL OR `price_quantity_start`="0" OR `price_quantity_start` <= 1)
AND (`price_quantity_end` IS NULL OR `price_quantity_end`="0" OR `price_quantity_end` >= 1) )
SELECT pc.`virtuemart_category_id`
FROM `lelwf_virtuemart_product_categories` as pc
WHERE pc.`virtuemart_product_id` = 319
SELECT pc.`virtuemart_category_id`
FROM `lelwf_virtuemart_product_categories` as pc
LEFT JOIN `lelwf_virtuemart_categories` as c
ON c.`virtuemart_category_id` = pc.`virtuemart_category_id`
WHERE pc.`virtuemart_product_id` = 319
AND `published`=1
ORDER BY `c`.`ordering` ASC
SELECT `ordering`,`id`
FROM `lelwf_virtuemart_product_categories`
WHERE `virtuemart_product_id` = "319"
and `virtuemart_category_id`= "127"
SELECT `slug`
FROM `lelwf_virtuemart_products_lt_lt`
WHERE `virtuemart_product_id` = 319
SELECT `lelwf_virtuemart_products`.* ,`lelwf_virtuemart_products_lt_lt`.* ,`lelwf_virtuemart_product_manufacturers`.`virtuemart_manufacturer_id` ,`lelwf_virtuemart_product_customfields`.`virtuemart_customfield_id`
FROM `lelwf_virtuemart_products`
INNER JOIN `lelwf_virtuemart_products_lt_lt` using (`virtuemart_product_id`)
LEFT JOIN `lelwf_virtuemart_product_manufacturers`
on `lelwf_virtuemart_product_manufacturers`.`virtuemart_product_id`=`lelwf_virtuemart_products`.`virtuemart_product_id`
LEFT JOIN `lelwf_virtuemart_product_customfields`
on `lelwf_virtuemart_product_customfields`.`virtuemart_product_id`=`lelwf_virtuemart_products`.`virtuemart_product_id`
WHERE `lelwf_virtuemart_products`.`virtuemart_product_id` = "1501"
SELECT `virtuemart_media_id`
FROM `lelwf_virtuemart_product_medias`
WHERE `virtuemart_product_id` = "1501"
ORDER BY `ordering`
SELECT `virtuemart_shoppergroup_id`
FROM `lelwf_virtuemart_product_shoppergroups`
WHERE `virtuemart_product_id` = "1501"
SELECT *
FROM `lelwf_virtuemart_product_prices`
WHERE `virtuemart_product_id` = "1501"
AND ( `virtuemart_shoppergroup_id` ="1" OR `virtuemart_shoppergroup_id` IS NULL OR `virtuemart_shoppergroup_id`="0")
AND ( (`product_price_publish_up` IS NULL OR `product_price_publish_up` = "0000-00-00 00:00:00" OR `product_price_publish_up` <= "2025-01-14 02:51:41" )
AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2025-01-14 02:51:41" ) )
AND( (`price_quantity_start` IS NULL OR `price_quantity_start`="0" OR `price_quantity_start` <= 1)
AND (`price_quantity_end` IS NULL OR `price_quantity_end`="0" OR `price_quantity_end` >= 1) )
SELECT pc.`virtuemart_category_id`
FROM `lelwf_virtuemart_product_categories` as pc
WHERE pc.`virtuemart_product_id` = 1501
SELECT pc.`virtuemart_category_id`
FROM `lelwf_virtuemart_product_categories` as pc
LEFT JOIN `lelwf_virtuemart_categories` as c
ON c.`virtuemart_category_id` = pc.`virtuemart_category_id`
WHERE pc.`virtuemart_product_id` = 1501
AND `published`=1
ORDER BY `c`.`ordering` ASC
SELECT `ordering`,`id`
FROM `lelwf_virtuemart_product_categories`
WHERE `virtuemart_product_id` = "1501"
and `virtuemart_category_id`= "85"
SELECT `lelwf_virtuemart_categories`.* ,`lelwf_virtuemart_categories_lt_lt`.*
FROM `lelwf_virtuemart_categories`
INNER JOIN `lelwf_virtuemart_categories_lt_lt` using (`virtuemart_category_id`)
WHERE `lelwf_virtuemart_categories`.`virtuemart_category_id` = "85"
SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
FROM lelwf_virtuemart_category_categories AS `xref`
WHERE `xref`.`category_child_id`= 85
SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
FROM lelwf_virtuemart_category_categories AS `xref`
WHERE `xref`.`category_child_id`= 81
SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
FROM lelwf_virtuemart_category_categories AS `xref`
WHERE `xref`.`category_child_id`= 76
SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
FROM lelwf_virtuemart_category_categories AS `xref`
WHERE `xref`.`category_child_id`= 50
SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
FROM lelwf_virtuemart_category_categories AS `xref`
WHERE `xref`.`category_child_id`= 85
SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
FROM lelwf_virtuemart_category_categories AS `xref`
WHERE `xref`.`category_child_id`= 81
SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
FROM lelwf_virtuemart_category_categories AS `xref`
WHERE `xref`.`category_child_id`= 76
SELECT `slug` as name
FROM `lelwf_virtuemart_categories_lt_lt`
WHERE `virtuemart_category_id`=81
SELECT `slug` as name
FROM `lelwf_virtuemart_categories_lt_lt`
WHERE `virtuemart_category_id`=85
SELECT `slug`
FROM `lelwf_virtuemart_products_lt_lt`
WHERE `virtuemart_product_id` = 1501
SELECT `lelwf_virtuemart_products`.* ,`lelwf_virtuemart_products_lt_lt`.* ,`lelwf_virtuemart_product_manufacturers`.`virtuemart_manufacturer_id` ,`lelwf_virtuemart_product_customfields`.`virtuemart_customfield_id`
FROM `lelwf_virtuemart_products`
INNER JOIN `lelwf_virtuemart_products_lt_lt` using (`virtuemart_product_id`)
LEFT JOIN `lelwf_virtuemart_product_manufacturers`
on `lelwf_virtuemart_product_manufacturers`.`virtuemart_product_id`=`lelwf_virtuemart_products`.`virtuemart_product_id`
LEFT JOIN `lelwf_virtuemart_product_customfields`
on `lelwf_virtuemart_product_customfields`.`virtuemart_product_id`=`lelwf_virtuemart_products`.`virtuemart_product_id`
WHERE `lelwf_virtuemart_products`.`virtuemart_product_id` = "596"
SELECT `virtuemart_media_id`
FROM `lelwf_virtuemart_product_medias`
WHERE `virtuemart_product_id` = "596"
ORDER BY `ordering`
SELECT `virtuemart_shoppergroup_id`
FROM `lelwf_virtuemart_product_shoppergroups`
WHERE `virtuemart_product_id` = "596"
SELECT *
FROM `lelwf_virtuemart_product_prices`
WHERE `virtuemart_product_id` = "596"
AND ( `virtuemart_shoppergroup_id` ="1" OR `virtuemart_shoppergroup_id` IS NULL OR `virtuemart_shoppergroup_id`="0")
AND ( (`product_price_publish_up` IS NULL OR `product_price_publish_up` = "0000-00-00 00:00:00" OR `product_price_publish_up` <= "2025-01-14 02:51:41" )
AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2025-01-14 02:51:41" ) )
AND( (`price_quantity_start` IS NULL OR `price_quantity_start`="0" OR `price_quantity_start` <= 1)
AND (`price_quantity_end` IS NULL OR `price_quantity_end`="0" OR `price_quantity_end` >= 1) )
SELECT pc.`virtuemart_category_id`
FROM `lelwf_virtuemart_product_categories` as pc
WHERE pc.`virtuemart_product_id` = 596
SELECT pc.`virtuemart_category_id`
FROM `lelwf_virtuemart_product_categories` as pc
LEFT JOIN `lelwf_virtuemart_categories` as c
ON c.`virtuemart_category_id` = pc.`virtuemart_category_id`
WHERE pc.`virtuemart_product_id` = 596
AND `published`=1
ORDER BY `c`.`ordering` ASC
SELECT `ordering`,`id`
FROM `lelwf_virtuemart_product_categories`
WHERE `virtuemart_product_id` = "596"
and `virtuemart_category_id`= "122"
SELECT `slug`
FROM `lelwf_virtuemart_products_lt_lt`
WHERE `virtuemart_product_id` = 596
SELECT `lelwf_virtuemart_products`.* ,`lelwf_virtuemart_products_lt_lt`.* ,`lelwf_virtuemart_product_manufacturers`.`virtuemart_manufacturer_id` ,`lelwf_virtuemart_product_customfields`.`virtuemart_customfield_id`
FROM `lelwf_virtuemart_products`
INNER JOIN `lelwf_virtuemart_products_lt_lt` using (`virtuemart_product_id`)
LEFT JOIN `lelwf_virtuemart_product_manufacturers`
on `lelwf_virtuemart_product_manufacturers`.`virtuemart_product_id`=`lelwf_virtuemart_products`.`virtuemart_product_id`
LEFT JOIN `lelwf_virtuemart_product_customfields`
on `lelwf_virtuemart_product_customfields`.`virtuemart_product_id`=`lelwf_virtuemart_products`.`virtuemart_product_id`
WHERE `lelwf_virtuemart_products`.`virtuemart_product_id` = "639"
SELECT `virtuemart_media_id`
FROM `lelwf_virtuemart_product_medias`
WHERE `virtuemart_product_id` = "639"
ORDER BY `ordering`
SELECT `virtuemart_shoppergroup_id`
FROM `lelwf_virtuemart_product_shoppergroups`
WHERE `virtuemart_product_id` = "639"
SELECT *
FROM `lelwf_virtuemart_product_prices`
WHERE `virtuemart_product_id` = "639"
AND ( `virtuemart_shoppergroup_id` ="1" OR `virtuemart_shoppergroup_id` IS NULL OR `virtuemart_shoppergroup_id`="0")
AND ( (`product_price_publish_up` IS NULL OR `product_price_publish_up` = "0000-00-00 00:00:00" OR `product_price_publish_up` <= "2025-01-14 02:51:41" )
AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2025-01-14 02:51:41" ) )
AND( (`price_quantity_start` IS NULL OR `price_quantity_start`="0" OR `price_quantity_start` <= 1)
AND (`price_quantity_end` IS NULL OR `price_quantity_end`="0" OR `price_quantity_end` >= 1) )
SELECT pc.`virtuemart_category_id`
FROM `lelwf_virtuemart_product_categories` as pc
WHERE pc.`virtuemart_product_id` = 639
SELECT pc.`virtuemart_category_id`
FROM `lelwf_virtuemart_product_categories` as pc
LEFT JOIN `lelwf_virtuemart_categories` as c
ON c.`virtuemart_category_id` = pc.`virtuemart_category_id`
WHERE pc.`virtuemart_product_id` = 639
AND `published`=1
ORDER BY `c`.`ordering` ASC
SELECT `ordering`,`id`
FROM `lelwf_virtuemart_product_categories`
WHERE `virtuemart_product_id` = "639"
and `virtuemart_category_id`= "156"
SELECT `lelwf_virtuemart_categories`.* ,`lelwf_virtuemart_categories_lt_lt`.*
FROM `lelwf_virtuemart_categories`
INNER JOIN `lelwf_virtuemart_categories_lt_lt` using (`virtuemart_category_id`)
WHERE `lelwf_virtuemart_categories`.`virtuemart_category_id` = "156"
SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
FROM lelwf_virtuemart_category_categories AS `xref`
WHERE `xref`.`category_child_id`= 156
SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
FROM lelwf_virtuemart_category_categories AS `xref`
WHERE `xref`.`category_child_id`= 45
SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
FROM lelwf_virtuemart_category_categories AS `xref`
WHERE `xref`.`category_child_id`= 50
SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
FROM lelwf_virtuemart_category_categories AS `xref`
WHERE `xref`.`category_child_id`= 156
SELECT `slug` as name
FROM `lelwf_virtuemart_categories_lt_lt`
WHERE `virtuemart_category_id`=156
SELECT `slug`
FROM `lelwf_virtuemart_products_lt_lt`
WHERE `virtuemart_product_id` = 639
SELECT `lelwf_virtuemart_products`.* ,`lelwf_virtuemart_products_lt_lt`.* ,`lelwf_virtuemart_product_manufacturers`.`virtuemart_manufacturer_id` ,`lelwf_virtuemart_product_customfields`.`virtuemart_customfield_id`
FROM `lelwf_virtuemart_products`
INNER JOIN `lelwf_virtuemart_products_lt_lt` using (`virtuemart_product_id`)
LEFT JOIN `lelwf_virtuemart_product_manufacturers`
on `lelwf_virtuemart_product_manufacturers`.`virtuemart_product_id`=`lelwf_virtuemart_products`.`virtuemart_product_id`
LEFT JOIN `lelwf_virtuemart_product_customfields`
on `lelwf_virtuemart_product_customfields`.`virtuemart_product_id`=`lelwf_virtuemart_products`.`virtuemart_product_id`
WHERE `lelwf_virtuemart_products`.`virtuemart_product_id` = "1457"
SELECT `virtuemart_media_id`
FROM `lelwf_virtuemart_product_medias`
WHERE `virtuemart_product_id` = "1457"
ORDER BY `ordering`
SELECT `virtuemart_shoppergroup_id`
FROM `lelwf_virtuemart_product_shoppergroups`
WHERE `virtuemart_product_id` = "1457"
SELECT *
FROM `lelwf_virtuemart_product_prices`
WHERE `virtuemart_product_id` = "1457"
AND ( `virtuemart_shoppergroup_id` ="1" OR `virtuemart_shoppergroup_id` IS NULL OR `virtuemart_shoppergroup_id`="0")
AND ( (`product_price_publish_up` IS NULL OR `product_price_publish_up` = "0000-00-00 00:00:00" OR `product_price_publish_up` <= "2025-01-14 02:51:41" )
AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2025-01-14 02:51:41" ) )
AND( (`price_quantity_start` IS NULL OR `price_quantity_start`="0" OR `price_quantity_start` <= 1)
AND (`price_quantity_end` IS NULL OR `price_quantity_end`="0" OR `price_quantity_end` >= 1) )
SELECT pc.`virtuemart_category_id`
FROM `lelwf_virtuemart_product_categories` as pc
WHERE pc.`virtuemart_product_id` = 1457
SELECT pc.`virtuemart_category_id`
FROM `lelwf_virtuemart_product_categories` as pc
LEFT JOIN `lelwf_virtuemart_categories` as c
ON c.`virtuemart_category_id` = pc.`virtuemart_category_id`
WHERE pc.`virtuemart_product_id` = 1457
AND `published`=1
ORDER BY `c`.`ordering` ASC
SELECT `ordering`,`id`
FROM `lelwf_virtuemart_product_categories`
WHERE `virtuemart_product_id` = "1457"
and `virtuemart_category_id`= "78"
SELECT `slug`
FROM `lelwf_virtuemart_products_lt_lt`
WHERE `virtuemart_product_id` = 1457
SELECT `lelwf_virtuemart_products`.* ,`lelwf_virtuemart_products_lt_lt`.* ,`lelwf_virtuemart_product_manufacturers`.`virtuemart_manufacturer_id` ,`lelwf_virtuemart_product_customfields`.`virtuemart_customfield_id`
FROM `lelwf_virtuemart_products`
INNER JOIN `lelwf_virtuemart_products_lt_lt` using (`virtuemart_product_id`)
LEFT JOIN `lelwf_virtuemart_product_manufacturers`
on `lelwf_virtuemart_product_manufacturers`.`virtuemart_product_id`=`lelwf_virtuemart_products`.`virtuemart_product_id`
LEFT JOIN `lelwf_virtuemart_product_customfields`
on `lelwf_virtuemart_product_customfields`.`virtuemart_product_id`=`lelwf_virtuemart_products`.`virtuemart_product_id`
WHERE `lelwf_virtuemart_products`.`virtuemart_product_id` = "666"
SELECT `virtuemart_media_id`
FROM `lelwf_virtuemart_product_medias`
WHERE `virtuemart_product_id` = "666"
ORDER BY `ordering`
SELECT `virtuemart_shoppergroup_id`
FROM `lelwf_virtuemart_product_shoppergroups`
WHERE `virtuemart_product_id` = "666"
SELECT *
FROM `lelwf_virtuemart_product_prices`
WHERE `virtuemart_product_id` = "666"
AND ( `virtuemart_shoppergroup_id` ="1" OR `virtuemart_shoppergroup_id` IS NULL OR `virtuemart_shoppergroup_id`="0")
AND ( (`product_price_publish_up` IS NULL OR `product_price_publish_up` = "0000-00-00 00:00:00" OR `product_price_publish_up` <= "2025-01-14 02:51:41" )
AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2025-01-14 02:51:41" ) )
AND( (`price_quantity_start` IS NULL OR `price_quantity_start`="0" OR `price_quantity_start` <= 1)
AND (`price_quantity_end` IS NULL OR `price_quantity_end`="0" OR `price_quantity_end` >= 1) )
SELECT pc.`virtuemart_category_id`
FROM `lelwf_virtuemart_product_categories` as pc
WHERE pc.`virtuemart_product_id` = 666
SELECT pc.`virtuemart_category_id`
FROM `lelwf_virtuemart_product_categories` as pc
LEFT JOIN `lelwf_virtuemart_categories` as c
ON c.`virtuemart_category_id` = pc.`virtuemart_category_id`
WHERE pc.`virtuemart_product_id` = 666
AND `published`=1
ORDER BY `c`.`ordering` ASC
SELECT `ordering`,`id`
FROM `lelwf_virtuemart_product_categories`
WHERE `virtuemart_product_id` = "666"
and `virtuemart_category_id`= "64"
SELECT `slug`
FROM `lelwf_virtuemart_products_lt_lt`
WHERE `virtuemart_product_id` = 666
SELECT `lelwf_virtuemart_products`.* ,`lelwf_virtuemart_products_lt_lt`.* ,`lelwf_virtuemart_product_manufacturers`.`virtuemart_manufacturer_id` ,`lelwf_virtuemart_product_customfields`.`virtuemart_customfield_id`
FROM `lelwf_virtuemart_products`
INNER JOIN `lelwf_virtuemart_products_lt_lt` using (`virtuemart_product_id`)
LEFT JOIN `lelwf_virtuemart_product_manufacturers`
on `lelwf_virtuemart_product_manufacturers`.`virtuemart_product_id`=`lelwf_virtuemart_products`.`virtuemart_product_id`
LEFT JOIN `lelwf_virtuemart_product_customfields`
on `lelwf_virtuemart_product_customfields`.`virtuemart_product_id`=`lelwf_virtuemart_products`.`virtuemart_product_id`
WHERE `lelwf_virtuemart_products`.`virtuemart_product_id` = "1151"
SELECT `virtuemart_media_id`
FROM `lelwf_virtuemart_product_medias`
WHERE `virtuemart_product_id` = "1151"
ORDER BY `ordering`
SELECT `virtuemart_shoppergroup_id`
FROM `lelwf_virtuemart_product_shoppergroups`
WHERE `virtuemart_product_id` = "1151"
SELECT *
FROM `lelwf_virtuemart_product_prices`
WHERE `virtuemart_product_id` = "1151"
AND ( `virtuemart_shoppergroup_id` ="1" OR `virtuemart_shoppergroup_id` IS NULL OR `virtuemart_shoppergroup_id`="0")
AND ( (`product_price_publish_up` IS NULL OR `product_price_publish_up` = "0000-00-00 00:00:00" OR `product_price_publish_up` <= "2025-01-14 02:51:41" )
AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2025-01-14 02:51:41" ) )
AND( (`price_quantity_start` IS NULL OR `price_quantity_start`="0" OR `price_quantity_start` <= 1)
AND (`price_quantity_end` IS NULL OR `price_quantity_end`="0" OR `price_quantity_end` >= 1) )
SELECT pc.`virtuemart_category_id`
FROM `lelwf_virtuemart_product_categories` as pc
WHERE pc.`virtuemart_product_id` = 1151
SELECT pc.`virtuemart_category_id`
FROM `lelwf_virtuemart_product_categories` as pc
LEFT JOIN `lelwf_virtuemart_categories` as c
ON c.`virtuemart_category_id` = pc.`virtuemart_category_id`
WHERE pc.`virtuemart_product_id` = 1151
AND `published`=1
ORDER BY `c`.`ordering` ASC
SELECT `ordering`,`id`
FROM `lelwf_virtuemart_product_categories`
WHERE `virtuemart_product_id` = "1151"
and `virtuemart_category_id`= "78"
SELECT `slug`
FROM `lelwf_virtuemart_products_lt_lt`
WHERE `virtuemart_product_id` = 1151
SELECT `lelwf_virtuemart_products`.* ,`lelwf_virtuemart_products_lt_lt`.* ,`lelwf_virtuemart_product_manufacturers`.`virtuemart_manufacturer_id` ,`lelwf_virtuemart_product_customfields`.`virtuemart_customfield_id`
FROM `lelwf_virtuemart_products`
INNER JOIN `lelwf_virtuemart_products_lt_lt` using (`virtuemart_product_id`)
LEFT JOIN `lelwf_virtuemart_product_manufacturers`
on `lelwf_virtuemart_product_manufacturers`.`virtuemart_product_id`=`lelwf_virtuemart_products`.`virtuemart_product_id`
LEFT JOIN `lelwf_virtuemart_product_customfields`
on `lelwf_virtuemart_product_customfields`.`virtuemart_product_id`=`lelwf_virtuemart_products`.`virtuemart_product_id`
WHERE `lelwf_virtuemart_products`.`virtuemart_product_id` = "1314"
SELECT `virtuemart_media_id`
FROM `lelwf_virtuemart_product_medias`
WHERE `virtuemart_product_id` = "1314"
ORDER BY `ordering`
SELECT `virtuemart_shoppergroup_id`
FROM `lelwf_virtuemart_product_shoppergroups`
WHERE `virtuemart_product_id` = "1314"
SELECT *
FROM `lelwf_virtuemart_product_prices`
WHERE `virtuemart_product_id` = "1314"
AND ( `virtuemart_shoppergroup_id` ="1" OR `virtuemart_shoppergroup_id` IS NULL OR `virtuemart_shoppergroup_id`="0")
AND ( (`product_price_publish_up` IS NULL OR `product_price_publish_up` = "0000-00-00 00:00:00" OR `product_price_publish_up` <= "2025-01-14 02:51:41" )
AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2025-01-14 02:51:41" ) )
AND( (`price_quantity_start` IS NULL OR `price_quantity_start`="0" OR `price_quantity_start` <= 1)
AND (`price_quantity_end` IS NULL OR `price_quantity_end`="0" OR `price_quantity_end` >= 1) )
SELECT pc.`virtuemart_category_id`
FROM `lelwf_virtuemart_product_categories` as pc
WHERE pc.`virtuemart_product_id` = 1314
SELECT pc.`virtuemart_category_id`
FROM `lelwf_virtuemart_product_categories` as pc
LEFT JOIN `lelwf_virtuemart_categories` as c
ON c.`virtuemart_category_id` = pc.`virtuemart_category_id`
WHERE pc.`virtuemart_product_id` = 1314
AND `published`=1
ORDER BY `c`.`ordering` ASC
SELECT `ordering`,`id`
FROM `lelwf_virtuemart_product_categories`
WHERE `virtuemart_product_id` = "1314"
and `virtuemart_category_id`= "101"
SELECT `lelwf_virtuemart_categories`.* ,`lelwf_virtuemart_categories_lt_lt`.*
FROM `lelwf_virtuemart_categories`
INNER JOIN `lelwf_virtuemart_categories_lt_lt` using (`virtuemart_category_id`)
WHERE `lelwf_virtuemart_categories`.`virtuemart_category_id` = "101"
SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
FROM lelwf_virtuemart_category_categories AS `xref`
WHERE `xref`.`category_child_id`= 101
SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
FROM lelwf_virtuemart_category_categories AS `xref`
WHERE `xref`.`category_child_id`= 92
SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
FROM lelwf_virtuemart_category_categories AS `xref`
WHERE `xref`.`category_child_id`= 43
SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
FROM lelwf_virtuemart_category_categories AS `xref`
WHERE `xref`.`category_child_id`= 50
SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
FROM lelwf_virtuemart_category_categories AS `xref`
WHERE `xref`.`category_child_id`= 101
SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
FROM lelwf_virtuemart_category_categories AS `xref`
WHERE `xref`.`category_child_id`= 92
SELECT `slug` as name
FROM `lelwf_virtuemart_categories_lt_lt`
WHERE `virtuemart_category_id`=101
SELECT `slug`
FROM `lelwf_virtuemart_products_lt_lt`
WHERE `virtuemart_product_id` = 1314
SELECT `lelwf_virtuemart_products`.* ,`lelwf_virtuemart_products_lt_lt`.* ,`lelwf_virtuemart_product_manufacturers`.`virtuemart_manufacturer_id` ,`lelwf_virtuemart_product_customfields`.`virtuemart_customfield_id`
FROM `lelwf_virtuemart_products`
INNER JOIN `lelwf_virtuemart_products_lt_lt` using (`virtuemart_product_id`)
LEFT JOIN `lelwf_virtuemart_product_manufacturers`
on `lelwf_virtuemart_product_manufacturers`.`virtuemart_product_id`=`lelwf_virtuemart_products`.`virtuemart_product_id`
LEFT JOIN `lelwf_virtuemart_product_customfields`
on `lelwf_virtuemart_product_customfields`.`virtuemart_product_id`=`lelwf_virtuemart_products`.`virtuemart_product_id`
WHERE `lelwf_virtuemart_products`.`virtuemart_product_id` = "762"
SELECT `virtuemart_media_id`
FROM `lelwf_virtuemart_product_medias`
WHERE `virtuemart_product_id` = "762"
ORDER BY `ordering`
SELECT `virtuemart_shoppergroup_id`
FROM `lelwf_virtuemart_product_shoppergroups`
WHERE `virtuemart_product_id` = "762"
SELECT *
FROM `lelwf_virtuemart_product_prices`
WHERE `virtuemart_product_id` = "762"
AND ( `virtuemart_shoppergroup_id` ="1" OR `virtuemart_shoppergroup_id` IS NULL OR `virtuemart_shoppergroup_id`="0")
AND ( (`product_price_publish_up` IS NULL OR `product_price_publish_up` = "0000-00-00 00:00:00" OR `product_price_publish_up` <= "2025-01-14 02:51:41" )
AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2025-01-14 02:51:41" ) )
AND( (`price_quantity_start` IS NULL OR `price_quantity_start`="0" OR `price_quantity_start` <= 1)
AND (`price_quantity_end` IS NULL OR `price_quantity_end`="0" OR `price_quantity_end` >= 1) )
SELECT pc.`virtuemart_category_id`
FROM `lelwf_virtuemart_product_categories` as pc
WHERE pc.`virtuemart_product_id` = 762
SELECT pc.`virtuemart_category_id`
FROM `lelwf_virtuemart_product_categories` as pc
LEFT JOIN `lelwf_virtuemart_categories` as c
ON c.`virtuemart_category_id` = pc.`virtuemart_category_id`
WHERE pc.`virtuemart_product_id` = 762
AND `published`=1
ORDER BY `c`.`ordering` ASC
SELECT `ordering`,`id`
FROM `lelwf_virtuemart_product_categories`
WHERE `virtuemart_product_id` = "762"
and `virtuemart_category_id`= "172"
SELECT `lelwf_virtuemart_categories`.* ,`lelwf_virtuemart_categories_lt_lt`.*
FROM `lelwf_virtuemart_categories`
INNER JOIN `lelwf_virtuemart_categories_lt_lt` using (`virtuemart_category_id`)
WHERE `lelwf_virtuemart_categories`.`virtuemart_category_id` = "172"
SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
FROM lelwf_virtuemart_category_categories AS `xref`
WHERE `xref`.`category_child_id`= 172
SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
FROM lelwf_virtuemart_category_categories AS `xref`
WHERE `xref`.`category_child_id`= 83
SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
FROM lelwf_virtuemart_category_categories AS `xref`
WHERE `xref`.`category_child_id`= 50
SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
FROM lelwf_virtuemart_category_categories AS `xref`
WHERE `xref`.`category_child_id`= 172
SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
FROM lelwf_virtuemart_category_categories AS `xref`
WHERE `xref`.`category_child_id`= 83
SELECT `slug` as name
FROM `lelwf_virtuemart_categories_lt_lt`
WHERE `virtuemart_category_id`=172
SELECT `slug`
FROM `lelwf_virtuemart_products_lt_lt`
WHERE `virtuemart_product_id` = 762
SELECT `lelwf_virtuemart_medias`.*
FROM `lelwf_virtuemart_medias`
WHERE `lelwf_virtuemart_medias`.`virtuemart_media_id` = "2211"
SELECT `lelwf_virtuemart_medias`.*
FROM `lelwf_virtuemart_medias`
WHERE `lelwf_virtuemart_medias`.`virtuemart_media_id` = "986"
SELECT `lelwf_virtuemart_medias`.*
FROM `lelwf_virtuemart_medias`
WHERE `lelwf_virtuemart_medias`.`virtuemart_media_id` = "1329"
SELECT `lelwf_virtuemart_medias`.*
FROM `lelwf_virtuemart_medias`
WHERE `lelwf_virtuemart_medias`.`virtuemart_media_id` = "1328"
SELECT `lelwf_virtuemart_medias`.*
FROM `lelwf_virtuemart_medias`
WHERE `lelwf_virtuemart_medias`.`virtuemart_media_id` = "2217"
SELECT `lelwf_virtuemart_medias`.*
FROM `lelwf_virtuemart_medias`
WHERE `lelwf_virtuemart_medias`.`virtuemart_media_id` = "2215"
SELECT `lelwf_virtuemart_medias`.*
FROM `lelwf_virtuemart_medias`
WHERE `lelwf_virtuemart_medias`.`virtuemart_media_id` = "2216"
SELECT `lelwf_virtuemart_medias`.*
FROM `lelwf_virtuemart_medias`
WHERE `lelwf_virtuemart_medias`.`virtuemart_media_id` = "1681"
SELECT `lelwf_virtuemart_medias`.*
FROM `lelwf_virtuemart_medias`
WHERE `lelwf_virtuemart_medias`.`virtuemart_media_id` = "1716"
SELECT `lelwf_virtuemart_medias`.*
FROM `lelwf_virtuemart_medias`
WHERE `lelwf_virtuemart_medias`.`virtuemart_media_id` = "1680"
SELECT `lelwf_virtuemart_medias`.*
FROM `lelwf_virtuemart_medias`
WHERE `lelwf_virtuemart_medias`.`virtuemart_media_id` = "593"
SELECT `lelwf_virtuemart_medias`.*
FROM `lelwf_virtuemart_medias`
WHERE `lelwf_virtuemart_medias`.`virtuemart_media_id` = "1578"
SELECT `lelwf_virtuemart_medias`.*
FROM `lelwf_virtuemart_medias`
WHERE `lelwf_virtuemart_medias`.`virtuemart_media_id` = "1130"
SELECT `lelwf_virtuemart_medias`.*
FROM `lelwf_virtuemart_medias`
WHERE `lelwf_virtuemart_medias`.`virtuemart_media_id` = "911"
SELECT `lelwf_virtuemart_medias`.*
FROM `lelwf_virtuemart_medias`
WHERE `lelwf_virtuemart_medias`.`virtuemart_media_id` = "2415"
SELECT `lelwf_virtuemart_medias`.*
FROM `lelwf_virtuemart_medias`
WHERE `lelwf_virtuemart_medias`.`virtuemart_media_id` = "744"
SELECT `lelwf_virtuemart_medias`.*
FROM `lelwf_virtuemart_medias`
WHERE `lelwf_virtuemart_medias`.`virtuemart_media_id` = "745"
SELECT `lelwf_virtuemart_medias`.*
FROM `lelwf_virtuemart_medias`
WHERE `lelwf_virtuemart_medias`.`virtuemart_media_id` = "2285"
SELECT `lelwf_virtuemart_medias`.*
FROM `lelwf_virtuemart_medias`
WHERE `lelwf_virtuemart_medias`.`virtuemart_media_id` = "2214"
SELECT `lelwf_virtuemart_medias`.*
FROM `lelwf_virtuemart_medias`
WHERE `lelwf_virtuemart_medias`.`virtuemart_media_id` = "2212"
SELECT `lelwf_virtuemart_medias`.*
FROM `lelwf_virtuemart_medias`
WHERE `lelwf_virtuemart_medias`.`virtuemart_media_id` = "2213"
SELECT `lelwf_virtuemart_medias`.*
FROM `lelwf_virtuemart_medias`
WHERE `lelwf_virtuemart_medias`.`virtuemart_media_id` = "977"
SELECT `lelwf_virtuemart_medias`.*
FROM `lelwf_virtuemart_medias`
WHERE `lelwf_virtuemart_medias`.`virtuemart_media_id` = "1830"
SELECT `lelwf_virtuemart_medias`.*
FROM `lelwf_virtuemart_medias`
WHERE `lelwf_virtuemart_medias`.`virtuemart_media_id` = "1584"
SELECT `lelwf_virtuemart_medias`.*
FROM `lelwf_virtuemart_medias`
WHERE `lelwf_virtuemart_medias`.`virtuemart_media_id` = "2210"
SELECT `lelwf_virtuemart_medias`.*
FROM `lelwf_virtuemart_medias`
WHERE `lelwf_virtuemart_medias`.`virtuemart_media_id` = "507"
SELECT `lelwf_virtuemart_medias`.*
FROM `lelwf_virtuemart_medias`
WHERE `lelwf_virtuemart_medias`.`virtuemart_media_id` = "622"
SELECT `lelwf_virtuemart_medias`.*
FROM `lelwf_virtuemart_medias`
WHERE `lelwf_virtuemart_medias`.`virtuemart_media_id` = "2571"
SELECT `lelwf_virtuemart_medias`.*
FROM `lelwf_virtuemart_medias`
WHERE `lelwf_virtuemart_medias`.`virtuemart_media_id` = "2572"
SELECT `lelwf_virtuemart_medias`.*
FROM `lelwf_virtuemart_medias`
WHERE `lelwf_virtuemart_medias`.`virtuemart_media_id` = "1962"
SELECT `lelwf_virtuemart_medias`.*
FROM `lelwf_virtuemart_medias`
WHERE `lelwf_virtuemart_medias`.`virtuemart_media_id` = "1910"
SELECT `lelwf_virtuemart_medias`.*
FROM `lelwf_virtuemart_medias`
WHERE `lelwf_virtuemart_medias`.`virtuemart_media_id` = "1911"
SELECT `lelwf_virtuemart_medias`.*
FROM `lelwf_virtuemart_medias`
WHERE `lelwf_virtuemart_medias`.`virtuemart_media_id` = "1223"
SELECT `lelwf_virtuemart_medias`.*
FROM `lelwf_virtuemart_medias`
WHERE `lelwf_virtuemart_medias`.`virtuemart_media_id` = "976"
SELECT `lelwf_virtuemart_medias`.*
FROM `lelwf_virtuemart_medias`
WHERE `lelwf_virtuemart_medias`.`virtuemart_media_id` = "2333"
SELECT `lelwf_virtuemart_medias`.*
FROM `lelwf_virtuemart_medias`
WHERE `lelwf_virtuemart_medias`.`virtuemart_media_id` = "1663"
SELECT `lelwf_virtuemart_medias`.*
FROM `lelwf_virtuemart_medias`
WHERE `lelwf_virtuemart_medias`.`virtuemart_media_id` = "1451"
SELECT `lelwf_virtuemart_medias`.*
FROM `lelwf_virtuemart_medias`
WHERE `lelwf_virtuemart_medias`.`virtuemart_media_id` = "1454"
SELECT `lelwf_virtuemart_medias`.*
FROM `lelwf_virtuemart_medias`
WHERE `lelwf_virtuemart_medias`.`virtuemart_media_id` = "1452"
SELECT `lelwf_virtuemart_medias`.*
FROM `lelwf_virtuemart_medias`
WHERE `lelwf_virtuemart_medias`.`virtuemart_media_id` = "2237"
SELECT `lelwf_virtuemart_medias`.*
FROM `lelwf_virtuemart_medias`
WHERE `lelwf_virtuemart_medias`.`virtuemart_media_id` = "594"
SELECT `lelwf_virtuemart_medias`.*
FROM `lelwf_virtuemart_medias`
WHERE `lelwf_virtuemart_medias`.`virtuemart_media_id` = "2517"
SELECT `lelwf_virtuemart_medias`.*
FROM `lelwf_virtuemart_medias`
WHERE `lelwf_virtuemart_medias`.`virtuemart_media_id` = "2518"
SELECT `lelwf_virtuemart_medias`.*
FROM `lelwf_virtuemart_medias`
WHERE `lelwf_virtuemart_medias`.`virtuemart_media_id` = "600"
SELECT `lelwf_virtuemart_medias`.*
FROM `lelwf_virtuemart_medias`
WHERE `lelwf_virtuemart_medias`.`virtuemart_media_id` = "2472"
SELECT `lelwf_virtuemart_medias`.*
FROM `lelwf_virtuemart_medias`
WHERE `lelwf_virtuemart_medias`.`virtuemart_media_id` = "2474"
SELECT `lelwf_virtuemart_medias`.*
FROM `lelwf_virtuemart_medias`
WHERE `lelwf_virtuemart_medias`.`virtuemart_media_id` = "1164"
SELECT `lelwf_virtuemart_medias`.*
FROM `lelwf_virtuemart_medias`
WHERE `lelwf_virtuemart_medias`.`virtuemart_media_id` = "1165"
SELECT `lelwf_virtuemart_medias`.*
FROM `lelwf_virtuemart_medias`
WHERE `lelwf_virtuemart_medias`.`virtuemart_media_id` = "2367"
SELECT `lelwf_virtuemart_medias`.*
FROM `lelwf_virtuemart_medias`
WHERE `lelwf_virtuemart_medias`.`virtuemart_media_id` = "2248"
SELECT `lelwf_virtuemart_medias`.*
FROM `lelwf_virtuemart_medias`
WHERE `lelwf_virtuemart_medias`.`virtuemart_media_id` = "1318"
UPDATE lelwf_content
SET hits = hits + 1
WHERE id = 28
SELECT manifest_cache
FROM lelwf_extensions
WHERE element='vp_megamart';
SELECT *
FROM lelwf_modules
WHERE published=1
AND position='menu'
AND module='mod_menu'
AND client_id=0
ORDER BY id
;
SELECT extension_id AS id, element AS "option", params, enabled
FROM lelwf_extensions
WHERE `type` = 'component'
AND `element` = 'com_contact'
SELECT *
FROM lelwf_virtuemart_calcs
WHERE
`calc_kind`="DBTaxBill"
AND `published`="1"
AND (`virtuemart_vendor_id`="1" OR `shared`="1" )
AND ( publish_up = "0000-00-00 00:00:00" OR publish_up <= "2025-01-14 02:51:41" )
AND ( publish_down = "0000-00-00 00:00:00" OR publish_down >= "2025-01-14 02:51:41" )
SELECT *
FROM lelwf_virtuemart_calcs
WHERE
`calc_kind`="TaxBill"
AND `published`="1"
AND (`virtuemart_vendor_id`="1" OR `shared`="1" )
AND ( publish_up = "0000-00-00 00:00:00" OR publish_up <= "2025-01-14 02:51:41" )
AND ( publish_down = "0000-00-00 00:00:00" OR publish_down >= "2025-01-14 02:51:41" )
SELECT *
FROM lelwf_virtuemart_calcs
WHERE
`calc_kind`="DATaxBill"
AND `published`="1"
AND (`virtuemart_vendor_id`="1" OR `shared`="1" )
AND ( publish_up = "0000-00-00 00:00:00" OR publish_up <= "2025-01-14 02:51:41" )
AND ( publish_down = "0000-00-00 00:00:00" OR publish_down >= "2025-01-14 02:51:41" )
SELECT *
FROM lelwf_modules
WHERE published=1
AND position='mini-promo'
ORDER BY id
;
UPDATE `lelwf_session`
SET `data` = '__default|a:7:{s:15:\"session.counter\";i:1;s:19:\"session.timer.start\";i:1736823101;s:18:\"session.timer.last\";i:1736823101;s:17:\"session.timer.now\";i:1736823101;s:22:\"session.client.browser\";s:40:\"CCBot/2.0 (https://commoncrawl.org/faq/)\";s:8:\"registry\";O:9:\"JRegistry\":1:{s:7:\"\0*\0data\";O:8:\"stdClass\":0:{}}s:4:\"user\";O:5:\"JUser\":25:{s:9:\"\0*\0isRoot\";b:0;s:2:\"id\";i:0;s:4:\"name\";N;s:8:\"username\";N;s:5:\"email\";N;s:8:\"password\";N;s:14:\"password_clear\";s:0:\"\";s:8:\"usertype\";N;s:5:\"block\";N;s:9:\"sendEmail\";i:0;s:12:\"registerDate\";N;s:13:\"lastvisitDate\";N;s:10:\"activation\";N;s:6:\"params\";N;s:6:\"groups\";a:0:{}s:5:\"guest\";i:1;s:13:\"lastResetTime\";N;s:10:\"resetCount\";N;s:10:\"\0*\0_params\";O:9:\"JRegistry\":1:{s:7:\"\0*\0data\";O:8:\"stdClass\":0:{}}s:14:\"\0*\0_authGroups\";a:1:{i:0;i:1;}s:14:\"\0*\0_authLevels\";a:2:{i:0;i:1;i:1;i:1;}s:15:\"\0*\0_authActions\";N;s:12:\"\0*\0_errorMsg\";N;s:10:\"\0*\0_errors\";a:0:{}s:3:\"aid\";i:0;}}__vm|a:1:{s:6:\"vmcart\";s:645:\"O:8:\"stdClass\":24:{s:8:\"products\";a:0:{}s:8:\"vendorId\";i:1;s:21:\"lastVisitedCategoryId\";i:0;s:28:\"virtuemart_shipmentmethod_id\";i:0;s:27:\"virtuemart_paymentmethod_id\";i:0;s:25:\"automaticSelectedShipment\";b:0;s:24:\"automaticSelectedPayment\";b:0;s:12:\"order_number\";N;s:2:\"BT\";i:0;s:2:\"ST\";i:0;s:11:\"tosAccepted\";N;s:16:\"customer_comment\";s:0:\"\";s:10:\"couponCode\";s:0:\"\";s:20:\"_triesValidateCoupon\";a:0:{}s:14:\"order_language\";s:0:\"\";s:8:\"cartData\";N;s:5:\"lists\";N;s:14:\"pricesCurrency\";N;s:15:\"paymentCurrency\";N;s:11:\"_inCheckOut\";b:0;s:14:\"_dataValidated\";b:0;s:12:\"_confirmDone\";b:0;s:10:\"STsameAsBT\";b:1;s:15:\"customer_number\";s:7:\"nonreg_\";}\";}'
, `time` = '1736823102'
WHERE `session_id` = 'enj988kmj2b5ghafmd7quh27l0'
106 × SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
FROM lelwf_virtuemart_category_categories AS `xref`
51 × SELECT `lelwf_virtuemart_medias`.*
FROM `lelwf_virtuemart_medias`
35 × SELECT *
FROM `lelwf_virtuemart_product_prices`
35 × SELECT `virtuemart_shoppergroup_id`
FROM `lelwf_virtuemart_product_shoppergroups`
35 × SELECT pc.`virtuemart_category_id`
FROM `lelwf_virtuemart_product_categories` as pc
35 × SELECT `ordering`,`id`
FROM `lelwf_virtuemart_product_categories`
35 × SELECT `slug`
FROM `lelwf_virtuemart_products_lt_lt`
35 × SELECT `lelwf_virtuemart_products`.* ,`lelwf_virtuemart_products_lt_lt`.* ,`lelwf_virtuemart_product_manufacturers`.`virtuemart_manufacturer_id` ,`lelwf_virtuemart_product_customfields`.`virtuemart_customfield_id`
FROM `lelwf_virtuemart_products`
INNER JOIN `lelwf_virtuemart_products_lt_lt` using (`virtuemart_product_id`)
LEFT JOIN `lelwf_virtuemart_product_manufacturers`
on `lelwf_virtuemart_product_manufacturers`.`virtuemart_product_id`=`lelwf_virtuemart_products`.`virtuemart_product_id`
LEFT JOIN `lelwf_virtuemart_product_customfields`
on `lelwf_virtuemart_product_customfields`.`virtuemart_product_id`=`lelwf_virtuemart_products`.`virtuemart_product_id`
35 × SELECT pc.`virtuemart_category_id`
FROM `lelwf_virtuemart_product_categories` as pc
LEFT JOIN `lelwf_virtuemart_categories` as c
ON c.`virtuemart_category_id` = pc.`virtuemart_category_id`
35 × SELECT `virtuemart_media_id`
FROM `lelwf_virtuemart_product_medias`
30 × SELECT `slug` as name
FROM `lelwf_virtuemart_categories_lt_lt`
20 × SELECT `lelwf_virtuemart_categories`.* ,`lelwf_virtuemart_categories_lt_lt`.*
FROM `lelwf_virtuemart_categories`
INNER JOIN `lelwf_virtuemart_categories_lt_lt` using (`virtuemart_category_id`)
5 × SELECT extension_id AS id, element AS "option", params, enabled
FROM lelwf_extensions
4 × SELECT *
FROM lelwf_virtuemart_calcs
2 × SELECT *
FROM `lelwf_virtuemart_shoppergroups`
2 × SELECT b.rules
FROM lelwf_assets AS a
LEFT JOIN lelwf_assets AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
1 × SELECT b.id
FROM lelwf_usergroups AS a
LEFT JOIN lelwf_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
1 × SELECT *
FROM lelwf_modules
1 × SELECT *
FROM `lelwf_menu`
1 × SELECT *
FROM lelwf_modules
1 × SELECT `price_display`,`custom_price_display`
FROM `lelwf_virtuemart_shoppergroups` AS `sg`
1 × SELECT manifest_cache
FROM lelwf_extensions
1 × SELECT `virtuemart_category_id`
FROM lelwf_virtuemart_calc_categories
1 × SELECT `virtuemart_state_id`
FROM lelwf_virtuemart_calc_states
1 × SELECT `virtuemart_manufacturer_id`
FROM lelwf_virtuemart_calc_manufacturers
1 × SELECT `virtuemart_country_id`
FROM lelwf_virtuemart_calc_countries
1 × SELECT *
FROM `lelwf_virtuemart_currencies`
1 × SELECT `virtuemart_shoppergroup_id`
FROM lelwf_virtuemart_calc_shoppergroups
1 × SELECT `session_id`
FROM `lelwf_session`
1 × SELECT id, rules
FROM `lelwf_viewlevels
1 × SELECT `config`
FROM `lelwf_virtuemart_configs`
1 × SELECT id
FROM lelwf_assets
1 × SELECT `virtuemart_shoppergroup_id`
FROM `lelwf_virtuemart_vmuser_shoppergroups`
1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM lelwf_modules AS m
LEFT JOIN lelwf_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN lelwf_extensions AS e
ON e.element = m.module
AND e.client_id = m.client_id
1 × SELECT a.sef AS sef,a.lang_code AS lang_code
FROM lelwf_languages AS
1 × SELECT a.id, a.asset_id, a.title, a.alias, a.title_alias, a.introtext, a.fulltext,
CASE WHEN badcats.id is null THEN a.state ELSE 0 END AS state, a.mask, a.catid, a.created, a.created_by, a.created_by_alias,
CASE WHEN a.modified = 0 THEN a.created ELSE a.modified END as modified, a.modified_by, a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.images, a.urls, a.attribs, a.version, a.parentid, a.ordering, a.metakey, a.metadesc, a.access, a.hits, a.metadata, a.featured, a.language, a.xreference,c.title AS category_title, c.alias AS category_alias, c.access AS category_access,u.name AS author,( SELECT MAX(contact.id) AS id
FROM lelwf_contact_details AS contact
1 × SELECT c.*,
CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
FROM lelwf_categories as c
LEFT JOIN lelwf_categories AS s
ON (s.lft < c.lft
AND s.rgt > c.rgt
AND c.language in ('lt-LT','*')) OR (s.lft >= c.lft
AND s.rgt <= c.rgt)
LEFT JOIN (SELECT cat.id as id
FROM lelwf_categories AS cat JOIN lelwf_categories AS parent
ON cat.lft BETWEEN parent.lft
AND parent.rgt
1 × SELECT p.`virtuemart_product_id`
FROM `lelwf_virtuemart_products` as p
INNER JOIN `lelwf_virtuemart_products_lt_lt` as l using (`virtuemart_product_id`)
LEFT JOIN `lelwf_virtuemart_product_shoppergroups` as ps
ON p.`virtuemart_product_id` = `ps`.`virtuemart_product_id`
LEFT JOIN `lelwf_virtuemart_product_categories` as pc
ON p.`virtuemart_product_id` = `pc`.`virtuemart_product_id`
1 × SELECT id, home, template, s.params
FROM lelwf_template_styles as s
LEFT JOIN lelwf_extensions as e
ON e.element=s.template
AND e.type='template'
AND e.client_id=s.client_id
1 × SELECT folder AS type, element AS name, params
FROM lelwf_extensions
1 × SELECT a.rules
FROM lelwf_assets AS a
1 × SELECT *
FROM lelwf_languages
1 × SELECT COUNT(*)
FROM `lelwf_menu`
1 × SELECT `data`
FROM `lelwf_session`
1 × SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.type, m.level, m.language,m.browserNav, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component
FROM lelwf_menu AS m
LEFT JOIN lelwf_extensions AS e
ON m.component_id = e.extension_id
1 × SELECT `vendor_currency`,`currency_code_3`,`currency_numeric_code`
FROM `lelwf_virtuemart_vendors` AS v
LEFT JOIN `lelwf_virtuemart_currencies` AS c
ON virtuemart_currency_id = vendor_currency
1 × UPDATE lelwf_content
SET hits = hits + 1
1 × UPDATE `lelwf_session`
SET `data` = '__default|a:7:{s:15:\"session.counter\";i:1;s:19:\"session.timer.start\";i:1736823101;s:18:\"session.timer.last\";i:1736823101;s:17:\"session.timer.now\";i:1736823101;s:22:\"session.client.browser\";s:40:\"CCBot/2.0 (https://commoncrawl.org/faq/)\";s:8:\"registry\";O:9:\"JRegistry\":1:{s:7:\"\0*\0data\";O:8:\"stdClass\":0:{}}s:4:\"user\";O:5:\"JUser\":25:{s:9:\"\0*\0isRoot\";b:0;s:2:\"id\";i:0;s:4:\"name\";N;s:8:\"username\";N;s:5:\"email\";N;s:8:\"password\";N;s:14:\"password_clear\";s:0:\"\";s:8:\"usertype\";N;s:5:\"block\";N;s:9:\"sendEmail\";i:0;s:12:\"registerDate\";N;s:13:\"lastvisitDate\";N;s:10:\"activation\";N;s:6:\"params\";N;s:6:\"groups\";a:0:{}s:5:\"guest\";i:1;s:13:\"lastResetTime\";N;s:10:\"resetCount\";N;s:10:\"\0*\0_params\";O:9:\"JRegistry\":1:{s:7:\"\0*\0data\";O:8:\"stdClass\":0:{}}s:14:\"\0*\0_authGroups\";a:1:{i:0;i:1;}s:14:\"\0*\0_authLevels\";a:2:{i:0;i:1;i:1;i:1;}s:15:\"\0*\0_authActions\";N;s:12:\"\0*\0_errorMsg\";N;s:10:\"\0*\0_errors\";a:0:{}s:3:\"aid\";i:0;}}__vm|a:1:{s:6:\"vmcart\";s:645:\"O:8:\"stdClass\":24:{s:8:\"products\";a:0:{}s:8:\"vendorId\";i:1;s:21:\"lastVisitedCategoryId\";i:0;s:28:\"virtuemart_shipmentmethod_id\";i:0;s:27:\"virtuemart_paymentmethod_id\";i:0;s:25:\"automaticSelectedShipment\";b:0;s:24:\"automaticSelectedPayment\";b:0;s:12:\"order_number\";N;s:2:\"BT\";i:0;s:2:\"ST\";i:0;s:11:\"tosAccepted\";N;s:16:\"customer_comment\";s:0:\"\";s:10:\"couponCode\";s:0:\"\";s:20:\"_triesValidateCoupon\";a:0:{}s:14:\"order_language\";s:0:\"\";s:8:\"cartData\";N;s:5:\"lists\";N;s:14:\"pricesCurrency\";N;s:15:\"paymentCurrency\";N;s:11:\"_inCheckOut\";b:0;s:14:\"_dataValidated\";b:0;s:12:\"_confirmDone\";b:0;s:10:\"STsameAsBT\";b:1;s:15:\"customer_number\";s:7:\"nonreg_\";}\";}' , `time` = '1736823102'
1 × SHOW FULL COLUMNS
FROM `lelwf_assets
1 × SHOW TABLES LIKE "lelwf_virtuemart_configs
1 × INSERT INTO `lelwf_session` (`session_id`, `client_id`, `time`)
VALUES ('enj988kmj2b5ghafmd7quh27l0', 0, '1736823101'
1 × DELETE
FROM `lelwf_session`