Plaisir

Product Details

  • Type: Sidewall
  • Collection: Plaisir
  • Features: paste the wall
  • Roll Dimensions (D/Roll): 33ft x 21in (10m x 53cm)

Wallcoverings are packaged and sold in double rolls only

  • paste the wall
  • dry strippable
  • extra washable
  • good lightfastness

Profile Information

Application afterLoad: 0.000 seconds, 0.30 MB
Application afterInitialise: 0.005 seconds, 0.97 MB
Application afterRoute: 0.009 seconds, 2.53 MB
Application afterDispatch: 3.963 seconds, 3.64 MB
Application afterRender: 3.973 seconds, 3.92 MB

Memory Usage

4139760

473 queries logged

  1. SELECT *
      FROM jos_session
      WHERE session_id = 's06qsnk1re33m9me6m0k5mkea2'
  2. DELETE
      FROM jos_session
      WHERE ( time < '1756454671' )
  3. SELECT *
      FROM jos_session
      WHERE session_id = 's06qsnk1re33m9me6m0k5mkea2'
  4. UPDATE `jos_session`
      SET `time`='1756461871',`userid`='0',`usertype`='',`username`='',`gid`='0',`guest`='1',`client_id`='0',`data`='__default|a:7:{s:15:\"session.counter\";i:4;s:19:\"session.timer.start\";i:1756461847;s:18:\"session.timer.last\";i:1756461862;s:17:\"session.timer.now\";i:1756461868;s:8:\"registry\";O:9:\"JRegistry\":3:{s:17:\"_defaultNameSpace\";s:7:\"session\";s:9:\"_registry\";a:1:{s:7:\"session\";a:1:{s:4:\"data\";O:8:\"stdClass\":0:{}}}s:7:\"_errors\";a:0:{}}s:4:\"user\";O:5:\"JUser\":19:{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:3:\"gid\";i:0;s:12:\"registerDate\";N;s:13:\"lastvisitDate\";N;s:10:\"activation\";N;s:6:\"params\";N;s:3:\"aid\";i:0;s:5:\"guest\";i:1;s:7:\"_params\";O:10:\"JParameter\":7:{s:4:\"_raw\";s:0:\"\";s:4:\"_xml\";N;s:9:\"_elements\";a:0:{}s:12:\"_elementPath\";a:1:{i:0;s:65:\"/home/ontwall/public_html/libraries/joomla/html/parameter/element\";}s:17:\"_defaultNameSpace\";s:8:\"_default\";s:9:\"_registry\";a:1:{s:8:\"_default\";a:1:{s:4:\"data\";O:8:\"stdClass\":0:{}}}s:7:\"_errors\";a:0:{}}s:9:\"_errorMsg\";N;s:7:\"_errors\";a:0:{}}s:7:\"visited\";a:1:{i:0;s:3:\"263\";}}'
      WHERE session_id='s06qsnk1re33m9me6m0k5mkea2'
  5. SELECT *
      FROM jos_components
      WHERE parent = 0
  6. SELECT folder AS type, element AS name, params
      FROM jos_plugins
      WHERE published >= 1
      AND access <= 0
      ORDER BY ordering
  7. SELECT m.*, c.`option` AS component
      FROM jos_menu AS m
      LEFT JOIN jos_components AS c
      ON m.componentid = c.id
      WHERE m.published = 1
      ORDER BY m.sublevel, m.parent, m.ordering
  8. SELECT *
      FROM jos_redshop_configuration
  9. SELECT *
      FROM jos_redshop_catalog_request
      WHERE block = 0
  10. SELECT *
      FROM jos_redshop_sample_request
      WHERE block = 0
  11. SELECT count(id)
      FROM jos_redshop_cron
      WHERE date = '2025-08-29'
  12. SELECT *
      FROM jos_redshop_siteviewer
      WHERE session_id = 's06qsnk1re33m9me6m0k5mkea2'
  13. SELECT *
      FROM jos_redshop_pageviewer
      WHERE session_id = 's06qsnk1re33m9me6m0k5mkea2'
      AND section='category'
      AND section_id=''
  14. SELECT sg.*
      FROM `jos_redshop_shopper_group` AS sg 
      WHERE  sg.`shopper_group_id` = 0
  15. SELECT template
      FROM jos_templates_menu
      WHERE client_id = 0
      AND (menuid = 0 OR menuid = 188)
      ORDER BY menuid DESC
      LIMIT 0, 1
  16. SELECT *
      FROM jos_redshop_product AS p, jos_redshop_category AS c
      LEFT JOIN jos_redshop_product_category_xref AS pc
      ON pc.category_id=c.category_id
      WHERE p.product_id = pc.product_id
      AND pc.category_id=137
      AND p.published = 1
      AND p.expired = 0
      AND p.product_parent_id = 0
      ORDER BY c.ordering ASC
  17. SELECT *
      FROM jos_redshop_category
      WHERE category_id = 137
  18. SELECT *
      FROM jos_redshop_category AS c, jos_redshop_template AS t
      WHERE t.template_id = c.category_template
      AND t.template_section='category'
      AND c.category_id=137
      AND t.published = 1
      ORDER BY c.ordering ASC
      LIMIT 0,1
  19. SELECT *
      FROM jos_redshop_product AS p, jos_redshop_category AS c
      LEFT JOIN jos_redshop_product_category_xref AS pc
      ON pc.category_id=c.category_id
      WHERE p.product_id = pc.product_id
      AND pc.category_id=137
      AND p.published = 1
      AND p.expired = 0
      AND p.product_parent_id = 0
      ORDER BY p.product_name ASC
      LIMIT 0, 200
  20. SELECT *
      FROM jos_redshop_category AS c, jos_redshop_template AS t
      WHERE t.template_id = c.category_template
      AND t.template_section='category'
      AND c.category_id=137
      AND t.published = 1
      ORDER BY c.ordering ASC
      LIMIT 0,1
  21. SELECT *
      FROM jos_redshop_category
      WHERE category_id = 137
  22. SELECT *
      FROM jos_menu
      WHERE link LIKE '%com_redshop%'
      AND published=1
      AND id = '188'
  23. SELECT *
      FROM jos_menu
      WHERE link LIKE '%com_redshop%'
      AND published=1 
      AND link LIKE '%view=category%' 
      AND params NOT LIKE '%categoryid%'
  24. SELECT *
      FROM jos_menu
      WHERE link LIKE '%com_redshop%'
      AND published=1 
      AND link LIKE '%view=category%' 
      AND params  LIKE '%categoryid=137
    %'
  25. SELECT category_parent_id
      FROM jos_redshop_category_xref
      WHERE category_child_id=137
  26. SELECT *
      FROM jos_menu
      WHERE id = '188'
  27. SELECT sef_url,product_name,cat_in_sefurl
      FROM jos_redshop_product
      WHERE product_id = '6188'
  28. SELECT c.category_id
      FROM jos_redshop_category c,jos_redshop_product_category_xref pc
      WHERE pc.product_id = '6188'
      AND pc.category_id = c.category_id
  29. SELECT c.category_id,c.category_name ,cx.category_child_id,cx.category_parent_id
      FROM jos_redshop_category_xref AS cx, jos_redshop_category AS c
      WHERE cx.category_child_id='137'
      AND c.category_id = cx.category_parent_id
  30. SELECT category_name
      FROM jos_redshop_category
      WHERE category_id = '137'
  31. SELECT
      FROM jos_redshop_product AS
      WHERE  p.product_id = 6188
  32. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 6188
      AND ps.stockroom_id = s.stockroom_id
  33. SELECT
      FROM jos_modules
      WHERE `module` LIKE 'mod_redmagicmagnifyplus'
      AND published  = 1
  34. SELECT *
      FROM jos_redshop_media 
      WHERE media_section = "product"
      AND section_id ="6188"
      AND media_type="images" 
      AND media_name = "1438448853_420005_641.jpg"
  35. SELECT *
      FROM jos_menu
      WHERE id = '188'
  36. SELECT sef_url,product_name,cat_in_sefurl
      FROM jos_redshop_product
      WHERE product_id = '6189'
  37. SELECT c.category_id
      FROM jos_redshop_category c,jos_redshop_product_category_xref pc
      WHERE pc.product_id = '6189'
      AND pc.category_id = c.category_id
  38. SELECT c.category_id,c.category_name ,cx.category_child_id,cx.category_parent_id
      FROM jos_redshop_category_xref AS cx, jos_redshop_category AS c
      WHERE cx.category_child_id='137'
      AND c.category_id = cx.category_parent_id
  39. SELECT category_name
      FROM jos_redshop_category
      WHERE category_id = '137'
  40. SELECT
      FROM jos_redshop_product AS
      WHERE  p.product_id = 6189
  41. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 6189
      AND ps.stockroom_id = s.stockroom_id
  42. SELECT
      FROM jos_modules
      WHERE `module` LIKE 'mod_redmagicmagnifyplus'
      AND published  = 1
  43. SELECT *
      FROM jos_redshop_media 
      WHERE media_section = "product"
      AND section_id ="6189"
      AND media_type="images" 
      AND media_name = "1438448909_420029_641.jpg"
  44. SELECT *
      FROM jos_menu
      WHERE id = '188'
  45. SELECT sef_url,product_name,cat_in_sefurl
      FROM jos_redshop_product
      WHERE product_id = '6190'
  46. SELECT c.category_id
      FROM jos_redshop_category c,jos_redshop_product_category_xref pc
      WHERE pc.product_id = '6190'
      AND pc.category_id = c.category_id
  47. SELECT c.category_id,c.category_name ,cx.category_child_id,cx.category_parent_id
      FROM jos_redshop_category_xref AS cx, jos_redshop_category AS c
      WHERE cx.category_child_id='137'
      AND c.category_id = cx.category_parent_id
  48. SELECT category_name
      FROM jos_redshop_category
      WHERE category_id = '137'
  49. SELECT
      FROM jos_redshop_product AS
      WHERE  p.product_id = 6190
  50. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 6190
      AND ps.stockroom_id = s.stockroom_id
  51. SELECT
      FROM jos_modules
      WHERE `module` LIKE 'mod_redmagicmagnifyplus'
      AND published  = 1
  52. SELECT *
      FROM jos_redshop_media 
      WHERE media_section = "product"
      AND section_id ="6190"
      AND media_type="images" 
      AND media_name = "1438448936_454109_641.jpg"
  53. SELECT *
      FROM jos_menu
      WHERE id = '188'
  54. SELECT sef_url,product_name,cat_in_sefurl
      FROM jos_redshop_product
      WHERE product_id = '6191'
  55. SELECT c.category_id
      FROM jos_redshop_category c,jos_redshop_product_category_xref pc
      WHERE pc.product_id = '6191'
      AND pc.category_id = c.category_id
  56. SELECT c.category_id,c.category_name ,cx.category_child_id,cx.category_parent_id
      FROM jos_redshop_category_xref AS cx, jos_redshop_category AS c
      WHERE cx.category_child_id='137'
      AND c.category_id = cx.category_parent_id
  57. SELECT category_name
      FROM jos_redshop_category
      WHERE category_id = '137'
  58. SELECT
      FROM jos_redshop_product AS
      WHERE  p.product_id = 6191
  59. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 6191
      AND ps.stockroom_id = s.stockroom_id
  60. SELECT
      FROM jos_modules
      WHERE `module` LIKE 'mod_redmagicmagnifyplus'
      AND published  = 1
  61. SELECT *
      FROM jos_redshop_media 
      WHERE media_section = "product"
      AND section_id ="6191"
      AND media_type="images" 
      AND media_name = "1438448936_712315_529.jpg"
  62. SELECT *
      FROM jos_menu
      WHERE id = '188'
  63. SELECT sef_url,product_name,cat_in_sefurl
      FROM jos_redshop_product
      WHERE product_id = '6192'
  64. SELECT c.category_id
      FROM jos_redshop_category c,jos_redshop_product_category_xref pc
      WHERE pc.product_id = '6192'
      AND pc.category_id = c.category_id
  65. SELECT c.category_id,c.category_name ,cx.category_child_id,cx.category_parent_id
      FROM jos_redshop_category_xref AS cx, jos_redshop_category AS c
      WHERE cx.category_child_id='137'
      AND c.category_id = cx.category_parent_id
  66. SELECT category_name
      FROM jos_redshop_category
      WHERE category_id = '137'
  67. SELECT
      FROM jos_redshop_product AS
      WHERE  p.product_id = 6192
  68. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 6192
      AND ps.stockroom_id = s.stockroom_id
  69. SELECT
      FROM jos_modules
      WHERE `module` LIKE 'mod_redmagicmagnifyplus'
      AND published  = 1
  70. SELECT *
      FROM jos_redshop_media 
      WHERE media_section = "product"
      AND section_id ="6192"
      AND media_type="images" 
      AND media_name = "1438449004_723649_LR1.jpg"
  71. SELECT *
      FROM jos_menu
      WHERE id = '188'
  72. SELECT sef_url,product_name,cat_in_sefurl
      FROM jos_redshop_product
      WHERE product_id = '6193'
  73. SELECT c.category_id
      FROM jos_redshop_category c,jos_redshop_product_category_xref pc
      WHERE pc.product_id = '6193'
      AND pc.category_id = c.category_id
  74. SELECT c.category_id,c.category_name ,cx.category_child_id,cx.category_parent_id
      FROM jos_redshop_category_xref AS cx, jos_redshop_category AS c
      WHERE cx.category_child_id='137'
      AND c.category_id = cx.category_parent_id
  75. SELECT category_name
      FROM jos_redshop_category
      WHERE category_id = '137'
  76. SELECT
      FROM jos_redshop_product AS
      WHERE  p.product_id = 6193
  77. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 6193
      AND ps.stockroom_id = s.stockroom_id
  78. SELECT
      FROM jos_modules
      WHERE `module` LIKE 'mod_redmagicmagnifyplus'
      AND published  = 1
  79. SELECT *
      FROM jos_redshop_media 
      WHERE media_section = "product"
      AND section_id ="6193"
      AND media_type="images" 
      AND media_name = "1438449039_723908_LR1.jpg"
  80. SELECT *
      FROM jos_menu
      WHERE id = '188'
  81. SELECT sef_url,product_name,cat_in_sefurl
      FROM jos_redshop_product
      WHERE product_id = '6194'
  82. SELECT c.category_id
      FROM jos_redshop_category c,jos_redshop_product_category_xref pc
      WHERE pc.product_id = '6194'
      AND pc.category_id = c.category_id
  83. SELECT c.category_id,c.category_name ,cx.category_child_id,cx.category_parent_id
      FROM jos_redshop_category_xref AS cx, jos_redshop_category AS c
      WHERE cx.category_child_id='137'
      AND c.category_id = cx.category_parent_id
  84. SELECT category_name
      FROM jos_redshop_category
      WHERE category_id = '137'
  85. SELECT
      FROM jos_redshop_product AS
      WHERE  p.product_id = 6194
  86. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 6194
      AND ps.stockroom_id = s.stockroom_id
  87. SELECT
      FROM jos_modules
      WHERE `module` LIKE 'mod_redmagicmagnifyplus'
      AND published  = 1
  88. SELECT *
      FROM jos_redshop_media 
      WHERE media_section = "product"
      AND section_id ="6194"
      AND media_type="images" 
      AND media_name = "1438449081_724011_530.jpg"
  89. SELECT *
      FROM jos_menu
      WHERE id = '188'
  90. SELECT sef_url,product_name,cat_in_sefurl
      FROM jos_redshop_product
      WHERE product_id = '6195'
  91. SELECT c.category_id
      FROM jos_redshop_category c,jos_redshop_product_category_xref pc
      WHERE pc.product_id = '6195'
      AND pc.category_id = c.category_id
  92. SELECT c.category_id,c.category_name ,cx.category_child_id,cx.category_parent_id
      FROM jos_redshop_category_xref AS cx, jos_redshop_category AS c
      WHERE cx.category_child_id='137'
      AND c.category_id = cx.category_parent_id
  93. SELECT category_name
      FROM jos_redshop_category
      WHERE category_id = '137'
  94. SELECT
      FROM jos_redshop_product AS
      WHERE  p.product_id = 6195
  95. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 6195
      AND ps.stockroom_id = s.stockroom_id
  96. SELECT
      FROM jos_modules
      WHERE `module` LIKE 'mod_redmagicmagnifyplus'
      AND published  = 1
  97. SELECT *
      FROM jos_redshop_media 
      WHERE media_section = "product"
      AND section_id ="6195"
      AND media_type="images"
  98. SELECT *
      FROM jos_menu
      WHERE id = '188'
  99. SELECT sef_url,product_name,cat_in_sefurl
      FROM jos_redshop_product
      WHERE product_id = '6196'
  100. SELECT c.category_id
      FROM jos_redshop_category c,jos_redshop_product_category_xref pc
      WHERE pc.product_id = '6196'
      AND pc.category_id = c.category_id
  101. SELECT c.category_id,c.category_name ,cx.category_child_id,cx.category_parent_id
      FROM jos_redshop_category_xref AS cx, jos_redshop_category AS c
      WHERE cx.category_child_id='137'
      AND c.category_id = cx.category_parent_id
  102. SELECT category_name
      FROM jos_redshop_category
      WHERE category_id = '137'
  103. SELECT
      FROM jos_redshop_product AS
      WHERE  p.product_id = 6196
  104. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 6196
      AND ps.stockroom_id = s.stockroom_id
  105. SELECT
      FROM jos_modules
      WHERE `module` LIKE 'mod_redmagicmagnifyplus'
      AND published  = 1
  106. SELECT *
      FROM jos_redshop_media 
      WHERE media_section = "product"
      AND section_id ="6196"
      AND media_type="images" 
      AND media_name = "1438449165_724097_530.jpg"
  107. SELECT *
      FROM jos_menu
      WHERE id = '188'
  108. SELECT sef_url,product_name,cat_in_sefurl
      FROM jos_redshop_product
      WHERE product_id = '6197'
  109. SELECT c.category_id
      FROM jos_redshop_category c,jos_redshop_product_category_xref pc
      WHERE pc.product_id = '6197'
      AND pc.category_id = c.category_id
  110. SELECT c.category_id,c.category_name ,cx.category_child_id,cx.category_parent_id
      FROM jos_redshop_category_xref AS cx, jos_redshop_category AS c
      WHERE cx.category_child_id='137'
      AND c.category_id = cx.category_parent_id
  111. SELECT category_name
      FROM jos_redshop_category
      WHERE category_id = '137'
  112. SELECT
      FROM jos_redshop_product AS
      WHERE  p.product_id = 6197
  113. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 6197
      AND ps.stockroom_id = s.stockroom_id
  114. SELECT
      FROM jos_modules
      WHERE `module` LIKE 'mod_redmagicmagnifyplus'
      AND published  = 1
  115. SELECT *
      FROM jos_redshop_media 
      WHERE media_section = "product"
      AND section_id ="6197"
      AND media_type="images" 
      AND media_name = "1438449188_724202_530.jpg"
  116. SELECT *
      FROM jos_menu
      WHERE id = '188'
  117. SELECT sef_url,product_name,cat_in_sefurl
      FROM jos_redshop_product
      WHERE product_id = '6198'
  118. SELECT c.category_id
      FROM jos_redshop_category c,jos_redshop_product_category_xref pc
      WHERE pc.product_id = '6198'
      AND pc.category_id = c.category_id
  119. SELECT c.category_id,c.category_name ,cx.category_child_id,cx.category_parent_id
      FROM jos_redshop_category_xref AS cx, jos_redshop_category AS c
      WHERE cx.category_child_id='137'
      AND c.category_id = cx.category_parent_id
  120. SELECT category_name
      FROM jos_redshop_category
      WHERE category_id = '137'
  121. SELECT
      FROM jos_redshop_product AS
      WHERE  p.product_id = 6198
  122. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 6198
      AND ps.stockroom_id = s.stockroom_id
  123. SELECT
      FROM jos_modules
      WHERE `module` LIKE 'mod_redmagicmagnifyplus'
      AND published  = 1
  124. SELECT *
      FROM jos_redshop_media 
      WHERE media_section = "product"
      AND section_id ="6198"
      AND media_type="images" 
      AND media_name = "1438449213_725148_530.jpg"
  125. SELECT *
      FROM jos_menu
      WHERE id = '188'
  126. SELECT sef_url,product_name,cat_in_sefurl
      FROM jos_redshop_product
      WHERE product_id = '6199'
  127. SELECT c.category_id
      FROM jos_redshop_category c,jos_redshop_product_category_xref pc
      WHERE pc.product_id = '6199'
      AND pc.category_id = c.category_id
  128. SELECT c.category_id,c.category_name ,cx.category_child_id,cx.category_parent_id
      FROM jos_redshop_category_xref AS cx, jos_redshop_category AS c
      WHERE cx.category_child_id='137'
      AND c.category_id = cx.category_parent_id
  129. SELECT category_name
      FROM jos_redshop_category
      WHERE category_id = '137'
  130. SELECT
      FROM jos_redshop_product AS
      WHERE  p.product_id = 6199
  131. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 6199
      AND ps.stockroom_id = s.stockroom_id
  132. SELECT
      FROM jos_modules
      WHERE `module` LIKE 'mod_redmagicmagnifyplus'
      AND published  = 1
  133. SELECT *
      FROM jos_redshop_media 
      WHERE media_section = "product"
      AND section_id ="6199"
      AND media_type="images" 
      AND media_name = "1438449244_725193_530.jpg"
  134. SELECT *
      FROM jos_menu
      WHERE id = '188'
  135. SELECT sef_url,product_name,cat_in_sefurl
      FROM jos_redshop_product
      WHERE product_id = '6201'
  136. SELECT c.category_id
      FROM jos_redshop_category c,jos_redshop_product_category_xref pc
      WHERE pc.product_id = '6201'
      AND pc.category_id = c.category_id
  137. SELECT c.category_id,c.category_name ,cx.category_child_id,cx.category_parent_id
      FROM jos_redshop_category_xref AS cx, jos_redshop_category AS c
      WHERE cx.category_child_id='137'
      AND c.category_id = cx.category_parent_id
  138. SELECT category_name
      FROM jos_redshop_category
      WHERE category_id = '137'
  139. SELECT
      FROM jos_redshop_product AS
      WHERE  p.product_id = 6201
  140. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 6201
      AND ps.stockroom_id = s.stockroom_id
  141. SELECT
      FROM jos_modules
      WHERE `module` LIKE 'mod_redmagicmagnifyplus'
      AND published  = 1
  142. SELECT *
      FROM jos_redshop_media 
      WHERE media_section = "product"
      AND section_id ="6201"
      AND media_type="images" 
      AND media_name = "1438449350_725698_600.jpg"
  143. SELECT *
      FROM jos_menu
      WHERE id = '188'
  144. SELECT sef_url,product_name,cat_in_sefurl
      FROM jos_redshop_product
      WHERE product_id = '6200'
  145. SELECT c.category_id
      FROM jos_redshop_category c,jos_redshop_product_category_xref pc
      WHERE pc.product_id = '6200'
      AND pc.category_id = c.category_id
  146. SELECT c.category_id,c.category_name ,cx.category_child_id,cx.category_parent_id
      FROM jos_redshop_category_xref AS cx, jos_redshop_category AS c
      WHERE cx.category_child_id='137'
      AND c.category_id = cx.category_parent_id
  147. SELECT category_name
      FROM jos_redshop_category
      WHERE category_id = '137'
  148. SELECT
      FROM jos_redshop_product AS
      WHERE  p.product_id = 6200
  149. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 6200
      AND ps.stockroom_id = s.stockroom_id
  150. SELECT
      FROM jos_modules
      WHERE `module` LIKE 'mod_redmagicmagnifyplus'
      AND published  = 1
  151. SELECT *
      FROM jos_redshop_media 
      WHERE media_section = "product"
      AND section_id ="6200"
      AND media_type="images" 
      AND media_name = "1438449335_725742_641.jpg"
  152. SELECT *
      FROM jos_menu
      WHERE id = '188'
  153. SELECT sef_url,product_name,cat_in_sefurl
      FROM jos_redshop_product
      WHERE product_id = '6202'
  154. SELECT c.category_id
      FROM jos_redshop_category c,jos_redshop_product_category_xref pc
      WHERE pc.product_id = '6202'
      AND pc.category_id = c.category_id
  155. SELECT c.category_id,c.category_name ,cx.category_child_id,cx.category_parent_id
      FROM jos_redshop_category_xref AS cx, jos_redshop_category AS c
      WHERE cx.category_child_id='137'
      AND c.category_id = cx.category_parent_id
  156. SELECT category_name
      FROM jos_redshop_category
      WHERE category_id = '137'
  157. SELECT
      FROM jos_redshop_product AS
      WHERE  p.product_id = 6202
  158. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 6202
      AND ps.stockroom_id = s.stockroom_id
  159. SELECT
      FROM jos_modules
      WHERE `module` LIKE 'mod_redmagicmagnifyplus'
      AND published  = 1
  160. SELECT *
      FROM jos_redshop_media 
      WHERE media_section = "product"
      AND section_id ="6202"
      AND media_type="images" 
      AND media_name = "1438449364_725797_641.jpg"
  161. SELECT *
      FROM jos_menu
      WHERE id = '188'
  162. SELECT sef_url,product_name,cat_in_sefurl
      FROM jos_redshop_product
      WHERE product_id = '6203'
  163. SELECT c.category_id
      FROM jos_redshop_category c,jos_redshop_product_category_xref pc
      WHERE pc.product_id = '6203'
      AND pc.category_id = c.category_id
  164. SELECT c.category_id,c.category_name ,cx.category_child_id,cx.category_parent_id
      FROM jos_redshop_category_xref AS cx, jos_redshop_category AS c
      WHERE cx.category_child_id='137'
      AND c.category_id = cx.category_parent_id
  165. SELECT category_name
      FROM jos_redshop_category
      WHERE category_id = '137'
  166. SELECT
      FROM jos_redshop_product AS
      WHERE  p.product_id = 6203
  167. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 6203
      AND ps.stockroom_id = s.stockroom_id
  168. SELECT
      FROM jos_modules
      WHERE `module` LIKE 'mod_redmagicmagnifyplus'
      AND published  = 1
  169. SELECT *
      FROM jos_redshop_media 
      WHERE media_section = "product"
      AND section_id ="6203"
      AND media_type="images" 
      AND media_name = "1438449389_725810_641.jpg"
  170. SELECT *
      FROM jos_menu
      WHERE id = '188'
  171. SELECT sef_url,product_name,cat_in_sefurl
      FROM jos_redshop_product
      WHERE product_id = '6204'
  172. SELECT c.category_id
      FROM jos_redshop_category c,jos_redshop_product_category_xref pc
      WHERE pc.product_id = '6204'
      AND pc.category_id = c.category_id
  173. SELECT c.category_id,c.category_name ,cx.category_child_id,cx.category_parent_id
      FROM jos_redshop_category_xref AS cx, jos_redshop_category AS c
      WHERE cx.category_child_id='137'
      AND c.category_id = cx.category_parent_id
  174. SELECT category_name
      FROM jos_redshop_category
      WHERE category_id = '137'
  175. SELECT
      FROM jos_redshop_product AS
      WHERE  p.product_id = 6204
  176. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 6204
      AND ps.stockroom_id = s.stockroom_id
  177. SELECT
      FROM jos_modules
      WHERE `module` LIKE 'mod_redmagicmagnifyplus'
      AND published  = 1
  178. SELECT *
      FROM jos_redshop_media 
      WHERE media_section = "product"
      AND section_id ="6204"
      AND media_type="images" 
      AND media_name = "1438449417_725896_641.jpg"
  179. SELECT *
      FROM jos_menu
      WHERE id = '188'
  180. SELECT sef_url,product_name,cat_in_sefurl
      FROM jos_redshop_product
      WHERE product_id = '6205'
  181. SELECT c.category_id
      FROM jos_redshop_category c,jos_redshop_product_category_xref pc
      WHERE pc.product_id = '6205'
      AND pc.category_id = c.category_id
  182. SELECT c.category_id,c.category_name ,cx.category_child_id,cx.category_parent_id
      FROM jos_redshop_category_xref AS cx, jos_redshop_category AS c
      WHERE cx.category_child_id='137'
      AND c.category_id = cx.category_parent_id
  183. SELECT category_name
      FROM jos_redshop_category
      WHERE category_id = '137'
  184. SELECT
      FROM jos_redshop_product AS
      WHERE  p.product_id = 6205
  185. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 6205
      AND ps.stockroom_id = s.stockroom_id
  186. SELECT
      FROM jos_modules
      WHERE `module` LIKE 'mod_redmagicmagnifyplus'
      AND published  = 1
  187. SELECT *
      FROM jos_redshop_media 
      WHERE media_section = "product"
      AND section_id ="6205"
      AND media_type="images" 
      AND media_name = "1438449442_725919_641.jpg"
  188. SELECT *
      FROM jos_menu
      WHERE id = '188'
  189. SELECT sef_url,product_name,cat_in_sefurl
      FROM jos_redshop_product
      WHERE product_id = '6206'
  190. SELECT c.category_id
      FROM jos_redshop_category c,jos_redshop_product_category_xref pc
      WHERE pc.product_id = '6206'
      AND pc.category_id = c.category_id
  191. SELECT c.category_id,c.category_name ,cx.category_child_id,cx.category_parent_id
      FROM jos_redshop_category_xref AS cx, jos_redshop_category AS c
      WHERE cx.category_child_id='137'
      AND c.category_id = cx.category_parent_id
  192. SELECT category_name
      FROM jos_redshop_category
      WHERE category_id = '137'
  193. SELECT
      FROM jos_redshop_product AS
      WHERE  p.product_id = 6206
  194. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 6206
      AND ps.stockroom_id = s.stockroom_id
  195. SELECT
      FROM jos_modules
      WHERE `module` LIKE 'mod_redmagicmagnifyplus'
      AND published  = 1
  196. SELECT *
      FROM jos_redshop_media 
      WHERE media_section = "product"
      AND section_id ="6206"
      AND media_type="images" 
      AND media_name = "1438449469_725995_641.jpg"
  197. SELECT *
      FROM jos_menu
      WHERE id = '188'
  198. SELECT sef_url,product_name,cat_in_sefurl
      FROM jos_redshop_product
      WHERE product_id = '6207'
  199. SELECT c.category_id
      FROM jos_redshop_category c,jos_redshop_product_category_xref pc
      WHERE pc.product_id = '6207'
      AND pc.category_id = c.category_id
  200. SELECT c.category_id,c.category_name ,cx.category_child_id,cx.category_parent_id
      FROM jos_redshop_category_xref AS cx, jos_redshop_category AS c
      WHERE cx.category_child_id='137'
      AND c.category_id = cx.category_parent_id
  201. SELECT category_name
      FROM jos_redshop_category
      WHERE category_id = '137'
  202. SELECT
      FROM jos_redshop_product AS
      WHERE  p.product_id = 6207
  203. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 6207
      AND ps.stockroom_id = s.stockroom_id
  204. SELECT
      FROM jos_modules
      WHERE `module` LIKE 'mod_redmagicmagnifyplus'
      AND published  = 1
  205. SELECT *
      FROM jos_redshop_media 
      WHERE media_section = "product"
      AND section_id ="6207"
      AND media_type="images" 
      AND media_name = "1438449507_726046_641.jpg"
  206. SELECT *
      FROM jos_menu
      WHERE id = '188'
  207. SELECT sef_url,product_name,cat_in_sefurl
      FROM jos_redshop_product
      WHERE product_id = '6208'
  208. SELECT c.category_id
      FROM jos_redshop_category c,jos_redshop_product_category_xref pc
      WHERE pc.product_id = '6208'
      AND pc.category_id = c.category_id
  209. SELECT c.category_id,c.category_name ,cx.category_child_id,cx.category_parent_id
      FROM jos_redshop_category_xref AS cx, jos_redshop_category AS c
      WHERE cx.category_child_id='137'
      AND c.category_id = cx.category_parent_id
  210. SELECT category_name
      FROM jos_redshop_category
      WHERE category_id = '137'
  211. SELECT
      FROM jos_redshop_product AS
      WHERE  p.product_id = 6208
  212. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 6208
      AND ps.stockroom_id = s.stockroom_id
  213. SELECT
      FROM jos_modules
      WHERE `module` LIKE 'mod_redmagicmagnifyplus'
      AND published  = 1
  214. SELECT *
      FROM jos_redshop_media 
      WHERE media_section = "product"
      AND section_id ="6208"
      AND media_type="images" 
      AND media_name = "1438449525_726091_641.jpg"
  215. SELECT *
      FROM jos_menu
      WHERE id = '188'
  216. SELECT sef_url,product_name,cat_in_sefurl
      FROM jos_redshop_product
      WHERE product_id = '6209'
  217. SELECT c.category_id
      FROM jos_redshop_category c,jos_redshop_product_category_xref pc
      WHERE pc.product_id = '6209'
      AND pc.category_id = c.category_id
  218. SELECT c.category_id,c.category_name ,cx.category_child_id,cx.category_parent_id
      FROM jos_redshop_category_xref AS cx, jos_redshop_category AS c
      WHERE cx.category_child_id='137'
      AND c.category_id = cx.category_parent_id
  219. SELECT category_name
      FROM jos_redshop_category
      WHERE category_id = '137'
  220. SELECT
      FROM jos_redshop_product AS
      WHERE  p.product_id = 6209
  221. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 6209
      AND ps.stockroom_id = s.stockroom_id
  222. SELECT
      FROM jos_modules
      WHERE `module` LIKE 'mod_redmagicmagnifyplus'
      AND published  = 1
  223. SELECT *
      FROM jos_redshop_media 
      WHERE media_section = "product"
      AND section_id ="6209"
      AND media_type="images" 
      AND media_name = "1438449538_740301_641.jpg"
  224. SELECT *
      FROM jos_menu
      WHERE id = '188'
  225. SELECT sef_url,product_name,cat_in_sefurl
      FROM jos_redshop_product
      WHERE product_id = '6210'
  226. SELECT c.category_id
      FROM jos_redshop_category c,jos_redshop_product_category_xref pc
      WHERE pc.product_id = '6210'
      AND pc.category_id = c.category_id
  227. SELECT c.category_id,c.category_name ,cx.category_child_id,cx.category_parent_id
      FROM jos_redshop_category_xref AS cx, jos_redshop_category AS c
      WHERE cx.category_child_id='137'
      AND c.category_id = cx.category_parent_id
  228. SELECT category_name
      FROM jos_redshop_category
      WHERE category_id = '137'
  229. SELECT
      FROM jos_redshop_product AS
      WHERE  p.product_id = 6210
  230. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 6210
      AND ps.stockroom_id = s.stockroom_id
  231. SELECT
      FROM jos_modules
      WHERE `module` LIKE 'mod_redmagicmagnifyplus'
      AND published  = 1
  232. SELECT *
      FROM jos_redshop_media 
      WHERE media_section = "product"
      AND section_id ="6210"
      AND media_type="images" 
      AND media_name = "1438449559_752403_644.jpg"
  233. SELECT *
      FROM jos_menu
      WHERE id = '188'
  234. SELECT sef_url,product_name,cat_in_sefurl
      FROM jos_redshop_product
      WHERE product_id = '6211'
  235. SELECT c.category_id
      FROM jos_redshop_category c,jos_redshop_product_category_xref pc
      WHERE pc.product_id = '6211'
      AND pc.category_id = c.category_id
  236. SELECT c.category_id,c.category_name ,cx.category_child_id,cx.category_parent_id
      FROM jos_redshop_category_xref AS cx, jos_redshop_category AS c
      WHERE cx.category_child_id='137'
      AND c.category_id = cx.category_parent_id
  237. SELECT category_name
      FROM jos_redshop_category
      WHERE category_id = '137'
  238. SELECT
      FROM jos_redshop_product AS
      WHERE  p.product_id = 6211
  239. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 6211
      AND ps.stockroom_id = s.stockroom_id
  240. SELECT
      FROM jos_modules
      WHERE `module` LIKE 'mod_redmagicmagnifyplus'
      AND published  = 1
  241. SELECT *
      FROM jos_redshop_media 
      WHERE media_section = "product"
      AND section_id ="6211"
      AND media_type="images" 
      AND media_name = "1438449602_752465_641.jpg"
  242. SELECT *
      FROM jos_menu
      WHERE id = '188'
  243. SELECT sef_url,product_name,cat_in_sefurl
      FROM jos_redshop_product
      WHERE product_id = '6212'
  244. SELECT c.category_id
      FROM jos_redshop_category c,jos_redshop_product_category_xref pc
      WHERE pc.product_id = '6212'
      AND pc.category_id = c.category_id
  245. SELECT c.category_id,c.category_name ,cx.category_child_id,cx.category_parent_id
      FROM jos_redshop_category_xref AS cx, jos_redshop_category AS c
      WHERE cx.category_child_id='137'
      AND c.category_id = cx.category_parent_id
  246. SELECT category_name
      FROM jos_redshop_category
      WHERE category_id = '137'
  247. SELECT
      FROM jos_redshop_product AS
      WHERE  p.product_id = 6212
  248. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 6212
      AND ps.stockroom_id = s.stockroom_id
  249. SELECT
      FROM jos_modules
      WHERE `module` LIKE 'mod_redmagicmagnifyplus'
      AND published  = 1
  250. SELECT *
      FROM jos_redshop_media 
      WHERE media_section = "product"
      AND section_id ="6212"
      AND media_type="images" 
      AND media_name = "1438449610_773811_641.jpg"
  251. SELECT *
      FROM jos_menu
      WHERE id = '188'
  252. SELECT sef_url,product_name,cat_in_sefurl
      FROM jos_redshop_product
      WHERE product_id = '6213'
  253. SELECT c.category_id
      FROM jos_redshop_category c,jos_redshop_product_category_xref pc
      WHERE pc.product_id = '6213'
      AND pc.category_id = c.category_id
  254. SELECT c.category_id,c.category_name ,cx.category_child_id,cx.category_parent_id
      FROM jos_redshop_category_xref AS cx, jos_redshop_category AS c
      WHERE cx.category_child_id='137'
      AND c.category_id = cx.category_parent_id
  255. SELECT category_name
      FROM jos_redshop_category
      WHERE category_id = '137'
  256. SELECT
      FROM jos_redshop_product AS
      WHERE  p.product_id = 6213
  257. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 6213
      AND ps.stockroom_id = s.stockroom_id
  258. SELECT
      FROM jos_modules
      WHERE `module` LIKE 'mod_redmagicmagnifyplus'
      AND published  = 1
  259. SELECT *
      FROM jos_redshop_media 
      WHERE media_section = "product"
      AND section_id ="6213"
      AND media_type="images" 
      AND media_name = "1438449630_788020_641.jpg"
  260. SELECT *
      FROM jos_menu
      WHERE id = '188'
  261. SELECT sef_url,product_name,cat_in_sefurl
      FROM jos_redshop_product
      WHERE product_id = '6214'
  262. SELECT c.category_id
      FROM jos_redshop_category c,jos_redshop_product_category_xref pc
      WHERE pc.product_id = '6214'
      AND pc.category_id = c.category_id
  263. SELECT c.category_id,c.category_name ,cx.category_child_id,cx.category_parent_id
      FROM jos_redshop_category_xref AS cx, jos_redshop_category AS c
      WHERE cx.category_child_id='137'
      AND c.category_id = cx.category_parent_id
  264. SELECT category_name
      FROM jos_redshop_category
      WHERE category_id = '137'
  265. SELECT
      FROM jos_redshop_product AS
      WHERE  p.product_id = 6214
  266. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 6214
      AND ps.stockroom_id = s.stockroom_id
  267. SELECT
      FROM jos_modules
      WHERE `module` LIKE 'mod_redmagicmagnifyplus'
      AND published  = 1
  268. SELECT *
      FROM jos_redshop_media 
      WHERE media_section = "product"
      AND section_id ="6214"
      AND media_type="images" 
      AND media_name = "1438449678_788563_641.jpg"
  269. SELECT *
      FROM jos_menu
      WHERE id = '188'
  270. SELECT sef_url,product_name,cat_in_sefurl
      FROM jos_redshop_product
      WHERE product_id = '6215'
  271. SELECT c.category_id
      FROM jos_redshop_category c,jos_redshop_product_category_xref pc
      WHERE pc.product_id = '6215'
      AND pc.category_id = c.category_id
  272. SELECT c.category_id,c.category_name ,cx.category_child_id,cx.category_parent_id
      FROM jos_redshop_category_xref AS cx, jos_redshop_category AS c
      WHERE cx.category_child_id='137'
      AND c.category_id = cx.category_parent_id
  273. SELECT category_name
      FROM jos_redshop_category
      WHERE category_id = '137'
  274. SELECT
      FROM jos_redshop_product AS
      WHERE  p.product_id = 6215
  275. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 6215
      AND ps.stockroom_id = s.stockroom_id
  276. SELECT
      FROM jos_modules
      WHERE `module` LIKE 'mod_redmagicmagnifyplus'
      AND published  = 1
  277. SELECT *
      FROM jos_redshop_media 
      WHERE media_section = "product"
      AND section_id ="6215"
      AND media_type="images" 
      AND media_name = "1438449700_816204_531.jpg"
  278. SELECT *
      FROM jos_menu
      WHERE id = '188'
  279. SELECT sef_url,product_name,cat_in_sefurl
      FROM jos_redshop_product
      WHERE product_id = '6216'
  280. SELECT c.category_id
      FROM jos_redshop_category c,jos_redshop_product_category_xref pc
      WHERE pc.product_id = '6216'
      AND pc.category_id = c.category_id
  281. SELECT c.category_id,c.category_name ,cx.category_child_id,cx.category_parent_id
      FROM jos_redshop_category_xref AS cx, jos_redshop_category AS c
      WHERE cx.category_child_id='137'
      AND c.category_id = cx.category_parent_id
  282. SELECT category_name
      FROM jos_redshop_category
      WHERE category_id = '137'
  283. SELECT
      FROM jos_redshop_product AS
      WHERE  p.product_id = 6216
  284. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 6216
      AND ps.stockroom_id = s.stockroom_id
  285. SELECT
      FROM jos_modules
      WHERE `module` LIKE 'mod_redmagicmagnifyplus'
      AND published  = 1
  286. SELECT *
      FROM jos_redshop_media 
      WHERE media_section = "product"
      AND section_id ="6216"
      AND media_type="images" 
      AND media_name = "1438449723_884814_530.jpg"
  287. SELECT *
      FROM jos_menu
      WHERE id = '188'
  288. SELECT sef_url,product_name,cat_in_sefurl
      FROM jos_redshop_product
      WHERE product_id = '6217'
  289. SELECT c.category_id
      FROM jos_redshop_category c,jos_redshop_product_category_xref pc
      WHERE pc.product_id = '6217'
      AND pc.category_id = c.category_id
  290. SELECT c.category_id,c.category_name ,cx.category_child_id,cx.category_parent_id
      FROM jos_redshop_category_xref AS cx, jos_redshop_category AS c
      WHERE cx.category_child_id='137'
      AND c.category_id = cx.category_parent_id
  291. SELECT category_name
      FROM jos_redshop_category
      WHERE category_id = '137'
  292. SELECT
      FROM jos_redshop_product AS
      WHERE  p.product_id = 6217
  293. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 6217
      AND ps.stockroom_id = s.stockroom_id
  294. SELECT
      FROM jos_modules
      WHERE `module` LIKE 'mod_redmagicmagnifyplus'
      AND published  = 1
  295. SELECT *
      FROM jos_redshop_media 
      WHERE media_section = "product"
      AND section_id ="6217"
      AND media_type="images" 
      AND media_name = "1438449745_885507_531.jpg"
  296. SELECT *
      FROM jos_menu
      WHERE id = '188'
  297. SELECT sef_url,product_name,cat_in_sefurl
      FROM jos_redshop_product
      WHERE product_id = '6218'
  298. SELECT c.category_id
      FROM jos_redshop_category c,jos_redshop_product_category_xref pc
      WHERE pc.product_id = '6218'
      AND pc.category_id = c.category_id
  299. SELECT c.category_id,c.category_name ,cx.category_child_id,cx.category_parent_id
      FROM jos_redshop_category_xref AS cx, jos_redshop_category AS c
      WHERE cx.category_child_id='137'
      AND c.category_id = cx.category_parent_id
  300. SELECT category_name
      FROM jos_redshop_category
      WHERE category_id = '137'
  301. SELECT
      FROM jos_redshop_product AS
      WHERE  p.product_id = 6218
  302. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 6218
      AND ps.stockroom_id = s.stockroom_id
  303. SELECT
      FROM jos_modules
      WHERE `module` LIKE 'mod_redmagicmagnifyplus'
      AND published  = 1
  304. SELECT *
      FROM jos_redshop_media 
      WHERE media_section = "product"
      AND section_id ="6218"
      AND media_type="images" 
      AND media_name = "1438449782_885828_641.jpg"
  305. SELECT *
      FROM jos_menu
      WHERE id = '188'
  306. SELECT sef_url,product_name,cat_in_sefurl
      FROM jos_redshop_product
      WHERE product_id = '6219'
  307. SELECT c.category_id
      FROM jos_redshop_category c,jos_redshop_product_category_xref pc
      WHERE pc.product_id = '6219'
      AND pc.category_id = c.category_id
  308. SELECT c.category_id,c.category_name ,cx.category_child_id,cx.category_parent_id
      FROM jos_redshop_category_xref AS cx, jos_redshop_category AS c
      WHERE cx.category_child_id='137'
      AND c.category_id = cx.category_parent_id
  309. SELECT category_name
      FROM jos_redshop_category
      WHERE category_id = '137'
  310. SELECT
      FROM jos_redshop_product AS
      WHERE  p.product_id = 6219
  311. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 6219
      AND ps.stockroom_id = s.stockroom_id
  312. SELECT
      FROM jos_modules
      WHERE `module` LIKE 'mod_redmagicmagnifyplus'
      AND published  = 1
  313. SELECT *
      FROM jos_redshop_media 
      WHERE media_section = "product"
      AND section_id ="6219"
      AND media_type="images" 
      AND media_name = "1438449804_885842_641.jpg"
  314. SELECT *
      FROM jos_menu
      WHERE id = '188'
  315. SELECT sef_url,product_name,cat_in_sefurl
      FROM jos_redshop_product
      WHERE product_id = '6220'
  316. SELECT c.category_id
      FROM jos_redshop_category c,jos_redshop_product_category_xref pc
      WHERE pc.product_id = '6220'
      AND pc.category_id = c.category_id
  317. SELECT c.category_id,c.category_name ,cx.category_child_id,cx.category_parent_id
      FROM jos_redshop_category_xref AS cx, jos_redshop_category AS c
      WHERE cx.category_child_id='137'
      AND c.category_id = cx.category_parent_id
  318. SELECT category_name
      FROM jos_redshop_category
      WHERE category_id = '137'
  319. SELECT
      FROM jos_redshop_product AS
      WHERE  p.product_id = 6220
  320. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 6220
      AND ps.stockroom_id = s.stockroom_id
  321. SELECT
      FROM jos_modules
      WHERE `module` LIKE 'mod_redmagicmagnifyplus'
      AND published  = 1
  322. SELECT *
      FROM jos_redshop_media 
      WHERE media_section = "product"
      AND section_id ="6220"
      AND media_type="images" 
      AND media_name = "1438449820_885859_641.jpg"
  323. SELECT *
      FROM jos_menu
      WHERE id = '188'
  324. SELECT sef_url,product_name,cat_in_sefurl
      FROM jos_redshop_product
      WHERE product_id = '6221'
  325. SELECT c.category_id
      FROM jos_redshop_category c,jos_redshop_product_category_xref pc
      WHERE pc.product_id = '6221'
      AND pc.category_id = c.category_id
  326. SELECT c.category_id,c.category_name ,cx.category_child_id,cx.category_parent_id
      FROM jos_redshop_category_xref AS cx, jos_redshop_category AS c
      WHERE cx.category_child_id='137'
      AND c.category_id = cx.category_parent_id
  327. SELECT category_name
      FROM jos_redshop_category
      WHERE category_id = '137'
  328. SELECT
      FROM jos_redshop_product AS
      WHERE  p.product_id = 6221
  329. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 6221
      AND ps.stockroom_id = s.stockroom_id
  330. SELECT
      FROM jos_modules
      WHERE `module` LIKE 'mod_redmagicmagnifyplus'
      AND published  = 1
  331. SELECT *
      FROM jos_redshop_media 
      WHERE media_section = "product"
      AND section_id ="6221"
      AND media_type="images" 
      AND media_name = "1438449841_885903_641.jpg"
  332. SELECT *
      FROM jos_menu
      WHERE id = '188'
  333. SELECT sef_url,product_name,cat_in_sefurl
      FROM jos_redshop_product
      WHERE product_id = '6222'
  334. SELECT c.category_id
      FROM jos_redshop_category c,jos_redshop_product_category_xref pc
      WHERE pc.product_id = '6222'
      AND pc.category_id = c.category_id
  335. SELECT c.category_id,c.category_name ,cx.category_child_id,cx.category_parent_id
      FROM jos_redshop_category_xref AS cx, jos_redshop_category AS c
      WHERE cx.category_child_id='137'
      AND c.category_id = cx.category_parent_id
  336. SELECT category_name
      FROM jos_redshop_category
      WHERE category_id = '137'
  337. SELECT
      FROM jos_redshop_product AS
      WHERE  p.product_id = 6222
  338. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 6222
      AND ps.stockroom_id = s.stockroom_id
  339. SELECT
      FROM jos_modules
      WHERE `module` LIKE 'mod_redmagicmagnifyplus'
      AND published  = 1
  340. SELECT *
      FROM jos_redshop_media 
      WHERE media_section = "product"
      AND section_id ="6222"
      AND media_type="images" 
      AND media_name = "1438449862_885910_641.jpg"
  341. SELECT *
      FROM jos_menu
      WHERE id = '188'
  342. SELECT sef_url,product_name,cat_in_sefurl
      FROM jos_redshop_product
      WHERE product_id = '6223'
  343. SELECT c.category_id
      FROM jos_redshop_category c,jos_redshop_product_category_xref pc
      WHERE pc.product_id = '6223'
      AND pc.category_id = c.category_id
  344. SELECT c.category_id,c.category_name ,cx.category_child_id,cx.category_parent_id
      FROM jos_redshop_category_xref AS cx, jos_redshop_category AS c
      WHERE cx.category_child_id='137'
      AND c.category_id = cx.category_parent_id
  345. SELECT category_name
      FROM jos_redshop_category
      WHERE category_id = '137'
  346. SELECT
      FROM jos_redshop_product AS
      WHERE  p.product_id = 6223
  347. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 6223
      AND ps.stockroom_id = s.stockroom_id
  348. SELECT
      FROM jos_modules
      WHERE `module` LIKE 'mod_redmagicmagnifyplus'
      AND published  = 1
  349. SELECT *
      FROM jos_redshop_media 
      WHERE media_section = "product"
      AND section_id ="6223"
      AND media_type="images" 
      AND media_name = "1438449891_885965_641.jpg"
  350. SELECT *
      FROM jos_menu
      WHERE id = '188'
  351. SELECT sef_url,product_name,cat_in_sefurl
      FROM jos_redshop_product
      WHERE product_id = '6224'
  352. SELECT c.category_id
      FROM jos_redshop_category c,jos_redshop_product_category_xref pc
      WHERE pc.product_id = '6224'
      AND pc.category_id = c.category_id
  353. SELECT c.category_id,c.category_name ,cx.category_child_id,cx.category_parent_id
      FROM jos_redshop_category_xref AS cx, jos_redshop_category AS c
      WHERE cx.category_child_id='137'
      AND c.category_id = cx.category_parent_id
  354. SELECT category_name
      FROM jos_redshop_category
      WHERE category_id = '137'
  355. SELECT
      FROM jos_redshop_product AS
      WHERE  p.product_id = 6224
  356. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 6224
      AND ps.stockroom_id = s.stockroom_id
  357. SELECT
      FROM jos_modules
      WHERE `module` LIKE 'mod_redmagicmagnifyplus'
      AND published  = 1
  358. SELECT *
      FROM jos_redshop_media 
      WHERE media_section = "product"
      AND section_id ="6224"
      AND media_type="images" 
      AND media_name = "1438449928_886009_641.jpg"
  359. SELECT *
      FROM jos_menu
      WHERE id = '188'
  360. SELECT sef_url,product_name,cat_in_sefurl
      FROM jos_redshop_product
      WHERE product_id = '6225'
  361. SELECT c.category_id
      FROM jos_redshop_category c,jos_redshop_product_category_xref pc
      WHERE pc.product_id = '6225'
      AND pc.category_id = c.category_id
  362. SELECT c.category_id,c.category_name ,cx.category_child_id,cx.category_parent_id
      FROM jos_redshop_category_xref AS cx, jos_redshop_category AS c
      WHERE cx.category_child_id='137'
      AND c.category_id = cx.category_parent_id
  363. SELECT category_name
      FROM jos_redshop_category
      WHERE category_id = '137'
  364. SELECT
      FROM jos_redshop_product AS
      WHERE  p.product_id = 6225
  365. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 6225
      AND ps.stockroom_id = s.stockroom_id
  366. SELECT
      FROM jos_modules
      WHERE `module` LIKE 'mod_redmagicmagnifyplus'
      AND published  = 1
  367. SELECT *
      FROM jos_redshop_media 
      WHERE media_section = "product"
      AND section_id ="6225"
      AND media_type="images" 
      AND media_name = "1438449942_886023_641.jpg"
  368. SELECT *
      FROM jos_menu
      WHERE id = '188'
  369. SELECT sef_url,product_name,cat_in_sefurl
      FROM jos_redshop_product
      WHERE product_id = '6226'
  370. SELECT c.category_id
      FROM jos_redshop_category c,jos_redshop_product_category_xref pc
      WHERE pc.product_id = '6226'
      AND pc.category_id = c.category_id
  371. SELECT c.category_id,c.category_name ,cx.category_child_id,cx.category_parent_id
      FROM jos_redshop_category_xref AS cx, jos_redshop_category AS c
      WHERE cx.category_child_id='137'
      AND c.category_id = cx.category_parent_id
  372. SELECT category_name
      FROM jos_redshop_category
      WHERE category_id = '137'
  373. SELECT
      FROM jos_redshop_product AS
      WHERE  p.product_id = 6226
  374. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 6226
      AND ps.stockroom_id = s.stockroom_id
  375. SELECT
      FROM jos_modules
      WHERE `module` LIKE 'mod_redmagicmagnifyplus'
      AND published  = 1
  376. SELECT *
      FROM jos_redshop_media 
      WHERE media_section = "product"
      AND section_id ="6226"
      AND media_type="images" 
      AND media_name = "1438449956_886047_641.jpg"
  377. SELECT *
      FROM jos_menu
      WHERE id = '188'
  378. SELECT sef_url,product_name,cat_in_sefurl
      FROM jos_redshop_product
      WHERE product_id = '6227'
  379. SELECT c.category_id
      FROM jos_redshop_category c,jos_redshop_product_category_xref pc
      WHERE pc.product_id = '6227'
      AND pc.category_id = c.category_id
  380. SELECT c.category_id,c.category_name ,cx.category_child_id,cx.category_parent_id
      FROM jos_redshop_category_xref AS cx, jos_redshop_category AS c
      WHERE cx.category_child_id='137'
      AND c.category_id = cx.category_parent_id
  381. SELECT category_name
      FROM jos_redshop_category
      WHERE category_id = '137'
  382. SELECT
      FROM jos_redshop_product AS
      WHERE  p.product_id = 6227
  383. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 6227
      AND ps.stockroom_id = s.stockroom_id
  384. SELECT
      FROM jos_modules
      WHERE `module` LIKE 'mod_redmagicmagnifyplus'
      AND published  = 1
  385. SELECT *
      FROM jos_redshop_media 
      WHERE media_section = "product"
      AND section_id ="6227"
      AND media_type="images" 
      AND media_name = "1438450085_886054_641.jpg"
  386. SELECT *
      FROM jos_menu
      WHERE id = '188'
  387. SELECT sef_url,product_name,cat_in_sefurl
      FROM jos_redshop_product
      WHERE product_id = '6228'
  388. SELECT c.category_id
      FROM jos_redshop_category c,jos_redshop_product_category_xref pc
      WHERE pc.product_id = '6228'
      AND pc.category_id = c.category_id
  389. SELECT c.category_id,c.category_name ,cx.category_child_id,cx.category_parent_id
      FROM jos_redshop_category_xref AS cx, jos_redshop_category AS c
      WHERE cx.category_child_id='137'
      AND c.category_id = cx.category_parent_id
  390. SELECT category_name
      FROM jos_redshop_category
      WHERE category_id = '137'
  391. SELECT
      FROM jos_redshop_product AS
      WHERE  p.product_id = 6228
  392. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 6228
      AND ps.stockroom_id = s.stockroom_id
  393. SELECT
      FROM jos_modules
      WHERE `module` LIKE 'mod_redmagicmagnifyplus'
      AND published  = 1
  394. SELECT *
      FROM jos_redshop_media 
      WHERE media_section = "product"
      AND section_id ="6228"
      AND media_type="images" 
      AND media_name = "1438450113_886405_642.jpg"
  395. SELECT *
      FROM jos_menu
      WHERE id = '188'
  396. SELECT sef_url,product_name,cat_in_sefurl
      FROM jos_redshop_product
      WHERE product_id = '6229'
  397. SELECT c.category_id
      FROM jos_redshop_category c,jos_redshop_product_category_xref pc
      WHERE pc.product_id = '6229'
      AND pc.category_id = c.category_id
  398. SELECT c.category_id,c.category_name ,cx.category_child_id,cx.category_parent_id
      FROM jos_redshop_category_xref AS cx, jos_redshop_category AS c
      WHERE cx.category_child_id='137'
      AND c.category_id = cx.category_parent_id
  399. SELECT category_name
      FROM jos_redshop_category
      WHERE category_id = '137'
  400. SELECT
      FROM jos_redshop_product AS
      WHERE  p.product_id = 6229
  401. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 6229
      AND ps.stockroom_id = s.stockroom_id
  402. SELECT
      FROM jos_modules
      WHERE `module` LIKE 'mod_redmagicmagnifyplus'
      AND published  = 1
  403. SELECT *
      FROM jos_redshop_media 
      WHERE media_section = "product"
      AND section_id ="6229"
      AND media_type="images" 
      AND media_name = "1438450130_886900_641.jpg"
  404. SELECT *
      FROM jos_menu
      WHERE id = '188'
  405. SELECT sef_url,product_name,cat_in_sefurl
      FROM jos_redshop_product
      WHERE product_id = '6230'
  406. SELECT c.category_id
      FROM jos_redshop_category c,jos_redshop_product_category_xref pc
      WHERE pc.product_id = '6230'
      AND pc.category_id = c.category_id
  407. SELECT c.category_id,c.category_name ,cx.category_child_id,cx.category_parent_id
      FROM jos_redshop_category_xref AS cx, jos_redshop_category AS c
      WHERE cx.category_child_id='137'
      AND c.category_id = cx.category_parent_id
  408. SELECT category_name
      FROM jos_redshop_category
      WHERE category_id = '137'
  409. SELECT
      FROM jos_redshop_product AS
      WHERE  p.product_id = 6230
  410. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 6230
      AND ps.stockroom_id = s.stockroom_id
  411. SELECT
      FROM jos_modules
      WHERE `module` LIKE 'mod_redmagicmagnifyplus'
      AND published  = 1
  412. SELECT *
      FROM jos_redshop_media 
      WHERE media_section = "product"
      AND section_id ="6230"
      AND media_type="images" 
      AND media_name = "1438450156_886917_641.jpg"
  413. SELECT *
      FROM jos_menu
      WHERE id = '188'
  414. SELECT sef_url,product_name,cat_in_sefurl
      FROM jos_redshop_product
      WHERE product_id = '6231'
  415. SELECT c.category_id
      FROM jos_redshop_category c,jos_redshop_product_category_xref pc
      WHERE pc.product_id = '6231'
      AND pc.category_id = c.category_id
  416. SELECT c.category_id,c.category_name ,cx.category_child_id,cx.category_parent_id
      FROM jos_redshop_category_xref AS cx, jos_redshop_category AS c
      WHERE cx.category_child_id='137'
      AND c.category_id = cx.category_parent_id
  417. SELECT category_name
      FROM jos_redshop_category
      WHERE category_id = '137'
  418. SELECT
      FROM jos_redshop_product AS
      WHERE  p.product_id = 6231
  419. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 6231
      AND ps.stockroom_id = s.stockroom_id
  420. SELECT
      FROM jos_modules
      WHERE `module` LIKE 'mod_redmagicmagnifyplus'
      AND published  = 1
  421. SELECT *
      FROM jos_redshop_media 
      WHERE media_section = "product"
      AND section_id ="6231"
      AND media_type="images" 
      AND media_name = "1438450176_886924_641.jpg"
  422. SELECT *
      FROM jos_menu
      WHERE id = '188'
  423. SELECT sef_url,product_name,cat_in_sefurl
      FROM jos_redshop_product
      WHERE product_id = '6232'
  424. SELECT c.category_id
      FROM jos_redshop_category c,jos_redshop_product_category_xref pc
      WHERE pc.product_id = '6232'
      AND pc.category_id = c.category_id
  425. SELECT c.category_id,c.category_name ,cx.category_child_id,cx.category_parent_id
      FROM jos_redshop_category_xref AS cx, jos_redshop_category AS c
      WHERE cx.category_child_id='137'
      AND c.category_id = cx.category_parent_id
  426. SELECT category_name
      FROM jos_redshop_category
      WHERE category_id = '137'
  427. SELECT
      FROM jos_redshop_product AS
      WHERE  p.product_id = 6232
  428. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 6232
      AND ps.stockroom_id = s.stockroom_id
  429. SELECT
      FROM jos_modules
      WHERE `module` LIKE 'mod_redmagicmagnifyplus'
      AND published  = 1
  430. SELECT *
      FROM jos_redshop_media 
      WHERE media_section = "product"
      AND section_id ="6232"
      AND media_type="images" 
      AND media_name = "1438450195_887013_641.jpg"
  431. SELECT *
      FROM jos_menu
      WHERE id = '188'
  432. SELECT sef_url,product_name,cat_in_sefurl
      FROM jos_redshop_product
      WHERE product_id = '6233'
  433. SELECT c.category_id
      FROM jos_redshop_category c,jos_redshop_product_category_xref pc
      WHERE pc.product_id = '6233'
      AND pc.category_id = c.category_id
  434. SELECT c.category_id,c.category_name ,cx.category_child_id,cx.category_parent_id
      FROM jos_redshop_category_xref AS cx, jos_redshop_category AS c
      WHERE cx.category_child_id='137'
      AND c.category_id = cx.category_parent_id
  435. SELECT category_name
      FROM jos_redshop_category
      WHERE category_id = '137'
  436. SELECT
      FROM jos_redshop_product AS
      WHERE  p.product_id = 6233
  437. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 6233
      AND ps.stockroom_id = s.stockroom_id
  438. SELECT
      FROM jos_modules
      WHERE `module` LIKE 'mod_redmagicmagnifyplus'
      AND published  = 1
  439. SELECT *
      FROM jos_redshop_media 
      WHERE media_section = "product"
      AND section_id ="6233"
      AND media_type="images" 
      AND media_name = "1438450218_887020_641.jpg"
  440. SELECT *
      FROM jos_menu
      WHERE id = '188'
  441. SELECT sef_url,product_name,cat_in_sefurl
      FROM jos_redshop_product
      WHERE product_id = '6234'
  442. SELECT c.category_id
      FROM jos_redshop_category c,jos_redshop_product_category_xref pc
      WHERE pc.product_id = '6234'
      AND pc.category_id = c.category_id
  443. SELECT c.category_id,c.category_name ,cx.category_child_id,cx.category_parent_id
      FROM jos_redshop_category_xref AS cx, jos_redshop_category AS c
      WHERE cx.category_child_id='137'
      AND c.category_id = cx.category_parent_id
  444. SELECT category_name
      FROM jos_redshop_category
      WHERE category_id = '137'
  445. SELECT
      FROM jos_redshop_product AS
      WHERE  p.product_id = 6234
  446. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 6234
      AND ps.stockroom_id = s.stockroom_id
  447. SELECT
      FROM jos_modules
      WHERE `module` LIKE 'mod_redmagicmagnifyplus'
      AND published  = 1
  448. SELECT *
      FROM jos_redshop_media 
      WHERE media_section = "product"
      AND section_id ="6234"
      AND media_type="images" 
      AND media_name = "1438450240_887105_641.jpg"
  449. SELECT *
      FROM jos_menu
      WHERE id = '188'
  450. SELECT sef_url,product_name,cat_in_sefurl
      FROM jos_redshop_product
      WHERE product_id = '6235'
  451. SELECT c.category_id
      FROM jos_redshop_category c,jos_redshop_product_category_xref pc
      WHERE pc.product_id = '6235'
      AND pc.category_id = c.category_id
  452. SELECT c.category_id,c.category_name ,cx.category_child_id,cx.category_parent_id
      FROM jos_redshop_category_xref AS cx, jos_redshop_category AS c
      WHERE cx.category_child_id='137'
      AND c.category_id = cx.category_parent_id
  453. SELECT category_name
      FROM jos_redshop_category
      WHERE category_id = '137'
  454. SELECT
      FROM jos_redshop_product AS
      WHERE  p.product_id = 6235
  455. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 6235
      AND ps.stockroom_id = s.stockroom_id
  456. SELECT
      FROM jos_modules
      WHERE `module` LIKE 'mod_redmagicmagnifyplus'
      AND published  = 1
  457. SELECT *
      FROM jos_redshop_media 
      WHERE media_section = "product"
      AND section_id ="6235"
      AND media_type="images" 
      AND media_name = "1438450261_887112_641.jpg"
  458. SELECT *
      FROM jos_menu
      WHERE id = '188'
  459. SELECT sef_url,product_name,cat_in_sefurl
      FROM jos_redshop_product
      WHERE product_id = '6236'
  460. SELECT c.category_id
      FROM jos_redshop_category c,jos_redshop_product_category_xref pc
      WHERE pc.product_id = '6236'
      AND pc.category_id = c.category_id
  461. SELECT c.category_id,c.category_name ,cx.category_child_id,cx.category_parent_id
      FROM jos_redshop_category_xref AS cx, jos_redshop_category AS c
      WHERE cx.category_child_id='137'
      AND c.category_id = cx.category_parent_id
  462. SELECT category_name
      FROM jos_redshop_category
      WHERE category_id = '137'
  463. SELECT
      FROM jos_redshop_product AS
      WHERE  p.product_id = 6236
  464. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 6236
      AND ps.stockroom_id = s.stockroom_id
  465. SELECT
      FROM jos_modules
      WHERE `module` LIKE 'mod_redmagicmagnifyplus'
      AND published  = 1
  466. SELECT *
      FROM jos_redshop_media 
      WHERE media_section = "product"
      AND section_id ="6236"
      AND media_type="images" 
      AND media_name = "1438450280_887204_641.jpg"
  467. SELECT id, title, module, position, content, showtitle, control, params
      FROM jos_modules AS m
      LEFT JOIN jos_modules_menu AS mm
      ON mm.moduleid = m.id
      WHERE m.published = 1
      AND m.access <= 0
      AND m.client_id = 0
      AND ( mm.menuid = 188 OR mm.menuid = 0 )
      ORDER BY position, ordering
  468. SELECT *
      FROM jos_menu
      WHERE id = '71'
  469. SELECT *
      FROM jos_menu
      WHERE id = '222'
  470. SELECT category_id      
      FROM jos_redshop_product_category_xref cx
      WHERE product_id = ''
  471. SELECT id
      FROM jos_menu
      WHERE `link` LIKE '%com_redshop%'
      AND `link` LIKE '%view=category%'
      AND (`link` LIKE '%id=216%'  OR `params` LIKE '%categoryid=216%')
      ORDER BY 'ordering'
  472. SELECT category_id AS value,category_name AS text
      FROM jos_redshop_category
      WHERE published = 1
  473. SELECT *
      FROM jos_menu
      WHERE id = '188'

Language Files Loaded

Untranslated Strings Diagnostic

None

Untranslated Strings Designer

None