Καταγράφηκαν 535 ερωτήματα

1. SELECT `data`
  FROM `xnpis_session`
  WHERE `session_id` = 'aaf2ce912aece4e63203cd781006679a'
2. SELECT `session_id`
  FROM `xnpis_session`
  WHERE `session_id` = 'aaf2ce912aece4e63203cd781006679a'
  LIMIT 0, 1
3. INSERT INTO `xnpis_session` (`session_id`, `client_id`, `time`)
  VALUES ('aaf2ce912aece4e63203cd781006679a', 0, '1576389216')
4. SELECT extension_id AS id, element AS "option", params, enabled
  FROM xnpis_extensions
  WHERE `type` = 'component'
  AND `element` = 'com_users'
5. SELECT b.id
  FROM xnpis_usergroups AS a
  LEFT JOIN xnpis_usergroups AS b
  ON b.lft <= a.lft
  AND b.rgt >= a.rgt
  WHERE a.id = 1
6. SELECT id, rules
  FROM `xnpis_viewlevels`
7. SELECT folder AS type, element AS name, params
  FROM xnpis_extensions
  WHERE enabled >= 1
  AND type ='plugin'
  AND state >= 0
  AND access IN (1,1)
  ORDER BY ordering
8. SELECT extension_id AS id, element AS "option", params, enabled
  FROM xnpis_extensions
  WHERE `type` = 'component'
  AND `element` = 'com_languages'
9. SELECT `value`
  FROM `xnpis_admintools_storage`
  WHERE `key` = 'cparams'
10. SELECT a.rules
  FROM xnpis_assets AS a
  WHERE (a.id = 1)
  GROUP BY a.id, a.rules, a.lft
11. SHOW FULL COLUMNS
  FROM `xnpis_assets`
12. SELECT id
  FROM xnpis_assets
  WHERE parent_id = 0
13. SELECT b.rules
  FROM xnpis_assets AS a
  LEFT JOIN xnpis_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
14. select id, title, alias
  from xnpis_jumi
  where published = 1
15. 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 xnpis_menu AS m
  LEFT JOIN xnpis_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
16. SELECT id, home, template, s.params
  FROM xnpis_template_styles as s
  LEFT JOIN xnpis_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
17. SELECT extension_id AS id, element AS "option", params, enabled
  FROM xnpis_extensions
  WHERE `type` = 'component'
  AND `element` = 'com_virtuemart'
18. SELECT *
  FROM xnpis_languages
  WHERE published=1
  ORDER BY ordering ASC
19. SHOW TABLES LIKE "xnpis_virtuemart_configs"
20. SELECT `config`
  FROM `xnpis_virtuemart_configs`
  WHERE `virtuemart_config_id` = "1";
21. SELECT `virtuemart_permgroup_id`,`group_name`,`group_level`
  FROM `xnpis_virtuemart_permgroups`
  ORDER BY `group_level`
22. SELECT *
  FROM `xnpis_menu`
  where `link` like "index.php?option=com_virtuemart%"
  and client_id=0
  and published=1
  and (language="*" or language = "el-GR" )
23. SELECT `xnpis_virtuemart_categories_el_gr`.* ,`xnpis_virtuemart_categories`.*
  FROM `xnpis_virtuemart_categories_el_gr` JOIN xnpis_virtuemart_categories using (`virtuemart_category_id`)
  WHERE xnpis_virtuemart_categories_el_gr.`virtuemart_category_id` = "123"
24. SELECT `virtuemart_media_id`
  FROM `xnpis_virtuemart_category_medias`
  WHERE `virtuemart_category_id` = "123"
  ORDER BY `ordering`
25. SELECT `category_child_id`
  FROM `xnpis_virtuemart_category_categories`
  WHERE `category_parent_id` = 123
26. SELECT count(xnpis_virtuemart_products.virtuemart_product_id) AS total
  FROM `xnpis_virtuemart_products`, `xnpis_virtuemart_product_categories`
  WHERE `xnpis_virtuemart_products`.`virtuemart_vendor_id` = "1"
  AND `xnpis_virtuemart_product_categories`.`virtuemart_category_id` = 123
  AND `xnpis_virtuemart_products`.`virtuemart_product_id` = `xnpis_virtuemart_product_categories`.`virtuemart_product_id`
  AND `xnpis_virtuemart_products`.`published` = "1"
27. SELECT `virtuemart_shoppergroup_id`
  FROM `xnpis_virtuemart_vmuser_shoppergroups`
  WHERE `virtuemart_user_id` = "0"
28. SELECT *
  FROM `xnpis_virtuemart_shoppergroups`
  WHERE `default` = "2"
  AND (`virtuemart_vendor_id` = "1" OR `shared` = "1")
  AND `published`="1"
29. SELECT SQL_CALC_FOUND_ROWS l.`virtuemart_product_id`
  FROM `xnpis_virtuemart_products_el_gr` as l JOIN `xnpis_virtuemart_products` AS p using (`virtuemart_product_id`)
  LEFT JOIN `xnpis_virtuemart_product_categories` as pc
  ON p.`virtuemart_product_id` = `pc`.`virtuemart_product_id`
  LEFT JOIN `xnpis_virtuemart_categories_el_gr` as c
  ON c.`virtuemart_category_id` = `pc`.`virtuemart_category_id`
  LEFT JOIN `xnpis_virtuemart_product_shoppergroups`
  ON p.`virtuemart_product_id` = `xnpis_virtuemart_product_shoppergroups`.`virtuemart_product_id`
  LEFT
  OUTER JOIN `xnpis_virtuemart_shoppergroups` as s
  ON s.`virtuemart_shoppergroup_id` = `xnpis_virtuemart_product_shoppergroups`.`virtuemart_shoppergroup_id`
  WHERE ( p.`published`="1"
  AND `pc`.`virtuemart_category_id` = 123
  AND ( s.`virtuemart_shoppergroup_id`= "1" OR s.`virtuemart_shoppergroup_id` IS NULL ) )
  group by p.`virtuemart_product_id`
  ORDER BY product_name ASC
  LIMIT 0, 30
30. SELECT FOUND_ROWS()
31. SELECT `xnpis_virtuemart_products_el_gr`.* ,`xnpis_virtuemart_products`.* ,`xnpis_virtuemart_ratings`.`rating` ,`xnpis_virtuemart_product_manufacturers`.`virtuemart_manufacturer_id` ,`xnpis_virtuemart_product_customfields`.`virtuemart_customfield_id`
  FROM `xnpis_virtuemart_products_el_gr` JOIN xnpis_virtuemart_products using (`virtuemart_product_id`)
  LEFT JOIN `xnpis_virtuemart_ratings`
  on `xnpis_virtuemart_ratings`.`virtuemart_product_id`=`xnpis_virtuemart_products_el_gr`.`virtuemart_product_id`
  LEFT JOIN `xnpis_virtuemart_product_manufacturers`
  on `xnpis_virtuemart_product_manufacturers`.`virtuemart_product_id`=`xnpis_virtuemart_products_el_gr`.`virtuemart_product_id`
  LEFT JOIN `xnpis_virtuemart_product_customfields`
  on `xnpis_virtuemart_product_customfields`.`virtuemart_product_id`=`xnpis_virtuemart_products_el_gr`.`virtuemart_product_id`
  WHERE xnpis_virtuemart_products_el_gr.`virtuemart_product_id` = "1173"
32. SELECT `virtuemart_media_id`
  FROM `xnpis_virtuemart_product_medias`
  WHERE `virtuemart_product_id` = "1173"
  ORDER BY `ordering`
33. SELECT `virtuemart_shoppergroup_id`
  FROM `xnpis_virtuemart_product_shoppergroups`
  WHERE `virtuemart_product_id` = "1173"
34. SELECT *
  FROM `xnpis_virtuemart_product_prices`
  WHERE `virtuemart_product_id` = "1173"
  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` <= "2019-12-15 05:53:36" )
  AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2019-12-15 05:53:36" ) )
  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) )
35. SELECT pc.`virtuemart_category_id`
  FROM `xnpis_virtuemart_product_categories` as pc
  WHERE pc.`virtuemart_product_id` = 1173
36. SELECT pc.`virtuemart_category_id`
  FROM `xnpis_virtuemart_product_categories` as pc
  LEFT JOIN `xnpis_virtuemart_categories` as c
  ON c.`virtuemart_category_id` = pc.`virtuemart_category_id`
  WHERE pc.`virtuemart_product_id` = 1173
  AND `published`=1
  ORDER BY `c`.`ordering` ASC
37. SELECT `ordering`,`id`
  FROM `xnpis_virtuemart_product_categories`
  WHERE `virtuemart_product_id` = "1173"
  and `virtuemart_category_id`= "123"
38. SELECT `xnpis_virtuemart_categories_el_gr`.* ,`xnpis_virtuemart_categories`.*
  FROM `xnpis_virtuemart_categories_el_gr` JOIN xnpis_virtuemart_categories using (`virtuemart_category_id`)
  WHERE xnpis_virtuemart_categories_el_gr.`virtuemart_category_id` = "123"
39. 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 `xnpis_virtuemart_customs` AS C
  LEFT JOIN `xnpis_virtuemart_product_customfields` AS field
  ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
  Where `virtuemart_product_id` =1173
  and `field_type` != "G"
  and `field_type` != "R"
  and `field_type` != "Z"
  and is_cart_attribute = 0
  order by field.`ordering`,virtuemart_custom_id
40. SELECT `vendor_currency`,`currency_code_3`,`currency_numeric_code`
  FROM `xnpis_virtuemart_vendors` AS v
  LEFT JOIN `xnpis_virtuemart_currencies` AS c
  ON virtuemart_currency_id = vendor_currency
  WHERE v.`virtuemart_vendor_id`="1"
41. SELECT *
  FROM `xnpis_virtuemart_currencies`
  WHERE `virtuemart_currency_id`="47"
42. SELECT `price_display`,`custom_price_display`
  FROM `xnpis_virtuemart_shoppergroups` AS `sg`
  WHERE `sg`.`default` = "2"
43. 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 `xnpis_virtuemart_customs` AS C
  LEFT JOIN `xnpis_virtuemart_product_customfields` AS field
  ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
  Where `virtuemart_product_id` =1173
  and `field_type` = "Z"
  and is_cart_attribute = 0
  order by ordering
44. 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 `xnpis_virtuemart_customs` AS C
  LEFT JOIN `xnpis_virtuemart_product_customfields` AS field
  ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
  Where `virtuemart_product_id` =1173
  and `field_type` = "R"
  and is_cart_attribute = 0
  order by ordering
45. 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 `xnpis_virtuemart_customs` AS C
  LEFT JOIN `xnpis_virtuemart_product_customfields` AS field
  ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
  Where `virtuemart_product_id` =1173
  and `field_type` != "G"
  and `field_type` != "R"
  and `field_type` != "Z"
  and is_cart_attribute = 1
  group by virtuemart_custom_id
  ORDER BY field.`ordering`
46. SELECT virtuemart_product_id, product_name
  FROM `xnpis_virtuemart_products_el_gr` JOIN `xnpis_virtuemart_products` as C using (`virtuemart_product_id`)
  WHERE `product_parent_id` =1173
47. SELECT *
  FROM `xnpis_virtuemart_shoppergroups`
  WHERE `default` = "2"
  AND (`virtuemart_vendor_id` = "1" OR `shared` = "1")
  AND `published`="1"
48. SELECT *
  FROM xnpis_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 <= "2019-12-15 05:53:36" )
  AND ( publish_down = "0000-00-00 00:00:00" OR publish_down >= "2019-12-15 05:53:36" ) OR `for_override` = "1" )
49. SELECT `vendor_currency`
  FROM xnpis_virtuemart_vendors
  WHERE `virtuemart_vendor_id`="1"
50. SELECT `slug`
  FROM `xnpis_virtuemart_products_el_gr`
  WHERE `virtuemart_product_id` = 1173
51. SELECT `xnpis_virtuemart_products_el_gr`.* ,`xnpis_virtuemart_products`.* ,`xnpis_virtuemart_ratings`.`rating` ,`xnpis_virtuemart_product_manufacturers`.`virtuemart_manufacturer_id` ,`xnpis_virtuemart_product_customfields`.`virtuemart_customfield_id`
  FROM `xnpis_virtuemart_products_el_gr` JOIN xnpis_virtuemart_products using (`virtuemart_product_id`)
  LEFT JOIN `xnpis_virtuemart_ratings`
  on `xnpis_virtuemart_ratings`.`virtuemart_product_id`=`xnpis_virtuemart_products_el_gr`.`virtuemart_product_id`
  LEFT JOIN `xnpis_virtuemart_product_manufacturers`
  on `xnpis_virtuemart_product_manufacturers`.`virtuemart_product_id`=`xnpis_virtuemart_products_el_gr`.`virtuemart_product_id`
  LEFT JOIN `xnpis_virtuemart_product_customfields`
  on `xnpis_virtuemart_product_customfields`.`virtuemart_product_id`=`xnpis_virtuemart_products_el_gr`.`virtuemart_product_id`
  WHERE xnpis_virtuemart_products_el_gr.`virtuemart_product_id` = "612"
52. SELECT `virtuemart_media_id`
  FROM `xnpis_virtuemart_product_medias`
  WHERE `virtuemart_product_id` = "612"
  ORDER BY `ordering`
53. SELECT `virtuemart_shoppergroup_id`
  FROM `xnpis_virtuemart_product_shoppergroups`
  WHERE `virtuemart_product_id` = "612"
54. SELECT *
  FROM `xnpis_virtuemart_product_prices`
  WHERE `virtuemart_product_id` = "612"
  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` <= "2019-12-15 05:53:36" )
  AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2019-12-15 05:53:36" ) )
  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) )
55. SELECT pc.`virtuemart_category_id`
  FROM `xnpis_virtuemart_product_categories` as pc
  WHERE pc.`virtuemart_product_id` = 612
56. SELECT pc.`virtuemart_category_id`
  FROM `xnpis_virtuemart_product_categories` as pc
  LEFT JOIN `xnpis_virtuemart_categories` as c
  ON c.`virtuemart_category_id` = pc.`virtuemart_category_id`
  WHERE pc.`virtuemart_product_id` = 612
  AND `published`=1
  ORDER BY `c`.`ordering` ASC
57. SELECT `ordering`,`id`
  FROM `xnpis_virtuemart_product_categories`
  WHERE `virtuemart_product_id` = "612"
  and `virtuemart_category_id`= "123"
58. SELECT `xnpis_virtuemart_categories_el_gr`.* ,`xnpis_virtuemart_categories`.*
  FROM `xnpis_virtuemart_categories_el_gr` JOIN xnpis_virtuemart_categories using (`virtuemart_category_id`)
  WHERE xnpis_virtuemart_categories_el_gr.`virtuemart_category_id` = "123"
59. 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 `xnpis_virtuemart_customs` AS C
  LEFT JOIN `xnpis_virtuemart_product_customfields` AS field
  ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
  Where `virtuemart_product_id` =612
  and `field_type` != "G"
  and `field_type` != "R"
  and `field_type` != "Z"
  and is_cart_attribute = 0
  order by field.`ordering`,virtuemart_custom_id
60. 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 `xnpis_virtuemart_customs` AS C
  LEFT JOIN `xnpis_virtuemart_product_customfields` AS field
  ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
  Where `virtuemart_product_id` =612
  and `field_type` = "Z"
  and is_cart_attribute = 0
  order by ordering
61. 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 `xnpis_virtuemart_customs` AS C
  LEFT JOIN `xnpis_virtuemart_product_customfields` AS field
  ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
  Where `virtuemart_product_id` =612
  and `field_type` = "R"
  and is_cart_attribute = 0
  order by ordering
62. 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 `xnpis_virtuemart_customs` AS C
  LEFT JOIN `xnpis_virtuemart_product_customfields` AS field
  ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
  Where `virtuemart_product_id` =612
  and `field_type` != "G"
  and `field_type` != "R"
  and `field_type` != "Z"
  and is_cart_attribute = 1
  group by virtuemart_custom_id
  ORDER BY field.`ordering`
63. SELECT virtuemart_product_id, product_name
  FROM `xnpis_virtuemart_products_el_gr` JOIN `xnpis_virtuemart_products` as C using (`virtuemart_product_id`)
  WHERE `product_parent_id` =612
64. SELECT `vendor_currency`
  FROM xnpis_virtuemart_vendors
  WHERE `virtuemart_vendor_id`="1"
65. SELECT `slug`
  FROM `xnpis_virtuemart_products_el_gr`
  WHERE `virtuemart_product_id` = 612
66. SELECT `xnpis_virtuemart_products_el_gr`.* ,`xnpis_virtuemart_products`.* ,`xnpis_virtuemart_ratings`.`rating` ,`xnpis_virtuemart_product_manufacturers`.`virtuemart_manufacturer_id` ,`xnpis_virtuemart_product_customfields`.`virtuemart_customfield_id`
  FROM `xnpis_virtuemart_products_el_gr` JOIN xnpis_virtuemart_products using (`virtuemart_product_id`)
  LEFT JOIN `xnpis_virtuemart_ratings`
  on `xnpis_virtuemart_ratings`.`virtuemart_product_id`=`xnpis_virtuemart_products_el_gr`.`virtuemart_product_id`
  LEFT JOIN `xnpis_virtuemart_product_manufacturers`
  on `xnpis_virtuemart_product_manufacturers`.`virtuemart_product_id`=`xnpis_virtuemart_products_el_gr`.`virtuemart_product_id`
  LEFT JOIN `xnpis_virtuemart_product_customfields`
  on `xnpis_virtuemart_product_customfields`.`virtuemart_product_id`=`xnpis_virtuemart_products_el_gr`.`virtuemart_product_id`
  WHERE xnpis_virtuemart_products_el_gr.`virtuemart_product_id` = "613"
67. SELECT `virtuemart_media_id`
  FROM `xnpis_virtuemart_product_medias`
  WHERE `virtuemart_product_id` = "613"
  ORDER BY `ordering`
68. SELECT `virtuemart_shoppergroup_id`
  FROM `xnpis_virtuemart_product_shoppergroups`
  WHERE `virtuemart_product_id` = "613"
69. SELECT *
  FROM `xnpis_virtuemart_product_prices`
  WHERE `virtuemart_product_id` = "613"
  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` <= "2019-12-15 05:53:36" )
  AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2019-12-15 05:53:36" ) )
  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) )
70. SELECT pc.`virtuemart_category_id`
  FROM `xnpis_virtuemart_product_categories` as pc
  WHERE pc.`virtuemart_product_id` = 613
71. SELECT pc.`virtuemart_category_id`
  FROM `xnpis_virtuemart_product_categories` as pc
  LEFT JOIN `xnpis_virtuemart_categories` as c
  ON c.`virtuemart_category_id` = pc.`virtuemart_category_id`
  WHERE pc.`virtuemart_product_id` = 613
  AND `published`=1
  ORDER BY `c`.`ordering` ASC
72. SELECT `ordering`,`id`
  FROM `xnpis_virtuemart_product_categories`
  WHERE `virtuemart_product_id` = "613"
  and `virtuemart_category_id`= "123"
73. SELECT `xnpis_virtuemart_categories_el_gr`.* ,`xnpis_virtuemart_categories`.*
  FROM `xnpis_virtuemart_categories_el_gr` JOIN xnpis_virtuemart_categories using (`virtuemart_category_id`)
  WHERE xnpis_virtuemart_categories_el_gr.`virtuemart_category_id` = "123"
74. 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 `xnpis_virtuemart_customs` AS C
  LEFT JOIN `xnpis_virtuemart_product_customfields` AS field
  ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
  Where `virtuemart_product_id` =613
  and `field_type` != "G"
  and `field_type` != "R"
  and `field_type` != "Z"
  and is_cart_attribute = 0
  order by field.`ordering`,virtuemart_custom_id
75. 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 `xnpis_virtuemart_customs` AS C
  LEFT JOIN `xnpis_virtuemart_product_customfields` AS field
  ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
  Where `virtuemart_product_id` =613
  and `field_type` = "Z"
  and is_cart_attribute = 0
  order by ordering
76. 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 `xnpis_virtuemart_customs` AS C
  LEFT JOIN `xnpis_virtuemart_product_customfields` AS field
  ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
  Where `virtuemart_product_id` =613
  and `field_type` = "R"
  and is_cart_attribute = 0
  order by ordering
77. 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 `xnpis_virtuemart_customs` AS C
  LEFT JOIN `xnpis_virtuemart_product_customfields` AS field
  ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
  Where `virtuemart_product_id` =613
  and `field_type` != "G"
  and `field_type` != "R"
  and `field_type` != "Z"
  and is_cart_attribute = 1
  group by virtuemart_custom_id
  ORDER BY field.`ordering`
78. SELECT virtuemart_product_id, product_name
  FROM `xnpis_virtuemart_products_el_gr` JOIN `xnpis_virtuemart_products` as C using (`virtuemart_product_id`)
  WHERE `product_parent_id` =613
79. SELECT `vendor_currency`
  FROM xnpis_virtuemart_vendors
  WHERE `virtuemart_vendor_id`="1"
80. SELECT `slug`
  FROM `xnpis_virtuemart_products_el_gr`
  WHERE `virtuemart_product_id` = 613
81. SELECT `xnpis_virtuemart_products_el_gr`.* ,`xnpis_virtuemart_products`.* ,`xnpis_virtuemart_ratings`.`rating` ,`xnpis_virtuemart_product_manufacturers`.`virtuemart_manufacturer_id` ,`xnpis_virtuemart_product_customfields`.`virtuemart_customfield_id`
  FROM `xnpis_virtuemart_products_el_gr` JOIN xnpis_virtuemart_products using (`virtuemart_product_id`)
  LEFT JOIN `xnpis_virtuemart_ratings`
  on `xnpis_virtuemart_ratings`.`virtuemart_product_id`=`xnpis_virtuemart_products_el_gr`.`virtuemart_product_id`
  LEFT JOIN `xnpis_virtuemart_product_manufacturers`
  on `xnpis_virtuemart_product_manufacturers`.`virtuemart_product_id`=`xnpis_virtuemart_products_el_gr`.`virtuemart_product_id`
  LEFT JOIN `xnpis_virtuemart_product_customfields`
  on `xnpis_virtuemart_product_customfields`.`virtuemart_product_id`=`xnpis_virtuemart_products_el_gr`.`virtuemart_product_id`
  WHERE xnpis_virtuemart_products_el_gr.`virtuemart_product_id` = "621"
82. SELECT `virtuemart_media_id`
  FROM `xnpis_virtuemart_product_medias`
  WHERE `virtuemart_product_id` = "621"
  ORDER BY `ordering`
83. SELECT `virtuemart_shoppergroup_id`
  FROM `xnpis_virtuemart_product_shoppergroups`
  WHERE `virtuemart_product_id` = "621"
84. SELECT *
  FROM `xnpis_virtuemart_product_prices`
  WHERE `virtuemart_product_id` = "621"
  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` <= "2019-12-15 05:53:36" )
  AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2019-12-15 05:53:36" ) )
  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) )
