581 Queries Logged

1. SELECT `data`
  FROM `eqc_session`
  WHERE `session_id` = '9613f9d5029174b11cac57288c6a81f3'
2. DELETE
  FROM `eqc_session`
  WHERE `time` < '1397983635'
3. SELECT `session_id`
  FROM `eqc_session`
  WHERE `session_id` = '9613f9d5029174b11cac57288c6a81f3'
  LIMIT 0, 1
4. INSERT INTO `eqc_session` (`session_id`, `client_id`, `time`)
  VALUES ('9613f9d5029174b11cac57288c6a81f3', 0, '1397990835')
5. SELECT extension_id AS id, element AS "option", params, enabled
  FROM eqc_extensions
  WHERE `type` = 'component'
  AND `element` = 'com_users'
6. SELECT b.id
  FROM eqc_usergroups AS a
  LEFT JOIN eqc_usergroups AS b
  ON b.lft <= a.lft
  AND b.rgt >= a.rgt
  WHERE a.id = 1
7. SELECT id, rules
  FROM `eqc_viewlevels`
8. SELECT folder AS type, element AS name, params
  FROM eqc_extensions
  WHERE enabled >= 1
  AND type ='plugin'
  AND state >= 0
  AND access IN (1)
  ORDER BY ordering
9. SELECT extension_id AS id, element AS "option", params, enabled
  FROM eqc_extensions
  WHERE `type` = 'component'
  AND `element` = 'com_languages'
10. SELECT extension_id AS id, element AS "option", params, enabled
  FROM eqc_extensions
  WHERE `type` = 'component'
  AND `element` = 'com_k2'
11. 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 eqc_menu AS m
  LEFT JOIN eqc_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
12. SELECT id, home, template, s.params
  FROM eqc_template_styles as s
  LEFT JOIN eqc_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
13. SELECT *
  FROM eqc_languages
  WHERE published=1
  ORDER BY ordering ASC
14. SELECT m.published, m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
  FROM eqc_modules AS m
  LEFT JOIN eqc_modules_menu AS mm
  ON mm.moduleid = m.id
  LEFT JOIN eqc_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 <= '2014-04-20 10:47:15')
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2014-04-20 10:47:15')
  AND m.access IN (1)
  AND m.client_id = 0
  AND (mm.menuid = 435 OR mm.menuid <= 0)
  ORDER BY m.position, m.ordering
15. SELECT extension_id AS id, element AS "option", params, enabled
  FROM eqc_extensions
  WHERE `type` = 'component'
  AND `element` = 'com_content'
16. SELECT a.rules
  FROM eqc_assets AS a
  WHERE (a.id = 1)
  GROUP BY a.id, a.rules, a.lft
17. SELECT b.rules
  FROM eqc_assets AS a
  LEFT JOIN eqc_assets AS b
  ON b.lft <= a.lft
  AND b.rgt >= a.rgt
  WHERE (a.name = 'com_content')
  GROUP BY b.id, b.rules, b.lft
  ORDER BY b.lft
18. SELECT a.id, a.title, a.alias, a.title_alias, a.introtext, a.language, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias,
  CASE WHEN a.modified = 0 THEN a.created ELSE a.modified END as modified, a.modified_by, uam.name as modified_by_name,
  CASE WHEN a.publish_up = 0 THEN a.created ELSE a.publish_up END as publish_up,a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, LENGTH(a.fulltext) AS readmore,
  CASE WHEN badcats.id is not null THEN 0 ELSE a.state END AS state,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,
  CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,( SELECT MAX(contact.id) AS id
  FROM eqc_contact_details AS contact
  WHERE contact.published = 1
  AND contact.user_id = a.created_by) as contactid,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count,c.published,
  CASE WHEN badcats.id is null THEN c.published ELSE 0 END AS parents_published
  FROM eqc_content AS a
  LEFT JOIN eqc_categories AS c
  ON c.id = a.catid
  LEFT JOIN eqc_users AS ua
  ON ua.id = a.created_by
  LEFT JOIN eqc_users AS uam
  ON uam.id = a.modified_by
  LEFT JOIN eqc_categories as parent
  ON parent.id = c.parent_id
  LEFT JOIN eqc_content_rating AS v
  ON a.id = v.content_id
  LEFT
  OUTER JOIN (SELECT cat.id as id
  FROM eqc_categories AS cat JOIN eqc_categories AS parent
  ON cat.lft BETWEEN parent.lft
  AND parent.rgt
  WHERE parent.extension = 'com_content'
  AND parent.published != 1
  GROUP BY cat.id ) AS badcats
  ON badcats.id = c.id
  INNER JOIN eqc_content_frontpage AS fp
  ON fp.content_id = a.id
  WHERE a.access IN (1)
  AND c.access IN (1)
  AND
  CASE WHEN badcats.id is null THEN a.state ELSE 0 END = 1
  AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2014-04-20 10:47:15')
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2014-04-20 10:47:15')
  ORDER BY c.lft, a.featured DESC, fp.ordering, a.created DESC
  LIMIT 0, 3
19. SELECT a.id, a.title, a.alias, a.title_alias, a.introtext, a.language, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias,
  CASE WHEN a.modified = 0 THEN a.created ELSE a.modified END as modified, a.modified_by, uam.name as modified_by_name,
  CASE WHEN a.publish_up = 0 THEN a.created ELSE a.publish_up END as publish_up,a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, LENGTH(a.fulltext) AS readmore,
  CASE WHEN badcats.id is not null THEN 0 ELSE a.state END AS state,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,
  CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,( SELECT MAX(contact.id) AS id
  FROM eqc_contact_details AS contact
  WHERE contact.published = 1
  AND contact.user_id = a.created_by) as contactid,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count,c.published,
  CASE WHEN badcats.id is null THEN c.published ELSE 0 END AS parents_published
  FROM eqc_content AS a
  LEFT JOIN eqc_categories AS c
  ON c.id = a.catid
  LEFT JOIN eqc_users AS ua
  ON ua.id = a.created_by
  LEFT JOIN eqc_users AS uam
  ON uam.id = a.modified_by
  LEFT JOIN eqc_categories as parent
  ON parent.id = c.parent_id
  LEFT JOIN eqc_content_rating AS v
  ON a.id = v.content_id
  LEFT
  OUTER JOIN (SELECT cat.id as id
  FROM eqc_categories AS cat JOIN eqc_categories AS parent
  ON cat.lft BETWEEN parent.lft
  AND parent.rgt
  WHERE parent.extension = 'com_content'
  AND parent.published != 1
  GROUP BY cat.id ) AS badcats
  ON badcats.id = c.id
  INNER JOIN eqc_content_frontpage AS fp
  ON fp.content_id = a.id
  WHERE a.access IN (1)
  AND c.access IN (1)
  AND
  CASE WHEN badcats.id is null THEN a.state ELSE 0 END = 1
  AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2014-04-20 10:47:15')
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2014-04-20 10:47:15')
  ORDER BY c.lft, a.featured DESC, fp.ordering, a.created DESC
20. SHOW TABLES LIKE "eqc_virtuemart_configs"
21. SELECT `config`
  FROM `eqc_virtuemart_configs`
  WHERE `virtuemart_config_id` = "1";
22. SELECT `virtuemart_permgroup_id`,`group_name`,`group_level`
  FROM `eqc_virtuemart_permgroups`
  ORDER BY `group_level`
23. SELECT extension_id AS id, element AS "option", params, enabled
  FROM eqc_extensions
  WHERE `type` = 'component'
  AND `element` = 'com_virtuemart'
24. SELECT *
  FROM `eqc_menu`
  where `link` like "index.php?option=com_virtuemart%"
  and client_id=0
  and published=1
  and (language="*" or language = "en-GB" )
25. SELECT *
  FROM eqc_acymailing_config
26. SELECT *
  FROM eqc_acymailing_list
  WHERE type = 'list'
  ORDER BY ordering ASC
27. SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
  FROM `eqc_virtuemart_category_categories` AS `xref`
  WHERE `xref`.`category_child_id`= 0
28. SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
  FROM eqc_virtuemart_category_categories AS `xref`
  WHERE `xref`.`category_child_id`= 52
29. SELECT `slug` as name
  FROM `eqc_virtuemart_categories_en_gb`
  WHERE `virtuemart_category_id`=52
30. SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
  FROM eqc_virtuemart_category_categories AS `xref`
  WHERE `xref`.`category_child_id`= 7
31. SELECT `slug` as name
  FROM `eqc_virtuemart_categories_en_gb`
  WHERE `virtuemart_category_id`=7
32. SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
  FROM eqc_virtuemart_category_categories AS `xref`
  WHERE `xref`.`category_child_id`= 8
33. SELECT `slug` as name
  FROM `eqc_virtuemart_categories_en_gb`
  WHERE `virtuemart_category_id`=8
34. SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
  FROM eqc_virtuemart_category_categories AS `xref`
  WHERE `xref`.`category_child_id`= 68
35. SELECT `slug` as name
  FROM `eqc_virtuemart_categories_en_gb`
  WHERE `virtuemart_category_id`=68
36. SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
  FROM eqc_virtuemart_category_categories AS `xref`
  WHERE `xref`.`category_child_id`= 9
37. SELECT `slug` as name
  FROM `eqc_virtuemart_categories_en_gb`
  WHERE `virtuemart_category_id`=9
38. SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
  FROM eqc_virtuemart_category_categories AS `xref`
  WHERE `xref`.`category_child_id`= 10
39. SELECT `slug` as name
  FROM `eqc_virtuemart_categories_en_gb`
  WHERE `virtuemart_category_id`=10
40. SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
  FROM eqc_virtuemart_category_categories AS `xref`
  WHERE `xref`.`category_child_id`= 46
41. SELECT `slug` as name
  FROM `eqc_virtuemart_categories_en_gb`
  WHERE `virtuemart_category_id`=46
42. SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
  FROM eqc_virtuemart_category_categories AS `xref`
  WHERE `xref`.`category_child_id`= 38
43. SELECT `slug` as name
  FROM `eqc_virtuemart_categories_en_gb`
  WHERE `virtuemart_category_id`=38
44. SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
  FROM eqc_virtuemart_category_categories AS `xref`
  WHERE `xref`.`category_child_id`= 18
45. SELECT `slug` as name
  FROM `eqc_virtuemart_categories_en_gb`
  WHERE `virtuemart_category_id`=18
46. SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
  FROM eqc_virtuemart_category_categories AS `xref`
  WHERE `xref`.`category_child_id`= 11
47. SELECT `slug` as name
  FROM `eqc_virtuemart_categories_en_gb`
  WHERE `virtuemart_category_id`=11
48. SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
  FROM eqc_virtuemart_category_categories AS `xref`
  WHERE `xref`.`category_child_id`= 45
49. SELECT `slug` as name
  FROM `eqc_virtuemart_categories_en_gb`
  WHERE `virtuemart_category_id`=45
50. SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
  FROM eqc_virtuemart_category_categories AS `xref`
  WHERE `xref`.`category_child_id`= 37
51. SELECT `slug` as name
  FROM `eqc_virtuemart_categories_en_gb`
  WHERE `virtuemart_category_id`=37
52. SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
  FROM eqc_virtuemart_category_categories AS `xref`
  WHERE `xref`.`category_child_id`= 58
53. SELECT `slug` as name
  FROM `eqc_virtuemart_categories_en_gb`
  WHERE `virtuemart_category_id`=58
54. SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
  FROM eqc_virtuemart_category_categories AS `xref`
  WHERE `xref`.`category_child_id`= 44
55. SELECT `slug` as name
  FROM `eqc_virtuemart_categories_en_gb`
  WHERE `virtuemart_category_id`=44
56. SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
  FROM eqc_virtuemart_category_categories AS `xref`
  WHERE `xref`.`category_child_id`= 39
57. SELECT `slug` as name
  FROM `eqc_virtuemart_categories_en_gb`
  WHERE `virtuemart_category_id`=39
58. SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
  FROM eqc_virtuemart_category_categories AS `xref`
  WHERE `xref`.`category_child_id`= 63
59. SELECT `slug` as name
  FROM `eqc_virtuemart_categories_en_gb`
  WHERE `virtuemart_category_id`=63
60. SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
  FROM eqc_virtuemart_category_categories AS `xref`
  WHERE `xref`.`category_child_id`= 12
61. SELECT `slug` as name
  FROM `eqc_virtuemart_categories_en_gb`
  WHERE `virtuemart_category_id`=12
62. SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
  FROM eqc_virtuemart_category_categories AS `xref`
  WHERE `xref`.`category_child_id`= 13
63. SELECT `slug` as name
  FROM `eqc_virtuemart_categories_en_gb`
  WHERE `virtuemart_category_id`=13
64. SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
  FROM eqc_virtuemart_category_categories AS `xref`
  WHERE `xref`.`category_child_id`= 14
65. SELECT `slug` as name
  FROM `eqc_virtuemart_categories_en_gb`
  WHERE `virtuemart_category_id`=14
66. SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
  FROM eqc_virtuemart_category_categories AS `xref`
  WHERE `xref`.`category_child_id`= 15
67. SELECT `slug` as name
  FROM `eqc_virtuemart_categories_en_gb`
  WHERE `virtuemart_category_id`=15
68. SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
  FROM eqc_virtuemart_category_categories AS `xref`
  WHERE `xref`.`category_child_id`= 1
69. SELECT `slug` as name
  FROM `eqc_virtuemart_categories_en_gb`
  WHERE `virtuemart_category_id`=1
70. SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
  FROM eqc_virtuemart_category_categories AS `xref`
  WHERE `xref`.`category_child_id`= 16
71. SELECT `slug` as name
  FROM `eqc_virtuemart_categories_en_gb`
  WHERE `virtuemart_category_id`=16
72. SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
  FROM eqc_virtuemart_category_categories AS `xref`
  WHERE `xref`.`category_child_id`= 4
73. SELECT `slug` as name
  FROM `eqc_virtuemart_categories_en_gb`
  WHERE `virtuemart_category_id`=4
74. SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
  FROM eqc_virtuemart_category_categories AS `xref`
  WHERE `xref`.`category_child_id`= 19
75. SELECT `slug` as name
  FROM `eqc_virtuemart_categories_en_gb`
  WHERE `virtuemart_category_id`=19
76. SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
  FROM eqc_virtuemart_category_categories AS `xref`
  WHERE `xref`.`category_child_id`= 3
77. SELECT `slug` as name
  FROM `eqc_virtuemart_categories_en_gb`
  WHERE `virtuemart_category_id`=3
78. SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
  FROM eqc_virtuemart_category_categories AS `xref`
  WHERE `xref`.`category_child_id`= 34
79. SELECT `slug` as name
  FROM `eqc_virtuemart_categories_en_gb`
  WHERE `virtuemart_category_id`=34
80. SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
  FROM eqc_virtuemart_category_categories AS `xref`
  WHERE `xref`.`category_child_id`= 22
81. SELECT `slug` as name
  FROM `eqc_virtuemart_categories_en_gb`
  WHERE `virtuemart_category_id`=22
82. SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
  FROM eqc_virtuemart_category_categories AS `xref`
  WHERE `xref`.`category_child_id`= 24
83. SELECT `slug` as name
  FROM `eqc_virtuemart_categories_en_gb`
  WHERE `virtuemart_category_id`=24
84. SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
  FROM eqc_virtuemart_category_categories AS `xref`
  WHERE `xref`.`category_child_id`= 25
85. SELECT `slug` as name
  FROM `eqc_virtuemart_categories_en_gb`
  WHERE `virtuemart_category_id`=25
86. SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
  FROM eqc_virtuemart_category_categories AS `xref`
  WHERE `xref`.`category_child_id`= 2
87. SELECT `slug` as name
  FROM `eqc_virtuemart_categories_en_gb`
  WHERE `virtuemart_category_id`=2
88. SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
  FROM eqc_virtuemart_category_categories AS `xref`
  WHERE `xref`.`category_child_id`= 64
89. SELECT `slug` as name
  FROM `eqc_virtuemart_categories_en_gb`
  WHERE `virtuemart_category_id`=64
90. SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
  FROM eqc_virtuemart_category_categories AS `xref`
  WHERE `xref`.`category_child_id`= 26
91. SELECT `slug` as name
  FROM `eqc_virtuemart_categories_en_gb`
  WHERE `virtuemart_category_id`=26
92. SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
  FROM eqc_virtuemart_category_categories AS `xref`
  WHERE `xref`.`category_child_id`= 27
93. SELECT `slug` as name
  FROM `eqc_virtuemart_categories_en_gb`
  WHERE `virtuemart_category_id`=27
94. SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
  FROM eqc_virtuemart_category_categories AS `xref`
  WHERE `xref`.`category_child_id`= 41
95. SELECT `slug` as name
  FROM `eqc_virtuemart_categories_en_gb`
  WHERE `virtuemart_category_id`=41
96. SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
  FROM eqc_virtuemart_category_categories AS `xref`
  WHERE `xref`.`category_child_id`= 28
97. SELECT `slug` as name
  FROM `eqc_virtuemart_categories_en_gb`
  WHERE `virtuemart_category_id`=28
98. SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
  FROM eqc_virtuemart_category_categories AS `xref`
  WHERE `xref`.`category_child_id`= 35
99. SELECT `slug` as name
  FROM `eqc_virtuemart_categories_en_gb`
  WHERE `virtuemart_category_id`=35
100. SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
  FROM eqc_virtuemart_category_categories AS `xref`
  WHERE `xref`.`category_child_id`= 40
101. SELECT `slug` as name
  FROM `eqc_virtuemart_categories_en_gb`
  WHERE `virtuemart_category_id`=40
102. SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
  FROM eqc_virtuemart_category_categories AS `xref`
  WHERE `xref`.`category_child_id`= 57
103. SELECT `slug` as name
  FROM `eqc_virtuemart_categories_en_gb`
  WHERE `virtuemart_category_id`=57
104. SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
  FROM eqc_virtuemart_category_categories AS `xref`
  WHERE `xref`.`category_child_id`= 29
105. SELECT `slug` as name
  FROM `eqc_virtuemart_categories_en_gb`
  WHERE `virtuemart_category_id`=29
106. SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
  FROM eqc_virtuemart_category_categories AS `xref`
  WHERE `xref`.`category_child_id`= 30
107. SELECT `slug` as name
  FROM `eqc_virtuemart_categories_en_gb`
  WHERE `virtuemart_category_id`=30
108. SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
  FROM eqc_virtuemart_category_categories AS `xref`
  WHERE `xref`.`category_child_id`= 31
109. SELECT `slug` as name
  FROM `eqc_virtuemart_categories_en_gb`
  WHERE `virtuemart_category_id`=31
110. SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
  FROM eqc_virtuemart_category_categories AS `xref`
  WHERE `xref`.`category_child_id`= 32
111. SELECT `slug` as name
  FROM `eqc_virtuemart_categories_en_gb`
  WHERE `virtuemart_category_id`=32
112. SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
  FROM eqc_virtuemart_category_categories AS `xref`
  WHERE `xref`.`category_child_id`= 60
113. SELECT `slug` as name
  FROM `eqc_virtuemart_categories_en_gb`
  WHERE `virtuemart_category_id`=60
114. SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
  FROM eqc_virtuemart_category_categories AS `xref`
  WHERE `xref`.`category_child_id`= 65
115. SELECT `slug` as name
  FROM `eqc_virtuemart_categories_en_gb`
  WHERE `virtuemart_category_id`=65
116. SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
  FROM eqc_virtuemart_category_categories AS `xref`
  WHERE `xref`.`category_child_id`= 59
117. SELECT `slug` as name
  FROM `eqc_virtuemart_categories_en_gb`
  WHERE `virtuemart_category_id`=59
118. SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
  FROM eqc_virtuemart_category_categories AS `xref`
  WHERE `xref`.`category_child_id`= 33
119. SELECT `slug` as name
  FROM `eqc_virtuemart_categories_en_gb`
  WHERE `virtuemart_category_id`=33
120. SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
  FROM eqc_virtuemart_category_categories AS `xref`
  WHERE `xref`.`category_child_id`= 66
121. SELECT `slug` as name
  FROM `eqc_virtuemart_categories_en_gb`
  WHERE `virtuemart_category_id`=66
122. SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
  FROM eqc_virtuemart_category_categories AS `xref`
  WHERE `xref`.`category_child_id`= 48
123. SELECT `slug` as name
  FROM `eqc_virtuemart_categories_en_gb`
  WHERE `virtuemart_category_id`=48
124. SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
  FROM eqc_virtuemart_category_categories AS `xref`
  WHERE `xref`.`category_child_id`= 49
125. SELECT `slug` as name
  FROM `eqc_virtuemart_categories_en_gb`
  WHERE `virtuemart_category_id`=49
126. SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
  FROM eqc_virtuemart_category_categories AS `xref`
  WHERE `xref`.`category_child_id`= 50
127. SELECT `slug` as name
  FROM `eqc_virtuemart_categories_en_gb`
  WHERE `virtuemart_category_id`=50
128. SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
  FROM eqc_virtuemart_category_categories AS `xref`
  WHERE `xref`.`category_child_id`= 51
129. SELECT `slug` as name
  FROM `eqc_virtuemart_categories_en_gb`
  WHERE `virtuemart_category_id`=51
130. SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
  FROM eqc_virtuemart_category_categories AS `xref`
  WHERE `xref`.`category_child_id`= 67
131. SELECT `slug` as name
  FROM `eqc_virtuemart_categories_en_gb`
  WHERE `virtuemart_category_id`=67
132. SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
  FROM eqc_virtuemart_category_categories AS `xref`
  WHERE `xref`.`category_child_id`= 23
133. SELECT `slug` as name
  FROM `eqc_virtuemart_categories_en_gb`
  WHERE `virtuemart_category_id`=23
134. SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
  FROM eqc_virtuemart_category_categories AS `xref`
  WHERE `xref`.`category_child_id`= 47
135. SELECT `slug` as name
  FROM `eqc_virtuemart_categories_en_gb`
  WHERE `virtuemart_category_id`=47
136. SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
  FROM eqc_virtuemart_category_categories AS `xref`
  WHERE `xref`.`category_child_id`= 36
137. SELECT `slug` as name
  FROM `eqc_virtuemart_categories_en_gb`
  WHERE `virtuemart_category_id`=36
138. SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
  FROM eqc_virtuemart_category_categories AS `xref`
  WHERE `xref`.`category_child_id`= 20
139. SELECT `slug` as name
  FROM `eqc_virtuemart_categories_en_gb`
  WHERE `virtuemart_category_id`=20
140. SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
  FROM eqc_virtuemart_category_categories AS `xref`
  WHERE `xref`.`category_child_id`= 53
141. SELECT `slug` as name
  FROM `eqc_virtuemart_categories_en_gb`
  WHERE `virtuemart_category_id`=53
142. SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
  FROM eqc_virtuemart_category_categories AS `xref`
  WHERE `xref`.`category_child_id`= 54
143. SELECT `slug` as name
  FROM `eqc_virtuemart_categories_en_gb`
  WHERE `virtuemart_category_id`=54
144. SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
  FROM eqc_virtuemart_category_categories AS `xref`
  WHERE `xref`.`category_child_id`= 62
145. SELECT `slug` as name
  FROM `eqc_virtuemart_categories_en_gb`
  WHERE `virtuemart_category_id`=62
146. SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
  FROM eqc_virtuemart_category_categories AS `xref`
  WHERE `xref`.`category_child_id`= 55
147. SELECT `slug` as name
  FROM `eqc_virtuemart_categories_en_gb`
  WHERE `virtuemart_category_id`=55
148. SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
  FROM eqc_virtuemart_category_categories AS `xref`
  WHERE `xref`.`category_child_id`= 61
149. SELECT `slug` as name
  FROM `eqc_virtuemart_categories_en_gb`
  WHERE `virtuemart_category_id`=61
150. SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
  FROM eqc_virtuemart_category_categories AS `xref`
  WHERE `xref`.`category_child_id`= 6
151. SELECT `slug` as name
  FROM `eqc_virtuemart_categories_en_gb`
  WHERE `virtuemart_category_id`=6
152. SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
  FROM eqc_virtuemart_category_categories AS `xref`
  WHERE `xref`.`category_child_id`= 17
153. SELECT `slug` as name
  FROM `eqc_virtuemart_categories_en_gb`
  WHERE `virtuemart_category_id`=17
154. SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
  FROM eqc_virtuemart_category_categories AS `xref`
  WHERE `xref`.`category_child_id`= 43
155. SELECT `slug` as name
  FROM `eqc_virtuemart_categories_en_gb`
  WHERE `virtuemart_category_id`=43
156. SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
  FROM eqc_virtuemart_category_categories AS `xref`
  WHERE `xref`.`category_child_id`= 56
157. SELECT `slug` as name
  FROM `eqc_virtuemart_categories_en_gb`
  WHERE `virtuemart_category_id`=56
158. SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
  FROM eqc_virtuemart_category_categories AS `xref`
  WHERE `xref`.`category_child_id`= 21
159. SELECT `slug` as name
  FROM `eqc_virtuemart_categories_en_gb`
  WHERE `virtuemart_category_id`=21
160. SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
  FROM eqc_virtuemart_category_categories AS `xref`
  WHERE `xref`.`category_child_id`= 5
161. SELECT `slug` as name
  FROM `eqc_virtuemart_categories_en_gb`
  WHERE `virtuemart_category_id`=5
162. SELECT `virtuemart_shoppergroup_id`
  FROM `eqc_virtuemart_vmuser_shoppergroups`
  WHERE `virtuemart_user_id` = "0"
163. SELECT *
  FROM `eqc_virtuemart_shoppergroups`
  WHERE `default` = "2"
  AND (`virtuemart_vendor_id` = "1" OR `shared` = "1")
  AND `published`="1"
