GIR9430 Crazy Daisies Appliques

GIR9430
GIR9430
GIR9430

Easy Accent
Peel & Stick Appliques
Collection: Girls Rule
Packaged: TWO - 12"x19.5" (30.5x50cm)

 

 

Profile Information

Application afterLoad: 0.000 seconds, 0.29 MB
Application afterInitialise: 0.005 seconds, 0.96 MB
Application afterRoute: 0.010 seconds, 2.53 MB
Application afterDispatch: 4.958 seconds, 3.17 MB
Application afterRender: 4.967 seconds, 3.38 MB

Memory Usage

3574256

378 queries logged

  1. SELECT *
      FROM jos_session
      WHERE session_id = 'np52ks4so160075nm64qba8gt1'
  2. DELETE
      FROM jos_session
      WHERE ( time < '1746233754' )
  3. SELECT *
      FROM jos_session
      WHERE session_id = 'np52ks4so160075nm64qba8gt1'
  4. INSERT INTO `jos_session` ( `session_id`,`time`,`username`,`gid`,`guest`,`client_id` )
      VALUES ( 'np52ks4so160075nm64qba8gt1','1746240954','','0','1','0' )
  5. SELECT *
      FROM jos_components
      WHERE parent = 0
  6. SELECT folder AS type, element AS name, params
      FROM jos_plugins
      WHERE published >= 1
      AND access <= 0
      ORDER BY ordering
  7. SELECT m.*, c.`option` AS component
      FROM jos_menu AS m
      LEFT JOIN jos_components AS c
      ON m.componentid = c.id
      WHERE m.published = 1
      ORDER BY m.sublevel, m.parent, m.ordering
  8. SELECT *
      FROM jos_redshop_configuration
  9. SELECT *
      FROM jos_redshop_catalog_request
      WHERE block = 0
  10. SELECT *
      FROM jos_redshop_sample_request
      WHERE block = 0
  11. SELECT count(id)
      FROM jos_redshop_cron
      WHERE date = '2025-05-02'
  12. SELECT *
      FROM jos_redshop_siteviewer
      WHERE session_id = 'np52ks4so160075nm64qba8gt1'
  13. INSERT INTO jos_redshop_siteviewer (session_id, user_id, created_date)
      VALUES ('np52ks4so160075nm64qba8gt1', '0','1746240956')
  14. SELECT *
      FROM jos_redshop_pageviewer
      WHERE session_id = 'np52ks4so160075nm64qba8gt1'
      AND section='product'
      AND section_id='96'
  15. INSERT INTO jos_redshop_pageviewer (session_id, user_id, section, section_id, created_date)
      VALUES ('np52ks4so160075nm64qba8gt1','0','product','96','1746240959')
  16. SELECT sg.*
      FROM `jos_redshop_shopper_group` AS sg 
      WHERE  sg.`shopper_group_id` = 0
  17. SELECT template
      FROM jos_templates_menu
      WHERE client_id = 0
      AND (menuid = 0 OR menuid = 222)
      ORDER BY menuid DESC
      LIMIT 0, 1
  18. SELECT id
      FROM `jos_components`
      WHERE `link` LIKE '%com_reddesign%'
  19. 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=96
      AND pcr.product_id=96
      AND pcr.category_id=c.category_id 
      AND p.published = 1
  20. 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 = 96
      AND ps.stockroom_id = s.stockroom_id
      AND ps.quantity >0
      ORDER BY min_del_time ASC
      LIMIT 0,1
  21. 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=96
      AND t.published = 1
      LIMIT 0,1
  22. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 96
  23. SELECT p.price_id,p.product_price,p.product_currency 
      FROM jos_redshop_product_price AS
      WHERE  p.product_id = 96
      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
  24. SELECT *
      FROM jos_redshop_discount_product_shoppers AS ps
      WHERE ps.shopper_group_id ='0'
  25. SELECT *
      FROM jos_redshop_discount_product 
      WHERE amount <= 0
      AND discount_product_id IN (0) 
      AND published =1
      AND start_date <= '1746240959'
      AND end_date >= '1746240959' 
      ORDER BY amount DESC
      LIMIT 0,1
  26. SELECT *
      FROM jos_menu
      WHERE id = '222'
  27. SELECT sef_url,product_name,cat_in_sefurl
      FROM jos_redshop_product
      WHERE product_id = '96'
  28. SELECT c.category_id
      FROM jos_redshop_category c,jos_redshop_product_category_xref pc
      WHERE pc.product_id = '96'
      AND pc.category_id = c.category_id 
      AND c.category_id = '59'
  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='59'
      AND c.category_id = cx.category_parent_id
  30. 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
  31. SELECT category_name
      FROM jos_redshop_category
      WHERE category_id = '59'
  32. 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')
  33. SELECT *
      FROM jos_redshop_manufacturer
      WHERE manufacturer_id = 5
  34. SELECT *
      FROM jos_menu
      WHERE id = '222'
  35. SELECT sef_url,manufacturer_name
      FROM jos_redshop_manufacturer
      WHERE manufacturer_id = '5'
  36. SELECT product_id AS value,product_name AS text
                                           
      FROM `jos_redshop_product`
                                           
      WHERE `product_parent_id` =96
  37. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 96
      AND ps.stockroom_id = s.stockroom_id
  38. SELECT p.* 
      FROM jos_redshop_product AS p   
      WHERE  p.product_id = 96
  39. SELECT p.price_id,p.product_price,p.product_currency 
      FROM jos_redshop_product_price AS
      WHERE  p.product_id = 96
      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
  40. SELECT *
      FROM jos_redshop_discount_product_shoppers AS ps
      WHERE ps.shopper_group_id ='0'
  41. SELECT *
      FROM jos_redshop_discount_product 
      WHERE amount <= 0
      AND discount_product_id IN (0) 
      AND published =1
      AND start_date <= '1746240959'
      AND end_date >= '1746240959' 
      ORDER BY amount DESC
      LIMIT 0,1
  42. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 96
  43. 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
  44. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 96
  45. 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
  46. 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'
  47. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 96
  48. 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
  49. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 96
  50. 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
  51. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 96
      AND ps.stockroom_id = s.stockroom_id
  52. SELECT p.* 
      FROM jos_redshop_product_price AS
      WHERE  p.product_id = 96
      AND p.shopper_group_id = '0' 
      ORDER BY price_quantity_start ASC
  53. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 96
      AND discount_enddate>='1746240959'
      AND discount_stratdate<='1746240959'
  54. 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=96
      AND m.published = 1
  55. SELECT *
      FROM jos_redshop_media 
      WHERE media_section = "product"
      AND section_id ="96"
      AND media_type="images" 
      AND media_id="397"
  56. SELECT *
      FROM jos_redshop_media 
      WHERE media_section = "product"
      AND section_id ="96"
      AND media_type="images" 
      AND media_id="398"
  57. SELECT *
      FROM jos_redshop_wrapper
      WHERE published = 1
      AND (FIND_IN_SET(96,product_id)  OR wrapper_use_to_all = 1  )
  58. SELECT *
      FROM jos_redshop_template
      WHERE template_section LIKE 'wrapper_template'
      AND published=1
  59. SELECT *
      FROM jos_redshop_template
      WHERE template_section LIKE 'attribute_template'
      AND published=1
  60. 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=96
      AND p.published = 1
      ORDER BY a.ordering ASC
  61. SELECT *
      FROM jos_redshop_template
      WHERE template_section LIKE 'accessory_template'
      AND published=1
  62. SELECT *
      FROM jos_redshop_template
      WHERE template_section LIKE 'review'
      AND published=1
      LIMIT 0,1
  63. 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=96
      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
  64. SELECT pr.*
      FROM jos_redshop_product_rating AS pr
      WHERE pr.product_id=96
      AND pr.published = 1
  65. SELECT sum(user_rating) AS rating
      FROM jos_redshop_product_rating AS pr
      WHERE pr.product_id=96
      AND pr.published = 1
  66. SELECT *
      FROM jos_redshop_fields
      WHERE field_section='12'
      AND field_name=''
      AND published=1
      AND field_show_in_front=1
  67. SELECT
      FROM jos_redshop_product AS
      WHERE  p.product_id = 96
  68. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 96
      AND ps.stockroom_id = s.stockroom_id
  69. SELECT
      FROM jos_modules
      WHERE `module` LIKE 'mod_redmagicmagnifyplus'
      AND published  = 1
  70. SELECT *
      FROM jos_redshop_media 
      WHERE media_section = "product"
      AND section_id ="96"
      AND media_type="images" 
      AND media_name = "1307568700_crazy daisies1.jpg"
  71. SELECT *
      FROM jos_redshop_template
      WHERE template_section LIKE 'add_to_cart'
      AND published=1
  72. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 96
      AND ps.stockroom_id = s.stockroom_id
  73. SELECT p.* 
      FROM jos_redshop_product AS p   
      WHERE  p.product_id = 96
  74. SELECT p.price_id,p.product_price,p.product_currency 
      FROM jos_redshop_product_price AS
      WHERE  p.product_id = 96
      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
  75. SELECT *
      FROM jos_redshop_discount_product_shoppers AS ps
      WHERE ps.shopper_group_id ='0'
  76. SELECT *
      FROM jos_redshop_discount_product 
      WHERE amount <= 0
      AND discount_product_id IN (0) 
      AND published =1
      AND start_date <= '1746240959'
      AND end_date >= '1746240959' 
      ORDER BY amount DESC
      LIMIT 0,1
  77. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 96
  78. 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
  79. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 96
  80. 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
  81. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 96
      AND discount_enddate>='1746240959'
      AND discount_stratdate<='1746240959'
  82. 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'
  83. SELECT *
      FROM jos_redshop_fields
      WHERE field_section='12'
      AND field_name=''
      AND published=1
      AND field_show_in_front=1
  84. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 96
      AND ps.stockroom_id = s.stockroom_id
  85. SELECT p.* 
      FROM jos_redshop_product AS p   
      WHERE  p.product_id = 96
  86. SELECT p.price_id,p.product_price,p.product_currency 
      FROM jos_redshop_product_price AS
      WHERE  p.product_id = 96
      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
  87. SELECT *
      FROM jos_redshop_discount_product_shoppers AS ps
      WHERE ps.shopper_group_id ='0'
  88. SELECT *
      FROM jos_redshop_discount_product 
      WHERE amount <= 0
      AND discount_product_id IN (0) 
      AND published =1
      AND start_date <= '1746240959'
      AND end_date >= '1746240959' 
      ORDER BY amount DESC
      LIMIT 0,1
  89. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 96
  90. 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
  91. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 96
  92. 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
  93. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 96
      AND discount_enddate>='1746240959'
      AND discount_stratdate<='1746240959'
  94. 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'
  95. SELECT *
      FROM jos_redshop_fields
      WHERE field_section='12'
      AND field_name=''
      AND published=1
      AND field_show_in_front=1
  96. UPDATE jos_redshop_product
      SET `visited` = visited + 1
      WHERE `product_id` = '96'
  97. SELECT p.product_name,pcx.category_id
      FROM jos_redshop_product AS p,jos_redshop_product_category_xref AS pcx
      WHERE p.product_id = 96
      AND p.product_id = pcx.product_id
  98. 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
  99. SELECT pcx.product_id,p.product_name
      FROM jos_redshop_product AS p,jos_redshop_product_category_xref AS pcx
      WHERE pcx.category_id=59
      AND pcx.product_id=p.product_id
      ORDER BY pcx.product_id
  100. SELECT *
      FROM jos_menu
      WHERE id = '222'
  101. SELECT sef_url,product_name,cat_in_sefurl
      FROM jos_redshop_product
      WHERE product_id = '108'
  102. SELECT c.category_id
      FROM jos_redshop_category c,jos_redshop_product_category_xref pc
      WHERE pc.product_id = '108'
      AND pc.category_id = c.category_id 
      AND c.category_id = '59'
  103. SELECT c.category_id,c.category_name ,cx.category_child_id,cx.category_parent_id
      FROM jos_redshop_category_xref AS cx, jos_redshop_category AS c
      WHERE cx.category_child_id='59'
      AND c.category_id = cx.category_parent_id
  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='56'
      AND c.category_id = cx.category_parent_id
  105. SELECT category_name
      FROM jos_redshop_category
      WHERE category_id = '59'
  106. SELECT *
      FROM jos_menu
      WHERE id = '222'
  107. SELECT sef_url,product_name,cat_in_sefurl
      FROM jos_redshop_product
      WHERE product_id = '92'
  108. 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'
  109. 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
  110. SELECT c.category_id,c.category_name ,cx.category_child_id,cx.category_parent_id
      FROM jos_redshop_category_xref AS cx, jos_redshop_category AS c
      WHERE cx.category_child_id='56'
      AND c.category_id = cx.category_parent_id
  111. SELECT category_name
      FROM jos_redshop_category
      WHERE category_id = '59'
  112. SELECT *
      FROM jos_redshop_textlibrary
      WHERE published=1
  113. SELECT *
      FROM jos_menu
      WHERE link LIKE '%com_redshop%'
      AND published=1
      AND id = '222'
  114. SELECT category_id
      FROM jos_redshop_product_category_xref
      WHERE product_id=96
  115. SELECT *
      FROM jos_menu
      WHERE link LIKE '%com_redshop%'
      AND published=1 
      AND link LIKE '%view=category%' 
      AND params NOT LIKE '%categoryid%'
  116. SELECT *
      FROM jos_menu
      WHERE link LIKE '%com_redshop%'
      AND published=1 
      AND link LIKE '%view=product%' 
      AND params  LIKE '%productid=96
    %'
  117. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 96
  118. SELECT *
      FROM jos_redshop_template
      WHERE template_section LIKE 'related_product'
      AND published=1
  119. SELECT *
      FROM jos_redshop_product AS p ,jos_redshop_product_related  AS r
      WHERE r.related_id = p.product_id
      AND r.product_id=96
      AND p.published = 1
  120. SELECT *
      FROM jos_redshop_template
      WHERE template_section LIKE 'add_to_cart'
      AND published=1
  121. SELECT *
      FROM jos_menu
      WHERE id = '222'
  122. SELECT sef_url,product_name,cat_in_sefurl
      FROM jos_redshop_product
      WHERE product_id = '94'
  123. 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'
  124. 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
  125. 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
  126. SELECT category_name
      FROM jos_redshop_category
      WHERE category_id = '57'
  127. SELECT
      FROM jos_redshop_product AS
      WHERE  p.product_id = 94
  128. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 94
      AND ps.stockroom_id = s.stockroom_id
  129. SELECT
      FROM jos_modules
      WHERE `module` LIKE 'mod_redmagicmagnifyplus'
      AND published  = 1
  130. SELECT *
      FROM jos_redshop_media 
      WHERE media_section = "product"
      AND section_id ="94"
      AND media_type="images" 
      AND media_name = "1307566717_GU 9310_4.jpg"
  131. SELECT p.* 
      FROM jos_redshop_product AS p   
      WHERE  p.product_id = 94
  132. SELECT p.price_id,p.product_price,p.product_currency 
      FROM jos_redshop_product_price AS
      WHERE  p.product_id = 94
      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 <= '1746240959'
      AND end_date >= '1746240959' 
      ORDER BY amount DESC
      LIMIT 0,1
  135. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 94
  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 = 94
  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 *
      FROM jos_redshop_product
      WHERE product_id = 94
      AND discount_enddate>='1746240959'
      AND discount_stratdate<='1746240959'
  140. SELECT p.* 
      FROM jos_redshop_product AS p   
      WHERE  p.product_id = 94
  141. SELECT p.price_id,p.product_price,p.product_currency 
      FROM jos_redshop_product_price AS
      WHERE  p.product_id = 94
      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
  142. SELECT *
      FROM jos_redshop_discount_product_shoppers AS ps
      WHERE ps.shopper_group_id ='0'
  143. SELECT *
      FROM jos_redshop_discount_product 
      WHERE amount <= 0
      AND discount_product_id IN (0) 
      AND published =1
      AND start_date <= '1746240959'
      AND end_date >= '1746240959' 
      ORDER BY amount DESC
      LIMIT 0,1
  144. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 94
  145. 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
  146. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 94
  147. 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
  148. 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'
  149. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 94
      AND ps.stockroom_id = s.stockroom_id
  150. SELECT p.* 
      FROM jos_redshop_product_price AS
      WHERE  p.product_id = 94
      AND p.shopper_group_id = '0' 
      ORDER BY price_quantity_start ASC
  151. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 94
      AND discount_enddate>='1746240959'
      AND discount_stratdate<='1746240959'
  152. SELECT *
      FROM jos_menu
      WHERE id = '222'
  153. SELECT sef_url,product_name,cat_in_sefurl
      FROM jos_redshop_product
      WHERE product_id = '94'
  154. 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'
  155. SELECT c.category_id,c.category_name ,cx.category_child_id,cx.category_parent_id
      FROM jos_redshop_category_xref AS cx, jos_redshop_category AS c
      WHERE cx.category_child_id='57'
      AND c.category_id = cx.category_parent_id
  156. 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
  157. SELECT category_name
      FROM jos_redshop_category
      WHERE category_id = '57'
  158. 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=94
      AND p.published = 1
      AND a.attribute_required = 1
      ORDER BY a.ordering ASC
  159. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 94
      AND ps.stockroom_id = s.stockroom_id
  160. 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=94
      AND p.published = 1
      ORDER BY a.ordering ASC
  161. 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'
  162. SELECT p.* 
      FROM jos_redshop_product AS p   
      WHERE  p.product_id = 94
  163. SELECT p.price_id,p.product_price,p.product_currency 
      FROM jos_redshop_product_price AS
      WHERE  p.product_id = 94
      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
  164. SELECT *
      FROM jos_redshop_discount_product_shoppers AS ps
      WHERE ps.shopper_group_id ='0'
  165. SELECT *
      FROM jos_redshop_discount_product 
      WHERE amount <= 0
      AND discount_product_id IN (0) 
      AND published =1
      AND start_date <= '1746240959'
      AND end_date >= '1746240959' 
      ORDER BY amount DESC
      LIMIT 0,1
  166. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 94
  167. 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
  168. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 94
  169. 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
  170. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 94
      AND discount_enddate>='1746240959'
      AND discount_stratdate<='1746240959'
  171. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 94
      AND ps.stockroom_id = s.stockroom_id
  172. 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=94
      AND p.published = 1
      ORDER BY a.ordering ASC
  173. 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'
  174. SELECT p.* 
      FROM jos_redshop_product AS p   
      WHERE  p.product_id = 94
  175. SELECT p.price_id,p.product_price,p.product_currency 
      FROM jos_redshop_product_price AS
      WHERE  p.product_id = 94
      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
  176. SELECT *
      FROM jos_redshop_discount_product_shoppers AS ps
      WHERE ps.shopper_group_id ='0'
  177. SELECT *
      FROM jos_redshop_discount_product 
      WHERE amount <= 0
      AND discount_product_id IN (0) 
      AND published =1
      AND start_date <= '1746240959'
      AND end_date >= '1746240959' 
      ORDER BY amount DESC
      LIMIT 0,1
  178. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 94
  179. 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
  180. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 94
  181. 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
  182. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 94
      AND discount_enddate>='1746240959'
      AND discount_stratdate<='1746240959'
  183. SELECT *
      FROM jos_redshop_template
      WHERE template_section LIKE 'add_to_cart'
      AND published=1
  184. SELECT *
      FROM jos_menu
      WHERE id = '222'
  185. SELECT sef_url,product_name,cat_in_sefurl
      FROM jos_redshop_product
      WHERE product_id = '95'
  186. SELECT c.category_id
      FROM jos_redshop_category c,jos_redshop_product_category_xref pc
      WHERE pc.product_id = '95'
      AND pc.category_id = c.category_id 
      AND c.category_id = '57'
  187. 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
  188. 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
  189. SELECT category_name
      FROM jos_redshop_category
      WHERE category_id = '57'
  190. SELECT
      FROM jos_redshop_product AS
      WHERE  p.product_id = 95
  191. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 95
      AND ps.stockroom_id = s.stockroom_id
  192. SELECT
      FROM jos_modules
      WHERE `module` LIKE 'mod_redmagicmagnifyplus'
      AND published  = 1
  193. SELECT *
      FROM jos_redshop_media 
      WHERE media_section = "product"
      AND section_id ="95"
      AND media_type="images" 
      AND media_name = "1307567822_CK2570_16.jpg"
  194. SELECT p.* 
      FROM jos_redshop_product AS p   
      WHERE  p.product_id = 95
  195. SELECT p.price_id,p.product_price,p.product_currency 
      FROM jos_redshop_product_price AS
      WHERE  p.product_id = 95
      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
  196. SELECT *
      FROM jos_redshop_discount_product_shoppers AS ps
      WHERE ps.shopper_group_id ='0'
  197. SELECT *
      FROM jos_redshop_discount_product 
      WHERE amount <= 0
      AND discount_product_id IN (0) 
      AND published =1
      AND start_date <= '1746240959'
      AND end_date >= '1746240959' 
      ORDER BY amount DESC
      LIMIT 0,1
  198. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 95
  199. 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
  200. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 95
  201. 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
  202. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 95
      AND discount_enddate>='1746240959'
      AND discount_stratdate<='1746240959'
  203. SELECT p.* 
      FROM jos_redshop_product AS p   
      WHERE  p.product_id = 95
  204. SELECT p.price_id,p.product_price,p.product_currency 
      FROM jos_redshop_product_price AS
      WHERE  p.product_id = 95
      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
  205. SELECT *
      FROM jos_redshop_discount_product_shoppers AS ps
      WHERE ps.shopper_group_id ='0'
  206. SELECT *
      FROM jos_redshop_discount_product 
      WHERE amount <= 0
      AND discount_product_id IN (0) 
      AND published =1
      AND start_date <= '1746240959'
      AND end_date >= '1746240959' 
      ORDER BY amount DESC
      LIMIT 0,1
  207. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 95
  208. 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
  209. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 95
  210. 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
  211. 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'
  212. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 95
      AND ps.stockroom_id = s.stockroom_id
  213. SELECT p.* 
      FROM jos_redshop_product_price AS
      WHERE  p.product_id = 95
      AND p.shopper_group_id = '0' 
      ORDER BY price_quantity_start ASC
  214. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 95
      AND discount_enddate>='1746240959'
      AND discount_stratdate<='1746240959'
  215. SELECT *
      FROM jos_menu
      WHERE id = '222'
  216. SELECT sef_url,product_name,cat_in_sefurl
      FROM jos_redshop_product
      WHERE product_id = '95'
  217. SELECT c.category_id
      FROM jos_redshop_category c,jos_redshop_product_category_xref pc
      WHERE pc.product_id = '95'
      AND pc.category_id = c.category_id 
      AND c.category_id = '57'
  218. SELECT c.category_id,c.category_name ,cx.category_child_id,cx.category_parent_id
      FROM jos_redshop_category_xref AS cx, jos_redshop_category AS c
      WHERE cx.category_child_id='57'
      AND c.category_id = cx.category_parent_id
  219. 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
  220. SELECT category_name
      FROM jos_redshop_category
      WHERE category_id = '57'
  221. 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=95
      AND p.published = 1
      AND a.attribute_required = 1
      ORDER BY a.ordering ASC
  222. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 95
      AND ps.stockroom_id = s.stockroom_id
  223. 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=95
      AND p.published = 1
      ORDER BY a.ordering ASC
  224. 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'
  225. SELECT p.* 
      FROM jos_redshop_product AS p   
      WHERE  p.product_id = 95
  226. SELECT p.price_id,p.product_price,p.product_currency 
      FROM jos_redshop_product_price AS
      WHERE  p.product_id = 95
      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
  227. SELECT *
      FROM jos_redshop_discount_product_shoppers AS ps
      WHERE ps.shopper_group_id ='0'
  228. SELECT *
      FROM jos_redshop_discount_product 
      WHERE amount <= 0
      AND discount_product_id IN (0) 
      AND published =1
      AND start_date <= '1746240959'
      AND end_date >= '1746240959' 
      ORDER BY amount DESC
      LIMIT 0,1
  229. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 95
  230. 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
  231. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 95
  232. 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
  233. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 95
      AND discount_enddate>='1746240959'
      AND discount_stratdate<='1746240959'
  234. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 95
      AND ps.stockroom_id = s.stockroom_id
  235. 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=95
      AND p.published = 1
      ORDER BY a.ordering ASC
  236. 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'
  237. SELECT p.* 
      FROM jos_redshop_product AS p   
      WHERE  p.product_id = 95
  238. SELECT p.price_id,p.product_price,p.product_currency 
      FROM jos_redshop_product_price AS
      WHERE  p.product_id = 95
      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
  239. SELECT *
      FROM jos_redshop_discount_product_shoppers AS ps
      WHERE ps.shopper_group_id ='0'
  240. SELECT *
      FROM jos_redshop_discount_product 
      WHERE amount <= 0
      AND discount_product_id IN (0) 
      AND published =1
      AND start_date <= '1746240959'
      AND end_date >= '1746240959' 
      ORDER BY amount DESC
      LIMIT 0,1
  241. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 95
  242. 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
  243. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 95
  244. 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
  245. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 95
      AND discount_enddate>='1746240959'
      AND discount_stratdate<='1746240959'
  246. SELECT *
      FROM jos_redshop_template
      WHERE template_section LIKE 'add_to_cart'
      AND published=1
  247. SELECT *
      FROM jos_menu
      WHERE id = '222'
  248. SELECT sef_url,product_name,cat_in_sefurl
      FROM jos_redshop_product
      WHERE product_id = '97'
  249. SELECT c.category_id
      FROM jos_redshop_category c,jos_redshop_product_category_xref pc
      WHERE pc.product_id = '97'
      AND pc.category_id = c.category_id 
      AND c.category_id = '57'
  250. 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
  251. 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
  252. SELECT category_name
      FROM jos_redshop_category
      WHERE category_id = '57'
  253. SELECT
      FROM jos_redshop_product AS
      WHERE  p.product_id = 97
  254. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 97
      AND ps.stockroom_id = s.stockroom_id
  255. SELECT
      FROM jos_modules
      WHERE `module` LIKE 'mod_redmagicmagnifyplus'
      AND published  = 1
  256. SELECT *
      FROM jos_redshop_media 
      WHERE media_section = "product"
      AND section_id ="97"
      AND media_type="images" 
      AND media_name = "1307629399_GIR9554-1.jpg"
  257. SELECT p.* 
      FROM jos_redshop_product AS p   
      WHERE  p.product_id = 97
  258. SELECT p.price_id,p.product_price,p.product_currency 
      FROM jos_redshop_product_price AS
      WHERE  p.product_id = 97
      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
  259. SELECT *
      FROM jos_redshop_discount_product_shoppers AS ps
      WHERE ps.shopper_group_id ='0'
  260. SELECT *
      FROM jos_redshop_discount_product 
      WHERE amount <= 0
      AND discount_product_id IN (0) 
      AND published =1
      AND start_date <= '1746240959'
      AND end_date >= '1746240959' 
      ORDER BY amount DESC
      LIMIT 0,1
  261. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 97
  262. 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
  263. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 97
  264. 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
  265. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 97
      AND discount_enddate>='1746240959'
      AND discount_stratdate<='1746240959'
  266. SELECT p.* 
      FROM jos_redshop_product AS p   
      WHERE  p.product_id = 97
  267. SELECT p.price_id,p.product_price,p.product_currency 
      FROM jos_redshop_product_price AS
      WHERE  p.product_id = 97
      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
  268. SELECT *
      FROM jos_redshop_discount_product_shoppers AS ps
      WHERE ps.shopper_group_id ='0'
  269. SELECT *
      FROM jos_redshop_discount_product 
      WHERE amount <= 0
      AND discount_product_id IN (0) 
      AND published =1
      AND start_date <= '1746240959'
      AND end_date >= '1746240959' 
      ORDER BY amount DESC
      LIMIT 0,1
  270. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 97
  271. 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
  272. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 97
  273. 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
  274. 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'
  275. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 97
      AND ps.stockroom_id = s.stockroom_id
  276. SELECT p.* 
      FROM jos_redshop_product_price AS
      WHERE  p.product_id = 97
      AND p.shopper_group_id = '0' 
      ORDER BY price_quantity_start ASC
  277. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 97
      AND discount_enddate>='1746240959'
      AND discount_stratdate<='1746240959'
  278. SELECT *
      FROM jos_menu
      WHERE id = '222'
  279. SELECT sef_url,product_name,cat_in_sefurl
      FROM jos_redshop_product
      WHERE product_id = '97'
  280. SELECT c.category_id
      FROM jos_redshop_category c,jos_redshop_product_category_xref pc
      WHERE pc.product_id = '97'
      AND pc.category_id = c.category_id 
      AND c.category_id = '57'
  281. SELECT c.category_id,c.category_name ,cx.category_child_id,cx.category_parent_id
      FROM jos_redshop_category_xref AS cx, jos_redshop_category AS c
      WHERE cx.category_child_id='57'
      AND c.category_id = cx.category_parent_id
  282. 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
  283. SELECT category_name
      FROM jos_redshop_category
      WHERE category_id = '57'
  284. 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=97
      AND p.published = 1
      AND a.attribute_required = 1
      ORDER BY a.ordering ASC
  285. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 97
      AND ps.stockroom_id = s.stockroom_id
  286. 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=97
      AND p.published = 1
      ORDER BY a.ordering ASC
  287. 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'
  288. SELECT p.* 
      FROM jos_redshop_product AS p   
      WHERE  p.product_id = 97
  289. SELECT p.price_id,p.product_price,p.product_currency 
      FROM jos_redshop_product_price AS
      WHERE  p.product_id = 97
      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
  290. SELECT *
      FROM jos_redshop_discount_product_shoppers AS ps
      WHERE ps.shopper_group_id ='0'
  291. SELECT *
      FROM jos_redshop_discount_product 
      WHERE amount <= 0
      AND discount_product_id IN (0) 
      AND published =1
      AND start_date <= '1746240959'
      AND end_date >= '1746240959' 
      ORDER BY amount DESC
      LIMIT 0,1
  292. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 97
  293. 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
  294. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 97
  295. 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
  296. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 97
      AND discount_enddate>='1746240959'
      AND discount_stratdate<='1746240959'
  297. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 97
      AND ps.stockroom_id = s.stockroom_id
  298. 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=97
      AND p.published = 1
      ORDER BY a.ordering ASC
  299. 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'
  300. SELECT p.* 
      FROM jos_redshop_product AS p   
      WHERE  p.product_id = 97
  301. SELECT p.price_id,p.product_price,p.product_currency 
      FROM jos_redshop_product_price AS
      WHERE  p.product_id = 97
      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
  302. SELECT *
      FROM jos_redshop_discount_product_shoppers AS ps
      WHERE ps.shopper_group_id ='0'
  303. SELECT *
      FROM jos_redshop_discount_product 
      WHERE amount <= 0
      AND discount_product_id IN (0) 
      AND published =1
      AND start_date <= '1746240959'
      AND end_date >= '1746240959' 
      ORDER BY amount DESC
      LIMIT 0,1
  304. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 97
  305. 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
  306. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 97
  307. 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
  308. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 97
      AND discount_enddate>='1746240959'
      AND discount_stratdate<='1746240959'
  309. SELECT *
      FROM jos_redshop_template
      WHERE template_section LIKE 'add_to_cart'
      AND published=1
  310. SELECT *
      FROM jos_menu
      WHERE id = '222'
  311. SELECT sef_url,product_name,cat_in_sefurl
      FROM jos_redshop_product
      WHERE product_id = '93'
  312. SELECT c.category_id
      FROM jos_redshop_category c,jos_redshop_product_category_xref pc
      WHERE pc.product_id = '93'
      AND pc.category_id = c.category_id 
      AND c.category_id = '58'
  313. 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
  314. 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
  315. SELECT category_name
      FROM jos_redshop_category
      WHERE category_id = '58'
  316. SELECT
      FROM jos_redshop_product AS
      WHERE  p.product_id = 93
  317. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 93
      AND ps.stockroom_id = s.stockroom_id
  318. SELECT
      FROM jos_modules
      WHERE `module` LIKE 'mod_redmagicmagnifyplus'
      AND published  = 1
  319. SELECT *
      FROM jos_redshop_media 
      WHERE media_section = "product"
      AND section_id ="93"
      AND media_type="images" 
      AND media_name = "1307566197_GIR9403-1B.jpg"
  320. SELECT p.* 
      FROM jos_redshop_product AS p   
      WHERE  p.product_id = 93
  321. SELECT p.price_id,p.product_price,p.product_currency 
      FROM jos_redshop_product_price AS
      WHERE  p.product_id = 93
      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
  322. SELECT *
      FROM jos_redshop_discount_product_shoppers AS ps
      WHERE ps.shopper_group_id ='0'
  323. SELECT *
      FROM jos_redshop_discount_product 
      WHERE amount <= 0
      AND discount_product_id IN (0) 
      AND published =1
      AND start_date <= '1746240959'
      AND end_date >= '1746240959' 
      ORDER BY amount DESC
      LIMIT 0,1
  324. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 93
  325. 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
  326. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 93
  327. 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
  328. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 93
      AND discount_enddate>='1746240959'
      AND discount_stratdate<='1746240959'
  329. SELECT p.* 
      FROM jos_redshop_product AS p   
      WHERE  p.product_id = 93
  330. SELECT p.price_id,p.product_price,p.product_currency 
      FROM jos_redshop_product_price AS
      WHERE  p.product_id = 93
      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
  331. SELECT *
      FROM jos_redshop_discount_product_shoppers AS ps
      WHERE ps.shopper_group_id ='0'
  332. SELECT *
      FROM jos_redshop_discount_product 
      WHERE amount <= 0
      AND discount_product_id IN (0) 
      AND published =1
      AND start_date <= '1746240959'
      AND end_date >= '1746240959' 
      ORDER BY amount DESC
      LIMIT 0,1
  333. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 93
  334. 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
  335. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 93
  336. 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
  337. 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'
  338. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 93
      AND ps.stockroom_id = s.stockroom_id
  339. SELECT p.* 
      FROM jos_redshop_product_price AS
      WHERE  p.product_id = 93
      AND p.shopper_group_id = '0' 
      ORDER BY price_quantity_start ASC
  340. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 93
      AND discount_enddate>='1746240959'
      AND discount_stratdate<='1746240959'
  341. SELECT *
      FROM jos_menu
      WHERE id = '222'
  342. SELECT sef_url,product_name,cat_in_sefurl
      FROM jos_redshop_product
      WHERE product_id = '93'
  343. SELECT c.category_id
      FROM jos_redshop_category c,jos_redshop_product_category_xref pc
      WHERE pc.product_id = '93'
      AND pc.category_id = c.category_id 
      AND c.category_id = '58'
  344. SELECT c.category_id,c.category_name ,cx.category_child_id,cx.category_parent_id
      FROM jos_redshop_category_xref AS cx, jos_redshop_category AS c
      WHERE cx.category_child_id='58'
      AND c.category_id = cx.category_parent_id
  345. 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
  346. SELECT category_name
      FROM jos_redshop_category
      WHERE category_id = '58'
  347. 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=93
      AND p.published = 1
      AND a.attribute_required = 1
      ORDER BY a.ordering ASC
  348. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 93
      AND ps.stockroom_id = s.stockroom_id
  349. 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=93
      AND p.published = 1
      ORDER BY a.ordering ASC
  350. 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'
  351. SELECT p.* 
      FROM jos_redshop_product AS p   
      WHERE  p.product_id = 93
  352. SELECT p.price_id,p.product_price,p.product_currency 
      FROM jos_redshop_product_price AS
      WHERE  p.product_id = 93
      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
  353. SELECT *
      FROM jos_redshop_discount_product_shoppers AS ps
      WHERE ps.shopper_group_id ='0'
  354. SELECT *
      FROM jos_redshop_discount_product 
      WHERE amount <= 0
      AND discount_product_id IN (0) 
      AND published =1
      AND start_date <= '1746240959'
      AND end_date >= '1746240959' 
      ORDER BY amount DESC
      LIMIT 0,1
  355. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 93
  356. 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
  357. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 93
  358. 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
  359. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 93
      AND discount_enddate>='1746240959'
      AND discount_stratdate<='1746240959'
  360. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS
      WHERE  ps.product_id = 93
      AND ps.stockroom_id = s.stockroom_id
  361. 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=93
      AND p.published = 1
      ORDER BY a.ordering ASC
  362. 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'
  363. SELECT p.* 
      FROM jos_redshop_product AS p   
      WHERE  p.product_id = 93
  364. SELECT p.price_id,p.product_price,p.product_currency 
      FROM jos_redshop_product_price AS
      WHERE  p.product_id = 93
      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
  365. SELECT *
      FROM jos_redshop_discount_product_shoppers AS ps
      WHERE ps.shopper_group_id ='0'
  366. SELECT *
      FROM jos_redshop_discount_product 
      WHERE amount <= 0
      AND discount_product_id IN (0) 
      AND published =1
      AND start_date <= '1746240959'
      AND end_date >= '1746240959' 
      ORDER BY amount DESC
      LIMIT 0,1
  367. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 93
  368. 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
  369. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 93
  370. 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
  371. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 93
      AND discount_enddate>='1746240959'
      AND discount_stratdate<='1746240959'
  372. 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
  373. SELECT *
      FROM jos_menu
      WHERE id = '71'
  374. SELECT *
      FROM jos_menu
      WHERE id = '222'
  375. SELECT category_id      
      FROM jos_redshop_product_category_xref cx
      WHERE product_id = ''
  376. 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'
  377. SELECT category_id AS value,category_name AS text
      FROM jos_redshop_category
      WHERE published = 1
  378. SELECT *
      FROM jos_menu
      WHERE id = '222'

Language Files Loaded

Untranslated Strings Diagnostic

None

Untranslated Strings Designer

None