85. SELECT pc.`virtuemart_category_id`
  FROM `xnpis_virtuemart_product_categories` as pc
  WHERE pc.`virtuemart_product_id` = 621
86. SELECT pc.`virtuemart_category_id`
  FROM `xnpis_virtuemart_product_categories` as pc
  LEFT JOIN `xnpis_virtuemart_categories` as c
  ON c.`virtuemart_category_id` = pc.`virtuemart_category_id`
  WHERE pc.`virtuemart_product_id` = 621
  AND `published`=1
  ORDER BY `c`.`ordering` ASC
87. SELECT `ordering`,`id`
  FROM `xnpis_virtuemart_product_categories`
  WHERE `virtuemart_product_id` = "621"
  and `virtuemart_category_id`= "123"
88. SELECT `xnpis_virtuemart_categories_el_gr`.* ,`xnpis_virtuemart_categories`.*
  FROM `xnpis_virtuemart_categories_el_gr` JOIN xnpis_virtuemart_categories using (`virtuemart_category_id`)
  WHERE xnpis_virtuemart_categories_el_gr.`virtuemart_category_id` = "123"
89. 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 `xnpis_virtuemart_customs` AS C
  LEFT JOIN `xnpis_virtuemart_product_customfields` AS field
  ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
  Where `virtuemart_product_id` =621
  and `field_type` != "G"
  and `field_type` != "R"
  and `field_type` != "Z"
  and is_cart_attribute = 0
  order by field.`ordering`,virtuemart_custom_id
90. 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 `xnpis_virtuemart_customs` AS C
  LEFT JOIN `xnpis_virtuemart_product_customfields` AS field
  ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
  Where `virtuemart_product_id` =621
  and `field_type` = "Z"
  and is_cart_attribute = 0
  order by ordering
91. 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 `xnpis_virtuemart_customs` AS C
  LEFT JOIN `xnpis_virtuemart_product_customfields` AS field
  ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
  Where `virtuemart_product_id` =621
  and `field_type` = "R"
  and is_cart_attribute = 0
  order by ordering
92. 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 `xnpis_virtuemart_customs` AS C
  LEFT JOIN `xnpis_virtuemart_product_customfields` AS field
  ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
  Where `virtuemart_product_id` =621
  and `field_type` != "G"
  and `field_type` != "R"
  and `field_type` != "Z"
  and is_cart_attribute = 1
  group by virtuemart_custom_id
  ORDER BY field.`ordering`
93. SELECT virtuemart_product_id, product_name
  FROM `xnpis_virtuemart_products_el_gr` JOIN `xnpis_virtuemart_products` as C using (`virtuemart_product_id`)
  WHERE `product_parent_id` =621
94. SELECT `vendor_currency`
  FROM xnpis_virtuemart_vendors
  WHERE `virtuemart_vendor_id`="1"
95. SELECT `slug`
  FROM `xnpis_virtuemart_products_el_gr`
  WHERE `virtuemart_product_id` = 621
96. SELECT `xnpis_virtuemart_products_el_gr`.* ,`xnpis_virtuemart_products`.* ,`xnpis_virtuemart_ratings`.`rating` ,`xnpis_virtuemart_product_manufacturers`.`virtuemart_manufacturer_id` ,`xnpis_virtuemart_product_customfields`.`virtuemart_customfield_id`
  FROM `xnpis_virtuemart_products_el_gr` JOIN xnpis_virtuemart_products using (`virtuemart_product_id`)
  LEFT JOIN `xnpis_virtuemart_ratings`
  on `xnpis_virtuemart_ratings`.`virtuemart_product_id`=`xnpis_virtuemart_products_el_gr`.`virtuemart_product_id`
  LEFT JOIN `xnpis_virtuemart_product_manufacturers`
  on `xnpis_virtuemart_product_manufacturers`.`virtuemart_product_id`=`xnpis_virtuemart_products_el_gr`.`virtuemart_product_id`
  LEFT JOIN `xnpis_virtuemart_product_customfields`
  on `xnpis_virtuemart_product_customfields`.`virtuemart_product_id`=`xnpis_virtuemart_products_el_gr`.`virtuemart_product_id`
  WHERE xnpis_virtuemart_products_el_gr.`virtuemart_product_id` = "615"
97. SELECT `virtuemart_media_id`
  FROM `xnpis_virtuemart_product_medias`
  WHERE `virtuemart_product_id` = "615"
  ORDER BY `ordering`
98. SELECT `virtuemart_shoppergroup_id`
  FROM `xnpis_virtuemart_product_shoppergroups`
  WHERE `virtuemart_product_id` = "615"
99. SELECT *
  FROM `xnpis_virtuemart_product_prices`
  WHERE `virtuemart_product_id` = "615"
  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` <= "2019-12-15 05:53:36" )
  AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2019-12-15 05:53:36" ) )
  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) )
100. SELECT pc.`virtuemart_category_id`
  FROM `xnpis_virtuemart_product_categories` as pc
  WHERE pc.`virtuemart_product_id` = 615
101. SELECT pc.`virtuemart_category_id`
  FROM `xnpis_virtuemart_product_categories` as pc
  LEFT JOIN `xnpis_virtuemart_categories` as c
  ON c.`virtuemart_category_id` = pc.`virtuemart_category_id`
  WHERE pc.`virtuemart_product_id` = 615
  AND `published`=1
  ORDER BY `c`.`ordering` ASC
102. SELECT `ordering`,`id`
  FROM `xnpis_virtuemart_product_categories`
  WHERE `virtuemart_product_id` = "615"
  and `virtuemart_category_id`= "123"
103. SELECT `xnpis_virtuemart_categories_el_gr`.* ,`xnpis_virtuemart_categories`.*
  FROM `xnpis_virtuemart_categories_el_gr` JOIN xnpis_virtuemart_categories using (`virtuemart_category_id`)
  WHERE xnpis_virtuemart_categories_el_gr.`virtuemart_category_id` = "123"
104. 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 `xnpis_virtuemart_customs` AS C
  LEFT JOIN `xnpis_virtuemart_product_customfields` AS field
  ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
  Where `virtuemart_product_id` =615
  and `field_type` != "G"
  and `field_type` != "R"
  and `field_type` != "Z"
  and is_cart_attribute = 0
  order by field.`ordering`,virtuemart_custom_id
105. 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 `xnpis_virtuemart_customs` AS C
  LEFT JOIN `xnpis_virtuemart_product_customfields` AS field
  ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
  Where `virtuemart_product_id` =615
  and `field_type` = "Z"
  and is_cart_attribute = 0
  order by ordering
106. 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 `xnpis_virtuemart_customs` AS C
  LEFT JOIN `xnpis_virtuemart_product_customfields` AS field
  ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
  Where `virtuemart_product_id` =615
  and `field_type` = "R"
  and is_cart_attribute = 0
  order by ordering
107. 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 `xnpis_virtuemart_customs` AS C
  LEFT JOIN `xnpis_virtuemart_product_customfields` AS field
  ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
  Where `virtuemart_product_id` =615
  and `field_type` != "G"
  and `field_type` != "R"
  and `field_type` != "Z"
  and is_cart_attribute = 1
  group by virtuemart_custom_id
  ORDER BY field.`ordering`
108. SELECT virtuemart_product_id, product_name
  FROM `xnpis_virtuemart_products_el_gr` JOIN `xnpis_virtuemart_products` as C using (`virtuemart_product_id`)
  WHERE `product_parent_id` =615
109. SELECT `vendor_currency`
  FROM xnpis_virtuemart_vendors
  WHERE `virtuemart_vendor_id`="1"
110. SELECT `slug`
  FROM `xnpis_virtuemart_products_el_gr`
  WHERE `virtuemart_product_id` = 615
111. SELECT `xnpis_virtuemart_products_el_gr`.* ,`xnpis_virtuemart_products`.* ,`xnpis_virtuemart_ratings`.`rating` ,`xnpis_virtuemart_product_manufacturers`.`virtuemart_manufacturer_id` ,`xnpis_virtuemart_product_customfields`.`virtuemart_customfield_id`
  FROM `xnpis_virtuemart_products_el_gr` JOIN xnpis_virtuemart_products using (`virtuemart_product_id`)
  LEFT JOIN `xnpis_virtuemart_ratings`
  on `xnpis_virtuemart_ratings`.`virtuemart_product_id`=`xnpis_virtuemart_products_el_gr`.`virtuemart_product_id`
  LEFT JOIN `xnpis_virtuemart_product_manufacturers`
  on `xnpis_virtuemart_product_manufacturers`.`virtuemart_product_id`=`xnpis_virtuemart_products_el_gr`.`virtuemart_product_id`
  LEFT JOIN `xnpis_virtuemart_product_customfields`
  on `xnpis_virtuemart_product_customfields`.`virtuemart_product_id`=`xnpis_virtuemart_products_el_gr`.`virtuemart_product_id`
  WHERE xnpis_virtuemart_products_el_gr.`virtuemart_product_id` = "616"
112. SELECT `virtuemart_media_id`
  FROM `xnpis_virtuemart_product_medias`
  WHERE `virtuemart_product_id` = "616"
  ORDER BY `ordering`
113. SELECT `virtuemart_shoppergroup_id`
  FROM `xnpis_virtuemart_product_shoppergroups`
  WHERE `virtuemart_product_id` = "616"
114. SELECT *
  FROM `xnpis_virtuemart_product_prices`
  WHERE `virtuemart_product_id` = "616"
  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` <= "2019-12-15 05:53:36" )
  AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2019-12-15 05:53:36" ) )
  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) )
115. SELECT pc.`virtuemart_category_id`
  FROM `xnpis_virtuemart_product_categories` as pc
  WHERE pc.`virtuemart_product_id` = 616
116. SELECT pc.`virtuemart_category_id`
  FROM `xnpis_virtuemart_product_categories` as pc
  LEFT JOIN `xnpis_virtuemart_categories` as c
  ON c.`virtuemart_category_id` = pc.`virtuemart_category_id`
  WHERE pc.`virtuemart_product_id` = 616
  AND `published`=1
  ORDER BY `c`.`ordering` ASC
117. SELECT `ordering`,`id`
  FROM `xnpis_virtuemart_product_categories`
  WHERE `virtuemart_product_id` = "616"
  and `virtuemart_category_id`= "123"
118. SELECT `xnpis_virtuemart_categories_el_gr`.* ,`xnpis_virtuemart_categories`.*
  FROM `xnpis_virtuemart_categories_el_gr` JOIN xnpis_virtuemart_categories using (`virtuemart_category_id`)
  WHERE xnpis_virtuemart_categories_el_gr.`virtuemart_category_id` = "123"
119. 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 `xnpis_virtuemart_customs` AS C
  LEFT JOIN `xnpis_virtuemart_product_customfields` AS field
  ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
  Where `virtuemart_product_id` =616
  and `field_type` != "G"
  and `field_type` != "R"
  and `field_type` != "Z"
  and is_cart_attribute = 0
  order by field.`ordering`,virtuemart_custom_id
120. 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 `xnpis_virtuemart_customs` AS C
  LEFT JOIN `xnpis_virtuemart_product_customfields` AS field
  ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
  Where `virtuemart_product_id` =616
  and `field_type` = "Z"
  and is_cart_attribute = 0
  order by ordering
121. 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 `xnpis_virtuemart_customs` AS C
  LEFT JOIN `xnpis_virtuemart_product_customfields` AS field
  ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
  Where `virtuemart_product_id` =616
  and `field_type` = "R"
  and is_cart_attribute = 0
  order by ordering
122. 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 `xnpis_virtuemart_customs` AS C
  LEFT JOIN `xnpis_virtuemart_product_customfields` AS field
  ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
  Where `virtuemart_product_id` =616
  and `field_type` != "G"
  and `field_type` != "R"
  and `field_type` != "Z"
  and is_cart_attribute = 1
  group by virtuemart_custom_id
  ORDER BY field.`ordering`
123. SELECT virtuemart_product_id, product_name
  FROM `xnpis_virtuemart_products_el_gr` JOIN `xnpis_virtuemart_products` as C using (`virtuemart_product_id`)
  WHERE `product_parent_id` =616
124. SELECT `vendor_currency`
  FROM xnpis_virtuemart_vendors
  WHERE `virtuemart_vendor_id`="1"
125. SELECT `slug`
  FROM `xnpis_virtuemart_products_el_gr`
  WHERE `virtuemart_product_id` = 616
126. SELECT `xnpis_virtuemart_products_el_gr`.* ,`xnpis_virtuemart_products`.* ,`xnpis_virtuemart_ratings`.`rating` ,`xnpis_virtuemart_product_manufacturers`.`virtuemart_manufacturer_id` ,`xnpis_virtuemart_product_customfields`.`virtuemart_customfield_id`
  FROM `xnpis_virtuemart_products_el_gr` JOIN xnpis_virtuemart_products using (`virtuemart_product_id`)
  LEFT JOIN `xnpis_virtuemart_ratings`
  on `xnpis_virtuemart_ratings`.`virtuemart_product_id`=`xnpis_virtuemart_products_el_gr`.`virtuemart_product_id`
  LEFT JOIN `xnpis_virtuemart_product_manufacturers`
  on `xnpis_virtuemart_product_manufacturers`.`virtuemart_product_id`=`xnpis_virtuemart_products_el_gr`.`virtuemart_product_id`
  LEFT JOIN `xnpis_virtuemart_product_customfields`
  on `xnpis_virtuemart_product_customfields`.`virtuemart_product_id`=`xnpis_virtuemart_products_el_gr`.`virtuemart_product_id`
  WHERE xnpis_virtuemart_products_el_gr.`virtuemart_product_id` = "2083"
127. SELECT `virtuemart_media_id`
  FROM `xnpis_virtuemart_product_medias`
  WHERE `virtuemart_product_id` = "2083"
  ORDER BY `ordering`
128. SELECT `virtuemart_shoppergroup_id`
  FROM `xnpis_virtuemart_product_shoppergroups`
  WHERE `virtuemart_product_id` = "2083"
129. SELECT *
  FROM `xnpis_virtuemart_product_prices`
  WHERE `virtuemart_product_id` = "2083"
  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` <= "2019-12-15 05:53:36" )
  AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2019-12-15 05:53:36" ) )
  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) )
130. SELECT pc.`virtuemart_category_id`
  FROM `xnpis_virtuemart_product_categories` as pc
  WHERE pc.`virtuemart_product_id` = 2083
131. SELECT pc.`virtuemart_category_id`
  FROM `xnpis_virtuemart_product_categories` as pc
  LEFT JOIN `xnpis_virtuemart_categories` as c
  ON c.`virtuemart_category_id` = pc.`virtuemart_category_id`
  WHERE pc.`virtuemart_product_id` = 2083
  AND `published`=1
  ORDER BY `c`.`ordering` ASC
132. SELECT `ordering`,`id`
  FROM `xnpis_virtuemart_product_categories`
  WHERE `virtuemart_product_id` = "2083"
  and `virtuemart_category_id`= "123"
133. SELECT `xnpis_virtuemart_categories_el_gr`.* ,`xnpis_virtuemart_categories`.*
  FROM `xnpis_virtuemart_categories_el_gr` JOIN xnpis_virtuemart_categories using (`virtuemart_category_id`)
  WHERE xnpis_virtuemart_categories_el_gr.`virtuemart_category_id` = "123"
134. SELECT `vendor_currency`
  FROM xnpis_virtuemart_vendors
  WHERE `virtuemart_vendor_id`="1"
135. SELECT `slug`
  FROM `xnpis_virtuemart_products_el_gr`
  WHERE `virtuemart_product_id` = 2083
136. SELECT `xnpis_virtuemart_products_el_gr`.* ,`xnpis_virtuemart_products`.* ,`xnpis_virtuemart_ratings`.`rating` ,`xnpis_virtuemart_product_manufacturers`.`virtuemart_manufacturer_id` ,`xnpis_virtuemart_product_customfields`.`virtuemart_customfield_id`
  FROM `xnpis_virtuemart_products_el_gr` JOIN xnpis_virtuemart_products using (`virtuemart_product_id`)
  LEFT JOIN `xnpis_virtuemart_ratings`
  on `xnpis_virtuemart_ratings`.`virtuemart_product_id`=`xnpis_virtuemart_products_el_gr`.`virtuemart_product_id`
  LEFT JOIN `xnpis_virtuemart_product_manufacturers`
  on `xnpis_virtuemart_product_manufacturers`.`virtuemart_product_id`=`xnpis_virtuemart_products_el_gr`.`virtuemart_product_id`
  LEFT JOIN `xnpis_virtuemart_product_customfields`
  on `xnpis_virtuemart_product_customfields`.`virtuemart_product_id`=`xnpis_virtuemart_products_el_gr`.`virtuemart_product_id`
  WHERE xnpis_virtuemart_products_el_gr.`virtuemart_product_id` = "2084"
137. SELECT `virtuemart_media_id`
  FROM `xnpis_virtuemart_product_medias`
  WHERE `virtuemart_product_id` = "2084"
  ORDER BY `ordering`
138. SELECT `virtuemart_shoppergroup_id`
  FROM `xnpis_virtuemart_product_shoppergroups`
  WHERE `virtuemart_product_id` = "2084"
139. SELECT *
  FROM `xnpis_virtuemart_product_prices`
  WHERE `virtuemart_product_id` = "2084"
  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` <= "2019-12-15 05:53:36" )
  AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2019-12-15 05:53:36" ) )
  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) )
140. SELECT pc.`virtuemart_category_id`
  FROM `xnpis_virtuemart_product_categories` as pc
  WHERE pc.`virtuemart_product_id` = 2084
141. SELECT pc.`virtuemart_category_id`
  FROM `xnpis_virtuemart_product_categories` as pc
  LEFT JOIN `xnpis_virtuemart_categories` as c
  ON c.`virtuemart_category_id` = pc.`virtuemart_category_id`
  WHERE pc.`virtuemart_product_id` = 2084
  AND `published`=1
  ORDER BY `c`.`ordering` ASC
142. SELECT `ordering`,`id`
  FROM `xnpis_virtuemart_product_categories`
  WHERE `virtuemart_product_id` = "2084"
  and `virtuemart_category_id`= "123"
143. SELECT `xnpis_virtuemart_categories_el_gr`.* ,`xnpis_virtuemart_categories`.*
  FROM `xnpis_virtuemart_categories_el_gr` JOIN xnpis_virtuemart_categories using (`virtuemart_category_id`)
  WHERE xnpis_virtuemart_categories_el_gr.`virtuemart_category_id` = "123"
144. SELECT `vendor_currency`
  FROM xnpis_virtuemart_vendors
  WHERE `virtuemart_vendor_id`="1"
145. SELECT `slug`
  FROM `xnpis_virtuemart_products_el_gr`
  WHERE `virtuemart_product_id` = 2084
146. SELECT `xnpis_virtuemart_products_el_gr`.* ,`xnpis_virtuemart_products`.* ,`xnpis_virtuemart_ratings`.`rating` ,`xnpis_virtuemart_product_manufacturers`.`virtuemart_manufacturer_id` ,`xnpis_virtuemart_product_customfields`.`virtuemart_customfield_id`
  FROM `xnpis_virtuemart_products_el_gr` JOIN xnpis_virtuemart_products using (`virtuemart_product_id`)
  LEFT JOIN `xnpis_virtuemart_ratings`
  on `xnpis_virtuemart_ratings`.`virtuemart_product_id`=`xnpis_virtuemart_products_el_gr`.`virtuemart_product_id`
  LEFT JOIN `xnpis_virtuemart_product_manufacturers`
  on `xnpis_virtuemart_product_manufacturers`.`virtuemart_product_id`=`xnpis_virtuemart_products_el_gr`.`virtuemart_product_id`
  LEFT JOIN `xnpis_virtuemart_product_customfields`
  on `xnpis_virtuemart_product_customfields`.`virtuemart_product_id`=`xnpis_virtuemart_products_el_gr`.`virtuemart_product_id`
  WHERE xnpis_virtuemart_products_el_gr.`virtuemart_product_id` = "2080"