164. SELECT l.`virtuemart_product_id`
  FROM `eqc_virtuemart_products_en_gb` as l JOIN `eqc_virtuemart_products` AS p using (`virtuemart_product_id`)
  LEFT JOIN `eqc_virtuemart_product_categories` as pc
  ON p.`virtuemart_product_id` = `pc`.`virtuemart_product_id`
  LEFT JOIN `eqc_virtuemart_categories_en_gb` as c
  ON c.`virtuemart_category_id` = `pc`.`virtuemart_category_id`
  LEFT JOIN `eqc_virtuemart_product_prices` as pp
  ON p.`virtuemart_product_id` = pp.`virtuemart_product_id`
  LEFT JOIN `eqc_virtuemart_product_shoppergroups`
  ON p.`virtuemart_product_id` = `eqc_virtuemart_product_shoppergroups`.`virtuemart_product_id`
  LEFT
  OUTER JOIN `eqc_virtuemart_shoppergroups` as s
  ON s.`virtuemart_shoppergroup_id` = `eqc_virtuemart_product_shoppergroups`.`virtuemart_shoppergroup_id`
  WHERE ( p.`published`="1"
  AND `pc`.`virtuemart_category_id` > 0
  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, 27
165. SELECT `eqc_virtuemart_products_en_gb`.* ,`eqc_virtuemart_products`.* ,`eqc_virtuemart_product_manufacturers`.`virtuemart_manufacturer_id` ,`eqc_virtuemart_product_customfields`.`virtuemart_customfield_id`
  FROM `eqc_virtuemart_products_en_gb` JOIN eqc_virtuemart_products using (`virtuemart_product_id`)
  LEFT JOIN `eqc_virtuemart_product_manufacturers`
  on `eqc_virtuemart_product_manufacturers`.`virtuemart_product_id`=`eqc_virtuemart_products_en_gb`.`virtuemart_product_id`
  LEFT JOIN `eqc_virtuemart_product_customfields`
  on `eqc_virtuemart_product_customfields`.`virtuemart_product_id`=`eqc_virtuemart_products_en_gb`.`virtuemart_product_id`
  WHERE eqc_virtuemart_products_en_gb.`virtuemart_product_id` = "731"
166. SELECT `virtuemart_media_id`
  FROM `eqc_virtuemart_product_medias`
  WHERE `virtuemart_product_id` = "731"
  ORDER BY `ordering`
167. SELECT `virtuemart_shoppergroup_id`
  FROM `eqc_virtuemart_product_shoppergroups`
  WHERE `virtuemart_product_id` = "731"
168. SELECT *
  FROM `eqc_virtuemart_product_prices`
  WHERE `virtuemart_product_id` = "731"
  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` <= "2014-04-20 10:47:15" )
  AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2014-04-20 10:47:15" ) )
  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) )
169. SELECT `eqc_virtuemart_manufacturers_en_gb`.* ,`eqc_virtuemart_manufacturers`.*
  FROM `eqc_virtuemart_manufacturers_en_gb` JOIN eqc_virtuemart_manufacturers using (`virtuemart_manufacturer_id`)
  WHERE eqc_virtuemart_manufacturers_en_gb.`virtuemart_manufacturer_id` = "1"
170. SELECT pc.`virtuemart_category_id`
  FROM `eqc_virtuemart_product_categories` as pc
  WHERE pc.`virtuemart_product_id` = 731
171. SELECT pc.`virtuemart_category_id`
  FROM `eqc_virtuemart_product_categories` as pc
  LEFT JOIN `eqc_virtuemart_categories` as c
  ON c.`virtuemart_category_id` = pc.`virtuemart_category_id`
  WHERE pc.`virtuemart_product_id` = 731
  AND `published`=1
  ORDER BY `c`.`ordering` ASC
172. SELECT `ordering`,`id`
  FROM `eqc_virtuemart_product_categories`
  WHERE `virtuemart_product_id` = "731"
  and `virtuemart_category_id`= "35"
173. SELECT `eqc_virtuemart_categories_en_gb`.* ,`eqc_virtuemart_categories`.*
  FROM `eqc_virtuemart_categories_en_gb` JOIN eqc_virtuemart_categories using (`virtuemart_category_id`)
  WHERE eqc_virtuemart_categories_en_gb.`virtuemart_category_id` = "35"
174. SELECT `vendor_currency`,`currency_code_3`,`currency_numeric_code`
  FROM `eqc_virtuemart_vendors` AS v
  LEFT JOIN `eqc_virtuemart_currencies` AS c
  ON virtuemart_currency_id = vendor_currency
  WHERE v.`virtuemart_vendor_id`="1"
175. SELECT *
  FROM `eqc_virtuemart_currencies`
  WHERE `virtuemart_currency_id`="144"
176. SELECT `price_display`,`custom_price_display`
  FROM `eqc_virtuemart_shoppergroups` AS `sg`
  WHERE `sg`.`default` = "2"
177. SELECT *
  FROM `eqc_virtuemart_shoppergroups`
  WHERE `default` = "2"
  AND (`virtuemart_vendor_id` = "1" OR `shared` = "1")
  AND `published`="1"
178. SELECT *
  FROM eqc_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 <= "2014-04-20 10:47:15" )
  AND ( publish_down = "0000-00-00 00:00:00" OR publish_down >= "2014-04-20 10:47:15" ) OR `for_override` = "1" )
179. SELECT `slug`
  FROM `eqc_virtuemart_products_en_gb`
  WHERE `virtuemart_product_id` = 731
180. SELECT `eqc_virtuemart_products_en_gb`.* ,`eqc_virtuemart_products`.* ,`eqc_virtuemart_product_manufacturers`.`virtuemart_manufacturer_id` ,`eqc_virtuemart_product_customfields`.`virtuemart_customfield_id`
  FROM `eqc_virtuemart_products_en_gb` JOIN eqc_virtuemart_products using (`virtuemart_product_id`)
  LEFT JOIN `eqc_virtuemart_product_manufacturers`
  on `eqc_virtuemart_product_manufacturers`.`virtuemart_product_id`=`eqc_virtuemart_products_en_gb`.`virtuemart_product_id`
  LEFT JOIN `eqc_virtuemart_product_customfields`
  on `eqc_virtuemart_product_customfields`.`virtuemart_product_id`=`eqc_virtuemart_products_en_gb`.`virtuemart_product_id`
  WHERE eqc_virtuemart_products_en_gb.`virtuemart_product_id` = "1366"
181. SELECT `virtuemart_media_id`
  FROM `eqc_virtuemart_product_medias`
  WHERE `virtuemart_product_id` = "1366"
  ORDER BY `ordering`
182. SELECT `virtuemart_shoppergroup_id`
  FROM `eqc_virtuemart_product_shoppergroups`
  WHERE `virtuemart_product_id` = "1366"
183. SELECT *
  FROM `eqc_virtuemart_product_prices`
  WHERE `virtuemart_product_id` = "1366"
  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` <= "2014-04-20 10:47:15" )
  AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2014-04-20 10:47:15" ) )
  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) )
184. SELECT pc.`virtuemart_category_id`
  FROM `eqc_virtuemart_product_categories` as pc
  WHERE pc.`virtuemart_product_id` = 1366
185. SELECT pc.`virtuemart_category_id`
  FROM `eqc_virtuemart_product_categories` as pc
  LEFT JOIN `eqc_virtuemart_categories` as c
  ON c.`virtuemart_category_id` = pc.`virtuemart_category_id`
  WHERE pc.`virtuemart_product_id` = 1366
  AND `published`=1
  ORDER BY `c`.`ordering` ASC
186. SELECT `ordering`,`id`
  FROM `eqc_virtuemart_product_categories`
  WHERE `virtuemart_product_id` = "1366"
  and `virtuemart_category_id`= "56"
187. SELECT `eqc_virtuemart_categories_en_gb`.* ,`eqc_virtuemart_categories`.*
  FROM `eqc_virtuemart_categories_en_gb` JOIN eqc_virtuemart_categories using (`virtuemart_category_id`)
  WHERE eqc_virtuemart_categories_en_gb.`virtuemart_category_id` = "56"
188. SELECT `slug`
  FROM `eqc_virtuemart_products_en_gb`
  WHERE `virtuemart_product_id` = 1366
189. SELECT `eqc_virtuemart_products_en_gb`.* ,`eqc_virtuemart_products`.* ,`eqc_virtuemart_product_manufacturers`.`virtuemart_manufacturer_id` ,`eqc_virtuemart_product_customfields`.`virtuemart_customfield_id`
  FROM `eqc_virtuemart_products_en_gb` JOIN eqc_virtuemart_products using (`virtuemart_product_id`)
  LEFT JOIN `eqc_virtuemart_product_manufacturers`
  on `eqc_virtuemart_product_manufacturers`.`virtuemart_product_id`=`eqc_virtuemart_products_en_gb`.`virtuemart_product_id`
  LEFT JOIN `eqc_virtuemart_product_customfields`
  on `eqc_virtuemart_product_customfields`.`virtuemart_product_id`=`eqc_virtuemart_products_en_gb`.`virtuemart_product_id`
  WHERE eqc_virtuemart_products_en_gb.`virtuemart_product_id` = "1810"
190. SELECT `virtuemart_media_id`
  FROM `eqc_virtuemart_product_medias`
  WHERE `virtuemart_product_id` = "1810"
  ORDER BY `ordering`
191. SELECT `virtuemart_shoppergroup_id`
  FROM `eqc_virtuemart_product_shoppergroups`
  WHERE `virtuemart_product_id` = "1810"
192. SELECT *
  FROM `eqc_virtuemart_product_prices`
  WHERE `virtuemart_product_id` = "1810"
  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` <= "2014-04-20 10:47:15" )
  AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2014-04-20 10:47:15" ) )
  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) )
193. SELECT pc.`virtuemart_category_id`
  FROM `eqc_virtuemart_product_categories` as pc
  WHERE pc.`virtuemart_product_id` = 1810
194. SELECT pc.`virtuemart_category_id`
  FROM `eqc_virtuemart_product_categories` as pc
  LEFT JOIN `eqc_virtuemart_categories` as c
  ON c.`virtuemart_category_id` = pc.`virtuemart_category_id`
  WHERE pc.`virtuemart_product_id` = 1810
  AND `published`=1
  ORDER BY `c`.`ordering` ASC
195. SELECT `ordering`,`id`
  FROM `eqc_virtuemart_product_categories`
  WHERE `virtuemart_product_id` = "1810"
  and `virtuemart_category_id`= "56"
196. SELECT `eqc_virtuemart_categories_en_gb`.* ,`eqc_virtuemart_categories`.*
  FROM `eqc_virtuemart_categories_en_gb` JOIN eqc_virtuemart_categories using (`virtuemart_category_id`)
  WHERE eqc_virtuemart_categories_en_gb.`virtuemart_category_id` = "56"
197. SELECT `slug`
  FROM `eqc_virtuemart_products_en_gb`
  WHERE `virtuemart_product_id` = 1810
198. SELECT `eqc_virtuemart_products_en_gb`.* ,`eqc_virtuemart_products`.* ,`eqc_virtuemart_product_manufacturers`.`virtuemart_manufacturer_id` ,`eqc_virtuemart_product_customfields`.`virtuemart_customfield_id`
  FROM `eqc_virtuemart_products_en_gb` JOIN eqc_virtuemart_products using (`virtuemart_product_id`)
  LEFT JOIN `eqc_virtuemart_product_manufacturers`
  on `eqc_virtuemart_product_manufacturers`.`virtuemart_product_id`=`eqc_virtuemart_products_en_gb`.`virtuemart_product_id`
  LEFT JOIN `eqc_virtuemart_product_customfields`
  on `eqc_virtuemart_product_customfields`.`virtuemart_product_id`=`eqc_virtuemart_products_en_gb`.`virtuemart_product_id`
  WHERE eqc_virtuemart_products_en_gb.`virtuemart_product_id` = "355"
199. SELECT `virtuemart_media_id`
  FROM `eqc_virtuemart_product_medias`
  WHERE `virtuemart_product_id` = "355"
  ORDER BY `ordering`
200. SELECT `virtuemart_shoppergroup_id`
  FROM `eqc_virtuemart_product_shoppergroups`
  WHERE `virtuemart_product_id` = "355"
201. SELECT *
  FROM `eqc_virtuemart_product_prices`
  WHERE `virtuemart_product_id` = "355"
  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` <= "2014-04-20 10:47:15" )
  AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2014-04-20 10:47:15" ) )
  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) )
202. SELECT `eqc_virtuemart_manufacturers_en_gb`.* ,`eqc_virtuemart_manufacturers`.*
  FROM `eqc_virtuemart_manufacturers_en_gb` JOIN eqc_virtuemart_manufacturers using (`virtuemart_manufacturer_id`)
  WHERE eqc_virtuemart_manufacturers_en_gb.`virtuemart_manufacturer_id` = "1"
203. SELECT pc.`virtuemart_category_id`
  FROM `eqc_virtuemart_product_categories` as pc
  WHERE pc.`virtuemart_product_id` = 355
204. SELECT pc.`virtuemart_category_id`
  FROM `eqc_virtuemart_product_categories` as pc
  LEFT JOIN `eqc_virtuemart_categories` as c
  ON c.`virtuemart_category_id` = pc.`virtuemart_category_id`
  WHERE pc.`virtuemart_product_id` = 355
  AND `published`=1
  ORDER BY `c`.`ordering` ASC
205. SELECT `ordering`,`id`
  FROM `eqc_virtuemart_product_categories`
  WHERE `virtuemart_product_id` = "355"
  and `virtuemart_category_id`= "14"
206. SELECT `eqc_virtuemart_categories_en_gb`.* ,`eqc_virtuemart_categories`.*
  FROM `eqc_virtuemart_categories_en_gb` JOIN eqc_virtuemart_categories using (`virtuemart_category_id`)
  WHERE eqc_virtuemart_categories_en_gb.`virtuemart_category_id` = "14"
207. SELECT `slug`
  FROM `eqc_virtuemart_products_en_gb`
  WHERE `virtuemart_product_id` = 355
208. SELECT `eqc_virtuemart_products_en_gb`.* ,`eqc_virtuemart_products`.* ,`eqc_virtuemart_product_manufacturers`.`virtuemart_manufacturer_id` ,`eqc_virtuemart_product_customfields`.`virtuemart_customfield_id`
  FROM `eqc_virtuemart_products_en_gb` JOIN eqc_virtuemart_products using (`virtuemart_product_id`)
  LEFT JOIN `eqc_virtuemart_product_manufacturers`
  on `eqc_virtuemart_product_manufacturers`.`virtuemart_product_id`=`eqc_virtuemart_products_en_gb`.`virtuemart_product_id`
  LEFT JOIN `eqc_virtuemart_product_customfields`
  on `eqc_virtuemart_product_customfields`.`virtuemart_product_id`=`eqc_virtuemart_products_en_gb`.`virtuemart_product_id`
  WHERE eqc_virtuemart_products_en_gb.`virtuemart_product_id` = "1393"
209. SELECT `virtuemart_media_id`
  FROM `eqc_virtuemart_product_medias`
  WHERE `virtuemart_product_id` = "1393"
  ORDER BY `ordering`
210. SELECT `virtuemart_shoppergroup_id`
  FROM `eqc_virtuemart_product_shoppergroups`
  WHERE `virtuemart_product_id` = "1393"
211. SELECT *
  FROM `eqc_virtuemart_product_prices`
  WHERE `virtuemart_product_id` = "1393"
  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` <= "2014-04-20 10:47:15" )
  AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2014-04-20 10:47:15" ) )
  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) )
212. SELECT pc.`virtuemart_category_id`
  FROM `eqc_virtuemart_product_categories` as pc
  WHERE pc.`virtuemart_product_id` = 1393
213. SELECT pc.`virtuemart_category_id`
  FROM `eqc_virtuemart_product_categories` as pc
  LEFT JOIN `eqc_virtuemart_categories` as c
  ON c.`virtuemart_category_id` = pc.`virtuemart_category_id`
  WHERE pc.`virtuemart_product_id` = 1393
  AND `published`=1
  ORDER BY `c`.`ordering` ASC
214. SELECT `ordering`,`id`
  FROM `eqc_virtuemart_product_categories`
  WHERE `virtuemart_product_id` = "1393"
  and `virtuemart_category_id`= "57"
215. SELECT `eqc_virtuemart_categories_en_gb`.* ,`eqc_virtuemart_categories`.*
  FROM `eqc_virtuemart_categories_en_gb` JOIN eqc_virtuemart_categories using (`virtuemart_category_id`)
  WHERE eqc_virtuemart_categories_en_gb.`virtuemart_category_id` = "57"
216. SELECT `slug`
  FROM `eqc_virtuemart_products_en_gb`
  WHERE `virtuemart_product_id` = 1393
217. SELECT `eqc_virtuemart_products_en_gb`.* ,`eqc_virtuemart_products`.* ,`eqc_virtuemart_product_manufacturers`.`virtuemart_manufacturer_id` ,`eqc_virtuemart_product_customfields`.`virtuemart_customfield_id`
  FROM `eqc_virtuemart_products_en_gb` JOIN eqc_virtuemart_products using (`virtuemart_product_id`)
  LEFT JOIN `eqc_virtuemart_product_manufacturers`
  on `eqc_virtuemart_product_manufacturers`.`virtuemart_product_id`=`eqc_virtuemart_products_en_gb`.`virtuemart_product_id`
  LEFT JOIN `eqc_virtuemart_product_customfields`
  on `eqc_virtuemart_product_customfields`.`virtuemart_product_id`=`eqc_virtuemart_products_en_gb`.`virtuemart_product_id`
  WHERE eqc_virtuemart_products_en_gb.`virtuemart_product_id` = "1674"
218. SELECT `virtuemart_media_id`
  FROM `eqc_virtuemart_product_medias`
  WHERE `virtuemart_product_id` = "1674"
  ORDER BY `ordering`
219. SELECT `virtuemart_shoppergroup_id`
  FROM `eqc_virtuemart_product_shoppergroups`
  WHERE `virtuemart_product_id` = "1674"
220. SELECT *
  FROM `eqc_virtuemart_product_prices`
  WHERE `virtuemart_product_id` = "1674"
  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` <= "2014-04-20 10:47:15" )
  AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2014-04-20 10:47:15" ) )
  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) )
221. SELECT pc.`virtuemart_category_id`
  FROM `eqc_virtuemart_product_categories` as pc
  WHERE pc.`virtuemart_product_id` = 1674
222. SELECT pc.`virtuemart_category_id`
  FROM `eqc_virtuemart_product_categories` as pc
  LEFT JOIN `eqc_virtuemart_categories` as c
  ON c.`virtuemart_category_id` = pc.`virtuemart_category_id`
  WHERE pc.`virtuemart_product_id` = 1674
  AND `published`=1
  ORDER BY `c`.`ordering` ASC
223. SELECT `ordering`,`id`
  FROM `eqc_virtuemart_product_categories`
  WHERE `virtuemart_product_id` = "1674"
  and `virtuemart_category_id`= "13"
224. SELECT `eqc_virtuemart_categories_en_gb`.* ,`eqc_virtuemart_categories`.*
  FROM `eqc_virtuemart_categories_en_gb` JOIN eqc_virtuemart_categories using (`virtuemart_category_id`)
  WHERE eqc_virtuemart_categories_en_gb.`virtuemart_category_id` = "13"
225. SELECT `slug`
  FROM `eqc_virtuemart_products_en_gb`
  WHERE `virtuemart_product_id` = 1674
226. SELECT `eqc_virtuemart_products_en_gb`.* ,`eqc_virtuemart_products`.* ,`eqc_virtuemart_product_manufacturers`.`virtuemart_manufacturer_id` ,`eqc_virtuemart_product_customfields`.`virtuemart_customfield_id`
  FROM `eqc_virtuemart_products_en_gb` JOIN eqc_virtuemart_products using (`virtuemart_product_id`)
  LEFT JOIN `eqc_virtuemart_product_manufacturers`
  on `eqc_virtuemart_product_manufacturers`.`virtuemart_product_id`=`eqc_virtuemart_products_en_gb`.`virtuemart_product_id`
  LEFT JOIN `eqc_virtuemart_product_customfields`
  on `eqc_virtuemart_product_customfields`.`virtuemart_product_id`=`eqc_virtuemart_products_en_gb`.`virtuemart_product_id`
  WHERE eqc_virtuemart_products_en_gb.`virtuemart_product_id` = "1336"
227. SELECT `virtuemart_media_id`
  FROM `eqc_virtuemart_product_medias`
  WHERE `virtuemart_product_id` = "1336"
  ORDER BY `ordering`
228. SELECT `virtuemart_shoppergroup_id`
  FROM `eqc_virtuemart_product_shoppergroups`
  WHERE `virtuemart_product_id` = "1336"
229. SELECT *
  FROM `eqc_virtuemart_product_prices`
  WHERE `virtuemart_product_id` = "1336"
  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` <= "2014-04-20 10:47:15" )
  AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2014-04-20 10:47:15" ) )
  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) )
230. SELECT `eqc_virtuemart_manufacturers_en_gb`.* ,`eqc_virtuemart_manufacturers`.*
  FROM `eqc_virtuemart_manufacturers_en_gb` JOIN eqc_virtuemart_manufacturers using (`virtuemart_manufacturer_id`)
  WHERE eqc_virtuemart_manufacturers_en_gb.`virtuemart_manufacturer_id` = "1"
231. SELECT pc.`virtuemart_category_id`
  FROM `eqc_virtuemart_product_categories` as pc
  WHERE pc.`virtuemart_product_id` = 1336
232. SELECT pc.`virtuemart_category_id`
  FROM `eqc_virtuemart_product_categories` as pc
  LEFT JOIN `eqc_virtuemart_categories` as c
  ON c.`virtuemart_category_id` = pc.`virtuemart_category_id`
  WHERE pc.`virtuemart_product_id` = 1336
  AND `published`=1
  ORDER BY `c`.`ordering` ASC
233. SELECT `ordering`,`id`
  FROM `eqc_virtuemart_product_categories`
  WHERE `virtuemart_product_id` = "1336"
  and `virtuemart_category_id`= "57"
234. SELECT `eqc_virtuemart_categories_en_gb`.* ,`eqc_virtuemart_categories`.*
  FROM `eqc_virtuemart_categories_en_gb` JOIN eqc_virtuemart_categories using (`virtuemart_category_id`)
  WHERE eqc_virtuemart_categories_en_gb.`virtuemart_category_id` = "57"
235. SELECT `slug`
  FROM `eqc_virtuemart_products_en_gb`
  WHERE `virtuemart_product_id` = 1336
236. SELECT `eqc_virtuemart_products_en_gb`.* ,`eqc_virtuemart_products`.* ,`eqc_virtuemart_product_manufacturers`.`virtuemart_manufacturer_id` ,`eqc_virtuemart_product_customfields`.`virtuemart_customfield_id`
  FROM `eqc_virtuemart_products_en_gb` JOIN eqc_virtuemart_products using (`virtuemart_product_id`)
  LEFT JOIN `eqc_virtuemart_product_manufacturers`
  on `eqc_virtuemart_product_manufacturers`.`virtuemart_product_id`=`eqc_virtuemart_products_en_gb`.`virtuemart_product_id`
  LEFT JOIN `eqc_virtuemart_product_customfields`
  on `eqc_virtuemart_product_customfields`.`virtuemart_product_id`=`eqc_virtuemart_products_en_gb`.`virtuemart_product_id`
  WHERE eqc_virtuemart_products_en_gb.`virtuemart_product_id` = "250"
237. SELECT `virtuemart_media_id`
  FROM `eqc_virtuemart_product_medias`
  WHERE `virtuemart_product_id` = "250"
  ORDER BY `ordering`
238. SELECT `virtuemart_shoppergroup_id`
  FROM `eqc_virtuemart_product_shoppergroups`
  WHERE `virtuemart_product_id` = "250"
239. SELECT *
  FROM `eqc_virtuemart_product_prices`
  WHERE `virtuemart_product_id` = "250"
  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` <= "2014-04-20 10:47:15" )
  AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2014-04-20 10:47:15" ) )
  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 `eqc_virtuemart_manufacturers_en_gb`.* ,`eqc_virtuemart_manufacturers`.*
  FROM `eqc_virtuemart_manufacturers_en_gb` JOIN eqc_virtuemart_manufacturers using (`virtuemart_manufacturer_id`)
  WHERE eqc_virtuemart_manufacturers_en_gb.`virtuemart_manufacturer_id` = "1"
241. SELECT pc.`virtuemart_category_id`
  FROM `eqc_virtuemart_product_categories` as pc
  WHERE pc.`virtuemart_product_id` = 250
242. SELECT pc.`virtuemart_category_id`
  FROM `eqc_virtuemart_product_categories` as pc
  LEFT JOIN `eqc_virtuemart_categories` as c
  ON c.`virtuemart_category_id` = pc.`virtuemart_category_id`
  WHERE pc.`virtuemart_product_id` = 250
  AND `published`=1
  ORDER BY `c`.`ordering` ASC
243. SELECT `ordering`,`id`
  FROM `eqc_virtuemart_product_categories`
  WHERE `virtuemart_product_id` = "250"
  and `virtuemart_category_id`= "4"
244. SELECT `eqc_virtuemart_categories_en_gb`.* ,`eqc_virtuemart_categories`.*
  FROM `eqc_virtuemart_categories_en_gb` JOIN eqc_virtuemart_categories using (`virtuemart_category_id`)
  WHERE eqc_virtuemart_categories_en_gb.`virtuemart_category_id` = "4"
245. SELECT `slug`
  FROM `eqc_virtuemart_products_en_gb`
  WHERE `virtuemart_product_id` = 250
246. SELECT `eqc_virtuemart_products_en_gb`.* ,`eqc_virtuemart_products`.* ,`eqc_virtuemart_product_manufacturers`.`virtuemart_manufacturer_id` ,`eqc_virtuemart_product_customfields`.`virtuemart_customfield_id`
  FROM `eqc_virtuemart_products_en_gb` JOIN eqc_virtuemart_products using (`virtuemart_product_id`)
  LEFT JOIN `eqc_virtuemart_product_manufacturers`
  on `eqc_virtuemart_product_manufacturers`.`virtuemart_product_id`=`eqc_virtuemart_products_en_gb`.`virtuemart_product_id`
  LEFT JOIN `eqc_virtuemart_product_customfields`
  on `eqc_virtuemart_product_customfields`.`virtuemart_product_id`=`eqc_virtuemart_products_en_gb`.`virtuemart_product_id`
  WHERE eqc_virtuemart_products_en_gb.`virtuemart_product_id` = "367"
247. SELECT `virtuemart_media_id`
  FROM `eqc_virtuemart_product_medias`
  WHERE `virtuemart_product_id` = "367"
  ORDER BY `ordering`
248. SELECT `virtuemart_shoppergroup_id`
  FROM `eqc_virtuemart_product_shoppergroups`
  WHERE `virtuemart_product_id` = "367"
249. SELECT *
  FROM `eqc_virtuemart_product_prices`
  WHERE `virtuemart_product_id` = "367"
  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` <= "2014-04-20 10:47:15" )
  AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2014-04-20 10:47:15" ) )
  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) )
250. SELECT `eqc_virtuemart_manufacturers_en_gb`.* ,`eqc_virtuemart_manufacturers`.*
  FROM `eqc_virtuemart_manufacturers_en_gb` JOIN eqc_virtuemart_manufacturers using (`virtuemart_manufacturer_id`)
  WHERE eqc_virtuemart_manufacturers_en_gb.`virtuemart_manufacturer_id` = "1"
251. SELECT pc.`virtuemart_category_id`
  FROM `eqc_virtuemart_product_categories` as pc
  WHERE pc.`virtuemart_product_id` = 367
252. SELECT pc.`virtuemart_category_id`
  FROM `eqc_virtuemart_product_categories` as pc
  LEFT JOIN `eqc_virtuemart_categories` as c
  ON c.`virtuemart_category_id` = pc.`virtuemart_category_id`
  WHERE pc.`virtuemart_product_id` = 367
  AND `published`=1
  ORDER BY `c`.`ordering` ASC
253. SELECT `ordering`,`id`
  FROM `eqc_virtuemart_product_categories`
  WHERE `virtuemart_product_id` = "367"
  and `virtuemart_category_id`= "14"
254. SELECT `eqc_virtuemart_categories_en_gb`.* ,`eqc_virtuemart_categories`.*
  FROM `eqc_virtuemart_categories_en_gb` JOIN eqc_virtuemart_categories using (`virtuemart_category_id`)
  WHERE eqc_virtuemart_categories_en_gb.`virtuemart_category_id` = "14"
255. SELECT `slug`
  FROM `eqc_virtuemart_products_en_gb`
  WHERE `virtuemart_product_id` = 367
256. SELECT `eqc_virtuemart_products_en_gb`.* ,`eqc_virtuemart_products`.* ,`eqc_virtuemart_product_manufacturers`.`virtuemart_manufacturer_id` ,`eqc_virtuemart_product_customfields`.`virtuemart_customfield_id`
  FROM `eqc_virtuemart_products_en_gb` JOIN eqc_virtuemart_products using (`virtuemart_product_id`)
  LEFT JOIN `eqc_virtuemart_product_manufacturers`
  on `eqc_virtuemart_product_manufacturers`.`virtuemart_product_id`=`eqc_virtuemart_products_en_gb`.`virtuemart_product_id`
  LEFT JOIN `eqc_virtuemart_product_customfields`
  on `eqc_virtuemart_product_customfields`.`virtuemart_product_id`=`eqc_virtuemart_products_en_gb`.`virtuemart_product_id`
  WHERE eqc_virtuemart_products_en_gb.`virtuemart_product_id` = "1518"
257. SELECT `virtuemart_media_id`
  FROM `eqc_virtuemart_product_medias`
  WHERE `virtuemart_product_id` = "1518"
  ORDER BY `ordering`
258. SELECT `virtuemart_shoppergroup_id`
  FROM `eqc_virtuemart_product_shoppergroups`
  WHERE `virtuemart_product_id` = "1518"
259. SELECT *
  FROM `eqc_virtuemart_product_prices`
  WHERE `virtuemart_product_id` = "1518"
  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` <= "2014-04-20 10:47:15" )
  AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2014-04-20 10:47:15" ) )
  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) )
260. SELECT pc.`virtuemart_category_id`
  FROM `eqc_virtuemart_product_categories` as pc
  WHERE pc.`virtuemart_product_id` = 1518
261. SELECT pc.`virtuemart_category_id`
  FROM `eqc_virtuemart_product_categories` as pc
  LEFT JOIN `eqc_virtuemart_categories` as c
  ON c.`virtuemart_category_id` = pc.`virtuemart_category_id`
  WHERE pc.`virtuemart_product_id` = 1518
  AND `published`=1
  ORDER BY `c`.`ordering` ASC
262. SELECT `ordering`,`id`
  FROM `eqc_virtuemart_product_categories`
  WHERE `virtuemart_product_id` = "1518"
  and `virtuemart_category_id`= "46"
263. SELECT `eqc_virtuemart_categories_en_gb`.* ,`eqc_virtuemart_categories`.*
  FROM `eqc_virtuemart_categories_en_gb` JOIN eqc_virtuemart_categories using (`virtuemart_category_id`)
  WHERE eqc_virtuemart_categories_en_gb.`virtuemart_category_id` = "46"
264. SELECT `slug`
  FROM `eqc_virtuemart_products_en_gb`
  WHERE `virtuemart_product_id` = 1518
265. SELECT `eqc_virtuemart_products_en_gb`.* ,`eqc_virtuemart_products`.* ,`eqc_virtuemart_product_manufacturers`.`virtuemart_manufacturer_id` ,`eqc_virtuemart_product_customfields`.`virtuemart_customfield_id`
  FROM `eqc_virtuemart_products_en_gb` JOIN eqc_virtuemart_products using (`virtuemart_product_id`)
  LEFT JOIN `eqc_virtuemart_product_manufacturers`
  on `eqc_virtuemart_product_manufacturers`.`virtuemart_product_id`=`eqc_virtuemart_products_en_gb`.`virtuemart_product_id`
  LEFT JOIN `eqc_virtuemart_product_customfields`
  on `eqc_virtuemart_product_customfields`.`virtuemart_product_id`=`eqc_virtuemart_products_en_gb`.`virtuemart_product_id`
  WHERE eqc_virtuemart_products_en_gb.`virtuemart_product_id` = "646"
