Need assistance?
Call us at our office hours or email us and we will contact you. Sunday to Thursday 09:00-17:30 Jerusalem time (GMT+3). +97249999524 info@omega3galil.com
Omega Galil Products Store - Fresh Omega 3 from the refrigerator
SELECT extension_id AS id, element AS "option", params, enabled
FROMml0nf_extensions WHERE `type` = 'component' AND `element` = 'com_users'
SELECT b.id
FROMml0nf_usergroupsAS a
LEFTJOINml0nf_usergroupsAS b ON b.lft <= a.lft AND b.rgt >= a.rgt
WHERE a.id = 1
SELECT id, rules
FROM `ml0nf_viewlevels`
SELECT folder AS type, element AS name, params
FROMml0nf_extensions WHERE enabled >= 1 AND type ='plugin' AND state >= 0 AND access IN (1,1)
ORDERBY ordering
SELECT* FROMml0nf_languages WHERE published=1
ORDERBY ordering ASC
SELECT extension_id AS id, element AS "option", params, enabled
FROMml0nf_extensions WHERE `type` = 'component' AND `element` = 'com_languages'
SELECT language,id
FROM `ml0nf_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
FROMml0nf_menuAS m
LEFTJOINml0nf_extensionsAS e ON m.component_id = e.extension_id
WHERE m.published = 1 AND m.parent_id > 0 AND m.client_id = 0
ORDERBY m.lft
SHOWTABLESLIKE 'ml0nf_onepage_config'
select * from ml0nf_onepage_config where config_name = 'opc_load_jquery'
SHOWTABLESLIKE "ml0nf_virtuemart_configs"
SELECT `config` FROM `ml0nf_virtuemart_configs` WHERE `virtuemart_config_id` = "1";
SELECT a.rules
FROMml0nf_assetsAS a
WHERE (a.id = 1)
GROUPBY a.id, a.rules, a.lft
SELECT b.rules
FROMml0nf_assetsAS a
LEFTJOINml0nf_assetsAS b ON b.lft <= a.lft AND b.rgt >= a.rgt
WHERE (a.id = 1)
GROUPBY b.id, b.rules, b.lft
ORDERBY b.lft
SELECT extension_id AS id, element AS "option", params, enabled
FROMml0nf_extensions WHERE `type` = 'component' AND `element` = 'com_virtuemart'
SELECT id, home, template, s.params
FROMml0nf_template_styles as s
LEFTJOINml0nf_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 `ml0nf_virtuemart_categories`.* ,`ml0nf_virtuemart_categories_en_gb`.* FROM `ml0nf_virtuemart_categories` INNERJOIN `ml0nf_virtuemart_categories_en_gb` using (`virtuemart_category_id`) WHERE `ml0nf_virtuemart_categories`.`virtuemart_category_id` = "1"
SELECT `ml0nf_virtuemart_categories`.* ,`ml0nf_virtuemart_categories_he_il`.* FROM `ml0nf_virtuemart_categories` INNERJOIN `ml0nf_virtuemart_categories_he_il` using (`virtuemart_category_id`) WHERE `ml0nf_virtuemart_categories`.`virtuemart_category_id` = "1"
SELECT `virtuemart_media_id` FROM `ml0nf_virtuemart_category_medias` WHERE `virtuemart_category_id` = "1" ORDERBY `ordering`
SELECT `category_child_id`
FROM `ml0nf_virtuemart_category_categories`
WHERE `category_parent_id` = 1
SELECT count(ml0nf_virtuemart_products.virtuemart_product_id) AS total
FROM `ml0nf_virtuemart_products`, `ml0nf_virtuemart_product_categories`
WHERE `ml0nf_virtuemart_products`.`virtuemart_vendor_id` = "1"
AND `ml0nf_virtuemart_product_categories`.`virtuemart_category_id` = 1
AND `ml0nf_virtuemart_products`.`virtuemart_product_id` = `ml0nf_virtuemart_product_categories`.`virtuemart_product_id`
AND `ml0nf_virtuemart_products`.`published` = "1"
SELECT `virtuemart_shoppergroup_id` FROM `ml0nf_virtuemart_vmuser_shoppergroups` WHERE `virtuemart_user_id` = "0"
SELECT* FROM `ml0nf_virtuemart_shoppergroups` WHERE `default` = "2" AND (`virtuemart_vendor_id` = "1" OR `shared` = "1") AND `published`="1"
SELECTSQL_CALC_FOUND_ROWS p.`virtuemart_product_id` FROM `ml0nf_virtuemart_products` as p
INNERJOIN `ml0nf_virtuemart_products_en_gb` as l using (`virtuemart_product_id`)
LEFTJOIN `ml0nf_virtuemart_product_shoppergroups` as ps ON p.`virtuemart_product_id` = `ps`.`virtuemart_product_id`
LEFTJOIN `ml0nf_virtuemart_product_categories` as pc ON p.`virtuemart_product_id` = `pc`.`virtuemart_product_id`
WHERE ( p.`published`="1"
AND `pc`.`virtuemart_category_id` = 1
AND ( `ps`.`virtuemart_shoppergroup_id`= "1" OR `ps`.`virtuemart_shoppergroup_id` ISNULL ) )
group by p.`virtuemart_product_id`
ORDERBY `pc`.`ordering` ASC LIMIT 0, 20
SELECTFOUND_ROWS()
SELECT `ml0nf_virtuemart_products`.* ,`ml0nf_virtuemart_products_en_gb`.* ,`ml0nf_virtuemart_product_manufacturers`.`virtuemart_manufacturer_id` ,`ml0nf_virtuemart_product_customfields`.`virtuemart_customfield_id` FROM `ml0nf_virtuemart_products` INNERJOIN `ml0nf_virtuemart_products_en_gb` using (`virtuemart_product_id`) LEFTJOIN `ml0nf_virtuemart_product_manufacturers` on `ml0nf_virtuemart_product_manufacturers`.`virtuemart_product_id`=`ml0nf_virtuemart_products`.`virtuemart_product_id` LEFTJOIN `ml0nf_virtuemart_product_customfields` on `ml0nf_virtuemart_product_customfields`.`virtuemart_product_id`=`ml0nf_virtuemart_products`.`virtuemart_product_id` WHERE `ml0nf_virtuemart_products`.`virtuemart_product_id` = "1"
SELECT `virtuemart_media_id` FROM `ml0nf_virtuemart_product_medias` WHERE `virtuemart_product_id` = "1" ORDERBY `ordering`
SELECT `virtuemart_shoppergroup_id` FROM `ml0nf_virtuemart_product_shoppergroups` WHERE `virtuemart_product_id` = "1"
SELECT* FROM `ml0nf_virtuemart_product_prices` WHERE `virtuemart_product_id` = "1" AND ( `virtuemart_shoppergroup_id` ="1" OR `virtuemart_shoppergroup_id` ISNULLOR `virtuemart_shoppergroup_id`="0") AND ( (`product_price_publish_up` ISNULLOR `product_price_publish_up` = "0000-00-00 00:00:00" OR `product_price_publish_up` <= "2020-11-27 11:45:43" )
AND (`product_price_publish_down` ISNULLOR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2020-11-27 11:45:43" ) ) AND( (`price_quantity_start` ISNULLOR `price_quantity_start`="0" OR `price_quantity_start` <= 1) AND (`price_quantity_end` ISNULLOR `price_quantity_end`="0" OR `price_quantity_end` >= 1) )
SELECT pc.`virtuemart_category_id` FROM `ml0nf_virtuemart_product_categories` as pc WHERE pc.`virtuemart_product_id` = 1
SELECT pc.`virtuemart_category_id` FROM `ml0nf_virtuemart_product_categories` as pc LEFTJOIN `ml0nf_virtuemart_categories` as c ON c.`virtuemart_category_id` = pc.`virtuemart_category_id` WHERE pc.`virtuemart_product_id` = 1 AND `published`=1 ORDERBY `c`.`ordering` ASC
SELECT `ordering`,`id` FROM `ml0nf_virtuemart_product_categories`
WHERE `virtuemart_product_id` = "1" and `virtuemart_category_id`= "1"
SELECT `ml0nf_virtuemart_categories`.* ,`ml0nf_virtuemart_categories_en_gb`.* FROM `ml0nf_virtuemart_categories` INNERJOIN `ml0nf_virtuemart_categories_en_gb` using (`virtuemart_category_id`) WHERE `ml0nf_virtuemart_categories`.`virtuemart_category_id` = "1"
SELECT C.`virtuemart_custom_id` , `custom_element`, `custom_params`, `custom_parent_id` , `admin_only` , `custom_title` , `show_title` , `custom_tip` , C.`custom_value` AS value, `custom_field_desc` , `field_type` , `is_list` , `is_hidden`, `layout_pos`, C.`published` , field.`virtuemart_customfield_id` , field.`custom_value`, field.`custom_param`, field.`custom_price`, field.`ordering`
FROM `ml0nf_virtuemart_customs` AS C
LEFTJOIN `ml0nf_virtuemart_product_customfields` AS field ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
Where `virtuemart_product_id` =1 and `field_type` != "G" and `field_type` != "R" and `field_type` != "Z" and is_cart_attribute = 0 order by field.`ordering`,virtuemart_custom_id
SELECT `vendor_currency`,`currency_code_3`,`currency_numeric_code` FROM `ml0nf_virtuemart_vendors` AS v
LEFTJOIN `ml0nf_virtuemart_currencies` AS c ON virtuemart_currency_id = vendor_currency
WHERE v.`virtuemart_vendor_id`="1"
SELECT* FROM `ml0nf_virtuemart_currencies` WHERE `virtuemart_currency_id`="67"
SELECT `price_display`,`custom_price_display` FROM `ml0nf_virtuemart_shoppergroups` AS `sg`
WHERE `sg`.`default` = "2"
SELECT C.`virtuemart_custom_id` , `custom_parent_id` , `admin_only` , `custom_title` , `custom_tip` , C.`custom_value` AS value, `custom_field_desc` , `field_type` , `is_list` , `is_hidden` , C.`published` , field.`virtuemart_customfield_id` , field.`custom_value`, field.`custom_param`, field.`custom_price`, field.`ordering`
FROM `ml0nf_virtuemart_customs` AS C
LEFTJOIN `ml0nf_virtuemart_product_customfields` AS field ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
Where `virtuemart_product_id` =1 and `field_type` = "Z" and is_cart_attribute = 0 order by ordering
SELECT C.`virtuemart_custom_id` , `custom_parent_id` , `admin_only` , `custom_title` , `custom_tip` , C.`custom_value` AS value, `custom_field_desc` , `field_type` , `is_list` , `is_hidden` , C.`published` , field.`virtuemart_customfield_id` , field.`custom_value`, field.`custom_param`, field.`custom_price`, field.`ordering`
FROM `ml0nf_virtuemart_customs` AS C
LEFTJOIN `ml0nf_virtuemart_product_customfields` AS field ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
Where `virtuemart_product_id` =1 and `field_type` = "R" and is_cart_attribute = 0 order by ordering
SELECT `ml0nf_virtuemart_products`.* ,`ml0nf_virtuemart_products_en_gb`.* ,`ml0nf_virtuemart_product_manufacturers`.`virtuemart_manufacturer_id` ,`ml0nf_virtuemart_product_customfields`.`virtuemart_customfield_id` FROM `ml0nf_virtuemart_products` INNERJOIN `ml0nf_virtuemart_products_en_gb` using (`virtuemart_product_id`) LEFTJOIN `ml0nf_virtuemart_product_manufacturers` on `ml0nf_virtuemart_product_manufacturers`.`virtuemart_product_id`=`ml0nf_virtuemart_products`.`virtuemart_product_id` LEFTJOIN `ml0nf_virtuemart_product_customfields` on `ml0nf_virtuemart_product_customfields`.`virtuemart_product_id`=`ml0nf_virtuemart_products`.`virtuemart_product_id` WHERE `ml0nf_virtuemart_products`.`virtuemart_product_id` = "13"
SELECT `virtuemart_media_id` FROM `ml0nf_virtuemart_product_medias` WHERE `virtuemart_product_id` = "13" ORDERBY `ordering`
SELECT `virtuemart_shoppergroup_id` FROM `ml0nf_virtuemart_product_shoppergroups` WHERE `virtuemart_product_id` = "13"
SELECT* FROM `ml0nf_virtuemart_product_prices` WHERE `virtuemart_product_id` = "13" AND ( `virtuemart_shoppergroup_id` ="1" OR `virtuemart_shoppergroup_id` ISNULLOR `virtuemart_shoppergroup_id`="0") AND ( (`product_price_publish_up` ISNULLOR `product_price_publish_up` = "0000-00-00 00:00:00" OR `product_price_publish_up` <= "2020-11-27 11:45:43" )
AND (`product_price_publish_down` ISNULLOR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2020-11-27 11:45:43" ) ) AND( (`price_quantity_start` ISNULLOR `price_quantity_start`="0" OR `price_quantity_start` <= 1) AND (`price_quantity_end` ISNULLOR `price_quantity_end`="0" OR `price_quantity_end` >= 1) )
SELECT pc.`virtuemart_category_id` FROM `ml0nf_virtuemart_product_categories` as pc WHERE pc.`virtuemart_product_id` = 13
SELECT pc.`virtuemart_category_id` FROM `ml0nf_virtuemart_product_categories` as pc LEFTJOIN `ml0nf_virtuemart_categories` as c ON c.`virtuemart_category_id` = pc.`virtuemart_category_id` WHERE pc.`virtuemart_product_id` = 13 AND `published`=1 ORDERBY `c`.`ordering` ASC
SELECT `ordering`,`id` FROM `ml0nf_virtuemart_product_categories`
WHERE `virtuemart_product_id` = "13" and `virtuemart_category_id`= "1"
SELECT `ml0nf_virtuemart_categories`.* ,`ml0nf_virtuemart_categories_en_gb`.* FROM `ml0nf_virtuemart_categories` INNERJOIN `ml0nf_virtuemart_categories_en_gb` using (`virtuemart_category_id`) WHERE `ml0nf_virtuemart_categories`.`virtuemart_category_id` = "1"
SELECT* FROM `ml0nf_virtuemart_shoppergroups` WHERE `default` = "2" AND (`virtuemart_vendor_id` = "1" OR `shared` = "1") AND `published`="1"
SELECT* FROMml0nf_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 <= "2020-11-27 11:45:43" )
AND ( publish_down = "0000-00-00 00:00:00" OR publish_down >= "2020-11-27 11:45:43" )
OR `for_override` = "1" )
SELECT `currency_exchange_rate` FROM `ml0nf_virtuemart_currencies` WHERE `virtuemart_currency_id` ="144"
SELECT `ml0nf_virtuemart_medias`.* FROM `ml0nf_virtuemart_medias` WHERE `ml0nf_virtuemart_medias`.`virtuemart_media_id` = "124"
SELECT C.`virtuemart_custom_id`, `custom_title`, `show_title`, C.`custom_value`,`custom_field_desc` ,`custom_tip`,`field_type`,field.`virtuemart_customfield_id`,`is_hidden`
FROM `ml0nf_virtuemart_customs` AS C
LEFTJOIN `ml0nf_virtuemart_product_customfields` AS field ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
Where `virtuemart_product_id` =1 and `field_type` != "G" and `field_type` != "R" and `field_type` != "Z" and is_cart_attribute = 1 group by virtuemart_custom_id ORDERBY field.`ordering`
SELECT virtuemart_product_id, product_name FROM `ml0nf_virtuemart_products_en_gb`
JOIN `ml0nf_virtuemart_products` as C using (`virtuemart_product_id`)
WHERE `product_parent_id` =13
SELECT `ml0nf_virtuemart_products`.* ,`ml0nf_virtuemart_products_en_gb`.* ,`ml0nf_virtuemart_product_manufacturers`.`virtuemart_manufacturer_id` ,`ml0nf_virtuemart_product_customfields`.`virtuemart_customfield_id` FROM `ml0nf_virtuemart_products` INNERJOIN `ml0nf_virtuemart_products_en_gb` using (`virtuemart_product_id`) LEFTJOIN `ml0nf_virtuemart_product_manufacturers` on `ml0nf_virtuemart_product_manufacturers`.`virtuemart_product_id`=`ml0nf_virtuemart_products`.`virtuemart_product_id` LEFTJOIN `ml0nf_virtuemart_product_customfields` on `ml0nf_virtuemart_product_customfields`.`virtuemart_product_id`=`ml0nf_virtuemart_products`.`virtuemart_product_id` WHERE `ml0nf_virtuemart_products`.`virtuemart_product_id` = "4"
SELECT `virtuemart_media_id` FROM `ml0nf_virtuemart_product_medias` WHERE `virtuemart_product_id` = "4" ORDERBY `ordering`
SELECT `virtuemart_shoppergroup_id` FROM `ml0nf_virtuemart_product_shoppergroups` WHERE `virtuemart_product_id` = "4"
SELECT* FROM `ml0nf_virtuemart_product_prices` WHERE `virtuemart_product_id` = "4" AND ( `virtuemart_shoppergroup_id` ="1" OR `virtuemart_shoppergroup_id` ISNULLOR `virtuemart_shoppergroup_id`="0") AND ( (`product_price_publish_up` ISNULLOR `product_price_publish_up` = "0000-00-00 00:00:00" OR `product_price_publish_up` <= "2020-11-27 11:45:43" )
AND (`product_price_publish_down` ISNULLOR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2020-11-27 11:45:43" ) ) AND( (`price_quantity_start` ISNULLOR `price_quantity_start`="0" OR `price_quantity_start` <= 1) AND (`price_quantity_end` ISNULLOR `price_quantity_end`="0" OR `price_quantity_end` >= 1) )
SELECT pc.`virtuemart_category_id` FROM `ml0nf_virtuemart_product_categories` as pc WHERE pc.`virtuemart_product_id` = 4
SELECT pc.`virtuemart_category_id` FROM `ml0nf_virtuemart_product_categories` as pc LEFTJOIN `ml0nf_virtuemart_categories` as c ON c.`virtuemart_category_id` = pc.`virtuemart_category_id` WHERE pc.`virtuemart_product_id` = 4 AND `published`=1 ORDERBY `c`.`ordering` ASC
SELECT `ordering`,`id` FROM `ml0nf_virtuemart_product_categories`
WHERE `virtuemart_product_id` = "4" and `virtuemart_category_id`= "1"
SELECT `ml0nf_virtuemart_categories`.* ,`ml0nf_virtuemart_categories_en_gb`.* FROM `ml0nf_virtuemart_categories` INNERJOIN `ml0nf_virtuemart_categories_en_gb` using (`virtuemart_category_id`) WHERE `ml0nf_virtuemart_categories`.`virtuemart_category_id` = "1"
SELECT C.`virtuemart_custom_id` , `custom_element`, `custom_params`, `custom_parent_id` , `admin_only` , `custom_title` , `show_title` , `custom_tip` , C.`custom_value` AS value, `custom_field_desc` , `field_type` , `is_list` , `is_hidden`, `layout_pos`, C.`published` , field.`virtuemart_customfield_id` , field.`custom_value`, field.`custom_param`, field.`custom_price`, field.`ordering`
FROM `ml0nf_virtuemart_customs` AS C
LEFTJOIN `ml0nf_virtuemart_product_customfields` AS field ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
Where `virtuemart_product_id` =4 and `field_type` != "G" and `field_type` != "R" and `field_type` != "Z" and is_cart_attribute = 0 order by field.`ordering`,virtuemart_custom_id
SELECT C.`virtuemart_custom_id` , `custom_parent_id` , `admin_only` , `custom_title` , `custom_tip` , C.`custom_value` AS value, `custom_field_desc` , `field_type` , `is_list` , `is_hidden` , C.`published` , field.`virtuemart_customfield_id` , field.`custom_value`, field.`custom_param`, field.`custom_price`, field.`ordering`
FROM `ml0nf_virtuemart_customs` AS C
LEFTJOIN `ml0nf_virtuemart_product_customfields` AS field ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
Where `virtuemart_product_id` =4 and `field_type` = "Z" and is_cart_attribute = 0 order by ordering
SELECT C.`virtuemart_custom_id` , `custom_parent_id` , `admin_only` , `custom_title` , `custom_tip` , C.`custom_value` AS value, `custom_field_desc` , `field_type` , `is_list` , `is_hidden` , C.`published` , field.`virtuemart_customfield_id` , field.`custom_value`, field.`custom_param`, field.`custom_price`, field.`ordering`
FROM `ml0nf_virtuemart_customs` AS C
LEFTJOIN `ml0nf_virtuemart_product_customfields` AS field ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
Where `virtuemart_product_id` =4 and `field_type` = "R" and is_cart_attribute = 0 order by ordering
SELECT `ml0nf_virtuemart_products`.* ,`ml0nf_virtuemart_products_en_gb`.* ,`ml0nf_virtuemart_product_manufacturers`.`virtuemart_manufacturer_id` ,`ml0nf_virtuemart_product_customfields`.`virtuemart_customfield_id` FROM `ml0nf_virtuemart_products` INNERJOIN `ml0nf_virtuemart_products_en_gb` using (`virtuemart_product_id`) LEFTJOIN `ml0nf_virtuemart_product_manufacturers` on `ml0nf_virtuemart_product_manufacturers`.`virtuemart_product_id`=`ml0nf_virtuemart_products`.`virtuemart_product_id` LEFTJOIN `ml0nf_virtuemart_product_customfields` on `ml0nf_virtuemart_product_customfields`.`virtuemart_product_id`=`ml0nf_virtuemart_products`.`virtuemart_product_id` WHERE `ml0nf_virtuemart_products`.`virtuemart_product_id` = "5"
SELECT `virtuemart_media_id` FROM `ml0nf_virtuemart_product_medias` WHERE `virtuemart_product_id` = "5" ORDERBY `ordering`
SELECT `virtuemart_shoppergroup_id` FROM `ml0nf_virtuemart_product_shoppergroups` WHERE `virtuemart_product_id` = "5"
SELECT* FROM `ml0nf_virtuemart_product_prices` WHERE `virtuemart_product_id` = "5" AND ( `virtuemart_shoppergroup_id` ="1" OR `virtuemart_shoppergroup_id` ISNULLOR `virtuemart_shoppergroup_id`="0") AND ( (`product_price_publish_up` ISNULLOR `product_price_publish_up` = "0000-00-00 00:00:00" OR `product_price_publish_up` <= "2020-11-27 11:45:43" )
AND (`product_price_publish_down` ISNULLOR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2020-11-27 11:45:43" ) ) AND( (`price_quantity_start` ISNULLOR `price_quantity_start`="0" OR `price_quantity_start` <= 1) AND (`price_quantity_end` ISNULLOR `price_quantity_end`="0" OR `price_quantity_end` >= 1) )
SELECT pc.`virtuemart_category_id` FROM `ml0nf_virtuemart_product_categories` as pc WHERE pc.`virtuemart_product_id` = 5
SELECT pc.`virtuemart_category_id` FROM `ml0nf_virtuemart_product_categories` as pc LEFTJOIN `ml0nf_virtuemart_categories` as c ON c.`virtuemart_category_id` = pc.`virtuemart_category_id` WHERE pc.`virtuemart_product_id` = 5 AND `published`=1 ORDERBY `c`.`ordering` ASC
SELECT `ordering`,`id` FROM `ml0nf_virtuemart_product_categories`
WHERE `virtuemart_product_id` = "5" and `virtuemart_category_id`= "1"
SELECT `ml0nf_virtuemart_categories`.* ,`ml0nf_virtuemart_categories_en_gb`.* FROM `ml0nf_virtuemart_categories` INNERJOIN `ml0nf_virtuemart_categories_en_gb` using (`virtuemart_category_id`) WHERE `ml0nf_virtuemart_categories`.`virtuemart_category_id` = "1"
SHOWFULLCOLUMNS FROM `ml0nf_assets`
SELECT id
FROMml0nf_assets WHERE parent_id = 0
SELECT b.rules
FROMml0nf_assetsAS a
LEFTJOINml0nf_assetsAS b ON b.lft <= a.lft AND b.rgt >= a.rgt
WHERE (a.name = 'com_virtuemart')
GROUPBY b.id, b.rules, b.lft
ORDERBY b.lft
SELECT id
FROMml0nf_assets WHERE parent_id = 0
SELECT `ml0nf_virtuemart_medias`.* FROM `ml0nf_virtuemart_medias` WHERE `ml0nf_virtuemart_medias`.`virtuemart_media_id` = "85"
SELECT `ml0nf_virtuemart_products`.* ,`ml0nf_virtuemart_products_en_gb`.* ,`ml0nf_virtuemart_product_manufacturers`.`virtuemart_manufacturer_id` ,`ml0nf_virtuemart_product_customfields`.`virtuemart_customfield_id` FROM `ml0nf_virtuemart_products` INNERJOIN `ml0nf_virtuemart_products_en_gb` using (`virtuemart_product_id`) LEFTJOIN `ml0nf_virtuemart_product_manufacturers` on `ml0nf_virtuemart_product_manufacturers`.`virtuemart_product_id`=`ml0nf_virtuemart_products`.`virtuemart_product_id` LEFTJOIN `ml0nf_virtuemart_product_customfields` on `ml0nf_virtuemart_product_customfields`.`virtuemart_product_id`=`ml0nf_virtuemart_products`.`virtuemart_product_id` WHERE `ml0nf_virtuemart_products`.`virtuemart_product_id` = "2"
SELECT `virtuemart_media_id` FROM `ml0nf_virtuemart_product_medias` WHERE `virtuemart_product_id` = "2" ORDERBY `ordering`
SELECT `virtuemart_shoppergroup_id` FROM `ml0nf_virtuemart_product_shoppergroups` WHERE `virtuemart_product_id` = "2"
SELECT* FROM `ml0nf_virtuemart_product_prices` WHERE `virtuemart_product_id` = "2" AND ( `virtuemart_shoppergroup_id` ="1" OR `virtuemart_shoppergroup_id` ISNULLOR `virtuemart_shoppergroup_id`="0") AND ( (`product_price_publish_up` ISNULLOR `product_price_publish_up` = "0000-00-00 00:00:00" OR `product_price_publish_up` <= "2020-11-27 11:45:43" )
AND (`product_price_publish_down` ISNULLOR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2020-11-27 11:45:43" ) ) AND( (`price_quantity_start` ISNULLOR `price_quantity_start`="0" OR `price_quantity_start` <= 1) AND (`price_quantity_end` ISNULLOR `price_quantity_end`="0" OR `price_quantity_end` >= 1) )
SELECT pc.`virtuemart_category_id` FROM `ml0nf_virtuemart_product_categories` as pc WHERE pc.`virtuemart_product_id` = 2
SELECT pc.`virtuemart_category_id` FROM `ml0nf_virtuemart_product_categories` as pc LEFTJOIN `ml0nf_virtuemart_categories` as c ON c.`virtuemart_category_id` = pc.`virtuemart_category_id` WHERE pc.`virtuemart_product_id` = 2 AND `published`=1 ORDERBY `c`.`ordering` ASC
SELECT `ordering`,`id` FROM `ml0nf_virtuemart_product_categories`
WHERE `virtuemart_product_id` = "2" and `virtuemart_category_id`= "1"
SELECT `ml0nf_virtuemart_categories`.* ,`ml0nf_virtuemart_categories_en_gb`.* FROM `ml0nf_virtuemart_categories` INNERJOIN `ml0nf_virtuemart_categories_en_gb` using (`virtuemart_category_id`) WHERE `ml0nf_virtuemart_categories`.`virtuemart_category_id` = "1"
SELECT id
FROMml0nf_assets WHERE parent_id = 0
SELECT id
FROMml0nf_assets WHERE parent_id = 0
SELECT C.`virtuemart_custom_id`, `custom_title`, `show_title`, C.`custom_value`,`custom_field_desc` ,`custom_tip`,`field_type`,field.`virtuemart_customfield_id`,`is_hidden`
FROM `ml0nf_virtuemart_customs` AS C
LEFTJOIN `ml0nf_virtuemart_product_customfields` AS field ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
Where `virtuemart_product_id` =4 and `field_type` != "G" and `field_type` != "R" and `field_type` != "Z" and is_cart_attribute = 1 group by virtuemart_custom_id ORDERBY field.`ordering`
SELECT virtuemart_product_id, product_name FROM `ml0nf_virtuemart_products_en_gb`
JOIN `ml0nf_virtuemart_products` as C using (`virtuemart_product_id`)
WHERE `product_parent_id` =2
SELECT `ml0nf_virtuemart_medias`.* FROM `ml0nf_virtuemart_medias` WHERE `ml0nf_virtuemart_medias`.`virtuemart_media_id` = "86"
SELECT id
FROMml0nf_assets WHERE parent_id = 0
SELECT L.* FROM `ml0nf_virtuemart_categories_en_gb` as L
JOIN `ml0nf_virtuemart_categories` as c using (`virtuemart_category_id`) LEFTJOIN `ml0nf_virtuemart_category_categories` as cx on c.`virtuemart_category_id` = cx.`category_child_id` WHERE cx.`category_parent_id` = 1 AND c.`virtuemart_vendor_id` = 1 AND c.`published` = 1 ORDERBY c.ordering ASC
SELECT m2.language, m2.id
FROMml0nf_menu as m
INNERJOINml0nf_associations as a ON a.id=m.id AND a.context='com_menus.item'
INNERJOINml0nf_associations as a2 ON a.key=a2.key
INNERJOINml0nf_menu as m2 ON a2.id=m2.id
WHERE m.id=266
SELECT* FROMml0nf_rsform_config
SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROMml0nf_modulesAS m
LEFTJOINml0nf_modules_menuAS mm ON mm.moduleid = m.id
LEFTJOINml0nf_extensionsAS 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 <= '2020-11-27 11:45:43') AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2020-11-27 11:45:43') AND m.access IN (1,1) AND m.client_id = 0 AND (mm.menuid = 266 OR mm.menuid <= 0) AND m.language IN ('en-GB','*')
ORDERBY m.position, m.ordering
SELECT report_name, preset_name, a.* FROMml0nf_imr_automail a
JOINml0nf_imr_presets p ON a.preset_id = p.id WHERE next_send > 0
AND enabled = true
UPDATE `ml0nf_session`
SET `data` = '__default|a:7:{s:15:\"session.counter\";i:1;s:19:\"session.timer.start\";i:1606477543;s:18:\"session.timer.last\";i:1606477543;s:17:\"session.timer.now\";i:1606477543;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:4:{s:6:\"vmcart\";s:752:\"O:8:\"stdClass\":28:{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:19:\"virtuemart_order_id\";b:0;s:2:\"BT\";i:0;s:2:\"ST\";i:0;s:11:\"tosAccepted\";b:0;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:10:\"_inConfirm\";b:0;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_\";s:6:\"layout\";s:7:\"default\";s:10:\"layoutPath\";s:0:\"\";}\";s:23:\"vmlastvisitedcategoryid\";i:1;s:19:\"vmlastvisitedmanuid\";i:-1;s:15:\"vmlastvisItemid\";i:266;}'
, `time` = '1606477544'
WHERE `session_id` = '64bed81c9c894227a769fb48b197621f'
52 Query Types Logged, Sorted by Occurrences.
SELECT Tables:
6 × SELECT `ml0nf_virtuemart_categories`.* ,`ml0nf_virtuemart_categories_en_gb`.* FROM `ml0nf_virtuemart_categories` INNERJOIN `ml0nf_virtuemart_categories_en_gb` using (`virtuemart_category_id`)
5 × SELECT id FROMml0nf_assets
5 × SELECT `ordering`,`id` FROM `ml0nf_virtuemart_product_categories`
5 × SELECT pc.`virtuemart_category_id` FROM `ml0nf_virtuemart_product_categories` as pc
5 × SELECT `ml0nf_virtuemart_products`.* ,`ml0nf_virtuemart_products_en_gb`.* ,`ml0nf_virtuemart_product_manufacturers`.`virtuemart_manufacturer_id` ,`ml0nf_virtuemart_product_customfields`.`virtuemart_customfield_id` FROM `ml0nf_virtuemart_products` INNERJOIN `ml0nf_virtuemart_products_en_gb` using (`virtuemart_product_id`) LEFTJOIN `ml0nf_virtuemart_product_manufacturers` on `ml0nf_virtuemart_product_manufacturers`.`virtuemart_product_id`=`ml0nf_virtuemart_products`.`virtuemart_product_id` LEFTJOIN `ml0nf_virtuemart_product_customfields` on `ml0nf_virtuemart_product_customfields`.`virtuemart_product_id`=`ml0nf_virtuemart_products`.`virtuemart_product_id`
5 × SELECT pc.`virtuemart_category_id` FROM `ml0nf_virtuemart_product_categories` as pc LEFTJOIN `ml0nf_virtuemart_categories` as c ON c.`virtuemart_category_id` = pc.`virtuemart_category_id`
5 × SELECT `virtuemart_media_id` FROM `ml0nf_virtuemart_product_medias`
5 × SELECT* FROM `ml0nf_virtuemart_product_prices`
5 × SELECT `virtuemart_shoppergroup_id` FROM `ml0nf_virtuemart_product_shoppergroups`
4 × SELECT C.`virtuemart_custom_id` , `custom_parent_id` , `admin_only` , `custom_title` , `custom_tip` , C.`custom_value` AS value, `custom_field_desc` , `field_type` , `is_list` , `is_hidden` , C.`published` , field.`virtuemart_customfield_id` , field.`custom_value`, field.`custom_param`, field.`custom_price`, field.`ordering` FROM `ml0nf_virtuemart_customs` AS C LEFTJOIN `ml0nf_virtuemart_product_customfields` AS field ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
3 × SELECT extension_id AS id, element AS "option", params, enabled FROMml0nf_extensions
3 × SELECT `ml0nf_virtuemart_medias`.* FROM `ml0nf_virtuemart_medias`
2 × SELECT* FROM `ml0nf_virtuemart_shoppergroups`
2 × SELECT C.`virtuemart_custom_id` , `custom_element`, `custom_params`, `custom_parent_id` , `admin_only` , `custom_title` , `show_title` , `custom_tip` , C.`custom_value` AS value, `custom_field_desc` , `field_type` , `is_list` , `is_hidden`, `layout_pos`, C.`published` , field.`virtuemart_customfield_id` , field.`custom_value`, field.`custom_param`, field.`custom_price`, field.`ordering` FROM `ml0nf_virtuemart_customs` AS C LEFTJOIN `ml0nf_virtuemart_product_customfields` AS field ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
2 × SELECT virtuemart_product_id, product_name FROM `ml0nf_virtuemart_products_en_gb` JOIN `ml0nf_virtuemart_products` as C using (`virtuemart_product_id`)
2 × SELECT b.rules FROMml0nf_assetsAS a LEFTJOINml0nf_assetsAS b ON b.lft <= a.lft AND b.rgt >= a.rgt
2 × SELECT C.`virtuemart_custom_id`, `custom_title`, `show_title`, C.`custom_value`,`custom_field_desc` ,`custom_tip`,`field_type`,field.`virtuemart_customfield_id`,`is_hidden` FROM `ml0nf_virtuemart_customs` AS C LEFTJOIN `ml0nf_virtuemart_product_customfields` AS field ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
1 × SELECT `vendor_currency`,`currency_code_3`,`currency_numeric_code` FROM `ml0nf_virtuemart_vendors` AS v LEFTJOIN `ml0nf_virtuemart_currencies` AS c ON virtuemart_currency_id = vendor_currency
1 × SELECT* FROMml0nf_virtuemart_calcs
1 × SELECT* FROMml0nf_rsform_confi
1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid FROMml0nf_modulesAS m LEFTJOINml0nf_modules_menuAS mm ON mm.moduleid = m.id LEFTJOINml0nf_extensionsAS e ON e.element = m.module AND e.client_id = m.client_id
1 × SELECT report_name, preset_name, a.* FROMml0nf_imr_automail a JOINml0nf_imr_presets p ON a.preset_id = p.id
1 × SELECT m2.language, m2.id FROMml0nf_menu as m INNERJOINml0nf_associations as a ON a.id=m.id AND a.context='com_menus.item' INNERJOINml0nf_associations as a2 ON a.key=a2.key INNERJOINml0nf_menu as m2 ON a2.id=m2.id
1 × SELECT L.* FROM `ml0nf_virtuemart_categories_en_gb` as L JOIN `ml0nf_virtuemart_categories` as c using (`virtuemart_category_id`) LEFTJOIN `ml0nf_virtuemart_category_categories` as cx on c.`virtuemart_category_id` = cx.`category_child_id`
1 × SELECT `price_display`,`custom_price_display` FROM `ml0nf_virtuemart_shoppergroups` AS `sg`
1 × SELECT `currency_exchange_rate` FROM `ml0nf_virtuemart_currencies`
1 × SELECT* FROM `ml0nf_virtuemart_currencies`
1 × SELECTFOUND_ROWS(
1 × SELECT language,id FROM `ml0nf_menu`
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 FROMml0nf_menuAS m LEFTJOINml0nf_extensionsAS e ON m.component_id = e.extension_id
1 × select * from ml0nf_onepage_config
1 × SELECT* FROMml0nf_languages
1 × SELECT folder AS type, element AS name, params FROMml0nf_extensions
1 × SELECT `session_id` FROM `ml0nf_session`
1 × SELECT b.id FROMml0nf_usergroupsAS a LEFTJOINml0nf_usergroupsAS b ON b.lft <= a.lft AND b.rgt >= a.rgt
1 × SELECT id, rules FROM `ml0nf_viewlevels
1 × SELECT `config` FROM `ml0nf_virtuemart_configs`
1 × SELECT a.rules FROMml0nf_assetsAS a
1 × SELECT count(ml0nf_virtuemart_products.virtuemart_product_id) AS total FROM `ml0nf_virtuemart_products`, `ml0nf_virtuemart_product_categories`
1 × SELECT `virtuemart_shoppergroup_id` FROM `ml0nf_virtuemart_vmuser_shoppergroups`
1 × SELECTSQL_CALC_FOUND_ROWS p.`virtuemart_product_id` FROM `ml0nf_virtuemart_products` as p INNERJOIN `ml0nf_virtuemart_products_en_gb` as l using (`virtuemart_product_id`) LEFTJOIN `ml0nf_virtuemart_product_shoppergroups` as ps ON p.`virtuemart_product_id` = `ps`.`virtuemart_product_id` LEFTJOIN `ml0nf_virtuemart_product_categories` as pc ON p.`virtuemart_product_id` = `pc`.`virtuemart_product_id`
1 × SELECT `category_child_id` FROM `ml0nf_virtuemart_category_categories`
1 × SELECT `virtuemart_media_id` FROM `ml0nf_virtuemart_category_medias`
1 × SELECT id, home, template, s.params FROMml0nf_template_styles as s LEFTJOINml0nf_extensions as e ON e.element=s.template AND e.type='template' AND e.client_id=s.client_id
1 × SELECT `ml0nf_virtuemart_categories`.* ,`ml0nf_virtuemart_categories_he_il`.* FROM `ml0nf_virtuemart_categories` INNERJOIN `ml0nf_virtuemart_categories_he_il` using (`virtuemart_category_id`)