147. SELECT `virtuemart_media_id`
  FROM `xnpis_virtuemart_product_medias`
  WHERE `virtuemart_product_id` = "2080"
  ORDER BY `ordering`
148. SELECT `virtuemart_shoppergroup_id`
  FROM `xnpis_virtuemart_product_shoppergroups`
  WHERE `virtuemart_product_id` = "2080"
149. SELECT *
  FROM `xnpis_virtuemart_product_prices`
  WHERE `virtuemart_product_id` = "2080"
  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` <= "2019-12-15 05:53:36" )
  AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2019-12-15 05:53:36" ) )
  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) )
150. SELECT pc.`virtuemart_category_id`
  FROM `xnpis_virtuemart_product_categories` as pc
  WHERE pc.`virtuemart_product_id` = 2080
151. SELECT pc.`virtuemart_category_id`
  FROM `xnpis_virtuemart_product_categories` as pc
  LEFT JOIN `xnpis_virtuemart_categories` as c
  ON c.`virtuemart_category_id` = pc.`virtuemart_category_id`
  WHERE pc.`virtuemart_product_id` = 2080
  AND `published`=1
  ORDER BY `c`.`ordering` ASC
152. SELECT `ordering`,`id`
  FROM `xnpis_virtuemart_product_categories`
  WHERE `virtuemart_product_id` = "2080"
  and `virtuemart_category_id`= "123"
153. SELECT `xnpis_virtuemart_categories_el_gr`.* ,`xnpis_virtuemart_categories`.*
  FROM `xnpis_virtuemart_categories_el_gr` JOIN xnpis_virtuemart_categories using (`virtuemart_category_id`)
  WHERE xnpis_virtuemart_categories_el_gr.`virtuemart_category_id` = "123"
154. SELECT `vendor_currency`
  FROM xnpis_virtuemart_vendors
  WHERE `virtuemart_vendor_id`="1"
155. SELECT `slug`
  FROM `xnpis_virtuemart_products_el_gr`
  WHERE `virtuemart_product_id` = 2080
156. SELECT `xnpis_virtuemart_products_el_gr`.* ,`xnpis_virtuemart_products`.* ,`xnpis_virtuemart_ratings`.`rating` ,`xnpis_virtuemart_product_manufacturers`.`virtuemart_manufacturer_id` ,`xnpis_virtuemart_product_customfields`.`virtuemart_customfield_id`
  FROM `xnpis_virtuemart_products_el_gr` JOIN xnpis_virtuemart_products using (`virtuemart_product_id`)
  LEFT JOIN `xnpis_virtuemart_ratings`
  on `xnpis_virtuemart_ratings`.`virtuemart_product_id`=`xnpis_virtuemart_products_el_gr`.`virtuemart_product_id`
  LEFT JOIN `xnpis_virtuemart_product_manufacturers`
  on `xnpis_virtuemart_product_manufacturers`.`virtuemart_product_id`=`xnpis_virtuemart_products_el_gr`.`virtuemart_product_id`
  LEFT JOIN `xnpis_virtuemart_product_customfields`
  on `xnpis_virtuemart_product_customfields`.`virtuemart_product_id`=`xnpis_virtuemart_products_el_gr`.`virtuemart_product_id`
  WHERE xnpis_virtuemart_products_el_gr.`virtuemart_product_id` = "1666"
157. SELECT `virtuemart_media_id`
  FROM `xnpis_virtuemart_product_medias`
  WHERE `virtuemart_product_id` = "1666"
  ORDER BY `ordering`
158. SELECT `virtuemart_shoppergroup_id`
  FROM `xnpis_virtuemart_product_shoppergroups`
  WHERE `virtuemart_product_id` = "1666"
159. SELECT *
  FROM `xnpis_virtuemart_product_prices`
  WHERE `virtuemart_product_id` = "1666"
  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` <= "2019-12-15 05:53:36" )
  AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2019-12-15 05:53:36" ) )
  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) )
160. SELECT pc.`virtuemart_category_id`
  FROM `xnpis_virtuemart_product_categories` as pc
  WHERE pc.`virtuemart_product_id` = 1666
161. SELECT pc.`virtuemart_category_id`
  FROM `xnpis_virtuemart_product_categories` as pc
  LEFT JOIN `xnpis_virtuemart_categories` as c
  ON c.`virtuemart_category_id` = pc.`virtuemart_category_id`
  WHERE pc.`virtuemart_product_id` = 1666
  AND `published`=1
  ORDER BY `c`.`ordering` ASC
162. SELECT `ordering`,`id`
  FROM `xnpis_virtuemart_product_categories`
  WHERE `virtuemart_product_id` = "1666"
  and `virtuemart_category_id`= "123"
163. SELECT `xnpis_virtuemart_categories_el_gr`.* ,`xnpis_virtuemart_categories`.*
  FROM `xnpis_virtuemart_categories_el_gr` JOIN xnpis_virtuemart_categories using (`virtuemart_category_id`)
  WHERE xnpis_virtuemart_categories_el_gr.`virtuemart_category_id` = "123"
164. SELECT `vendor_currency`
  FROM xnpis_virtuemart_vendors
  WHERE `virtuemart_vendor_id`="1"
165. SELECT `slug`
  FROM `xnpis_virtuemart_products_el_gr`
  WHERE `virtuemart_product_id` = 1666
166. SELECT `xnpis_virtuemart_products_el_gr`.* ,`xnpis_virtuemart_products`.* ,`xnpis_virtuemart_ratings`.`rating` ,`xnpis_virtuemart_product_manufacturers`.`virtuemart_manufacturer_id` ,`xnpis_virtuemart_product_customfields`.`virtuemart_customfield_id`
  FROM `xnpis_virtuemart_products_el_gr` JOIN xnpis_virtuemart_products using (`virtuemart_product_id`)
  LEFT JOIN `xnpis_virtuemart_ratings`
  on `xnpis_virtuemart_ratings`.`virtuemart_product_id`=`xnpis_virtuemart_products_el_gr`.`virtuemart_product_id`
  LEFT JOIN `xnpis_virtuemart_product_manufacturers`
  on `xnpis_virtuemart_product_manufacturers`.`virtuemart_product_id`=`xnpis_virtuemart_products_el_gr`.`virtuemart_product_id`
  LEFT JOIN `xnpis_virtuemart_product_customfields`
  on `xnpis_virtuemart_product_customfields`.`virtuemart_product_id`=`xnpis_virtuemart_products_el_gr`.`virtuemart_product_id`
  WHERE xnpis_virtuemart_products_el_gr.`virtuemart_product_id` = "2081"
167. SELECT `virtuemart_media_id`
  FROM `xnpis_virtuemart_product_medias`
  WHERE `virtuemart_product_id` = "2081"
  ORDER BY `ordering`
168. SELECT `virtuemart_shoppergroup_id`
  FROM `xnpis_virtuemart_product_shoppergroups`
  WHERE `virtuemart_product_id` = "2081"
169. SELECT *
  FROM `xnpis_virtuemart_product_prices`
  WHERE `virtuemart_product_id` = "2081"
  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` <= "2019-12-15 05:53:36" )
  AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2019-12-15 05:53:36" ) )
  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) )
170. SELECT pc.`virtuemart_category_id`
  FROM `xnpis_virtuemart_product_categories` as pc
  WHERE pc.`virtuemart_product_id` = 2081
171. SELECT pc.`virtuemart_category_id`
  FROM `xnpis_virtuemart_product_categories` as pc
  LEFT JOIN `xnpis_virtuemart_categories` as c
  ON c.`virtuemart_category_id` = pc.`virtuemart_category_id`
  WHERE pc.`virtuemart_product_id` = 2081
  AND `published`=1
  ORDER BY `c`.`ordering` ASC
172. SELECT `ordering`,`id`
  FROM `xnpis_virtuemart_product_categories`
  WHERE `virtuemart_product_id` = "2081"
  and `virtuemart_category_id`= "123"
173. SELECT `xnpis_virtuemart_categories_el_gr`.* ,`xnpis_virtuemart_categories`.*
  FROM `xnpis_virtuemart_categories_el_gr` JOIN xnpis_virtuemart_categories using (`virtuemart_category_id`)
  WHERE xnpis_virtuemart_categories_el_gr.`virtuemart_category_id` = "123"
174. SELECT `vendor_currency`
  FROM xnpis_virtuemart_vendors
  WHERE `virtuemart_vendor_id`="1"
175. SELECT `slug`
  FROM `xnpis_virtuemart_products_el_gr`
  WHERE `virtuemart_product_id` = 2081
176. SELECT `xnpis_virtuemart_products_el_gr`.* ,`xnpis_virtuemart_products`.* ,`xnpis_virtuemart_ratings`.`rating` ,`xnpis_virtuemart_product_manufacturers`.`virtuemart_manufacturer_id` ,`xnpis_virtuemart_product_customfields`.`virtuemart_customfield_id`
  FROM `xnpis_virtuemart_products_el_gr` JOIN xnpis_virtuemart_products using (`virtuemart_product_id`)
  LEFT JOIN `xnpis_virtuemart_ratings`
  on `xnpis_virtuemart_ratings`.`virtuemart_product_id`=`xnpis_virtuemart_products_el_gr`.`virtuemart_product_id`
  LEFT JOIN `xnpis_virtuemart_product_manufacturers`
  on `xnpis_virtuemart_product_manufacturers`.`virtuemart_product_id`=`xnpis_virtuemart_products_el_gr`.`virtuemart_product_id`
  LEFT JOIN `xnpis_virtuemart_product_customfields`
  on `xnpis_virtuemart_product_customfields`.`virtuemart_product_id`=`xnpis_virtuemart_products_el_gr`.`virtuemart_product_id`
  WHERE xnpis_virtuemart_products_el_gr.`virtuemart_product_id` = "2082"
177. SELECT `virtuemart_media_id`
  FROM `xnpis_virtuemart_product_medias`
  WHERE `virtuemart_product_id` = "2082"
  ORDER BY `ordering`
178. SELECT `virtuemart_shoppergroup_id`
  FROM `xnpis_virtuemart_product_shoppergroups`
  WHERE `virtuemart_product_id` = "2082"
179. SELECT *
  FROM `xnpis_virtuemart_product_prices`
  WHERE `virtuemart_product_id` = "2082"
  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` <= "2019-12-15 05:53:36" )
  AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2019-12-15 05:53:36" ) )
  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) )
180. SELECT pc.`virtuemart_category_id`
  FROM `xnpis_virtuemart_product_categories` as pc
  WHERE pc.`virtuemart_product_id` = 2082
181. SELECT pc.`virtuemart_category_id`
  FROM `xnpis_virtuemart_product_categories` as pc
  LEFT JOIN `xnpis_virtuemart_categories` as c
  ON c.`virtuemart_category_id` = pc.`virtuemart_category_id`
  WHERE pc.`virtuemart_product_id` = 2082
  AND `published`=1
  ORDER BY `c`.`ordering` ASC
182. SELECT `ordering`,`id`
  FROM `xnpis_virtuemart_product_categories`
  WHERE `virtuemart_product_id` = "2082"
  and `virtuemart_category_id`= "123"
183. SELECT `xnpis_virtuemart_categories_el_gr`.* ,`xnpis_virtuemart_categories`.*
  FROM `xnpis_virtuemart_categories_el_gr` JOIN xnpis_virtuemart_categories using (`virtuemart_category_id`)
  WHERE xnpis_virtuemart_categories_el_gr.`virtuemart_category_id` = "123"
184. SELECT `vendor_currency`
  FROM xnpis_virtuemart_vendors
  WHERE `virtuemart_vendor_id`="1"
185. SELECT `slug`
  FROM `xnpis_virtuemart_products_el_gr`
  WHERE `virtuemart_product_id` = 2082
186. SELECT `xnpis_virtuemart_products_el_gr`.* ,`xnpis_virtuemart_products`.* ,`xnpis_virtuemart_ratings`.`rating` ,`xnpis_virtuemart_product_manufacturers`.`virtuemart_manufacturer_id` ,`xnpis_virtuemart_product_customfields`.`virtuemart_customfield_id`
  FROM `xnpis_virtuemart_products_el_gr` JOIN xnpis_virtuemart_products using (`virtuemart_product_id`)
  LEFT JOIN `xnpis_virtuemart_ratings`
  on `xnpis_virtuemart_ratings`.`virtuemart_product_id`=`xnpis_virtuemart_products_el_gr`.`virtuemart_product_id`
  LEFT JOIN `xnpis_virtuemart_product_manufacturers`
  on `xnpis_virtuemart_product_manufacturers`.`virtuemart_product_id`=`xnpis_virtuemart_products_el_gr`.`virtuemart_product_id`
  LEFT JOIN `xnpis_virtuemart_product_customfields`
  on `xnpis_virtuemart_product_customfields`.`virtuemart_product_id`=`xnpis_virtuemart_products_el_gr`.`virtuemart_product_id`
  WHERE xnpis_virtuemart_products_el_gr.`virtuemart_product_id` = "1664"
187. SELECT `virtuemart_media_id`
  FROM `xnpis_virtuemart_product_medias`
  WHERE `virtuemart_product_id` = "1664"
  ORDER BY `ordering`
188. SELECT `virtuemart_shoppergroup_id`
  FROM `xnpis_virtuemart_product_shoppergroups`
  WHERE `virtuemart_product_id` = "1664"
189. SELECT *
  FROM `xnpis_virtuemart_product_prices`
  WHERE `virtuemart_product_id` = "1664"
  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` <= "2019-12-15 05:53:36" )
  AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2019-12-15 05:53:36" ) )
  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) )
190. SELECT pc.`virtuemart_category_id`
  FROM `xnpis_virtuemart_product_categories` as pc
  WHERE pc.`virtuemart_product_id` = 1664
191. SELECT pc.`virtuemart_category_id`
  FROM `xnpis_virtuemart_product_categories` as pc
  LEFT JOIN `xnpis_virtuemart_categories` as c
  ON c.`virtuemart_category_id` = pc.`virtuemart_category_id`
  WHERE pc.`virtuemart_product_id` = 1664
  AND `published`=1
  ORDER BY `c`.`ordering` ASC
192. SELECT `ordering`,`id`
  FROM `xnpis_virtuemart_product_categories`
  WHERE `virtuemart_product_id` = "1664"
  and `virtuemart_category_id`= "123"
193. SELECT `xnpis_virtuemart_categories_el_gr`.* ,`xnpis_virtuemart_categories`.*
  FROM `xnpis_virtuemart_categories_el_gr` JOIN xnpis_virtuemart_categories using (`virtuemart_category_id`)
  WHERE xnpis_virtuemart_categories_el_gr.`virtuemart_category_id` = "123"
194. SELECT `vendor_currency`
  FROM xnpis_virtuemart_vendors
  WHERE `virtuemart_vendor_id`="1"
195. SELECT `slug`
  FROM `xnpis_virtuemart_products_el_gr`
  WHERE `virtuemart_product_id` = 1664
196. SELECT `xnpis_virtuemart_products_el_gr`.* ,`xnpis_virtuemart_products`.* ,`xnpis_virtuemart_ratings`.`rating` ,`xnpis_virtuemart_product_manufacturers`.`virtuemart_manufacturer_id` ,`xnpis_virtuemart_product_customfields`.`virtuemart_customfield_id`
  FROM `xnpis_virtuemart_products_el_gr` JOIN xnpis_virtuemart_products using (`virtuemart_product_id`)
  LEFT JOIN `xnpis_virtuemart_ratings`
  on `xnpis_virtuemart_ratings`.`virtuemart_product_id`=`xnpis_virtuemart_products_el_gr`.`virtuemart_product_id`
  LEFT JOIN `xnpis_virtuemart_product_manufacturers`
  on `xnpis_virtuemart_product_manufacturers`.`virtuemart_product_id`=`xnpis_virtuemart_products_el_gr`.`virtuemart_product_id`
  LEFT JOIN `xnpis_virtuemart_product_customfields`
  on `xnpis_virtuemart_product_customfields`.`virtuemart_product_id`=`xnpis_virtuemart_products_el_gr`.`virtuemart_product_id`
  WHERE xnpis_virtuemart_products_el_gr.`virtuemart_product_id` = "1637"
197. SELECT `virtuemart_media_id`
  FROM `xnpis_virtuemart_product_medias`
  WHERE `virtuemart_product_id` = "1637"
  ORDER BY `ordering`
198. SELECT `virtuemart_shoppergroup_id`
  FROM `xnpis_virtuemart_product_shoppergroups`
  WHERE `virtuemart_product_id` = "1637"
199. SELECT *
  FROM `xnpis_virtuemart_product_prices`
  WHERE `virtuemart_product_id` = "1637"
  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` <= "2019-12-15 05:53:36" )
  AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2019-12-15 05:53:36" ) )
  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) )
200. SELECT pc.`virtuemart_category_id`
  FROM `xnpis_virtuemart_product_categories` as pc
  WHERE pc.`virtuemart_product_id` = 1637
201. SELECT pc.`virtuemart_category_id`
  FROM `xnpis_virtuemart_product_categories` as pc
  LEFT JOIN `xnpis_virtuemart_categories` as c
  ON c.`virtuemart_category_id` = pc.`virtuemart_category_id`
  WHERE pc.`virtuemart_product_id` = 1637
  AND `published`=1
  ORDER BY `c`.`ordering` ASC
202. SELECT `ordering`,`id`
  FROM `xnpis_virtuemart_product_categories`
  WHERE `virtuemart_product_id` = "1637"
  and `virtuemart_category_id`= "123"
203. SELECT `xnpis_virtuemart_categories_el_gr`.* ,`xnpis_virtuemart_categories`.*
  FROM `xnpis_virtuemart_categories_el_gr` JOIN xnpis_virtuemart_categories using (`virtuemart_category_id`)
  WHERE xnpis_virtuemart_categories_el_gr.`virtuemart_category_id` = "123"
204. SELECT `vendor_currency`
  FROM xnpis_virtuemart_vendors
  WHERE `virtuemart_vendor_id`="1"
205. SELECT `slug`
  FROM `xnpis_virtuemart_products_el_gr`
  WHERE `virtuemart_product_id` = 1637
206. SELECT `xnpis_virtuemart_products_el_gr`.* ,`xnpis_virtuemart_products`.* ,`xnpis_virtuemart_ratings`.`rating` ,`xnpis_virtuemart_product_manufacturers`.`virtuemart_manufacturer_id` ,`xnpis_virtuemart_product_customfields`.`virtuemart_customfield_id`
  FROM `xnpis_virtuemart_products_el_gr` JOIN xnpis_virtuemart_products using (`virtuemart_product_id`)
  LEFT JOIN `xnpis_virtuemart_ratings`
  on `xnpis_virtuemart_ratings`.`virtuemart_product_id`=`xnpis_virtuemart_products_el_gr`.`virtuemart_product_id`
  LEFT JOIN `xnpis_virtuemart_product_manufacturers`
  on `xnpis_virtuemart_product_manufacturers`.`virtuemart_product_id`=`xnpis_virtuemart_products_el_gr`.`virtuemart_product_id`
  LEFT JOIN `xnpis_virtuemart_product_customfields`
  on `xnpis_virtuemart_product_customfields`.`virtuemart_product_id`=`xnpis_virtuemart_products_el_gr`.`virtuemart_product_id`
  WHERE xnpis_virtuemart_products_el_gr.`virtuemart_product_id` = "1162"
207. SELECT `virtuemart_media_id`
  FROM `xnpis_virtuemart_product_medias`
  WHERE `virtuemart_product_id` = "1162"
  ORDER BY `ordering`
208. SELECT `virtuemart_shoppergroup_id`
  FROM `xnpis_virtuemart_product_shoppergroups`
  WHERE `virtuemart_product_id` = "1162"