266. SELECT `virtuemart_media_id`
  FROM `eqc_virtuemart_product_medias`
  WHERE `virtuemart_product_id` = "646"
  ORDER BY `ordering`
267. SELECT `virtuemart_shoppergroup_id`
  FROM `eqc_virtuemart_product_shoppergroups`
  WHERE `virtuemart_product_id` = "646"
268. SELECT *
  FROM `eqc_virtuemart_product_prices`
  WHERE `virtuemart_product_id` = "646"
  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` <= "2014-04-20 10:47:15" )
  AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2014-04-20 10:47:15" ) )
  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) )
269. SELECT `eqc_virtuemart_manufacturers_en_gb`.* ,`eqc_virtuemart_manufacturers`.*
  FROM `eqc_virtuemart_manufacturers_en_gb` JOIN eqc_virtuemart_manufacturers using (`virtuemart_manufacturer_id`)
  WHERE eqc_virtuemart_manufacturers_en_gb.`virtuemart_manufacturer_id` = "1"
270. SELECT pc.`virtuemart_category_id`
  FROM `eqc_virtuemart_product_categories` as pc
  WHERE pc.`virtuemart_product_id` = 646
271. SELECT pc.`virtuemart_category_id`
  FROM `eqc_virtuemart_product_categories` as pc
  LEFT JOIN `eqc_virtuemart_categories` as c
  ON c.`virtuemart_category_id` = pc.`virtuemart_category_id`
  WHERE pc.`virtuemart_product_id` = 646
  AND `published`=1
  ORDER BY `c`.`ordering` ASC
272. SELECT `ordering`,`id`
  FROM `eqc_virtuemart_product_categories`
  WHERE `virtuemart_product_id` = "646"
  and `virtuemart_category_id`= "7"
273. SELECT `eqc_virtuemart_categories_en_gb`.* ,`eqc_virtuemart_categories`.*
  FROM `eqc_virtuemart_categories_en_gb` JOIN eqc_virtuemart_categories using (`virtuemart_category_id`)
  WHERE eqc_virtuemart_categories_en_gb.`virtuemart_category_id` = "7"
274. SELECT `slug`
  FROM `eqc_virtuemart_products_en_gb`
  WHERE `virtuemart_product_id` = 646
275. SELECT `eqc_virtuemart_products_en_gb`.* ,`eqc_virtuemart_products`.* ,`eqc_virtuemart_product_manufacturers`.`virtuemart_manufacturer_id` ,`eqc_virtuemart_product_customfields`.`virtuemart_customfield_id`
  FROM `eqc_virtuemart_products_en_gb` JOIN eqc_virtuemart_products using (`virtuemart_product_id`)
  LEFT JOIN `eqc_virtuemart_product_manufacturers`
  on `eqc_virtuemart_product_manufacturers`.`virtuemart_product_id`=`eqc_virtuemart_products_en_gb`.`virtuemart_product_id`
  LEFT JOIN `eqc_virtuemart_product_customfields`
  on `eqc_virtuemart_product_customfields`.`virtuemart_product_id`=`eqc_virtuemart_products_en_gb`.`virtuemart_product_id`
  WHERE eqc_virtuemart_products_en_gb.`virtuemart_product_id` = "1811"
276. SELECT `virtuemart_media_id`
  FROM `eqc_virtuemart_product_medias`
  WHERE `virtuemart_product_id` = "1811"
  ORDER BY `ordering`
277. SELECT `virtuemart_shoppergroup_id`
  FROM `eqc_virtuemart_product_shoppergroups`
  WHERE `virtuemart_product_id` = "1811"
278. SELECT *
  FROM `eqc_virtuemart_product_prices`
  WHERE `virtuemart_product_id` = "1811"
  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` <= "2014-04-20 10:47:15" )
  AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2014-04-20 10:47:15" ) )
  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) )
279. SELECT pc.`virtuemart_category_id`
  FROM `eqc_virtuemart_product_categories` as pc
  WHERE pc.`virtuemart_product_id` = 1811
280. SELECT pc.`virtuemart_category_id`
  FROM `eqc_virtuemart_product_categories` as pc
  LEFT JOIN `eqc_virtuemart_categories` as c
  ON c.`virtuemart_category_id` = pc.`virtuemart_category_id`
  WHERE pc.`virtuemart_product_id` = 1811
  AND `published`=1
  ORDER BY `c`.`ordering` ASC
281. SELECT `ordering`,`id`
  FROM `eqc_virtuemart_product_categories`
  WHERE `virtuemart_product_id` = "1811"
  and `virtuemart_category_id`= "56"
282. SELECT `eqc_virtuemart_categories_en_gb`.* ,`eqc_virtuemart_categories`.*
  FROM `eqc_virtuemart_categories_en_gb` JOIN eqc_virtuemart_categories using (`virtuemart_category_id`)
  WHERE eqc_virtuemart_categories_en_gb.`virtuemart_category_id` = "56"
283. SELECT `slug`
  FROM `eqc_virtuemart_products_en_gb`
  WHERE `virtuemart_product_id` = 1811
284. SELECT `eqc_virtuemart_products_en_gb`.* ,`eqc_virtuemart_products`.* ,`eqc_virtuemart_product_manufacturers`.`virtuemart_manufacturer_id` ,`eqc_virtuemart_product_customfields`.`virtuemart_customfield_id`
  FROM `eqc_virtuemart_products_en_gb` JOIN eqc_virtuemart_products using (`virtuemart_product_id`)
  LEFT JOIN `eqc_virtuemart_product_manufacturers`
  on `eqc_virtuemart_product_manufacturers`.`virtuemart_product_id`=`eqc_virtuemart_products_en_gb`.`virtuemart_product_id`
  LEFT JOIN `eqc_virtuemart_product_customfields`
  on `eqc_virtuemart_product_customfields`.`virtuemart_product_id`=`eqc_virtuemart_products_en_gb`.`virtuemart_product_id`
  WHERE eqc_virtuemart_products_en_gb.`virtuemart_product_id` = "1048"
285. SELECT `virtuemart_media_id`
  FROM `eqc_virtuemart_product_medias`
  WHERE `virtuemart_product_id` = "1048"
  ORDER BY `ordering`
286. SELECT `virtuemart_shoppergroup_id`
  FROM `eqc_virtuemart_product_shoppergroups`
  WHERE `virtuemart_product_id` = "1048"
287. SELECT *
  FROM `eqc_virtuemart_product_prices`
  WHERE `virtuemart_product_id` = "1048"
  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` <= "2014-04-20 10:47:15" )
  AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2014-04-20 10:47:15" ) )
  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) )
288. SELECT `eqc_virtuemart_manufacturers_en_gb`.* ,`eqc_virtuemart_manufacturers`.*
  FROM `eqc_virtuemart_manufacturers_en_gb` JOIN eqc_virtuemart_manufacturers using (`virtuemart_manufacturer_id`)
  WHERE eqc_virtuemart_manufacturers_en_gb.`virtuemart_manufacturer_id` = "1"
289. SELECT pc.`virtuemart_category_id`
  FROM `eqc_virtuemart_product_categories` as pc
  WHERE pc.`virtuemart_product_id` = 1048
290. SELECT pc.`virtuemart_category_id`
  FROM `eqc_virtuemart_product_categories` as pc
  LEFT JOIN `eqc_virtuemart_categories` as c
  ON c.`virtuemart_category_id` = pc.`virtuemart_category_id`
  WHERE pc.`virtuemart_product_id` = 1048
  AND `published`=1
  ORDER BY `c`.`ordering` ASC
291. SELECT `ordering`,`id`
  FROM `eqc_virtuemart_product_categories`
  WHERE `virtuemart_product_id` = "1048"
  and `virtuemart_category_id`= "10"
292. SELECT `eqc_virtuemart_categories_en_gb`.* ,`eqc_virtuemart_categories`.*
  FROM `eqc_virtuemart_categories_en_gb` JOIN eqc_virtuemart_categories using (`virtuemart_category_id`)
  WHERE eqc_virtuemart_categories_en_gb.`virtuemart_category_id` = "10"
293. SELECT `slug`
  FROM `eqc_virtuemart_products_en_gb`
  WHERE `virtuemart_product_id` = 1048
294. SELECT `eqc_virtuemart_products_en_gb`.* ,`eqc_virtuemart_products`.* ,`eqc_virtuemart_product_manufacturers`.`virtuemart_manufacturer_id` ,`eqc_virtuemart_product_customfields`.`virtuemart_customfield_id`
  FROM `eqc_virtuemart_products_en_gb` JOIN eqc_virtuemart_products using (`virtuemart_product_id`)
  LEFT JOIN `eqc_virtuemart_product_manufacturers`
  on `eqc_virtuemart_product_manufacturers`.`virtuemart_product_id`=`eqc_virtuemart_products_en_gb`.`virtuemart_product_id`
  LEFT JOIN `eqc_virtuemart_product_customfields`
  on `eqc_virtuemart_product_customfields`.`virtuemart_product_id`=`eqc_virtuemart_products_en_gb`.`virtuemart_product_id`
  WHERE eqc_virtuemart_products_en_gb.`virtuemart_product_id` = "405"
295. SELECT `virtuemart_media_id`
  FROM `eqc_virtuemart_product_medias`
  WHERE `virtuemart_product_id` = "405"
  ORDER BY `ordering`
296. SELECT `virtuemart_shoppergroup_id`
  FROM `eqc_virtuemart_product_shoppergroups`
  WHERE `virtuemart_product_id` = "405"
297. SELECT *
  FROM `eqc_virtuemart_product_prices`
  WHERE `virtuemart_product_id` = "405"
  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` <= "2014-04-20 10:47:15" )
  AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2014-04-20 10:47:15" ) )
  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) )
298. SELECT `eqc_virtuemart_manufacturers_en_gb`.* ,`eqc_virtuemart_manufacturers`.*
  FROM `eqc_virtuemart_manufacturers_en_gb` JOIN eqc_virtuemart_manufacturers using (`virtuemart_manufacturer_id`)
  WHERE eqc_virtuemart_manufacturers_en_gb.`virtuemart_manufacturer_id` = "1"
299. SELECT pc.`virtuemart_category_id`
  FROM `eqc_virtuemart_product_categories` as pc
  WHERE pc.`virtuemart_product_id` = 405
300. SELECT pc.`virtuemart_category_id`
  FROM `eqc_virtuemart_product_categories` as pc
  LEFT JOIN `eqc_virtuemart_categories` as c
  ON c.`virtuemart_category_id` = pc.`virtuemart_category_id`
  WHERE pc.`virtuemart_product_id` = 405
  AND `published`=1
  ORDER BY `c`.`ordering` ASC
301. SELECT `ordering`,`id`
  FROM `eqc_virtuemart_product_categories`
  WHERE `virtuemart_product_id` = "405"
  and `virtuemart_category_id`= "19"
302. SELECT `eqc_virtuemart_categories_en_gb`.* ,`eqc_virtuemart_categories`.*
  FROM `eqc_virtuemart_categories_en_gb` JOIN eqc_virtuemart_categories using (`virtuemart_category_id`)
  WHERE eqc_virtuemart_categories_en_gb.`virtuemart_category_id` = "19"
303. SELECT `slug`
  FROM `eqc_virtuemart_products_en_gb`
  WHERE `virtuemart_product_id` = 405
304. SELECT `eqc_virtuemart_products_en_gb`.* ,`eqc_virtuemart_products`.* ,`eqc_virtuemart_product_manufacturers`.`virtuemart_manufacturer_id` ,`eqc_virtuemart_product_customfields`.`virtuemart_customfield_id`
  FROM `eqc_virtuemart_products_en_gb` JOIN eqc_virtuemart_products using (`virtuemart_product_id`)
  LEFT JOIN `eqc_virtuemart_product_manufacturers`
  on `eqc_virtuemart_product_manufacturers`.`virtuemart_product_id`=`eqc_virtuemart_products_en_gb`.`virtuemart_product_id`
  LEFT JOIN `eqc_virtuemart_product_customfields`
  on `eqc_virtuemart_product_customfields`.`virtuemart_product_id`=`eqc_virtuemart_products_en_gb`.`virtuemart_product_id`
  WHERE eqc_virtuemart_products_en_gb.`virtuemart_product_id` = "1467"
305. SELECT `virtuemart_media_id`
  FROM `eqc_virtuemart_product_medias`
  WHERE `virtuemart_product_id` = "1467"
  ORDER BY `ordering`
306. SELECT `virtuemart_shoppergroup_id`
  FROM `eqc_virtuemart_product_shoppergroups`
  WHERE `virtuemart_product_id` = "1467"
307. SELECT *
  FROM `eqc_virtuemart_product_prices`
  WHERE `virtuemart_product_id` = "1467"
  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` <= "2014-04-20 10:47:15" )
  AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2014-04-20 10:47:15" ) )
  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) )
308. SELECT pc.`virtuemart_category_id`
  FROM `eqc_virtuemart_product_categories` as pc
  WHERE pc.`virtuemart_product_id` = 1467
309. SELECT pc.`virtuemart_category_id`
  FROM `eqc_virtuemart_product_categories` as pc
  LEFT JOIN `eqc_virtuemart_categories` as c
  ON c.`virtuemart_category_id` = pc.`virtuemart_category_id`
  WHERE pc.`virtuemart_product_id` = 1467
  AND `published`=1
  ORDER BY `c`.`ordering` ASC
310. SELECT `ordering`,`id`
  FROM `eqc_virtuemart_product_categories`
  WHERE `virtuemart_product_id` = "1467"
  and `virtuemart_category_id`= "21"
311. SELECT `eqc_virtuemart_categories_en_gb`.* ,`eqc_virtuemart_categories`.*
  FROM `eqc_virtuemart_categories_en_gb` JOIN eqc_virtuemart_categories using (`virtuemart_category_id`)
  WHERE eqc_virtuemart_categories_en_gb.`virtuemart_category_id` = "21"
312. SELECT `slug`
  FROM `eqc_virtuemart_products_en_gb`
  WHERE `virtuemart_product_id` = 1467
313. SELECT `eqc_virtuemart_products_en_gb`.* ,`eqc_virtuemart_products`.* ,`eqc_virtuemart_product_manufacturers`.`virtuemart_manufacturer_id` ,`eqc_virtuemart_product_customfields`.`virtuemart_customfield_id`
  FROM `eqc_virtuemart_products_en_gb` JOIN eqc_virtuemart_products using (`virtuemart_product_id`)
  LEFT JOIN `eqc_virtuemart_product_manufacturers`
  on `eqc_virtuemart_product_manufacturers`.`virtuemart_product_id`=`eqc_virtuemart_products_en_gb`.`virtuemart_product_id`
  LEFT JOIN `eqc_virtuemart_product_customfields`
  on `eqc_virtuemart_product_customfields`.`virtuemart_product_id`=`eqc_virtuemart_products_en_gb`.`virtuemart_product_id`
  WHERE eqc_virtuemart_products_en_gb.`virtuemart_product_id` = "781"
314. SELECT `virtuemart_media_id`
  FROM `eqc_virtuemart_product_medias`
  WHERE `virtuemart_product_id` = "781"
  ORDER BY `ordering`
315. SELECT `virtuemart_shoppergroup_id`
  FROM `eqc_virtuemart_product_shoppergroups`
  WHERE `virtuemart_product_id` = "781"
316. SELECT *
  FROM `eqc_virtuemart_product_prices`
  WHERE `virtuemart_product_id` = "781"
  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` <= "2014-04-20 10:47:15" )
  AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2014-04-20 10:47:15" ) )
  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) )
317. SELECT `eqc_virtuemart_manufacturers_en_gb`.* ,`eqc_virtuemart_manufacturers`.*
  FROM `eqc_virtuemart_manufacturers_en_gb` JOIN eqc_virtuemart_manufacturers using (`virtuemart_manufacturer_id`)
  WHERE eqc_virtuemart_manufacturers_en_gb.`virtuemart_manufacturer_id` = "1"
318. SELECT pc.`virtuemart_category_id`
  FROM `eqc_virtuemart_product_categories` as pc
  WHERE pc.`virtuemart_product_id` = 781
319. SELECT pc.`virtuemart_category_id`
  FROM `eqc_virtuemart_product_categories` as pc
  LEFT JOIN `eqc_virtuemart_categories` as c
  ON c.`virtuemart_category_id` = pc.`virtuemart_category_id`
  WHERE pc.`virtuemart_product_id` = 781
  AND `published`=1
  ORDER BY `c`.`ordering` ASC
320. SELECT `ordering`,`id`
  FROM `eqc_virtuemart_product_categories`
  WHERE `virtuemart_product_id` = "781"
  and `virtuemart_category_id`= "36"
321. SELECT `eqc_virtuemart_categories_en_gb`.* ,`eqc_virtuemart_categories`.*
  FROM `eqc_virtuemart_categories_en_gb` JOIN eqc_virtuemart_categories using (`virtuemart_category_id`)
  WHERE eqc_virtuemart_categories_en_gb.`virtuemart_category_id` = "36"
322. SELECT `slug`
  FROM `eqc_virtuemart_products_en_gb`
  WHERE `virtuemart_product_id` = 781
323. SELECT `eqc_virtuemart_products_en_gb`.* ,`eqc_virtuemart_products`.* ,`eqc_virtuemart_product_manufacturers`.`virtuemart_manufacturer_id` ,`eqc_virtuemart_product_customfields`.`virtuemart_customfield_id`
  FROM `eqc_virtuemart_products_en_gb` JOIN eqc_virtuemart_products using (`virtuemart_product_id`)
  LEFT JOIN `eqc_virtuemart_product_manufacturers`
  on `eqc_virtuemart_product_manufacturers`.`virtuemart_product_id`=`eqc_virtuemart_products_en_gb`.`virtuemart_product_id`
  LEFT JOIN `eqc_virtuemart_product_customfields`
  on `eqc_virtuemart_product_customfields`.`virtuemart_product_id`=`eqc_virtuemart_products_en_gb`.`virtuemart_product_id`
  WHERE eqc_virtuemart_products_en_gb.`virtuemart_product_id` = "1107"
324. SELECT `virtuemart_media_id`
  FROM `eqc_virtuemart_product_medias`
  WHERE `virtuemart_product_id` = "1107"
  ORDER BY `ordering`
325. SELECT `virtuemart_shoppergroup_id`
  FROM `eqc_virtuemart_product_shoppergroups`
  WHERE `virtuemart_product_id` = "1107"
326. SELECT *
  FROM `eqc_virtuemart_product_prices`
  WHERE `virtuemart_product_id` = "1107"
  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` <= "2014-04-20 10:47:15" )
  AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2014-04-20 10:47:15" ) )
  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) )
327. SELECT `eqc_virtuemart_manufacturers_en_gb`.* ,`eqc_virtuemart_manufacturers`.*
  FROM `eqc_virtuemart_manufacturers_en_gb` JOIN eqc_virtuemart_manufacturers using (`virtuemart_manufacturer_id`)
  WHERE eqc_virtuemart_manufacturers_en_gb.`virtuemart_manufacturer_id` = "1"
328. SELECT pc.`virtuemart_category_id`
  FROM `eqc_virtuemart_product_categories` as pc
  WHERE pc.`virtuemart_product_id` = 1107
329. SELECT pc.`virtuemart_category_id`
  FROM `eqc_virtuemart_product_categories` as pc
  LEFT JOIN `eqc_virtuemart_categories` as c
  ON c.`virtuemart_category_id` = pc.`virtuemart_category_id`
  WHERE pc.`virtuemart_product_id` = 1107
  AND `published`=1
  ORDER BY `c`.`ordering` ASC
330. SELECT `ordering`,`id`
  FROM `eqc_virtuemart_product_categories`
  WHERE `virtuemart_product_id` = "1107"
  and `virtuemart_category_id`= "46"
331. SELECT `eqc_virtuemart_categories_en_gb`.* ,`eqc_virtuemart_categories`.*
  FROM `eqc_virtuemart_categories_en_gb` JOIN eqc_virtuemart_categories using (`virtuemart_category_id`)
  WHERE eqc_virtuemart_categories_en_gb.`virtuemart_category_id` = "46"
332. SELECT `slug`
  FROM `eqc_virtuemart_products_en_gb`
  WHERE `virtuemart_product_id` = 1107
333. SELECT `eqc_virtuemart_products_en_gb`.* ,`eqc_virtuemart_products`.* ,`eqc_virtuemart_product_manufacturers`.`virtuemart_manufacturer_id` ,`eqc_virtuemart_product_customfields`.`virtuemart_customfield_id`
  FROM `eqc_virtuemart_products_en_gb` JOIN eqc_virtuemart_products using (`virtuemart_product_id`)
  LEFT JOIN `eqc_virtuemart_product_manufacturers`
  on `eqc_virtuemart_product_manufacturers`.`virtuemart_product_id`=`eqc_virtuemart_products_en_gb`.`virtuemart_product_id`
  LEFT JOIN `eqc_virtuemart_product_customfields`
  on `eqc_virtuemart_product_customfields`.`virtuemart_product_id`=`eqc_virtuemart_products_en_gb`.`virtuemart_product_id`
  WHERE eqc_virtuemart_products_en_gb.`virtuemart_product_id` = "338"
334. SELECT `virtuemart_media_id`
  FROM `eqc_virtuemart_product_medias`
  WHERE `virtuemart_product_id` = "338"
  ORDER BY `ordering`
335. SELECT `virtuemart_shoppergroup_id`
  FROM `eqc_virtuemart_product_shoppergroups`
  WHERE `virtuemart_product_id` = "338"
336. SELECT *
  FROM `eqc_virtuemart_product_prices`
  WHERE `virtuemart_product_id` = "338"
  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` <= "2014-04-20 10:47:15" )
  AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2014-04-20 10:47:15" ) )
  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) )
337. SELECT `eqc_virtuemart_manufacturers_en_gb`.* ,`eqc_virtuemart_manufacturers`.*
  FROM `eqc_virtuemart_manufacturers_en_gb` JOIN eqc_virtuemart_manufacturers using (`virtuemart_manufacturer_id`)
  WHERE eqc_virtuemart_manufacturers_en_gb.`virtuemart_manufacturer_id` = "1"
338. SELECT pc.`virtuemart_category_id`
  FROM `eqc_virtuemart_product_categories` as pc
  WHERE pc.`virtuemart_product_id` = 338
339. SELECT pc.`virtuemart_category_id`
  FROM `eqc_virtuemart_product_categories` as pc
  LEFT JOIN `eqc_virtuemart_categories` as c
  ON c.`virtuemart_category_id` = pc.`virtuemart_category_id`
  WHERE pc.`virtuemart_product_id` = 338
  AND `published`=1
  ORDER BY `c`.`ordering` ASC
340. SELECT `ordering`,`id`
  FROM `eqc_virtuemart_product_categories`
  WHERE `virtuemart_product_id` = "338"
  and `virtuemart_category_id`= "14"
341. SELECT `eqc_virtuemart_categories_en_gb`.* ,`eqc_virtuemart_categories`.*
  FROM `eqc_virtuemart_categories_en_gb` JOIN eqc_virtuemart_categories using (`virtuemart_category_id`)
  WHERE eqc_virtuemart_categories_en_gb.`virtuemart_category_id` = "14"
342. SELECT `slug`
  FROM `eqc_virtuemart_products_en_gb`
  WHERE `virtuemart_product_id` = 338
343. SELECT `eqc_virtuemart_products_en_gb`.* ,`eqc_virtuemart_products`.* ,`eqc_virtuemart_product_manufacturers`.`virtuemart_manufacturer_id` ,`eqc_virtuemart_product_customfields`.`virtuemart_customfield_id`
  FROM `eqc_virtuemart_products_en_gb` JOIN eqc_virtuemart_products using (`virtuemart_product_id`)
  LEFT JOIN `eqc_virtuemart_product_manufacturers`
  on `eqc_virtuemart_product_manufacturers`.`virtuemart_product_id`=`eqc_virtuemart_products_en_gb`.`virtuemart_product_id`
  LEFT JOIN `eqc_virtuemart_product_customfields`
  on `eqc_virtuemart_product_customfields`.`virtuemart_product_id`=`eqc_virtuemart_products_en_gb`.`virtuemart_product_id`
  WHERE eqc_virtuemart_products_en_gb.`virtuemart_product_id` = "1062"
344. SELECT `virtuemart_media_id`
  FROM `eqc_virtuemart_product_medias`
  WHERE `virtuemart_product_id` = "1062"
  ORDER BY `ordering`
345. SELECT `virtuemart_shoppergroup_id`
  FROM `eqc_virtuemart_product_shoppergroups`
  WHERE `virtuemart_product_id` = "1062"
346. SELECT *
  FROM `eqc_virtuemart_product_prices`
  WHERE `virtuemart_product_id` = "1062"
  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` <= "2014-04-20 10:47:15" )
  AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2014-04-20 10:47:15" ) )
  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) )
347. SELECT `eqc_virtuemart_manufacturers_en_gb`.* ,`eqc_virtuemart_manufacturers`.*
  FROM `eqc_virtuemart_manufacturers_en_gb` JOIN eqc_virtuemart_manufacturers using (`virtuemart_manufacturer_id`)
  WHERE eqc_virtuemart_manufacturers_en_gb.`virtuemart_manufacturer_id` = "1"
348. SELECT pc.`virtuemart_category_id`
  FROM `eqc_virtuemart_product_categories` as pc
  WHERE pc.`virtuemart_product_id` = 1062
349. SELECT pc.`virtuemart_category_id`
  FROM `eqc_virtuemart_product_categories` as pc
  LEFT JOIN `eqc_virtuemart_categories` as c
  ON c.`virtuemart_category_id` = pc.`virtuemart_category_id`
  WHERE pc.`virtuemart_product_id` = 1062
  AND `published`=1
  ORDER BY `c`.`ordering` ASC
350. SELECT `ordering`,`id`
  FROM `eqc_virtuemart_product_categories`
  WHERE `virtuemart_product_id` = "1062"
  and `virtuemart_category_id`= "43"
351. SELECT `eqc_virtuemart_categories_en_gb`.* ,`eqc_virtuemart_categories`.*
  FROM `eqc_virtuemart_categories_en_gb` JOIN eqc_virtuemart_categories using (`virtuemart_category_id`)
  WHERE eqc_virtuemart_categories_en_gb.`virtuemart_category_id` = "43"
352. SELECT `slug`
  FROM `eqc_virtuemart_products_en_gb`
  WHERE `virtuemart_product_id` = 1062
353. SELECT `eqc_virtuemart_products_en_gb`.* ,`eqc_virtuemart_products`.* ,`eqc_virtuemart_product_manufacturers`.`virtuemart_manufacturer_id` ,`eqc_virtuemart_product_customfields`.`virtuemart_customfield_id`
  FROM `eqc_virtuemart_products_en_gb` JOIN eqc_virtuemart_products using (`virtuemart_product_id`)
  LEFT JOIN `eqc_virtuemart_product_manufacturers`
  on `eqc_virtuemart_product_manufacturers`.`virtuemart_product_id`=`eqc_virtuemart_products_en_gb`.`virtuemart_product_id`
  LEFT JOIN `eqc_virtuemart_product_customfields`
  on `eqc_virtuemart_product_customfields`.`virtuemart_product_id`=`eqc_virtuemart_products_en_gb`.`virtuemart_product_id`
  WHERE eqc_virtuemart_products_en_gb.`virtuemart_product_id` = "527"
354. SELECT `virtuemart_media_id`
  FROM `eqc_virtuemart_product_medias`
  WHERE `virtuemart_product_id` = "527"
  ORDER BY `ordering`
355. SELECT `virtuemart_shoppergroup_id`
  FROM `eqc_virtuemart_product_shoppergroups`
  WHERE `virtuemart_product_id` = "527"
356. SELECT *
  FROM `eqc_virtuemart_product_prices`
  WHERE `virtuemart_product_id` = "527"
  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` <= "2014-04-20 10:47:15" )
  AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2014-04-20 10:47:15" ) )
  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) )
357. SELECT `eqc_virtuemart_manufacturers_en_gb`.* ,`eqc_virtuemart_manufacturers`.*
  FROM `eqc_virtuemart_manufacturers_en_gb` JOIN eqc_virtuemart_manufacturers using (`virtuemart_manufacturer_id`)
  WHERE eqc_virtuemart_manufacturers_en_gb.`virtuemart_manufacturer_id` = "1"
358. SELECT pc.`virtuemart_category_id`
  FROM `eqc_virtuemart_product_categories` as pc
  WHERE pc.`virtuemart_product_id` = 527
359. SELECT pc.`virtuemart_category_id`
  FROM `eqc_virtuemart_product_categories` as pc
  LEFT JOIN `eqc_virtuemart_categories` as c
  ON c.`virtuemart_category_id` = pc.`virtuemart_category_id`
  WHERE pc.`virtuemart_product_id` = 527
  AND `published`=1
  ORDER BY `c`.`ordering` ASC
360. SELECT `ordering`,`id`
  FROM `eqc_virtuemart_product_categories`
  WHERE `virtuemart_product_id` = "527"
  and `virtuemart_category_id`= "53"
