Elle Decoration 2 Collection

 

Elle Decoration -- „More Beauty 2“

 

 

Wallpapers with passion! This is also true of the 2nd wallpaper collection from ELLE DECORATION. Under the motto 'More Beauty 2', she again presents wallpaper designs and inspiration of the highest level — elegant, modern, stylish.

 
The second Elle Decoration collection comprises a total of five expressive designs for stylish living spaces. In addition to luxurious motifs with breathtaking gloss effects, this collection also features natural themes from extroverted to poetic translucency. The interplay of matt and glossy elements underlines the exclusive character of these high-end wallpapers.
 
Attractive plain structures complement the style worlds: three new fresh colours in Aqua, Light Jade and Ecru expand the already wide range of sensual colours in the collection.

Product Details

  • Type: Sidewall
  • Collection: Elle Decoration 2
  • Features: paste the wall
  • Roll Dimensions (D/Roll): 33’ 0” x 21” (10m x 53 cm)

Wallcoverings are packaged and sold in double rolls only

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

Elle Decoration 2

 

Order By :

Profile Information

Application afterLoad: 0.000 seconds, 0.29 MB
Application afterInitialise: 0.005 seconds, 0.96 MB
Application afterRoute: 0.010 seconds, 2.52 MB
Application afterDispatch: 11.623 seconds, 14.80 MB
Application afterRender: 11.637 seconds, 15.79 MB

Memory Usage

16586704