209. SELECT *
  FROM `xnpis_virtuemart_product_prices`
  WHERE `virtuemart_product_id` = "1162"
  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` <= "2019-12-15 05:53:36" )
  AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2019-12-15 05:53:36" ) )
  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) )
210. SELECT pc.`virtuemart_category_id`
  FROM `xnpis_virtuemart_product_categories` as pc
  WHERE pc.`virtuemart_product_id` = 1162
211. SELECT pc.`virtuemart_category_id`
  FROM `xnpis_virtuemart_product_categories` as pc
  LEFT JOIN `xnpis_virtuemart_categories` as c
  ON c.`virtuemart_category_id` = pc.`virtuemart_category_id`
  WHERE pc.`virtuemart_product_id` = 1162
  AND `published`=1
  ORDER BY `c`.`ordering` ASC
212. SELECT `ordering`,`id`
  FROM `xnpis_virtuemart_product_categories`
  WHERE `virtuemart_product_id` = "1162"
  and `virtuemart_category_id`= "123"
213. SELECT `xnpis_virtuemart_categories_el_gr`.* ,`xnpis_virtuemart_categories`.*
  FROM `xnpis_virtuemart_categories_el_gr` JOIN xnpis_virtuemart_categories using (`virtuemart_category_id`)
  WHERE xnpis_virtuemart_categories_el_gr.`virtuemart_category_id` = "123"
214. 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 `xnpis_virtuemart_customs` AS C
  LEFT JOIN `xnpis_virtuemart_product_customfields` AS field
  ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
  Where `virtuemart_product_id` =1162
  and `field_type` != "G"
  and `field_type` != "R"
  and `field_type` != "Z"
  and is_cart_attribute = 0
  order by field.`ordering`,virtuemart_custom_id
215. 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 `xnpis_virtuemart_customs` AS C
  LEFT JOIN `xnpis_virtuemart_product_customfields` AS field
  ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
  Where `virtuemart_product_id` =1162
  and `field_type` = "Z"
  and is_cart_attribute = 0
  order by ordering
216. 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 `xnpis_virtuemart_customs` AS C
  LEFT JOIN `xnpis_virtuemart_product_customfields` AS field
  ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
  Where `virtuemart_product_id` =1162
  and `field_type` = "R"
  and is_cart_attribute = 0
  order by ordering
217. 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 `xnpis_virtuemart_customs` AS C
  LEFT JOIN `xnpis_virtuemart_product_customfields` AS field
  ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
  Where `virtuemart_product_id` =1162
  and `field_type` != "G"
  and `field_type` != "R"
  and `field_type` != "Z"
  and is_cart_attribute = 1
  group by virtuemart_custom_id
  ORDER BY field.`ordering`
218. SELECT virtuemart_product_id, product_name
  FROM `xnpis_virtuemart_products_el_gr` JOIN `xnpis_virtuemart_products` as C using (`virtuemart_product_id`)
  WHERE `product_parent_id` =1162
219. SELECT `vendor_currency`
  FROM xnpis_virtuemart_vendors
  WHERE `virtuemart_vendor_id`="1"
220. SELECT `slug`
  FROM `xnpis_virtuemart_products_el_gr`
  WHERE `virtuemart_product_id` = 1162
221. SELECT `xnpis_virtuemart_products_el_gr`.* ,`xnpis_virtuemart_products`.* ,`xnpis_virtuemart_ratings`.`rating` ,`xnpis_virtuemart_product_manufacturers`.`virtuemart_manufacturer_id` ,`xnpis_virtuemart_product_customfields`.`virtuemart_customfield_id`
  FROM `xnpis_virtuemart_products_el_gr` JOIN xnpis_virtuemart_products using (`virtuemart_product_id`)
  LEFT JOIN `xnpis_virtuemart_ratings`
  on `xnpis_virtuemart_ratings`.`virtuemart_product_id`=`xnpis_virtuemart_products_el_gr`.`virtuemart_product_id`
  LEFT JOIN `xnpis_virtuemart_product_manufacturers`
  on `xnpis_virtuemart_product_manufacturers`.`virtuemart_product_id`=`xnpis_virtuemart_products_el_gr`.`virtuemart_product_id`
  LEFT JOIN `xnpis_virtuemart_product_customfields`
  on `xnpis_virtuemart_product_customfields`.`virtuemart_product_id`=`xnpis_virtuemart_products_el_gr`.`virtuemart_product_id`
  WHERE xnpis_virtuemart_products_el_gr.`virtuemart_product_id` = "2049"
222. SELECT `virtuemart_media_id`
  FROM `xnpis_virtuemart_product_medias`
  WHERE `virtuemart_product_id` = "2049"
  ORDER BY `ordering`
223. SELECT `virtuemart_shoppergroup_id`
  FROM `xnpis_virtuemart_product_shoppergroups`
  WHERE `virtuemart_product_id` = "2049"
224. SELECT *
  FROM `xnpis_virtuemart_product_prices`
  WHERE `virtuemart_product_id` = "2049"
  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` <= "2019-12-15 05:53:36" )
  AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2019-12-15 05:53:36" ) )
  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) )
225. SELECT pc.`virtuemart_category_id`
  FROM `xnpis_virtuemart_product_categories` as pc
  WHERE pc.`virtuemart_product_id` = 2049
226. SELECT pc.`virtuemart_category_id`
  FROM `xnpis_virtuemart_product_categories` as pc
  LEFT JOIN `xnpis_virtuemart_categories` as c
  ON c.`virtuemart_category_id` = pc.`virtuemart_category_id`
  WHERE pc.`virtuemart_product_id` = 2049
  AND `published`=1
  ORDER BY `c`.`ordering` ASC
227. SELECT `ordering`,`id`
  FROM `xnpis_virtuemart_product_categories`
  WHERE `virtuemart_product_id` = "2049"
  and `virtuemart_category_id`= "123"
228. SELECT `xnpis_virtuemart_categories_el_gr`.* ,`xnpis_virtuemart_categories`.*
  FROM `xnpis_virtuemart_categories_el_gr` JOIN xnpis_virtuemart_categories using (`virtuemart_category_id`)
  WHERE xnpis_virtuemart_categories_el_gr.`virtuemart_category_id` = "123"
229. 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 `xnpis_virtuemart_customs` AS C
  LEFT JOIN `xnpis_virtuemart_product_customfields` AS field
  ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
  Where `virtuemart_product_id` =2049
  and `field_type` != "G"
  and `field_type` != "R"
  and `field_type` != "Z"
  and is_cart_attribute = 0
  order by field.`ordering`,virtuemart_custom_id
230. 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 `xnpis_virtuemart_customs` AS C
  LEFT JOIN `xnpis_virtuemart_product_customfields` AS field
  ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
  Where `virtuemart_product_id` =2049
  and `field_type` = "Z"
  and is_cart_attribute = 0
  order by ordering
231. 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 `xnpis_virtuemart_customs` AS C
  LEFT JOIN `xnpis_virtuemart_product_customfields` AS field
  ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
  Where `virtuemart_product_id` =2049
  and `field_type` = "R"
  and is_cart_attribute = 0
  order by ordering
232. 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 `xnpis_virtuemart_customs` AS C
  LEFT JOIN `xnpis_virtuemart_product_customfields` AS field
  ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
  Where `virtuemart_product_id` =2049
  and `field_type` != "G"
  and `field_type` != "R"
  and `field_type` != "Z"
  and is_cart_attribute = 1
  group by virtuemart_custom_id
  ORDER BY field.`ordering`
233. SELECT virtuemart_product_id, product_name
  FROM `xnpis_virtuemart_products_el_gr` JOIN `xnpis_virtuemart_products` as C using (`virtuemart_product_id`)
  WHERE `product_parent_id` =2049
234. SELECT `vendor_currency`
  FROM xnpis_virtuemart_vendors
  WHERE `virtuemart_vendor_id`="1"
235. SELECT `slug`
  FROM `xnpis_virtuemart_products_el_gr`
  WHERE `virtuemart_product_id` = 2049
236. SELECT `xnpis_virtuemart_products_el_gr`.* ,`xnpis_virtuemart_products`.* ,`xnpis_virtuemart_ratings`.`rating` ,`xnpis_virtuemart_product_manufacturers`.`virtuemart_manufacturer_id` ,`xnpis_virtuemart_product_customfields`.`virtuemart_customfield_id`
  FROM `xnpis_virtuemart_products_el_gr` JOIN xnpis_virtuemart_products using (`virtuemart_product_id`)
  LEFT JOIN `xnpis_virtuemart_ratings`
  on `xnpis_virtuemart_ratings`.`virtuemart_product_id`=`xnpis_virtuemart_products_el_gr`.`virtuemart_product_id`
  LEFT JOIN `xnpis_virtuemart_product_manufacturers`
  on `xnpis_virtuemart_product_manufacturers`.`virtuemart_product_id`=`xnpis_virtuemart_products_el_gr`.`virtuemart_product_id`
  LEFT JOIN `xnpis_virtuemart_product_customfields`
  on `xnpis_virtuemart_product_customfields`.`virtuemart_product_id`=`xnpis_virtuemart_products_el_gr`.`virtuemart_product_id`
  WHERE xnpis_virtuemart_products_el_gr.`virtuemart_product_id` = "620"
237. SELECT `virtuemart_media_id`
  FROM `xnpis_virtuemart_product_medias`
  WHERE `virtuemart_product_id` = "620"
  ORDER BY `ordering`
238. SELECT `virtuemart_shoppergroup_id`
  FROM `xnpis_virtuemart_product_shoppergroups`
  WHERE `virtuemart_product_id` = "620"
239. SELECT *
  FROM `xnpis_virtuemart_product_prices`
  WHERE `virtuemart_product_id` = "620"
  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` <= "2019-12-15 05:53:36" )
  AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2019-12-15 05:53:36" ) )
  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) )
240. SELECT pc.`virtuemart_category_id`
  FROM `xnpis_virtuemart_product_categories` as pc
  WHERE pc.`virtuemart_product_id` = 620
241. SELECT pc.`virtuemart_category_id`
  FROM `xnpis_virtuemart_product_categories` as pc
  LEFT JOIN `xnpis_virtuemart_categories` as c
  ON c.`virtuemart_category_id` = pc.`virtuemart_category_id`
  WHERE pc.`virtuemart_product_id` = 620
  AND `published`=1
  ORDER BY `c`.`ordering` ASC
242. SELECT `ordering`,`id`
  FROM `xnpis_virtuemart_product_categories`
  WHERE `virtuemart_product_id` = "620"
  and `virtuemart_category_id`= "123"
243. SELECT `xnpis_virtuemart_categories_el_gr`.* ,`xnpis_virtuemart_categories`.*
  FROM `xnpis_virtuemart_categories_el_gr` JOIN xnpis_virtuemart_categories using (`virtuemart_category_id`)
  WHERE xnpis_virtuemart_categories_el_gr.`virtuemart_category_id` = "123"
244. 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 `xnpis_virtuemart_customs` AS C
  LEFT JOIN `xnpis_virtuemart_product_customfields` AS field
  ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
  Where `virtuemart_product_id` =620
  and `field_type` != "G"
  and `field_type` != "R"
  and `field_type` != "Z"
  and is_cart_attribute = 0
  order by field.`ordering`,virtuemart_custom_id
245. 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 `xnpis_virtuemart_customs` AS C
  LEFT JOIN `xnpis_virtuemart_product_customfields` AS field
  ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
  Where `virtuemart_product_id` =620
  and `field_type` = "Z"
  and is_cart_attribute = 0
  order by ordering
246. 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 `xnpis_virtuemart_customs` AS C
  LEFT JOIN `xnpis_virtuemart_product_customfields` AS field
  ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
  Where `virtuemart_product_id` =620
  and `field_type` = "R"
  and is_cart_attribute = 0
  order by ordering
247. 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 `xnpis_virtuemart_customs` AS C
  LEFT JOIN `xnpis_virtuemart_product_customfields` AS field
  ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
  Where `virtuemart_product_id` =620
  and `field_type` != "G"
  and `field_type` != "R"
  and `field_type` != "Z"
  and is_cart_attribute = 1
  group by virtuemart_custom_id
  ORDER BY field.`ordering`
248. SELECT virtuemart_product_id, product_name
  FROM `xnpis_virtuemart_products_el_gr` JOIN `xnpis_virtuemart_products` as C using (`virtuemart_product_id`)
  WHERE `product_parent_id` =620
249. SELECT `vendor_currency`
  FROM xnpis_virtuemart_vendors
  WHERE `virtuemart_vendor_id`="1"
250. SELECT `slug`
  FROM `xnpis_virtuemart_products_el_gr`
  WHERE `virtuemart_product_id` = 620
251. SELECT `xnpis_virtuemart_products_el_gr`.* ,`xnpis_virtuemart_products`.* ,`xnpis_virtuemart_ratings`.`rating` ,`xnpis_virtuemart_product_manufacturers`.`virtuemart_manufacturer_id` ,`xnpis_virtuemart_product_customfields`.`virtuemart_customfield_id`
  FROM `xnpis_virtuemart_products_el_gr` JOIN xnpis_virtuemart_products using (`virtuemart_product_id`)
  LEFT JOIN `xnpis_virtuemart_ratings`
  on `xnpis_virtuemart_ratings`.`virtuemart_product_id`=`xnpis_virtuemart_products_el_gr`.`virtuemart_product_id`
  LEFT JOIN `xnpis_virtuemart_product_manufacturers`
  on `xnpis_virtuemart_product_manufacturers`.`virtuemart_product_id`=`xnpis_virtuemart_products_el_gr`.`virtuemart_product_id`
  LEFT JOIN `xnpis_virtuemart_product_customfields`
  on `xnpis_virtuemart_product_customfields`.`virtuemart_product_id`=`xnpis_virtuemart_products_el_gr`.`virtuemart_product_id`
  WHERE xnpis_virtuemart_products_el_gr.`virtuemart_product_id` = "2085"
252. SELECT `virtuemart_media_id`
  FROM `xnpis_virtuemart_product_medias`
  WHERE `virtuemart_product_id` = "2085"
  ORDER BY `ordering`
253. SELECT `virtuemart_shoppergroup_id`
  FROM `xnpis_virtuemart_product_shoppergroups`
  WHERE `virtuemart_product_id` = "2085"
254. SELECT *
  FROM `xnpis_virtuemart_product_prices`
  WHERE `virtuemart_product_id` = "2085"
  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` <= "2019-12-15 05:53:36" )
  AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2019-12-15 05:53:36" ) )
  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) )
255. SELECT pc.`virtuemart_category_id`
  FROM `xnpis_virtuemart_product_categories` as pc
  WHERE pc.`virtuemart_product_id` = 2085
256. SELECT pc.`virtuemart_category_id`
  FROM `xnpis_virtuemart_product_categories` as pc
  LEFT JOIN `xnpis_virtuemart_categories` as c
  ON c.`virtuemart_category_id` = pc.`virtuemart_category_id`
  WHERE pc.`virtuemart_product_id` = 2085
  AND `published`=1
  ORDER BY `c`.`ordering` ASC
257. SELECT `ordering`,`id`
  FROM `xnpis_virtuemart_product_categories`
  WHERE `virtuemart_product_id` = "2085"
  and `virtuemart_category_id`= "123"
258. SELECT `xnpis_virtuemart_categories_el_gr`.* ,`xnpis_virtuemart_categories`.*
  FROM `xnpis_virtuemart_categories_el_gr` JOIN xnpis_virtuemart_categories using (`virtuemart_category_id`)
  WHERE xnpis_virtuemart_categories_el_gr.`virtuemart_category_id` = "123"
259. SELECT `vendor_currency`
  FROM xnpis_virtuemart_vendors
  WHERE `virtuemart_vendor_id`="1"
260. SELECT `slug`
  FROM `xnpis_virtuemart_products_el_gr`
  WHERE `virtuemart_product_id` = 2085
261. SELECT `xnpis_virtuemart_products_el_gr`.* ,`xnpis_virtuemart_products`.* ,`xnpis_virtuemart_ratings`.`rating` ,`xnpis_virtuemart_product_manufacturers`.`virtuemart_manufacturer_id` ,`xnpis_virtuemart_product_customfields`.`virtuemart_customfield_id`
  FROM `xnpis_virtuemart_products_el_gr` JOIN xnpis_virtuemart_products using (`virtuemart_product_id`)
  LEFT JOIN `xnpis_virtuemart_ratings`
  on `xnpis_virtuemart_ratings`.`virtuemart_product_id`=`xnpis_virtuemart_products_el_gr`.`virtuemart_product_id`
  LEFT JOIN `xnpis_virtuemart_product_manufacturers`
  on `xnpis_virtuemart_product_manufacturers`.`virtuemart_product_id`=`xnpis_virtuemart_products_el_gr`.`virtuemart_product_id`
  LEFT JOIN `xnpis_virtuemart_product_customfields`
  on `xnpis_virtuemart_product_customfields`.`virtuemart_product_id`=`xnpis_virtuemart_products_el_gr`.`virtuemart_product_id`
  WHERE xnpis_virtuemart_products_el_gr.`virtuemart_product_id` = "2048"
262. SELECT `virtuemart_media_id`
  FROM `xnpis_virtuemart_product_medias`
  WHERE `virtuemart_product_id` = "2048"
  ORDER BY `ordering`
263. SELECT `virtuemart_shoppergroup_id`
  FROM `xnpis_virtuemart_product_shoppergroups`
  WHERE `virtuemart_product_id` = "2048"
264. SELECT *
  FROM `xnpis_virtuemart_product_prices`
  WHERE `virtuemart_product_id` = "2048"
  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` <= "2019-12-15 05:53:36" )
  AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2019-12-15 05:53:36" ) )
  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) )
265. SELECT pc.`virtuemart_category_id`
  FROM `xnpis_virtuemart_product_categories` as pc
  WHERE pc.`virtuemart_product_id` = 2048
266. SELECT pc.`virtuemart_category_id`
  FROM `xnpis_virtuemart_product_categories` as pc
  LEFT JOIN `xnpis_virtuemart_categories` as c
  ON c.`virtuemart_category_id` = pc.`virtuemart_category_id`
  WHERE pc.`virtuemart_product_id` = 2048
  AND `published`=1
  ORDER BY `c`.`ordering` ASC
267. SELECT `ordering`,`id`
  FROM `xnpis_virtuemart_product_categories`
  WHERE `virtuemart_product_id` = "2048"
  and `virtuemart_category_id`= "123"
268. SELECT `xnpis_virtuemart_categories_el_gr`.* ,`xnpis_virtuemart_categories`.*
  FROM `xnpis_virtuemart_categories_el_gr` JOIN xnpis_virtuemart_categories using (`virtuemart_category_id`)
  WHERE xnpis_virtuemart_categories_el_gr.`virtuemart_category_id` = "123"
269. 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 `xnpis_virtuemart_customs` AS C
  LEFT JOIN `xnpis_virtuemart_product_customfields` AS field
  ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
  Where `virtuemart_product_id` =2048
  and `field_type` != "G"
  and `field_type` != "R"
  and `field_type` != "Z"
  and is_cart_attribute = 0
  order by field.`ordering`,virtuemart_custom_id
270. 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 `xnpis_virtuemart_customs` AS C
  LEFT JOIN `xnpis_virtuemart_product_customfields` AS field
  ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
  Where `virtuemart_product_id` =2048
  and `field_type` = "Z"
  and is_cart_attribute = 0
  order by ordering
271. 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 `xnpis_virtuemart_customs` AS C
  LEFT JOIN `xnpis_virtuemart_product_customfields` AS field
  ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
  Where `virtuemart_product_id` =2048
  and `field_type` = "R"
  and is_cart_attribute = 0
  order by ordering
272. 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 `xnpis_virtuemart_customs` AS C
  LEFT JOIN `xnpis_virtuemart_product_customfields` AS field
  ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
  Where `virtuemart_product_id` =2048
  and `field_type` != "G"
  and `field_type` != "R"
  and `field_type` != "Z"
  and is_cart_attribute = 1
  group by virtuemart_custom_id
  ORDER BY field.`ordering`
273. SELECT virtuemart_product_id, product_name
  FROM `xnpis_virtuemart_products_el_gr` JOIN `xnpis_virtuemart_products` as C using (`virtuemart_product_id`)
  WHERE `product_parent_id` =2048
274. SELECT `vendor_currency`
  FROM xnpis_virtuemart_vendors
  WHERE `virtuemart_vendor_id`="1"
275. SELECT `slug`
  FROM `xnpis_virtuemart_products_el_gr`
  WHERE `virtuemart_product_id` = 2048
276. SELECT `xnpis_virtuemart_products_el_gr`.* ,`xnpis_virtuemart_products`.* ,`xnpis_virtuemart_ratings`.`rating` ,`xnpis_virtuemart_product_manufacturers`.`virtuemart_manufacturer_id` ,`xnpis_virtuemart_product_customfields`.`virtuemart_customfield_id`
  FROM `xnpis_virtuemart_products_el_gr` JOIN xnpis_virtuemart_products using (`virtuemart_product_id`)
  LEFT JOIN `xnpis_virtuemart_ratings`
  on `xnpis_virtuemart_ratings`.`virtuemart_product_id`=`xnpis_virtuemart_products_el_gr`.`virtuemart_product_id`
  LEFT JOIN `xnpis_virtuemart_product_manufacturers`
  on `xnpis_virtuemart_product_manufacturers`.`virtuemart_product_id`=`xnpis_virtuemart_products_el_gr`.`virtuemart_product_id`
  LEFT JOIN `xnpis_virtuemart_product_customfields`
  on `xnpis_virtuemart_product_customfields`.`virtuemart_product_id`=`xnpis_virtuemart_products_el_gr`.`virtuemart_product_id`
  WHERE xnpis_virtuemart_products_el_gr.`virtuemart_product_id` = "2044"
277. SELECT `virtuemart_media_id`
  FROM `xnpis_virtuemart_product_medias`
  WHERE `virtuemart_product_id` = "2044"
  ORDER BY `ordering`
278. SELECT `virtuemart_shoppergroup_id`
  FROM `xnpis_virtuemart_product_shoppergroups`
  WHERE `virtuemart_product_id` = "2044"
279. SELECT *
  FROM `xnpis_virtuemart_product_prices`
  WHERE `virtuemart_product_id` = "2044"
  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` <= "2019-12-15 05:53:36" )
  AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2019-12-15 05:53:36" ) )
  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) )
280. SELECT pc.`virtuemart_category_id`
  FROM `xnpis_virtuemart_product_categories` as pc
  WHERE pc.`virtuemart_product_id` = 2044
281. SELECT pc.`virtuemart_category_id`
  FROM `xnpis_virtuemart_product_categories` as pc
  LEFT JOIN `xnpis_virtuemart_categories` as c
  ON c.`virtuemart_category_id` = pc.`virtuemart_category_id`
  WHERE pc.`virtuemart_product_id` = 2044
  AND `published`=1
  ORDER BY `c`.`ordering` ASC