361. SELECT `eqc_virtuemart_categories_en_gb`.* ,`eqc_virtuemart_categories`.*
  FROM `eqc_virtuemart_categories_en_gb` JOIN eqc_virtuemart_categories using (`virtuemart_category_id`)
  WHERE eqc_virtuemart_categories_en_gb.`virtuemart_category_id` = "53"
362. SELECT `slug`
  FROM `eqc_virtuemart_products_en_gb`
  WHERE `virtuemart_product_id` = 527
363. SELECT `eqc_virtuemart_products_en_gb`.* ,`eqc_virtuemart_products`.* ,`eqc_virtuemart_product_manufacturers`.`virtuemart_manufacturer_id` ,`eqc_virtuemart_product_customfields`.`virtuemart_customfield_id`
  FROM `eqc_virtuemart_products_en_gb` JOIN eqc_virtuemart_products using (`virtuemart_product_id`)
  LEFT JOIN `eqc_virtuemart_product_manufacturers`
  on `eqc_virtuemart_product_manufacturers`.`virtuemart_product_id`=`eqc_virtuemart_products_en_gb`.`virtuemart_product_id`
  LEFT JOIN `eqc_virtuemart_product_customfields`
  on `eqc_virtuemart_product_customfields`.`virtuemart_product_id`=`eqc_virtuemart_products_en_gb`.`virtuemart_product_id`
  WHERE eqc_virtuemart_products_en_gb.`virtuemart_product_id` = "32"
364. SELECT `virtuemart_media_id`
  FROM `eqc_virtuemart_product_medias`
  WHERE `virtuemart_product_id` = "32"
  ORDER BY `ordering`
365. SELECT `virtuemart_shoppergroup_id`
  FROM `eqc_virtuemart_product_shoppergroups`
  WHERE `virtuemart_product_id` = "32"
366. SELECT *
  FROM `eqc_virtuemart_product_prices`
  WHERE `virtuemart_product_id` = "32"
  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` <= "2014-04-20 10:47:15" )
  AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2014-04-20 10:47:15" ) )
  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) )
367. SELECT `eqc_virtuemart_manufacturers_en_gb`.* ,`eqc_virtuemart_manufacturers`.*
  FROM `eqc_virtuemart_manufacturers_en_gb` JOIN eqc_virtuemart_manufacturers using (`virtuemart_manufacturer_id`)
  WHERE eqc_virtuemart_manufacturers_en_gb.`virtuemart_manufacturer_id` = "1"
368. SELECT pc.`virtuemart_category_id`
  FROM `eqc_virtuemart_product_categories` as pc
  WHERE pc.`virtuemart_product_id` = 32
369. SELECT pc.`virtuemart_category_id`
  FROM `eqc_virtuemart_product_categories` as pc
  LEFT JOIN `eqc_virtuemart_categories` as c
  ON c.`virtuemart_category_id` = pc.`virtuemart_category_id`
  WHERE pc.`virtuemart_product_id` = 32
  AND `published`=1
  ORDER BY `c`.`ordering` ASC
370. SELECT `ordering`,`id`
  FROM `eqc_virtuemart_product_categories`
  WHERE `virtuemart_product_id` = "32"
  and `virtuemart_category_id`= "5"
371. SELECT `eqc_virtuemart_categories_en_gb`.* ,`eqc_virtuemart_categories`.*
  FROM `eqc_virtuemart_categories_en_gb` JOIN eqc_virtuemart_categories using (`virtuemart_category_id`)
  WHERE eqc_virtuemart_categories_en_gb.`virtuemart_category_id` = "5"
372. SELECT `slug`
  FROM `eqc_virtuemart_products_en_gb`
  WHERE `virtuemart_product_id` = 32
373. SELECT `eqc_virtuemart_products_en_gb`.* ,`eqc_virtuemart_products`.* ,`eqc_virtuemart_product_manufacturers`.`virtuemart_manufacturer_id` ,`eqc_virtuemart_product_customfields`.`virtuemart_customfield_id`
  FROM `eqc_virtuemart_products_en_gb` JOIN eqc_virtuemart_products using (`virtuemart_product_id`)
  LEFT JOIN `eqc_virtuemart_product_manufacturers`
  on `eqc_virtuemart_product_manufacturers`.`virtuemart_product_id`=`eqc_virtuemart_products_en_gb`.`virtuemart_product_id`
  LEFT JOIN `eqc_virtuemart_product_customfields`
  on `eqc_virtuemart_product_customfields`.`virtuemart_product_id`=`eqc_virtuemart_products_en_gb`.`virtuemart_product_id`
  WHERE eqc_virtuemart_products_en_gb.`virtuemart_product_id` = "794"
374. SELECT `virtuemart_media_id`
  FROM `eqc_virtuemart_product_medias`
  WHERE `virtuemart_product_id` = "794"
  ORDER BY `ordering`
375. SELECT `virtuemart_shoppergroup_id`
  FROM `eqc_virtuemart_product_shoppergroups`
  WHERE `virtuemart_product_id` = "794"
376. SELECT *
  FROM `eqc_virtuemart_product_prices`
  WHERE `virtuemart_product_id` = "794"
  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` <= "2014-04-20 10:47:15" )
  AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2014-04-20 10:47:15" ) )
  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) )
377. SELECT `eqc_virtuemart_manufacturers_en_gb`.* ,`eqc_virtuemart_manufacturers`.*
  FROM `eqc_virtuemart_manufacturers_en_gb` JOIN eqc_virtuemart_manufacturers using (`virtuemart_manufacturer_id`)
  WHERE eqc_virtuemart_manufacturers_en_gb.`virtuemart_manufacturer_id` = "1"
378. SELECT pc.`virtuemart_category_id`
  FROM `eqc_virtuemart_product_categories` as pc
  WHERE pc.`virtuemart_product_id` = 794
379. SELECT pc.`virtuemart_category_id`
  FROM `eqc_virtuemart_product_categories` as pc
  LEFT JOIN `eqc_virtuemart_categories` as c
  ON c.`virtuemart_category_id` = pc.`virtuemart_category_id`
  WHERE pc.`virtuemart_product_id` = 794
  AND `published`=1
  ORDER BY `c`.`ordering` ASC
380. SELECT `ordering`,`id`
  FROM `eqc_virtuemart_product_categories`
  WHERE `virtuemart_product_id` = "794"
  and `virtuemart_category_id`= "49"
381. SELECT `eqc_virtuemart_categories_en_gb`.* ,`eqc_virtuemart_categories`.*
  FROM `eqc_virtuemart_categories_en_gb` JOIN eqc_virtuemart_categories using (`virtuemart_category_id`)
  WHERE eqc_virtuemart_categories_en_gb.`virtuemart_category_id` = "49"
382. SELECT `slug`
  FROM `eqc_virtuemart_products_en_gb`
  WHERE `virtuemart_product_id` = 794
383. SELECT `eqc_virtuemart_products_en_gb`.* ,`eqc_virtuemart_products`.* ,`eqc_virtuemart_product_manufacturers`.`virtuemart_manufacturer_id` ,`eqc_virtuemart_product_customfields`.`virtuemart_customfield_id`
  FROM `eqc_virtuemart_products_en_gb` JOIN eqc_virtuemart_products using (`virtuemart_product_id`)
  LEFT JOIN `eqc_virtuemart_product_manufacturers`
  on `eqc_virtuemart_product_manufacturers`.`virtuemart_product_id`=`eqc_virtuemart_products_en_gb`.`virtuemart_product_id`
  LEFT JOIN `eqc_virtuemart_product_customfields`
  on `eqc_virtuemart_product_customfields`.`virtuemart_product_id`=`eqc_virtuemart_products_en_gb`.`virtuemart_product_id`
  WHERE eqc_virtuemart_products_en_gb.`virtuemart_product_id` = "1357"
384. SELECT `virtuemart_media_id`
  FROM `eqc_virtuemart_product_medias`
  WHERE `virtuemart_product_id` = "1357"
  ORDER BY `ordering`
385. SELECT `virtuemart_shoppergroup_id`
  FROM `eqc_virtuemart_product_shoppergroups`
  WHERE `virtuemart_product_id` = "1357"
386. SELECT *
  FROM `eqc_virtuemart_product_prices`
  WHERE `virtuemart_product_id` = "1357"
  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` <= "2014-04-20 10:47:15" )
  AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2014-04-20 10:47:15" ) )
  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) )
387. SELECT pc.`virtuemart_category_id`
  FROM `eqc_virtuemart_product_categories` as pc
  WHERE pc.`virtuemart_product_id` = 1357
388. SELECT pc.`virtuemart_category_id`
  FROM `eqc_virtuemart_product_categories` as pc
  LEFT JOIN `eqc_virtuemart_categories` as c
  ON c.`virtuemart_category_id` = pc.`virtuemart_category_id`
  WHERE pc.`virtuemart_product_id` = 1357
  AND `published`=1
  ORDER BY `c`.`ordering` ASC
389. SELECT `ordering`,`id`
  FROM `eqc_virtuemart_product_categories`
  WHERE `virtuemart_product_id` = "1357"
  and `virtuemart_category_id`= "35"
390. SELECT `eqc_virtuemart_categories_en_gb`.* ,`eqc_virtuemart_categories`.*
  FROM `eqc_virtuemart_categories_en_gb` JOIN eqc_virtuemart_categories using (`virtuemart_category_id`)
  WHERE eqc_virtuemart_categories_en_gb.`virtuemart_category_id` = "35"
391. SELECT `slug`
  FROM `eqc_virtuemart_products_en_gb`
  WHERE `virtuemart_product_id` = 1357
392. SELECT `eqc_virtuemart_products_en_gb`.* ,`eqc_virtuemart_products`.* ,`eqc_virtuemart_product_manufacturers`.`virtuemart_manufacturer_id` ,`eqc_virtuemart_product_customfields`.`virtuemart_customfield_id`
  FROM `eqc_virtuemart_products_en_gb` JOIN eqc_virtuemart_products using (`virtuemart_product_id`)
  LEFT JOIN `eqc_virtuemart_product_manufacturers`
  on `eqc_virtuemart_product_manufacturers`.`virtuemart_product_id`=`eqc_virtuemart_products_en_gb`.`virtuemart_product_id`
  LEFT JOIN `eqc_virtuemart_product_customfields`
  on `eqc_virtuemart_product_customfields`.`virtuemart_product_id`=`eqc_virtuemart_products_en_gb`.`virtuemart_product_id`
  WHERE eqc_virtuemart_products_en_gb.`virtuemart_product_id` = "1304"
393. SELECT `virtuemart_media_id`
  FROM `eqc_virtuemart_product_medias`
  WHERE `virtuemart_product_id` = "1304"
  ORDER BY `ordering`
394. SELECT `virtuemart_shoppergroup_id`
  FROM `eqc_virtuemart_product_shoppergroups`
  WHERE `virtuemart_product_id` = "1304"
395. SELECT *
  FROM `eqc_virtuemart_product_prices`
  WHERE `virtuemart_product_id` = "1304"
  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` <= "2014-04-20 10:47:15" )
  AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2014-04-20 10:47:15" ) )
  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) )
396. SELECT `eqc_virtuemart_manufacturers_en_gb`.* ,`eqc_virtuemart_manufacturers`.*
  FROM `eqc_virtuemart_manufacturers_en_gb` JOIN eqc_virtuemart_manufacturers using (`virtuemart_manufacturer_id`)
  WHERE eqc_virtuemart_manufacturers_en_gb.`virtuemart_manufacturer_id` = "1"
397. SELECT pc.`virtuemart_category_id`
  FROM `eqc_virtuemart_product_categories` as pc
  WHERE pc.`virtuemart_product_id` = 1304
398. SELECT pc.`virtuemart_category_id`
  FROM `eqc_virtuemart_product_categories` as pc
  LEFT JOIN `eqc_virtuemart_categories` as c
  ON c.`virtuemart_category_id` = pc.`virtuemart_category_id`
  WHERE pc.`virtuemart_product_id` = 1304
  AND `published`=1
  ORDER BY `c`.`ordering` ASC
399. SELECT `ordering`,`id`
  FROM `eqc_virtuemart_product_categories`
  WHERE `virtuemart_product_id` = "1304"
  and `virtuemart_category_id`= "54"
400. SELECT `eqc_virtuemart_categories_en_gb`.* ,`eqc_virtuemart_categories`.*
  FROM `eqc_virtuemart_categories_en_gb` JOIN eqc_virtuemart_categories using (`virtuemart_category_id`)
  WHERE eqc_virtuemart_categories_en_gb.`virtuemart_category_id` = "54"
401. SELECT `slug`
  FROM `eqc_virtuemart_products_en_gb`
  WHERE `virtuemart_product_id` = 1304
402. SELECT `eqc_virtuemart_products_en_gb`.* ,`eqc_virtuemart_products`.* ,`eqc_virtuemart_product_manufacturers`.`virtuemart_manufacturer_id` ,`eqc_virtuemart_product_customfields`.`virtuemart_customfield_id`
  FROM `eqc_virtuemart_products_en_gb` JOIN eqc_virtuemart_products using (`virtuemart_product_id`)
  LEFT JOIN `eqc_virtuemart_product_manufacturers`
  on `eqc_virtuemart_product_manufacturers`.`virtuemart_product_id`=`eqc_virtuemart_products_en_gb`.`virtuemart_product_id`
  LEFT JOIN `eqc_virtuemart_product_customfields`
  on `eqc_virtuemart_product_customfields`.`virtuemart_product_id`=`eqc_virtuemart_products_en_gb`.`virtuemart_product_id`
  WHERE eqc_virtuemart_products_en_gb.`virtuemart_product_id` = "1319"
403. SELECT `virtuemart_media_id`
  FROM `eqc_virtuemart_product_medias`
  WHERE `virtuemart_product_id` = "1319"
  ORDER BY `ordering`
404. SELECT `virtuemart_shoppergroup_id`
  FROM `eqc_virtuemart_product_shoppergroups`
  WHERE `virtuemart_product_id` = "1319"
405. SELECT *
  FROM `eqc_virtuemart_product_prices`
  WHERE `virtuemart_product_id` = "1319"
  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` <= "2014-04-20 10:47:15" )
  AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2014-04-20 10:47:15" ) )
  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) )
406. SELECT `eqc_virtuemart_manufacturers_en_gb`.* ,`eqc_virtuemart_manufacturers`.*
  FROM `eqc_virtuemart_manufacturers_en_gb` JOIN eqc_virtuemart_manufacturers using (`virtuemart_manufacturer_id`)
  WHERE eqc_virtuemart_manufacturers_en_gb.`virtuemart_manufacturer_id` = "1"
407. SELECT pc.`virtuemart_category_id`
  FROM `eqc_virtuemart_product_categories` as pc
  WHERE pc.`virtuemart_product_id` = 1319
408. SELECT pc.`virtuemart_category_id`
  FROM `eqc_virtuemart_product_categories` as pc
  LEFT JOIN `eqc_virtuemart_categories` as c
  ON c.`virtuemart_category_id` = pc.`virtuemart_category_id`
  WHERE pc.`virtuemart_product_id` = 1319
  AND `published`=1
  ORDER BY `c`.`ordering` ASC
409. SELECT `ordering`,`id`
  FROM `eqc_virtuemart_product_categories`
  WHERE `virtuemart_product_id` = "1319"
  and `virtuemart_category_id`= "25"
410. SELECT `eqc_virtuemart_categories_en_gb`.* ,`eqc_virtuemart_categories`.*
  FROM `eqc_virtuemart_categories_en_gb` JOIN eqc_virtuemart_categories using (`virtuemart_category_id`)
  WHERE eqc_virtuemart_categories_en_gb.`virtuemart_category_id` = "25"
411. SELECT `slug`
  FROM `eqc_virtuemart_products_en_gb`
  WHERE `virtuemart_product_id` = 1319
412. SELECT `eqc_virtuemart_products_en_gb`.* ,`eqc_virtuemart_products`.* ,`eqc_virtuemart_product_manufacturers`.`virtuemart_manufacturer_id` ,`eqc_virtuemart_product_customfields`.`virtuemart_customfield_id`
  FROM `eqc_virtuemart_products_en_gb` JOIN eqc_virtuemart_products using (`virtuemart_product_id`)
  LEFT JOIN `eqc_virtuemart_product_manufacturers`
  on `eqc_virtuemart_product_manufacturers`.`virtuemart_product_id`=`eqc_virtuemart_products_en_gb`.`virtuemart_product_id`
  LEFT JOIN `eqc_virtuemart_product_customfields`
  on `eqc_virtuemart_product_customfields`.`virtuemart_product_id`=`eqc_virtuemart_products_en_gb`.`virtuemart_product_id`
  WHERE eqc_virtuemart_products_en_gb.`virtuemart_product_id` = "967"
413. SELECT `virtuemart_media_id`
  FROM `eqc_virtuemart_product_medias`
  WHERE `virtuemart_product_id` = "967"
  ORDER BY `ordering`
414. SELECT `virtuemart_shoppergroup_id`
  FROM `eqc_virtuemart_product_shoppergroups`
  WHERE `virtuemart_product_id` = "967"
415. SELECT *
  FROM `eqc_virtuemart_product_prices`
  WHERE `virtuemart_product_id` = "967"
  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` <= "2014-04-20 10:47:15" )
  AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2014-04-20 10:47:15" ) )
  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) )
416. SELECT `eqc_virtuemart_manufacturers_en_gb`.* ,`eqc_virtuemart_manufacturers`.*
  FROM `eqc_virtuemart_manufacturers_en_gb` JOIN eqc_virtuemart_manufacturers using (`virtuemart_manufacturer_id`)
  WHERE eqc_virtuemart_manufacturers_en_gb.`virtuemart_manufacturer_id` = "1"
417. SELECT pc.`virtuemart_category_id`
  FROM `eqc_virtuemart_product_categories` as pc
  WHERE pc.`virtuemart_product_id` = 967
418. SELECT pc.`virtuemart_category_id`
  FROM `eqc_virtuemart_product_categories` as pc
  LEFT JOIN `eqc_virtuemart_categories` as c
  ON c.`virtuemart_category_id` = pc.`virtuemart_category_id`
  WHERE pc.`virtuemart_product_id` = 967
  AND `published`=1
  ORDER BY `c`.`ordering` ASC
419. SELECT `ordering`,`id`
  FROM `eqc_virtuemart_product_categories`
  WHERE `virtuemart_product_id` = "967"
  and `virtuemart_category_id`= "19"
420. SELECT `eqc_virtuemart_categories_en_gb`.* ,`eqc_virtuemart_categories`.*
  FROM `eqc_virtuemart_categories_en_gb` JOIN eqc_virtuemart_categories using (`virtuemart_category_id`)
  WHERE eqc_virtuemart_categories_en_gb.`virtuemart_category_id` = "19"
421. SELECT `slug`
  FROM `eqc_virtuemart_products_en_gb`
  WHERE `virtuemart_product_id` = 967
422. SELECT `eqc_virtuemart_products_en_gb`.* ,`eqc_virtuemart_products`.* ,`eqc_virtuemart_product_manufacturers`.`virtuemart_manufacturer_id` ,`eqc_virtuemart_product_customfields`.`virtuemart_customfield_id`
  FROM `eqc_virtuemart_products_en_gb` JOIN eqc_virtuemart_products using (`virtuemart_product_id`)
  LEFT JOIN `eqc_virtuemart_product_manufacturers`
  on `eqc_virtuemart_product_manufacturers`.`virtuemart_product_id`=`eqc_virtuemart_products_en_gb`.`virtuemart_product_id`
  LEFT JOIN `eqc_virtuemart_product_customfields`
  on `eqc_virtuemart_product_customfields`.`virtuemart_product_id`=`eqc_virtuemart_products_en_gb`.`virtuemart_product_id`
  WHERE eqc_virtuemart_products_en_gb.`virtuemart_product_id` = "1276"
423. SELECT `virtuemart_media_id`
  FROM `eqc_virtuemart_product_medias`
  WHERE `virtuemart_product_id` = "1276"
  ORDER BY `ordering`
424. SELECT `virtuemart_shoppergroup_id`
  FROM `eqc_virtuemart_product_shoppergroups`
  WHERE `virtuemart_product_id` = "1276"
