Moods 2

Product Details

  • Type: Sidewall
  • Collection: Moods2
  • 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.29 MB
Application afterInitialise: 0.007 seconds, 0.96 MB
Application afterRoute: 0.015 seconds, 2.52 MB
Application afterDispatch: 6.044 seconds, 3.72 MB
Application afterRender: 6.062 seconds, 4.01 MB

Memory Usage

4231912

538 queries logged

  1. SELECT *
      FROM jos_session
      WHERE session_id = 'eo9r83gd5sptc5s3feqja38926'
  2. DELETE
      FROM jos_session
      WHERE ( time < '1748627304' )
  3. SELECT *
      FROM jos_session
      WHERE session_id = 'eo9r83gd5sptc5s3feqja38926'
  4. INSERT INTO `jos_session` ( `session_id`,`time`,`username`,`gid`,`guest`,`client_id` )
      VALUES ( 'eo9r83gd5sptc5s3feqja38926','1748634504','','0','1','0' )
  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-05-30'
  12. SELECT *
      FROM jos_redshop_siteviewer
      WHERE session_id = 'eo9r83gd5sptc5s3feqja38926'
  13. INSERT INTO jos_redshop_siteviewer (session_id, user_id, created_date)
      VALUES ('eo9r83gd5sptc5s3feqja38926', '0','1748634507')
  14. SELECT *
      FROM jos_redshop_pageviewer
      WHERE session_id = 'eo9r83gd5sptc5s3feqja38926'
      AND section='category'
      AND section_id=''
  15. INSERT INTO jos_redshop_pageviewer (session_id, user_id, section, section_id, created_date)
      VALUES ('eo9r83gd5sptc5s3feqja38926','0','category','','1748634510')
  16. SELECT sg.*
      FROM `jos_redshop_shopper_group` AS sg 
      WHERE  sg.`shopper_group_id` = 0
  17. SELECT template
      FROM jos_templates_menu
      WHERE client_id = 0
      AND (menuid = 0 OR menuid = 187)
      ORDER BY menuid DESC
      LIMIT 0, 1
  18. 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=136
      AND p.published = 1
      AND p.expired = 0
      AND p.product_parent_id = 0
      ORDER BY c.ordering ASC
  19. SELECT *
      FROM jos_redshop_category
      WHERE category_id = 136
  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=136
      AND t.published = 1
      ORDER BY c.ordering ASC
      LIMIT 0,1
  21. 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=136
      AND p.published = 1
      AND p.expired = 0
      AND p.product_parent_id = 0
      ORDER BY p.product_name ASC
      LIMIT 0, 200
  22. 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=136
      AND t.published = 1
      ORDER BY c.ordering ASC
      LIMIT 0,1
  23. SELECT *
      FROM jos_redshop_category
      WHERE category_id = 136
  24. SELECT *
      FROM jos_menu
      WHERE link LIKE '%com_redshop%'
      AND published=1
      AND id = '187'
  25. SELECT *
      FROM jos_menu
      WHERE link LIKE '%com_redshop%'
      AND published=1 
      AND link LIKE '%view=category%' 
      AND params NOT LIKE '%categoryid%'
  26. SELECT *
      FROM jos_menu
      WHERE link LIKE '%com_redshop%'
      AND published=1 
      AND link LIKE '%view=category%' 
      AND params  LIKE '%categoryid=136
    %'
  27. SELECT category_parent_id
      FROM jos_redshop_category_xref
      WHERE category_child_id=136
  28. SELECT *
      FROM jos_menu
      WHERE id = '187'
  29. SELECT sef_url,product_name,cat_in_sefurl
      FROM jos_redshop_product
      WHERE product_id = '6237'
  30. SELECT c.category_id
      FROM jos_redshop_category c,jos_redshop_product_category_xref pc
      WHERE pc.product_id = '6237'
      AND pc.category_id = c.category_id
  31. 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='136'
      AND c.category_id = cx.category_parent_id
  32. SELECT category_name
      FROM jos_redshop_category
      WHERE category_id = '136'
  33. SELECT
      FROM jos_redshop_product AS
      WHERE  p.product_id = 6237
  34. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 6237
      AND ps.stockroom_id = s.stockroom_id
  35. SELECT
      FROM jos_modules
      WHERE `module` LIKE 'mod_redmagicmagnifyplus'
      AND published  = 1
  36. SELECT *
      FROM jos_redshop_media 
      WHERE media_section = "product"
      AND section_id ="6237"
      AND media_type="images" 
      AND media_name = "1438580359_17300.jpg"
  37. SELECT *
      FROM jos_menu
      WHERE id = '187'
  38. SELECT sef_url,product_name,cat_in_sefurl
      FROM jos_redshop_product
      WHERE product_id = '6238'
  39. SELECT c.category_id
      FROM jos_redshop_category c,jos_redshop_product_category_xref pc
      WHERE pc.product_id = '6238'
      AND pc.category_id = c.category_id
  40. 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='136'
      AND c.category_id = cx.category_parent_id
  41. SELECT category_name
      FROM jos_redshop_category
      WHERE category_id = '136'
  42. SELECT
      FROM jos_redshop_product AS
      WHERE  p.product_id = 6238
  43. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 6238
      AND ps.stockroom_id = s.stockroom_id
  44. SELECT
      FROM jos_modules
      WHERE `module` LIKE 'mod_redmagicmagnifyplus'
      AND published  = 1
  45. SELECT *
      FROM jos_redshop_media 
      WHERE media_section = "product"
      AND section_id ="6238"
      AND media_type="images" 
      AND media_name = "1438580584_17301.jpg"
  46. SELECT *
      FROM jos_menu
      WHERE id = '187'
  47. SELECT sef_url,product_name,cat_in_sefurl
      FROM jos_redshop_product
      WHERE product_id = '6239'
  48. SELECT c.category_id
      FROM jos_redshop_category c,jos_redshop_product_category_xref pc
      WHERE pc.product_id = '6239'
      AND pc.category_id = c.category_id
  49. 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='136'
      AND c.category_id = cx.category_parent_id
  50. SELECT category_name
      FROM jos_redshop_category
      WHERE category_id = '136'
  51. SELECT
      FROM jos_redshop_product AS
      WHERE  p.product_id = 6239
  52. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 6239
      AND ps.stockroom_id = s.stockroom_id
  53. SELECT
      FROM jos_modules
      WHERE `module` LIKE 'mod_redmagicmagnifyplus'
      AND published  = 1
  54. SELECT *
      FROM jos_redshop_media 
      WHERE media_section = "product"
      AND section_id ="6239"
      AND media_type="images" 
      AND media_name = "1438580591_17302.jpg"
  55. SELECT *
      FROM jos_menu
      WHERE id = '187'
  56. SELECT sef_url,product_name,cat_in_sefurl
      FROM jos_redshop_product
      WHERE product_id = '6240'
  57. SELECT c.category_id
      FROM jos_redshop_category c,jos_redshop_product_category_xref pc
      WHERE pc.product_id = '6240'
      AND pc.category_id = c.category_id
  58. 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='136'
      AND c.category_id = cx.category_parent_id
  59. SELECT category_name
      FROM jos_redshop_category
      WHERE category_id = '136'
  60. SELECT
      FROM jos_redshop_product AS
      WHERE  p.product_id = 6240
  61. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 6240
      AND ps.stockroom_id = s.stockroom_id
  62. SELECT
      FROM jos_modules
      WHERE `module` LIKE 'mod_redmagicmagnifyplus'
      AND published  = 1
  63. SELECT *
      FROM jos_redshop_media 
      WHERE media_section = "product"
      AND section_id ="6240"
      AND media_type="images" 
      AND media_name = "1438580599_17303.jpg"
  64. SELECT *
      FROM jos_menu
      WHERE id = '187'
  65. SELECT sef_url,product_name,cat_in_sefurl
      FROM jos_redshop_product
      WHERE product_id = '6242'
  66. SELECT c.category_id
      FROM jos_redshop_category c,jos_redshop_product_category_xref pc
      WHERE pc.product_id = '6242'
      AND pc.category_id = c.category_id
  67. 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='136'
      AND c.category_id = cx.category_parent_id
  68. SELECT category_name
      FROM jos_redshop_category
      WHERE category_id = '136'
  69. SELECT
      FROM jos_redshop_product AS
      WHERE  p.product_id = 6242
  70. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 6242
      AND ps.stockroom_id = s.stockroom_id
  71. SELECT
      FROM jos_modules
      WHERE `module` LIKE 'mod_redmagicmagnifyplus'
      AND published  = 1
  72. SELECT *
      FROM jos_redshop_media 
      WHERE media_section = "product"
      AND section_id ="6242"
      AND media_type="images" 
      AND media_name = "1438580644_17304.jpg"
  73. SELECT *
      FROM jos_menu
      WHERE id = '187'
  74. SELECT sef_url,product_name,cat_in_sefurl
      FROM jos_redshop_product
      WHERE product_id = '6241'
  75. SELECT c.category_id
      FROM jos_redshop_category c,jos_redshop_product_category_xref pc
      WHERE pc.product_id = '6241'
      AND pc.category_id = c.category_id
  76. 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='136'
      AND c.category_id = cx.category_parent_id
  77. SELECT category_name
      FROM jos_redshop_category
      WHERE category_id = '136'
  78. SELECT
      FROM jos_redshop_product AS
      WHERE  p.product_id = 6241
  79. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 6241
      AND ps.stockroom_id = s.stockroom_id
  80. SELECT
      FROM jos_modules
      WHERE `module` LIKE 'mod_redmagicmagnifyplus'
      AND published  = 1
  81. SELECT *
      FROM jos_redshop_media 
      WHERE media_section = "product"
      AND section_id ="6241"
      AND media_type="images" 
      AND media_name = "1438580633_17305.jpg"
  82. SELECT *
      FROM jos_menu
      WHERE id = '187'
  83. SELECT sef_url,product_name,cat_in_sefurl
      FROM jos_redshop_product
      WHERE product_id = '6243'
  84. SELECT c.category_id
      FROM jos_redshop_category c,jos_redshop_product_category_xref pc
      WHERE pc.product_id = '6243'
      AND pc.category_id = c.category_id
  85. 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='136'
      AND c.category_id = cx.category_parent_id
  86. SELECT category_name
      FROM jos_redshop_category
      WHERE category_id = '136'
  87. SELECT
      FROM jos_redshop_product AS
      WHERE  p.product_id = 6243
  88. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 6243
      AND ps.stockroom_id = s.stockroom_id
  89. SELECT
      FROM jos_modules
      WHERE `module` LIKE 'mod_redmagicmagnifyplus'
      AND published  = 1
  90. SELECT *
      FROM jos_redshop_media 
      WHERE media_section = "product"
      AND section_id ="6243"
      AND media_type="images" 
      AND media_name = "1438580662_17306.jpg"
  91. SELECT *
      FROM jos_menu
      WHERE id = '187'
  92. SELECT sef_url,product_name,cat_in_sefurl
      FROM jos_redshop_product
      WHERE product_id = '6244'
  93. SELECT c.category_id
      FROM jos_redshop_category c,jos_redshop_product_category_xref pc
      WHERE pc.product_id = '6244'
      AND pc.category_id = c.category_id
  94. 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='136'
      AND c.category_id = cx.category_parent_id
  95. SELECT category_name
      FROM jos_redshop_category
      WHERE category_id = '136'
  96. SELECT
      FROM jos_redshop_product AS
      WHERE  p.product_id = 6244
  97. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 6244
      AND ps.stockroom_id = s.stockroom_id
  98. SELECT
      FROM jos_modules
      WHERE `module` LIKE 'mod_redmagicmagnifyplus'
      AND published  = 1
  99. SELECT *
      FROM jos_redshop_media 
      WHERE media_section = "product"
      AND section_id ="6244"
      AND media_type="images" 
      AND media_name = "1438580804_17307.jpg"
  100. SELECT *
      FROM jos_menu
      WHERE id = '187'
  101. SELECT sef_url,product_name,cat_in_sefurl
      FROM jos_redshop_product
      WHERE product_id = '6245'
  102. SELECT c.category_id
      FROM jos_redshop_category c,jos_redshop_product_category_xref pc
      WHERE pc.product_id = '6245'
      AND pc.category_id = c.category_id
  103. 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='136'
      AND c.category_id = cx.category_parent_id
  104. SELECT category_name
      FROM jos_redshop_category
      WHERE category_id = '136'
  105. SELECT
      FROM jos_redshop_product AS
      WHERE  p.product_id = 6245
  106. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 6245
      AND ps.stockroom_id = s.stockroom_id
  107. SELECT
      FROM jos_modules
      WHERE `module` LIKE 'mod_redmagicmagnifyplus'
      AND published  = 1
  108. SELECT *
      FROM jos_redshop_media 
      WHERE media_section = "product"
      AND section_id ="6245"
      AND media_type="images" 
      AND media_name = "1438580842_17310.jpg"
  109. SELECT *
      FROM jos_menu
      WHERE id = '187'
  110. SELECT sef_url,product_name,cat_in_sefurl
      FROM jos_redshop_product
      WHERE product_id = '6246'
  111. SELECT c.category_id
      FROM jos_redshop_category c,jos_redshop_product_category_xref pc
      WHERE pc.product_id = '6246'
      AND pc.category_id = c.category_id
  112. 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='136'
      AND c.category_id = cx.category_parent_id
  113. SELECT category_name
      FROM jos_redshop_category
      WHERE category_id = '136'
  114. SELECT
      FROM jos_redshop_product AS
      WHERE  p.product_id = 6246
  115. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 6246
      AND ps.stockroom_id = s.stockroom_id
  116. SELECT
      FROM jos_modules
      WHERE `module` LIKE 'mod_redmagicmagnifyplus'
      AND published  = 1
  117. SELECT *
      FROM jos_redshop_media 
      WHERE media_section = "product"
      AND section_id ="6246"
      AND media_type="images" 
      AND media_name = "1438580906_17311.jpg"
  118. SELECT *
      FROM jos_menu
      WHERE id = '187'
  119. SELECT sef_url,product_name,cat_in_sefurl
      FROM jos_redshop_product
      WHERE product_id = '6249'
  120. SELECT c.category_id
      FROM jos_redshop_category c,jos_redshop_product_category_xref pc
      WHERE pc.product_id = '6249'
      AND pc.category_id = c.category_id
  121. 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='136'
      AND c.category_id = cx.category_parent_id
  122. SELECT category_name
      FROM jos_redshop_category
      WHERE category_id = '136'
  123. SELECT
      FROM jos_redshop_product AS
      WHERE  p.product_id = 6249
  124. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 6249
      AND ps.stockroom_id = s.stockroom_id
  125. SELECT
      FROM jos_modules
      WHERE `module` LIKE 'mod_redmagicmagnifyplus'
      AND published  = 1
  126. SELECT *
      FROM jos_redshop_media 
      WHERE media_section = "product"
      AND section_id ="6249"
      AND media_type="images" 
      AND media_name = "1438581010_17312.jpg"
  127. SELECT *
      FROM jos_menu
      WHERE id = '187'
  128. SELECT sef_url,product_name,cat_in_sefurl
      FROM jos_redshop_product
      WHERE product_id = '6247'
  129. SELECT c.category_id
      FROM jos_redshop_category c,jos_redshop_product_category_xref pc
      WHERE pc.product_id = '6247'
      AND pc.category_id = c.category_id
  130. 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='136'
      AND c.category_id = cx.category_parent_id
  131. SELECT category_name
      FROM jos_redshop_category
      WHERE category_id = '136'
  132. SELECT
      FROM jos_redshop_product AS
      WHERE  p.product_id = 6247
  133. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 6247
      AND ps.stockroom_id = s.stockroom_id
  134. SELECT
      FROM jos_modules
      WHERE `module` LIKE 'mod_redmagicmagnifyplus'
      AND published  = 1
  135. SELECT *
      FROM jos_redshop_media 
      WHERE media_section = "product"
      AND section_id ="6247"
      AND media_type="images" 
      AND media_name = "1438580933_17313.jpg"
  136. SELECT *
      FROM jos_menu
      WHERE id = '187'
  137. SELECT sef_url,product_name,cat_in_sefurl
      FROM jos_redshop_product
      WHERE product_id = '6248'
  138. SELECT c.category_id
      FROM jos_redshop_category c,jos_redshop_product_category_xref pc
      WHERE pc.product_id = '6248'
      AND pc.category_id = c.category_id
  139. 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='136'
      AND c.category_id = cx.category_parent_id
  140. SELECT category_name
      FROM jos_redshop_category
      WHERE category_id = '136'
  141. SELECT
      FROM jos_redshop_product AS
      WHERE  p.product_id = 6248
  142. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 6248
      AND ps.stockroom_id = s.stockroom_id
  143. SELECT
      FROM jos_modules
      WHERE `module` LIKE 'mod_redmagicmagnifyplus'
      AND published  = 1
  144. SELECT *
      FROM jos_redshop_media 
      WHERE media_section = "product"
      AND section_id ="6248"
      AND media_type="images" 
      AND media_name = "1438580995_17314.jpg"
  145. SELECT *
      FROM jos_menu
      WHERE id = '187'
  146. SELECT sef_url,product_name,cat_in_sefurl
      FROM jos_redshop_product
      WHERE product_id = '6251'
  147. SELECT c.category_id
      FROM jos_redshop_category c,jos_redshop_product_category_xref pc
      WHERE pc.product_id = '6251'
      AND pc.category_id = c.category_id
  148. 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='136'
      AND c.category_id = cx.category_parent_id
  149. SELECT category_name
      FROM jos_redshop_category
      WHERE category_id = '136'
  150. SELECT
      FROM jos_redshop_product AS
      WHERE  p.product_id = 6251
  151. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 6251
      AND ps.stockroom_id = s.stockroom_id
  152. SELECT
      FROM jos_modules
      WHERE `module` LIKE 'mod_redmagicmagnifyplus'
      AND published  = 1
  153. SELECT *
      FROM jos_redshop_media 
      WHERE media_section = "product"
      AND section_id ="6251"
      AND media_type="images" 
      AND media_name = "1438581086_17315.jpg"
  154. SELECT *
      FROM jos_menu
      WHERE id = '187'
  155. SELECT sef_url,product_name,cat_in_sefurl
      FROM jos_redshop_product
      WHERE product_id = '6250'
  156. SELECT c.category_id
      FROM jos_redshop_category c,jos_redshop_product_category_xref pc
      WHERE pc.product_id = '6250'
      AND pc.category_id = c.category_id
  157. 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='136'
      AND c.category_id = cx.category_parent_id
  158. SELECT category_name
      FROM jos_redshop_category
      WHERE category_id = '136'
  159. SELECT
      FROM jos_redshop_product AS
      WHERE  p.product_id = 6250
  160. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 6250
      AND ps.stockroom_id = s.stockroom_id
  161. SELECT
      FROM jos_modules
      WHERE `module` LIKE 'mod_redmagicmagnifyplus'
      AND published  = 1
  162. SELECT *
      FROM jos_redshop_media 
      WHERE media_section = "product"
      AND section_id ="6250"
      AND media_type="images" 
      AND media_name = "1438581078_17316.jpg"
  163. SELECT *
      FROM jos_menu
      WHERE id = '187'
  164. SELECT sef_url,product_name,cat_in_sefurl
      FROM jos_redshop_product
      WHERE product_id = '6252'
  165. SELECT c.category_id
      FROM jos_redshop_category c,jos_redshop_product_category_xref pc
      WHERE pc.product_id = '6252'
      AND pc.category_id = c.category_id
  166. 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='136'
      AND c.category_id = cx.category_parent_id
  167. SELECT category_name
      FROM jos_redshop_category
      WHERE category_id = '136'
  168. SELECT
      FROM jos_redshop_product AS
      WHERE  p.product_id = 6252
  169. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 6252
      AND ps.stockroom_id = s.stockroom_id
  170. SELECT
      FROM jos_modules
      WHERE `module` LIKE 'mod_redmagicmagnifyplus'
      AND published  = 1
  171. SELECT *
      FROM jos_redshop_media 
      WHERE media_section = "product"
      AND section_id ="6252"
      AND media_type="images" 
      AND media_name = "1438581097_17320.jpg"
  172. SELECT *
      FROM jos_menu
      WHERE id = '187'
  173. SELECT sef_url,product_name,cat_in_sefurl
      FROM jos_redshop_product
      WHERE product_id = '6253'
  174. SELECT c.category_id
      FROM jos_redshop_category c,jos_redshop_product_category_xref pc
      WHERE pc.product_id = '6253'
      AND pc.category_id = c.category_id
  175. 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='136'
      AND c.category_id = cx.category_parent_id
  176. SELECT category_name
      FROM jos_redshop_category
      WHERE category_id = '136'
  177. SELECT
      FROM jos_redshop_product AS
      WHERE  p.product_id = 6253
  178. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 6253
      AND ps.stockroom_id = s.stockroom_id
  179. SELECT
      FROM jos_modules
      WHERE `module` LIKE 'mod_redmagicmagnifyplus'
      AND published  = 1
  180. SELECT *
      FROM jos_redshop_media 
      WHERE media_section = "product"
      AND section_id ="6253"
      AND media_type="images" 
      AND media_name = "1438581166_17321.jpg"
  181. SELECT *
      FROM jos_menu
      WHERE id = '187'
  182. SELECT sef_url,product_name,cat_in_sefurl
      FROM jos_redshop_product
      WHERE product_id = '6254'
  183. SELECT c.category_id
      FROM jos_redshop_category c,jos_redshop_product_category_xref pc
      WHERE pc.product_id = '6254'
      AND pc.category_id = c.category_id
  184. 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='136'
      AND c.category_id = cx.category_parent_id
  185. SELECT category_name
      FROM jos_redshop_category
      WHERE category_id = '136'
  186. SELECT
      FROM jos_redshop_product AS
      WHERE  p.product_id = 6254
  187. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 6254
      AND ps.stockroom_id = s.stockroom_id
  188. SELECT
      FROM jos_modules
      WHERE `module` LIKE 'mod_redmagicmagnifyplus'
      AND published  = 1
  189. SELECT *
      FROM jos_redshop_media 
      WHERE media_section = "product"
      AND section_id ="6254"
      AND media_type="images" 
      AND media_name = "1438581200_17322.jpg"
  190. SELECT *
      FROM jos_menu
      WHERE id = '187'
  191. SELECT sef_url,product_name,cat_in_sefurl
      FROM jos_redshop_product
      WHERE product_id = '6256'
  192. SELECT c.category_id
      FROM jos_redshop_category c,jos_redshop_product_category_xref pc
      WHERE pc.product_id = '6256'
      AND pc.category_id = c.category_id
  193. 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='136'
      AND c.category_id = cx.category_parent_id
  194. SELECT category_name
      FROM jos_redshop_category
      WHERE category_id = '136'
  195. SELECT
      FROM jos_redshop_product AS
      WHERE  p.product_id = 6256
  196. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 6256
      AND ps.stockroom_id = s.stockroom_id
  197. SELECT
      FROM jos_modules
      WHERE `module` LIKE 'mod_redmagicmagnifyplus'
      AND published  = 1
  198. SELECT *
      FROM jos_redshop_media 
      WHERE media_section = "product"
      AND section_id ="6256"
      AND media_type="images" 
      AND media_name = "1438581336_17323.jpg"
  199. SELECT *
      FROM jos_menu
      WHERE id = '187'
  200. SELECT sef_url,product_name,cat_in_sefurl
      FROM jos_redshop_product
      WHERE product_id = '6255'
  201. SELECT c.category_id
      FROM jos_redshop_category c,jos_redshop_product_category_xref pc
      WHERE pc.product_id = '6255'
      AND pc.category_id = c.category_id
  202. 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='136'
      AND c.category_id = cx.category_parent_id
  203. SELECT category_name
      FROM jos_redshop_category
      WHERE category_id = '136'
  204. SELECT
      FROM jos_redshop_product AS
      WHERE  p.product_id = 6255
  205. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 6255
      AND ps.stockroom_id = s.stockroom_id
  206. SELECT
      FROM jos_modules
      WHERE `module` LIKE 'mod_redmagicmagnifyplus'
      AND published  = 1
  207. SELECT *
      FROM jos_redshop_media 
      WHERE media_section = "product"
      AND section_id ="6255"
      AND media_type="images" 
      AND media_name = "1438581223_17324.jpg"
  208. SELECT *
      FROM jos_menu
      WHERE id = '187'
  209. SELECT sef_url,product_name,cat_in_sefurl
      FROM jos_redshop_product
      WHERE product_id = '6259'
  210. SELECT c.category_id
      FROM jos_redshop_category c,jos_redshop_product_category_xref pc
      WHERE pc.product_id = '6259'
      AND pc.category_id = c.category_id
  211. 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='136'
      AND c.category_id = cx.category_parent_id
  212. SELECT category_name
      FROM jos_redshop_category
      WHERE category_id = '136'
  213. SELECT
      FROM jos_redshop_product AS
      WHERE  p.product_id = 6259
  214. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 6259
      AND ps.stockroom_id = s.stockroom_id
  215. SELECT
      FROM jos_modules
      WHERE `module` LIKE 'mod_redmagicmagnifyplus'
      AND published  = 1
  216. SELECT *
      FROM jos_redshop_media 
      WHERE media_section = "product"
      AND section_id ="6259"
      AND media_type="images" 
      AND media_name = "1438581457_17325.jpg"
  217. SELECT *
      FROM jos_menu
      WHERE id = '187'
  218. SELECT sef_url,product_name,cat_in_sefurl
      FROM jos_redshop_product
      WHERE product_id = '6258'
  219. SELECT c.category_id
      FROM jos_redshop_category c,jos_redshop_product_category_xref pc
      WHERE pc.product_id = '6258'
      AND pc.category_id = c.category_id
  220. 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='136'
      AND c.category_id = cx.category_parent_id
  221. SELECT category_name
      FROM jos_redshop_category
      WHERE category_id = '136'
  222. SELECT
      FROM jos_redshop_product AS
      WHERE  p.product_id = 6258
  223. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 6258
      AND ps.stockroom_id = s.stockroom_id
  224. SELECT
      FROM jos_modules
      WHERE `module` LIKE 'mod_redmagicmagnifyplus'
      AND published  = 1
  225. SELECT *
      FROM jos_redshop_media 
      WHERE media_section = "product"
      AND section_id ="6258"
      AND media_type="images" 
      AND media_name = "1438581438_17326.jpg"
  226. SELECT *
      FROM jos_menu
      WHERE id = '187'
  227. SELECT sef_url,product_name,cat_in_sefurl
      FROM jos_redshop_product
      WHERE product_id = '6257'
  228. SELECT c.category_id
      FROM jos_redshop_category c,jos_redshop_product_category_xref pc
      WHERE pc.product_id = '6257'
      AND pc.category_id = c.category_id
  229. 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='136'
      AND c.category_id = cx.category_parent_id
  230. SELECT category_name
      FROM jos_redshop_category
      WHERE category_id = '136'
  231. SELECT
      FROM jos_redshop_product AS
      WHERE  p.product_id = 6257
  232. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 6257
      AND ps.stockroom_id = s.stockroom_id
  233. SELECT
      FROM jos_modules
      WHERE `module` LIKE 'mod_redmagicmagnifyplus'
      AND published  = 1
  234. SELECT *
      FROM jos_redshop_media 
      WHERE media_section = "product"
      AND section_id ="6257"
      AND media_type="images" 
      AND media_name = "1438581436_17327.jpg"
  235. SELECT *
      FROM jos_menu
      WHERE id = '187'
  236. SELECT sef_url,product_name,cat_in_sefurl
      FROM jos_redshop_product
      WHERE product_id = '6260'
  237. SELECT c.category_id
      FROM jos_redshop_category c,jos_redshop_product_category_xref pc
      WHERE pc.product_id = '6260'
      AND pc.category_id = c.category_id
  238. 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='136'
      AND c.category_id = cx.category_parent_id
  239. SELECT category_name
      FROM jos_redshop_category
      WHERE category_id = '136'
  240. SELECT
      FROM jos_redshop_product AS
      WHERE  p.product_id = 6260
  241. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 6260
      AND ps.stockroom_id = s.stockroom_id
  242. SELECT
      FROM jos_modules
      WHERE `module` LIKE 'mod_redmagicmagnifyplus'
      AND published  = 1
  243. SELECT *
      FROM jos_redshop_media 
      WHERE media_section = "product"
      AND section_id ="6260"
      AND media_type="images" 
      AND media_name = "1438581544_17328.jpg"
  244. SELECT *
      FROM jos_menu
      WHERE id = '187'
  245. SELECT sef_url,product_name,cat_in_sefurl
      FROM jos_redshop_product
      WHERE product_id = '6263'
  246. SELECT c.category_id
      FROM jos_redshop_category c,jos_redshop_product_category_xref pc
      WHERE pc.product_id = '6263'
      AND pc.category_id = c.category_id
  247. 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='136'
      AND c.category_id = cx.category_parent_id
  248. SELECT category_name
      FROM jos_redshop_category
      WHERE category_id = '136'
  249. SELECT
      FROM jos_redshop_product AS
      WHERE  p.product_id = 6263
  250. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 6263
      AND ps.stockroom_id = s.stockroom_id
  251. SELECT
      FROM jos_modules
      WHERE `module` LIKE 'mod_redmagicmagnifyplus'
      AND published  = 1
  252. SELECT *
      FROM jos_redshop_media 
      WHERE media_section = "product"
      AND section_id ="6263"
      AND media_type="images" 
      AND media_name = "1438581648_17330.jpg"
  253. SELECT *
      FROM jos_menu
      WHERE id = '187'
  254. SELECT sef_url,product_name,cat_in_sefurl
      FROM jos_redshop_product
      WHERE product_id = '6261'
  255. SELECT c.category_id
      FROM jos_redshop_category c,jos_redshop_product_category_xref pc
      WHERE pc.product_id = '6261'
      AND pc.category_id = c.category_id
  256. 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='136'
      AND c.category_id = cx.category_parent_id
  257. SELECT category_name
      FROM jos_redshop_category
      WHERE category_id = '136'
  258. SELECT
      FROM jos_redshop_product AS
      WHERE  p.product_id = 6261
  259. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 6261
      AND ps.stockroom_id = s.stockroom_id
  260. SELECT
      FROM jos_modules
      WHERE `module` LIKE 'mod_redmagicmagnifyplus'
      AND published  = 1
  261. SELECT *
      FROM jos_redshop_media 
      WHERE media_section = "product"
      AND section_id ="6261"
      AND media_type="images" 
      AND media_name = "1438581605_17331.jpg"
  262. SELECT *
      FROM jos_menu
      WHERE id = '187'
  263. SELECT sef_url,product_name,cat_in_sefurl
      FROM jos_redshop_product
      WHERE product_id = '6266'
  264. SELECT c.category_id
      FROM jos_redshop_category c,jos_redshop_product_category_xref pc
      WHERE pc.product_id = '6266'
      AND pc.category_id = c.category_id
  265. 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='136'
      AND c.category_id = cx.category_parent_id
  266. SELECT category_name
      FROM jos_redshop_category
      WHERE category_id = '136'
  267. SELECT
      FROM jos_redshop_product AS
      WHERE  p.product_id = 6266
  268. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 6266
      AND ps.stockroom_id = s.stockroom_id
  269. SELECT
      FROM jos_modules
      WHERE `module` LIKE 'mod_redmagicmagnifyplus'
      AND published  = 1
  270. SELECT *
      FROM jos_redshop_media 
      WHERE media_section = "product"
      AND section_id ="6266"
      AND media_type="images" 
      AND media_name = "1438581771_17332.jpg"
  271. SELECT *
      FROM jos_menu
      WHERE id = '187'
  272. SELECT sef_url,product_name,cat_in_sefurl
      FROM jos_redshop_product
      WHERE product_id = '6264'
  273. SELECT c.category_id
      FROM jos_redshop_category c,jos_redshop_product_category_xref pc
      WHERE pc.product_id = '6264'
      AND pc.category_id = c.category_id
  274. 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='136'
      AND c.category_id = cx.category_parent_id
  275. SELECT category_name
      FROM jos_redshop_category
      WHERE category_id = '136'
  276. SELECT
      FROM jos_redshop_product AS
      WHERE  p.product_id = 6264
  277. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 6264
      AND ps.stockroom_id = s.stockroom_id
  278. SELECT
      FROM jos_modules
      WHERE `module` LIKE 'mod_redmagicmagnifyplus'
      AND published  = 1
  279. SELECT *
      FROM jos_redshop_media 
      WHERE media_section = "product"
      AND section_id ="6264"
      AND media_type="images" 
      AND media_name = "1438581722_17333.jpg"
  280. SELECT *
      FROM jos_menu
      WHERE id = '187'
  281. SELECT sef_url,product_name,cat_in_sefurl
      FROM jos_redshop_product
      WHERE product_id = '6262'
  282. SELECT c.category_id
      FROM jos_redshop_category c,jos_redshop_product_category_xref pc
      WHERE pc.product_id = '6262'
      AND pc.category_id = c.category_id
  283. 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='136'
      AND c.category_id = cx.category_parent_id
  284. SELECT category_name
      FROM jos_redshop_category
      WHERE category_id = '136'
  285. SELECT
      FROM jos_redshop_product AS
      WHERE  p.product_id = 6262
  286. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 6262
      AND ps.stockroom_id = s.stockroom_id
  287. SELECT
      FROM jos_modules
      WHERE `module` LIKE 'mod_redmagicmagnifyplus'
      AND published  = 1
  288. SELECT *
      FROM jos_redshop_media 
      WHERE media_section = "product"
      AND section_id ="6262"
      AND media_type="images" 
      AND media_name = "1438581612_17334.jpg"
  289. SELECT *
      FROM jos_menu
      WHERE id = '187'
  290. SELECT sef_url,product_name,cat_in_sefurl
      FROM jos_redshop_product
      WHERE product_id = '6273'
  291. SELECT c.category_id
      FROM jos_redshop_category c,jos_redshop_product_category_xref pc
      WHERE pc.product_id = '6273'
      AND pc.category_id = c.category_id
  292. 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='136'
      AND c.category_id = cx.category_parent_id
  293. SELECT category_name
      FROM jos_redshop_category
      WHERE category_id = '136'
  294. SELECT
      FROM jos_redshop_product AS
      WHERE  p.product_id = 6273
  295. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 6273
      AND ps.stockroom_id = s.stockroom_id
  296. SELECT
      FROM jos_modules
      WHERE `module` LIKE 'mod_redmagicmagnifyplus'
      AND published  = 1
  297. SELECT *
      FROM jos_redshop_media 
      WHERE media_section = "product"
      AND section_id ="6273"
      AND media_type="images" 
      AND media_name = "1438582077_17335.jpg"
  298. SELECT *
      FROM jos_menu
      WHERE id = '187'
  299. SELECT sef_url,product_name,cat_in_sefurl
      FROM jos_redshop_product
      WHERE product_id = '6267'
  300. SELECT c.category_id
      FROM jos_redshop_category c,jos_redshop_product_category_xref pc
      WHERE pc.product_id = '6267'
      AND pc.category_id = c.category_id
  301. 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='136'
      AND c.category_id = cx.category_parent_id
  302. SELECT category_name
      FROM jos_redshop_category
      WHERE category_id = '136'
  303. SELECT
      FROM jos_redshop_product AS
      WHERE  p.product_id = 6267
  304. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 6267
      AND ps.stockroom_id = s.stockroom_id
  305. SELECT
      FROM jos_modules
      WHERE `module` LIKE 'mod_redmagicmagnifyplus'
      AND published  = 1
  306. SELECT *
      FROM jos_redshop_media 
      WHERE media_section = "product"
      AND section_id ="6267"
      AND media_type="images" 
      AND media_name = "1438581777_17336.jpg"
  307. SELECT *
      FROM jos_menu
      WHERE id = '187'
  308. SELECT sef_url,product_name,cat_in_sefurl
      FROM jos_redshop_product
      WHERE product_id = '6271'
  309. SELECT c.category_id
      FROM jos_redshop_category c,jos_redshop_product_category_xref pc
      WHERE pc.product_id = '6271'
      AND pc.category_id = c.category_id
  310. 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='136'
      AND c.category_id = cx.category_parent_id
  311. SELECT category_name
      FROM jos_redshop_category
      WHERE category_id = '136'
  312. SELECT
      FROM jos_redshop_product AS
      WHERE  p.product_id = 6271
  313. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 6271
      AND ps.stockroom_id = s.stockroom_id
  314. SELECT
      FROM jos_modules
      WHERE `module` LIKE 'mod_redmagicmagnifyplus'
      AND published  = 1
  315. SELECT *
      FROM jos_redshop_media 
      WHERE media_section = "product"
      AND section_id ="6271"
      AND media_type="images" 
      AND media_name = "1438581910_17337.jpg"
  316. SELECT *
      FROM jos_menu
      WHERE id = '187'
  317. SELECT sef_url,product_name,cat_in_sefurl
      FROM jos_redshop_product
      WHERE product_id = '6265'
  318. SELECT c.category_id
      FROM jos_redshop_category c,jos_redshop_product_category_xref pc
      WHERE pc.product_id = '6265'
      AND pc.category_id = c.category_id
  319. 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='136'
      AND c.category_id = cx.category_parent_id
  320. SELECT category_name
      FROM jos_redshop_category
      WHERE category_id = '136'
  321. SELECT
      FROM jos_redshop_product AS
      WHERE  p.product_id = 6265
  322. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 6265
      AND ps.stockroom_id = s.stockroom_id
  323. SELECT
      FROM jos_modules
      WHERE `module` LIKE 'mod_redmagicmagnifyplus'
      AND published  = 1
  324. SELECT *
      FROM jos_redshop_media 
      WHERE media_section = "product"
      AND section_id ="6265"
      AND media_type="images" 
      AND media_name = "1438581765_17338.jpg"
  325. SELECT *
      FROM jos_menu
      WHERE id = '187'
  326. SELECT sef_url,product_name,cat_in_sefurl
      FROM jos_redshop_product
      WHERE product_id = '6272'
  327. SELECT c.category_id
      FROM jos_redshop_category c,jos_redshop_product_category_xref pc
      WHERE pc.product_id = '6272'
      AND pc.category_id = c.category_id
  328. 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='136'
      AND c.category_id = cx.category_parent_id
  329. SELECT category_name
      FROM jos_redshop_category
      WHERE category_id = '136'
  330. SELECT
      FROM jos_redshop_product AS
      WHERE  p.product_id = 6272
  331. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 6272
      AND ps.stockroom_id = s.stockroom_id
  332. SELECT
      FROM jos_modules
      WHERE `module` LIKE 'mod_redmagicmagnifyplus'
      AND published  = 1
  333. SELECT *
      FROM jos_redshop_media 
      WHERE media_section = "product"
      AND section_id ="6272"
      AND media_type="images" 
      AND media_name = "1438581919_17340.jpg"
  334. SELECT *
      FROM jos_menu
      WHERE id = '187'
  335. SELECT sef_url,product_name,cat_in_sefurl
      FROM jos_redshop_product
      WHERE product_id = '6269'
  336. SELECT c.category_id
      FROM jos_redshop_category c,jos_redshop_product_category_xref pc
      WHERE pc.product_id = '6269'
      AND pc.category_id = c.category_id
  337. 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='136'
      AND c.category_id = cx.category_parent_id
  338. SELECT category_name
      FROM jos_redshop_category
      WHERE category_id = '136'
  339. SELECT
      FROM jos_redshop_product AS
      WHERE  p.product_id = 6269
  340. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 6269
      AND ps.stockroom_id = s.stockroom_id
  341. SELECT
      FROM jos_modules
      WHERE `module` LIKE 'mod_redmagicmagnifyplus'
      AND published  = 1
  342. SELECT *
      FROM jos_redshop_media 
      WHERE media_section = "product"
      AND section_id ="6269"
      AND media_type="images" 
      AND media_name = "1438581871_17341.jpg"
  343. SELECT *
      FROM jos_menu
      WHERE id = '187'
  344. SELECT sef_url,product_name,cat_in_sefurl
      FROM jos_redshop_product
      WHERE product_id = '6268'
  345. SELECT c.category_id
      FROM jos_redshop_category c,jos_redshop_product_category_xref pc
      WHERE pc.product_id = '6268'
      AND pc.category_id = c.category_id
  346. 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='136'
      AND c.category_id = cx.category_parent_id
  347. SELECT category_name
      FROM jos_redshop_category
      WHERE category_id = '136'
  348. SELECT
      FROM jos_redshop_product AS
      WHERE  p.product_id = 6268
  349. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 6268
      AND ps.stockroom_id = s.stockroom_id
  350. SELECT
      FROM jos_modules
      WHERE `module` LIKE 'mod_redmagicmagnifyplus'
      AND published  = 1
  351. SELECT *
      FROM jos_redshop_media 
      WHERE media_section = "product"
      AND section_id ="6268"
      AND media_type="images" 
      AND media_name = "1438581838_17342.jpg"
  352. SELECT *
      FROM jos_menu
      WHERE id = '187'
  353. SELECT sef_url,product_name,cat_in_sefurl
      FROM jos_redshop_product
      WHERE product_id = '6270'
  354. SELECT c.category_id
      FROM jos_redshop_category c,jos_redshop_product_category_xref pc
      WHERE pc.product_id = '6270'
      AND pc.category_id = c.category_id
  355. 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='136'
      AND c.category_id = cx.category_parent_id
  356. SELECT category_name
      FROM jos_redshop_category
      WHERE category_id = '136'
  357. SELECT
      FROM jos_redshop_product AS
      WHERE  p.product_id = 6270
  358. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 6270
      AND ps.stockroom_id = s.stockroom_id
  359. SELECT
      FROM jos_modules
      WHERE `module` LIKE 'mod_redmagicmagnifyplus'
      AND published  = 1
  360. SELECT *
      FROM jos_redshop_media 
      WHERE media_section = "product"
      AND section_id ="6270"
      AND media_type="images" 
      AND media_name = "1438581878_17343.jpg"
  361. SELECT *
      FROM jos_menu
      WHERE id = '187'
  362. SELECT sef_url,product_name,cat_in_sefurl
      FROM jos_redshop_product
      WHERE product_id = '6274'
  363. SELECT c.category_id
      FROM jos_redshop_category c,jos_redshop_product_category_xref pc
      WHERE pc.product_id = '6274'
      AND pc.category_id = c.category_id
  364. 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='136'
      AND c.category_id = cx.category_parent_id
  365. SELECT category_name
      FROM jos_redshop_category
      WHERE category_id = '136'
  366. SELECT
      FROM jos_redshop_product AS
      WHERE  p.product_id = 6274
  367. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 6274
      AND ps.stockroom_id = s.stockroom_id
  368. SELECT
      FROM jos_modules
      WHERE `module` LIKE 'mod_redmagicmagnifyplus'
      AND published  = 1
  369. SELECT *
      FROM jos_redshop_media 
      WHERE media_section = "product"
      AND section_id ="6274"
      AND media_type="images" 
      AND media_name = "1438582143_17344.jpg"
  370. SELECT *
      FROM jos_menu
      WHERE id = '187'
  371. SELECT sef_url,product_name,cat_in_sefurl
      FROM jos_redshop_product
      WHERE product_id = '6275'
  372. SELECT c.category_id
      FROM jos_redshop_category c,jos_redshop_product_category_xref pc
      WHERE pc.product_id = '6275'
      AND pc.category_id = c.category_id
  373. 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='136'
      AND c.category_id = cx.category_parent_id
  374. SELECT category_name
      FROM jos_redshop_category
      WHERE category_id = '136'
  375. SELECT
      FROM jos_redshop_product AS
      WHERE  p.product_id = 6275
  376. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 6275
      AND ps.stockroom_id = s.stockroom_id
  377. SELECT
      FROM jos_modules
      WHERE `module` LIKE 'mod_redmagicmagnifyplus'
      AND published  = 1
  378. SELECT *
      FROM jos_redshop_media 
      WHERE media_section = "product"
      AND section_id ="6275"
      AND media_type="images" 
      AND media_name = "1438582158_17350.jpg"
  379. SELECT *
      FROM jos_menu
      WHERE id = '187'
  380. SELECT sef_url,product_name,cat_in_sefurl
      FROM jos_redshop_product
      WHERE product_id = '6279'
  381. SELECT c.category_id
      FROM jos_redshop_category c,jos_redshop_product_category_xref pc
      WHERE pc.product_id = '6279'
      AND pc.category_id = c.category_id
  382. 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='136'
      AND c.category_id = cx.category_parent_id
  383. SELECT category_name
      FROM jos_redshop_category
      WHERE category_id = '136'
  384. SELECT
      FROM jos_redshop_product AS
      WHERE  p.product_id = 6279
  385. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 6279
      AND ps.stockroom_id = s.stockroom_id
  386. SELECT
      FROM jos_modules
      WHERE `module` LIKE 'mod_redmagicmagnifyplus'
      AND published  = 1
  387. SELECT *
      FROM jos_redshop_media 
      WHERE media_section = "product"
      AND section_id ="6279"
      AND media_type="images" 
      AND media_name = "1438582299_17351.jpg"
  388. SELECT *
      FROM jos_menu
      WHERE id = '187'
  389. SELECT sef_url,product_name,cat_in_sefurl
      FROM jos_redshop_product
      WHERE product_id = '6276'
  390. SELECT c.category_id
      FROM jos_redshop_category c,jos_redshop_product_category_xref pc
      WHERE pc.product_id = '6276'
      AND pc.category_id = c.category_id
  391. 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='136'
      AND c.category_id = cx.category_parent_id
  392. SELECT category_name
      FROM jos_redshop_category
      WHERE category_id = '136'
  393. SELECT
      FROM jos_redshop_product AS
      WHERE  p.product_id = 6276
  394. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 6276
      AND ps.stockroom_id = s.stockroom_id
  395. SELECT
      FROM jos_modules
      WHERE `module` LIKE 'mod_redmagicmagnifyplus'
      AND published  = 1
  396. SELECT *
      FROM jos_redshop_media 
      WHERE media_section = "product"
      AND section_id ="6276"
      AND media_type="images" 
      AND media_name = "1438582260_17352.jpg"
  397. SELECT *
      FROM jos_menu
      WHERE id = '187'
  398. SELECT sef_url,product_name,cat_in_sefurl
      FROM jos_redshop_product
      WHERE product_id = '6277'
  399. SELECT c.category_id
      FROM jos_redshop_category c,jos_redshop_product_category_xref pc
      WHERE pc.product_id = '6277'
      AND pc.category_id = c.category_id
  400. 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='136'
      AND c.category_id = cx.category_parent_id
  401. SELECT category_name
      FROM jos_redshop_category
      WHERE category_id = '136'
  402. SELECT
      FROM jos_redshop_product AS
      WHERE  p.product_id = 6277
  403. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 6277
      AND ps.stockroom_id = s.stockroom_id
  404. SELECT
      FROM jos_modules
      WHERE `module` LIKE 'mod_redmagicmagnifyplus'
      AND published  = 1
  405. SELECT *
      FROM jos_redshop_media 
      WHERE media_section = "product"
      AND section_id ="6277"
      AND media_type="images" 
      AND media_name = "1438582271_17353.jpg"
  406. SELECT *
      FROM jos_menu
      WHERE id = '187'
  407. SELECT sef_url,product_name,cat_in_sefurl
      FROM jos_redshop_product
      WHERE product_id = '6278'
  408. SELECT c.category_id
      FROM jos_redshop_category c,jos_redshop_product_category_xref pc
      WHERE pc.product_id = '6278'
      AND pc.category_id = c.category_id
  409. 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='136'
      AND c.category_id = cx.category_parent_id
  410. SELECT category_name
      FROM jos_redshop_category
      WHERE category_id = '136'
  411. SELECT
      FROM jos_redshop_product AS
      WHERE  p.product_id = 6278
  412. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 6278
      AND ps.stockroom_id = s.stockroom_id
  413. SELECT
      FROM jos_modules
      WHERE `module` LIKE 'mod_redmagicmagnifyplus'
      AND published  = 1
  414. SELECT *
      FROM jos_redshop_media 
      WHERE media_section = "product"
      AND section_id ="6278"
      AND media_type="images" 
      AND media_name = "1438582288_17360.jpg"
  415. SELECT *
      FROM jos_menu
      WHERE id = '187'
  416. SELECT sef_url,product_name,cat_in_sefurl
      FROM jos_redshop_product
      WHERE product_id = '6291'
  417. SELECT c.category_id
      FROM jos_redshop_category c,jos_redshop_product_category_xref pc
      WHERE pc.product_id = '6291'
      AND pc.category_id = c.category_id
  418. 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='136'
      AND c.category_id = cx.category_parent_id
  419. SELECT category_name
      FROM jos_redshop_category
      WHERE category_id = '136'
  420. SELECT
      FROM jos_redshop_product AS
      WHERE  p.product_id = 6291
  421. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 6291
      AND ps.stockroom_id = s.stockroom_id
  422. SELECT
      FROM jos_modules
      WHERE `module` LIKE 'mod_redmagicmagnifyplus'
      AND published  = 1
  423. SELECT *
      FROM jos_redshop_media 
      WHERE media_section = "product"
      AND section_id ="6291"
      AND media_type="images" 
      AND media_name = "1438582784_17361.jpg"
  424. SELECT *
      FROM jos_menu
      WHERE id = '187'
  425. SELECT sef_url,product_name,cat_in_sefurl
      FROM jos_redshop_product
      WHERE product_id = '6280'
  426. SELECT c.category_id
      FROM jos_redshop_category c,jos_redshop_product_category_xref pc
      WHERE pc.product_id = '6280'
      AND pc.category_id = c.category_id
  427. 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='136'
      AND c.category_id = cx.category_parent_id
  428. SELECT category_name
      FROM jos_redshop_category
      WHERE category_id = '136'
  429. SELECT
      FROM jos_redshop_product AS
      WHERE  p.product_id = 6280
  430. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 6280
      AND ps.stockroom_id = s.stockroom_id
  431. SELECT
      FROM jos_modules
      WHERE `module` LIKE 'mod_redmagicmagnifyplus'
      AND published  = 1
  432. SELECT *
      FROM jos_redshop_media 
      WHERE media_section = "product"
      AND section_id ="6280"
      AND media_type="images" 
      AND media_name = "1438582365_17362.jpg"
  433. SELECT *
      FROM jos_menu
      WHERE id = '187'
  434. SELECT sef_url,product_name,cat_in_sefurl
      FROM jos_redshop_product
      WHERE product_id = '6282'
  435. SELECT c.category_id
      FROM jos_redshop_category c,jos_redshop_product_category_xref pc
      WHERE pc.product_id = '6282'
      AND pc.category_id = c.category_id
  436. 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='136'
      AND c.category_id = cx.category_parent_id
  437. SELECT category_name
      FROM jos_redshop_category
      WHERE category_id = '136'
  438. SELECT
      FROM jos_redshop_product AS
      WHERE  p.product_id = 6282
  439. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 6282
      AND ps.stockroom_id = s.stockroom_id
  440. SELECT
      FROM jos_modules
      WHERE `module` LIKE 'mod_redmagicmagnifyplus'
      AND published  = 1
  441. SELECT *
      FROM jos_redshop_media 
      WHERE media_section = "product"
      AND section_id ="6282"
      AND media_type="images" 
      AND media_name = "1438582422_17363.jpg"
  442. SELECT *
      FROM jos_menu
      WHERE id = '187'
  443. SELECT sef_url,product_name,cat_in_sefurl
      FROM jos_redshop_product
      WHERE product_id = '6281'
  444. SELECT c.category_id
      FROM jos_redshop_category c,jos_redshop_product_category_xref pc
      WHERE pc.product_id = '6281'
      AND pc.category_id = c.category_id
  445. 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='136'
      AND c.category_id = cx.category_parent_id
  446. SELECT category_name
      FROM jos_redshop_category
      WHERE category_id = '136'
  447. SELECT
      FROM jos_redshop_product AS
      WHERE  p.product_id = 6281
  448. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 6281
      AND ps.stockroom_id = s.stockroom_id
  449. SELECT
      FROM jos_modules
      WHERE `module` LIKE 'mod_redmagicmagnifyplus'
      AND published  = 1
  450. SELECT *
      FROM jos_redshop_media 
      WHERE media_section = "product"
      AND section_id ="6281"
      AND media_type="images" 
      AND media_name = "1438582402_17364.jpg"
  451. SELECT *
      FROM jos_menu
      WHERE id = '187'
  452. SELECT sef_url,product_name,cat_in_sefurl
      FROM jos_redshop_product
      WHERE product_id = '6288'
  453. SELECT c.category_id
      FROM jos_redshop_category c,jos_redshop_product_category_xref pc
      WHERE pc.product_id = '6288'
      AND pc.category_id = c.category_id
  454. 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='136'
      AND c.category_id = cx.category_parent_id
  455. SELECT category_name
      FROM jos_redshop_category
      WHERE category_id = '136'
  456. SELECT
      FROM jos_redshop_product AS
      WHERE  p.product_id = 6288
  457. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 6288
      AND ps.stockroom_id = s.stockroom_id
  458. SELECT
      FROM jos_modules
      WHERE `module` LIKE 'mod_redmagicmagnifyplus'
      AND published  = 1
  459. SELECT *
      FROM jos_redshop_media 
      WHERE media_section = "product"
      AND section_id ="6288"
      AND media_type="images" 
      AND media_name = "1438582584_17365.jpg"
  460. SELECT *
      FROM jos_menu
      WHERE id = '187'
  461. SELECT sef_url,product_name,cat_in_sefurl
      FROM jos_redshop_product
      WHERE product_id = '6283'
  462. SELECT c.category_id
      FROM jos_redshop_category c,jos_redshop_product_category_xref pc
      WHERE pc.product_id = '6283'
      AND pc.category_id = c.category_id
  463. 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='136'
      AND c.category_id = cx.category_parent_id
  464. SELECT category_name
      FROM jos_redshop_category
      WHERE category_id = '136'
  465. SELECT
      FROM jos_redshop_product AS
      WHERE  p.product_id = 6283
  466. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 6283
      AND ps.stockroom_id = s.stockroom_id
  467. SELECT
      FROM jos_modules
      WHERE `module` LIKE 'mod_redmagicmagnifyplus'
      AND published  = 1
  468. SELECT *
      FROM jos_redshop_media 
      WHERE media_section = "product"
      AND section_id ="6283"
      AND media_type="images" 
      AND media_name = "1438582471_17366.jpg"
  469. SELECT *
      FROM jos_menu
      WHERE id = '187'
  470. SELECT sef_url,product_name,cat_in_sefurl
      FROM jos_redshop_product
      WHERE product_id = '6292'
  471. SELECT c.category_id
      FROM jos_redshop_category c,jos_redshop_product_category_xref pc
      WHERE pc.product_id = '6292'
      AND pc.category_id = c.category_id
  472. 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='136'
      AND c.category_id = cx.category_parent_id
  473. SELECT category_name
      FROM jos_redshop_category
      WHERE category_id = '136'
  474. SELECT
      FROM jos_redshop_product AS
      WHERE  p.product_id = 6292
  475. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 6292
      AND ps.stockroom_id = s.stockroom_id
  476. SELECT
      FROM jos_modules
      WHERE `module` LIKE 'mod_redmagicmagnifyplus'
      AND published  = 1
  477. SELECT *
      FROM jos_redshop_media 
      WHERE media_section = "product"
      AND section_id ="6292"
      AND media_type="images" 
      AND media_name = "1438582829_17367.jpg"
  478. SELECT *
      FROM jos_menu
      WHERE id = '187'
  479. SELECT sef_url,product_name,cat_in_sefurl
      FROM jos_redshop_product
      WHERE product_id = '6284'
  480. SELECT c.category_id
      FROM jos_redshop_category c,jos_redshop_product_category_xref pc
      WHERE pc.product_id = '6284'
      AND pc.category_id = c.category_id
  481. 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='136'
      AND c.category_id = cx.category_parent_id
  482. SELECT category_name
      FROM jos_redshop_category
      WHERE category_id = '136'
  483. SELECT
      FROM jos_redshop_product AS
      WHERE  p.product_id = 6284
  484. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 6284
      AND ps.stockroom_id = s.stockroom_id
  485. SELECT
      FROM jos_modules
      WHERE `module` LIKE 'mod_redmagicmagnifyplus'
      AND published  = 1
  486. SELECT *
      FROM jos_redshop_media 
      WHERE media_section = "product"
      AND section_id ="6284"
      AND media_type="images" 
      AND media_name = "1438582510_17368.jpg"
  487. SELECT *
      FROM jos_menu
      WHERE id = '187'
  488. SELECT sef_url,product_name,cat_in_sefurl
      FROM jos_redshop_product
      WHERE product_id = '6286'
  489. SELECT c.category_id
      FROM jos_redshop_category c,jos_redshop_product_category_xref pc
      WHERE pc.product_id = '6286'
      AND pc.category_id = c.category_id
  490. 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='136'
      AND c.category_id = cx.category_parent_id
  491. SELECT category_name
      FROM jos_redshop_category
      WHERE category_id = '136'
  492. SELECT
      FROM jos_redshop_product AS
      WHERE  p.product_id = 6286
  493. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 6286
      AND ps.stockroom_id = s.stockroom_id
  494. SELECT
      FROM jos_modules
      WHERE `module` LIKE 'mod_redmagicmagnifyplus'
      AND published  = 1
  495. SELECT *
      FROM jos_redshop_media 
      WHERE media_section = "product"
      AND section_id ="6286"
      AND media_type="images" 
      AND media_name = "1438582539_17369.jpg"
  496. SELECT *
      FROM jos_menu
      WHERE id = '187'
  497. SELECT sef_url,product_name,cat_in_sefurl
      FROM jos_redshop_product
      WHERE product_id = '6285'
  498. SELECT c.category_id
      FROM jos_redshop_category c,jos_redshop_product_category_xref pc
      WHERE pc.product_id = '6285'
      AND pc.category_id = c.category_id
  499. 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='136'
      AND c.category_id = cx.category_parent_id
  500. SELECT category_name
      FROM jos_redshop_category
      WHERE category_id = '136'
  501. SELECT
      FROM jos_redshop_product AS
      WHERE  p.product_id = 6285
  502. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 6285
      AND ps.stockroom_id = s.stockroom_id
  503. SELECT
      FROM jos_modules
      WHERE `module` LIKE 'mod_redmagicmagnifyplus'
      AND published  = 1
  504. SELECT *
      FROM jos_redshop_media 
      WHERE media_section = "product"
      AND section_id ="6285"
      AND media_type="images" 
      AND media_name = "1438582516_17370.jpg"
  505. SELECT *
      FROM jos_menu
      WHERE id = '187'
  506. SELECT sef_url,product_name,cat_in_sefurl
      FROM jos_redshop_product
      WHERE product_id = '6287'
  507. SELECT c.category_id
      FROM jos_redshop_category c,jos_redshop_product_category_xref pc
      WHERE pc.product_id = '6287'
      AND pc.category_id = c.category_id
  508. 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='136'
      AND c.category_id = cx.category_parent_id
  509. SELECT category_name
      FROM jos_redshop_category
      WHERE category_id = '136'
  510. SELECT
      FROM jos_redshop_product AS
      WHERE  p.product_id = 6287
  511. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 6287
      AND ps.stockroom_id = s.stockroom_id
  512. SELECT
      FROM jos_modules
      WHERE `module` LIKE 'mod_redmagicmagnifyplus'
      AND published  = 1
  513. SELECT *
      FROM jos_redshop_media 
      WHERE media_section = "product"
      AND section_id ="6287"
      AND media_type="images" 
      AND media_name = "1438582574_17371.jpg"
  514. SELECT *
      FROM jos_menu
      WHERE id = '187'
  515. SELECT sef_url,product_name,cat_in_sefurl
      FROM jos_redshop_product
      WHERE product_id = '6289'
  516. SELECT c.category_id
      FROM jos_redshop_category c,jos_redshop_product_category_xref pc
      WHERE pc.product_id = '6289'
      AND pc.category_id = c.category_id 
      AND c.category_id = '95'
  517. 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=''
      AND c.category_id = cx.category_parent_id
  518. SELECT category_name
      FROM jos_redshop_category
      WHERE category_id = ''
  519. SELECT
      FROM jos_redshop_product AS
      WHERE  p.product_id = 6289
  520. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 6289
      AND ps.stockroom_id = s.stockroom_id
  521. SELECT
      FROM jos_modules
      WHERE `module` LIKE 'mod_redmagicmagnifyplus'
      AND published  = 1
  522. SELECT *
      FROM jos_redshop_media 
      WHERE media_section = "product"
      AND section_id ="6289"
      AND media_type="images" 
      AND media_name = "1438582734_17372.jpg"
  523. SELECT *
      FROM jos_menu
      WHERE id = '187'
  524. SELECT sef_url,product_name,cat_in_sefurl
      FROM jos_redshop_product
      WHERE product_id = '6290'
  525. SELECT c.category_id
      FROM jos_redshop_category c,jos_redshop_product_category_xref pc
      WHERE pc.product_id = '6290'
      AND pc.category_id = c.category_id
  526. 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='136'
      AND c.category_id = cx.category_parent_id
  527. SELECT category_name
      FROM jos_redshop_category
      WHERE category_id = '136'
  528. SELECT
      FROM jos_redshop_product AS
      WHERE  p.product_id = 6290
  529. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 6290
      AND ps.stockroom_id = s.stockroom_id
  530. SELECT
      FROM jos_modules
      WHERE `module` LIKE 'mod_redmagicmagnifyplus'
      AND published  = 1
  531. SELECT *
      FROM jos_redshop_media 
      WHERE media_section = "product"
      AND section_id ="6290"
      AND media_type="images" 
      AND media_name = "1438582779_17373.jpg"
  532. 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 = 187 OR mm.menuid = 0 )
      ORDER BY position, ordering
  533. SELECT *
      FROM jos_menu
      WHERE id = '71'
  534. SELECT *
      FROM jos_menu
      WHERE id = '222'
  535. SELECT category_id      
      FROM jos_redshop_product_category_xref cx
      WHERE product_id = ''
  536. 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'
  537. SELECT category_id AS value,category_name AS text
      FROM jos_redshop_category
      WHERE published = 1
  538. SELECT *
      FROM jos_menu
      WHERE id = '187'

Language Files Loaded

Untranslated Strings Diagnostic

None

Untranslated Strings Designer

None