282. SELECT `ordering`,`id`
  FROM `xnpis_virtuemart_product_categories`
  WHERE `virtuemart_product_id` = "2044"
  and `virtuemart_category_id`= "123"
283. SELECT `xnpis_virtuemart_categories_el_gr`.* ,`xnpis_virtuemart_categories`.*
  FROM `xnpis_virtuemart_categories_el_gr` JOIN xnpis_virtuemart_categories using (`virtuemart_category_id`)
  WHERE xnpis_virtuemart_categories_el_gr.`virtuemart_category_id` = "123"
284. 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 `xnpis_virtuemart_customs` AS C
  LEFT JOIN `xnpis_virtuemart_product_customfields` AS field
  ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
  Where `virtuemart_product_id` =2044
  and `field_type` != "G"
  and `field_type` != "R"
  and `field_type` != "Z"
  and is_cart_attribute = 0
  order by field.`ordering`,virtuemart_custom_id
285. 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 `xnpis_virtuemart_customs` AS C
  LEFT JOIN `xnpis_virtuemart_product_customfields` AS field
  ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
  Where `virtuemart_product_id` =2044
  and `field_type` = "Z"
  and is_cart_attribute = 0
  order by ordering
286. 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 `xnpis_virtuemart_customs` AS C
  LEFT JOIN `xnpis_virtuemart_product_customfields` AS field
  ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
  Where `virtuemart_product_id` =2044
  and `field_type` = "R"
  and is_cart_attribute = 0
  order by ordering
287. 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 `xnpis_virtuemart_customs` AS C
  LEFT JOIN `xnpis_virtuemart_product_customfields` AS field
  ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
  Where `virtuemart_product_id` =2044
  and `field_type` != "G"
  and `field_type` != "R"
  and `field_type` != "Z"
  and is_cart_attribute = 1
  group by virtuemart_custom_id
  ORDER BY field.`ordering`
288. SELECT virtuemart_product_id, product_name
  FROM `xnpis_virtuemart_products_el_gr` JOIN `xnpis_virtuemart_products` as C using (`virtuemart_product_id`)
  WHERE `product_parent_id` =2044
289. SELECT `vendor_currency`
  FROM xnpis_virtuemart_vendors
  WHERE `virtuemart_vendor_id`="1"
290. SELECT `slug`
  FROM `xnpis_virtuemart_products_el_gr`
  WHERE `virtuemart_product_id` = 2044
291. SELECT `xnpis_virtuemart_products_el_gr`.* ,`xnpis_virtuemart_products`.* ,`xnpis_virtuemart_ratings`.`rating` ,`xnpis_virtuemart_product_manufacturers`.`virtuemart_manufacturer_id` ,`xnpis_virtuemart_product_customfields`.`virtuemart_customfield_id`
  FROM `xnpis_virtuemart_products_el_gr` JOIN xnpis_virtuemart_products using (`virtuemart_product_id`)
  LEFT JOIN `xnpis_virtuemart_ratings`
  on `xnpis_virtuemart_ratings`.`virtuemart_product_id`=`xnpis_virtuemart_products_el_gr`.`virtuemart_product_id`
  LEFT JOIN `xnpis_virtuemart_product_manufacturers`
  on `xnpis_virtuemart_product_manufacturers`.`virtuemart_product_id`=`xnpis_virtuemart_products_el_gr`.`virtuemart_product_id`
  LEFT JOIN `xnpis_virtuemart_product_customfields`
  on `xnpis_virtuemart_product_customfields`.`virtuemart_product_id`=`xnpis_virtuemart_products_el_gr`.`virtuemart_product_id`
  WHERE xnpis_virtuemart_products_el_gr.`virtuemart_product_id` = "2047"
292. SELECT `virtuemart_media_id`
  FROM `xnpis_virtuemart_product_medias`
  WHERE `virtuemart_product_id` = "2047"
  ORDER BY `ordering`
293. SELECT `virtuemart_shoppergroup_id`
  FROM `xnpis_virtuemart_product_shoppergroups`
  WHERE `virtuemart_product_id` = "2047"
294. SELECT *
  FROM `xnpis_virtuemart_product_prices`
  WHERE `virtuemart_product_id` = "2047"
  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` <= "2019-12-15 05:53:36" )
  AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2019-12-15 05:53:36" ) )
  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) )
295. SELECT pc.`virtuemart_category_id`
  FROM `xnpis_virtuemart_product_categories` as pc
  WHERE pc.`virtuemart_product_id` = 2047
296. SELECT pc.`virtuemart_category_id`
  FROM `xnpis_virtuemart_product_categories` as pc
  LEFT JOIN `xnpis_virtuemart_categories` as c
  ON c.`virtuemart_category_id` = pc.`virtuemart_category_id`
  WHERE pc.`virtuemart_product_id` = 2047
  AND `published`=1
  ORDER BY `c`.`ordering` ASC
297. SELECT `ordering`,`id`
  FROM `xnpis_virtuemart_product_categories`
  WHERE `virtuemart_product_id` = "2047"
  and `virtuemart_category_id`= "123"
298. SELECT `xnpis_virtuemart_categories_el_gr`.* ,`xnpis_virtuemart_categories`.*
  FROM `xnpis_virtuemart_categories_el_gr` JOIN xnpis_virtuemart_categories using (`virtuemart_category_id`)
  WHERE xnpis_virtuemart_categories_el_gr.`virtuemart_category_id` = "123"
299. 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 `xnpis_virtuemart_customs` AS C
  LEFT JOIN `xnpis_virtuemart_product_customfields` AS field
  ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
  Where `virtuemart_product_id` =2047
  and `field_type` != "G"
  and `field_type` != "R"
  and `field_type` != "Z"
  and is_cart_attribute = 0
  order by field.`ordering`,virtuemart_custom_id
300. 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 `xnpis_virtuemart_customs` AS C
  LEFT JOIN `xnpis_virtuemart_product_customfields` AS field
  ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
  Where `virtuemart_product_id` =2047
  and `field_type` = "Z"
  and is_cart_attribute = 0
  order by ordering
301. 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 `xnpis_virtuemart_customs` AS C
  LEFT JOIN `xnpis_virtuemart_product_customfields` AS field
  ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
  Where `virtuemart_product_id` =2047
  and `field_type` = "R"
  and is_cart_attribute = 0
  order by ordering
302. 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 `xnpis_virtuemart_customs` AS C
  LEFT JOIN `xnpis_virtuemart_product_customfields` AS field
  ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
  Where `virtuemart_product_id` =2047
  and `field_type` != "G"
  and `field_type` != "R"
  and `field_type` != "Z"
  and is_cart_attribute = 1
  group by virtuemart_custom_id
  ORDER BY field.`ordering`
303. SELECT virtuemart_product_id, product_name
  FROM `xnpis_virtuemart_products_el_gr` JOIN `xnpis_virtuemart_products` as C using (`virtuemart_product_id`)
  WHERE `product_parent_id` =2047
304. SELECT `vendor_currency`
  FROM xnpis_virtuemart_vendors
  WHERE `virtuemart_vendor_id`="1"
305. SELECT `slug`
  FROM `xnpis_virtuemart_products_el_gr`
  WHERE `virtuemart_product_id` = 2047
306. SELECT `xnpis_virtuemart_products_el_gr`.* ,`xnpis_virtuemart_products`.* ,`xnpis_virtuemart_ratings`.`rating` ,`xnpis_virtuemart_product_manufacturers`.`virtuemart_manufacturer_id` ,`xnpis_virtuemart_product_customfields`.`virtuemart_customfield_id`
  FROM `xnpis_virtuemart_products_el_gr` JOIN xnpis_virtuemart_products using (`virtuemart_product_id`)
  LEFT JOIN `xnpis_virtuemart_ratings`
  on `xnpis_virtuemart_ratings`.`virtuemart_product_id`=`xnpis_virtuemart_products_el_gr`.`virtuemart_product_id`
  LEFT JOIN `xnpis_virtuemart_product_manufacturers`
  on `xnpis_virtuemart_product_manufacturers`.`virtuemart_product_id`=`xnpis_virtuemart_products_el_gr`.`virtuemart_product_id`
  LEFT JOIN `xnpis_virtuemart_product_customfields`
  on `xnpis_virtuemart_product_customfields`.`virtuemart_product_id`=`xnpis_virtuemart_products_el_gr`.`virtuemart_product_id`
  WHERE xnpis_virtuemart_products_el_gr.`virtuemart_product_id` = "2050"
307. SELECT `virtuemart_media_id`
  FROM `xnpis_virtuemart_product_medias`
  WHERE `virtuemart_product_id` = "2050"
  ORDER BY `ordering`
308. SELECT `virtuemart_shoppergroup_id`
  FROM `xnpis_virtuemart_product_shoppergroups`
  WHERE `virtuemart_product_id` = "2050"
309. SELECT *
  FROM `xnpis_virtuemart_product_prices`
  WHERE `virtuemart_product_id` = "2050"
  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` <= "2019-12-15 05:53:36" )
  AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2019-12-15 05:53:36" ) )
  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) )
310. SELECT pc.`virtuemart_category_id`
  FROM `xnpis_virtuemart_product_categories` as pc
  WHERE pc.`virtuemart_product_id` = 2050
311. SELECT pc.`virtuemart_category_id`
  FROM `xnpis_virtuemart_product_categories` as pc
  LEFT JOIN `xnpis_virtuemart_categories` as c
  ON c.`virtuemart_category_id` = pc.`virtuemart_category_id`
  WHERE pc.`virtuemart_product_id` = 2050
  AND `published`=1
  ORDER BY `c`.`ordering` ASC
312. SELECT `ordering`,`id`
  FROM `xnpis_virtuemart_product_categories`
  WHERE `virtuemart_product_id` = "2050"
  and `virtuemart_category_id`= "123"
313. SELECT `xnpis_virtuemart_categories_el_gr`.* ,`xnpis_virtuemart_categories`.*
  FROM `xnpis_virtuemart_categories_el_gr` JOIN xnpis_virtuemart_categories using (`virtuemart_category_id`)
  WHERE xnpis_virtuemart_categories_el_gr.`virtuemart_category_id` = "123"
314. 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 `xnpis_virtuemart_customs` AS C
  LEFT JOIN `xnpis_virtuemart_product_customfields` AS field
  ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
  Where `virtuemart_product_id` =2050
  and `field_type` != "G"
  and `field_type` != "R"
  and `field_type` != "Z"
  and is_cart_attribute = 0
  order by field.`ordering`,virtuemart_custom_id
315. 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 `xnpis_virtuemart_customs` AS C
  LEFT JOIN `xnpis_virtuemart_product_customfields` AS field
  ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
  Where `virtuemart_product_id` =2050
  and `field_type` = "Z"
  and is_cart_attribute = 0
  order by ordering
316. 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 `xnpis_virtuemart_customs` AS C
  LEFT JOIN `xnpis_virtuemart_product_customfields` AS field
  ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
  Where `virtuemart_product_id` =2050
  and `field_type` = "R"
  and is_cart_attribute = 0
  order by ordering
317. 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 `xnpis_virtuemart_customs` AS C
  LEFT JOIN `xnpis_virtuemart_product_customfields` AS field
  ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
  Where `virtuemart_product_id` =2050
  and `field_type` != "G"
  and `field_type` != "R"
  and `field_type` != "Z"
  and is_cart_attribute = 1
  group by virtuemart_custom_id
  ORDER BY field.`ordering`
318. SELECT virtuemart_product_id, product_name
  FROM `xnpis_virtuemart_products_el_gr` JOIN `xnpis_virtuemart_products` as C using (`virtuemart_product_id`)
  WHERE `product_parent_id` =2050
319. SELECT `vendor_currency`
  FROM xnpis_virtuemart_vendors
  WHERE `virtuemart_vendor_id`="1"
320. SELECT `slug`
  FROM `xnpis_virtuemart_products_el_gr`
  WHERE `virtuemart_product_id` = 2050
321. SELECT `xnpis_virtuemart_products_el_gr`.* ,`xnpis_virtuemart_products`.* ,`xnpis_virtuemart_ratings`.`rating` ,`xnpis_virtuemart_product_manufacturers`.`virtuemart_manufacturer_id` ,`xnpis_virtuemart_product_customfields`.`virtuemart_customfield_id`
  FROM `xnpis_virtuemart_products_el_gr` JOIN xnpis_virtuemart_products using (`virtuemart_product_id`)
  LEFT JOIN `xnpis_virtuemart_ratings`
  on `xnpis_virtuemart_ratings`.`virtuemart_product_id`=`xnpis_virtuemart_products_el_gr`.`virtuemart_product_id`
  LEFT JOIN `xnpis_virtuemart_product_manufacturers`
  on `xnpis_virtuemart_product_manufacturers`.`virtuemart_product_id`=`xnpis_virtuemart_products_el_gr`.`virtuemart_product_id`
  LEFT JOIN `xnpis_virtuemart_product_customfields`
  on `xnpis_virtuemart_product_customfields`.`virtuemart_product_id`=`xnpis_virtuemart_products_el_gr`.`virtuemart_product_id`
  WHERE xnpis_virtuemart_products_el_gr.`virtuemart_product_id` = "2051"
322. SELECT `virtuemart_media_id`
  FROM `xnpis_virtuemart_product_medias`
  WHERE `virtuemart_product_id` = "2051"
  ORDER BY `ordering`
323. SELECT `virtuemart_shoppergroup_id`
  FROM `xnpis_virtuemart_product_shoppergroups`
  WHERE `virtuemart_product_id` = "2051"
324. SELECT *
  FROM `xnpis_virtuemart_product_prices`
  WHERE `virtuemart_product_id` = "2051"
  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` <= "2019-12-15 05:53:36" )
  AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2019-12-15 05:53:36" ) )
  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) )
325. SELECT pc.`virtuemart_category_id`
  FROM `xnpis_virtuemart_product_categories` as pc
  WHERE pc.`virtuemart_product_id` = 2051
326. SELECT pc.`virtuemart_category_id`
  FROM `xnpis_virtuemart_product_categories` as pc
  LEFT JOIN `xnpis_virtuemart_categories` as c
  ON c.`virtuemart_category_id` = pc.`virtuemart_category_id`
  WHERE pc.`virtuemart_product_id` = 2051
  AND `published`=1
  ORDER BY `c`.`ordering` ASC
327. SELECT `ordering`,`id`
  FROM `xnpis_virtuemart_product_categories`
  WHERE `virtuemart_product_id` = "2051"
  and `virtuemart_category_id`= "123"
328. SELECT `xnpis_virtuemart_categories_el_gr`.* ,`xnpis_virtuemart_categories`.*
  FROM `xnpis_virtuemart_categories_el_gr` JOIN xnpis_virtuemart_categories using (`virtuemart_category_id`)
  WHERE xnpis_virtuemart_categories_el_gr.`virtuemart_category_id` = "123"
329. 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 `xnpis_virtuemart_customs` AS C
  LEFT JOIN `xnpis_virtuemart_product_customfields` AS field
  ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
  Where `virtuemart_product_id` =2051
  and `field_type` != "G"
  and `field_type` != "R"
  and `field_type` != "Z"
  and is_cart_attribute = 0
  order by field.`ordering`,virtuemart_custom_id
330. 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 `xnpis_virtuemart_customs` AS C
  LEFT JOIN `xnpis_virtuemart_product_customfields` AS field
  ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
  Where `virtuemart_product_id` =2051
  and `field_type` = "Z"
  and is_cart_attribute = 0
  order by ordering
331. 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 `xnpis_virtuemart_customs` AS C
  LEFT JOIN `xnpis_virtuemart_product_customfields` AS field
  ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
  Where `virtuemart_product_id` =2051
  and `field_type` = "R"
  and is_cart_attribute = 0
  order by ordering
332. 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 `xnpis_virtuemart_customs` AS C
  LEFT JOIN `xnpis_virtuemart_product_customfields` AS field
  ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
  Where `virtuemart_product_id` =2051
  and `field_type` != "G"
  and `field_type` != "R"
  and `field_type` != "Z"
  and is_cart_attribute = 1
  group by virtuemart_custom_id
  ORDER BY field.`ordering`
333. SELECT virtuemart_product_id, product_name
  FROM `xnpis_virtuemart_products_el_gr` JOIN `xnpis_virtuemart_products` as C using (`virtuemart_product_id`)
  WHERE `product_parent_id` =2051
334. SELECT `vendor_currency`
  FROM xnpis_virtuemart_vendors
  WHERE `virtuemart_vendor_id`="1"
335. SELECT `slug`
  FROM `xnpis_virtuemart_products_el_gr`
  WHERE `virtuemart_product_id` = 2051
336. SELECT `xnpis_virtuemart_products_el_gr`.* ,`xnpis_virtuemart_products`.* ,`xnpis_virtuemart_ratings`.`rating` ,`xnpis_virtuemart_product_manufacturers`.`virtuemart_manufacturer_id` ,`xnpis_virtuemart_product_customfields`.`virtuemart_customfield_id`
  FROM `xnpis_virtuemart_products_el_gr` JOIN xnpis_virtuemart_products using (`virtuemart_product_id`)
  LEFT JOIN `xnpis_virtuemart_ratings`
  on `xnpis_virtuemart_ratings`.`virtuemart_product_id`=`xnpis_virtuemart_products_el_gr`.`virtuemart_product_id`
  LEFT JOIN `xnpis_virtuemart_product_manufacturers`
  on `xnpis_virtuemart_product_manufacturers`.`virtuemart_product_id`=`xnpis_virtuemart_products_el_gr`.`virtuemart_product_id`
  LEFT JOIN `xnpis_virtuemart_product_customfields`
  on `xnpis_virtuemart_product_customfields`.`virtuemart_product_id`=`xnpis_virtuemart_products_el_gr`.`virtuemart_product_id`
  WHERE xnpis_virtuemart_products_el_gr.`virtuemart_product_id` = "2052"
337. SELECT `virtuemart_media_id`
  FROM `xnpis_virtuemart_product_medias`
  WHERE `virtuemart_product_id` = "2052"
  ORDER BY `ordering`
338. SELECT `virtuemart_shoppergroup_id`
  FROM `xnpis_virtuemart_product_shoppergroups`
  WHERE `virtuemart_product_id` = "2052"
339. SELECT *
  FROM `xnpis_virtuemart_product_prices`
  WHERE `virtuemart_product_id` = "2052"
  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` <= "2019-12-15 05:53:36" )
  AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2019-12-15 05:53:36" ) )
  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) )
340. SELECT pc.`virtuemart_category_id`
  FROM `xnpis_virtuemart_product_categories` as pc
  WHERE pc.`virtuemart_product_id` = 2052
341. SELECT pc.`virtuemart_category_id`
  FROM `xnpis_virtuemart_product_categories` as pc
  LEFT JOIN `xnpis_virtuemart_categories` as c
  ON c.`virtuemart_category_id` = pc.`virtuemart_category_id`
  WHERE pc.`virtuemart_product_id` = 2052
  AND `published`=1
  ORDER BY `c`.`ordering` ASC
342. SELECT `ordering`,`id`
  FROM `xnpis_virtuemart_product_categories`
  WHERE `virtuemart_product_id` = "2052"
  and `virtuemart_category_id`= "123"
343. SELECT `xnpis_virtuemart_categories_el_gr`.* ,`xnpis_virtuemart_categories`.*
  FROM `xnpis_virtuemart_categories_el_gr` JOIN xnpis_virtuemart_categories using (`virtuemart_category_id`)
  WHERE xnpis_virtuemart_categories_el_gr.`virtuemart_category_id` = "123"
344. 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 `xnpis_virtuemart_customs` AS C
  LEFT JOIN `xnpis_virtuemart_product_customfields` AS field
  ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
  Where `virtuemart_product_id` =2052
  and `field_type` != "G"
  and `field_type` != "R"
  and `field_type` != "Z"
  and is_cart_attribute = 0
  order by field.`ordering`,virtuemart_custom_id
345. 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 `xnpis_virtuemart_customs` AS C
  LEFT JOIN `xnpis_virtuemart_product_customfields` AS field
  ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
  Where `virtuemart_product_id` =2052
  and `field_type` = "Z"
  and is_cart_attribute = 0
  order by ordering
346. 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 `xnpis_virtuemart_customs` AS C
  LEFT JOIN `xnpis_virtuemart_product_customfields` AS field
  ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
  Where `virtuemart_product_id` =2052
  and `field_type` = "R"
  and is_cart_attribute = 0
  order by ordering
347. 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 `xnpis_virtuemart_customs` AS C
  LEFT JOIN `xnpis_virtuemart_product_customfields` AS field
  ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
  Where `virtuemart_product_id` =2052
  and `field_type` != "G"
  and `field_type` != "R"
  and `field_type` != "Z"
  and is_cart_attribute = 1
  group by virtuemart_custom_id
  ORDER BY field.`ordering`
348. SELECT virtuemart_product_id, product_name
  FROM `xnpis_virtuemart_products_el_gr` JOIN `xnpis_virtuemart_products` as C using (`virtuemart_product_id`)
  WHERE `product_parent_id` =2052
349. SELECT `vendor_currency`
  FROM xnpis_virtuemart_vendors
  WHERE `virtuemart_vendor_id`="1"