28410 queries logged

  1. DELETE
      FROM jos_session
      WHERE ( time < '1739785486' )
  2. SELECT *
      FROM jos_session
      WHERE session_id = 'd5q46q5548oi0r5eop58pjdr60'
  3. INSERT INTO `jos_session` ( `session_id`,`time`,`username`,`gid`,`guest`,`client_id` )
      VALUES ( 'd5q46q5548oi0r5eop58pjdr60','1739792686','','0','1','0' )
  4. SELECT *
      FROM jos_components
      WHERE parent = 0
  5. SELECT folder AS type, element AS name, params
      FROM jos_plugins
      WHERE published >= 1
      AND access <= 0
      ORDER BY ordering
  6. 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
  7. SELECT *
      FROM jos_redshop_configuration
  8. SELECT *
      FROM jos_redshop_catalog_request
      WHERE block = 0
  9. SELECT *
      FROM jos_redshop_sample_request
      WHERE block = 0
  10. SELECT count(id)
      FROM jos_redshop_cron
      WHERE date = '2025-02-17'
  11. SELECT *
      FROM jos_redshop_siteviewer
      WHERE session_id = 'd5q46q5548oi0r5eop58pjdr60'
  12. INSERT INTO jos_redshop_siteviewer (session_id, user_id, created_date)
      VALUES ('d5q46q5548oi0r5eop58pjdr60', '0','1739792687')
  13. SELECT *
      FROM jos_redshop_pageviewer
      WHERE session_id = 'd5q46q5548oi0r5eop58pjdr60'
      AND section='manufacturers'
      AND section_id='11'
  14. INSERT INTO jos_redshop_pageviewer (session_id, user_id, section, section_id, created_date)
      VALUES ('d5q46q5548oi0r5eop58pjdr60','0','manufacturers','11','1739792688')
  15. SELECT sg.*
      FROM `jos_redshop_shopper_group` AS sg 
      WHERE  sg.`shopper_group_id` = 0
  16. SELECT template
      FROM jos_templates_menu
      WHERE client_id = 0
      AND (menuid = 0 OR menuid = 283)
      ORDER BY menuid DESC
      LIMIT 0, 1
  17. SELECT mn.*, m.media_name,m.section_id
      FROM  jos_redshop_manufacturer AS mn
      LEFT JOIN jos_redshop_media AS m
      ON m.section_id=mn.manufacturer_id
      AND m.published = 1
      AND m.media_section='manufacturer'
      WHERE mn.published = 1 
      AND mn.manufacturer_id='11'
  18. SELECT *
      FROM jos_menu
      WHERE link LIKE '%com_redshop%'
      AND published=1
      AND id = '283'
  19. SELECT *
      FROM jos_menu
      WHERE link LIKE '%com_redshop%'
      AND published=1 
      AND link LIKE '%view=manufacturers%' 
      AND params  LIKE '%manufacturerid=11
    %'
  20. SELECT *
      FROM jos_redshop_manufacturer
      WHERE manufacturer_id = 11
  21. SELECT *
      FROM  jos_redshop_manufacturer
      WHERE published = 1
  22. SELECT DISTINCT(p.product_id),p.product_number,p.product_name,p.product_price,p.product_s_desc,p.product_thumb_image,p.product_full_image , c.category_name
      FROM jos_redshop_product AS p , jos_redshop_manufacturer AS m , jos_redshop_category AS c , jos_redshop_product_category_xref AS pc
      WHERE p.published=1
      AND p.manufacturer_id=11
      AND p.manufacturer_id=m.manufacturer_id 
      AND p.product_id = pc.product_id 
      AND p.expired = 0 
      AND p.product_parent_id = 0 
      AND pc.category_id = c.category_id 
      GROUP BY p.product_id   
      ORDER BY p.product_id DESC
  23. SELECT *
      FROM jos_redshop_template
      WHERE template_section LIKE 'manufacturer_products'
      AND published=1
      AND template_id='14'
      LIMIT 0,1
  24. SELECT category_id AS value, category_name AS text
      FROM jos_redshop_category
      WHERE published = '1'
      ORDER BY category_name ASC
  25. SELECT DISTINCT(p.product_id),p.product_number,p.product_name,p.product_price,p.product_s_desc,p.product_thumb_image,p.product_full_image , c.category_name
      FROM jos_redshop_product AS p , jos_redshop_manufacturer AS m , jos_redshop_category AS c , jos_redshop_product_category_xref AS pc
      WHERE p.published=1
      AND p.manufacturer_id=11
      AND p.manufacturer_id=m.manufacturer_id 
      AND p.product_id = pc.product_id 
      AND p.expired = 0 
      AND p.product_parent_id = 0 
      AND pc.category_id = c.category_id 
      GROUP BY p.product_id   
      ORDER BY p.product_id DESC
  26. SELECT *
      FROM jos_menu
      WHERE id = '283'
  27. SELECT sef_url,product_name,cat_in_sefurl
      FROM jos_redshop_product
      WHERE product_id = '18303'
  28. SELECT c.category_id
      FROM jos_redshop_category c,jos_redshop_product_category_xref pc
      WHERE pc.product_id = '18303'
      AND pc.category_id = c.category_id 
      AND c.category_id = '276'
  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='276'
      AND c.category_id = cx.category_parent_id
  30. SELECT category_name
      FROM jos_redshop_category
      WHERE category_id = '276'
  31. SELECT p.* 
      FROM jos_redshop_product AS p   
      WHERE  p.product_id = 18303
  32. SELECT p.price_id,p.product_price,p.product_currency 
      FROM jos_redshop_product_price AS
      WHERE  p.product_id = 18303
      AND p.shopper_group_id = '0' 
      AND ( p.price_quantity_start <= '1'
      AND p.price_quantity_end >= '1' ) 
      ORDER BY price_quantity_start ASC
      LIMIT 0,1
  33. SELECT *
      FROM jos_redshop_discount_product_shoppers AS ps
      WHERE ps.shopper_group_id ='0'
  34. SELECT *
      FROM jos_redshop_discount_product 
      WHERE amount <= 0
      AND discount_product_id IN (0) 
      AND published =1
      AND start_date <= '1739792688'
      AND end_date >= '1739792688' 
      ORDER BY amount DESC
      LIMIT 0,1
  35. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 18303
  36. SELECT sg.*
     
      FROM jos_redshop_shopper_group AS sg
     
      LEFT JOIN jos_redshop_users_info AS ui
      ON ui.shopper_group_id = sg.shopper_group_id
      WHERE ui.user_id = '0'
      LIMIT 0,1
  37. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 18303
  38. SELECT tr.*
      FROM jos_redshop_tax_rate AS tr
      WHERE tr.tax_group_id = 1
      AND tr.tax_country="CAN"
      AND tr.tax_state = "ON"  
      ORDER BY `tax_rate` DESC
  39. SELECT sh.tax_exempt AS shopper_tax_exempt,sh.*,u.*
      FROM jos_redshop_users_info AS u
      LEFT JOIN jos_redshop_shopper_group AS sh
      ON sh.shopper_group_id=u.shopper_group_id
      WHERE u.user_id='0'
      AND u.address_type='BT'
  40. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 18303
  41. SELECT sg.*
     
      FROM jos_redshop_shopper_group AS sg
     
      LEFT JOIN jos_redshop_users_info AS ui
      ON ui.shopper_group_id = sg.shopper_group_id
      WHERE ui.user_id = '0'
      LIMIT 0,1
  42. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 18303
  43. SELECT tr.*
      FROM jos_redshop_tax_rate AS tr
      WHERE tr.tax_group_id = 1
      AND tr.tax_country="CAN"
      AND tr.tax_state = "ON"  
      ORDER BY `tax_rate` DESC
  44. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 18303
      AND ps.stockroom_id = s.stockroom_id
  45. SELECT p.* 
      FROM jos_redshop_product_price AS
      WHERE  p.product_id = 18303
      AND p.shopper_group_id = '0' 
      ORDER BY price_quantity_start ASC
  46. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 18303
      AND discount_enddate>='1739792688'
      AND discount_stratdate<='1739792688'
  47. SELECT
      FROM jos_redshop_product AS
      WHERE  p.product_id = 18303
  48. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 18303
      AND ps.stockroom_id = s.stockroom_id
  49. SELECT
      FROM jos_modules
      WHERE `module` LIKE 'mod_redmagicmagnifyplus'
      AND published  = 1
  50. SELECT *
      FROM jos_redshop_media 
      WHERE media_section = "product"
      AND section_id ="18303"
      AND media_type="images" 
      AND media_name = "fashionforwalls4/2557N-72_scan_fashionforwalls4.jpg"
  51. SELECT *
      FROM jos_menu
      WHERE id = '283'
  52. SELECT sef_url,product_name,cat_in_sefurl
      FROM jos_redshop_product
      WHERE product_id = '18302'
  53. SELECT c.category_id
      FROM jos_redshop_category c,jos_redshop_product_category_xref pc
      WHERE pc.product_id = '18302'
      AND pc.category_id = c.category_id 
      AND c.category_id = '276'
  54. 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='276'
      AND c.category_id = cx.category_parent_id
  55. SELECT category_name
      FROM jos_redshop_category
      WHERE category_id = '276'
  56. SELECT p.* 
      FROM jos_redshop_product AS p   
      WHERE  p.product_id = 18302
  57. SELECT p.price_id,p.product_price,p.product_currency 
      FROM jos_redshop_product_price AS
      WHERE  p.product_id = 18302
      AND p.shopper_group_id = '0' 
      AND ( p.price_quantity_start <= '1'
      AND p.price_quantity_end >= '1' ) 
      ORDER BY price_quantity_start ASC
      LIMIT 0,1
  58. SELECT *
      FROM jos_redshop_discount_product_shoppers AS ps
      WHERE ps.shopper_group_id ='0'
  59. SELECT *
      FROM jos_redshop_discount_product 
      WHERE amount <= 0
      AND discount_product_id IN (0) 
      AND published =1
      AND start_date <= '1739792688'
      AND end_date >= '1739792688' 
      ORDER BY amount DESC
      LIMIT 0,1
  60. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 18302
  61. SELECT sg.*
     
      FROM jos_redshop_shopper_group AS sg
     
      LEFT JOIN jos_redshop_users_info AS ui
      ON ui.shopper_group_id = sg.shopper_group_id
      WHERE ui.user_id = '0'
      LIMIT 0,1
  62. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 18302
  63. SELECT tr.*
      FROM jos_redshop_tax_rate AS tr
      WHERE tr.tax_group_id = 1
      AND tr.tax_country="CAN"
      AND tr.tax_state = "ON"  
      ORDER BY `tax_rate` DESC
  64. SELECT sh.tax_exempt AS shopper_tax_exempt,sh.*,u.*
      FROM jos_redshop_users_info AS u
      LEFT JOIN jos_redshop_shopper_group AS sh
      ON sh.shopper_group_id=u.shopper_group_id
      WHERE u.user_id='0'
      AND u.address_type='BT'
  65. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 18302
  66. SELECT sg.*
     
      FROM jos_redshop_shopper_group AS sg
     
      LEFT JOIN jos_redshop_users_info AS ui
      ON ui.shopper_group_id = sg.shopper_group_id
      WHERE ui.user_id = '0'
      LIMIT 0,1
  67. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 18302
  68. SELECT tr.*
      FROM jos_redshop_tax_rate AS tr
      WHERE tr.tax_group_id = 1
      AND tr.tax_country="CAN"
      AND tr.tax_state = "ON"  
      ORDER BY `tax_rate` DESC
  69. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 18302
      AND ps.stockroom_id = s.stockroom_id
  70. SELECT p.* 
      FROM jos_redshop_product_price AS
      WHERE  p.product_id = 18302
      AND p.shopper_group_id = '0' 
      ORDER BY price_quantity_start ASC
  71. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 18302
      AND discount_enddate>='1739792688'
      AND discount_stratdate<='1739792688'
  72. SELECT
      FROM jos_redshop_product AS
      WHERE  p.product_id = 18302
  73. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 18302
      AND ps.stockroom_id = s.stockroom_id
  74. SELECT
      FROM jos_modules
      WHERE `module` LIKE 'mod_redmagicmagnifyplus'
      AND published  = 1
  75. SELECT *
      FROM jos_redshop_media 
      WHERE media_section = "product"
      AND section_id ="18302"
      AND media_type="images" 
      AND media_name = "fashionforwalls4/2557N-71_scan_fashionforwalls4.jpg"
  76. SELECT *
      FROM jos_menu
      WHERE id = '283'
  77. SELECT sef_url,product_name,cat_in_sefurl
      FROM jos_redshop_product
      WHERE product_id = '18301'
  78. SELECT c.category_id
      FROM jos_redshop_category c,jos_redshop_product_category_xref pc
      WHERE pc.product_id = '18301'
      AND pc.category_id = c.category_id 
      AND c.category_id = '276'
  79. 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='276'
      AND c.category_id = cx.category_parent_id
  80. SELECT category_name
      FROM jos_redshop_category
      WHERE category_id = '276'
  81. SELECT p.* 
      FROM jos_redshop_product AS p   
      WHERE  p.product_id = 18301
  82. SELECT p.price_id,p.product_price,p.product_currency 
      FROM jos_redshop_product_price AS
      WHERE  p.product_id = 18301
      AND p.shopper_group_id = '0' 
      AND ( p.price_quantity_start <= '1'
      AND p.price_quantity_end >= '1' ) 
      ORDER BY price_quantity_start ASC
      LIMIT 0,1
  83. SELECT *
      FROM jos_redshop_discount_product_shoppers AS ps
      WHERE ps.shopper_group_id ='0'
  84. SELECT *
      FROM jos_redshop_discount_product 
      WHERE amount <= 0
      AND discount_product_id IN (0) 
      AND published =1
      AND start_date <= '1739792688'
      AND end_date >= '1739792688' 
      ORDER BY amount DESC
      LIMIT 0,1
  85. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 18301
  86. SELECT sg.*
     
      FROM jos_redshop_shopper_group AS sg
     
      LEFT JOIN jos_redshop_users_info AS ui
      ON ui.shopper_group_id = sg.shopper_group_id
      WHERE ui.user_id = '0'
      LIMIT 0,1
  87. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 18301
  88. SELECT tr.*
      FROM jos_redshop_tax_rate AS tr
      WHERE tr.tax_group_id = 1
      AND tr.tax_country="CAN"
      AND tr.tax_state = "ON"  
      ORDER BY `tax_rate` DESC
  89. SELECT sh.tax_exempt AS shopper_tax_exempt,sh.*,u.*
      FROM jos_redshop_users_info AS u
      LEFT JOIN jos_redshop_shopper_group AS sh
      ON sh.shopper_group_id=u.shopper_group_id
      WHERE u.user_id='0'
      AND u.address_type='BT'
  90. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 18301
  91. SELECT sg.*
     
      FROM jos_redshop_shopper_group AS sg
     
      LEFT JOIN jos_redshop_users_info AS ui
      ON ui.shopper_group_id = sg.shopper_group_id
      WHERE ui.user_id = '0'
      LIMIT 0,1
  92. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 18301
  93. SELECT tr.*
      FROM jos_redshop_tax_rate AS tr
      WHERE tr.tax_group_id = 1
      AND tr.tax_country="CAN"
      AND tr.tax_state = "ON"  
      ORDER BY `tax_rate` DESC
  94. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 18301
      AND ps.stockroom_id = s.stockroom_id
  95. SELECT p.* 
      FROM jos_redshop_product_price AS
      WHERE  p.product_id = 18301
      AND p.shopper_group_id = '0' 
      ORDER BY price_quantity_start ASC
  96. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 18301
      AND discount_enddate>='1739792688'
      AND discount_stratdate<='1739792688'
  97. SELECT
      FROM jos_redshop_product AS
      WHERE  p.product_id = 18301
  98. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 18301
      AND ps.stockroom_id = s.stockroom_id
  99. SELECT
      FROM jos_modules
      WHERE `module` LIKE 'mod_redmagicmagnifyplus'
      AND published  = 1
  100. SELECT *
      FROM jos_redshop_media 
      WHERE media_section = "product"
      AND section_id ="18301"
      AND media_type="images" 
      AND media_name = "fashionforwalls4/2556N-72_scan_fashionforwalls4.jpg"
  101. SELECT *
      FROM jos_menu
      WHERE id = '283'
  102. SELECT sef_url,product_name,cat_in_sefurl
      FROM jos_redshop_product
      WHERE product_id = '18300'
  103. SELECT c.category_id
      FROM jos_redshop_category c,jos_redshop_product_category_xref pc
      WHERE pc.product_id = '18300'
      AND pc.category_id = c.category_id 
      AND c.category_id = '276'
  104. 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='276'
      AND c.category_id = cx.category_parent_id
  105. SELECT category_name
      FROM jos_redshop_category
      WHERE category_id = '276'
  106. SELECT p.* 
      FROM jos_redshop_product AS p   
      WHERE  p.product_id = 18300
  107. SELECT p.price_id,p.product_price,p.product_currency 
      FROM jos_redshop_product_price AS
      WHERE  p.product_id = 18300
      AND p.shopper_group_id = '0' 
      AND ( p.price_quantity_start <= '1'
      AND p.price_quantity_end >= '1' ) 
      ORDER BY price_quantity_start ASC
      LIMIT 0,1
  108. SELECT *
      FROM jos_redshop_discount_product_shoppers AS ps
      WHERE ps.shopper_group_id ='0'
  109. SELECT *
      FROM jos_redshop_discount_product 
      WHERE amount <= 0
      AND discount_product_id IN (0) 
      AND published =1
      AND start_date <= '1739792688'
      AND end_date >= '1739792688' 
      ORDER BY amount DESC
      LIMIT 0,1
  110. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 18300
  111. SELECT sg.*
     
      FROM jos_redshop_shopper_group AS sg
     
      LEFT JOIN jos_redshop_users_info AS ui
      ON ui.shopper_group_id = sg.shopper_group_id
      WHERE ui.user_id = '0'
      LIMIT 0,1
  112. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 18300
  113. SELECT tr.*
      FROM jos_redshop_tax_rate AS tr
      WHERE tr.tax_group_id = 1
      AND tr.tax_country="CAN"
      AND tr.tax_state = "ON"  
      ORDER BY `tax_rate` DESC
  114. SELECT sh.tax_exempt AS shopper_tax_exempt,sh.*,u.*
      FROM jos_redshop_users_info AS u
      LEFT JOIN jos_redshop_shopper_group AS sh
      ON sh.shopper_group_id=u.shopper_group_id
      WHERE u.user_id='0'
      AND u.address_type='BT'
  115. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 18300
  116. SELECT sg.*
     
      FROM jos_redshop_shopper_group AS sg
     
      LEFT JOIN jos_redshop_users_info AS ui
      ON ui.shopper_group_id = sg.shopper_group_id
      WHERE ui.user_id = '0'
      LIMIT 0,1
  117. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 18300
  118. SELECT tr.*
      FROM jos_redshop_tax_rate AS tr
      WHERE tr.tax_group_id = 1
      AND tr.tax_country="CAN"
      AND tr.tax_state = "ON"  
      ORDER BY `tax_rate` DESC
  119. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 18300
      AND ps.stockroom_id = s.stockroom_id
  120. SELECT p.* 
      FROM jos_redshop_product_price AS
      WHERE  p.product_id = 18300
      AND p.shopper_group_id = '0' 
      ORDER BY price_quantity_start ASC
  121. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 18300
      AND discount_enddate>='1739792688'
      AND discount_stratdate<='1739792688'
  122. SELECT
      FROM jos_redshop_product AS
      WHERE  p.product_id = 18300
  123. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 18300
      AND ps.stockroom_id = s.stockroom_id
  124. SELECT
      FROM jos_modules
      WHERE `module` LIKE 'mod_redmagicmagnifyplus'
      AND published  = 1
  125. SELECT *
      FROM jos_redshop_media 
      WHERE media_section = "product"
      AND section_id ="18300"
      AND media_type="images" 
      AND media_name = "fashionforwalls4/2556N-71_scan_fashionforwalls4.jpg"
  126. SELECT *
      FROM jos_menu
      WHERE id = '283'
  127. SELECT sef_url,product_name,cat_in_sefurl
      FROM jos_redshop_product
      WHERE product_id = '18299'
  128. SELECT c.category_id
      FROM jos_redshop_category c,jos_redshop_product_category_xref pc
      WHERE pc.product_id = '18299'
      AND pc.category_id = c.category_id 
      AND c.category_id = '276'
  129. 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='276'
      AND c.category_id = cx.category_parent_id
  130. SELECT category_name
      FROM jos_redshop_category
      WHERE category_id = '276'
  131. SELECT p.* 
      FROM jos_redshop_product AS p   
      WHERE  p.product_id = 18299
  132. SELECT p.price_id,p.product_price,p.product_currency 
      FROM jos_redshop_product_price AS
      WHERE  p.product_id = 18299
      AND p.shopper_group_id = '0' 
      AND ( p.price_quantity_start <= '1'
      AND p.price_quantity_end >= '1' ) 
      ORDER BY price_quantity_start ASC
      LIMIT 0,1
  133. SELECT *
      FROM jos_redshop_discount_product_shoppers AS ps
      WHERE ps.shopper_group_id ='0'
  134. SELECT *
      FROM jos_redshop_discount_product 
      WHERE amount <= 0
      AND discount_product_id IN (0) 
      AND published =1
      AND start_date <= '1739792688'
      AND end_date >= '1739792688' 
      ORDER BY amount DESC
      LIMIT 0,1
  135. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 18299
  136. SELECT sg.*
     
      FROM jos_redshop_shopper_group AS sg
     
      LEFT JOIN jos_redshop_users_info AS ui
      ON ui.shopper_group_id = sg.shopper_group_id
      WHERE ui.user_id = '0'
      LIMIT 0,1
  137. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 18299
  138. SELECT tr.*
      FROM jos_redshop_tax_rate AS tr
      WHERE tr.tax_group_id = 1
      AND tr.tax_country="CAN"
      AND tr.tax_state = "ON"  
      ORDER BY `tax_rate` DESC
  139. SELECT sh.tax_exempt AS shopper_tax_exempt,sh.*,u.*
      FROM jos_redshop_users_info AS u
      LEFT JOIN jos_redshop_shopper_group AS sh
      ON sh.shopper_group_id=u.shopper_group_id
      WHERE u.user_id='0'
      AND u.address_type='BT'
  140. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 18299
  141. SELECT sg.*
     
      FROM jos_redshop_shopper_group AS sg
     
      LEFT JOIN jos_redshop_users_info AS ui
      ON ui.shopper_group_id = sg.shopper_group_id
      WHERE ui.user_id = '0'
      LIMIT 0,1
  142. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 18299
  143. SELECT tr.*
      FROM jos_redshop_tax_rate AS tr
      WHERE tr.tax_group_id = 1
      AND tr.tax_country="CAN"
      AND tr.tax_state = "ON"  
      ORDER BY `tax_rate` DESC
  144. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 18299
      AND ps.stockroom_id = s.stockroom_id
  145. SELECT p.* 
      FROM jos_redshop_product_price AS
      WHERE  p.product_id = 18299
      AND p.shopper_group_id = '0' 
      ORDER BY price_quantity_start ASC
  146. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 18299
      AND discount_enddate>='1739792688'
      AND discount_stratdate<='1739792688'
  147. SELECT
      FROM jos_redshop_product AS
      WHERE  p.product_id = 18299
  148. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 18299
      AND ps.stockroom_id = s.stockroom_id
  149. SELECT
      FROM jos_modules
      WHERE `module` LIKE 'mod_redmagicmagnifyplus'
      AND published  = 1
  150. SELECT *
      FROM jos_redshop_media 
      WHERE media_section = "product"
      AND section_id ="18299"
      AND media_type="images" 
      AND media_name = "fashionforwalls4/2555N-72_scan_fashionforwalls4.jpg"
  151. SELECT *
      FROM jos_menu
      WHERE id = '283'
  152. SELECT sef_url,product_name,cat_in_sefurl
      FROM jos_redshop_product
      WHERE product_id = '18298'
  153. SELECT c.category_id
      FROM jos_redshop_category c,jos_redshop_product_category_xref pc
      WHERE pc.product_id = '18298'
      AND pc.category_id = c.category_id 
      AND c.category_id = '276'
  154. 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='276'
      AND c.category_id = cx.category_parent_id
  155. SELECT category_name
      FROM jos_redshop_category
      WHERE category_id = '276'
  156. SELECT p.* 
      FROM jos_redshop_product AS p   
      WHERE  p.product_id = 18298
  157. SELECT p.price_id,p.product_price,p.product_currency 
      FROM jos_redshop_product_price AS
      WHERE  p.product_id = 18298
      AND p.shopper_group_id = '0' 
      AND ( p.price_quantity_start <= '1'
      AND p.price_quantity_end >= '1' ) 
      ORDER BY price_quantity_start ASC
      LIMIT 0,1
  158. SELECT *
      FROM jos_redshop_discount_product_shoppers AS ps
      WHERE ps.shopper_group_id ='0'
  159. SELECT *
      FROM jos_redshop_discount_product 
      WHERE amount <= 0
      AND discount_product_id IN (0) 
      AND published =1
      AND start_date <= '1739792688'
      AND end_date >= '1739792688' 
      ORDER BY amount DESC
      LIMIT 0,1
  160. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 18298
  161. SELECT sg.*
     
      FROM jos_redshop_shopper_group AS sg
     
      LEFT JOIN jos_redshop_users_info AS ui
      ON ui.shopper_group_id = sg.shopper_group_id
      WHERE ui.user_id = '0'
      LIMIT 0,1
  162. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 18298
  163. SELECT tr.*
      FROM jos_redshop_tax_rate AS tr
      WHERE tr.tax_group_id = 1
      AND tr.tax_country="CAN"
      AND tr.tax_state = "ON"  
      ORDER BY `tax_rate` DESC
  164. SELECT sh.tax_exempt AS shopper_tax_exempt,sh.*,u.*
      FROM jos_redshop_users_info AS u
      LEFT JOIN jos_redshop_shopper_group AS sh
      ON sh.shopper_group_id=u.shopper_group_id
      WHERE u.user_id='0'
      AND u.address_type='BT'
  165. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 18298
  166. SELECT sg.*
     
      FROM jos_redshop_shopper_group AS sg
     
      LEFT JOIN jos_redshop_users_info AS ui
      ON ui.shopper_group_id = sg.shopper_group_id
      WHERE ui.user_id = '0'
      LIMIT 0,1
  167. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 18298
  168. SELECT tr.*
      FROM jos_redshop_tax_rate AS tr
      WHERE tr.tax_group_id = 1
      AND tr.tax_country="CAN"
      AND tr.tax_state = "ON"  
      ORDER BY `tax_rate` DESC
  169. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 18298
      AND ps.stockroom_id = s.stockroom_id
  170. SELECT p.* 
      FROM jos_redshop_product_price AS
      WHERE  p.product_id = 18298
      AND p.shopper_group_id = '0' 
      ORDER BY price_quantity_start ASC
  171. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 18298
      AND discount_enddate>='1739792688'
      AND discount_stratdate<='1739792688'
  172. SELECT
      FROM jos_redshop_product AS
      WHERE  p.product_id = 18298
  173. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 18298
      AND ps.stockroom_id = s.stockroom_id
  174. SELECT
      FROM jos_modules
      WHERE `module` LIKE 'mod_redmagicmagnifyplus'
      AND published  = 1
  175. SELECT *
      FROM jos_redshop_media 
      WHERE media_section = "product"
      AND section_id ="18298"
      AND media_type="images" 
      AND media_name = "fashionforwalls4/2555N-71_scan_fashionforwalls4.jpg"
  176. SELECT *
      FROM jos_menu
      WHERE id = '283'
  177. SELECT sef_url,product_name,cat_in_sefurl
      FROM jos_redshop_product
      WHERE product_id = '18297'
  178. SELECT c.category_id
      FROM jos_redshop_category c,jos_redshop_product_category_xref pc
      WHERE pc.product_id = '18297'
      AND pc.category_id = c.category_id 
      AND c.category_id = '276'
  179. 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='276'
      AND c.category_id = cx.category_parent_id
  180. SELECT category_name
      FROM jos_redshop_category
      WHERE category_id = '276'
  181. SELECT p.* 
      FROM jos_redshop_product AS p   
      WHERE  p.product_id = 18297
  182. SELECT p.price_id,p.product_price,p.product_currency 
      FROM jos_redshop_product_price AS
      WHERE  p.product_id = 18297
      AND p.shopper_group_id = '0' 
      AND ( p.price_quantity_start <= '1'
      AND p.price_quantity_end >= '1' ) 
      ORDER BY price_quantity_start ASC
      LIMIT 0,1
  183. SELECT *
      FROM jos_redshop_discount_product_shoppers AS ps
      WHERE ps.shopper_group_id ='0'
  184. SELECT *
      FROM jos_redshop_discount_product 
      WHERE amount <= 0
      AND discount_product_id IN (0) 
      AND published =1
      AND start_date <= '1739792688'
      AND end_date >= '1739792688' 
      ORDER BY amount DESC
      LIMIT 0,1
  185. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 18297
  186. SELECT sg.*
     
      FROM jos_redshop_shopper_group AS sg
     
      LEFT JOIN jos_redshop_users_info AS ui
      ON ui.shopper_group_id = sg.shopper_group_id
      WHERE ui.user_id = '0'
      LIMIT 0,1
  187. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 18297
  188. SELECT tr.*
      FROM jos_redshop_tax_rate AS tr
      WHERE tr.tax_group_id = 1
      AND tr.tax_country="CAN"
      AND tr.tax_state = "ON"  
      ORDER BY `tax_rate` DESC
  189. SELECT sh.tax_exempt AS shopper_tax_exempt,sh.*,u.*
      FROM jos_redshop_users_info AS u
      LEFT JOIN jos_redshop_shopper_group AS sh
      ON sh.shopper_group_id=u.shopper_group_id
      WHERE u.user_id='0'
      AND u.address_type='BT'
  190. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 18297
  191. SELECT sg.*
     
      FROM jos_redshop_shopper_group AS sg
     
      LEFT JOIN jos_redshop_users_info AS ui
      ON ui.shopper_group_id = sg.shopper_group_id
      WHERE ui.user_id = '0'
      LIMIT 0,1
  192. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 18297
  193. SELECT tr.*
      FROM jos_redshop_tax_rate AS tr
      WHERE tr.tax_group_id = 1
      AND tr.tax_country="CAN"
      AND tr.tax_state = "ON"  
      ORDER BY `tax_rate` DESC
  194. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 18297
      AND ps.stockroom_id = s.stockroom_id
  195. SELECT p.* 
      FROM jos_redshop_product_price AS
      WHERE  p.product_id = 18297
      AND p.shopper_group_id = '0' 
      ORDER BY price_quantity_start ASC
  196. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 18297
      AND discount_enddate>='1739792688'
      AND discount_stratdate<='1739792688'
  197. SELECT
      FROM jos_redshop_product AS
      WHERE  p.product_id = 18297
  198. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 18297
      AND ps.stockroom_id = s.stockroom_id
  199. SELECT
      FROM jos_modules
      WHERE `module` LIKE 'mod_redmagicmagnifyplus'
      AND published  = 1
  200. SELECT *
      FROM jos_redshop_media 
      WHERE media_section = "product"
      AND section_id ="18297"
      AND media_type="images" 
      AND media_name = "fashionforwalls4/2554N-72_scan_fashionforwalls4.jpg"
  201. SELECT *
      FROM jos_menu
      WHERE id = '283'
  202. SELECT sef_url,product_name,cat_in_sefurl
      FROM jos_redshop_product
      WHERE product_id = '18296'
  203. SELECT c.category_id
      FROM jos_redshop_category c,jos_redshop_product_category_xref pc
      WHERE pc.product_id = '18296'
      AND pc.category_id = c.category_id 
      AND c.category_id = '276'
  204. 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='276'
      AND c.category_id = cx.category_parent_id
  205. SELECT category_name
      FROM jos_redshop_category
      WHERE category_id = '276'
  206. SELECT p.* 
      FROM jos_redshop_product AS p   
      WHERE  p.product_id = 18296
  207. SELECT p.price_id,p.product_price,p.product_currency 
      FROM jos_redshop_product_price AS
      WHERE  p.product_id = 18296
      AND p.shopper_group_id = '0' 
      AND ( p.price_quantity_start <= '1'
      AND p.price_quantity_end >= '1' ) 
      ORDER BY price_quantity_start ASC
      LIMIT 0,1
  208. SELECT *
      FROM jos_redshop_discount_product_shoppers AS ps
      WHERE ps.shopper_group_id ='0'
  209. SELECT *
      FROM jos_redshop_discount_product 
      WHERE amount <= 0
      AND discount_product_id IN (0) 
      AND published =1
      AND start_date <= '1739792688'
      AND end_date >= '1739792688' 
      ORDER BY amount DESC
      LIMIT 0,1
  210. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 18296
  211. SELECT sg.*
     
      FROM jos_redshop_shopper_group AS sg
     
      LEFT JOIN jos_redshop_users_info AS ui
      ON ui.shopper_group_id = sg.shopper_group_id
      WHERE ui.user_id = '0'
      LIMIT 0,1
  212. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 18296
  213. SELECT tr.*
      FROM jos_redshop_tax_rate AS tr
      WHERE tr.tax_group_id = 1
      AND tr.tax_country="CAN"
      AND tr.tax_state = "ON"  
      ORDER BY `tax_rate` DESC
  214. SELECT sh.tax_exempt AS shopper_tax_exempt,sh.*,u.*
      FROM jos_redshop_users_info AS u
      LEFT JOIN jos_redshop_shopper_group AS sh
      ON sh.shopper_group_id=u.shopper_group_id
      WHERE u.user_id='0'
      AND u.address_type='BT'
  215. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 18296
  216. SELECT sg.*
     
      FROM jos_redshop_shopper_group AS sg
     
      LEFT JOIN jos_redshop_users_info AS ui
      ON ui.shopper_group_id = sg.shopper_group_id
      WHERE ui.user_id = '0'
      LIMIT 0,1
  217. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 18296
  218. SELECT tr.*
      FROM jos_redshop_tax_rate AS tr
      WHERE tr.tax_group_id = 1
      AND tr.tax_country="CAN"
      AND tr.tax_state = "ON"  
      ORDER BY `tax_rate` DESC
  219. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 18296
      AND ps.stockroom_id = s.stockroom_id
  220. SELECT p.* 
      FROM jos_redshop_product_price AS
      WHERE  p.product_id = 18296
      AND p.shopper_group_id = '0' 
      ORDER BY price_quantity_start ASC
  221. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 18296
      AND discount_enddate>='1739792688'
      AND discount_stratdate<='1739792688'
  222. SELECT
      FROM jos_redshop_product AS
      WHERE  p.product_id = 18296
  223. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 18296
      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 ="18296"
      AND media_type="images" 
      AND media_name = "fashionforwalls4/2554N-71_scan_fashionforwalls4.jpg"
  226. SELECT *
      FROM jos_menu
      WHERE id = '283'
  227. SELECT sef_url,product_name,cat_in_sefurl
      FROM jos_redshop_product
      WHERE product_id = '18295'
  228. SELECT c.category_id
      FROM jos_redshop_category c,jos_redshop_product_category_xref pc
      WHERE pc.product_id = '18295'
      AND pc.category_id = c.category_id 
      AND c.category_id = '276'
  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='276'
      AND c.category_id = cx.category_parent_id
  230. SELECT category_name
      FROM jos_redshop_category
      WHERE category_id = '276'
  231. SELECT p.* 
      FROM jos_redshop_product AS p   
      WHERE  p.product_id = 18295
  232. SELECT p.price_id,p.product_price,p.product_currency 
      FROM jos_redshop_product_price AS
      WHERE  p.product_id = 18295
      AND p.shopper_group_id = '0' 
      AND ( p.price_quantity_start <= '1'
      AND p.price_quantity_end >= '1' ) 
      ORDER BY price_quantity_start ASC
      LIMIT 0,1
  233. SELECT *
      FROM jos_redshop_discount_product_shoppers AS ps
      WHERE ps.shopper_group_id ='0'
  234. SELECT *
      FROM jos_redshop_discount_product 
      WHERE amount <= 0
      AND discount_product_id IN (0) 
      AND published =1
      AND start_date <= '1739792688'
      AND end_date >= '1739792688' 
      ORDER BY amount DESC
      LIMIT 0,1
  235. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 18295
  236. SELECT sg.*
     
      FROM jos_redshop_shopper_group AS sg
     
      LEFT JOIN jos_redshop_users_info AS ui
      ON ui.shopper_group_id = sg.shopper_group_id
      WHERE ui.user_id = '0'
      LIMIT 0,1
  237. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 18295
  238. SELECT tr.*
      FROM jos_redshop_tax_rate AS tr
      WHERE tr.tax_group_id = 1
      AND tr.tax_country="CAN"
      AND tr.tax_state = "ON"  
      ORDER BY `tax_rate` DESC
  239. SELECT sh.tax_exempt AS shopper_tax_exempt,sh.*,u.*
      FROM jos_redshop_users_info AS u
      LEFT JOIN jos_redshop_shopper_group AS sh
      ON sh.shopper_group_id=u.shopper_group_id
      WHERE u.user_id='0'
      AND u.address_type='BT'
  240. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 18295
  241. SELECT sg.*
     
      FROM jos_redshop_shopper_group AS sg
     
      LEFT JOIN jos_redshop_users_info AS ui
      ON ui.shopper_group_id = sg.shopper_group_id
      WHERE ui.user_id = '0'
      LIMIT 0,1
  242. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 18295
  243. SELECT tr.*
      FROM jos_redshop_tax_rate AS tr
      WHERE tr.tax_group_id = 1
      AND tr.tax_country="CAN"
      AND tr.tax_state = "ON"  
      ORDER BY `tax_rate` DESC
  244. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 18295
      AND ps.stockroom_id = s.stockroom_id
  245. SELECT p.* 
      FROM jos_redshop_product_price AS
      WHERE  p.product_id = 18295
      AND p.shopper_group_id = '0' 
      ORDER BY price_quantity_start ASC
  246. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 18295
      AND discount_enddate>='1739792688'
      AND discount_stratdate<='1739792688'
  247. SELECT
      FROM jos_redshop_product AS
      WHERE  p.product_id = 18295
  248. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 18295
      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 ="18295"
      AND media_type="images" 
      AND media_name = "fashionforwalls4/2553N-72_scan_fashionforwalls4.jpg"
  251. SELECT *
      FROM jos_menu
      WHERE id = '283'
  252. SELECT sef_url,product_name,cat_in_sefurl
      FROM jos_redshop_product
      WHERE product_id = '18294'
  253. SELECT c.category_id
      FROM jos_redshop_category c,jos_redshop_product_category_xref pc
      WHERE pc.product_id = '18294'
      AND pc.category_id = c.category_id 
      AND c.category_id = '276'
  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='276'
      AND c.category_id = cx.category_parent_id
  255. SELECT category_name
      FROM jos_redshop_category
      WHERE category_id = '276'
  256. SELECT p.* 
      FROM jos_redshop_product AS p   
      WHERE  p.product_id = 18294
  257. SELECT p.price_id,p.product_price,p.product_currency 
      FROM jos_redshop_product_price AS
      WHERE  p.product_id = 18294
      AND p.shopper_group_id = '0' 
      AND ( p.price_quantity_start <= '1'
      AND p.price_quantity_end >= '1' ) 
      ORDER BY price_quantity_start ASC
      LIMIT 0,1
  258. SELECT *
      FROM jos_redshop_discount_product_shoppers AS ps
      WHERE ps.shopper_group_id ='0'
  259. SELECT *
      FROM jos_redshop_discount_product 
      WHERE amount <= 0
      AND discount_product_id IN (0) 
      AND published =1
      AND start_date <= '1739792688'
      AND end_date >= '1739792688' 
      ORDER BY amount DESC
      LIMIT 0,1
  260. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 18294
  261. SELECT sg.*
     
      FROM jos_redshop_shopper_group AS sg
     
      LEFT JOIN jos_redshop_users_info AS ui
      ON ui.shopper_group_id = sg.shopper_group_id
      WHERE ui.user_id = '0'
      LIMIT 0,1
  262. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 18294
  263. SELECT tr.*
      FROM jos_redshop_tax_rate AS tr
      WHERE tr.tax_group_id = 1
      AND tr.tax_country="CAN"
      AND tr.tax_state = "ON"  
      ORDER BY `tax_rate` DESC
  264. SELECT sh.tax_exempt AS shopper_tax_exempt,sh.*,u.*
      FROM jos_redshop_users_info AS u
      LEFT JOIN jos_redshop_shopper_group AS sh
      ON sh.shopper_group_id=u.shopper_group_id
      WHERE u.user_id='0'
      AND u.address_type='BT'
  265. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 18294
  266. SELECT sg.*
     
      FROM jos_redshop_shopper_group AS sg
     
      LEFT JOIN jos_redshop_users_info AS ui
      ON ui.shopper_group_id = sg.shopper_group_id
      WHERE ui.user_id = '0'
      LIMIT 0,1
  267. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 18294
  268. SELECT tr.*
      FROM jos_redshop_tax_rate AS tr
      WHERE tr.tax_group_id = 1
      AND tr.tax_country="CAN"
      AND tr.tax_state = "ON"  
      ORDER BY `tax_rate` DESC
  269. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 18294
      AND ps.stockroom_id = s.stockroom_id
  270. SELECT p.* 
      FROM jos_redshop_product_price AS
      WHERE  p.product_id = 18294
      AND p.shopper_group_id = '0' 
      ORDER BY price_quantity_start ASC
  271. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 18294
      AND discount_enddate>='1739792688'
      AND discount_stratdate<='1739792688'
  272. SELECT
      FROM jos_redshop_product AS
      WHERE  p.product_id = 18294
  273. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 18294
      AND ps.stockroom_id = s.stockroom_id
  274. SELECT
      FROM jos_modules
      WHERE `module` LIKE 'mod_redmagicmagnifyplus'
      AND published  = 1
  275. SELECT *
      FROM jos_redshop_media 
      WHERE media_section = "product"
      AND section_id ="18294"
      AND media_type="images" 
      AND media_name = "fashionforwalls4/2553N-71_scan_fashionforwalls4.jpg"
  276. SELECT *
      FROM jos_menu
      WHERE id = '283'
  277. SELECT sef_url,product_name,cat_in_sefurl
      FROM jos_redshop_product
      WHERE product_id = '18293'
  278. SELECT c.category_id
      FROM jos_redshop_category c,jos_redshop_product_category_xref pc
      WHERE pc.product_id = '18293'
      AND pc.category_id = c.category_id 
      AND c.category_id = '276'
  279. 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='276'
      AND c.category_id = cx.category_parent_id
  280. SELECT category_name
      FROM jos_redshop_category
      WHERE category_id = '276'
  281. SELECT p.* 
      FROM jos_redshop_product AS p   
      WHERE  p.product_id = 18293
  282. SELECT p.price_id,p.product_price,p.product_currency 
      FROM jos_redshop_product_price AS
      WHERE  p.product_id = 18293
      AND p.shopper_group_id = '0' 
      AND ( p.price_quantity_start <= '1'
      AND p.price_quantity_end >= '1' ) 
      ORDER BY price_quantity_start ASC
      LIMIT 0,1
  283. SELECT *
      FROM jos_redshop_discount_product_shoppers AS ps
      WHERE ps.shopper_group_id ='0'
  284. SELECT *
      FROM jos_redshop_discount_product 
      WHERE amount <= 0
      AND discount_product_id IN (0) 
      AND published =1
      AND start_date <= '1739792688'
      AND end_date >= '1739792688' 
      ORDER BY amount DESC
      LIMIT 0,1
  285. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 18293
  286. SELECT sg.*
     
      FROM jos_redshop_shopper_group AS sg
     
      LEFT JOIN jos_redshop_users_info AS ui
      ON ui.shopper_group_id = sg.shopper_group_id
      WHERE ui.user_id = '0'
      LIMIT 0,1
  287. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 18293
  288. SELECT tr.*
      FROM jos_redshop_tax_rate AS tr
      WHERE tr.tax_group_id = 1
      AND tr.tax_country="CAN"
      AND tr.tax_state = "ON"  
      ORDER BY `tax_rate` DESC
  289. SELECT sh.tax_exempt AS shopper_tax_exempt,sh.*,u.*
      FROM jos_redshop_users_info AS u
      LEFT JOIN jos_redshop_shopper_group AS sh
      ON sh.shopper_group_id=u.shopper_group_id
      WHERE u.user_id='0'
      AND u.address_type='BT'
  290. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 18293
  291. SELECT sg.*
     
      FROM jos_redshop_shopper_group AS sg
     
      LEFT JOIN jos_redshop_users_info AS ui
      ON ui.shopper_group_id = sg.shopper_group_id
      WHERE ui.user_id = '0'
      LIMIT 0,1
  292. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 18293
  293. SELECT tr.*
      FROM jos_redshop_tax_rate AS tr
      WHERE tr.tax_group_id = 1
      AND tr.tax_country="CAN"
      AND tr.tax_state = "ON"  
      ORDER BY `tax_rate` DESC
  294. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 18293
      AND ps.stockroom_id = s.stockroom_id
  295. SELECT p.* 
      FROM jos_redshop_product_price AS
      WHERE  p.product_id = 18293
      AND p.shopper_group_id = '0' 
      ORDER BY price_quantity_start ASC
  296. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 18293
      AND discount_enddate>='1739792688'
      AND discount_stratdate<='1739792688'
  297. SELECT
      FROM jos_redshop_product AS
      WHERE  p.product_id = 18293
  298. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 18293
      AND ps.stockroom_id = s.stockroom_id
  299. SELECT
      FROM jos_modules
      WHERE `module` LIKE 'mod_redmagicmagnifyplus'
      AND published  = 1
  300. SELECT *
      FROM jos_redshop_media 
      WHERE media_section = "product"
      AND section_id ="18293"
      AND media_type="images" 
      AND media_name = "fashionforwalls4/2552N-82_scan_fashionforwalls4.jpg"
  301. SELECT *
      FROM jos_menu
      WHERE id = '283'
  302. SELECT sef_url,product_name,cat_in_sefurl
      FROM jos_redshop_product
      WHERE product_id = '18292'
  303. SELECT c.category_id
      FROM jos_redshop_category c,jos_redshop_product_category_xref pc
      WHERE pc.product_id = '18292'
      AND pc.category_id = c.category_id 
      AND c.category_id = '276'
  304. 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='276'
      AND c.category_id = cx.category_parent_id
  305. SELECT category_name
      FROM jos_redshop_category
      WHERE category_id = '276'
  306. SELECT p.* 
      FROM jos_redshop_product AS p   
      WHERE  p.product_id = 18292
  307. SELECT p.price_id,p.product_price,p.product_currency 
      FROM jos_redshop_product_price AS
      WHERE  p.product_id = 18292
      AND p.shopper_group_id = '0' 
      AND ( p.price_quantity_start <= '1'
      AND p.price_quantity_end >= '1' ) 
      ORDER BY price_quantity_start ASC
      LIMIT 0,1
  308. SELECT *
      FROM jos_redshop_discount_product_shoppers AS ps
      WHERE ps.shopper_group_id ='0'
  309. SELECT *
      FROM jos_redshop_discount_product 
      WHERE amount <= 0
      AND discount_product_id IN (0) 
      AND published =1
      AND start_date <= '1739792688'
      AND end_date >= '1739792688' 
      ORDER BY amount DESC
      LIMIT 0,1
  310. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 18292
  311. SELECT sg.*
     
      FROM jos_redshop_shopper_group AS sg
     
      LEFT JOIN jos_redshop_users_info AS ui
      ON ui.shopper_group_id = sg.shopper_group_id
      WHERE ui.user_id = '0'
      LIMIT 0,1
  312. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 18292
  313. SELECT tr.*
      FROM jos_redshop_tax_rate AS tr
      WHERE tr.tax_group_id = 1
      AND tr.tax_country="CAN"
      AND tr.tax_state = "ON"  
      ORDER BY `tax_rate` DESC
  314. SELECT sh.tax_exempt AS shopper_tax_exempt,sh.*,u.*
      FROM jos_redshop_users_info AS u
      LEFT JOIN jos_redshop_shopper_group AS sh
      ON sh.shopper_group_id=u.shopper_group_id
      WHERE u.user_id='0'
      AND u.address_type='BT'
  315. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 18292
  316. SELECT sg.*
     
      FROM jos_redshop_shopper_group AS sg
     
      LEFT JOIN jos_redshop_users_info AS ui
      ON ui.shopper_group_id = sg.shopper_group_id
      WHERE ui.user_id = '0'
      LIMIT 0,1
  317. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 18292
  318. SELECT tr.*
      FROM jos_redshop_tax_rate AS tr
      WHERE tr.tax_group_id = 1
      AND tr.tax_country="CAN"
      AND tr.tax_state = "ON"  
      ORDER BY `tax_rate` DESC
  319. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 18292
      AND ps.stockroom_id = s.stockroom_id
  320. SELECT p.* 
      FROM jos_redshop_product_price AS
      WHERE  p.product_id = 18292
      AND p.shopper_group_id = '0' 
      ORDER BY price_quantity_start ASC
  321. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 18292
      AND discount_enddate>='1739792688'
      AND discount_stratdate<='1739792688'
  322. SELECT
      FROM jos_redshop_product AS
      WHERE  p.product_id = 18292
  323. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 18292
      AND ps.stockroom_id = s.stockroom_id
  324. SELECT
      FROM jos_modules
      WHERE `module` LIKE 'mod_redmagicmagnifyplus'
      AND published  = 1
  325. SELECT *
      FROM jos_redshop_media 
      WHERE media_section = "product"
      AND section_id ="18292"
      AND media_type="images" 
      AND media_name = "fashionforwalls4/2552N-81_scan_fashionforwalls4.jpg"
  326. SELECT *
      FROM jos_menu
      WHERE id = '283'
  327. SELECT sef_url,product_name,cat_in_sefurl
      FROM jos_redshop_product
      WHERE product_id = '18291'
  328. SELECT c.category_id
      FROM jos_redshop_category c,jos_redshop_product_category_xref pc
      WHERE pc.product_id = '18291'
      AND pc.category_id = c.category_id 
      AND c.category_id = '276'
  329. 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='276'
      AND c.category_id = cx.category_parent_id
  330. SELECT category_name
      FROM jos_redshop_category
      WHERE category_id = '276'
  331. SELECT p.* 
      FROM jos_redshop_product AS p   
      WHERE  p.product_id = 18291
  332. SELECT p.price_id,p.product_price,p.product_currency 
      FROM jos_redshop_product_price AS
      WHERE  p.product_id = 18291
      AND p.shopper_group_id = '0' 
      AND ( p.price_quantity_start <= '1'
      AND p.price_quantity_end >= '1' ) 
      ORDER BY price_quantity_start ASC
      LIMIT 0,1
  333. SELECT *
      FROM jos_redshop_discount_product_shoppers AS ps
      WHERE ps.shopper_group_id ='0'
  334. SELECT *
      FROM jos_redshop_discount_product 
      WHERE amount <= 0
      AND discount_product_id IN (0) 
      AND published =1
      AND start_date <= '1739792688'
      AND end_date >= '1739792688' 
      ORDER BY amount DESC
      LIMIT 0,1
  335. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 18291
  336. SELECT sg.*
     
      FROM jos_redshop_shopper_group AS sg
     
      LEFT JOIN jos_redshop_users_info AS ui
      ON ui.shopper_group_id = sg.shopper_group_id
      WHERE ui.user_id = '0'
      LIMIT 0,1
  337. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 18291
  338. SELECT tr.*
      FROM jos_redshop_tax_rate AS tr
      WHERE tr.tax_group_id = 1
      AND tr.tax_country="CAN"
      AND tr.tax_state = "ON"  
      ORDER BY `tax_rate` DESC
  339. SELECT sh.tax_exempt AS shopper_tax_exempt,sh.*,u.*
      FROM jos_redshop_users_info AS u
      LEFT JOIN jos_redshop_shopper_group AS sh
      ON sh.shopper_group_id=u.shopper_group_id
      WHERE u.user_id='0'
      AND u.address_type='BT'
  340. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 18291
  341. SELECT sg.*
     
      FROM jos_redshop_shopper_group AS sg
     
      LEFT JOIN jos_redshop_users_info AS ui
      ON ui.shopper_group_id = sg.shopper_group_id
      WHERE ui.user_id = '0'
      LIMIT 0,1
  342. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 18291
  343. SELECT tr.*
      FROM jos_redshop_tax_rate AS tr
      WHERE tr.tax_group_id = 1
      AND tr.tax_country="CAN"
      AND tr.tax_state = "ON"  
      ORDER BY `tax_rate` DESC
  344. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 18291
      AND ps.stockroom_id = s.stockroom_id
  345. SELECT p.* 
      FROM jos_redshop_product_price AS
      WHERE  p.product_id = 18291
      AND p.shopper_group_id = '0' 
      ORDER BY price_quantity_start ASC
  346. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 18291
      AND discount_enddate>='1739792688'
      AND discount_stratdate<='1739792688'
  347. SELECT
      FROM jos_redshop_product AS
      WHERE  p.product_id = 18291
  348. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 18291
      AND ps.stockroom_id = s.stockroom_id
  349. SELECT
      FROM jos_modules
      WHERE `module` LIKE 'mod_redmagicmagnifyplus'
      AND published  = 1
  350. SELECT *
      FROM jos_redshop_media 
      WHERE media_section = "product"
      AND section_id ="18291"
      AND media_type="images" 
      AND media_name = "fashionforwalls4/2551N-82_scan_fashionforwalls4.jpg"
  351. SELECT *
      FROM jos_menu
      WHERE id = '283'
  352. SELECT sef_url,product_name,cat_in_sefurl
      FROM jos_redshop_product
      WHERE product_id = '18290'
  353. SELECT c.category_id
      FROM jos_redshop_category c,jos_redshop_product_category_xref pc
      WHERE pc.product_id = '18290'
      AND pc.category_id = c.category_id 
      AND c.category_id = '276'
  354. 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='276'
      AND c.category_id = cx.category_parent_id
  355. SELECT category_name
      FROM jos_redshop_category
      WHERE category_id = '276'
  356. SELECT p.* 
      FROM jos_redshop_product AS p   
      WHERE  p.product_id = 18290
  357. SELECT p.price_id,p.product_price,p.product_currency 
      FROM jos_redshop_product_price AS
      WHERE  p.product_id = 18290
      AND p.shopper_group_id = '0' 
      AND ( p.price_quantity_start <= '1'
      AND p.price_quantity_end >= '1' ) 
      ORDER BY price_quantity_start ASC
      LIMIT 0,1
  358. SELECT *
      FROM jos_redshop_discount_product_shoppers AS ps
      WHERE ps.shopper_group_id ='0'
  359. SELECT *
      FROM jos_redshop_discount_product 
      WHERE amount <= 0
      AND discount_product_id IN (0) 
      AND published =1
      AND start_date <= '1739792688'
      AND end_date >= '1739792688' 
      ORDER BY amount DESC
      LIMIT 0,1
  360. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 18290
  361. SELECT sg.*
     
      FROM jos_redshop_shopper_group AS sg
     
      LEFT JOIN jos_redshop_users_info AS ui
      ON ui.shopper_group_id = sg.shopper_group_id
      WHERE ui.user_id = '0'
      LIMIT 0,1
  362. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 18290
  363. SELECT tr.*
      FROM jos_redshop_tax_rate AS tr
      WHERE tr.tax_group_id = 1
      AND tr.tax_country="CAN"
      AND tr.tax_state = "ON"  
      ORDER BY `tax_rate` DESC
  364. SELECT sh.tax_exempt AS shopper_tax_exempt,sh.*,u.*
      FROM jos_redshop_users_info AS u
      LEFT JOIN jos_redshop_shopper_group AS sh
      ON sh.shopper_group_id=u.shopper_group_id
      WHERE u.user_id='0'
      AND u.address_type='BT'
  365. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 18290
  366. SELECT sg.*
     
      FROM jos_redshop_shopper_group AS sg
     
      LEFT JOIN jos_redshop_users_info AS ui
      ON ui.shopper_group_id = sg.shopper_group_id
      WHERE ui.user_id = '0'
      LIMIT 0,1
  367. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 18290
  368. SELECT tr.*
      FROM jos_redshop_tax_rate AS tr
      WHERE tr.tax_group_id = 1
      AND tr.tax_country="CAN"
      AND tr.tax_state = "ON"  
      ORDER BY `tax_rate` DESC
  369. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 18290
      AND ps.stockroom_id = s.stockroom_id
  370. SELECT p.* 
      FROM jos_redshop_product_price AS
      WHERE  p.product_id = 18290
      AND p.shopper_group_id = '0' 
      ORDER BY price_quantity_start ASC
  371. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 18290
      AND discount_enddate>='1739792688'
      AND discount_stratdate<='1739792688'
  372. SELECT
      FROM jos_redshop_product AS
      WHERE  p.product_id = 18290
  373. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 18290
      AND ps.stockroom_id = s.stockroom_id
  374. SELECT
      FROM jos_modules
      WHERE `module` LIKE 'mod_redmagicmagnifyplus'
      AND published  = 1
  375. SELECT *
      FROM jos_redshop_media 
      WHERE media_section = "product"
      AND section_id ="18290"
      AND media_type="images" 
      AND media_name = "fashionforwalls4/2551N-81_scan_fashionforwalls4.jpg"
  376. SELECT *
      FROM jos_menu
      WHERE id = '283'
  377. SELECT sef_url,product_name,cat_in_sefurl
      FROM jos_redshop_product
      WHERE product_id = '18289'
  378. SELECT c.category_id
      FROM jos_redshop_category c,jos_redshop_product_category_xref pc
      WHERE pc.product_id = '18289'
      AND pc.category_id = c.category_id 
      AND c.category_id = '276'
  379. 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='276'
      AND c.category_id = cx.category_parent_id
  380. SELECT category_name
      FROM jos_redshop_category
      WHERE category_id = '276'
  381. SELECT p.* 
      FROM jos_redshop_product AS p   
      WHERE  p.product_id = 18289
  382. SELECT p.price_id,p.product_price,p.product_currency 
      FROM jos_redshop_product_price AS
      WHERE  p.product_id = 18289
      AND p.shopper_group_id = '0' 
      AND ( p.price_quantity_start <= '1'
      AND p.price_quantity_end >= '1' ) 
      ORDER BY price_quantity_start ASC
      LIMIT 0,1
  383. SELECT *
      FROM jos_redshop_discount_product_shoppers AS ps
      WHERE ps.shopper_group_id ='0'
  384. SELECT *
      FROM jos_redshop_discount_product 
      WHERE amount <= 0
      AND discount_product_id IN (0) 
      AND published =1
      AND start_date <= '1739792688'
      AND end_date >= '1739792688' 
      ORDER BY amount DESC
      LIMIT 0,1
  385. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 18289
  386. SELECT sg.*
     
      FROM jos_redshop_shopper_group AS sg
     
      LEFT JOIN jos_redshop_users_info AS ui
      ON ui.shopper_group_id = sg.shopper_group_id
      WHERE ui.user_id = '0'
      LIMIT 0,1
  387. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 18289
  388. SELECT tr.*
      FROM jos_redshop_tax_