425. SELECT *
  FROM `eqc_virtuemart_product_prices`
  WHERE `virtuemart_product_id` = "1276"
  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` <= "2014-04-20 10:47:15" )
  AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2014-04-20 10:47:15" ) )
  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) )
426. SELECT `eqc_virtuemart_manufacturers_en_gb`.* ,`eqc_virtuemart_manufacturers`.*
  FROM `eqc_virtuemart_manufacturers_en_gb` JOIN eqc_virtuemart_manufacturers using (`virtuemart_manufacturer_id`)
  WHERE eqc_virtuemart_manufacturers_en_gb.`virtuemart_manufacturer_id` = "1"
427. SELECT pc.`virtuemart_category_id`
  FROM `eqc_virtuemart_product_categories` as pc
  WHERE pc.`virtuemart_product_id` = 1276
428. SELECT pc.`virtuemart_category_id`
  FROM `eqc_virtuemart_product_categories` as pc
  LEFT JOIN `eqc_virtuemart_categories` as c
  ON c.`virtuemart_category_id` = pc.`virtuemart_category_id`
  WHERE pc.`virtuemart_product_id` = 1276
  AND `published`=1
  ORDER BY `c`.`ordering` ASC
429. SELECT `ordering`,`id`
  FROM `eqc_virtuemart_product_categories`
  WHERE `virtuemart_product_id` = "1276"
  and `virtuemart_category_id`= "56"
430. SELECT `eqc_virtuemart_categories_en_gb`.* ,`eqc_virtuemart_categories`.*
  FROM `eqc_virtuemart_categories_en_gb` JOIN eqc_virtuemart_categories using (`virtuemart_category_id`)
  WHERE eqc_virtuemart_categories_en_gb.`virtuemart_category_id` = "56"
431. SELECT `slug`
  FROM `eqc_virtuemart_products_en_gb`
  WHERE `virtuemart_product_id` = 1276
432. SELECT `eqc_virtuemart_medias`.*
  FROM `eqc_virtuemart_medias`
  WHERE eqc_virtuemart_medias.`virtuemart_media_id` = "1698"
433. SELECT `eqc_virtuemart_medias`.*
  FROM `eqc_virtuemart_medias`
  WHERE eqc_virtuemart_medias.`virtuemart_media_id` = "3178"
434. SELECT `eqc_virtuemart_medias`.*
  FROM `eqc_virtuemart_medias`
  WHERE eqc_virtuemart_medias.`virtuemart_media_id` = "3612"
435. SELECT `eqc_virtuemart_medias`.*
  FROM `eqc_virtuemart_medias`
  WHERE eqc_virtuemart_medias.`virtuemart_media_id` = "1351"
436. SELECT `eqc_virtuemart_medias`.*
  FROM `eqc_virtuemart_medias`
  WHERE eqc_virtuemart_medias.`virtuemart_media_id` = "3205"
437. SELECT `eqc_virtuemart_medias`.*
  FROM `eqc_virtuemart_medias`
  WHERE eqc_virtuemart_medias.`virtuemart_media_id` = "3482"
438. SELECT `eqc_virtuemart_medias`.*
  FROM `eqc_virtuemart_medias`
  WHERE eqc_virtuemart_medias.`virtuemart_media_id` = "162"
439. SELECT `eqc_virtuemart_medias`.*
  FROM `eqc_virtuemart_medias`
  WHERE eqc_virtuemart_medias.`virtuemart_media_id` = "2158"
440. SELECT `eqc_virtuemart_medias`.*
  FROM `eqc_virtuemart_medias`
  WHERE eqc_virtuemart_medias.`virtuemart_media_id` = "2632"
441. SELECT `eqc_virtuemart_medias`.*
  FROM `eqc_virtuemart_medias`
  WHERE eqc_virtuemart_medias.`virtuemart_media_id` = "3328"
442. SELECT `eqc_virtuemart_medias`.*
  FROM `eqc_virtuemart_medias`
  WHERE eqc_virtuemart_medias.`virtuemart_media_id` = "2567"
443. SELECT `eqc_virtuemart_medias`.*
  FROM `eqc_virtuemart_medias`
  WHERE eqc_virtuemart_medias.`virtuemart_media_id` = "3613"
444. SELECT `eqc_virtuemart_medias`.*
  FROM `eqc_virtuemart_medias`
  WHERE eqc_virtuemart_medias.`virtuemart_media_id` = "1326"
445. SELECT `eqc_virtuemart_medias`.*
  FROM `eqc_virtuemart_medias`
  WHERE eqc_virtuemart_medias.`virtuemart_media_id` = "3277"
446. SELECT `eqc_virtuemart_medias`.*
  FROM `eqc_virtuemart_medias`
  WHERE eqc_virtuemart_medias.`virtuemart_media_id` = "1808"
447. SELECT `eqc_virtuemart_medias`.*
  FROM `eqc_virtuemart_medias`
  WHERE eqc_virtuemart_medias.`virtuemart_media_id` = "2819"
448. SELECT `eqc_virtuemart_medias`.*
  FROM `eqc_virtuemart_medias`
  WHERE eqc_virtuemart_medias.`virtuemart_media_id` = "223"
449. SELECT `eqc_virtuemart_medias`.*
  FROM `eqc_virtuemart_medias`
  WHERE eqc_virtuemart_medias.`virtuemart_media_id` = "583"
450. SELECT `eqc_virtuemart_medias`.*
  FROM `eqc_virtuemart_medias`
  WHERE eqc_virtuemart_medias.`virtuemart_media_id` = "2546"
451. SELECT `eqc_virtuemart_medias`.*
  FROM `eqc_virtuemart_medias`
  WHERE eqc_virtuemart_medias.`virtuemart_media_id` = "1339"
452. SELECT `eqc_virtuemart_medias`.*
  FROM `eqc_virtuemart_medias`
  WHERE eqc_virtuemart_medias.`virtuemart_media_id` = "1931"
453. SELECT `eqc_virtuemart_medias`.*
  FROM `eqc_virtuemart_medias`
  WHERE eqc_virtuemart_medias.`virtuemart_media_id` = "3169"
454. SELECT `eqc_virtuemart_medias`.*
  FROM `eqc_virtuemart_medias`
  WHERE eqc_virtuemart_medias.`virtuemart_media_id` = "1662"
455. SELECT `eqc_virtuemart_medias`.*
  FROM `eqc_virtuemart_medias`
  WHERE eqc_virtuemart_medias.`virtuemart_media_id` = "294"
456. SELECT `eqc_virtuemart_medias`.*
  FROM `eqc_virtuemart_medias`
  WHERE eqc_virtuemart_medias.`virtuemart_media_id` = "1594"
457. SELECT `eqc_virtuemart_medias`.*
  FROM `eqc_virtuemart_medias`
  WHERE eqc_virtuemart_medias.`virtuemart_media_id` = "2259"
458. SELECT p.`virtuemart_product_id` as id, `eqc_virtuemart_products`.`product_parent_id` as parent_id, `eqc_virtuemart_products`.`created_on`, p.`product_name` as name, GROUP_CONCAT(`eqc_virtuemart_product_categories`.`virtuemart_category_id` SEPARATOR ',') as categories, `eqc_virtuemart_product_categories`.`virtuemart_category_id` as category_id, GROUP_CONCAT(i.`file_url` SEPARATOR ',') as thumbnail, pr.virtuemart_product_price_id, pr.product_price, pr.override, pr.product_override_price, pr.product_tax_id, pr.product_discount_id, pr.product_currency
  FROM `eqc_virtuemart_products_en_gb` as p
  LEFT JOIN `eqc_virtuemart_products`
  ON `eqc_virtuemart_products`.`virtuemart_product_id` = p.`virtuemart_product_id`
  LEFT JOIN `eqc_virtuemart_product_categories`
  ON p.`virtuemart_product_id` = `eqc_virtuemart_product_categories`.`virtuemart_product_id`
  LEFT JOIN `eqc_virtuemart_product_medias`
  ON p.`virtuemart_product_id` = `eqc_virtuemart_product_medias`.`virtuemart_product_id`
  LEFT JOIN `eqc_virtuemart_medias` as i
  ON `eqc_virtuemart_product_medias`.`virtuemart_media_id` = i.`virtuemart_media_id`
  LEFT JOIN `eqc_virtuemart_product_prices` as pr
  ON p.`virtuemart_product_id` = pr.`virtuemart_product_id`
  WHERE ( `eqc_virtuemart_product_categories`.`virtuemart_category_id` IN (52)
  AND `eqc_virtuemart_products`.`published`="1" )
  GROUP BY id
  ORDER BY RAND()
  LIMIT 1
459. SELECT p.`virtuemart_product_id` as id, `eqc_virtuemart_products`.`product_parent_id` as parent_id, `eqc_virtuemart_products`.`created_on`, p.`product_name` as name, GROUP_CONCAT(`eqc_virtuemart_product_categories`.`virtuemart_category_id` SEPARATOR ',') as categories, `eqc_virtuemart_product_categories`.`virtuemart_category_id` as category_id, GROUP_CONCAT(i.`file_url` SEPARATOR ',') as thumbnail, pr.virtuemart_product_price_id, pr.product_price, pr.override, pr.product_override_price, pr.product_tax_id, pr.product_discount_id, pr.product_currency
  FROM `eqc_virtuemart_products_en_gb` as p
  LEFT JOIN `eqc_virtuemart_products`
  ON `eqc_virtuemart_products`.`virtuemart_product_id` = p.`virtuemart_product_id`
  LEFT JOIN `eqc_virtuemart_product_categories`
  ON p.`virtuemart_product_id` = `eqc_virtuemart_product_categories`.`virtuemart_product_id`
  LEFT JOIN `eqc_virtuemart_product_medias`
  ON p.`virtuemart_product_id` = `eqc_virtuemart_product_medias`.`virtuemart_product_id`
  LEFT JOIN `eqc_virtuemart_medias` as i
  ON `eqc_virtuemart_product_medias`.`virtuemart_media_id` = i.`virtuemart_media_id`
  LEFT JOIN `eqc_virtuemart_product_prices` as pr
  ON p.`virtuemart_product_id` = pr.`virtuemart_product_id`
  WHERE ( `eqc_virtuemart_product_categories`.`virtuemart_category_id` IN (7)
  AND `eqc_virtuemart_products`.`published`="1" )
  GROUP BY id
  ORDER BY RAND()
  LIMIT 1
460. SELECT p.`virtuemart_product_id` as id, `eqc_virtuemart_products`.`product_parent_id` as parent_id, `eqc_virtuemart_products`.`created_on`, p.`product_name` as name, GROUP_CONCAT(`eqc_virtuemart_product_categories`.`virtuemart_category_id` SEPARATOR ',') as categories, `eqc_virtuemart_product_categories`.`virtuemart_category_id` as category_id, GROUP_CONCAT(i.`file_url` SEPARATOR ',') as thumbnail, pr.virtuemart_product_price_id, pr.product_price, pr.override, pr.product_override_price, pr.product_tax_id, pr.product_discount_id, pr.product_currency
  FROM `eqc_virtuemart_products_en_gb` as p
  LEFT JOIN `eqc_virtuemart_products`
  ON `eqc_virtuemart_products`.`virtuemart_product_id` = p.`virtuemart_product_id`
  LEFT JOIN `eqc_virtuemart_product_categories`
  ON p.`virtuemart_product_id` = `eqc_virtuemart_product_categories`.`virtuemart_product_id`
  LEFT JOIN `eqc_virtuemart_product_medias`
  ON p.`virtuemart_product_id` = `eqc_virtuemart_product_medias`.`virtuemart_product_id`
  LEFT JOIN `eqc_virtuemart_medias` as i
  ON `eqc_virtuemart_product_medias`.`virtuemart_media_id` = i.`virtuemart_media_id`
  LEFT JOIN `eqc_virtuemart_product_prices` as pr
  ON p.`virtuemart_product_id` = pr.`virtuemart_product_id`
  WHERE ( `eqc_virtuemart_product_categories`.`virtuemart_category_id` IN (8)
  AND `eqc_virtuemart_products`.`published`="1" )
  GROUP BY id
  ORDER BY RAND()
  LIMIT 1
461. SELECT p.`virtuemart_product_id` as id, `eqc_virtuemart_products`.`product_parent_id` as parent_id, `eqc_virtuemart_products`.`created_on`, p.`product_name` as name, GROUP_CONCAT(`eqc_virtuemart_product_categories`.`virtuemart_category_id` SEPARATOR ',') as categories, `eqc_virtuemart_product_categories`.`virtuemart_category_id` as category_id, GROUP_CONCAT(i.`file_url` SEPARATOR ',') as thumbnail, pr.virtuemart_product_price_id, pr.product_price, pr.override, pr.product_override_price, pr.product_tax_id, pr.product_discount_id, pr.product_currency
  FROM `eqc_virtuemart_products_en_gb` as p
  LEFT JOIN `eqc_virtuemart_products`
  ON `eqc_virtuemart_products`.`virtuemart_product_id` = p.`virtuemart_product_id`
  LEFT JOIN `eqc_virtuemart_product_categories`
  ON p.`virtuemart_product_id` = `eqc_virtuemart_product_categories`.`virtuemart_product_id`
  LEFT JOIN `eqc_virtuemart_product_medias`
  ON p.`virtuemart_product_id` = `eqc_virtuemart_product_medias`.`virtuemart_product_id`
  LEFT JOIN `eqc_virtuemart_medias` as i
  ON `eqc_virtuemart_product_medias`.`virtuemart_media_id` = i.`virtuemart_media_id`
  LEFT JOIN `eqc_virtuemart_product_prices` as pr
  ON p.`virtuemart_product_id` = pr.`virtuemart_product_id`
  WHERE ( `eqc_virtuemart_product_categories`.`virtuemart_category_id` IN (9)
  AND `eqc_virtuemart_products`.`published`="1" )
  GROUP BY id
  ORDER BY RAND()
  LIMIT 1
462. SELECT p.`virtuemart_product_id` as id, `eqc_virtuemart_products`.`product_parent_id` as parent_id, `eqc_virtuemart_products`.`created_on`, p.`product_name` as name, GROUP_CONCAT(`eqc_virtuemart_product_categories`.`virtuemart_category_id` SEPARATOR ',') as categories, `eqc_virtuemart_product_categories`.`virtuemart_category_id` as category_id, GROUP_CONCAT(i.`file_url` SEPARATOR ',') as thumbnail, pr.virtuemart_product_price_id, pr.product_price, pr.override, pr.product_override_price, pr.product_tax_id, pr.product_discount_id, pr.product_currency
  FROM `eqc_virtuemart_products_en_gb` as p
  LEFT JOIN `eqc_virtuemart_products`
  ON `eqc_virtuemart_products`.`virtuemart_product_id` = p.`virtuemart_product_id`
  LEFT JOIN `eqc_virtuemart_product_categories`
  ON p.`virtuemart_product_id` = `eqc_virtuemart_product_categories`.`virtuemart_product_id`
  LEFT JOIN `eqc_virtuemart_product_medias`
  ON p.`virtuemart_product_id` = `eqc_virtuemart_product_medias`.`virtuemart_product_id`
  LEFT JOIN `eqc_virtuemart_medias` as i
  ON `eqc_virtuemart_product_medias`.`virtuemart_media_id` = i.`virtuemart_media_id`
  LEFT JOIN `eqc_virtuemart_product_prices` as pr
  ON p.`virtuemart_product_id` = pr.`virtuemart_product_id`
  WHERE ( `eqc_virtuemart_product_categories`.`virtuemart_category_id` IN (10)
  AND `eqc_virtuemart_products`.`published`="1" )
  GROUP BY id
  ORDER BY RAND()
  LIMIT 1
463. SELECT p.`virtuemart_product_id` as id, `eqc_virtuemart_products`.`product_parent_id` as parent_id, `eqc_virtuemart_products`.`created_on`, p.`product_name` as name, GROUP_CONCAT(`eqc_virtuemart_product_categories`.`virtuemart_category_id` SEPARATOR ',') as categories, `eqc_virtuemart_product_categories`.`virtuemart_category_id` as category_id, GROUP_CONCAT(i.`file_url` SEPARATOR ',') as thumbnail, pr.virtuemart_product_price_id, pr.product_price, pr.override, pr.product_override_price, pr.product_tax_id, pr.product_discount_id, pr.product_currency
  FROM `eqc_virtuemart_products_en_gb` as p
  LEFT JOIN `eqc_virtuemart_products`
  ON `eqc_virtuemart_products`.`virtuemart_product_id` = p.`virtuemart_product_id`
  LEFT JOIN `eqc_virtuemart_product_categories`
  ON p.`virtuemart_product_id` = `eqc_virtuemart_product_categories`.`virtuemart_product_id`
  LEFT JOIN `eqc_virtuemart_product_medias`
  ON p.`virtuemart_product_id` = `eqc_virtuemart_product_medias`.`virtuemart_product_id`
  LEFT JOIN `eqc_virtuemart_medias` as i
  ON `eqc_virtuemart_product_medias`.`virtuemart_media_id` = i.`virtuemart_media_id`
  LEFT JOIN `eqc_virtuemart_product_prices` as pr
  ON p.`virtuemart_product_id` = pr.`virtuemart_product_id`
  WHERE ( `eqc_virtuemart_product_categories`.`virtuemart_category_id` IN (46)
  AND `eqc_virtuemart_products`.`published`="1" )
  GROUP BY id
  ORDER BY RAND()
  LIMIT 1
464. SELECT p.`virtuemart_product_id` as id, `eqc_virtuemart_products`.`product_parent_id` as parent_id, `eqc_virtuemart_products`.`created_on`, p.`product_name` as name, GROUP_CONCAT(`eqc_virtuemart_product_categories`.`virtuemart_category_id` SEPARATOR ',') as categories, `eqc_virtuemart_product_categories`.`virtuemart_category_id` as category_id, GROUP_CONCAT(i.`file_url` SEPARATOR ',') as thumbnail, pr.virtuemart_product_price_id, pr.product_price, pr.override, pr.product_override_price, pr.product_tax_id, pr.product_discount_id, pr.product_currency
  FROM `eqc_virtuemart_products_en_gb` as p
  LEFT JOIN `eqc_virtuemart_products`
  ON `eqc_virtuemart_products`.`virtuemart_product_id` = p.`virtuemart_product_id`
  LEFT JOIN `eqc_virtuemart_product_categories`
  ON p.`virtuemart_product_id` = `eqc_virtuemart_product_categories`.`virtuemart_product_id`
  LEFT JOIN `eqc_virtuemart_product_medias`
  ON p.`virtuemart_product_id` = `eqc_virtuemart_product_medias`.`virtuemart_product_id`
  LEFT JOIN `eqc_virtuemart_medias` as i
  ON `eqc_virtuemart_product_medias`.`virtuemart_media_id` = i.`virtuemart_media_id`
  LEFT JOIN `eqc_virtuemart_product_prices` as pr
  ON p.`virtuemart_product_id` = pr.`virtuemart_product_id`
  WHERE ( `eqc_virtuemart_product_categories`.`virtuemart_category_id` IN (38)
  AND `eqc_virtuemart_products`.`published`="1" )
  GROUP BY id
  ORDER BY RAND()
  LIMIT 1
465. SELECT p.`virtuemart_product_id` as id, `eqc_virtuemart_products`.`product_parent_id` as parent_id, `eqc_virtuemart_products`.`created_on`, p.`product_name` as name, GROUP_CONCAT(`eqc_virtuemart_product_categories`.`virtuemart_category_id` SEPARATOR ',') as categories, `eqc_virtuemart_product_categories`.`virtuemart_category_id` as category_id, GROUP_CONCAT(i.`file_url` SEPARATOR ',') as thumbnail, pr.virtuemart_product_price_id, pr.product_price, pr.override, pr.product_override_price, pr.product_tax_id, pr.product_discount_id, pr.product_currency
  FROM `eqc_virtuemart_products_en_gb` as p
  LEFT JOIN `eqc_virtuemart_products`
  ON `eqc_virtuemart_products`.`virtuemart_product_id` = p.`virtuemart_product_id`
  LEFT JOIN `eqc_virtuemart_product_categories`
  ON p.`virtuemart_product_id` = `eqc_virtuemart_product_categories`.`virtuemart_product_id`
  LEFT JOIN `eqc_virtuemart_product_medias`
  ON p.`virtuemart_product_id` = `eqc_virtuemart_product_medias`.`virtuemart_product_id`
  LEFT JOIN `eqc_virtuemart_medias` as i
  ON `eqc_virtuemart_product_medias`.`virtuemart_media_id` = i.`virtuemart_media_id`
  LEFT JOIN `eqc_virtuemart_product_prices` as pr
  ON p.`virtuemart_product_id` = pr.`virtuemart_product_id`
  WHERE ( `eqc_virtuemart_product_categories`.`virtuemart_category_id` IN (18)
  AND `eqc_virtuemart_products`.`published`="1" )
  GROUP BY id
  ORDER BY RAND()
  LIMIT 1
466. SELECT p.`virtuemart_product_id` as id, `eqc_virtuemart_products`.`product_parent_id` as parent_id, `eqc_virtuemart_products`.`created_on`, p.`product_name` as name, GROUP_CONCAT(`eqc_virtuemart_product_categories`.`virtuemart_category_id` SEPARATOR ',') as categories, `eqc_virtuemart_product_categories`.`virtuemart_category_id` as category_id, GROUP_CONCAT(i.`file_url` SEPARATOR ',') as thumbnail, pr.virtuemart_product_price_id, pr.product_price, pr.override, pr.product_override_price, pr.product_tax_id, pr.product_discount_id, pr.product_currency
  FROM `eqc_virtuemart_products_en_gb` as p
  LEFT JOIN `eqc_virtuemart_products`
  ON `eqc_virtuemart_products`.`virtuemart_product_id` = p.`virtuemart_product_id`
  LEFT JOIN `eqc_virtuemart_product_categories`
  ON p.`virtuemart_product_id` = `eqc_virtuemart_product_categories`.`virtuemart_product_id`
  LEFT JOIN `eqc_virtuemart_product_medias`
  ON p.`virtuemart_product_id` = `eqc_virtuemart_product_medias`.`virtuemart_product_id`
  LEFT JOIN `eqc_virtuemart_medias` as i
  ON `eqc_virtuemart_product_medias`.`virtuemart_media_id` = i.`virtuemart_media_id`
  LEFT JOIN `eqc_virtuemart_product_prices` as pr
  ON p.`virtuemart_product_id` = pr.`virtuemart_product_id`
  WHERE ( `eqc_virtuemart_product_categories`.`virtuemart_category_id` IN (11)
  AND `eqc_virtuemart_products`.`published`="1" )
  GROUP BY id
  ORDER BY RAND()
  LIMIT 1
467. SELECT p.`virtuemart_product_id` as id, `eqc_virtuemart_products`.`product_parent_id` as parent_id, `eqc_virtuemart_products`.`created_on`, p.`product_name` as name, GROUP_CONCAT(`eqc_virtuemart_product_categories`.`virtuemart_category_id` SEPARATOR ',') as categories, `eqc_virtuemart_product_categories`.`virtuemart_category_id` as category_id, GROUP_CONCAT(i.`file_url` SEPARATOR ',') as thumbnail, pr.virtuemart_product_price_id, pr.product_price, pr.override, pr.product_override_price, pr.product_tax_id, pr.product_discount_id, pr.product_currency
  FROM `eqc_virtuemart_products_en_gb` as p
  LEFT JOIN `eqc_virtuemart_products`
  ON `eqc_virtuemart_products`.`virtuemart_product_id` = p.`virtuemart_product_id`
  LEFT JOIN `eqc_virtuemart_product_categories`
  ON p.`virtuemart_product_id` = `eqc_virtuemart_product_categories`.`virtuemart_product_id`
  LEFT JOIN `eqc_virtuemart_product_medias`
  ON p.`virtuemart_product_id` = `eqc_virtuemart_product_medias`.`virtuemart_product_id`
  LEFT JOIN `eqc_virtuemart_medias` as i
  ON `eqc_virtuemart_product_medias`.`virtuemart_media_id` = i.`virtuemart_media_id`
  LEFT JOIN `eqc_virtuemart_product_prices` as pr
  ON p.`virtuemart_product_id` = pr.`virtuemart_product_id`
  WHERE ( `eqc_virtuemart_product_categories`.`virtuemart_category_id` IN (45)
  AND `eqc_virtuemart_products`.`published`="1" )
  GROUP BY id
  ORDER BY RAND()
  LIMIT 1
468. SELECT p.`virtuemart_product_id` as id, `eqc_virtuemart_products`.`product_parent_id` as parent_id, `eqc_virtuemart_products`.`created_on`, p.`product_name` as name, GROUP_CONCAT(`eqc_virtuemart_product_categories`.`virtuemart_category_id` SEPARATOR ',') as categories, `eqc_virtuemart_product_categories`.`virtuemart_category_id` as category_id, GROUP_CONCAT(i.`file_url` SEPARATOR ',') as thumbnail, pr.virtuemart_product_price_id, pr.product_price, pr.override, pr.product_override_price, pr.product_tax_id, pr.product_discount_id, pr.product_currency
  FROM `eqc_virtuemart_products_en_gb` as p
  LEFT JOIN `eqc_virtuemart_products`
  ON `eqc_virtuemart_products`.`virtuemart_product_id` = p.`virtuemart_product_id`
  LEFT JOIN `eqc_virtuemart_product_categories`
  ON p.`virtuemart_product_id` = `eqc_virtuemart_product_categories`.`virtuemart_product_id`
  LEFT JOIN `eqc_virtuemart_product_medias`
  ON p.`virtuemart_product_id` = `eqc_virtuemart_product_medias`.`virtuemart_product_id`
  LEFT JOIN `eqc_virtuemart_medias` as i
  ON `eqc_virtuemart_product_medias`.`virtuemart_media_id` = i.`virtuemart_media_id`
  LEFT JOIN `eqc_virtuemart_product_prices` as pr
  ON p.`virtuemart_product_id` = pr.`virtuemart_product_id`
  WHERE ( `eqc_virtuemart_product_categories`.`virtuemart_category_id` IN (37)
  AND `eqc_virtuemart_products`.`published`="1" )
  GROUP BY id
  ORDER BY RAND()
  LIMIT 1
469. SELECT p.`virtuemart_product_id` as id, `eqc_virtuemart_products`.`product_parent_id` as parent_id, `eqc_virtuemart_products`.`created_on`, p.`product_name` as name, GROUP_CONCAT(`eqc_virtuemart_product_categories`.`virtuemart_category_id` SEPARATOR ',') as categories, `eqc_virtuemart_product_categories`.`virtuemart_category_id` as category_id, GROUP_CONCAT(i.`file_url` SEPARATOR ',') as thumbnail, pr.virtuemart_product_price_id, pr.product_price, pr.override, pr.product_override_price, pr.product_tax_id, pr.product_discount_id, pr.product_currency
  FROM `eqc_virtuemart_products_en_gb` as p
  LEFT JOIN `eqc_virtuemart_products`
  ON `eqc_virtuemart_products`.`virtuemart_product_id` = p.`virtuemart_product_id`
  LEFT JOIN `eqc_virtuemart_product_categories`
  ON p.`virtuemart_product_id` = `eqc_virtuemart_product_categories`.`virtuemart_product_id`
  LEFT JOIN `eqc_virtuemart_product_medias`
  ON p.`virtuemart_product_id` = `eqc_virtuemart_product_medias`.`virtuemart_product_id`
  LEFT JOIN `eqc_virtuemart_medias` as i
  ON `eqc_virtuemart_product_medias`.`virtuemart_media_id` = i.`virtuemart_media_id`
  LEFT JOIN `eqc_virtuemart_product_prices` as pr
  ON p.`virtuemart_product_id` = pr.`virtuemart_product_id`
  WHERE ( `eqc_virtuemart_product_categories`.`virtuemart_category_id` IN (58)
  AND `eqc_virtuemart_products`.`published`="1" )
  GROUP BY id
  ORDER BY RAND()
  LIMIT 1
470. SELECT p.`virtuemart_product_id` as id, `eqc_virtuemart_products`.`product_parent_id` as parent_id, `eqc_virtuemart_products`.`created_on`, p.`product_name` as name, GROUP_CONCAT(`eqc_virtuemart_product_categories`.`virtuemart_category_id` SEPARATOR ',') as categories, `eqc_virtuemart_product_categories`.`virtuemart_category_id` as category_id, GROUP_CONCAT(i.`file_url` SEPARATOR ',') as thumbnail, pr.virtuemart_product_price_id, pr.product_price, pr.override, pr.product_override_price, pr.product_tax_id, pr.product_discount_id, pr.product_currency
  FROM `eqc_virtuemart_products_en_gb` as p
  LEFT JOIN `eqc_virtuemart_products`
  ON `eqc_virtuemart_products`.`virtuemart_product_id` = p.`virtuemart_product_id`
  LEFT JOIN `eqc_virtuemart_product_categories`
  ON p.`virtuemart_product_id` = `eqc_virtuemart_product_categories`.`virtuemart_product_id`
  LEFT JOIN `eqc_virtuemart_product_medias`
  ON p.`virtuemart_product_id` = `eqc_virtuemart_product_medias`.`virtuemart_product_id`
  LEFT JOIN `eqc_virtuemart_medias` as i
  ON `eqc_virtuemart_product_medias`.`virtuemart_media_id` = i.`virtuemart_media_id`
  LEFT JOIN `eqc_virtuemart_product_prices` as pr
  ON p.`virtuemart_product_id` = pr.`virtuemart_product_id`
  WHERE ( `eqc_virtuemart_product_categories`.`virtuemart_category_id` IN (44)
  AND `eqc_virtuemart_products`.`published`="1" )
  GROUP BY id
  ORDER BY RAND()
  LIMIT 1
471. SELECT p.`virtuemart_product_id` as id, `eqc_virtuemart_products`.`product_parent_id` as parent_id, `eqc_virtuemart_products`.`created_on`, p.`product_name` as name, GROUP_CONCAT(`eqc_virtuemart_product_categories`.`virtuemart_category_id` SEPARATOR ',') as categories, `eqc_virtuemart_product_categories`.`virtuemart_category_id` as category_id, GROUP_CONCAT(i.`file_url` SEPARATOR ',') as thumbnail, pr.virtuemart_product_price_id, pr.product_price, pr.override, pr.product_override_price, pr.product_tax_id, pr.product_discount_id, pr.product_currency
  FROM `eqc_virtuemart_products_en_gb` as p
  LEFT JOIN `eqc_virtuemart_products`
  ON `eqc_virtuemart_products`.`virtuemart_product_id` = p.`virtuemart_product_id`
  LEFT JOIN `eqc_virtuemart_product_categories`
  ON p.`virtuemart_product_id` = `eqc_virtuemart_product_categories`.`virtuemart_product_id`
  LEFT JOIN `eqc_virtuemart_product_medias`
  ON p.`virtuemart_product_id` = `eqc_virtuemart_product_medias`.`virtuemart_product_id`
  LEFT JOIN `eqc_virtuemart_medias` as i
  ON `eqc_virtuemart_product_medias`.`virtuemart_media_id` = i.`virtuemart_media_id`
  LEFT JOIN `eqc_virtuemart_product_prices` as pr
  ON p.`virtuemart_product_id` = pr.`virtuemart_product_id`
  WHERE ( `eqc_virtuemart_product_categories`.`virtuemart_category_id` IN (39)
  AND `eqc_virtuemart_products`.`published`="1" )
  GROUP BY id
  ORDER BY RAND()
  LIMIT 1
472. SELECT p.`virtuemart_product_id` as id, `eqc_virtuemart_products`.`product_parent_id` as parent_id, `eqc_virtuemart_products`.`created_on`, p.`product_name` as name, GROUP_CONCAT(`eqc_virtuemart_product_categories`.`virtuemart_category_id` SEPARATOR ',') as categories, `eqc_virtuemart_product_categories`.`virtuemart_category_id` as category_id, GROUP_CONCAT(i.`file_url` SEPARATOR ',') as thumbnail, pr.virtuemart_product_price_id, pr.product_price, pr.override, pr.product_override_price, pr.product_tax_id, pr.product_discount_id, pr.product_currency
  FROM `eqc_virtuemart_products_en_gb` as p
  LEFT JOIN `eqc_virtuemart_products`
  ON `eqc_virtuemart_products`.`virtuemart_product_id` = p.`virtuemart_product_id`
  LEFT JOIN `eqc_virtuemart_product_categories`
  ON p.`virtuemart_product_id` = `eqc_virtuemart_product_categories`.`virtuemart_product_id`
  LEFT JOIN `eqc_virtuemart_product_medias`
  ON p.`virtuemart_product_id` = `eqc_virtuemart_product_medias`.`virtuemart_product_id`
  LEFT JOIN `eqc_virtuemart_medias` as i
  ON `eqc_virtuemart_product_medias`.`virtuemart_media_id` = i.`virtuemart_media_id`
  LEFT JOIN `eqc_virtuemart_product_prices` as pr
  ON p.`virtuemart_product_id` = pr.`virtuemart_product_id`
  WHERE ( `eqc_virtuemart_product_categories`.`virtuemart_category_id` IN (12)
  AND `eqc_virtuemart_products`.`published`="1" )
  GROUP BY id
  ORDER BY RAND()
  LIMIT 1
473. SELECT p.`virtuemart_product_id` as id, `eqc_virtuemart_products`.`product_parent_id` as parent_id, `eqc_virtuemart_products`.`created_on`, p.`product_name` as name, GROUP_CONCAT(`eqc_virtuemart_product_categories`.`virtuemart_category_id` SEPARATOR ',') as categories, `eqc_virtuemart_product_categories`.`virtuemart_category_id` as category_id, GROUP_CONCAT(i.`file_url` SEPARATOR ',') as thumbnail, pr.virtuemart_product_price_id, pr.product_price, pr.override, pr.product_override_price, pr.product_tax_id, pr.product_discount_id, pr.product_currency
  FROM `eqc_virtuemart_products_en_gb` as p
  LEFT JOIN `eqc_virtuemart_products`
  ON `eqc_virtuemart_products`.`virtuemart_product_id` = p.`virtuemart_product_id`
  LEFT JOIN `eqc_virtuemart_product_categories`
  ON p.`virtuemart_product_id` = `eqc_virtuemart_product_categories`.`virtuemart_product_id`
  LEFT JOIN `eqc_virtuemart_product_medias`
  ON p.`virtuemart_product_id` = `eqc_virtuemart_product_medias`.`virtuemart_product_id`
  LEFT JOIN `eqc_virtuemart_medias` as i
  ON `eqc_virtuemart_product_medias`.`virtuemart_media_id` = i.`virtuemart_media_id`
  LEFT JOIN `eqc_virtuemart_product_prices` as pr
  ON p.`virtuemart_product_id` = pr.`virtuemart_product_id`
  WHERE ( `eqc_virtuemart_product_categories`.`virtuemart_category_id` IN (13)
  AND `eqc_virtuemart_products`.`published`="1" )
  GROUP BY id
  ORDER BY RAND()
  LIMIT 1
474. SELECT p.`virtuemart_product_id` as id, `eqc_virtuemart_products`.`product_parent_id` as parent_id, `eqc_virtuemart_products`.`created_on`, p.`product_name` as name, GROUP_CONCAT(`eqc_virtuemart_product_categories`.`virtuemart_category_id` SEPARATOR ',') as categories, `eqc_virtuemart_product_categories`.`virtuemart_category_id` as category_id, GROUP_CONCAT(i.`file_url` SEPARATOR ',') as thumbnail, pr.virtuemart_product_price_id, pr.product_price, pr.override, pr.product_override_price, pr.product_tax_id, pr.product_discount_id, pr.product_currency
  FROM `eqc_virtuemart_products_en_gb` as p
  LEFT JOIN `eqc_virtuemart_products`
  ON `eqc_virtuemart_products`.`virtuemart_product_id` = p.`virtuemart_product_id`
  LEFT JOIN `eqc_virtuemart_product_categories`
  ON p.`virtuemart_product_id` = `eqc_virtuemart_product_categories`.`virtuemart_product_id`
  LEFT JOIN `eqc_virtuemart_product_medias`
  ON p.`virtuemart_product_id` = `eqc_virtuemart_product_medias`.`virtuemart_product_id`
  LEFT JOIN `eqc_virtuemart_medias` as i
  ON `eqc_virtuemart_product_medias`.`virtuemart_media_id` = i.`virtuemart_media_id`
  LEFT JOIN `eqc_virtuemart_product_prices` as pr
  ON p.`virtuemart_product_id` = pr.`virtuemart_product_id`
  WHERE ( `eqc_virtuemart_product_categories`.`virtuemart_category_id` IN (14)
  AND `eqc_virtuemart_products`.`published`="1" )
  GROUP BY id
  ORDER BY RAND()
  LIMIT 1
475. SELECT p.`virtuemart_product_id` as id, `eqc_virtuemart_products`.`product_parent_id` as parent_id, `eqc_virtuemart_products`.`created_on`, p.`product_name` as name, GROUP_CONCAT(`eqc_virtuemart_product_categories`.`virtuemart_category_id` SEPARATOR ',') as categories, `eqc_virtuemart_product_categories`.`virtuemart_category_id` as category_id, GROUP_CONCAT(i.`file_url` SEPARATOR ',') as thumbnail, pr.virtuemart_product_price_id, pr.product_price, pr.override, pr.product_override_price, pr.product_tax_id, pr.product_discount_id, pr.product_currency
  FROM `eqc_virtuemart_products_en_gb` as p
  LEFT JOIN `eqc_virtuemart_products`
  ON `eqc_virtuemart_products`.`virtuemart_product_id` = p.`virtuemart_product_id`
  LEFT JOIN `eqc_virtuemart_product_categories`
  ON p.`virtuemart_product_id` = `eqc_virtuemart_product_categories`.`virtuemart_product_id`
  LEFT JOIN `eqc_virtuemart_product_medias`
  ON p.`virtuemart_product_id` = `eqc_virtuemart_product_medias`.`virtuemart_product_id`
  LEFT JOIN `eqc_virtuemart_medias` as i
  ON `eqc_virtuemart_product_medias`.`virtuemart_media_id` = i.`virtuemart_media_id`
  LEFT JOIN `eqc_virtuemart_product_prices` as pr
  ON p.`virtuemart_product_id` = pr.`virtuemart_product_id`
  WHERE ( `eqc_virtuemart_product_categories`.`virtuemart_category_id` IN (15)
  AND `eqc_virtuemart_products`.`published`="1" )
  GROUP BY id
  ORDER BY RAND()
  LIMIT 1
476. SELECT p.`virtuemart_product_id` as id, `eqc_virtuemart_products`.`product_parent_id` as parent_id, `eqc_virtuemart_products`.`created_on`, p.`product_name` as name, GROUP_CONCAT(`eqc_virtuemart_product_categories`.`virtuemart_category_id` SEPARATOR ',') as categories, `eqc_virtuemart_product_categories`.`virtuemart_category_id` as category_id, GROUP_CONCAT(i.`file_url` SEPARATOR ',') as thumbnail, pr.virtuemart_product_price_id, pr.product_price, pr.override, pr.product_override_price, pr.product_tax_id, pr.product_discount_id, pr.product_currency
  FROM `eqc_virtuemart_products_en_gb` as p
  LEFT JOIN `eqc_virtuemart_products`
  ON `eqc_virtuemart_products`.`virtuemart_product_id` = p.`virtuemart_product_id`
  LEFT JOIN `eqc_virtuemart_product_categories`
  ON p.`virtuemart_product_id` = `eqc_virtuemart_product_categories`.`virtuemart_product_id`
  LEFT JOIN `eqc_virtuemart_product_medias`
  ON p.`virtuemart_product_id` = `eqc_virtuemart_product_medias`.`virtuemart_product_id`
  LEFT JOIN `eqc_virtuemart_medias` as i
  ON `eqc_virtuemart_product_medias`.`virtuemart_media_id` = i.`virtuemart_media_id`
  LEFT JOIN `eqc_virtuemart_product_prices` as pr
  ON p.`virtuemart_product_id` = pr.`virtuemart_product_id`
  WHERE ( `eqc_virtuemart_product_categories`.`virtuemart_category_id` IN (1)
  AND `eqc_virtuemart_products`.`published`="1" )
  GROUP BY id
  ORDER BY RAND()
  LIMIT 1
477. SELECT p.`virtuemart_product_id` as id, `eqc_virtuemart_products`.`product_parent_id` as parent_id, `eqc_virtuemart_products`.`created_on`, p.`product_name` as name, GROUP_CONCAT(`eqc_virtuemart_product_categories`.`virtuemart_category_id` SEPARATOR ',') as categories, `eqc_virtuemart_product_categories`.`virtuemart_category_id` as category_id, GROUP_CONCAT(i.`file_url` SEPARATOR ',') as thumbnail, pr.virtuemart_product_price_id, pr.product_price, pr.override, pr.product_override_price, pr.product_tax_id, pr.product_discount_id, pr.product_currency
  FROM `eqc_virtuemart_products_en_gb` as p
  LEFT JOIN `eqc_virtuemart_products`
  ON `eqc_virtuemart_products`.`virtuemart_product_id` = p.`virtuemart_product_id`
  LEFT JOIN `eqc_virtuemart_product_categories`
  ON p.`virtuemart_product_id` = `eqc_virtuemart_product_categories`.`virtuemart_product_id`
  LEFT JOIN `eqc_virtuemart_product_medias`
  ON p.`virtuemart_product_id` = `eqc_virtuemart_product_medias`.`virtuemart_product_id`
  LEFT JOIN `eqc_virtuemart_medias` as i
  ON `eqc_virtuemart_product_medias`.`virtuemart_media_id` = i.`virtuemart_media_id`
  LEFT JOIN `eqc_virtuemart_product_prices` as pr
  ON p.`virtuemart_product_id` = pr.`virtuemart_product_id`
  WHERE ( `eqc_virtuemart_product_categories`.`virtuemart_category_id` IN (16)
  AND `eqc_virtuemart_products`.`published`="1" )
  GROUP BY id
  ORDER BY RAND()
  LIMIT 1
478. SELECT p.`virtuemart_product_id` as id, `eqc_virtuemart_products`.`product_parent_id` as parent_id, `eqc_virtuemart_products`.`created_on`, p.`product_name` as name, GROUP_CONCAT(`eqc_virtuemart_product_categories`.`virtuemart_category_id` SEPARATOR ',') as categories, `eqc_virtuemart_product_categories`.`virtuemart_category_id` as category_id, GROUP_CONCAT(i.`file_url` SEPARATOR ',') as thumbnail, pr.virtuemart_product_price_id, pr.product_price, pr.override, pr.product_override_price, pr.product_tax_id, pr.product_discount_id, pr.product_currency
  FROM `eqc_virtuemart_products_en_gb` as p
  LEFT JOIN `eqc_virtuemart_products`
  ON `eqc_virtuemart_products`.`virtuemart_product_id` = p.`virtuemart_product_id`
  LEFT JOIN `eqc_virtuemart_product_categories`
  ON p.`virtuemart_product_id` = `eqc_virtuemart_product_categories`.`virtuemart_product_id`
  LEFT JOIN `eqc_virtuemart_product_medias`
  ON p.`virtuemart_product_id` = `eqc_virtuemart_product_medias`.`virtuemart_product_id`
  LEFT JOIN `eqc_virtuemart_medias` as i
  ON `eqc_virtuemart_product_medias`.`virtuemart_media_id` = i.`virtuemart_media_id`
  LEFT JOIN `eqc_virtuemart_product_prices` as pr
  ON p.`virtuemart_product_id` = pr.`virtuemart_product_id`
  WHERE ( `eqc_virtuemart_product_categories`.`virtuemart_category_id` IN (4)
  AND `eqc_virtuemart_products`.`published`="1" )
  GROUP BY id
  ORDER BY RAND()
  LIMIT 1
479. SELECT p.`virtuemart_product_id` as id, `eqc_virtuemart_products`.`product_parent_id` as parent_id, `eqc_virtuemart_products`.`created_on`, p.`product_name` as name, GROUP_CONCAT(`eqc_virtuemart_product_categories`.`virtuemart_category_id` SEPARATOR ',') as categories, `eqc_virtuemart_product_categories`.`virtuemart_category_id` as category_id, GROUP_CONCAT(i.`file_url` SEPARATOR ',') as thumbnail, pr.virtuemart_product_price_id, pr.product_price, pr.override, pr.product_override_price, pr.product_tax_id, pr.product_discount_id, pr.product_currency
  FROM `eqc_virtuemart_products_en_gb` as p
  LEFT JOIN `eqc_virtuemart_products`
  ON `eqc_virtuemart_products`.`virtuemart_product_id` = p.`virtuemart_product_id`
  LEFT JOIN `eqc_virtuemart_product_categories`
  ON p.`virtuemart_product_id` = `eqc_virtuemart_product_categories`.`virtuemart_product_id`
  LEFT JOIN `eqc_virtuemart_product_medias`
  ON p.`virtuemart_product_id` = `eqc_virtuemart_product_medias`.`virtuemart_product_id`
  LEFT JOIN `eqc_virtuemart_medias` as i
  ON `eqc_virtuemart_product_medias`.`virtuemart_media_id` = i.`virtuemart_media_id`
  LEFT JOIN `eqc_virtuemart_product_prices` as pr
  ON p.`virtuemart_product_id` = pr.`virtuemart_product_id`
  WHERE ( `eqc_virtuemart_product_categories`.`virtuemart_category_id` IN (19)
  AND `eqc_virtuemart_products`.`published`="1" )
  GROUP BY id
  ORDER BY RAND()
  LIMIT 1
480. SELECT p.`virtuemart_product_id` as id, `eqc_virtuemart_products`.`product_parent_id` as parent_id, `eqc_virtuemart_products`.`created_on`, p.`product_name` as name, GROUP_CONCAT(`eqc_virtuemart_product_categories`.`virtuemart_category_id` SEPARATOR ',') as categories, `eqc_virtuemart_product_categories`.`virtuemart_category_id` as category_id, GROUP_CONCAT(i.`file_url` SEPARATOR ',') as thumbnail, pr.virtuemart_product_price_id, pr.product_price, pr.override, pr.product_override_price, pr.product_tax_id, pr.product_discount_id, pr.product_currency
  FROM `eqc_virtuemart_products_en_gb` as p
  LEFT JOIN `eqc_virtuemart_products`
  ON `eqc_virtuemart_products`.`virtuemart_product_id` = p.`virtuemart_product_id`
  LEFT JOIN `eqc_virtuemart_product_categories`
  ON p.`virtuemart_product_id` = `eqc_virtuemart_product_categories`.`virtuemart_product_id`
  LEFT JOIN `eqc_virtuemart_product_medias`
  ON p.`virtuemart_product_id` = `eqc_virtuemart_product_medias`.`virtuemart_product_id`
  LEFT JOIN `eqc_virtuemart_medias` as i
  ON `eqc_virtuemart_product_medias`.`virtuemart_media_id` = i.`virtuemart_media_id`
  LEFT JOIN `eqc_virtuemart_product_prices` as pr
  ON p.`virtuemart_product_id` = pr.`virtuemart_product_id`
  WHERE ( `eqc_virtuemart_product_categories`.`virtuemart_category_id` IN (3)
  AND `eqc_virtuemart_products`.`published`="1" )
  GROUP BY id
  ORDER BY RAND()
  LIMIT 1
481. SELECT p.`virtuemart_product_id` as id, `eqc_virtuemart_products`.`product_parent_id` as parent_id, `eqc_virtuemart_products`.`created_on`, p.`product_name` as name, GROUP_CONCAT(`eqc_virtuemart_product_categories`.`virtuemart_category_id` SEPARATOR ',') as categories, `eqc_virtuemart_product_categories`.`virtuemart_category_id` as category_id, GROUP_CONCAT(i.`file_url` SEPARATOR ',') as thumbnail, pr.virtuemart_product_price_id, pr.product_price, pr.override, pr.product_override_price, pr.product_tax_id, pr.product_discount_id, pr.product_currency
  FROM `eqc_virtuemart_products_en_gb` as p
  LEFT JOIN `eqc_virtuemart_products`
  ON `eqc_virtuemart_products`.`virtuemart_product_id` = p.`virtuemart_product_id`
  LEFT JOIN `eqc_virtuemart_product_categories`
  ON p.`virtuemart_product_id` = `eqc_virtuemart_product_categories`.`virtuemart_product_id`
  LEFT JOIN `eqc_virtuemart_product_medias`
  ON p.`virtuemart_product_id` = `eqc_virtuemart_product_medias`.`virtuemart_product_id`
  LEFT JOIN `eqc_virtuemart_medias` as i
  ON `eqc_virtuemart_product_medias`.`virtuemart_media_id` = i.`virtuemart_media_id`
  LEFT JOIN `eqc_virtuemart_product_prices` as pr
  ON p.`virtuemart_product_id` = pr.`virtuemart_product_id`
  WHERE ( `eqc_virtuemart_product_categories`.`virtuemart_category_id` IN (34)
  AND `eqc_virtuemart_products`.`published`="1" )
  GROUP BY id
  ORDER BY RAND()
  LIMIT 1
482. SELECT p.`virtuemart_product_id` as id, `eqc_virtuemart_products`.`product_parent_id` as parent_id, `eqc_virtuemart_products`.`created_on`, p.`product_name` as name, GROUP_CONCAT(`eqc_virtuemart_product_categories`.`virtuemart_category_id` SEPARATOR ',') as categories, `eqc_virtuemart_product_categories`.`virtuemart_category_id` as category_id, GROUP_CONCAT(i.`file_url` SEPARATOR ',') as thumbnail, pr.virtuemart_product_price_id, pr.product_price, pr.override, pr.product_override_price, pr.product_tax_id, pr.product_discount_id, pr.product_currency
  FROM `eqc_virtuemart_products_en_gb` as p
  LEFT JOIN `eqc_virtuemart_products`
  ON `eqc_virtuemart_products`.`virtuemart_product_id` = p.`virtuemart_product_id`
  LEFT JOIN `eqc_virtuemart_product_categories`
  ON p.`virtuemart_product_id` = `eqc_virtuemart_product_categories`.`virtuemart_product_id`
  LEFT JOIN `eqc_virtuemart_product_medias`
  ON p.`virtuemart_product_id` = `eqc_virtuemart_product_medias`.`virtuemart_product_id`
  LEFT JOIN `eqc_virtuemart_medias` as i
  ON `eqc_virtuemart_product_medias`.`virtuemart_media_id` = i.`virtuemart_media_id`
  LEFT JOIN `eqc_virtuemart_product_prices` as pr
  ON p.`virtuemart_product_id` = pr.`virtuemart_product_id`
  WHERE ( `eqc_virtuemart_product_categories`.`virtuemart_category_id` IN (22)
  AND `eqc_virtuemart_products`.`published`="1" )
  GROUP BY id
  ORDER BY RAND()
  LIMIT 1
483. SELECT p.`virtuemart_product_id` as id, `eqc_virtuemart_products`.`product_parent_id` as parent_id, `eqc_virtuemart_products`.`created_on`, p.`product_name` as name, GROUP_CONCAT(`eqc_virtuemart_product_categories`.`virtuemart_category_id` SEPARATOR ',') as categories, `eqc_virtuemart_product_categories`.`virtuemart_category_id` as category_id, GROUP_CONCAT(i.`file_url` SEPARATOR ',') as thumbnail, pr.virtuemart_product_price_id, pr.product_price, pr.override, pr.product_override_price, pr.product_tax_id, pr.product_discount_id, pr.product_currency
  FROM `eqc_virtuemart_products_en_gb` as p
  LEFT JOIN `eqc_virtuemart_products`
  ON `eqc_virtuemart_products`.`virtuemart_product_id` = p.`virtuemart_product_id`
  LEFT JOIN `eqc_virtuemart_product_categories`
  ON p.`virtuemart_product_id` = `eqc_virtuemart_product_categories`.`virtuemart_product_id`
  LEFT JOIN `eqc_virtuemart_product_medias`
  ON p.`virtuemart_product_id` = `eqc_virtuemart_product_medias`.`virtuemart_product_id`
  LEFT JOIN `eqc_virtuemart_medias` as i
  ON `eqc_virtuemart_product_medias`.`virtuemart_media_id` = i.`virtuemart_media_id`
  LEFT JOIN `eqc_virtuemart_product_prices` as pr
  ON p.`virtuemart_product_id` = pr.`virtuemart_product_id`
  WHERE ( `eqc_virtuemart_product_categories`.`virtuemart_category_id` IN (24)
  AND `eqc_virtuemart_products`.`published`="1" )
  GROUP BY id
  ORDER BY RAND()
  LIMIT 1
484. SELECT p.`virtuemart_product_id` as id, `eqc_virtuemart_products`.`product_parent_id` as parent_id, `eqc_virtuemart_products`.`created_on`, p.`product_name` as name, GROUP_CONCAT(`eqc_virtuemart_product_categories`.`virtuemart_category_id` SEPARATOR ',') as categories, `eqc_virtuemart_product_categories`.`virtuemart_category_id` as category_id, GROUP_CONCAT(i.`file_url` SEPARATOR ',') as thumbnail, pr.virtuemart_product_price_id, pr.product_price, pr.override, pr.product_override_price, pr.product_tax_id, pr.product_discount_id, pr.product_currency
  FROM `eqc_virtuemart_products_en_gb` as p
  LEFT JOIN `eqc_virtuemart_products`
  ON `eqc_virtuemart_products`.`virtuemart_product_id` = p.`virtuemart_product_id`
  LEFT JOIN `eqc_virtuemart_product_categories`
  ON p.`virtuemart_product_id` = `eqc_virtuemart_product_categories`.`virtuemart_product_id`
  LEFT JOIN `eqc_virtuemart_product_medias`
  ON p.`virtuemart_product_id` = `eqc_virtuemart_product_medias`.`virtuemart_product_id`
  LEFT JOIN `eqc_virtuemart_medias` as i
  ON `eqc_virtuemart_product_medias`.`virtuemart_media_id` = i.`virtuemart_media_id`
  LEFT JOIN `eqc_virtuemart_product_prices` as pr
  ON p.`virtuemart_product_id` = pr.`virtuemart_product_id`
  WHERE ( `eqc_virtuemart_product_categories`.`virtuemart_category_id` IN (25)
  AND `eqc_virtuemart_products`.`published`="1" )
  GROUP BY id
  ORDER BY RAND()
  LIMIT 1
485. SELECT p.`virtuemart_product_id` as id, `eqc_virtuemart_products`.`product_parent_id` as parent_id, `eqc_virtuemart_products`.`created_on`, p.`product_name` as name, GROUP_CONCAT(`eqc_virtuemart_product_categories`.`virtuemart_category_id` SEPARATOR ',') as categories, `eqc_virtuemart_product_categories`.`virtuemart_category_id` as category_id, GROUP_CONCAT(i.`file_url` SEPARATOR ',') as thumbnail, pr.virtuemart_product_price_id, pr.product_price, pr.override, pr.product_override_price, pr.product_tax_id, pr.product_discount_id, pr.product_currency
  FROM `eqc_virtuemart_products_en_gb` as p
  LEFT JOIN `eqc_virtuemart_products`
  ON `eqc_virtuemart_products`.`virtuemart_product_id` = p.`virtuemart_product_id`
  LEFT JOIN `eqc_virtuemart_product_categories`
  ON p.`virtuemart_product_id` = `eqc_virtuemart_product_categories`.`virtuemart_product_id`
  LEFT JOIN `eqc_virtuemart_product_medias`
  ON p.`virtuemart_product_id` = `eqc_virtuemart_product_medias`.`virtuemart_product_id`
  LEFT JOIN `eqc_virtuemart_medias` as i
  ON `eqc_virtuemart_product_medias`.`virtuemart_media_id` = i.`virtuemart_media_id`
  LEFT JOIN `eqc_virtuemart_product_prices` as pr
  ON p.`virtuemart_product_id` = pr.`virtuemart_product_id`
  WHERE ( `eqc_virtuemart_product_categories`.`virtuemart_category_id` IN (2)
  AND `eqc_virtuemart_products`.`published`="1" )
  GROUP BY id
  ORDER BY RAND()
  LIMIT 1
486. SELECT p.`virtuemart_product_id` as id, `eqc_virtuemart_products`.`product_parent_id` as parent_id, `eqc_virtuemart_products`.`created_on`, p.`product_name` as name, GROUP_CONCAT(`eqc_virtuemart_product_categories`.`virtuemart_category_id` SEPARATOR ',') as categories, `eqc_virtuemart_product_categories`.`virtuemart_category_id` as category_id, GROUP_CONCAT(i.`file_url` SEPARATOR ',') as thumbnail, pr.virtuemart_product_price_id, pr.product_price, pr.override, pr.product_override_price, pr.product_tax_id, pr.product_discount_id, pr.product_currency
  FROM `eqc_virtuemart_products_en_gb` as p
  LEFT JOIN `eqc_virtuemart_products`
  ON `eqc_virtuemart_products`.`virtuemart_product_id` = p.`virtuemart_product_id`
  LEFT JOIN `eqc_virtuemart_product_categories`
  ON p.`virtuemart_product_id` = `eqc_virtuemart_product_categories`.`virtuemart_product_id`
  LEFT JOIN `eqc_virtuemart_product_medias`
  ON p.`virtuemart_product_id` = `eqc_virtuemart_product_medias`.`virtuemart_product_id`
  LEFT JOIN `eqc_virtuemart_medias` as i
  ON `eqc_virtuemart_product_medias`.`virtuemart_media_id` = i.`virtuemart_media_id`
  LEFT JOIN `eqc_virtuemart_product_prices` as pr
  ON p.`virtuemart_product_id` = pr.`virtuemart_product_id`
  WHERE ( `eqc_virtuemart_product_categories`.`virtuemart_category_id` IN (26)
  AND `eqc_virtuemart_products`.`published`="1" )
  GROUP BY id
  ORDER BY RAND()
  LIMIT 1
487. SELECT p.`virtuemart_product_id` as id, `eqc_virtuemart_products`.`product_parent_id` as parent_id, `eqc_virtuemart_products`.`created_on`, p.`product_name` as name, GROUP_CONCAT(`eqc_virtuemart_product_categories`.`virtuemart_category_id` SEPARATOR ',') as categories, `eqc_virtuemart_product_categories`.`virtuemart_category_id` as category_id, GROUP_CONCAT(i.`file_url` SEPARATOR ',') as thumbnail, pr.virtuemart_product_price_id, pr.product_price, pr.override, pr.product_override_price, pr.product_tax_id, pr.product_discount_id, pr.product_currency
  FROM `eqc_virtuemart_products_en_gb` as p
  LEFT JOIN `eqc_virtuemart_products`
  ON `eqc_virtuemart_products`.`virtuemart_product_id` = p.`virtuemart_product_id`
  LEFT JOIN `eqc_virtuemart_product_categories`
  ON p.`virtuemart_product_id` = `eqc_virtuemart_product_categories`.`virtuemart_product_id`
  LEFT JOIN `eqc_virtuemart_product_medias`
  ON p.`virtuemart_product_id` = `eqc_virtuemart_product_medias`.`virtuemart_product_id`
  LEFT JOIN `eqc_virtuemart_medias` as i
  ON `eqc_virtuemart_product_medias`.`virtuemart_media_id` = i.`virtuemart_media_id`
  LEFT JOIN `eqc_virtuemart_product_prices` as pr
  ON p.`virtuemart_product_id` = pr.`virtuemart_product_id`
  WHERE ( `eqc_virtuemart_product_categories`.`virtuemart_category_id` IN (27)
  AND `eqc_virtuemart_products`.`published`="1" )
  GROUP BY id
  ORDER BY RAND()
  LIMIT 1
488. SELECT `slug`
  FROM `eqc_virtuemart_products_en_gb`
  WHERE `virtuemart_product_id` = 572
489. SELECT `slug`
  FROM `eqc_virtuemart_products_en_gb`
  WHERE `virtuemart_product_id` = 637
490. SELECT `slug`
  FROM `eqc_virtuemart_products_en_gb`
  WHERE `virtuemart_product_id` = 1161
491. SELECT `slug`
  FROM `eqc_virtuemart_products_en_gb`
  WHERE `virtuemart_product_id` = 99
492. SELECT `slug`
  FROM `eqc_virtuemart_products_en_gb`
  WHERE `virtuemart_product_id` = 327
493. SELECT `slug`
  FROM `eqc_virtuemart_products_en_gb`
  WHERE `virtuemart_product_id` = 1517
494. SELECT `slug`
  FROM `eqc_virtuemart_products_en_gb`
  WHERE `virtuemart_product_id` = 1363
495. SELECT `slug`
  FROM `eqc_virtuemart_products_en_gb`
  WHERE `virtuemart_product_id` = 141
496. SELECT `slug`
  FROM `eqc_virtuemart_products_en_gb`
  WHERE `virtuemart_product_id` = 115
497. SELECT `slug`
  FROM `eqc_virtuemart_products_en_gb`
  WHERE `virtuemart_product_id` = 1439
498. SELECT `slug`
  FROM `eqc_virtuemart_products_en_gb`
  WHERE `virtuemart_product_id` = 802
499. SELECT `slug`
  FROM `eqc_virtuemart_products_en_gb`
  WHERE `virtuemart_product_id` = 1843
500. SELECT `slug`
  FROM `eqc_virtuemart_products_en_gb`
  WHERE `virtuemart_product_id` = 1482
501. SELECT `slug`
  FROM `eqc_virtuemart_products_en_gb`
  WHERE `virtuemart_product_id` = 873
502. SELECT `slug`
  FROM `eqc_virtuemart_products_en_gb`
  WHERE `virtuemart_product_id` = 334
503. SELECT `slug`
  FROM `eqc_virtuemart_products_en_gb`
  WHERE `virtuemart_product_id` = 171
504. SELECT `slug`
  FROM `eqc_virtuemart_products_en_gb`
  WHERE `virtuemart_product_id` = 354
505. SELECT `slug`
  FROM `eqc_virtuemart_products_en_gb`
  WHERE `virtuemart_product_id` = 133
506. SELECT `slug`
  FROM `eqc_virtuemart_products_en_gb`
  WHERE `virtuemart_product_id` = 1
507. SELECT `slug`
  FROM `eqc_virtuemart_products_en_gb`
  WHERE `virtuemart_product_id` = 377
508. SELECT `slug`
  FROM `eqc_virtuemart_products_en_gb`
  WHERE `virtuemart_product_id` = 1385
509. SELECT `slug`
  FROM `eqc_virtuemart_products_en_gb`
  WHERE `virtuemart_product_id` = 397
510. SELECT `slug`
  FROM `eqc_virtuemart_products_en_gb`
  WHERE `virtuemart_product_id` = 263
511. SELECT `slug`
  FROM `eqc_virtuemart_products_en_gb`
  WHERE `virtuemart_product_id` = 587
512. SELECT `slug`
  FROM `eqc_virtuemart_products_en_gb`
  WHERE `virtuemart_product_id` = 1218
513. SELECT `slug`
  FROM `eqc_virtuemart_products_en_gb`
  WHERE `virtuemart_product_id` = 415
514. SELECT `slug`
  FROM `eqc_virtuemart_products_en_gb`
  WHERE `virtuemart_product_id` = 1880
515. SELECT `slug`
  FROM `eqc_virtuemart_products_en_gb`
  WHERE `virtuemart_product_id` = 550
516. SELECT `slug`
  FROM `eqc_virtuemart_products_en_gb`
  WHERE `virtuemart_product_id` = 1165
517. SELECT `slug`
  FROM `eqc_virtuemart_products_en_gb`
  WHERE `virtuemart_product_id` = 458
518. SELECT p.`virtuemart_product_id` as id, `eqc_virtuemart_products`.`product_parent_id` as parent_id, `eqc_virtuemart_products`.`created_on`, p.`product_name` as name, GROUP_CONCAT(`eqc_virtuemart_product_categories`.`virtuemart_category_id` SEPARATOR ',') as categories, `eqc_virtuemart_product_categories`.`virtuemart_category_id` as category_id, GROUP_CONCAT(i.`file_url` SEPARATOR ',') as thumbnail, pr.virtuemart_product_price_id, pr.product_price, pr.override, pr.product_override_price, pr.product_tax_id, pr.product_discount_id, pr.product_currency
  FROM `eqc_virtuemart_products_en_gb` as p
  LEFT JOIN `eqc_virtuemart_products`
  ON `eqc_virtuemart_products`.`virtuemart_product_id` = p.`virtuemart_product_id`
  LEFT JOIN `eqc_virtuemart_product_categories`
  ON p.`virtuemart_product_id` = `eqc_virtuemart_product_categories`.`virtuemart_product_id`
  LEFT JOIN `eqc_virtuemart_product_medias`
  ON p.`virtuemart_product_id` = `eqc_virtuemart_product_medias`.`virtuemart_product_id`
  LEFT JOIN `eqc_virtuemart_medias` as i
  ON `eqc_virtuemart_product_medias`.`virtuemart_media_id` = i.`virtuemart_media_id`
  LEFT JOIN `eqc_virtuemart_product_prices` as pr
  ON p.`virtuemart_product_id` = pr.`virtuemart_product_id`
  WHERE ( `eqc_virtuemart_product_categories`.`virtuemart_category_id` IN (52)
  AND `eqc_virtuemart_products`.`published`="1" )
  GROUP BY id
  ORDER BY RAND()
  LIMIT 1
519. SELECT p.`virtuemart_product_id` as id, `eqc_virtuemart_products`.`product_parent_id` as parent_id, `eqc_virtuemart_products`.`created_on`, p.`product_name` as name, GROUP_CONCAT(`eqc_virtuemart_product_categories`.`virtuemart_category_id` SEPARATOR ',') as categories, `eqc_virtuemart_product_categories`.`virtuemart_category_id` as category_id, GROUP_CONCAT(i.`file_url` SEPARATOR ',') as thumbnail, pr.virtuemart_product_price_id, pr.product_price, pr.override, pr.product_override_price, pr.product_tax_id, pr.product_discount_id, pr.product_currency
  FROM `eqc_virtuemart_products_en_gb` as p
  LEFT JOIN `eqc_virtuemart_products`
  ON `eqc_virtuemart_products`.`virtuemart_product_id` = p.`virtuemart_product_id`
  LEFT JOIN `eqc_virtuemart_product_categories`
  ON p.`virtuemart_product_id` = `eqc_virtuemart_product_categories`.`virtuemart_product_id`
  LEFT JOIN `eqc_virtuemart_product_medias`
  ON p.`virtuemart_product_id` = `eqc_virtuemart_product_medias`.`virtuemart_product_id`
  LEFT JOIN `eqc_virtuemart_medias` as i
  ON `eqc_virtuemart_product_medias`.`virtuemart_media_id` = i.`virtuemart_media_id`
  LEFT JOIN `eqc_virtuemart_product_prices` as pr
  ON p.`virtuemart_product_id` = pr.`virtuemart_product_id`
  WHERE ( `eqc_virtuemart_product_categories`.`virtuemart_category_id` IN (7)
  AND `eqc_virtuemart_products`.`published`="1" )
  GROUP BY id
  ORDER BY RAND()
  LIMIT 1
520. SELECT p.`virtuemart_product_id` as id, `eqc_virtuemart_products`.`product_parent_id` as parent_id, `eqc_virtuemart_products`.`created_on`, p.`product_name` as name, GROUP_CONCAT(`eqc_virtuemart_product_categories`.`virtuemart_category_id` SEPARATOR ',') as categories, `eqc_virtuemart_product_categories`.`virtuemart_category_id` as category_id, GROUP_CONCAT(i.`file_url` SEPARATOR ',') as thumbnail, pr.virtuemart_product_price_id, pr.product_price, pr.override, pr.product_override_price, pr.product_tax_id, pr.product_discount_id, pr.product_currency
  FROM `eqc_virtuemart_products_en_gb` as p
  LEFT JOIN `eqc_virtuemart_products`
  ON `eqc_virtuemart_products`.`virtuemart_product_id` = p.`virtuemart_product_id`
  LEFT JOIN `eqc_virtuemart_product_categories`
  ON p.`virtuemart_product_id` = `eqc_virtuemart_product_categories`.`virtuemart_product_id`
  LEFT JOIN `eqc_virtuemart_product_medias`
  ON p.`virtuemart_product_id` = `eqc_virtuemart_product_medias`.`virtuemart_product_id`
  LEFT JOIN `eqc_virtuemart_medias` as i
  ON `eqc_virtuemart_product_medias`.`virtuemart_media_id` = i.`virtuemart_media_id`
  LEFT JOIN `eqc_virtuemart_product_prices` as pr
  ON p.`virtuemart_product_id` = pr.`virtuemart_product_id`
  WHERE ( `eqc_virtuemart_product_categories`.`virtuemart_category_id` IN (8)
  AND `eqc_virtuemart_products`.`published`="1" )
  GROUP BY id
  ORDER BY RAND()
  LIMIT 1
521. SELECT p.`virtuemart_product_id` as id, `eqc_virtuemart_products`.`product_parent_id` as parent_id, `eqc_virtuemart_products`.`created_on`, p.`product_name` as name, GROUP_CONCAT(`eqc_virtuemart_product_categories`.`virtuemart_category_id` SEPARATOR ',') as categories, `eqc_virtuemart_product_categories`.`virtuemart_category_id` as category_id, GROUP_CONCAT(i.`file_url` SEPARATOR ',') as thumbnail, pr.virtuemart_product_price_id, pr.product_price, pr.override, pr.product_override_price, pr.product_tax_id, pr.product_discount_id, pr.product_currency
  FROM `eqc_virtuemart_products_en_gb` as p
  LEFT JOIN `eqc_virtuemart_products`
  ON `eqc_virtuemart_products`.`virtuemart_product_id` = p.`virtuemart_product_id`
  LEFT JOIN `eqc_virtuemart_product_categories`
  ON p.`virtuemart_product_id` = `eqc_virtuemart_product_categories`.`virtuemart_product_id`
  LEFT JOIN `eqc_virtuemart_product_medias`
  ON p.`virtuemart_product_id` = `eqc_virtuemart_product_medias`.`virtuemart_product_id`
  LEFT JOIN `eqc_virtuemart_medias` as i
  ON `eqc_virtuemart_product_medias`.`virtuemart_media_id` = i.`virtuemart_media_id`
  LEFT JOIN `eqc_virtuemart_product_prices` as pr
  ON p.`virtuemart_product_id` = pr.`virtuemart_product_id`
  WHERE ( `eqc_virtuemart_product_categories`.`virtuemart_category_id` IN (9)
  AND `eqc_virtuemart_products`.`published`="1" )
  GROUP BY id
  ORDER BY RAND()
  LIMIT 1
522. SELECT p.`virtuemart_product_id` as id, `eqc_virtuemart_products`.`product_parent_id` as parent_id, `eqc_virtuemart_products`.`created_on`, p.`product_name` as name, GROUP_CONCAT(`eqc_virtuemart_product_categories`.`virtuemart_category_id` SEPARATOR ',') as categories, `eqc_virtuemart_product_categories`.`virtuemart_category_id` as category_id, GROUP_CONCAT(i.`file_url` SEPARATOR ',') as thumbnail, pr.virtuemart_product_price_id, pr.product_price, pr.override, pr.product_override_price, pr.product_tax_id, pr.product_discount_id, pr.product_currency
  FROM `eqc_virtuemart_products_en_gb` as p
  LEFT JOIN `eqc_virtuemart_products`
  ON `eqc_virtuemart_products`.`virtuemart_product_id` = p.`virtuemart_product_id`
  LEFT JOIN `eqc_virtuemart_product_categories`
  ON p.`virtuemart_product_id` = `eqc_virtuemart_product_categories`.`virtuemart_product_id`
  LEFT JOIN `eqc_virtuemart_product_medias`
  ON p.`virtuemart_product_id` = `eqc_virtuemart_product_medias`.`virtuemart_product_id`
  LEFT JOIN `eqc_virtuemart_medias` as i
  ON `eqc_virtuemart_product_medias`.`virtuemart_media_id` = i.`virtuemart_media_id`
  LEFT JOIN `eqc_virtuemart_product_prices` as pr
  ON p.`virtuemart_product_id` = pr.`virtuemart_product_id`
  WHERE ( `eqc_virtuemart_product_categories`.`virtuemart_category_id` IN (10)
  AND `eqc_virtuemart_products`.`published`="1" )
  GROUP BY id
  ORDER BY RAND()
  LIMIT 1
523. SELECT p.`virtuemart_product_id` as id, `eqc_virtuemart_products`.`product_parent_id` as parent_id, `eqc_virtuemart_products`.`created_on`, p.`product_name` as name, GROUP_CONCAT(`eqc_virtuemart_product_categories`.`virtuemart_category_id` SEPARATOR ',') as categories, `eqc_virtuemart_product_categories`.`virtuemart_category_id` as category_id, GROUP_CONCAT(i.`file_url` SEPARATOR ',') as thumbnail, pr.virtuemart_product_price_id, pr.product_price, pr.override, pr.product_override_price, pr.product_tax_id, pr.product_discount_id, pr.product_currency
  FROM `eqc_virtuemart_products_en_gb` as p
  LEFT JOIN `eqc_virtuemart_products`
  ON `eqc_virtuemart_products`.`virtuemart_product_id` = p.`virtuemart_product_id`
  LEFT JOIN `eqc_virtuemart_product_categories`
  ON p.`virtuemart_product_id` = `eqc_virtuemart_product_categories`.`virtuemart_product_id`
  LEFT JOIN `eqc_virtuemart_product_medias`
  ON p.`virtuemart_product_id` = `eqc_virtuemart_product_medias`.`virtuemart_product_id`
  LEFT JOIN `eqc_virtuemart_medias` as i
  ON `eqc_virtuemart_product_medias`.`virtuemart_media_id` = i.`virtuemart_media_id`
  LEFT JOIN `eqc_virtuemart_product_prices` as pr
  ON p.`virtuemart_product_id` = pr.`virtuemart_product_id`
  WHERE ( `eqc_virtuemart_product_categories`.`virtuemart_category_id` IN (46)
  AND `eqc_virtuemart_products`.`published`="1" )
  GROUP BY id
  ORDER BY RAND()
  LIMIT 1
524. SELECT p.`virtuemart_product_id` as id, `eqc_virtuemart_products`.`product_parent_id` as parent_id, `eqc_virtuemart_products`.`created_on`, p.`product_name` as name, GROUP_CONCAT(`eqc_virtuemart_product_categories`.`virtuemart_category_id` SEPARATOR ',') as categories, `eqc_virtuemart_product_categories`.`virtuemart_category_id` as category_id, GROUP_CONCAT(i.`file_url` SEPARATOR ',') as thumbnail, pr.virtuemart_product_price_id, pr.product_price, pr.override, pr.product_override_price, pr.product_tax_id, pr.product_discount_id, pr.product_currency
  FROM `eqc_virtuemart_products_en_gb` as p
  LEFT JOIN `eqc_virtuemart_products`
  ON `eqc_virtuemart_products`.`virtuemart_product_id` = p.`virtuemart_product_id`
  LEFT JOIN `eqc_virtuemart_product_categories`
  ON p.`virtuemart_product_id` = `eqc_virtuemart_product_categories`.`virtuemart_product_id`
  LEFT JOIN `eqc_virtuemart_product_medias`
  ON p.`virtuemart_product_id` = `eqc_virtuemart_product_medias`.`virtuemart_product_id`
  LEFT JOIN `eqc_virtuemart_medias` as i
  ON `eqc_virtuemart_product_medias`.`virtuemart_media_id` = i.`virtuemart_media_id`
  LEFT JOIN `eqc_virtuemart_product_prices` as pr
  ON p.`virtuemart_product_id` = pr.`virtuemart_product_id`
  WHERE ( `eqc_virtuemart_product_categories`.`virtuemart_category_id` IN (38)
  AND `eqc_virtuemart_products`.`published`="1" )
  GROUP BY id
  ORDER BY RAND()
  LIMIT 1
525. SELECT p.`virtuemart_product_id` as id, `eqc_virtuemart_products`.`product_parent_id` as parent_id, `eqc_virtuemart_products`.`created_on`, p.`product_name` as name, GROUP_CONCAT(`eqc_virtuemart_product_categories`.`virtuemart_category_id` SEPARATOR ',') as categories, `eqc_virtuemart_product_categories`.`virtuemart_category_id` as category_id, GROUP_CONCAT(i.`file_url` SEPARATOR ',') as thumbnail, pr.virtuemart_product_price_id, pr.product_price, pr.override, pr.product_override_price, pr.product_tax_id, pr.product_discount_id, pr.product_currency
  FROM `eqc_virtuemart_products_en_gb` as p
  LEFT JOIN `eqc_virtuemart_products`
  ON `eqc_virtuemart_products`.`virtuemart_product_id` = p.`virtuemart_product_id`
  LEFT JOIN `eqc_virtuemart_product_categories`
  ON p.`virtuemart_product_id` = `eqc_virtuemart_product_categories`.`virtuemart_product_id`
  LEFT JOIN `eqc_virtuemart_product_medias`
  ON p.`virtuemart_product_id` = `eqc_virtuemart_product_medias`.`virtuemart_product_id`
  LEFT JOIN `eqc_virtuemart_medias` as i
  ON `eqc_virtuemart_product_medias`.`virtuemart_media_id` = i.`virtuemart_media_id`
  LEFT JOIN `eqc_virtuemart_product_prices` as pr
  ON p.`virtuemart_product_id` = pr.`virtuemart_product_id`
  WHERE ( `eqc_virtuemart_product_categories`.`virtuemart_category_id` IN (18)
  AND `eqc_virtuemart_products`.`published`="1" )
  GROUP BY id
  ORDER BY RAND()
  LIMIT 1
526. SELECT p.`virtuemart_product_id` as id, `eqc_virtuemart_products`.`product_parent_id` as parent_id, `eqc_virtuemart_products`.`created_on`, p.`product_name` as name, GROUP_CONCAT(`eqc_virtuemart_product_categories`.`virtuemart_category_id` SEPARATOR ',') as categories, `eqc_virtuemart_product_categories`.`virtuemart_category_id` as category_id, GROUP_CONCAT(i.`file_url` SEPARATOR ',') as thumbnail, pr.virtuemart_product_price_id, pr.product_price, pr.override, pr.product_override_price, pr.product_tax_id, pr.product_discount_id, pr.product_currency
  FROM `eqc_virtuemart_products_en_gb` as p
  LEFT JOIN `eqc_virtuemart_products`
  ON `eqc_virtuemart_products`.`virtuemart_product_id` = p.`virtuemart_product_id`
  LEFT JOIN `eqc_virtuemart_product_categories`
  ON p.`virtuemart_product_id` = `eqc_virtuemart_product_categories`.`virtuemart_product_id`
  LEFT JOIN `eqc_virtuemart_product_medias`
  ON p.`virtuemart_product_id` = `eqc_virtuemart_product_medias`.`virtuemart_product_id`
  LEFT JOIN `eqc_virtuemart_medias` as i
  ON `eqc_virtuemart_product_medias`.`virtuemart_media_id` = i.`virtuemart_media_id`
  LEFT JOIN `eqc_virtuemart_product_prices` as pr
  ON p.`virtuemart_product_id` = pr.`virtuemart_product_id`
  WHERE ( `eqc_virtuemart_product_categories`.`virtuemart_category_id` IN (11)
  AND `eqc_virtuemart_products`.`published`="1" )
  GROUP BY id
  ORDER BY RAND()
  LIMIT 1
527. SELECT p.`virtuemart_product_id` as id, `eqc_virtuemart_products`.`product_parent_id` as parent_id, `eqc_virtuemart_products`.`created_on`, p.`product_name` as name, GROUP_CONCAT(`eqc_virtuemart_product_categories`.`virtuemart_category_id` SEPARATOR ',') as categories, `eqc_virtuemart_product_categories`.`virtuemart_category_id` as category_id, GROUP_CONCAT(i.`file_url` SEPARATOR ',') as thumbnail, pr.virtuemart_product_price_id, pr.product_price, pr.override, pr.product_override_price, pr.product_tax_id, pr.product_discount_id, pr.product_currency
  FROM `eqc_virtuemart_products_en_gb` as p
  LEFT JOIN `eqc_virtuemart_products`
  ON `eqc_virtuemart_products`.`virtuemart_product_id` = p.`virtuemart_product_id`
  LEFT JOIN `eqc_virtuemart_product_categories`
  ON p.`virtuemart_product_id` = `eqc_virtuemart_product_categories`.`virtuemart_product_id`
  LEFT JOIN `eqc_virtuemart_product_medias`
  ON p.`virtuemart_product_id` = `eqc_virtuemart_product_medias`.`virtuemart_product_id`
  LEFT JOIN `eqc_virtuemart_medias` as i
  ON `eqc_virtuemart_product_medias`.`virtuemart_media_id` = i.`virtuemart_media_id`
  LEFT JOIN `eqc_virtuemart_product_prices` as pr
  ON p.`virtuemart_product_id` = pr.`virtuemart_product_id`
  WHERE ( `eqc_virtuemart_product_categories`.`virtuemart_category_id` IN (45)
  AND `eqc_virtuemart_products`.`published`="1" )
  GROUP BY id
  ORDER BY RAND()
  LIMIT 1
528. SELECT p.`virtuemart_product_id` as id, `eqc_virtuemart_products`.`product_parent_id` as parent_id, `eqc_virtuemart_products`.`created_on`, p.`product_name` as name, GROUP_CONCAT(`eqc_virtuemart_product_categories`.`virtuemart_category_id` SEPARATOR ',') as categories, `eqc_virtuemart_product_categories`.`virtuemart_category_id` as category_id, GROUP_CONCAT(i.`file_url` SEPARATOR ',') as thumbnail, pr.virtuemart_product_price_id, pr.product_price, pr.override, pr.product_override_price, pr.product_tax_id, pr.product_discount_id, pr.product_currency
  FROM `eqc_virtuemart_products_en_gb` as p
  LEFT JOIN `eqc_virtuemart_products`
  ON `eqc_virtuemart_products`.`virtuemart_product_id` = p.`virtuemart_product_id`
  LEFT JOIN `eqc_virtuemart_product_categories`
  ON p.`virtuemart_product_id` = `eqc_virtuemart_product_categories`.`virtuemart_product_id`
  LEFT JOIN `eqc_virtuemart_product_medias`
  ON p.`virtuemart_product_id` = `eqc_virtuemart_product_medias`.`virtuemart_product_id`
  LEFT JOIN `eqc_virtuemart_medias` as i
  ON `eqc_virtuemart_product_medias`.`virtuemart_media_id` = i.`virtuemart_media_id`
  LEFT JOIN `eqc_virtuemart_product_prices` as pr
  ON p.`virtuemart_product_id` = pr.`virtuemart_product_id`
  WHERE ( `eqc_virtuemart_product_categories`.`virtuemart_category_id` IN (37)
  AND `eqc_virtuemart_products`.`published`="1" )
  GROUP BY id
  ORDER BY RAND()
  LIMIT 1
529. SELECT p.`virtuemart_product_id` as id, `eqc_virtuemart_products`.`product_parent_id` as parent_id, `eqc_virtuemart_products`.`created_on`, p.`product_name` as name, GROUP_CONCAT(`eqc_virtuemart_product_categories`.`virtuemart_category_id` SEPARATOR ',') as categories, `eqc_virtuemart_product_categories`.`virtuemart_category_id` as category_id, GROUP_CONCAT(i.`file_url` SEPARATOR ',') as thumbnail, pr.virtuemart_product_price_id, pr.product_price, pr.override, pr.product_override_price, pr.product_tax_id, pr.product_discount_id, pr.product_currency
  FROM `eqc_virtuemart_products_en_gb` as p
  LEFT JOIN `eqc_virtuemart_products`
  ON `eqc_virtuemart_products`.`virtuemart_product_id` = p.`virtuemart_product_id`
  LEFT JOIN `eqc_virtuemart_product_categories`
  ON p.`virtuemart_product_id` = `eqc_virtuemart_product_categories`.`virtuemart_product_id`
  LEFT JOIN `eqc_virtuemart_product_medias`
  ON p.`virtuemart_product_id` = `eqc_virtuemart_product_medias`.`virtuemart_product_id`
  LEFT JOIN `eqc_virtuemart_medias` as i
  ON `eqc_virtuemart_product_medias`.`virtuemart_media_id` = i.`virtuemart_media_id`
  LEFT JOIN `eqc_virtuemart_product_prices` as pr
  ON p.`virtuemart_product_id` = pr.`virtuemart_product_id`
  WHERE ( `eqc_virtuemart_product_categories`.`virtuemart_category_id` IN (58)
  AND `eqc_virtuemart_products`.`published`="1" )
  GROUP BY id
  ORDER BY RAND()
  LIMIT 1
530. SELECT p.`virtuemart_product_id` as id, `eqc_virtuemart_products`.`product_parent_id` as parent_id, `eqc_virtuemart_products`.`created_on`, p.`product_name` as name, GROUP_CONCAT(`eqc_virtuemart_product_categories`.`virtuemart_category_id` SEPARATOR ',') as categories, `eqc_virtuemart_product_categories`.`virtuemart_category_id` as category_id, GROUP_CONCAT(i.`file_url` SEPARATOR ',') as thumbnail, pr.virtuemart_product_price_id, pr.product_price, pr.override, pr.product_override_price, pr.product_tax_id, pr.product_discount_id, pr.product_currency
  FROM `eqc_virtuemart_products_en_gb` as p
  LEFT JOIN `eqc_virtuemart_products`
  ON `eqc_virtuemart_products`.`virtuemart_product_id` = p.`virtuemart_product_id`
  LEFT JOIN `eqc_virtuemart_product_categories`
  ON p.`virtuemart_product_id` = `eqc_virtuemart_product_categories`.`virtuemart_product_id`
  LEFT JOIN `eqc_virtuemart_product_medias`
  ON p.`virtuemart_product_id` = `eqc_virtuemart_product_medias`.`virtuemart_product_id`
  LEFT JOIN `eqc_virtuemart_medias` as i
  ON `eqc_virtuemart_product_medias`.`virtuemart_media_id` = i.`virtuemart_media_id`
  LEFT JOIN `eqc_virtuemart_product_prices` as pr
  ON p.`virtuemart_product_id` = pr.`virtuemart_product_id`
  WHERE ( `eqc_virtuemart_product_categories`.`virtuemart_category_id` IN (44)
  AND `eqc_virtuemart_products`.`published`="1" )
  GROUP BY id
  ORDER BY RAND()
  LIMIT 1
531. SELECT p.`virtuemart_product_id` as id, `eqc_virtuemart_products`.`product_parent_id` as parent_id, `eqc_virtuemart_products`.`created_on`, p.`product_name` as name, GROUP_CONCAT(`eqc_virtuemart_product_categories`.`virtuemart_category_id` SEPARATOR ',') as categories, `eqc_virtuemart_product_categories`.`virtuemart_category_id` as category_id, GROUP_CONCAT(i.`file_url` SEPARATOR ',') as thumbnail, pr.virtuemart_product_price_id, pr.product_price, pr.override, pr.product_override_price, pr.product_tax_id, pr.product_discount_id, pr.product_currency
  FROM `eqc_virtuemart_products_en_gb` as p
  LEFT JOIN `eqc_virtuemart_products`
  ON `eqc_virtuemart_products`.`virtuemart_product_id` = p.`virtuemart_product_id`
  LEFT JOIN `eqc_virtuemart_product_categories`
  ON p.`virtuemart_product_id` = `eqc_virtuemart_product_categories`.`virtuemart_product_id`
  LEFT JOIN `eqc_virtuemart_product_medias`
  ON p.`virtuemart_product_id` = `eqc_virtuemart_product_medias`.`virtuemart_product_id`
  LEFT JOIN `eqc_virtuemart_medias` as i
  ON `eqc_virtuemart_product_medias`.`virtuemart_media_id` = i.`virtuemart_media_id`
  LEFT JOIN `eqc_virtuemart_product_prices` as pr
  ON p.`virtuemart_product_id` = pr.`virtuemart_product_id`
  WHERE ( `eqc_virtuemart_product_categories`.`virtuemart_category_id` IN (39)
  AND `eqc_virtuemart_products`.`published`="1" )
  GROUP BY id
  ORDER BY RAND()
  LIMIT 1
532. SELECT p.`virtuemart_product_id` as id, `eqc_virtuemart_products`.`product_parent_id` as parent_id, `eqc_virtuemart_products`.`created_on`, p.`product_name` as name, GROUP_CONCAT(`eqc_virtuemart_product_categories`.`virtuemart_category_id` SEPARATOR ',') as categories, `eqc_virtuemart_product_categories`.`virtuemart_category_id` as category_id, GROUP_CONCAT(i.`file_url` SEPARATOR ',') as thumbnail, pr.virtuemart_product_price_id, pr.product_price, pr.override, pr.product_override_price, pr.product_tax_id, pr.product_discount_id, pr.product_currency
  FROM `eqc_virtuemart_products_en_gb` as p
  LEFT JOIN `eqc_virtuemart_products`
  ON `eqc_virtuemart_products`.`virtuemart_product_id` = p.`virtuemart_product_id`
  LEFT JOIN `eqc_virtuemart_product_categories`
  ON p.`virtuemart_product_id` = `eqc_virtuemart_product_categories`.`virtuemart_product_id`
  LEFT JOIN `eqc_virtuemart_product_medias`
  ON p.`virtuemart_product_id` = `eqc_virtuemart_product_medias`.`virtuemart_product_id`
  LEFT JOIN `eqc_virtuemart_medias` as i
  ON `eqc_virtuemart_product_medias`.`virtuemart_media_id` = i.`virtuemart_media_id`
  LEFT JOIN `eqc_virtuemart_product_prices` as pr
  ON p.`virtuemart_product_id` = pr.`virtuemart_product_id`
  WHERE ( `eqc_virtuemart_product_categories`.`virtuemart_category_id` IN (12)
  AND `eqc_virtuemart_products`.`published`="1" )
  GROUP BY id
  ORDER BY RAND()
  LIMIT 1
533. SELECT p.`virtuemart_product_id` as id, `eqc_virtuemart_products`.`product_parent_id` as parent_id, `eqc_virtuemart_products`.`created_on`, p.`product_name` as name, GROUP_CONCAT(`eqc_virtuemart_product_categories`.`virtuemart_category_id` SEPARATOR ',') as categories, `eqc_virtuemart_product_categories`.`virtuemart_category_id` as category_id, GROUP_CONCAT(i.`file_url` SEPARATOR ',') as thumbnail, pr.virtuemart_product_price_id, pr.product_price, pr.override, pr.product_override_price, pr.product_tax_id, pr.product_discount_id, pr.product_currency
  FROM `eqc_virtuemart_products_en_gb` as p
  LEFT JOIN `eqc_virtuemart_products`
  ON `eqc_virtuemart_products`.`virtuemart_product_id` = p.`virtuemart_product_id`
  LEFT JOIN `eqc_virtuemart_product_categories`
  ON p.`virtuemart_product_id` = `eqc_virtuemart_product_categories`.`virtuemart_product_id`
  LEFT JOIN `eqc_virtuemart_product_medias`
  ON p.`virtuemart_product_id` = `eqc_virtuemart_product_medias`.`virtuemart_product_id`
  LEFT JOIN `eqc_virtuemart_medias` as i
  ON `eqc_virtuemart_product_medias`.`virtuemart_media_id` = i.`virtuemart_media_id`
  LEFT JOIN `eqc_virtuemart_product_prices` as pr
  ON p.`virtuemart_product_id` = pr.`virtuemart_product_id`
  WHERE ( `eqc_virtuemart_product_categories`.`virtuemart_category_id` IN (13)
  AND `eqc_virtuemart_products`.`published`="1" )
  GROUP BY id
  ORDER BY RAND()
  LIMIT 1
534. SELECT p.`virtuemart_product_id` as id, `eqc_virtuemart_products`.`product_parent_id` as parent_id, `eqc_virtuemart_products`.`created_on`, p.`product_name` as name, GROUP_CONCAT(`eqc_virtuemart_product_categories`.`virtuemart_category_id` SEPARATOR ',') as categories, `eqc_virtuemart_product_categories`.`virtuemart_category_id` as category_id, GROUP_CONCAT(i.`file_url` SEPARATOR ',') as thumbnail, pr.virtuemart_product_price_id, pr.product_price, pr.override, pr.product_override_price, pr.product_tax_id, pr.product_discount_id, pr.product_currency
  FROM `eqc_virtuemart_products_en_gb` as p
  LEFT JOIN `eqc_virtuemart_products`
  ON `eqc_virtuemart_products`.`virtuemart_product_id` = p.`virtuemart_product_id`
  LEFT JOIN `eqc_virtuemart_product_categories`
  ON p.`virtuemart_product_id` = `eqc_virtuemart_product_categories`.`virtuemart_product_id`
  LEFT JOIN `eqc_virtuemart_product_medias`
  ON p.`virtuemart_product_id` = `eqc_virtuemart_product_medias`.`virtuemart_product_id`
  LEFT JOIN `eqc_virtuemart_medias` as i
  ON `eqc_virtuemart_product_medias`.`virtuemart_media_id` = i.`virtuemart_media_id`
  LEFT JOIN `eqc_virtuemart_product_prices` as pr
  ON p.`virtuemart_product_id` = pr.`virtuemart_product_id`
  WHERE ( `eqc_virtuemart_product_categories`.`virtuemart_category_id` IN (14)
  AND `eqc_virtuemart_products`.`published`="1" )
  GROUP BY id
  ORDER BY RAND()
  LIMIT 1
535. SELECT p.`virtuemart_product_id` as id, `eqc_virtuemart_products`.`product_parent_id` as parent_id, `eqc_virtuemart_products`.`created_on`, p.`product_name` as name, GROUP_CONCAT(`eqc_virtuemart_product_categories`.`virtuemart_category_id` SEPARATOR ',') as categories, `eqc_virtuemart_product_categories`.`virtuemart_category_id` as category_id, GROUP_CONCAT(i.`file_url` SEPARATOR ',') as thumbnail, pr.virtuemart_product_price_id, pr.product_price, pr.override, pr.product_override_price, pr.product_tax_id, pr.product_discount_id, pr.product_currency
  FROM `eqc_virtuemart_products_en_gb` as p
  LEFT JOIN `eqc_virtuemart_products`
  ON `eqc_virtuemart_products`.`virtuemart_product_id` = p.`virtuemart_product_id`
  LEFT JOIN `eqc_virtuemart_product_categories`
  ON p.`virtuemart_product_id` = `eqc_virtuemart_product_categories`.`virtuemart_product_id`
  LEFT JOIN `eqc_virtuemart_product_medias`
  ON p.`virtuemart_product_id` = `eqc_virtuemart_product_medias`.`virtuemart_product_id`
  LEFT JOIN `eqc_virtuemart_medias` as i
  ON `eqc_virtuemart_product_medias`.`virtuemart_media_id` = i.`virtuemart_media_id`
  LEFT JOIN `eqc_virtuemart_product_prices` as pr
  ON p.`virtuemart_product_id` = pr.`virtuemart_product_id`
  WHERE ( `eqc_virtuemart_product_categories`.`virtuemart_category_id` IN (15)
  AND `eqc_virtuemart_products`.`published`="1" )
  GROUP BY id
  ORDER BY RAND()
  LIMIT 1
536. SELECT p.`virtuemart_product_id` as id, `eqc_virtuemart_products`.`product_parent_id` as parent_id, `eqc_virtuemart_products`.`created_on`, p.`product_name` as name, GROUP_CONCAT(`eqc_virtuemart_product_categories`.`virtuemart_category_id` SEPARATOR ',') as categories, `eqc_virtuemart_product_categories`.`virtuemart_category_id` as category_id, GROUP_CONCAT(i.`file_url` SEPARATOR ',') as thumbnail, pr.virtuemart_product_price_id, pr.product_price, pr.override, pr.product_override_price, pr.product_tax_id, pr.product_discount_id, pr.product_currency
  FROM `eqc_virtuemart_products_en_gb` as p
  LEFT JOIN `eqc_virtuemart_products`
  ON `eqc_virtuemart_products`.`virtuemart_product_id` = p.`virtuemart_product_id`
  LEFT JOIN `eqc_virtuemart_product_categories`
  ON p.`virtuemart_product_id` = `eqc_virtuemart_product_categories`.`virtuemart_product_id`
  LEFT JOIN `eqc_virtuemart_product_medias`
  ON p.`virtuemart_product_id` = `eqc_virtuemart_product_medias`.`virtuemart_product_id`
  LEFT JOIN `eqc_virtuemart_medias` as i
  ON `eqc_virtuemart_product_medias`.`virtuemart_media_id` = i.`virtuemart_media_id`
  LEFT JOIN `eqc_virtuemart_product_prices` as pr
  ON p.`virtuemart_product_id` = pr.`virtuemart_product_id`
  WHERE ( `eqc_virtuemart_product_categories`.`virtuemart_category_id` IN (1)
  AND `eqc_virtuemart_products`.`published`="1" )
  GROUP BY id
  ORDER BY RAND()
  LIMIT 1
537. SELECT p.`virtuemart_product_id` as id, `eqc_virtuemart_products`.`product_parent_id` as parent_id, `eqc_virtuemart_products`.`created_on`, p.`product_name` as name, GROUP_CONCAT(`eqc_virtuemart_product_categories`.`virtuemart_category_id` SEPARATOR ',') as categories, `eqc_virtuemart_product_categories`.`virtuemart_category_id` as category_id, GROUP_CONCAT(i.`file_url` SEPARATOR ',') as thumbnail, pr.virtuemart_product_price_id, pr.product_price, pr.override, pr.product_override_price, pr.product_tax_id, pr.product_discount_id, pr.product_currency
  FROM `eqc_virtuemart_products_en_gb` as p
  LEFT JOIN `eqc_virtuemart_products`
  ON `eqc_virtuemart_products`.`virtuemart_product_id` = p.`virtuemart_product_id`
  LEFT JOIN `eqc_virtuemart_product_categories`
  ON p.`virtuemart_product_id` = `eqc_virtuemart_product_categories`.`virtuemart_product_id`
  LEFT JOIN `eqc_virtuemart_product_medias`
  ON p.`virtuemart_product_id` = `eqc_virtuemart_product_medias`.`virtuemart_product_id`
  LEFT JOIN `eqc_virtuemart_medias` as i
  ON `eqc_virtuemart_product_medias`.`virtuemart_media_id` = i.`virtuemart_media_id`
  LEFT JOIN `eqc_virtuemart_product_prices` as pr
  ON p.`virtuemart_product_id` = pr.`virtuemart_product_id`
  WHERE ( `eqc_virtuemart_product_categories`.`virtuemart_category_id` IN (16)
  AND `eqc_virtuemart_products`.`published`="1" )
  GROUP BY id
  ORDER BY RAND()
  LIMIT 1
538. SELECT p.`virtuemart_product_id` as id, `eqc_virtuemart_products`.`product_parent_id` as parent_id, `eqc_virtuemart_products`.`created_on`, p.`product_name` as name, GROUP_CONCAT(`eqc_virtuemart_product_categories`.`virtuemart_category_id` SEPARATOR ',') as categories, `eqc_virtuemart_product_categories`.`virtuemart_category_id` as category_id, GROUP_CONCAT(i.`file_url` SEPARATOR ',') as thumbnail, pr.virtuemart_product_price_id, pr.product_price, pr.override, pr.product_override_price, pr.product_tax_id, pr.product_discount_id, pr.product_currency
  FROM `eqc_virtuemart_products_en_gb` as p
  LEFT JOIN `eqc_virtuemart_products`
  ON `eqc_virtuemart_products`.`virtuemart_product_id` = p.`virtuemart_product_id`
  LEFT JOIN `eqc_virtuemart_product_categories`
  ON p.`virtuemart_product_id` = `eqc_virtuemart_product_categories`.`virtuemart_product_id`
  LEFT JOIN `eqc_virtuemart_product_medias`
  ON p.`virtuemart_product_id` = `eqc_virtuemart_product_medias`.`virtuemart_product_id`
  LEFT JOIN `eqc_virtuemart_medias` as i
  ON `eqc_virtuemart_product_medias`.`virtuemart_media_id` = i.`virtuemart_media_id`
  LEFT JOIN `eqc_virtuemart_product_prices` as pr
  ON p.`virtuemart_product_id` = pr.`virtuemart_product_id`
  WHERE ( `eqc_virtuemart_product_categories`.`virtuemart_category_id` IN (4)
  AND `eqc_virtuemart_products`.`published`="1" )
  GROUP BY id
  ORDER BY RAND()
  LIMIT 1
539. SELECT p.`virtuemart_product_id` as id, `eqc_virtuemart_products`.`product_parent_id` as parent_id, `eqc_virtuemart_products`.`created_on`, p.`product_name` as name, GROUP_CONCAT(`eqc_virtuemart_product_categories`.`virtuemart_category_id` SEPARATOR ',') as categories, `eqc_virtuemart_product_categories`.`virtuemart_category_id` as category_id, GROUP_CONCAT(i.`file_url` SEPARATOR ',') as thumbnail, pr.virtuemart_product_price_id, pr.product_price, pr.override, pr.product_override_price, pr.product_tax_id, pr.product_discount_id, pr.product_currency
  FROM `eqc_virtuemart_products_en_gb` as p
  LEFT JOIN `eqc_virtuemart_products`
  ON `eqc_virtuemart_products`.`virtuemart_product_id` = p.`virtuemart_product_id`
  LEFT JOIN `eqc_virtuemart_product_categories`
  ON p.`virtuemart_product_id` = `eqc_virtuemart_product_categories`.`virtuemart_product_id`
  LEFT JOIN `eqc_virtuemart_product_medias`
  ON p.`virtuemart_product_id` = `eqc_virtuemart_product_medias`.`virtuemart_product_id`
  LEFT JOIN `eqc_virtuemart_medias` as i
  ON `eqc_virtuemart_product_medias`.`virtuemart_media_id` = i.`virtuemart_media_id`
  LEFT JOIN `eqc_virtuemart_product_prices` as pr
  ON p.`virtuemart_product_id` = pr.`virtuemart_product_id`
  WHERE ( `eqc_virtuemart_product_categories`.`virtuemart_category_id` IN (19)
  AND `eqc_virtuemart_products`.`published`="1" )
  GROUP BY id
  ORDER BY RAND()
  LIMIT 1
540. SELECT p.`virtuemart_product_id` as id, `eqc_virtuemart_products`.`product_parent_id` as parent_id, `eqc_virtuemart_products`.`created_on`, p.`product_name` as name, GROUP_CONCAT(`eqc_virtuemart_product_categories`.`virtuemart_category_id` SEPARATOR ',') as categories, `eqc_virtuemart_product_categories`.`virtuemart_category_id` as category_id, GROUP_CONCAT(i.`file_url` SEPARATOR ',') as thumbnail, pr.virtuemart_product_price_id, pr.product_price, pr.override, pr.product_override_price, pr.product_tax_id, pr.product_discount_id, pr.product_currency
  FROM `eqc_virtuemart_products_en_gb` as p
  LEFT JOIN `eqc_virtuemart_products`
  ON `eqc_virtuemart_products`.`virtuemart_product_id` = p.`virtuemart_product_id`
  LEFT JOIN `eqc_virtuemart_product_categories`
  ON p.`virtuemart_product_id` = `eqc_virtuemart_product_categories`.`virtuemart_product_id`
  LEFT JOIN `eqc_virtuemart_product_medias`
  ON p.`virtuemart_product_id` = `eqc_virtuemart_product_medias`.`virtuemart_product_id`
  LEFT JOIN `eqc_virtuemart_medias` as i
  ON `eqc_virtuemart_product_medias`.`virtuemart_media_id` = i.`virtuemart_media_id`
  LEFT JOIN `eqc_virtuemart_product_prices` as pr
  ON p.`virtuemart_product_id` = pr.`virtuemart_product_id`
  WHERE ( `eqc_virtuemart_product_categories`.`virtuemart_category_id` IN (3)
  AND `eqc_virtuemart_products`.`published`="1" )
  GROUP BY id
  ORDER BY RAND()
  LIMIT 1
541. SELECT p.`virtuemart_product_id` as id, `eqc_virtuemart_products`.`product_parent_id` as parent_id, `eqc_virtuemart_products`.`created_on`, p.`product_name` as name, GROUP_CONCAT(`eqc_virtuemart_product_categories`.`virtuemart_category_id` SEPARATOR ',') as categories, `eqc_virtuemart_product_categories`.`virtuemart_category_id` as category_id, GROUP_CONCAT(i.`file_url` SEPARATOR ',') as thumbnail, pr.virtuemart_product_price_id, pr.product_price, pr.override, pr.product_override_price, pr.product_tax_id, pr.product_discount_id, pr.product_currency
  FROM `eqc_virtuemart_products_en_gb` as p
  LEFT JOIN `eqc_virtuemart_products`
  ON `eqc_virtuemart_products`.`virtuemart_product_id` = p.`virtuemart_product_id`
  LEFT JOIN `eqc_virtuemart_product_categories`
  ON p.`virtuemart_product_id` = `eqc_virtuemart_product_categories`.`virtuemart_product_id`
  LEFT JOIN `eqc_virtuemart_product_medias`
  ON p.`virtuemart_product_id` = `eqc_virtuemart_product_medias`.`virtuemart_product_id`
  LEFT JOIN `eqc_virtuemart_medias` as i
  ON `eqc_virtuemart_product_medias`.`virtuemart_media_id` = i.`virtuemart_media_id`
  LEFT JOIN `eqc_virtuemart_product_prices` as pr
  ON p.`virtuemart_product_id` = pr.`virtuemart_product_id`
  WHERE ( `eqc_virtuemart_product_categories`.`virtuemart_category_id` IN (34)
  AND `eqc_virtuemart_products`.`published`="1" )
  GROUP BY id
  ORDER BY RAND()
  LIMIT 1
542. SELECT p.`virtuemart_product_id` as id, `eqc_virtuemart_products`.`product_parent_id` as parent_id, `eqc_virtuemart_products`.`created_on`, p.`product_name` as name, GROUP_CONCAT(`eqc_virtuemart_product_categories`.`virtuemart_category_id` SEPARATOR ',') as categories, `eqc_virtuemart_product_categories`.`virtuemart_category_id` as category_id, GROUP_CONCAT(i.`file_url` SEPARATOR ',') as thumbnail, pr.virtuemart_product_price_id, pr.product_price, pr.override, pr.product_override_price, pr.product_tax_id, pr.product_discount_id, pr.product_currency
  FROM `eqc_virtuemart_products_en_gb` as p
  LEFT JOIN `eqc_virtuemart_products`
  ON `eqc_virtuemart_products`.`virtuemart_product_id` = p.`virtuemart_product_id`
  LEFT JOIN `eqc_virtuemart_product_categories`
  ON p.`virtuemart_product_id` = `eqc_virtuemart_product_categories`.`virtuemart_product_id`
  LEFT JOIN `eqc_virtuemart_product_medias`
  ON p.`virtuemart_product_id` = `eqc_virtuemart_product_medias`.`virtuemart_product_id`
  LEFT JOIN `eqc_virtuemart_medias` as i
  ON `eqc_virtuemart_product_medias`.`virtuemart_media_id` = i.`virtuemart_media_id`
  LEFT JOIN `eqc_virtuemart_product_prices` as pr
  ON p.`virtuemart_product_id` = pr.`virtuemart_product_id`
  WHERE ( `eqc_virtuemart_product_categories`.`virtuemart_category_id` IN (22)
  AND `eqc_virtuemart_products`.`published`="1" )
  GROUP BY id
  ORDER BY RAND()
  LIMIT 1
543. SELECT p.`virtuemart_product_id` as id, `eqc_virtuemart_products`.`product_parent_id` as parent_id, `eqc_virtuemart_products`.`created_on`, p.`product_name` as name, GROUP_CONCAT(`eqc_virtuemart_product_categories`.`virtuemart_category_id` SEPARATOR ',') as categories, `eqc_virtuemart_product_categories`.`virtuemart_category_id` as category_id, GROUP_CONCAT(i.`file_url` SEPARATOR ',') as thumbnail, pr.virtuemart_product_price_id, pr.product_price, pr.override, pr.product_override_price, pr.product_tax_id, pr.product_discount_id, pr.product_currency
  FROM `eqc_virtuemart_products_en_gb` as p
  LEFT JOIN `eqc_virtuemart_products`
  ON `eqc_virtuemart_products`.`virtuemart_product_id` = p.`virtuemart_product_id`
  LEFT JOIN `eqc_virtuemart_product_categories`
  ON p.`virtuemart_product_id` = `eqc_virtuemart_product_categories`.`virtuemart_product_id`
  LEFT JOIN `eqc_virtuemart_product_medias`
  ON p.`virtuemart_product_id` = `eqc_virtuemart_product_medias`.`virtuemart_product_id`
  LEFT JOIN `eqc_virtuemart_medias` as i
  ON `eqc_virtuemart_product_medias`.`virtuemart_media_id` = i.`virtuemart_media_id`
  LEFT JOIN `eqc_virtuemart_product_prices` as pr
  ON p.`virtuemart_product_id` = pr.`virtuemart_product_id`
  WHERE ( `eqc_virtuemart_product_categories`.`virtuemart_category_id` IN (24)
  AND `eqc_virtuemart_products`.`published`="1" )
  GROUP BY id
  ORDER BY RAND()
  LIMIT 1
544. SELECT p.`virtuemart_product_id` as id, `eqc_virtuemart_products`.`product_parent_id` as parent_id, `eqc_virtuemart_products`.`created_on`, p.`product_name` as name, GROUP_CONCAT(`eqc_virtuemart_product_categories`.`virtuemart_category_id` SEPARATOR ',') as categories, `eqc_virtuemart_product_categories`.`virtuemart_category_id` as category_id, GROUP_CONCAT(i.`file_url` SEPARATOR ',') as thumbnail, pr.virtuemart_product_price_id, pr.product_price, pr.override, pr.product_override_price, pr.product_tax_id, pr.product_discount_id, pr.product_currency
  FROM `eqc_virtuemart_products_en_gb` as p
  LEFT JOIN `eqc_virtuemart_products`
  ON `eqc_virtuemart_products`.`virtuemart_product_id` = p.`virtuemart_product_id`
  LEFT JOIN `eqc_virtuemart_product_categories`
  ON p.`virtuemart_product_id` = `eqc_virtuemart_product_categories`.`virtuemart_product_id`
  LEFT JOIN `eqc_virtuemart_product_medias`
  ON p.`virtuemart_product_id` = `eqc_virtuemart_product_medias`.`virtuemart_product_id`
  LEFT JOIN `eqc_virtuemart_medias` as i
  ON `eqc_virtuemart_product_medias`.`virtuemart_media_id` = i.`virtuemart_media_id`
  LEFT JOIN `eqc_virtuemart_product_prices` as pr
  ON p.`virtuemart_product_id` = pr.`virtuemart_product_id`
  WHERE ( `eqc_virtuemart_product_categories`.`virtuemart_category_id` IN (25)
  AND `eqc_virtuemart_products`.`published`="1" )
  GROUP BY id
  ORDER BY RAND()
  LIMIT 1
545. SELECT p.`virtuemart_product_id` as id, `eqc_virtuemart_products`.`product_parent_id` as parent_id, `eqc_virtuemart_products`.`created_on`, p.`product_name` as name, GROUP_CONCAT(`eqc_virtuemart_product_categories`.`virtuemart_category_id` SEPARATOR ',') as categories, `eqc_virtuemart_product_categories`.`virtuemart_category_id` as category_id, GROUP_CONCAT(i.`file_url` SEPARATOR ',') as thumbnail, pr.virtuemart_product_price_id, pr.product_price, pr.override, pr.product_override_price, pr.product_tax_id, pr.product_discount_id, pr.product_currency
  FROM `eqc_virtuemart_products_en_gb` as p
  LEFT JOIN `eqc_virtuemart_products`
  ON `eqc_virtuemart_products`.`virtuemart_product_id` = p.`virtuemart_product_id`
  LEFT JOIN `eqc_virtuemart_product_categories`
  ON p.`virtuemart_product_id` = `eqc_virtuemart_product_categories`.`virtuemart_product_id`
  LEFT JOIN `eqc_virtuemart_product_medias`
  ON p.`virtuemart_product_id` = `eqc_virtuemart_product_medias`.`virtuemart_product_id`
  LEFT JOIN `eqc_virtuemart_medias` as i
  ON `eqc_virtuemart_product_medias`.`virtuemart_media_id` = i.`virtuemart_media_id`
  LEFT JOIN `eqc_virtuemart_product_prices` as pr
  ON p.`virtuemart_product_id` = pr.`virtuemart_product_id`
  WHERE ( `eqc_virtuemart_product_categories`.`virtuemart_category_id` IN (2)
  AND `eqc_virtuemart_products`.`published`="1" )
  GROUP BY id
  ORDER BY RAND()
  LIMIT 1
546. SELECT p.`virtuemart_product_id` as id, `eqc_virtuemart_products`.`product_parent_id` as parent_id, `eqc_virtuemart_products`.`created_on`, p.`product_name` as name, GROUP_CONCAT(`eqc_virtuemart_product_categories`.`virtuemart_category_id` SEPARATOR ',') as categories, `eqc_virtuemart_product_categories`.`virtuemart_category_id` as category_id, GROUP_CONCAT(i.`file_url` SEPARATOR ',') as thumbnail, pr.virtuemart_product_price_id, pr.product_price, pr.override, pr.product_override_price, pr.product_tax_id, pr.product_discount_id, pr.product_currency
  FROM `eqc_virtuemart_products_en_gb` as p
  LEFT JOIN `eqc_virtuemart_products`
  ON `eqc_virtuemart_products`.`virtuemart_product_id` = p.`virtuemart_product_id`
  LEFT JOIN `eqc_virtuemart_product_categories`
  ON p.`virtuemart_product_id` = `eqc_virtuemart_product_categories`.`virtuemart_product_id`
  LEFT JOIN `eqc_virtuemart_product_medias`
  ON p.`virtuemart_product_id` = `eqc_virtuemart_product_medias`.`virtuemart_product_id`
  LEFT JOIN `eqc_virtuemart_medias` as i
  ON `eqc_virtuemart_product_medias`.`virtuemart_media_id` = i.`virtuemart_media_id`
  LEFT JOIN `eqc_virtuemart_product_prices` as pr
  ON p.`virtuemart_product_id` = pr.`virtuemart_product_id`
  WHERE ( `eqc_virtuemart_product_categories`.`virtuemart_category_id` IN (26)
  AND `eqc_virtuemart_products`.`published`="1" )
  GROUP BY id
  ORDER BY RAND()
  LIMIT 1
547. SELECT p.`virtuemart_product_id` as id, `eqc_virtuemart_products`.`product_parent_id` as parent_id, `eqc_virtuemart_products`.`created_on`, p.`product_name` as name, GROUP_CONCAT(`eqc_virtuemart_product_categories`.`virtuemart_category_id` SEPARATOR ',') as categories, `eqc_virtuemart_product_categories`.`virtuemart_category_id` as category_id, GROUP_CONCAT(i.`file_url` SEPARATOR ',') as thumbnail, pr.virtuemart_product_price_id, pr.product_price, pr.override, pr.product_override_price, pr.product_tax_id, pr.product_discount_id, pr.product_currency
  FROM `eqc_virtuemart_products_en_gb` as p
  LEFT JOIN `eqc_virtuemart_products`
  ON `eqc_virtuemart_products`.`virtuemart_product_id` = p.`virtuemart_product_id`
  LEFT JOIN `eqc_virtuemart_product_categories`
  ON p.`virtuemart_product_id` = `eqc_virtuemart_product_categories`.`virtuemart_product_id`
  LEFT JOIN `eqc_virtuemart_product_medias`
  ON p.`virtuemart_product_id` = `eqc_virtuemart_product_medias`.`virtuemart_product_id`
  LEFT JOIN `eqc_virtuemart_medias` as i
  ON `eqc_virtuemart_product_medias`.`virtuemart_media_id` = i.`virtuemart_media_id`
  LEFT JOIN `eqc_virtuemart_product_prices` as pr
  ON p.`virtuemart_product_id` = pr.`virtuemart_product_id`
  WHERE ( `eqc_virtuemart_product_categories`.`virtuemart_category_id` IN (27)
  AND `eqc_virtuemart_products`.`published`="1" )
  GROUP BY id
  ORDER BY RAND()
  LIMIT 1
548. SELECT `slug`
  FROM `eqc_virtuemart_products_en_gb`
  WHERE `virtuemart_product_id` = 567
549. SELECT `slug`
  FROM `eqc_virtuemart_products_en_gb`
  WHERE `virtuemart_product_id` = 635
550. SELECT `slug`
  FROM `eqc_virtuemart_products_en_gb`
  WHERE `virtuemart_product_id` = 651
551. SELECT `slug`
  FROM `eqc_virtuemart_products_en_gb`
  WHERE `virtuemart_product_id` = 101
552. SELECT `slug`
  FROM `eqc_virtuemart_products_en_gb`
  WHERE `virtuemart_product_id` = 709
553. SELECT `slug`
  FROM `eqc_virtuemart_products_en_gb`
  WHERE `virtuemart_product_id` = 1663
554. SELECT `slug`
  FROM `eqc_virtuemart_products_en_gb`
  WHERE `virtuemart_product_id` = 1399
555. SELECT `slug`
  FROM `eqc_virtuemart_products_en_gb`
  WHERE `virtuemart_product_id` = 1838
556. SELECT `slug`
  FROM `eqc_virtuemart_products_en_gb`
  WHERE `virtuemart_product_id` = 811
557. SELECT `slug`
  FROM `eqc_virtuemart_products_en_gb`
  WHERE `virtuemart_product_id` = 1437
558. SELECT `slug`
  FROM `eqc_virtuemart_products_en_gb`
  WHERE `virtuemart_product_id` = 1215
559. SELECT `slug`
  FROM `eqc_virtuemart_products_en_gb`
  WHERE `virtuemart_product_id` = 1307
560. SELECT `slug`
  FROM `eqc_virtuemart_products_en_gb`
  WHERE `virtuemart_product_id` = 1652
561. SELECT `slug`
  FROM `eqc_virtuemart_products_en_gb`
  WHERE `virtuemart_product_id` = 1253
562. SELECT `slug`
  FROM `eqc_virtuemart_products_en_gb`
  WHERE `virtuemart_product_id` = 1000
563. SELECT `slug`
  FROM `eqc_virtuemart_products_en_gb`
  WHERE `virtuemart_product_id` = 285
564. SELECT `slug`
  FROM `eqc_virtuemart_products_en_gb`
  WHERE `virtuemart_product_id` = 378
565. SELECT `slug`
  FROM `eqc_virtuemart_products_en_gb`
  WHERE `virtuemart_product_id` = 225
566. SELECT `slug`
  FROM `eqc_virtuemart_products_en_gb`
  WHERE `virtuemart_product_id` = 392
567. SELECT `slug`
  FROM `eqc_virtuemart_products_en_gb`
  WHERE `virtuemart_product_id` = 1100
568. SELECT `slug`
  FROM `eqc_virtuemart_products_en_gb`
  WHERE `virtuemart_product_id` = 1135
569. SELECT `slug`
  FROM `eqc_virtuemart_products_en_gb`
  WHERE `virtuemart_product_id` = 412
570. SELECT `slug`
  FROM `eqc_virtuemart_products_en_gb`
  WHERE `virtuemart_product_id` = 1643
571. SELECT `slug`
  FROM `eqc_virtuemart_products_en_gb`
  WHERE `virtuemart_product_id` = 95
572. SELECT `slug`
  FROM `eqc_virtuemart_products_en_gb`
  WHERE `virtuemart_product_id` = 1167
573. SELECT `slug`
  FROM `eqc_virtuemart_products_en_gb`
  WHERE `virtuemart_product_id` = 1008
574. SELECT *
  FROM eqc_virtuemart_calcs
  WHERE `calc_kind`="DBTaxBill"
  AND `published`="1"
  AND (`virtuemart_vendor_id`="1" OR `shared`="1" )
  AND ( publish_up = "0000-00-00 00:00:00" OR publish_up <= "2014-04-20 10:47:15" )
  AND ( publish_down = "0000-00-00 00:00:00" OR publish_down >= "2014-04-20 10:47:15" )
575. SELECT `virtuemart_country_id`
  FROM eqc_virtuemart_calc_countries
  WHERE `virtuemart_calc_id`="1"
576. SELECT `virtuemart_state_id`
  FROM eqc_virtuemart_calc_states
  WHERE `virtuemart_calc_id`="1"
577. SELECT `virtuemart_category_id`
  FROM eqc_virtuemart_calc_categories
  WHERE `virtuemart_calc_id`="1"
578. SELECT `virtuemart_shoppergroup_id`
  FROM eqc_virtuemart_calc_shoppergroups
  WHERE `virtuemart_calc_id`="1"
579. SELECT *
  FROM eqc_virtuemart_calcs
  WHERE `calc_kind`="TaxBill"
  AND `published`="1"
  AND (`virtuemart_vendor_id`="1" OR `shared`="1" )
  AND ( publish_up = "0000-00-00 00:00:00" OR publish_up <= "2014-04-20 10:47:15" )
  AND ( publish_down = "0000-00-00 00:00:00" OR publish_down >= "2014-04-20 10:47:15" )
580. SELECT *
  FROM eqc_virtuemart_calcs
  WHERE `calc_kind`="DATaxBill"
  AND `published`="1"
  AND (`virtuemart_vendor_id`="1" OR `shared`="1" )
  AND ( publish_up = "0000-00-00 00:00:00" OR publish_up <= "2014-04-20 10:47:15" )
  AND ( publish_down = "0000-00-00 00:00:00" OR publish_down >= "2014-04-20 10:47:15" )
581. UPDATE `eqc_session`
  SET `data` = '__default|a:8:{s:15:\"session.counter\";i:1;s:19:\"session.timer.start\";i:1397990835;s:18:\"session.timer.last\";i:1397990835;s:17:\"session.timer.now\";i:1397990835;s:22:\"session.client.browser\";s:39:\"CCBot/2.0 (http://commoncrawl.org/faq/)\";s:8:\"registry\";O:9:\"JRegistry\":1:{s:7:\"\0*\0data\";O:8:\"stdClass\":0:{}}s:4:\"user\";O:5:\"JUser\":25:{s:9:\"\0*\0isRoot\";b:0;s:2:\"id\";i:0;s:4:\"name\";N;s:8:\"username\";N;s:5:\"email\";N;s:8:\"password\";N;s:14:\"password_clear\";s:0:\"\";s:8:\"usertype\";N;s:5:\"block\";N;s:9:\"sendEmail\";i:0;s:12:\"registerDate\";N;s:13:\"lastvisitDate\";N;s:10:\"activation\";N;s:6:\"params\";N;s:6:\"groups\";a:0:{}s:5:\"guest\";i:1;s:13:\"lastResetTime\";N;s:10:\"resetCount\";N;s:10:\"\0*\0_params\";O:9:\"JRegistry\":1:{s:7:\"\0*\0data\";O:8:\"stdClass\":0:{}}s:14:\"\0*\0_authGroups\";a:1:{i:0;i:1;}s:14:\"\0*\0_authLevels\";a:1:{i:0;i:1;}s:15:\"\0*\0_authActions\";N;s:12:\"\0*\0_errorMsg\";N;s:10:\"\0*\0_errors\";a:0:{}s:3:\"aid\";i:0;}s:13:\"session.token\";s:32:\"964a42dd1b0e74fdb2360cc238b9f508\";}__vm|a:1:{s:6:\"vmcart\";s:645:\"O:8:\"stdClass\":24:{s:8:\"products\";a:0:{}s:8:\"vendorId\";i:1;s:21:\"lastVisitedCategoryId\";i:0;s:28:\"virtuemart_shipmentmethod_id\";i:0;s:27:\"virtuemart_paymentmethod_id\";i:0;s:25:\"automaticSelectedShipment\";b:0;s:24:\"automaticSelectedPayment\";b:0;s:12:\"order_number\";N;s:2:\"BT\";i:0;s:2:\"ST\";i:0;s:11:\"tosAccepted\";N;s:16:\"customer_comment\";s:0:\"\";s:10:\"couponCode\";s:0:\"\";s:20:\"_triesValidateCoupon\";a:0:{}s:14:\"order_language\";s:0:\"\";s:8:\"cartData\";N;s:5:\"lists\";N;s:14:\"pricesCurrency\";N;s:15:\"paymentCurrency\";N;s:11:\"_inCheckOut\";b:0;s:14:\"_dataValidated\";b:0;s:12:\"_confirmDone\";b:0;s:10:\"STsameAsBT\";b:1;s:15:\"customer_number\";s:7:\"nonreg_\";}\";}' , `time` = '1397990836'
  WHERE `session_id` = '9613f9d5029174b11cac57288c6a81f3'