350. SELECT `slug`
  FROM `xnpis_virtuemart_products_el_gr`
  WHERE `virtuemart_product_id` = 2052
351. SELECT `xnpis_virtuemart_products_el_gr`.* ,`xnpis_virtuemart_products`.* ,`xnpis_virtuemart_ratings`.`rating` ,`xnpis_virtuemart_product_manufacturers`.`virtuemart_manufacturer_id` ,`xnpis_virtuemart_product_customfields`.`virtuemart_customfield_id`
  FROM `xnpis_virtuemart_products_el_gr` JOIN xnpis_virtuemart_products using (`virtuemart_product_id`)
  LEFT JOIN `xnpis_virtuemart_ratings`
  on `xnpis_virtuemart_ratings`.`virtuemart_product_id`=`xnpis_virtuemart_products_el_gr`.`virtuemart_product_id`
  LEFT JOIN `xnpis_virtuemart_product_manufacturers`
  on `xnpis_virtuemart_product_manufacturers`.`virtuemart_product_id`=`xnpis_virtuemart_products_el_gr`.`virtuemart_product_id`
  LEFT JOIN `xnpis_virtuemart_product_customfields`
  on `xnpis_virtuemart_product_customfields`.`virtuemart_product_id`=`xnpis_virtuemart_products_el_gr`.`virtuemart_product_id`
  WHERE xnpis_virtuemart_products_el_gr.`virtuemart_product_id` = "614"
352. SELECT `virtuemart_media_id`
  FROM `xnpis_virtuemart_product_medias`
  WHERE `virtuemart_product_id` = "614"
  ORDER BY `ordering`
353. SELECT `virtuemart_shoppergroup_id`
  FROM `xnpis_virtuemart_product_shoppergroups`
  WHERE `virtuemart_product_id` = "614"
354. SELECT *
  FROM `xnpis_virtuemart_product_prices`
  WHERE `virtuemart_product_id` = "614"
  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` <= "2019-12-15 05:53:36" )
  AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2019-12-15 05:53:36" ) )
  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) )
355. SELECT pc.`virtuemart_category_id`
  FROM `xnpis_virtuemart_product_categories` as pc
  WHERE pc.`virtuemart_product_id` = 614
356. SELECT pc.`virtuemart_category_id`
  FROM `xnpis_virtuemart_product_categories` as pc
  LEFT JOIN `xnpis_virtuemart_categories` as c
  ON c.`virtuemart_category_id` = pc.`virtuemart_category_id`
  WHERE pc.`virtuemart_product_id` = 614
  AND `published`=1
  ORDER BY `c`.`ordering` ASC
357. SELECT `ordering`,`id`
  FROM `xnpis_virtuemart_product_categories`
  WHERE `virtuemart_product_id` = "614"
  and `virtuemart_category_id`= "123"
358. SELECT `xnpis_virtuemart_categories_el_gr`.* ,`xnpis_virtuemart_categories`.*
  FROM `xnpis_virtuemart_categories_el_gr` JOIN xnpis_virtuemart_categories using (`virtuemart_category_id`)
  WHERE xnpis_virtuemart_categories_el_gr.`virtuemart_category_id` = "123"
359. 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 `xnpis_virtuemart_customs` AS C
  LEFT JOIN `xnpis_virtuemart_product_customfields` AS field
  ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
  Where `virtuemart_product_id` =614
  and `field_type` != "G"
  and `field_type` != "R"
  and `field_type` != "Z"
  and is_cart_attribute = 0
  order by field.`ordering`,virtuemart_custom_id
360. 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 `xnpis_virtuemart_customs` AS C
  LEFT JOIN `xnpis_virtuemart_product_customfields` AS field
  ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
  Where `virtuemart_product_id` =614
  and `field_type` = "Z"
  and is_cart_attribute = 0
  order by ordering
361. 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 `xnpis_virtuemart_customs` AS C
  LEFT JOIN `xnpis_virtuemart_product_customfields` AS field
  ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
  Where `virtuemart_product_id` =614
  and `field_type` = "R"
  and is_cart_attribute = 0
  order by ordering
362. 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 `xnpis_virtuemart_customs` AS C
  LEFT JOIN `xnpis_virtuemart_product_customfields` AS field
  ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
  Where `virtuemart_product_id` =614
  and `field_type` != "G"
  and `field_type` != "R"
  and `field_type` != "Z"
  and is_cart_attribute = 1
  group by virtuemart_custom_id
  ORDER BY field.`ordering`
363. SELECT virtuemart_product_id, product_name
  FROM `xnpis_virtuemart_products_el_gr` JOIN `xnpis_virtuemart_products` as C using (`virtuemart_product_id`)
  WHERE `product_parent_id` =614
364. SELECT `vendor_currency`
  FROM xnpis_virtuemart_vendors
  WHERE `virtuemart_vendor_id`="1"
365. SELECT `slug`
  FROM `xnpis_virtuemart_products_el_gr`
  WHERE `virtuemart_product_id` = 614
366. SELECT `xnpis_virtuemart_products_el_gr`.* ,`xnpis_virtuemart_products`.* ,`xnpis_virtuemart_ratings`.`rating` ,`xnpis_virtuemart_product_manufacturers`.`virtuemart_manufacturer_id` ,`xnpis_virtuemart_product_customfields`.`virtuemart_customfield_id`
  FROM `xnpis_virtuemart_products_el_gr` JOIN xnpis_virtuemart_products using (`virtuemart_product_id`)
  LEFT JOIN `xnpis_virtuemart_ratings`
  on `xnpis_virtuemart_ratings`.`virtuemart_product_id`=`xnpis_virtuemart_products_el_gr`.`virtuemart_product_id`
  LEFT JOIN `xnpis_virtuemart_product_manufacturers`
  on `xnpis_virtuemart_product_manufacturers`.`virtuemart_product_id`=`xnpis_virtuemart_products_el_gr`.`virtuemart_product_id`
  LEFT JOIN `xnpis_virtuemart_product_customfields`
  on `xnpis_virtuemart_product_customfields`.`virtuemart_product_id`=`xnpis_virtuemart_products_el_gr`.`virtuemart_product_id`
  WHERE xnpis_virtuemart_products_el_gr.`virtuemart_product_id` = "2079"
367. SELECT `virtuemart_media_id`
  FROM `xnpis_virtuemart_product_medias`
  WHERE `virtuemart_product_id` = "2079"
  ORDER BY `ordering`
368. SELECT `virtuemart_shoppergroup_id`
  FROM `xnpis_virtuemart_product_shoppergroups`
  WHERE `virtuemart_product_id` = "2079"
369. SELECT *
  FROM `xnpis_virtuemart_product_prices`
  WHERE `virtuemart_product_id` = "2079"
  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` <= "2019-12-15 05:53:36" )
  AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2019-12-15 05:53:36" ) )
  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) )
370. SELECT pc.`virtuemart_category_id`
  FROM `xnpis_virtuemart_product_categories` as pc
  WHERE pc.`virtuemart_product_id` = 2079
371. SELECT pc.`virtuemart_category_id`
  FROM `xnpis_virtuemart_product_categories` as pc
  LEFT JOIN `xnpis_virtuemart_categories` as c
  ON c.`virtuemart_category_id` = pc.`virtuemart_category_id`
  WHERE pc.`virtuemart_product_id` = 2079
  AND `published`=1
  ORDER BY `c`.`ordering` ASC
372. SELECT `ordering`,`id`
  FROM `xnpis_virtuemart_product_categories`
  WHERE `virtuemart_product_id` = "2079"
  and `virtuemart_category_id`= "123"
373. SELECT `xnpis_virtuemart_categories_el_gr`.* ,`xnpis_virtuemart_categories`.*
  FROM `xnpis_virtuemart_categories_el_gr` JOIN xnpis_virtuemart_categories using (`virtuemart_category_id`)
  WHERE xnpis_virtuemart_categories_el_gr.`virtuemart_category_id` = "123"
374. 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 `xnpis_virtuemart_customs` AS C
  LEFT JOIN `xnpis_virtuemart_product_customfields` AS field
  ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
  Where `virtuemart_product_id` =2079
  and `field_type` != "G"
  and `field_type` != "R"
  and `field_type` != "Z"
  and is_cart_attribute = 0
  order by field.`ordering`,virtuemart_custom_id
375. 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 `xnpis_virtuemart_customs` AS C
  LEFT JOIN `xnpis_virtuemart_product_customfields` AS field
  ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
  Where `virtuemart_product_id` =2079
  and `field_type` = "Z"
  and is_cart_attribute = 0
  order by ordering
376. 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 `xnpis_virtuemart_customs` AS C
  LEFT JOIN `xnpis_virtuemart_product_customfields` AS field
  ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
  Where `virtuemart_product_id` =2079
  and `field_type` = "R"
  and is_cart_attribute = 0
  order by ordering
377. 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 `xnpis_virtuemart_customs` AS C
  LEFT JOIN `xnpis_virtuemart_product_customfields` AS field
  ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
  Where `virtuemart_product_id` =2079
  and `field_type` != "G"
  and `field_type` != "R"
  and `field_type` != "Z"
  and is_cart_attribute = 1
  group by virtuemart_custom_id
  ORDER BY field.`ordering`
378. SELECT virtuemart_product_id, product_name
  FROM `xnpis_virtuemart_products_el_gr` JOIN `xnpis_virtuemart_products` as C using (`virtuemart_product_id`)
  WHERE `product_parent_id` =2079
379. SELECT `vendor_currency`
  FROM xnpis_virtuemart_vendors
  WHERE `virtuemart_vendor_id`="1"
380. SELECT `slug`
  FROM `xnpis_virtuemart_products_el_gr`
  WHERE `virtuemart_product_id` = 2079
381. SELECT `xnpis_virtuemart_products_el_gr`.* ,`xnpis_virtuemart_products`.* ,`xnpis_virtuemart_ratings`.`rating` ,`xnpis_virtuemart_product_manufacturers`.`virtuemart_manufacturer_id` ,`xnpis_virtuemart_product_customfields`.`virtuemart_customfield_id`
  FROM `xnpis_virtuemart_products_el_gr` JOIN xnpis_virtuemart_products using (`virtuemart_product_id`)
  LEFT JOIN `xnpis_virtuemart_ratings`
  on `xnpis_virtuemart_ratings`.`virtuemart_product_id`=`xnpis_virtuemart_products_el_gr`.`virtuemart_product_id`
  LEFT JOIN `xnpis_virtuemart_product_manufacturers`
  on `xnpis_virtuemart_product_manufacturers`.`virtuemart_product_id`=`xnpis_virtuemart_products_el_gr`.`virtuemart_product_id`
  LEFT JOIN `xnpis_virtuemart_product_customfields`
  on `xnpis_virtuemart_product_customfields`.`virtuemart_product_id`=`xnpis_virtuemart_products_el_gr`.`virtuemart_product_id`
  WHERE xnpis_virtuemart_products_el_gr.`virtuemart_product_id` = "2037"
382. SELECT `virtuemart_media_id`
  FROM `xnpis_virtuemart_product_medias`
  WHERE `virtuemart_product_id` = "2037"
  ORDER BY `ordering`
383. SELECT `virtuemart_shoppergroup_id`
  FROM `xnpis_virtuemart_product_shoppergroups`
  WHERE `virtuemart_product_id` = "2037"
384. SELECT *
  FROM `xnpis_virtuemart_product_prices`
  WHERE `virtuemart_product_id` = "2037"
  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` <= "2019-12-15 05:53:36" )
  AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2019-12-15 05:53:36" ) )
  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) )
385. SELECT pc.`virtuemart_category_id`
  FROM `xnpis_virtuemart_product_categories` as pc
  WHERE pc.`virtuemart_product_id` = 2037
386. SELECT pc.`virtuemart_category_id`
  FROM `xnpis_virtuemart_product_categories` as pc
  LEFT JOIN `xnpis_virtuemart_categories` as c
  ON c.`virtuemart_category_id` = pc.`virtuemart_category_id`
  WHERE pc.`virtuemart_product_id` = 2037
  AND `published`=1
  ORDER BY `c`.`ordering` ASC
387. SELECT `ordering`,`id`
  FROM `xnpis_virtuemart_product_categories`
  WHERE `virtuemart_product_id` = "2037"
  and `virtuemart_category_id`= "123"
388. SELECT `xnpis_virtuemart_categories_el_gr`.* ,`xnpis_virtuemart_categories`.*
  FROM `xnpis_virtuemart_categories_el_gr` JOIN xnpis_virtuemart_categories using (`virtuemart_category_id`)
  WHERE xnpis_virtuemart_categories_el_gr.`virtuemart_category_id` = "123"
389. 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 `xnpis_virtuemart_customs` AS C
  LEFT JOIN `xnpis_virtuemart_product_customfields` AS field
  ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
  Where `virtuemart_product_id` =2037
  and `field_type` != "G"
  and `field_type` != "R"
  and `field_type` != "Z"
  and is_cart_attribute = 0
  order by field.`ordering`,virtuemart_custom_id
390. 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 `xnpis_virtuemart_customs` AS C
  LEFT JOIN `xnpis_virtuemart_product_customfields` AS field
  ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
  Where `virtuemart_product_id` =2037
  and `field_type` = "Z"
  and is_cart_attribute = 0
  order by ordering
391. 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 `xnpis_virtuemart_customs` AS C
  LEFT JOIN `xnpis_virtuemart_product_customfields` AS field
  ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
  Where `virtuemart_product_id` =2037
  and `field_type` = "R"
  and is_cart_attribute = 0
  order by ordering
392. 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 `xnpis_virtuemart_customs` AS C
  LEFT JOIN `xnpis_virtuemart_product_customfields` AS field
  ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
  Where `virtuemart_product_id` =2037
  and `field_type` != "G"
  and `field_type` != "R"
  and `field_type` != "Z"
  and is_cart_attribute = 1
  group by virtuemart_custom_id
  ORDER BY field.`ordering`
393. SELECT virtuemart_product_id, product_name
  FROM `xnpis_virtuemart_products_el_gr` JOIN `xnpis_virtuemart_products` as C using (`virtuemart_product_id`)
  WHERE `product_parent_id` =2037
394. SELECT `vendor_currency`
  FROM xnpis_virtuemart_vendors
  WHERE `virtuemart_vendor_id`="1"
395. SELECT `slug`
  FROM `xnpis_virtuemart_products_el_gr`
  WHERE `virtuemart_product_id` = 2037
396. SELECT `xnpis_virtuemart_products_el_gr`.* ,`xnpis_virtuemart_products`.* ,`xnpis_virtuemart_ratings`.`rating` ,`xnpis_virtuemart_product_manufacturers`.`virtuemart_manufacturer_id` ,`xnpis_virtuemart_product_customfields`.`virtuemart_customfield_id`
  FROM `xnpis_virtuemart_products_el_gr` JOIN xnpis_virtuemart_products using (`virtuemart_product_id`)
  LEFT JOIN `xnpis_virtuemart_ratings`
  on `xnpis_virtuemart_ratings`.`virtuemart_product_id`=`xnpis_virtuemart_products_el_gr`.`virtuemart_product_id`
  LEFT JOIN `xnpis_virtuemart_product_manufacturers`
  on `xnpis_virtuemart_product_manufacturers`.`virtuemart_product_id`=`xnpis_virtuemart_products_el_gr`.`virtuemart_product_id`
  LEFT JOIN `xnpis_virtuemart_product_customfields`
  on `xnpis_virtuemart_product_customfields`.`virtuemart_product_id`=`xnpis_virtuemart_products_el_gr`.`virtuemart_product_id`
  WHERE xnpis_virtuemart_products_el_gr.`virtuemart_product_id` = "1655"
397. SELECT `virtuemart_media_id`
  FROM `xnpis_virtuemart_product_medias`
  WHERE `virtuemart_product_id` = "1655"
  ORDER BY `ordering`
398. SELECT `virtuemart_shoppergroup_id`
  FROM `xnpis_virtuemart_product_shoppergroups`
  WHERE `virtuemart_product_id` = "1655"
399. SELECT *
  FROM `xnpis_virtuemart_product_prices`
  WHERE `virtuemart_product_id` = "1655"
  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` <= "2019-12-15 05:53:36" )
  AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2019-12-15 05:53:36" ) )
  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) )
400. SELECT pc.`virtuemart_category_id`
  FROM `xnpis_virtuemart_product_categories` as pc
  WHERE pc.`virtuemart_product_id` = 1655
401. SELECT pc.`virtuemart_category_id`
  FROM `xnpis_virtuemart_product_categories` as pc
  LEFT JOIN `xnpis_virtuemart_categories` as c
  ON c.`virtuemart_category_id` = pc.`virtuemart_category_id`
  WHERE pc.`virtuemart_product_id` = 1655
  AND `published`=1
  ORDER BY `c`.`ordering` ASC
402. SELECT `ordering`,`id`
  FROM `xnpis_virtuemart_product_categories`
  WHERE `virtuemart_product_id` = "1655"
  and `virtuemart_category_id`= "123"
403. SELECT `xnpis_virtuemart_categories_el_gr`.* ,`xnpis_virtuemart_categories`.*
  FROM `xnpis_virtuemart_categories_el_gr` JOIN xnpis_virtuemart_categories using (`virtuemart_category_id`)
  WHERE xnpis_virtuemart_categories_el_gr.`virtuemart_category_id` = "123"
404. SELECT `vendor_currency`
  FROM xnpis_virtuemart_vendors
  WHERE `virtuemart_vendor_id`="1"
405. SELECT `slug`
  FROM `xnpis_virtuemart_products_el_gr`
  WHERE `virtuemart_product_id` = 1655
406. SELECT `xnpis_virtuemart_products_el_gr`.* ,`xnpis_virtuemart_products`.* ,`xnpis_virtuemart_ratings`.`rating` ,`xnpis_virtuemart_product_manufacturers`.`virtuemart_manufacturer_id` ,`xnpis_virtuemart_product_customfields`.`virtuemart_customfield_id`
  FROM `xnpis_virtuemart_products_el_gr` JOIN xnpis_virtuemart_products using (`virtuemart_product_id`)
  LEFT JOIN `xnpis_virtuemart_ratings`
  on `xnpis_virtuemart_ratings`.`virtuemart_product_id`=`xnpis_virtuemart_products_el_gr`.`virtuemart_product_id`
  LEFT JOIN `xnpis_virtuemart_product_manufacturers`
  on `xnpis_virtuemart_product_manufacturers`.`virtuemart_product_id`=`xnpis_virtuemart_products_el_gr`.`virtuemart_product_id`
  LEFT JOIN `xnpis_virtuemart_product_customfields`
  on `xnpis_virtuemart_product_customfields`.`virtuemart_product_id`=`xnpis_virtuemart_products_el_gr`.`virtuemart_product_id`
  WHERE xnpis_virtuemart_products_el_gr.`virtuemart_product_id` = "2036"
407. SELECT `virtuemart_media_id`
  FROM `xnpis_virtuemart_product_medias`
  WHERE `virtuemart_product_id` = "2036"
  ORDER BY `ordering`
408. SELECT `virtuemart_shoppergroup_id`
  FROM `xnpis_virtuemart_product_shoppergroups`
  WHERE `virtuemart_product_id` = "2036"
