GIR257018 Scroll Texture

GIR257018 Scroll Texture
GIR257015
GIR257016
GIR257018
GIR257020
GIR257029
GIR257030

Sidewall
Collection: Girls Rule
Type: Prepasted, Washable,Environmentally Friendly, Fully Removable
Packaged in 2 single roll: 20.5"x11y (56 sq.ft) 52.1cm x 10.06 m
Repeat: 20.5" / 52 cm
Match: Half Dropt
Wallcoverings are packaged and sold in double rolls only

 

 

Profile Information

Application afterLoad: 0.000 seconds, 0.30 MB
Application afterInitialise: 0.006 seconds, 0.97 MB
Application afterRoute: 0.011 seconds, 2.53 MB
Application afterDispatch: 8.236 seconds, 3.22 MB
Application afterRender: 8.252 seconds, 3.43 MB

Memory Usage

3631696

501 queries logged

  1. SELECT *
      FROM jos_session
      WHERE session_id = '4ume81mguniq0dn7mqctfeijj5'
  2. DELETE
      FROM jos_session
      WHERE ( time < '1753921591' )
  3. SELECT *
      FROM jos_session
      WHERE session_id = '4ume81mguniq0dn7mqctfeijj5'
  4. UPDATE `jos_session`
      SET `time`='1753928791',`userid`='0',`usertype`='',`username`='',`gid`='0',`guest`='1',`client_id`='0',`data`='__default|a:7:{s:15:\"session.counter\";i:1;s:19:\"session.timer.start\";i:1753928784;s:18:\"session.timer.last\";i:1753928784;s:17:\"session.timer.now\";i:1753928784;s:8:\"registry\";O:9:\"JRegistry\":3:{s:17:\"_defaultNameSpace\";s:7:\"session\";s:9:\"_registry\";a:1:{s:7:\"session\";a:1:{s:4:\"data\";O:8:\"stdClass\":0:{}}}s:7:\"_errors\";a:0:{}}s:4:\"user\";O:5:\"JUser\":19:{s:2:\"id\";i:0;s:4:\"name\";N;s:8:\"username\";N;s:5:\"email\";N;s:8:\"password\";N;s:14:\"password_clear\";s:0:\"\";s:8:\"usertype\";N;s:5:\"block\";N;s:9:\"sendEmail\";i:0;s:3:\"gid\";i:0;s:12:\"registerDate\";N;s:13:\"lastvisitDate\";N;s:10:\"activation\";N;s:6:\"params\";N;s:3:\"aid\";i:0;s:5:\"guest\";i:1;s:7:\"_params\";O:10:\"JParameter\":7:{s:4:\"_raw\";s:0:\"\";s:4:\"_xml\";N;s:9:\"_elements\";a:0:{}s:12:\"_elementPath\";a:1:{i:0;s:65:\"/home/ontwall/public_html/libraries/joomla/html/parameter/element\";}s:17:\"_defaultNameSpace\";s:8:\"_default\";s:9:\"_registry\";a:1:{s:8:\"_default\";a:1:{s:4:\"data\";O:8:\"stdClass\":0:{}}}s:7:\"_errors\";a:0:{}}s:9:\"_errorMsg\";N;s:7:\"_errors\";a:0:{}}s:7:\"visited\";a:1:{i:0;s:3:\"124\";}}'
      WHERE session_id='4ume81mguniq0dn7mqctfeijj5'
  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-07-30'
  12. SELECT *
      FROM jos_redshop_siteviewer
      WHERE session_id = '4ume81mguniq0dn7mqctfeijj5'
  13. SELECT *
      FROM jos_redshop_pageviewer
      WHERE session_id = '4ume81mguniq0dn7mqctfeijj5'
      AND section='product'
      AND section_id='86'
  14. INSERT INTO jos_redshop_pageviewer (session_id, user_id, section, section_id, created_date)
      VALUES ('4ume81mguniq0dn7mqctfeijj5','0','product','86','1753928799')
  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 = 222)
      ORDER BY menuid DESC
      LIMIT 0, 1
  17. SELECT id
      FROM `jos_components`
      WHERE `link` LIKE '%com_reddesign%'
  18. SELECT p.*, c.category_id, c.category_name, m.manufacturer_name ,s.supplier_name 
      FROM (jos_redshop_category AS c ,jos_redshop_product AS p , jos_redshop_product_category_xref AS pcr ) 
      LEFT JOIN jos_redshop_manufacturer AS m
      ON m.manufacturer_id = p.manufacturer_id 
      LEFT JOIN jos_redshop_supplier AS s
      ON s.supplier_id = p.supplier_id   
      WHERE p.product_id=86
      AND pcr.product_id=86
      AND pcr.category_id=c.category_id 
      AND p.published = 1
  19. SELECT  min_del_time AS deltime, s.max_del_time, s.delivery_time 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 86
      AND ps.stockroom_id = s.stockroom_id
      AND ps.quantity >0
      ORDER BY min_del_time ASC
      LIMIT 0,1
  20. SELECT *
      FROM jos_redshop_product AS p, jos_redshop_template AS t
      WHERE t.template_id = p.product_template
      AND t.template_section='product'
      AND p.product_id=86
      AND t.published = 1
      LIMIT 0,1
  21. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 86
  22. SELECT p.price_id,p.product_price,p.product_currency 
      FROM jos_redshop_product_price AS
      WHERE  p.product_id = 86
      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
  23. SELECT *
      FROM jos_redshop_discount_product_shoppers AS ps
      WHERE ps.shopper_group_id ='0'
  24. SELECT *
      FROM jos_redshop_discount_product 
      WHERE amount <= 0
      AND discount_product_id IN (0) 
      AND published =1
      AND start_date <= '1753928799'
      AND end_date >= '1753928799' 
      ORDER BY amount DESC
      LIMIT 0,1
  25. SELECT *
      FROM jos_menu
      WHERE id = '222'
  26. SELECT sef_url,product_name,cat_in_sefurl
      FROM jos_redshop_product
      WHERE product_id = '86'
  27. SELECT c.category_id
      FROM jos_redshop_category c,jos_redshop_product_category_xref pc
      WHERE pc.product_id = '86'
      AND pc.category_id = c.category_id 
      AND c.category_id = '57'
  28. 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='57'
      AND c.category_id = cx.category_parent_id
  29. SELECT c.category_id,c.category_name ,cx.category_child_id,cx.category_parent_id
      FROM jos_redshop_category_xref AS cx, jos_redshop_category AS c
      WHERE cx.category_child_id='56'
      AND c.category_id = cx.category_parent_id
  30. SELECT category_name
      FROM jos_redshop_category
      WHERE category_id = '57'
  31. SELECT *
      FROM jos_redshop_fields
      WHERE field_section='1'
      AND published=1 
      AND field_name IN ('product_desc','product_thumb_image','more_images','product_s_desc','manufacturer_link','related_product:Related Products')
  32. SELECT *
      FROM jos_redshop_manufacturer
      WHERE manufacturer_id = 5
  33. SELECT *
      FROM jos_menu
      WHERE id = '222'
  34. SELECT sef_url,manufacturer_name
      FROM jos_redshop_manufacturer
      WHERE manufacturer_id = '5'
  35. SELECT product_id AS value,product_name AS text
                                           
      FROM `jos_redshop_product`
                                           
      WHERE `product_parent_id` =86
  36. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 86
      AND ps.stockroom_id = s.stockroom_id
  37. SELECT p.* 
      FROM jos_redshop_product AS p   
      WHERE  p.product_id = 86
  38. SELECT p.price_id,p.product_price,p.product_currency 
      FROM jos_redshop_product_price AS
      WHERE  p.product_id = 86
      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
  39. SELECT *
      FROM jos_redshop_discount_product_shoppers AS ps
      WHERE ps.shopper_group_id ='0'
  40. SELECT *
      FROM jos_redshop_discount_product 
      WHERE amount <= 0
      AND discount_product_id IN (0) 
      AND published =1
      AND start_date <= '1753928799'
      AND end_date >= '1753928799' 
      ORDER BY amount DESC
      LIMIT 0,1
  41. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 86
  42. 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
  43. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 86
  44. 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
  45. 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'
  46. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 86
  47. 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
  48. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 86
  49. 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
  50. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 86
      AND ps.stockroom_id = s.stockroom_id
  51. SELECT p.* 
      FROM jos_redshop_product_price AS
      WHERE  p.product_id = 86
      AND p.shopper_group_id = '0' 
      ORDER BY price_quantity_start ASC
  52. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 86
      AND discount_enddate>='1753928799'
      AND discount_stratdate<='1753928799'
  53. SELECT *
      FROM jos_redshop_media AS m
      LEFT JOIN jos_redshop_product AS p
      ON p.product_id = m.section_id
      WHERE m.media_section = 'product'
      AND media_type='images'
      AND m.section_id=86
      AND m.published = 1
  54. SELECT *
      FROM jos_redshop_media 
      WHERE media_section = "product"
      AND section_id ="86"
      AND media_type="images" 
      AND media_id="355"
  55. SELECT *
      FROM jos_redshop_media 
      WHERE media_section = "product"
      AND section_id ="86"
      AND media_type="images" 
      AND media_id="356"
  56. SELECT *
      FROM jos_redshop_media 
      WHERE media_section = "product"
      AND section_id ="86"
      AND media_type="images" 
      AND media_id="357"
  57. SELECT *
      FROM jos_redshop_media 
      WHERE media_section = "product"
      AND section_id ="86"
      AND media_type="images" 
      AND media_id="358"
  58. SELECT *
      FROM jos_redshop_media 
      WHERE media_section = "product"
      AND section_id ="86"
      AND media_type="images" 
      AND media_id="359"
  59. SELECT *
      FROM jos_redshop_media 
      WHERE media_section = "product"
      AND section_id ="86"
      AND media_type="images" 
      AND media_id="360"
  60. SELECT *
      FROM jos_redshop_wrapper
      WHERE published = 1
      AND (FIND_IN_SET(86,product_id)  OR wrapper_use_to_all = 1  )
  61. SELECT *
      FROM jos_redshop_template
      WHERE template_section LIKE 'wrapper_template'
      AND published=1
  62. SELECT *
      FROM jos_redshop_template
      WHERE template_section LIKE 'attribute_template'
      AND published=1
  63. SELECT a.attribute_id AS value,a.attribute_name AS text,a.*
      FROM jos_redshop_product AS p , jos_redshop_product_attribute AS a
      WHERE a.product_id = p.product_id
      AND p.product_id=86
      AND p.published = 1
      ORDER BY a.ordering ASC
  64. SELECT *
      FROM jos_redshop_template
      WHERE template_section LIKE 'accessory_template'
      AND published=1
  65. SELECT *
      FROM jos_redshop_template
      WHERE template_section LIKE 'review'
      AND published=1
      LIMIT 0,1
  66. SELECT ui.firstname,ui.lastname,pr.*
      FROM jos_redshop_product_rating AS pr, jos_users AS u, jos_redshop_users_info AS ui
      WHERE pr.product_id=86
      AND pr.published = 1
      AND pr.userid=u.id
      AND ui.user_id=u.id
      AND ui.address_type LIKE 'BT'
      ORDER BY pr.favoured DESC
  67. SELECT pr.*
      FROM jos_redshop_product_rating AS pr
      WHERE pr.product_id=86
      AND pr.published = 1
  68. SELECT sum(user_rating) AS rating
      FROM jos_redshop_product_rating AS pr
      WHERE pr.product_id=86
      AND pr.published = 1
  69. SELECT *
      FROM jos_redshop_fields
      WHERE field_section='12'
      AND field_name=''
      AND published=1
      AND field_show_in_front=1
  70. SELECT
      FROM jos_redshop_product AS
      WHERE  p.product_id = 86
  71. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 86
      AND ps.stockroom_id = s.stockroom_id
  72. SELECT
      FROM jos_modules
      WHERE `module` LIKE 'mod_redmagicmagnifyplus'
      AND published  = 1
  73. SELECT *
      FROM jos_redshop_media 
      WHERE media_section = "product"
      AND section_id ="86"
      AND media_type="images" 
      AND media_name = "1307552016_CK2570-18.jpg"
  74. SELECT *
      FROM jos_redshop_template
      WHERE template_section LIKE 'add_to_cart'
      AND published=1
  75. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 86
      AND ps.stockroom_id = s.stockroom_id
  76. SELECT p.* 
      FROM jos_redshop_product AS p   
      WHERE  p.product_id = 86
  77. SELECT p.price_id,p.product_price,p.product_currency 
      FROM jos_redshop_product_price AS
      WHERE  p.product_id = 86
      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
  78. SELECT *
      FROM jos_redshop_discount_product_shoppers AS ps
      WHERE ps.shopper_group_id ='0'
  79. SELECT *
      FROM jos_redshop_discount_product 
      WHERE amount <= 0
      AND discount_product_id IN (0) 
      AND published =1
      AND start_date <= '1753928799'
      AND end_date >= '1753928799' 
      ORDER BY amount DESC
      LIMIT 0,1
  80. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 86
  81. 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
  82. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 86
  83. 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
  84. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 86
      AND discount_enddate>='1753928799'
      AND discount_stratdate<='1753928799'
  85. 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'
  86. SELECT *
      FROM jos_redshop_fields
      WHERE field_section='12'
      AND field_name=''
      AND published=1
      AND field_show_in_front=1
  87. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 86
      AND ps.stockroom_id = s.stockroom_id
  88. SELECT p.* 
      FROM jos_redshop_product AS p   
      WHERE  p.product_id = 86
  89. SELECT p.price_id,p.product_price,p.product_currency 
      FROM jos_redshop_product_price AS
      WHERE  p.product_id = 86
      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
  90. SELECT *
      FROM jos_redshop_discount_product_shoppers AS ps
      WHERE ps.shopper_group_id ='0'
  91. SELECT *
      FROM jos_redshop_discount_product 
      WHERE amount <= 0
      AND discount_product_id IN (0) 
      AND published =1
      AND start_date <= '1753928799'
      AND end_date >= '1753928799' 
      ORDER BY amount DESC
      LIMIT 0,1
  92. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 86
  93. 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
  94. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 86
  95. 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
  96. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 86
      AND discount_enddate>='1753928799'
      AND discount_stratdate<='1753928799'
  97. 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'
  98. SELECT *
      FROM jos_redshop_fields
      WHERE field_section='12'
      AND field_name=''
      AND published=1
      AND field_show_in_front=1
  99. UPDATE jos_redshop_product
      SET `visited` = visited + 1
      WHERE `product_id` = '86'
  100. SELECT p.product_name,pcx.category_id
      FROM jos_redshop_product AS p,jos_redshop_product_category_xref AS pcx
      WHERE p.product_id = 86
      AND p.product_id = pcx.product_id
  101. SELECT c.category_id,c.category_name ,cx.category_child_id,cx.category_parent_id
      FROM jos_redshop_category_xref AS cx, jos_redshop_category AS c
      WHERE cx.category_child_id=''
      AND c.category_id = cx.category_parent_id
  102. SELECT pcx.product_id,p.product_name
      FROM jos_redshop_product AS p,jos_redshop_product_category_xref AS pcx
      WHERE pcx.category_id=57
      AND pcx.product_id=p.product_id
      ORDER BY pcx.product_id
  103. SELECT *
      FROM jos_menu
      WHERE id = '222'
  104. SELECT sef_url,product_name,cat_in_sefurl
      FROM jos_redshop_product
      WHERE product_id = '94'
  105. SELECT c.category_id
      FROM jos_redshop_category c,jos_redshop_product_category_xref pc
      WHERE pc.product_id = '94'
      AND pc.category_id = c.category_id 
      AND c.category_id = '57'
  106. 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='57'
      AND c.category_id = cx.category_parent_id
  107. 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='56'
      AND c.category_id = cx.category_parent_id
  108. SELECT category_name
      FROM jos_redshop_category
      WHERE category_id = '57'
  109. SELECT *
      FROM jos_redshop_textlibrary
      WHERE published=1
  110. SELECT *
      FROM jos_menu
      WHERE link LIKE '%com_redshop%'
      AND published=1
      AND id = '222'
  111. SELECT category_id
      FROM jos_redshop_product_category_xref
      WHERE product_id=86
  112. SELECT *
      FROM jos_menu
      WHERE link LIKE '%com_redshop%'
      AND published=1 
      AND link LIKE '%view=category%' 
      AND params NOT LIKE '%categoryid%'
  113. SELECT *
      FROM jos_menu
      WHERE link LIKE '%com_redshop%'
      AND published=1 
      AND link LIKE '%view=product%' 
      AND params  LIKE '%productid=86
    %'
  114. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 86
  115. SELECT *
      FROM jos_redshop_template
      WHERE template_section LIKE 'related_product'
      AND published=1
  116. SELECT *
      FROM jos_redshop_product AS p ,jos_redshop_product_related  AS r
      WHERE r.related_id = p.product_id
      AND r.product_id=86
      AND p.published = 1
  117. SELECT *
      FROM jos_redshop_template
      WHERE template_section LIKE 'add_to_cart'
      AND published=1
  118. SELECT *
      FROM jos_menu
      WHERE id = '222'
  119. SELECT sef_url,product_name,cat_in_sefurl
      FROM jos_redshop_product
      WHERE product_id = '92'
  120. SELECT c.category_id
      FROM jos_redshop_category c,jos_redshop_product_category_xref pc
      WHERE pc.product_id = '92'
      AND pc.category_id = c.category_id 
      AND c.category_id = '59'
  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='59'
      AND c.category_id = cx.category_parent_id
  122. 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='56'
      AND c.category_id = cx.category_parent_id
  123. SELECT category_name
      FROM jos_redshop_category
      WHERE category_id = '59'
  124. SELECT
      FROM jos_redshop_product AS
      WHERE  p.product_id = 92
  125. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 92
      AND ps.stockroom_id = s.stockroom_id
  126. SELECT
      FROM jos_modules
      WHERE `module` LIKE 'mod_redmagicmagnifyplus'
      AND published  = 1
  127. SELECT *
      FROM jos_redshop_media 
      WHERE media_section = "product"
      AND section_id ="92"
      AND media_type="images" 
      AND media_name = "1307561491_StarsHearts1.jpg"
  128. SELECT p.* 
      FROM jos_redshop_product AS p   
      WHERE  p.product_id = 92
  129. SELECT p.price_id,p.product_price,p.product_currency 
      FROM jos_redshop_product_price AS
      WHERE  p.product_id = 92
      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
  130. SELECT *
      FROM jos_redshop_discount_product_shoppers AS ps
      WHERE ps.shopper_group_id ='0'
  131. SELECT *
      FROM jos_redshop_discount_product 
      WHERE amount <= 0
      AND discount_product_id IN (0) 
      AND published =1
      AND start_date <= '1753928799'
      AND end_date >= '1753928799' 
      ORDER BY amount DESC
      LIMIT 0,1
  132. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 92
  133. 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
  134. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 92
  135. 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
  136. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 92
      AND discount_enddate>='1753928799'
      AND discount_stratdate<='1753928799'
  137. SELECT p.* 
      FROM jos_redshop_product AS p   
      WHERE  p.product_id = 92
  138. SELECT p.price_id,p.product_price,p.product_currency 
      FROM jos_redshop_product_price AS
      WHERE  p.product_id = 92
      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
  139. SELECT *
      FROM jos_redshop_discount_product_shoppers AS ps
      WHERE ps.shopper_group_id ='0'
  140. SELECT *
      FROM jos_redshop_discount_product 
      WHERE amount <= 0
      AND discount_product_id IN (0) 
      AND published =1
      AND start_date <= '1753928799'
      AND end_date >= '1753928799' 
      ORDER BY amount DESC
      LIMIT 0,1
  141. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 92
  142. 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
  143. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 92
  144. 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
  145. 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'
  146. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 92
      AND ps.stockroom_id = s.stockroom_id
  147. SELECT p.* 
      FROM jos_redshop_product_price AS
      WHERE  p.product_id = 92
      AND p.shopper_group_id = '0' 
      ORDER BY price_quantity_start ASC
  148. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 92
      AND discount_enddate>='1753928799'
      AND discount_stratdate<='1753928799'
  149. SELECT *
      FROM jos_menu
      WHERE id = '222'
  150. SELECT sef_url,product_name,cat_in_sefurl
      FROM jos_redshop_product
      WHERE product_id = '92'
  151. SELECT c.category_id
      FROM jos_redshop_category c,jos_redshop_product_category_xref pc
      WHERE pc.product_id = '92'
      AND pc.category_id = c.category_id 
      AND c.category_id = '59'
  152. 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='59'
      AND c.category_id = cx.category_parent_id
  153. 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='56'
      AND c.category_id = cx.category_parent_id
  154. SELECT category_name
      FROM jos_redshop_category
      WHERE category_id = '59'
  155. SELECT a.attribute_id AS value,a.attribute_name AS text,a.attribute_required
      FROM jos_redshop_product AS p, jos_redshop_product_attribute AS a
      WHERE a.product_id = p.product_id
      AND p.product_id=92
      AND p.published = 1
      AND a.attribute_required = 1
      ORDER BY a.ordering ASC
  156. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 92
      AND ps.stockroom_id = s.stockroom_id
  157. SELECT count(a.attribute_id)
      FROM jos_redshop_product AS p , jos_redshop_product_attribute AS a
      WHERE a.product_id = p.product_id
      AND p.product_id=92
      AND p.published = 1
      ORDER BY a.ordering ASC
  158. 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'
  159. SELECT p.* 
      FROM jos_redshop_product AS p   
      WHERE  p.product_id = 92
  160. SELECT p.price_id,p.product_price,p.product_currency 
      FROM jos_redshop_product_price AS
      WHERE  p.product_id = 92
      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
  161. SELECT *
      FROM jos_redshop_discount_product_shoppers AS ps
      WHERE ps.shopper_group_id ='0'
  162. SELECT *
      FROM jos_redshop_discount_product 
      WHERE amount <= 0
      AND discount_product_id IN (0) 
      AND published =1
      AND start_date <= '1753928799'
      AND end_date >= '1753928799' 
      ORDER BY amount DESC
      LIMIT 0,1
  163. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 92
  164. 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
  165. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 92
  166. 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
  167. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 92
      AND discount_enddate>='1753928799'
      AND discount_stratdate<='1753928799'
  168. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 92
      AND ps.stockroom_id = s.stockroom_id
  169. SELECT count(a.attribute_id)
      FROM jos_redshop_product AS p , jos_redshop_product_attribute AS a
      WHERE a.product_id = p.product_id
      AND p.product_id=92
      AND p.published = 1
      ORDER BY a.ordering ASC
  170. 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'
  171. SELECT p.* 
      FROM jos_redshop_product AS p   
      WHERE  p.product_id = 92
  172. SELECT p.price_id,p.product_price,p.product_currency 
      FROM jos_redshop_product_price AS
      WHERE  p.product_id = 92
      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
  173. SELECT *
      FROM jos_redshop_discount_product_shoppers AS ps
      WHERE ps.shopper_group_id ='0'
  174. SELECT *
      FROM jos_redshop_discount_product 
      WHERE amount <= 0
      AND discount_product_id IN (0) 
      AND published =1
      AND start_date <= '1753928799'
      AND end_date >= '1753928799' 
      ORDER BY amount DESC
      LIMIT 0,1
  175. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 92
  176. 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
  177. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 92
  178. 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
  179. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 92
      AND discount_enddate>='1753928799'
      AND discount_stratdate<='1753928799'
  180. SELECT *
      FROM jos_redshop_template
      WHERE template_section LIKE 'add_to_cart'
      AND published=1
  181. SELECT *
      FROM jos_menu
      WHERE id = '222'
  182. SELECT sef_url,product_name,cat_in_sefurl
      FROM jos_redshop_product
      WHERE product_id = '90'
  183. SELECT c.category_id
      FROM jos_redshop_category c,jos_redshop_product_category_xref pc
      WHERE pc.product_id = '90'
      AND pc.category_id = c.category_id 
      AND c.category_id = '58'
  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='58'
      AND c.category_id = cx.category_parent_id
  185. 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='56'
      AND c.category_id = cx.category_parent_id
  186. SELECT category_name
      FROM jos_redshop_category
      WHERE category_id = '58'
  187. SELECT
      FROM jos_redshop_product AS
      WHERE  p.product_id = 90
  188. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 90
      AND ps.stockroom_id = s.stockroom_id
  189. SELECT
      FROM jos_modules
      WHERE `module` LIKE 'mod_redmagicmagnifyplus'
      AND published  = 1
  190. SELECT *
      FROM jos_redshop_media 
      WHERE media_section = "product"
      AND section_id ="90"
      AND media_type="images" 
      AND media_name = "1307558555_GIR9404-1B.jpg"
  191. SELECT p.* 
      FROM jos_redshop_product AS p   
      WHERE  p.product_id = 90
  192. SELECT p.price_id,p.product_price,p.product_currency 
      FROM jos_redshop_product_price AS
      WHERE  p.product_id = 90
      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
  193. SELECT *
      FROM jos_redshop_discount_product_shoppers AS ps
      WHERE ps.shopper_group_id ='0'
  194. SELECT *
      FROM jos_redshop_discount_product 
      WHERE amount <= 0
      AND discount_product_id IN (0) 
      AND published =1
      AND start_date <= '1753928799'
      AND end_date >= '1753928799' 
      ORDER BY amount DESC
      LIMIT 0,1
  195. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 90
  196. 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
  197. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 90
  198. 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
  199. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 90
      AND discount_enddate>='1753928799'
      AND discount_stratdate<='1753928799'
  200. SELECT p.* 
      FROM jos_redshop_product AS p   
      WHERE  p.product_id = 90
  201. SELECT p.price_id,p.product_price,p.product_currency 
      FROM jos_redshop_product_price AS
      WHERE  p.product_id = 90
      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
  202. SELECT *
      FROM jos_redshop_discount_product_shoppers AS ps
      WHERE ps.shopper_group_id ='0'
  203. SELECT *
      FROM jos_redshop_discount_product 
      WHERE amount <= 0
      AND discount_product_id IN (0) 
      AND published =1
      AND start_date <= '1753928799'
      AND end_date >= '1753928799' 
      ORDER BY amount DESC
      LIMIT 0,1
  204. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 90
  205. 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
  206. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 90
  207. 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
  208. 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'
  209. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 90
      AND ps.stockroom_id = s.stockroom_id
  210. SELECT p.* 
      FROM jos_redshop_product_price AS
      WHERE  p.product_id = 90
      AND p.shopper_group_id = '0' 
      ORDER BY price_quantity_start ASC
  211. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 90
      AND discount_enddate>='1753928799'
      AND discount_stratdate<='1753928799'
  212. SELECT *
      FROM jos_menu
      WHERE id = '222'
  213. SELECT sef_url,product_name,cat_in_sefurl
      FROM jos_redshop_product
      WHERE product_id = '90'
  214. SELECT c.category_id
      FROM jos_redshop_category c,jos_redshop_product_category_xref pc
      WHERE pc.product_id = '90'
      AND pc.category_id = c.category_id 
      AND c.category_id = '58'
  215. 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='58'
      AND c.category_id = cx.category_parent_id
  216. 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='56'
      AND c.category_id = cx.category_parent_id
  217. SELECT category_name
      FROM jos_redshop_category
      WHERE category_id = '58'
  218. SELECT a.attribute_id AS value,a.attribute_name AS text,a.attribute_required
      FROM jos_redshop_product AS p, jos_redshop_product_attribute AS a
      WHERE a.product_id = p.product_id
      AND p.product_id=90
      AND p.published = 1
      AND a.attribute_required = 1
      ORDER BY a.ordering ASC
  219. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 90
      AND ps.stockroom_id = s.stockroom_id
  220. SELECT count(a.attribute_id)
      FROM jos_redshop_product AS p , jos_redshop_product_attribute AS a
      WHERE a.product_id = p.product_id
      AND p.product_id=90
      AND p.published = 1
      ORDER BY a.ordering ASC
  221. 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'
  222. SELECT p.* 
      FROM jos_redshop_product AS p   
      WHERE  p.product_id = 90
  223. SELECT p.price_id,p.product_price,p.product_currency 
      FROM jos_redshop_product_price AS
      WHERE  p.product_id = 90
      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
  224. SELECT *
      FROM jos_redshop_discount_product_shoppers AS ps
      WHERE ps.shopper_group_id ='0'
  225. SELECT *
      FROM jos_redshop_discount_product 
      WHERE amount <= 0
      AND discount_product_id IN (0) 
      AND published =1
      AND start_date <= '1753928799'
      AND end_date >= '1753928799' 
      ORDER BY amount DESC
      LIMIT 0,1
  226. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 90
  227. 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
  228. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 90
  229. 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
  230. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 90
      AND discount_enddate>='1753928799'
      AND discount_stratdate<='1753928799'
  231. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 90
      AND ps.stockroom_id = s.stockroom_id
  232. SELECT count(a.attribute_id)
      FROM jos_redshop_product AS p , jos_redshop_product_attribute AS a
      WHERE a.product_id = p.product_id
      AND p.product_id=90
      AND p.published = 1
      ORDER BY a.ordering ASC
  233. 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'
  234. SELECT p.* 
      FROM jos_redshop_product AS p   
      WHERE  p.product_id = 90
  235. SELECT p.price_id,p.product_price,p.product_currency 
      FROM jos_redshop_product_price AS
      WHERE  p.product_id = 90
      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
  236. SELECT *
      FROM jos_redshop_discount_product_shoppers AS ps
      WHERE ps.shopper_group_id ='0'
  237. SELECT *
      FROM jos_redshop_discount_product 
      WHERE amount <= 0
      AND discount_product_id IN (0) 
      AND published =1
      AND start_date <= '1753928799'
      AND end_date >= '1753928799' 
      ORDER BY amount DESC
      LIMIT 0,1
  238. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 90
  239. 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
  240. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 90
  241. 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
  242. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 90
      AND discount_enddate>='1753928799'
      AND discount_stratdate<='1753928799'
  243. SELECT *
      FROM jos_redshop_template
      WHERE template_section LIKE 'add_to_cart'
      AND published=1
  244. SELECT *
      FROM jos_menu
      WHERE id = '222'
  245. SELECT sef_url,product_name,cat_in_sefurl
      FROM jos_redshop_product
      WHERE product_id = '87'
  246. SELECT c.category_id
      FROM jos_redshop_category c,jos_redshop_product_category_xref pc
      WHERE pc.product_id = '87'
      AND pc.category_id = c.category_id 
      AND c.category_id = '58'
  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='58'
      AND c.category_id = cx.category_parent_id
  248. 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='56'
      AND c.category_id = cx.category_parent_id
  249. SELECT category_name
      FROM jos_redshop_category
      WHERE category_id = '58'
  250. SELECT
      FROM jos_redshop_product AS
      WHERE  p.product_id = 87
  251. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 87
      AND ps.stockroom_id = s.stockroom_id
  252. SELECT
      FROM jos_modules
      WHERE `module` LIKE 'mod_redmagicmagnifyplus'
      AND published  = 1
  253. SELECT *
      FROM jos_redshop_media 
      WHERE media_section = "product"
      AND section_id ="87"
      AND media_type="images" 
      AND media_name = "1307553969_GIR9405-1B.jpg"
  254. SELECT p.* 
      FROM jos_redshop_product AS p   
      WHERE  p.product_id = 87
  255. SELECT p.price_id,p.product_price,p.product_currency 
      FROM jos_redshop_product_price AS
      WHERE  p.product_id = 87
      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
  256. SELECT *
      FROM jos_redshop_discount_product_shoppers AS ps
      WHERE ps.shopper_group_id ='0'
  257. SELECT *
      FROM jos_redshop_discount_product 
      WHERE amount <= 0
      AND discount_product_id IN (0) 
      AND published =1
      AND start_date <= '1753928799'
      AND end_date >= '1753928799' 
      ORDER BY amount DESC
      LIMIT 0,1
  258. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 87
  259. 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
  260. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 87
  261. 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
  262. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 87
      AND discount_enddate>='1753928799'
      AND discount_stratdate<='1753928799'
  263. SELECT p.* 
      FROM jos_redshop_product AS p   
      WHERE  p.product_id = 87
  264. SELECT p.price_id,p.product_price,p.product_currency 
      FROM jos_redshop_product_price AS
      WHERE  p.product_id = 87
      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
  265. SELECT *
      FROM jos_redshop_discount_product_shoppers AS ps
      WHERE ps.shopper_group_id ='0'
  266. SELECT *
      FROM jos_redshop_discount_product 
      WHERE amount <= 0
      AND discount_product_id IN (0) 
      AND published =1
      AND start_date <= '1753928799'
      AND end_date >= '1753928799' 
      ORDER BY amount DESC
      LIMIT 0,1
  267. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 87
  268. 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
  269. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 87
  270. 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
  271. 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'
  272. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 87
      AND ps.stockroom_id = s.stockroom_id
  273. SELECT p.* 
      FROM jos_redshop_product_price AS
      WHERE  p.product_id = 87
      AND p.shopper_group_id = '0' 
      ORDER BY price_quantity_start ASC
  274. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 87
      AND discount_enddate>='1753928799'
      AND discount_stratdate<='1753928799'
  275. SELECT *
      FROM jos_menu
      WHERE id = '222'
  276. SELECT sef_url,product_name,cat_in_sefurl
      FROM jos_redshop_product
      WHERE product_id = '87'
  277. SELECT c.category_id
      FROM jos_redshop_category c,jos_redshop_product_category_xref pc
      WHERE pc.product_id = '87'
      AND pc.category_id = c.category_id 
      AND c.category_id = '58'
  278. 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='58'
      AND c.category_id = cx.category_parent_id
  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='56'
      AND c.category_id = cx.category_parent_id
  280. SELECT category_name
      FROM jos_redshop_category
      WHERE category_id = '58'
  281. SELECT a.attribute_id AS value,a.attribute_name AS text,a.attribute_required
      FROM jos_redshop_product AS p, jos_redshop_product_attribute AS a
      WHERE a.product_id = p.product_id
      AND p.product_id=87
      AND p.published = 1
      AND a.attribute_required = 1
      ORDER BY a.ordering ASC
  282. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 87
      AND ps.stockroom_id = s.stockroom_id
  283. SELECT count(a.attribute_id)
      FROM jos_redshop_product AS p , jos_redshop_product_attribute AS a
      WHERE a.product_id = p.product_id
      AND p.product_id=87
      AND p.published = 1
      ORDER BY a.ordering ASC
  284. 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'
  285. SELECT p.* 
      FROM jos_redshop_product AS p   
      WHERE  p.product_id = 87
  286. SELECT p.price_id,p.product_price,p.product_currency 
      FROM jos_redshop_product_price AS
      WHERE  p.product_id = 87
      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
  287. SELECT *
      FROM jos_redshop_discount_product_shoppers AS ps
      WHERE ps.shopper_group_id ='0'
  288. SELECT *
      FROM jos_redshop_discount_product 
      WHERE amount <= 0
      AND discount_product_id IN (0) 
      AND published =1
      AND start_date <= '1753928799'
      AND end_date >= '1753928799' 
      ORDER BY amount DESC
      LIMIT 0,1
  289. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 87
  290. 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
  291. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 87
  292. 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
  293. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 87
      AND discount_enddate>='1753928799'
      AND discount_stratdate<='1753928799'
  294. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 87
      AND ps.stockroom_id = s.stockroom_id
  295. SELECT count(a.attribute_id)
      FROM jos_redshop_product AS p , jos_redshop_product_attribute AS a
      WHERE a.product_id = p.product_id
      AND p.product_id=87
      AND p.published = 1
      ORDER BY a.ordering ASC
  296. 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'
  297. SELECT p.* 
      FROM jos_redshop_product AS p   
      WHERE  p.product_id = 87
  298. SELECT p.price_id,p.product_price,p.product_currency 
      FROM jos_redshop_product_price AS
      WHERE  p.product_id = 87
      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
  299. SELECT *
      FROM jos_redshop_discount_product_shoppers AS ps
      WHERE ps.shopper_group_id ='0'
  300. SELECT *
      FROM jos_redshop_discount_product 
      WHERE amount <= 0
      AND discount_product_id IN (0) 
      AND published =1
      AND start_date <= '1753928799'
      AND end_date >= '1753928799' 
      ORDER BY amount DESC
      LIMIT 0,1
  301. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 87
  302. 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
  303. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 87
  304. 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
  305. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 87
      AND discount_enddate>='1753928799'
      AND discount_stratdate<='1753928799'
  306. SELECT *
      FROM jos_redshop_template
      WHERE template_section LIKE 'add_to_cart'
      AND published=1
  307. SELECT *
      FROM jos_menu
      WHERE id = '222'
  308. SELECT sef_url,product_name,cat_in_sefurl
      FROM jos_redshop_product
      WHERE product_id = '88'
  309. SELECT c.category_id
      FROM jos_redshop_category c,jos_redshop_product_category_xref pc
      WHERE pc.product_id = '88'
      AND pc.category_id = c.category_id 
      AND c.category_id = '58'
  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='58'
      AND c.category_id = cx.category_parent_id
  311. 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='56'
      AND c.category_id = cx.category_parent_id
  312. SELECT category_name
      FROM jos_redshop_category
      WHERE category_id = '58'
  313. SELECT
      FROM jos_redshop_product AS
      WHERE  p.product_id = 88
  314. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 88
      AND ps.stockroom_id = s.stockroom_id
  315. SELECT
      FROM jos_modules
      WHERE `module` LIKE 'mod_redmagicmagnifyplus'
      AND published  = 1
  316. SELECT *
      FROM jos_redshop_media 
      WHERE media_section = "product"
      AND section_id ="88"
      AND media_type="images" 
      AND media_name = "1307555687_GIR9403-3B.jpg"
  317. SELECT p.* 
      FROM jos_redshop_product AS p   
      WHERE  p.product_id = 88
  318. SELECT p.price_id,p.product_price,p.product_currency 
      FROM jos_redshop_product_price AS
      WHERE  p.product_id = 88
      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
  319. SELECT *
      FROM jos_redshop_discount_product_shoppers AS ps
      WHERE ps.shopper_group_id ='0'
  320. SELECT *
      FROM jos_redshop_discount_product 
      WHERE amount <= 0
      AND discount_product_id IN (0) 
      AND published =1
      AND start_date <= '1753928799'
      AND end_date >= '1753928799' 
      ORDER BY amount DESC
      LIMIT 0,1
  321. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 88
  322. 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
  323. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 88
  324. 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
  325. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 88
      AND discount_enddate>='1753928799'
      AND discount_stratdate<='1753928799'
  326. SELECT p.* 
      FROM jos_redshop_product AS p   
      WHERE  p.product_id = 88
  327. SELECT p.price_id,p.product_price,p.product_currency 
      FROM jos_redshop_product_price AS
      WHERE  p.product_id = 88
      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
  328. SELECT *
      FROM jos_redshop_discount_product_shoppers AS ps
      WHERE ps.shopper_group_id ='0'
  329. SELECT *
      FROM jos_redshop_discount_product 
      WHERE amount <= 0
      AND discount_product_id IN (0) 
      AND published =1
      AND start_date <= '1753928799'
      AND end_date >= '1753928799' 
      ORDER BY amount DESC
      LIMIT 0,1
  330. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 88
  331. 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
  332. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 88
  333. 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
  334. 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'
  335. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 88
      AND ps.stockroom_id = s.stockroom_id
  336. SELECT p.* 
      FROM jos_redshop_product_price AS
      WHERE  p.product_id = 88
      AND p.shopper_group_id = '0' 
      ORDER BY price_quantity_start ASC
  337. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 88
      AND discount_enddate>='1753928799'
      AND discount_stratdate<='1753928799'
  338. SELECT *
      FROM jos_menu
      WHERE id = '222'
  339. SELECT sef_url,product_name,cat_in_sefurl
      FROM jos_redshop_product
      WHERE product_id = '88'
  340. SELECT c.category_id
      FROM jos_redshop_category c,jos_redshop_product_category_xref pc
      WHERE pc.product_id = '88'
      AND pc.category_id = c.category_id 
      AND c.category_id = '58'
  341. 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='58'
      AND c.category_id = cx.category_parent_id
  342. 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='56'
      AND c.category_id = cx.category_parent_id
  343. SELECT category_name
      FROM jos_redshop_category
      WHERE category_id = '58'
  344. SELECT a.attribute_id AS value,a.attribute_name AS text,a.attribute_required
      FROM jos_redshop_product AS p, jos_redshop_product_attribute AS a
      WHERE a.product_id = p.product_id
      AND p.product_id=88
      AND p.published = 1
      AND a.attribute_required = 1
      ORDER BY a.ordering ASC
  345. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 88
      AND ps.stockroom_id = s.stockroom_id
  346. SELECT count(a.attribute_id)
      FROM jos_redshop_product AS p , jos_redshop_product_attribute AS a
      WHERE a.product_id = p.product_id
      AND p.product_id=88
      AND p.published = 1
      ORDER BY a.ordering ASC
  347. 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'
  348. SELECT p.* 
      FROM jos_redshop_product AS p   
      WHERE  p.product_id = 88
  349. SELECT p.price_id,p.product_price,p.product_currency 
      FROM jos_redshop_product_price AS
      WHERE  p.product_id = 88
      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
  350. SELECT *
      FROM jos_redshop_discount_product_shoppers AS ps
      WHERE ps.shopper_group_id ='0'
  351. SELECT *
      FROM jos_redshop_discount_product 
      WHERE amount <= 0
      AND discount_product_id IN (0) 
      AND published =1
      AND start_date <= '1753928799'
      AND end_date >= '1753928799' 
      ORDER BY amount DESC
      LIMIT 0,1
  352. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 88
  353. 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
  354. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 88
  355. 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
  356. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 88
      AND discount_enddate>='1753928799'
      AND discount_stratdate<='1753928799'
  357. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 88
      AND ps.stockroom_id = s.stockroom_id
  358. SELECT count(a.attribute_id)
      FROM jos_redshop_product AS p , jos_redshop_product_attribute AS a
      WHERE a.product_id = p.product_id
      AND p.product_id=88
      AND p.published = 1
      ORDER BY a.ordering ASC
  359. 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'
  360. SELECT p.* 
      FROM jos_redshop_product AS p   
      WHERE  p.product_id = 88
  361. SELECT p.price_id,p.product_price,p.product_currency 
      FROM jos_redshop_product_price AS
      WHERE  p.product_id = 88
      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
  362. SELECT *
      FROM jos_redshop_discount_product_shoppers AS ps
      WHERE ps.shopper_group_id ='0'
  363. SELECT *
      FROM jos_redshop_discount_product 
      WHERE amount <= 0
      AND discount_product_id IN (0) 
      AND published =1
      AND start_date <= '1753928799'
      AND end_date >= '1753928799' 
      ORDER BY amount DESC
      LIMIT 0,1
  364. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 88
  365. 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
  366. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 88
  367. 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
  368. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 88
      AND discount_enddate>='1753928799'
      AND discount_stratdate<='1753928799'
  369. SELECT *
      FROM jos_redshop_template
      WHERE template_section LIKE 'add_to_cart'
      AND published=1
  370. SELECT *
      FROM jos_menu
      WHERE id = '222'
  371. SELECT sef_url,product_name,cat_in_sefurl
      FROM jos_redshop_product
      WHERE product_id = '89'
  372. SELECT c.category_id
      FROM jos_redshop_category c,jos_redshop_product_category_xref pc
      WHERE pc.product_id = '89'
      AND pc.category_id = c.category_id 
      AND c.category_id = '58'
  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='58'
      AND c.category_id = cx.category_parent_id
  374. 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='56'
      AND c.category_id = cx.category_parent_id
  375. SELECT category_name
      FROM jos_redshop_category
      WHERE category_id = '58'
  376. SELECT
      FROM jos_redshop_product AS
      WHERE  p.product_id = 89
  377. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 89
      AND ps.stockroom_id = s.stockroom_id
  378. SELECT
      FROM jos_modules
      WHERE `module` LIKE 'mod_redmagicmagnifyplus'
      AND published  = 1
  379. SELECT *
      FROM jos_redshop_media 
      WHERE media_section = "product"
      AND section_id ="89"
      AND media_type="images" 
      AND media_name = "1307556894_GIR9425-2B.jpg"
  380. SELECT p.* 
      FROM jos_redshop_product AS p   
      WHERE  p.product_id = 89
  381. SELECT p.price_id,p.product_price,p.product_currency 
      FROM jos_redshop_product_price AS
      WHERE  p.product_id = 89
      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
  382. SELECT *
      FROM jos_redshop_discount_product_shoppers AS ps
      WHERE ps.shopper_group_id ='0'
  383. SELECT *
      FROM jos_redshop_discount_product 
      WHERE amount <= 0
      AND discount_product_id IN (0) 
      AND published =1
      AND start_date <= '1753928799'
      AND end_date >= '1753928799' 
      ORDER BY amount DESC
      LIMIT 0,1
  384. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 89
  385. 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
  386. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 89
  387. 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
  388. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 89
      AND discount_enddate>='1753928799'
      AND discount_stratdate<='1753928799'
  389. SELECT p.* 
      FROM jos_redshop_product AS p   
      WHERE  p.product_id = 89
  390. SELECT p.price_id,p.product_price,p.product_currency 
      FROM jos_redshop_product_price AS
      WHERE  p.product_id = 89
      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
  391. SELECT *
      FROM jos_redshop_discount_product_shoppers AS ps
      WHERE ps.shopper_group_id ='0'
  392. SELECT *
      FROM jos_redshop_discount_product 
      WHERE amount <= 0
      AND discount_product_id IN (0) 
      AND published =1
      AND start_date <= '1753928799'
      AND end_date >= '1753928799' 
      ORDER BY amount DESC
      LIMIT 0,1
  393. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 89
  394. 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
  395. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 89
  396. 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
  397. 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'
  398. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 89
      AND ps.stockroom_id = s.stockroom_id
  399. SELECT p.* 
      FROM jos_redshop_product_price AS
      WHERE  p.product_id = 89
      AND p.shopper_group_id = '0' 
      ORDER BY price_quantity_start ASC
  400. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 89
      AND discount_enddate>='1753928799'
      AND discount_stratdate<='1753928799'
  401. SELECT *
      FROM jos_menu
      WHERE id = '222'
  402. SELECT sef_url,product_name,cat_in_sefurl
      FROM jos_redshop_product
      WHERE product_id = '89'
  403. SELECT c.category_id
      FROM jos_redshop_category c,jos_redshop_product_category_xref pc
      WHERE pc.product_id = '89'
      AND pc.category_id = c.category_id 
      AND c.category_id = '58'
  404. 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='58'
      AND c.category_id = cx.category_parent_id
  405. 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='56'
      AND c.category_id = cx.category_parent_id
  406. SELECT category_name
      FROM jos_redshop_category
      WHERE category_id = '58'
  407. SELECT a.attribute_id AS value,a.attribute_name AS text,a.attribute_required
      FROM jos_redshop_product AS p, jos_redshop_product_attribute AS a
      WHERE a.product_id = p.product_id
      AND p.product_id=89
      AND p.published = 1
      AND a.attribute_required = 1
      ORDER BY a.ordering ASC
  408. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 89
      AND ps.stockroom_id = s.stockroom_id
  409. SELECT count(a.attribute_id)
      FROM jos_redshop_product AS p , jos_redshop_product_attribute AS a
      WHERE a.product_id = p.product_id
      AND p.product_id=89
      AND p.published = 1
      ORDER BY a.ordering ASC
  410. 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'
  411. SELECT p.* 
      FROM jos_redshop_product AS p   
      WHERE  p.product_id = 89
  412. SELECT p.price_id,p.product_price,p.product_currency 
      FROM jos_redshop_product_price AS
      WHERE  p.product_id = 89
      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
  413. SELECT *
      FROM jos_redshop_discount_product_shoppers AS ps
      WHERE ps.shopper_group_id ='0'
  414. SELECT *
      FROM jos_redshop_discount_product 
      WHERE amount <= 0
      AND discount_product_id IN (0) 
      AND published =1
      AND start_date <= '1753928799'
      AND end_date >= '1753928799' 
      ORDER BY amount DESC
      LIMIT 0,1
  415. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 89
  416. 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
  417. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 89
  418. 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
  419. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 89
      AND discount_enddate>='1753928799'
      AND discount_stratdate<='1753928799'
  420. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 89
      AND ps.stockroom_id = s.stockroom_id
  421. SELECT count(a.attribute_id)
      FROM jos_redshop_product AS p , jos_redshop_product_attribute AS a
      WHERE a.product_id = p.product_id
      AND p.product_id=89
      AND p.published = 1
      ORDER BY a.ordering ASC
  422. 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'
  423. SELECT p.* 
      FROM jos_redshop_product AS p   
      WHERE  p.product_id = 89
  424. SELECT p.price_id,p.product_price,p.product_currency 
      FROM jos_redshop_product_price AS
      WHERE  p.product_id = 89
      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
  425. SELECT *
      FROM jos_redshop_discount_product_shoppers AS ps
      WHERE ps.shopper_group_id ='0'
  426. SELECT *
      FROM jos_redshop_discount_product 
      WHERE amount <= 0
      AND discount_product_id IN (0) 
      AND published =1
      AND start_date <= '1753928799'
      AND end_date >= '1753928799' 
      ORDER BY amount DESC
      LIMIT 0,1
  427. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 89
  428. 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
  429. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 89
  430. 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
  431. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 89
      AND discount_enddate>='1753928799'
      AND discount_stratdate<='1753928799'
  432. SELECT *
      FROM jos_redshop_template
      WHERE template_section LIKE 'add_to_cart'
      AND published=1
  433. SELECT *
      FROM jos_menu
      WHERE id = '222'
  434. SELECT sef_url,product_name,cat_in_sefurl
      FROM jos_redshop_product
      WHERE product_id = '91'
  435. SELECT c.category_id
      FROM jos_redshop_category c,jos_redshop_product_category_xref pc
      WHERE pc.product_id = '91'
      AND pc.category_id = c.category_id 
      AND c.category_id = '58'
  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='58'
      AND c.category_id = cx.category_parent_id
  437. 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='56'
      AND c.category_id = cx.category_parent_id
  438. SELECT category_name
      FROM jos_redshop_category
      WHERE category_id = '58'
  439. SELECT
      FROM jos_redshop_product AS
      WHERE  p.product_id = 91
  440. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 91
      AND ps.stockroom_id = s.stockroom_id
  441. SELECT
      FROM jos_modules
      WHERE `module` LIKE 'mod_redmagicmagnifyplus'
      AND published  = 1
  442. SELECT *
      FROM jos_redshop_media 
      WHERE media_section = "product"
      AND section_id ="91"
      AND media_type="images" 
      AND media_name = "1307559282_GIR9421-2B.jpg"
  443. SELECT p.* 
      FROM jos_redshop_product AS p   
      WHERE  p.product_id = 91
  444. SELECT p.price_id,p.product_price,p.product_currency 
      FROM jos_redshop_product_price AS
      WHERE  p.product_id = 91
      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
  445. SELECT *
      FROM jos_redshop_discount_product_shoppers AS ps
      WHERE ps.shopper_group_id ='0'
  446. SELECT *
      FROM jos_redshop_discount_product 
      WHERE amount <= 0
      AND discount_product_id IN (0) 
      AND published =1
      AND start_date <= '1753928799'
      AND end_date >= '1753928799' 
      ORDER BY amount DESC
      LIMIT 0,1
  447. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 91
  448. 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
  449. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 91
  450. 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
  451. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 91
      AND discount_enddate>='1753928799'
      AND discount_stratdate<='1753928799'
  452. SELECT p.* 
      FROM jos_redshop_product AS p   
      WHERE  p.product_id = 91
  453. SELECT p.price_id,p.product_price,p.product_currency 
      FROM jos_redshop_product_price AS
      WHERE  p.product_id = 91
      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
  454. SELECT *
      FROM jos_redshop_discount_product_shoppers AS ps
      WHERE ps.shopper_group_id ='0'
  455. SELECT *
      FROM jos_redshop_discount_product 
      WHERE amount <= 0
      AND discount_product_id IN (0) 
      AND published =1
      AND start_date <= '1753928799'
      AND end_date >= '1753928799' 
      ORDER BY amount DESC
      LIMIT 0,1
  456. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 91
  457. 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
  458. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 91
  459. 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
  460. 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'
  461. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 91
      AND ps.stockroom_id = s.stockroom_id
  462. SELECT p.* 
      FROM jos_redshop_product_price AS
      WHERE  p.product_id = 91
      AND p.shopper_group_id = '0' 
      ORDER BY price_quantity_start ASC
  463. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 91
      AND discount_enddate>='1753928799'
      AND discount_stratdate<='1753928799'
  464. SELECT *
      FROM jos_menu
      WHERE id = '222'
  465. SELECT sef_url,product_name,cat_in_sefurl
      FROM jos_redshop_product
      WHERE product_id = '91'
  466. SELECT c.category_id
      FROM jos_redshop_category c,jos_redshop_product_category_xref pc
      WHERE pc.product_id = '91'
      AND pc.category_id = c.category_id 
      AND c.category_id = '58'
  467. 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='58'
      AND c.category_id = cx.category_parent_id
  468. 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='56'
      AND c.category_id = cx.category_parent_id
  469. SELECT category_name
      FROM jos_redshop_category
      WHERE category_id = '58'
  470. SELECT a.attribute_id AS value,a.attribute_name AS text,a.attribute_required
      FROM jos_redshop_product AS p, jos_redshop_product_attribute AS a
      WHERE a.product_id = p.product_id
      AND p.product_id=91
      AND p.published = 1
      AND a.attribute_required = 1
      ORDER BY a.ordering ASC
  471. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 91
      AND ps.stockroom_id = s.stockroom_id
  472. SELECT count(a.attribute_id)
      FROM jos_redshop_product AS p , jos_redshop_product_attribute AS a
      WHERE a.product_id = p.product_id
      AND p.product_id=91
      AND p.published = 1
      ORDER BY a.ordering ASC
  473. 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'
  474. SELECT p.* 
      FROM jos_redshop_product AS p   
      WHERE  p.product_id = 91
  475. SELECT p.price_id,p.product_price,p.product_currency 
      FROM jos_redshop_product_price AS
      WHERE  p.product_id = 91
      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
  476. SELECT *
      FROM jos_redshop_discount_product_shoppers AS ps
      WHERE ps.shopper_group_id ='0'
  477. SELECT *
      FROM jos_redshop_discount_product 
      WHERE amount <= 0
      AND discount_product_id IN (0) 
      AND published =1
      AND start_date <= '1753928799'
      AND end_date >= '1753928799' 
      ORDER BY amount DESC
      LIMIT 0,1
  478. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 91
  479. 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
  480. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 91
  481. 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
  482. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 91
      AND discount_enddate>='1753928799'
      AND discount_stratdate<='1753928799'
  483. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 91
      AND ps.stockroom_id = s.stockroom_id
  484. SELECT count(a.attribute_id)
      FROM jos_redshop_product AS p , jos_redshop_product_attribute AS a
      WHERE a.product_id = p.product_id
      AND p.product_id=91
      AND p.published = 1
      ORDER BY a.ordering ASC
  485. 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'
  486. SELECT p.* 
      FROM jos_redshop_product AS p   
      WHERE  p.product_id = 91
  487. SELECT p.price_id,p.product_price,p.product_currency 
      FROM jos_redshop_product_price AS
      WHERE  p.product_id = 91
      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
  488. SELECT *
      FROM jos_redshop_discount_product_shoppers AS ps
      WHERE ps.shopper_group_id ='0'
  489. SELECT *
      FROM jos_redshop_discount_product 
      WHERE amount <= 0
      AND discount_product_id IN (0) 
      AND published =1
      AND start_date <= '1753928799'
      AND end_date >= '1753928799' 
      ORDER BY amount DESC
      LIMIT 0,1
  490. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 91
  491. 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
  492. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 91
  493. 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
  494. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 91
      AND discount_enddate>='1753928799'
      AND discount_stratdate<='1753928799'
  495. 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 = 222 OR mm.menuid = 0 )
      ORDER BY position, ordering
  496. SELECT *
      FROM jos_menu
      WHERE id = '71'
  497. SELECT *
      FROM jos_menu
      WHERE id = '222'
  498. SELECT category_id      
      FROM jos_redshop_product_category_xref cx
      WHERE product_id = ''
  499. 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'
  500. SELECT category_id AS value,category_name AS text
      FROM jos_redshop_category
      WHERE published = 1
  501. SELECT *
      FROM jos_menu
      WHERE id = '222'

Language Files Loaded

Untranslated Strings Diagnostic

None

Untranslated Strings Designer

None