409. SELECT *
  FROM `xnpis_virtuemart_product_prices`
  WHERE `virtuemart_product_id` = "2036"
  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` <= "2019-12-15 05:53:36" )
  AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2019-12-15 05:53:36" ) )
  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) )
410. SELECT pc.`virtuemart_category_id`
  FROM `xnpis_virtuemart_product_categories` as pc
  WHERE pc.`virtuemart_product_id` = 2036
411. SELECT pc.`virtuemart_category_id`
  FROM `xnpis_virtuemart_product_categories` as pc
  LEFT JOIN `xnpis_virtuemart_categories` as c
  ON c.`virtuemart_category_id` = pc.`virtuemart_category_id`
  WHERE pc.`virtuemart_product_id` = 2036
  AND `published`=1
  ORDER BY `c`.`ordering` ASC
412. SELECT `ordering`,`id`
  FROM `xnpis_virtuemart_product_categories`
  WHERE `virtuemart_product_id` = "2036"
  and `virtuemart_category_id`= "123"
413. SELECT `xnpis_virtuemart_categories_el_gr`.* ,`xnpis_virtuemart_categories`.*
  FROM `xnpis_virtuemart_categories_el_gr` JOIN xnpis_virtuemart_categories using (`virtuemart_category_id`)
  WHERE xnpis_virtuemart_categories_el_gr.`virtuemart_category_id` = "123"
414. 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 `xnpis_virtuemart_customs` AS C
  LEFT JOIN `xnpis_virtuemart_product_customfields` AS field
  ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
  Where `virtuemart_product_id` =2036
  and `field_type` != "G"
  and `field_type` != "R"
  and `field_type` != "Z"
  and is_cart_attribute = 0
  order by field.`ordering`,virtuemart_custom_id
415. 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 `xnpis_virtuemart_customs` AS C
  LEFT JOIN `xnpis_virtuemart_product_customfields` AS field
  ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
  Where `virtuemart_product_id` =2036
  and `field_type` = "Z"
  and is_cart_attribute = 0
  order by ordering
416. 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 `xnpis_virtuemart_customs` AS C
  LEFT JOIN `xnpis_virtuemart_product_customfields` AS field
  ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
  Where `virtuemart_product_id` =2036
  and `field_type` = "R"
  and is_cart_attribute = 0
  order by ordering
417. 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 `xnpis_virtuemart_customs` AS C
  LEFT JOIN `xnpis_virtuemart_product_customfields` AS field
  ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
  Where `virtuemart_product_id` =2036
  and `field_type` != "G"
  and `field_type` != "R"
  and `field_type` != "Z"
  and is_cart_attribute = 1
  group by virtuemart_custom_id
  ORDER BY field.`ordering`
418. SELECT virtuemart_product_id, product_name
  FROM `xnpis_virtuemart_products_el_gr` JOIN `xnpis_virtuemart_products` as C using (`virtuemart_product_id`)
  WHERE `product_parent_id` =2036
419. SELECT `vendor_currency`
  FROM xnpis_virtuemart_vendors
  WHERE `virtuemart_vendor_id`="1"
420. SELECT `slug`
  FROM `xnpis_virtuemart_products_el_gr`
  WHERE `virtuemart_product_id` = 2036
421. SELECT `xnpis_virtuemart_products_el_gr`.* ,`xnpis_virtuemart_products`.* ,`xnpis_virtuemart_ratings`.`rating` ,`xnpis_virtuemart_product_manufacturers`.`virtuemart_manufacturer_id` ,`xnpis_virtuemart_product_customfields`.`virtuemart_customfield_id`
  FROM `xnpis_virtuemart_products_el_gr` JOIN xnpis_virtuemart_products using (`virtuemart_product_id`)
  LEFT JOIN `xnpis_virtuemart_ratings`
  on `xnpis_virtuemart_ratings`.`virtuemart_product_id`=`xnpis_virtuemart_products_el_gr`.`virtuemart_product_id`
  LEFT JOIN `xnpis_virtuemart_product_manufacturers`
  on `xnpis_virtuemart_product_manufacturers`.`virtuemart_product_id`=`xnpis_virtuemart_products_el_gr`.`virtuemart_product_id`
  LEFT JOIN `xnpis_virtuemart_product_customfields`
  on `xnpis_virtuemart_product_customfields`.`virtuemart_product_id`=`xnpis_virtuemart_products_el_gr`.`virtuemart_product_id`
  WHERE xnpis_virtuemart_products_el_gr.`virtuemart_product_id` = "2035"
422. SELECT `virtuemart_media_id`
  FROM `xnpis_virtuemart_product_medias`
  WHERE `virtuemart_product_id` = "2035"
  ORDER BY `ordering`
423. SELECT `virtuemart_shoppergroup_id`
  FROM `xnpis_virtuemart_product_shoppergroups`
  WHERE `virtuemart_product_id` = "2035"
424. SELECT *
  FROM `xnpis_virtuemart_product_prices`
  WHERE `virtuemart_product_id` = "2035"
  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` <= "2019-12-15 05:53:36" )
  AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2019-12-15 05:53:36" ) )
  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) )
425. SELECT pc.`virtuemart_category_id`
  FROM `xnpis_virtuemart_product_categories` as pc
  WHERE pc.`virtuemart_product_id` = 2035
426. SELECT pc.`virtuemart_category_id`
  FROM `xnpis_virtuemart_product_categories` as pc
  LEFT JOIN `xnpis_virtuemart_categories` as c
  ON c.`virtuemart_category_id` = pc.`virtuemart_category_id`
  WHERE pc.`virtuemart_product_id` = 2035
  AND `published`=1
  ORDER BY `c`.`ordering` ASC
427. SELECT `ordering`,`id`
  FROM `xnpis_virtuemart_product_categories`
  WHERE `virtuemart_product_id` = "2035"
  and `virtuemart_category_id`= "123"
428. SELECT `xnpis_virtuemart_categories_el_gr`.* ,`xnpis_virtuemart_categories`.*
  FROM `xnpis_virtuemart_categories_el_gr` JOIN xnpis_virtuemart_categories using (`virtuemart_category_id`)
  WHERE xnpis_virtuemart_categories_el_gr.`virtuemart_category_id` = "123"
429. 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 `xnpis_virtuemart_customs` AS C
  LEFT JOIN `xnpis_virtuemart_product_customfields` AS field
  ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
  Where `virtuemart_product_id` =2035
  and `field_type` != "G"
  and `field_type` != "R"
  and `field_type` != "Z"
  and is_cart_attribute = 0
  order by field.`ordering`,virtuemart_custom_id
430. 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 `xnpis_virtuemart_customs` AS C
  LEFT JOIN `xnpis_virtuemart_product_customfields` AS field
  ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
  Where `virtuemart_product_id` =2035
  and `field_type` = "Z"
  and is_cart_attribute = 0
  order by ordering
431. 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 `xnpis_virtuemart_customs` AS C
  LEFT JOIN `xnpis_virtuemart_product_customfields` AS field
  ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
  Where `virtuemart_product_id` =2035
  and `field_type` = "R"
  and is_cart_attribute = 0
  order by ordering
432. 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 `xnpis_virtuemart_customs` AS C
  LEFT JOIN `xnpis_virtuemart_product_customfields` AS field
  ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
  Where `virtuemart_product_id` =2035
  and `field_type` != "G"
  and `field_type` != "R"
  and `field_type` != "Z"
  and is_cart_attribute = 1
  group by virtuemart_custom_id
  ORDER BY field.`ordering`
433. SELECT virtuemart_product_id, product_name
  FROM `xnpis_virtuemart_products_el_gr` JOIN `xnpis_virtuemart_products` as C using (`virtuemart_product_id`)
  WHERE `product_parent_id` =2035
434. SELECT `vendor_currency`
  FROM xnpis_virtuemart_vendors
  WHERE `virtuemart_vendor_id`="1"
435. SELECT `slug`
  FROM `xnpis_virtuemart_products_el_gr`
  WHERE `virtuemart_product_id` = 2035
436. SELECT `xnpis_virtuemart_medias`.*
  FROM `xnpis_virtuemart_medias`
  WHERE xnpis_virtuemart_medias.`virtuemart_media_id` = "1336"
437. SELECT `xnpis_virtuemart_medias`.*
  FROM `xnpis_virtuemart_medias`
  WHERE xnpis_virtuemart_medias.`virtuemart_media_id` = "709"
438. SELECT `xnpis_virtuemart_medias`.*
  FROM `xnpis_virtuemart_medias`
  WHERE xnpis_virtuemart_medias.`virtuemart_media_id` = "711"
439. SELECT `xnpis_virtuemart_medias`.*
  FROM `xnpis_virtuemart_medias`
  WHERE xnpis_virtuemart_medias.`virtuemart_media_id` = "723"
440. SELECT `xnpis_virtuemart_medias`.*
  FROM `xnpis_virtuemart_medias`
  WHERE xnpis_virtuemart_medias.`virtuemart_media_id` = "1315"
441. SELECT `xnpis_virtuemart_medias`.*
  FROM `xnpis_virtuemart_medias`
  WHERE xnpis_virtuemart_medias.`virtuemart_media_id` = "715"
442. SELECT `xnpis_virtuemart_medias`.*
  FROM `xnpis_virtuemart_medias`
  WHERE xnpis_virtuemart_medias.`virtuemart_media_id` = "2362"
443. SELECT `xnpis_virtuemart_medias`.*
  FROM `xnpis_virtuemart_medias`
  WHERE xnpis_virtuemart_medias.`virtuemart_media_id` = "2366"
444. SELECT `xnpis_virtuemart_medias`.*
  FROM `xnpis_virtuemart_medias`
  WHERE xnpis_virtuemart_medias.`virtuemart_media_id` = "2359"
445. SELECT `xnpis_virtuemart_medias`.*
  FROM `xnpis_virtuemart_medias`
  WHERE xnpis_virtuemart_medias.`virtuemart_media_id` = "1924"
446. SELECT `xnpis_virtuemart_medias`.*
  FROM `xnpis_virtuemart_medias`
  WHERE xnpis_virtuemart_medias.`virtuemart_media_id` = "2360"
447. SELECT `xnpis_virtuemart_medias`.*
  FROM `xnpis_virtuemart_medias`
  WHERE xnpis_virtuemart_medias.`virtuemart_media_id` = "2365"
448. SELECT `xnpis_virtuemart_medias`.*
  FROM `xnpis_virtuemart_medias`
  WHERE xnpis_virtuemart_medias.`virtuemart_media_id` = "1922"
449. SELECT `xnpis_virtuemart_medias`.*
  FROM `xnpis_virtuemart_medias`
  WHERE xnpis_virtuemart_medias.`virtuemart_media_id` = "1892"
450. SELECT `xnpis_virtuemart_medias`.*
  FROM `xnpis_virtuemart_medias`
  WHERE xnpis_virtuemart_medias.`virtuemart_media_id` = "1325"
451. SELECT `xnpis_virtuemart_medias`.*
  FROM `xnpis_virtuemart_medias`
  WHERE xnpis_virtuemart_medias.`virtuemart_media_id` = "2322"
452. SELECT `xnpis_virtuemart_medias`.*
  FROM `xnpis_virtuemart_medias`
  WHERE xnpis_virtuemart_medias.`virtuemart_media_id` = "722"
453. SELECT `xnpis_virtuemart_medias`.*
  FROM `xnpis_virtuemart_medias`
  WHERE xnpis_virtuemart_medias.`virtuemart_media_id` = "2367"
454. SELECT `xnpis_virtuemart_medias`.*
  FROM `xnpis_virtuemart_medias`
  WHERE xnpis_virtuemart_medias.`virtuemart_media_id` = "2320"
455. SELECT `xnpis_virtuemart_medias`.*
  FROM `xnpis_virtuemart_medias`
  WHERE xnpis_virtuemart_medias.`virtuemart_media_id` = "2316"
456. SELECT `xnpis_virtuemart_medias`.*
  FROM `xnpis_virtuemart_medias`
  WHERE xnpis_virtuemart_medias.`virtuemart_media_id` = "2319"
457. SELECT `xnpis_virtuemart_medias`.*
  FROM `xnpis_virtuemart_medias`
  WHERE xnpis_virtuemart_medias.`virtuemart_media_id` = "2323"
458. SELECT `xnpis_virtuemart_medias`.*
  FROM `xnpis_virtuemart_medias`
  WHERE xnpis_virtuemart_medias.`virtuemart_media_id` = "2324"
459. SELECT `xnpis_virtuemart_medias`.*
  FROM `xnpis_virtuemart_medias`
  WHERE xnpis_virtuemart_medias.`virtuemart_media_id` = "2325"
460. SELECT `xnpis_virtuemart_medias`.*
  FROM `xnpis_virtuemart_medias`
  WHERE xnpis_virtuemart_medias.`virtuemart_media_id` = "1316"
461. SELECT `xnpis_virtuemart_medias`.*
  FROM `xnpis_virtuemart_medias`
  WHERE xnpis_virtuemart_medias.`virtuemart_media_id` = "2358"
462. SELECT `xnpis_virtuemart_medias`.*
  FROM `xnpis_virtuemart_medias`
  WHERE xnpis_virtuemart_medias.`virtuemart_media_id` = "2309"
463. SELECT `xnpis_virtuemart_medias`.*
  FROM `xnpis_virtuemart_medias`
  WHERE xnpis_virtuemart_medias.`virtuemart_media_id` = "1913"
464. SELECT `xnpis_virtuemart_medias`.*
  FROM `xnpis_virtuemart_medias`
  WHERE xnpis_virtuemart_medias.`virtuemart_media_id` = "2308"
465. SELECT `xnpis_virtuemart_medias`.*
  FROM `xnpis_virtuemart_medias`
  WHERE xnpis_virtuemart_medias.`virtuemart_media_id` = "2307"
466. SELECT L.*
  FROM `xnpis_virtuemart_categories_el_gr` as L JOIN `xnpis_virtuemart_categories` as c using (`virtuemart_category_id`)
  LEFT JOIN `xnpis_virtuemart_category_categories` as cx
  on c.`virtuemart_category_id` = cx.`category_child_id`
  WHERE cx.`category_parent_id` = 123
  AND c.`virtuemart_vendor_id` = 1
  AND c.`published` = 1
  ORDER BY category_name ASC
467. SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
  FROM xnpis_modules AS m
  LEFT JOIN xnpis_modules_menu AS mm
  ON mm.moduleid = m.id
  LEFT JOIN xnpis_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 <= '2019-12-15 05:53:36')
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2019-12-15 05:53:36')
  AND m.access IN (1,1)
  AND m.client_id = 0
  AND (mm.menuid = 223 OR mm.menuid <= 0)
  ORDER BY m.position, m.ordering
468. SELECT l.`virtuemart_product_id`
  FROM `xnpis_virtuemart_products_el_gr` as l JOIN `xnpis_virtuemart_products` AS p using (`virtuemart_product_id`)
  LEFT JOIN `xnpis_virtuemart_product_prices` as pp
  ON p.`virtuemart_product_id` = pp.`virtuemart_product_id`
  LEFT JOIN `xnpis_virtuemart_product_shoppergroups`
  ON p.`virtuemart_product_id` = `xnpis_virtuemart_product_shoppergroups`.`virtuemart_product_id`
  LEFT
  OUTER JOIN `xnpis_virtuemart_shoppergroups` as s
  ON s.`virtuemart_shoppergroup_id` = `xnpis_virtuemart_product_shoppergroups`.`virtuemart_shoppergroup_id`
  WHERE ( p.`published`="1"
  AND ( s.`virtuemart_shoppergroup_id`= "1" OR s.`virtuemart_shoppergroup_id` IS NULL ) )
  group by p.`virtuemart_product_id`
  ORDER BY RAND() ASC
  LIMIT 0, 1
469. SELECT `xnpis_virtuemart_products_el_gr`.* ,`xnpis_virtuemart_products`.* ,`xnpis_virtuemart_ratings`.`rating` ,`xnpis_virtuemart_product_manufacturers`.`virtuemart_manufacturer_id` ,`xnpis_virtuemart_product_customfields`.`virtuemart_customfield_id`
  FROM `xnpis_virtuemart_products_el_gr` JOIN xnpis_virtuemart_products using (`virtuemart_product_id`)
  LEFT JOIN `xnpis_virtuemart_ratings`
  on `xnpis_virtuemart_ratings`.`virtuemart_product_id`=`xnpis_virtuemart_products_el_gr`.`virtuemart_product_id`
  LEFT JOIN `xnpis_virtuemart_product_manufacturers`
  on `xnpis_virtuemart_product_manufacturers`.`virtuemart_product_id`=`xnpis_virtuemart_products_el_gr`.`virtuemart_product_id`
  LEFT JOIN `xnpis_virtuemart_product_customfields`
  on `xnpis_virtuemart_product_customfields`.`virtuemart_product_id`=`xnpis_virtuemart_products_el_gr`.`virtuemart_product_id`
  WHERE xnpis_virtuemart_products_el_gr.`virtuemart_product_id` = "2054"
470. SELECT `virtuemart_media_id`
  FROM `xnpis_virtuemart_product_medias`
  WHERE `virtuemart_product_id` = "2054"
  ORDER BY `ordering`
471. SELECT `virtuemart_shoppergroup_id`
  FROM `xnpis_virtuemart_product_shoppergroups`
  WHERE `virtuemart_product_id` = "2054"
472. SELECT *
  FROM `xnpis_virtuemart_product_prices`
  WHERE `virtuemart_product_id` = "2054"
  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` <= "2019-12-15 05:53:36" )
  AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2019-12-15 05:53:36" ) )
  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) )
473. SELECT pc.`virtuemart_category_id`
  FROM `xnpis_virtuemart_product_categories` as pc
  WHERE pc.`virtuemart_product_id` = 2054
474. SELECT pc.`virtuemart_category_id`
  FROM `xnpis_virtuemart_product_categories` as pc
  LEFT JOIN `xnpis_virtuemart_categories` as c
  ON c.`virtuemart_category_id` = pc.`virtuemart_category_id`
  WHERE pc.`virtuemart_product_id` = 2054
  AND `published`=1
  ORDER BY `c`.`ordering` ASC
475. SELECT `ordering`,`id`
  FROM `xnpis_virtuemart_product_categories`
  WHERE `virtuemart_product_id` = "2054"
  and `virtuemart_category_id`= "211"
476. SELECT `xnpis_virtuemart_categories_el_gr`.* ,`xnpis_virtuemart_categories`.*
  FROM `xnpis_virtuemart_categories_el_gr` JOIN xnpis_virtuemart_categories using (`virtuemart_category_id`)
  WHERE xnpis_virtuemart_categories_el_gr.`virtuemart_category_id` = "211"
477. SELECT `vendor_currency`
  FROM xnpis_virtuemart_vendors
  WHERE `virtuemart_vendor_id`="1"
478. SELECT `slug`
  FROM `xnpis_virtuemart_products_el_gr`
  WHERE `virtuemart_product_id` = 2054
479. SELECT `xnpis_virtuemart_medias`.*
  FROM `xnpis_virtuemart_medias`
  WHERE xnpis_virtuemart_medias.`virtuemart_media_id` = "2327"
480. SELECT l.`virtuemart_product_id`
  FROM `xnpis_virtuemart_products_el_gr` as l JOIN `xnpis_virtuemart_products` AS p using (`virtuemart_product_id`)
  LEFT JOIN `xnpis_virtuemart_product_categories` as pc
  ON p.`virtuemart_product_id` = `pc`.`virtuemart_product_id`
  LEFT JOIN `xnpis_virtuemart_categories_el_gr` as c
  ON c.`virtuemart_category_id` = `pc`.`virtuemart_category_id`
  LEFT JOIN `xnpis_virtuemart_product_prices` as pp
  ON p.`virtuemart_product_id` = pp.`virtuemart_product_id`
  LEFT JOIN `xnpis_virtuemart_product_shoppergroups`
  ON p.`virtuemart_product_id` = `xnpis_virtuemart_product_shoppergroups`.`virtuemart_product_id`
  LEFT
  OUTER JOIN `xnpis_virtuemart_shoppergroups` as s
  ON s.`virtuemart_shoppergroup_id` = `xnpis_virtuemart_product_shoppergroups`.`virtuemart_shoppergroup_id`
  WHERE ( p.`published`="1"
  AND `pc`.`virtuemart_category_id` = 329
  AND ( s.`virtuemart_shoppergroup_id`= "1" OR s.`virtuemart_shoppergroup_id` IS NULL ) )
  group by p.`virtuemart_product_id`
  ORDER BY RAND() ASC
  LIMIT 0, 1
481. SELECT `xnpis_virtuemart_products_el_gr`.* ,`xnpis_virtuemart_products`.* ,`xnpis_virtuemart_ratings`.`rating` ,`xnpis_virtuemart_product_manufacturers`.`virtuemart_manufacturer_id` ,`xnpis_virtuemart_product_customfields`.`virtuemart_customfield_id`
  FROM `xnpis_virtuemart_products_el_gr` JOIN xnpis_virtuemart_products using (`virtuemart_product_id`)
  LEFT JOIN `xnpis_virtuemart_ratings`
  on `xnpis_virtuemart_ratings`.`virtuemart_product_id`=`xnpis_virtuemart_products_el_gr`.`virtuemart_product_id`
  LEFT JOIN `xnpis_virtuemart_product_manufacturers`
  on `xnpis_virtuemart_product_manufacturers`.`virtuemart_product_id`=`xnpis_virtuemart_products_el_gr`.`virtuemart_product_id`
  LEFT JOIN `xnpis_virtuemart_product_customfields`
  on `xnpis_virtuemart_product_customfields`.`virtuemart_product_id`=`xnpis_virtuemart_products_el_gr`.`virtuemart_product_id`
  WHERE xnpis_virtuemart_products_el_gr.`virtuemart_product_id` = "1946"
482. SELECT `virtuemart_media_id`
  FROM `xnpis_virtuemart_product_medias`
  WHERE `virtuemart_product_id` = "1946"
  ORDER BY `ordering`
483. SELECT `virtuemart_shoppergroup_id`
  FROM `xnpis_virtuemart_product_shoppergroups`
  WHERE `virtuemart_product_id` = "1946"
484. SELECT *
  FROM `xnpis_virtuemart_product_prices`
  WHERE `virtuemart_product_id` = "1946"
  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` <= "2019-12-15 05:53:36" )
  AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2019-12-15 05:53:36" ) )
  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) )
485. SELECT pc.`virtuemart_category_id`
  FROM `xnpis_virtuemart_product_categories` as pc
  WHERE pc.`virtuemart_product_id` = 1946
486. SELECT pc.`virtuemart_category_id`
  FROM `xnpis_virtuemart_product_categories` as pc
  LEFT JOIN `xnpis_virtuemart_categories` as c
  ON c.`virtuemart_category_id` = pc.`virtuemart_category_id`
  WHERE pc.`virtuemart_product_id` = 1946
  AND `published`=1
  ORDER BY `c`.`ordering` ASC
487. SELECT `ordering`,`id`
  FROM `xnpis_virtuemart_product_categories`
  WHERE `virtuemart_product_id` = "1946"
  and `virtuemart_category_id`= "328"
488. SELECT `xnpis_virtuemart_categories_el_gr`.* ,`xnpis_virtuemart_categories`.*
  FROM `xnpis_virtuemart_categories_el_gr` JOIN xnpis_virtuemart_categories using (`virtuemart_category_id`)
  WHERE xnpis_virtuemart_categories_el_gr.`virtuemart_category_id` = "328"
489. 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 `xnpis_virtuemart_customs` AS C
  LEFT JOIN `xnpis_virtuemart_product_customfields` AS field
  ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
  Where `virtuemart_product_id` =1946
  and `field_type` != "G"
  and `field_type` != "R"
  and `field_type` != "Z"
  and is_cart_attribute = 0
  order by field.`ordering`,virtuemart_custom_id
490. 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 `xnpis_virtuemart_customs` AS C
  LEFT JOIN `xnpis_virtuemart_product_customfields` AS field
  ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
  Where `virtuemart_product_id` =1946
  and `field_type` = "Z"
  and is_cart_attribute = 0
  order by ordering
491. 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 `xnpis_virtuemart_customs` AS C
  LEFT JOIN `xnpis_virtuemart_product_customfields` AS field
  ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
  Where `virtuemart_product_id` =1946
  and `field_type` = "R"
  and is_cart_attribute = 0
  order by ordering
492. 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 `xnpis_virtuemart_customs` AS C
  LEFT JOIN `xnpis_virtuemart_product_customfields` AS field
  ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
  Where `virtuemart_product_id` =1946
  and `field_type` != "G"
  and `field_type` != "R"
  and `field_type` != "Z"
  and is_cart_attribute = 1
  group by virtuemart_custom_id
  ORDER BY field.`ordering`
493. SELECT virtuemart_product_id, product_name
  FROM `xnpis_virtuemart_products_el_gr` JOIN `xnpis_virtuemart_products` as C using (`virtuemart_product_id`)
  WHERE `product_parent_id` =1946
494. SELECT `vendor_currency`
  FROM xnpis_virtuemart_vendors
  WHERE `virtuemart_vendor_id`="1"
495. SELECT `slug`
  FROM `xnpis_virtuemart_products_el_gr`
  WHERE `virtuemart_product_id` = 1946
496. SELECT `xnpis_virtuemart_medias`.*
  FROM `xnpis_virtuemart_medias`
  WHERE xnpis_virtuemart_medias.`virtuemart_media_id` = "2217"
497. SELECT l.`virtuemart_product_id`
  FROM `xnpis_virtuemart_products_el_gr` as l JOIN `xnpis_virtuemart_products` AS p using (`virtuemart_product_id`)
  LEFT JOIN `xnpis_virtuemart_product_prices` as pp
  ON p.`virtuemart_product_id` = pp.`virtuemart_product_id`
  LEFT JOIN `xnpis_virtuemart_product_shoppergroups`
  ON p.`virtuemart_product_id` = `xnpis_virtuemart_product_shoppergroups`.`virtuemart_product_id`
  LEFT
  OUTER JOIN `xnpis_virtuemart_shoppergroups` as s
  ON s.`virtuemart_shoppergroup_id` = `xnpis_virtuemart_product_shoppergroups`.`virtuemart_shoppergroup_id`
  WHERE ( p.`published`="1"
  AND ( s.`virtuemart_shoppergroup_id`= "1" OR s.`virtuemart_shoppergroup_id` IS NULL )
  AND pp.`product_price`>"0.0" )
  group by p.`virtuemart_product_id`
  ORDER BY p.`product_sales` DESC
  LIMIT 0, 2
498. SELECT `xnpis_virtuemart_products_el_gr`.* ,`xnpis_virtuemart_products`.* ,`xnpis_virtuemart_ratings`.`rating` ,`xnpis_virtuemart_product_manufacturers`.`virtuemart_manufacturer_id` ,`xnpis_virtuemart_product_customfields`.`virtuemart_customfield_id`
  FROM `xnpis_virtuemart_products_el_gr` JOIN xnpis_virtuemart_products using (`virtuemart_product_id`)
  LEFT JOIN `xnpis_virtuemart_ratings`
  on `xnpis_virtuemart_ratings`.`virtuemart_product_id`=`xnpis_virtuemart_products_el_gr`.`virtuemart_product_id`
  LEFT JOIN `xnpis_virtuemart_product_manufacturers`
  on `xnpis_virtuemart_product_manufacturers`.`virtuemart_product_id`=`xnpis_virtuemart_products_el_gr`.`virtuemart_product_id`
  LEFT JOIN `xnpis_virtuemart_product_customfields`
  on `xnpis_virtuemart_product_customfields`.`virtuemart_product_id`=`xnpis_virtuemart_products_el_gr`.`virtuemart_product_id`
  WHERE xnpis_virtuemart_products_el_gr.`virtuemart_product_id` = "260"
499. SELECT `virtuemart_media_id`
  FROM `xnpis_virtuemart_product_medias`
  WHERE `virtuemart_product_id` = "260"
  ORDER BY `ordering`
500. SELECT `virtuemart_shoppergroup_id`
  FROM `xnpis_virtuemart_product_shoppergroups`
  WHERE `virtuemart_product_id` = "260"
501. SELECT *
  FROM `xnpis_virtuemart_product_prices`
  WHERE `virtuemart_product_id` = "260"
  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` <= "2019-12-15 05:53:36" )
  AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2019-12-15 05:53:36" ) )
  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) )
502. SELECT pc.`virtuemart_category_id`
  FROM `xnpis_virtuemart_product_categories` as pc
  WHERE pc.`virtuemart_product_id` = 260
503. SELECT pc.`virtuemart_category_id`
  FROM `xnpis_virtuemart_product_categories` as pc
  LEFT JOIN `xnpis_virtuemart_categories` as c
  ON c.`virtuemart_category_id` = pc.`virtuemart_category_id`
  WHERE pc.`virtuemart_product_id` = 260
  AND `published`=1
  ORDER BY `c`.`ordering` ASC
504. SELECT `ordering`,`id`
  FROM `xnpis_virtuemart_product_categories`
  WHERE `virtuemart_product_id` = "260"
  and `virtuemart_category_id`= "310"
505. SELECT `xnpis_virtuemart_categories_el_gr`.* ,`xnpis_virtuemart_categories`.*
  FROM `xnpis_virtuemart_categories_el_gr` JOIN xnpis_virtuemart_categories using (`virtuemart_category_id`)
  WHERE xnpis_virtuemart_categories_el_gr.`virtuemart_category_id` = "310"
506. 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 `xnpis_virtuemart_customs` AS C
  LEFT JOIN `xnpis_virtuemart_product_customfields` AS field
  ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
  Where `virtuemart_product_id` =260
  and `field_type` != "G"
  and `field_type` != "R"
  and `field_type` != "Z"
  and is_cart_attribute = 0
  order by field.`ordering`,virtuemart_custom_id
507. 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 `xnpis_virtuemart_customs` AS C
  LEFT JOIN `xnpis_virtuemart_product_customfields` AS field
  ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
  Where `virtuemart_product_id` =260
  and `field_type` = "Z"
  and is_cart_attribute = 0
  order by ordering
508. 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 `xnpis_virtuemart_customs` AS C
  LEFT JOIN `xnpis_virtuemart_product_customfields` AS field
  ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
  Where `virtuemart_product_id` =260
  and `field_type` = "R"
  and is_cart_attribute = 0
  order by ordering
509. 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 `xnpis_virtuemart_customs` AS C
  LEFT JOIN `xnpis_virtuemart_product_customfields` AS field
  ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
  Where `virtuemart_product_id` =260
  and `field_type` != "G"
  and `field_type` != "R"
  and `field_type` != "Z"
  and is_cart_attribute = 1
  group by virtuemart_custom_id
  ORDER BY field.`ordering`
510. SELECT field.`virtuemart_product_id`, `custom_params`,`custom_element`, field.`virtuemart_custom_id`, field.`virtuemart_customfield_id`,field.`custom_value`, field.`custom_price`, field.`custom_param`
  FROM `xnpis_virtuemart_customs` AS C
  LEFT JOIN `xnpis_virtuemart_product_customfields` AS field
  ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
  Where `virtuemart_product_id` =260
  and is_cart_attribute = 1
  and C.`virtuemart_custom_id`=27
  ORDER BY field.`ordering`
511. SELECT virtuemart_product_id, product_name
  FROM `xnpis_virtuemart_products_el_gr` JOIN `xnpis_virtuemart_products` as C using (`virtuemart_product_id`)
  WHERE `product_parent_id` =260
512. SELECT `vendor_currency`
  FROM xnpis_virtuemart_vendors
  WHERE `virtuemart_vendor_id`="1"
513. SELECT `slug`
  FROM `xnpis_virtuemart_products_el_gr`
  WHERE `virtuemart_product_id` = 260
514. SELECT `xnpis_virtuemart_products_el_gr`.* ,`xnpis_virtuemart_products`.* ,`xnpis_virtuemart_ratings`.`rating` ,`xnpis_virtuemart_product_manufacturers`.`virtuemart_manufacturer_id` ,`xnpis_virtuemart_product_customfields`.`virtuemart_customfield_id`
  FROM `xnpis_virtuemart_products_el_gr` JOIN xnpis_virtuemart_products using (`virtuemart_product_id`)
  LEFT JOIN `xnpis_virtuemart_ratings`
  on `xnpis_virtuemart_ratings`.`virtuemart_product_id`=`xnpis_virtuemart_products_el_gr`.`virtuemart_product_id`
  LEFT JOIN `xnpis_virtuemart_product_manufacturers`
  on `xnpis_virtuemart_product_manufacturers`.`virtuemart_product_id`=`xnpis_virtuemart_products_el_gr`.`virtuemart_product_id`
  LEFT JOIN `xnpis_virtuemart_product_customfields`
  on `xnpis_virtuemart_product_customfields`.`virtuemart_product_id`=`xnpis_virtuemart_products_el_gr`.`virtuemart_product_id`
  WHERE xnpis_virtuemart_products_el_gr.`virtuemart_product_id` = "151"
515. SELECT `virtuemart_media_id`
  FROM `xnpis_virtuemart_product_medias`
  WHERE `virtuemart_product_id` = "151"
  ORDER BY `ordering`
516. SELECT `virtuemart_shoppergroup_id`
  FROM `xnpis_virtuemart_product_shoppergroups`
  WHERE `virtuemart_product_id` = "151"
517. SELECT *
  FROM `xnpis_virtuemart_product_prices`
  WHERE `virtuemart_product_id` = "151"
  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` <= "2019-12-15 05:53:36" )
  AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2019-12-15 05:53:36" ) )
  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) )
518. SELECT pc.`virtuemart_category_id`
  FROM `xnpis_virtuemart_product_categories` as pc
  WHERE pc.`virtuemart_product_id` = 151
519. SELECT pc.`virtuemart_category_id`
  FROM `xnpis_virtuemart_product_categories` as pc
  LEFT JOIN `xnpis_virtuemart_categories` as c
  ON c.`virtuemart_category_id` = pc.`virtuemart_category_id`
  WHERE pc.`virtuemart_product_id` = 151
  AND `published`=1
  ORDER BY `c`.`ordering` ASC
520. SELECT `ordering`,`id`
  FROM `xnpis_virtuemart_product_categories`
  WHERE `virtuemart_product_id` = "151"
  and `virtuemart_category_id`= "309"
521. SELECT `xnpis_virtuemart_categories_el_gr`.* ,`xnpis_virtuemart_categories`.*
  FROM `xnpis_virtuemart_categories_el_gr` JOIN xnpis_virtuemart_categories using (`virtuemart_category_id`)
  WHERE xnpis_virtuemart_categories_el_gr.`virtuemart_category_id` = "309"
522. 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 `xnpis_virtuemart_customs` AS C
  LEFT JOIN `xnpis_virtuemart_product_customfields` AS field
  ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
  Where `virtuemart_product_id` =151
  and `field_type` != "G"
  and `field_type` != "R"
  and `field_type` != "Z"
  and is_cart_attribute = 0
  order by field.`ordering`,virtuemart_custom_id
523. 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 `xnpis_virtuemart_customs` AS C
  LEFT JOIN `xnpis_virtuemart_product_customfields` AS field
  ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
  Where `virtuemart_product_id` =151
  and `field_type` = "Z"
  and is_cart_attribute = 0
  order by ordering
524. 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 `xnpis_virtuemart_customs` AS C
  LEFT JOIN `xnpis_virtuemart_product_customfields` AS field
  ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
  Where `virtuemart_product_id` =151
  and `field_type` = "R"
  and is_cart_attribute = 0
  order by ordering
525. 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 `xnpis_virtuemart_customs` AS C
  LEFT JOIN `xnpis_virtuemart_product_customfields` AS field
  ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
  Where `virtuemart_product_id` =151
  and `field_type` != "G"
  and `field_type` != "R"
  and `field_type` != "Z"
  and is_cart_attribute = 1
  group by virtuemart_custom_id
  ORDER BY field.`ordering`
526. SELECT field.`virtuemart_product_id`, `custom_params`,`custom_element`, field.`virtuemart_custom_id`, field.`virtuemart_customfield_id`,field.`custom_value`, field.`custom_price`, field.`custom_param`
  FROM `xnpis_virtuemart_customs` AS C
  LEFT JOIN `xnpis_virtuemart_product_customfields` AS field
  ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
  Where `virtuemart_product_id` =151
  and is_cart_attribute = 1
  and C.`virtuemart_custom_id`=27
  ORDER BY field.`ordering`
527. SELECT virtuemart_product_id, product_name
  FROM `xnpis_virtuemart_products_el_gr` JOIN `xnpis_virtuemart_products` as C using (`virtuemart_product_id`)
  WHERE `product_parent_id` =151
528. SELECT `vendor_currency`
  FROM xnpis_virtuemart_vendors
  WHERE `virtuemart_vendor_id`="1"
529. SELECT `slug`
  FROM `xnpis_virtuemart_products_el_gr`
  WHERE `virtuemart_product_id` = 151
530. SELECT `xnpis_virtuemart_medias`.*
  FROM `xnpis_virtuemart_medias`
  WHERE xnpis_virtuemart_medias.`virtuemart_media_id` = "459"
531. SELECT `xnpis_virtuemart_medias`.*
  FROM `xnpis_virtuemart_medias`
  WHERE xnpis_virtuemart_medias.`virtuemart_media_id` = "2143"
532. SELECT extension_id AS id, element AS "option", params, enabled
  FROM xnpis_extensions
  WHERE `type` = 'component'
  AND `element` = 'com_content'
533. SELECT *
  FROM xnpis_modules
  WHERE published=1
  ORDER BY id ;
534. SELECT extension_id AS id, element AS "option", params, enabled
  FROM xnpis_extensions
  WHERE `type` = 'component'
  AND `element` = 'com_contact'
535. UPDATE `xnpis_session`
  SET `data` = 'ZNIXh7kIBySJP4xfvKRnDeAm9CwaMFv4U0c2T_ltzvDou00z42TtMe64mDRrphpXrAZUUDdovTfrELxc385AbGb1Rydf4IChCsVTKb-DC2d79Av8kpFis-8X4_O-_5M4aW51oEEDVlb-lO2WlWeHk9_bzp46702kaFUXEs39Pk8FURO5nNYEHuW7D913rmCFN_IgWkcyv0VW3fZBohUjl3TRkTREI3MKUbvR9pAZZqpd_qBlnQ5s7s0v0xTQYfqc8TDddCjYOjOYnqIyZMIQZIxec1xXyvOAlOskwwZouG9eJBV8-foUr2l2wbbRQJL2ipaAlfVbf5UW-1DpRBBMMek43rW0UrFlepsqQZUjOIeaGATL8Iv01JKYRF864mI-l3LcBeakM5J1xx1uemBTjTeLOpWDPrk8SR1qkQRQVERNia0Cyqpft5gKCc1Lh2ImN7Vd6On6RDTOdQBYtICH98vcuLyrQMVpdpAtW4I5YAxYADJdfHsR48V8yPgmPwlgWiMZHvZLdtTV6IzfudNesc-vg71mMTyk_xrgPcjNroRdM4bCtcpd0i7-8yIYGeMm76tH-MjF6galVLv1ZOoywJk_8mDr4jKcNETIRlSDGhnRIyZtuMg9v3MSqTVRso8RG0zogPNNMFsCluwAIZVNOJjC0MR6tHolDOhHYSSF9171I--CqUstw0QVZAsCHklXXp0bHCrvkzJkGSbBFAQ2C3PiR-udSasgQINYIhVEINoU3JlzWVCMCNInbT3U6okjysCjVy2F9P20tgEnc3HjNZevetJGjC_iah8JvDi-0t7askeiTIeGJgayBgxJoDpgY_plHrq5oxgy3TnyVwe12FaNzmCbX-7l9zcbO5gZcH93HSpwo_sUud8zuEPn1XzsvfDrzGpflCzuB6ldtXxKYDiRbMg_-5fe7_TzAg9wADdBEArfG89gHZ5FZm1xHV72WfLkoFOu6MqZyCGSvKYKTZfj9g_4vapz-2pm8NNqYUm89tkfPzhD-yGyE26I9XIw3fwmM5899SUrr-qZ3801KYbyvS-ZkhT5OHPMEwtmrel70tDdp6giRcUOqRsRASS0F8sqoWDAT_Pr-iB9-hMteZ5_T0tNVQMB_D4iHJUuTTNciXNBmwzdydf24nwrmIJlhxyWTr8gkVqvxRAril-vCeUeAOI12fxVGLbRg2fRc6fyH0csvBpn9Fzpic3dsBFwxZYHLXCfRnFj_IpM1rJjB8PMa-NSsYp9uFTDSz2YfCI7NALmex85KUoBNQcVLiSwfhkvRfD8Uyb9aZEdHWKtRj5LT0lvQ88eyzDKTMzXUaj8Lf4405KHvgZ7lwcXp-mCRSju4UGGh5ivAUgrPvXNSYQ5VyOUGcS679uxaqSNgbEcL0U10eyzezLCbEN5TYmKiTVn8jJx_PFkpN5Epd8bHAF2dK9vsztA1TWxGbBuFdyQpJamEdeLhrwq8eZisnG1QHJdHjtcBzWl22LXidBwxi-3evLGKY1hs93yK2uLjdMSZzQx16_61JqB4axLcO-kzZEDHwlRwa9t2kGrgYWsXtb7wkIIA15DY-qlNuweS4qgdXvMT85ZEh4aYrpNmdmKQ8PfTJBzaa852jcxU0xaWksA1ptNqTppCYeAEHD6NgNU_Hbok801mQO4HgIIuyjPMJymwIhjlnFLP0hd5KGCuZPGuj5Ww91BOlxZsBPQbgL7pFoqO-xigAXs_Wgf9fZ0RADHPU9Du_gS_cEJhEwq39wKAIWUtd94d5pfjpVhM10dXbvNwWIIP-zRurI8_zyu56ABzr8tLRtS5sBiFZKIPxi-xeJbwk3KryQCbNTKrw1lt1lx60llkRAQVlVHqOs_6DzpUef_YOcann1hqslFGv_qF9_7EKwpdzPVVbb6IO1So-LQrGmRU8UdRpl22ecD7OlKIyOos77c-JKC65Kq-QU4bd11RWpKpJuZr60_0pibtPsl4hD6JG_r4RJdWqWDirC9t24ovQrwen17L2nm174EhEKyP9jACxrnZGQPNv3VWCe9B9M6HOicNTLKg5NGek8xv73hHfTK_r91xDM14PNePqbfJr8uUyp6Lz2DgZihbus0bR-P5BLjF0TiGDWHH-RvYaFVumLLlK9h5pQTJbbjL3Ns_qvYTubF0FcVmIxyCWrufvRx1pWkjR2EoymGCvyujhXeJb1mPcihvlbsSUCIvAy5lnk5GkGY6IdCYSnfMpEAKtz5LnaGMiJDw5yj00z2TaWjqM6BuIekpY3V8aEGzpVGjYHDky8XIWmZXvJhEfzhbwrDSnqs3Ng9tlOu-RWhewFEus3n-fMpAxmcYkxr2udZUC47WYV8G0dR-vIAdQ2_QQoAqfLiBB5daMUhPKzdphUVQ6GtPRuhQF5C_wTLKqD4Qbt-Y4Fc2uwSwk4PQJb8puMkRyXPj3lfzycP8B2mIM_7RGELgLrLOjb1yWAV2lA5eY1GjSKG65ND786fARjlTgad1lzawIrH2MPayqbYBRRt0UcDLB_HXCDYHxwHN0d8gBxObmDSewXf39w_c61LID0aqjC2khNUJ4gawhcu6IX2QTfc_NEfsu_Rk1bb9sR-qW8ayUM7TguDFesOqy9n8Y8WgQzXMAe_gCvlStPmgyuLClqPJEmZeWk1L5Xb3dkd_Powj8l1srmlkmLt4Gf--2Xkr3pEx8uP6_GWX4YLi1z7T_lEnggxpmhHsJbRYaxCbmjUU_dPw9cdS2iP91i3yd-UMkRYhVsKkgJdQzPLhLT45avqXKx1gP7n9aPfuCwgmaUSwK510vnqMRuQKAFcI1-fdSBfwJmKVcg92GhtfjSpX0yA28pTDtc9ilEo_xj_lPaHhKVvJBxDH2EAqAK3be24-QlYHhhTgLvgeysAP0p9jX7Y6J66X6w7LReenTNyWmL2RL8fe1bQ0PUX_4RXyouINoHLnf4hwLRNSn5U4yi9fIHpIFQ2alA6zMgtUuVIPH2Tn3k4WycV0FgwtKjd1nqtA-0ayjbbA6ijNNKdXLTggnsaZNDmQ5EdIw..' , `time` = '1576389216'
  WHERE `session_id` = 'aaf2ce912aece4e63203cd781006679a'