Електронен магазин


Списък на всички продукти


Разширено търсене





Забравена парола?
Забравено потребителско име?
Нямате акаунт? Регистрирайте се

Количка

VirtueMart
Количката Ви е празна.

0 лв.

Посетете още...

За да организираме:

Abv.bg | Dox.bg
Icq.abv.bg

За да намерим:

Gbg.bg | Lubimi.com

Google.bg | Yahoo.com

Да сме информирани:

Vesti.bg | Sportni.bg

Sinoptik.bg | Pariteni.bg

Svejo.net | Dir.bg | Start.bg

Забавлевния:

Vbox7.com | Vgames.bg

Vmusic.bg | facebook.com

За да знаем:

Fanopic.com

Последни новини ...


DEBUG info JoomlaStats: Joomla CMS cache is ON        
DEBUG info JoomlaStats: Visit time in Joomla Local timezone: 2023-10-01 08:21:36        
DEBUG info JoomlaStats: Perform Visitor counting process (function: countVisitor())        
DEBUG info JoomlaStats: UserAgent string: 'ccbot/2.0 (https://commoncrawl.org/faq/)'        
DEBUG info JoomlaStats: Visitor already known        
DEBUG info JoomlaStats: Perform Visit counting process        
DEBUG info JoomlaStats: Visit already in progress. Continue this Visit        
DEBUG info JoomlaStats: Perform Page counting process        
DEBUG info JoomlaStats: Page counting process successful        
DEBUG info JoomlaStats: Refferer not set.        

Социални медии

Споделете...
Digg.com Digg.com Facebook Facebook Google Google Twitter Twitter Yahoo Yahoo

PDFПечат

Преглед feed

Подреждане според:     Покажи №  

Резултати 241 - 260 от 637

Антена електронна

Антена вътрешна електронна
[Допълнителна информация...]

7.20 лв. (Цена с ДДС)

Средна оценка на потребители:
0 stars  Общо гласове: 0


Антена телескопична

Антена телескопична - хром
[Допълнителна информация...]

4.16 лв. (Цена с ДДС)

Средна оценка на потребители:
0 stars  Общо гласове: 0


Антена телескопична

Антена телескопична - черна
[Допълнителна информация...]

4.40 лв. (Цена с ДДС)

Средна оценка на потребители:
0 stars  Общо гласове: 0


Антикорозионен и почистващ спрей

Ефективно средство за почистване на ръжда.
[Допълнителна информация...]

Обадете се за цена

Средна оценка на потребители:
0 stars  Общо гласове: 0

Антифириз за пневматични спирачки

Антифириз за пневматични спирачки
[Допълнителна информация...]

21.66 лв. (Цена с ДДС)

Средна оценка на потребители:
0 stars  Общо гласове: 0


Бензинов генератор 2.0kW - Ferros tools

Бензинов генератор 2.0kW - Ferros tools
[Допълнителна информация...]

349.68 лв. (Цена с ДДС)

Средна оценка на потребители:
0 stars  Общо гласове: 0


Бушони ножични

Бушони ножични микро 10 бр. блистер
[Допълнителна информация...]

1.00 лв. (Цена с ДДС)

Средна оценка на потребители:
0 stars  Общо гласове: 0


Бушони ножични

Бушони порцелан 20 бр. блистер
[Допълнителна информация...]

1.70 лв. (Цена с ДДС)

Средна оценка на потребители:
0 stars  Общо гласове: 0


Бушони ножични

Бушони ножични 10 бр. блистер
[Допълнителна информация...]

1.00 лв. (Цена с ДДС)

Средна оценка на потребители:
0 stars  Общо гласове: 0


Бяла грес под формата на спрей

BIZOL White Grease SPRAY е аерозолна грес с много добра прилепчивост и висок вискозитет.
[Допълнителна информация...]

9.71 лв. (Цена с ДДС)

Средна оценка на потребители:
0 stars  Общо гласове: 0


Вакуумрегулатор

Рециклиран вакуумрегулатор за делко Bosch за някой автомобили с марките Audi и VW
[Допълнителна информация...]

Обадете се за цена

Средна оценка на потребители:
0 stars  Общо гласове: 0

Вакуумрегулатор

Рециклиран вакуумрегулатор за делко Duceller за някой автомобили с марката Renault
[Допълнителна информация...]

Обадете се за цена

Средна оценка на потребители:
0 stars  Общо гласове: 0

Вакуумрегулатор

Рециклиран вакуумрегулатор за делко Duceller за някой автомобили с марката Audi
[Допълнителна информация...]

Обадете се за цена

Средна оценка на потребители:
0 stars  Общо гласове: 0

Вакуумрегулатор

Рециклиран вакуумрегулатор за делко Bosch за някой автомобили с марката VW
[Допълнителна информация...]

Обадете се за цена

Средна оценка на потребители:
0 stars  Общо гласове: 0

Виброшлайф, 135W - AKITA

Виброшлайф, 135W - AKITA
[Допълнителна информация...]

27.88 лв. (Цена с ДДС)

Средна оценка на потребители:
0 stars  Общо гласове: 0


Водоустойчива грес под формата на спрей

Универсален смазочен продукт с отлична механична и термична стабилност,за приложение е метални и пластмасови детайли.
[Допълнителна информация...]

Обадете се за цена

Средна оценка на потребители:
0 stars  Общо гласове: 0

Въже за теглене

Въже за теглене ластично 2,8 т
[Допълнителна информация...]

6.30 лв. (Цена с ДДС)

Средна оценка на потребители:
0 stars  Общо гласове: 0


Въже за теглене

Въже за теглене плетено 5 т
[Допълнителна информация...]

9.92 лв. (Цена с ДДС)

Средна оценка на потребители:
0 stars  Общо гласове: 0


Въже за теглене

Въже за теглене 3т
[Допълнителна информация...]

6.00 лв. (Цена с ДДС)

Средна оценка на потребители:
0 stars  Общо гласове: 0


Въже за теглене

Въже за теглене синтетично 1,8 т
[Допълнителна информация...]

6.00 лв. (Цена с ДДС)

Средна оценка на потребители:
0 stars  Общо гласове: 0





Покажи №  
Резултати 241 - 260 от 637
Обновено на: Sunday, 01 October 2023 08:21


 

Времето

Любопитно

Информация за профила

Application afterLoad: 0.000 seconds, 0.88 MB
Application afterInitialise: 0.031 seconds, 7.68 MB
Application afterRoute: 0.059 seconds, 12.00 MB
Application afterDispatch: 0.899 seconds, 20.78 MB
Application afterRender: 9.835 seconds, 28.02 MB

Използвана памет

29499160

658 заявки са записани

  1. SELECT *
      FROM jos_session
      WHERE session_id = '569e4c6982ab3aac798cb6e516725595'
  2. DELETE
      FROM jos_session
      WHERE ( TIME < '1696144886' )
  3. SELECT *
      FROM jos_session
      WHERE session_id = '569e4c6982ab3aac798cb6e516725595'
  4. INSERT INTO `jos_session` ( `session_id`,`time`,`username`,`gid`,`guest`,`client_id` )
      VALUES ( '569e4c6982ab3aac798cb6e516725595','1696148486','','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 *
      FROM jos_migration_backlinks
      WHERE url LIKE 'option=com\_virtuemart&category\_id=0&page=shop.browse&Itemid=1&limit=20&limitstart=240&vmcchk=1&Itemid=1%' OR sefurl LIKE 'option=com\_virtuemart&category\_id=0&page=shop.browse&Itemid=1&limit=20&limitstart=240&vmcchk=1&Itemid=1%'
  8. SELECT *
      FROM jos_migration_backlinks
      WHERE url LIKE 'index.php?option=com\_virtuemart&category\_id=0&page=shop.browse&Itemid=1&limit=20&limitstart=240&vmcchk=1&Itemid=1%' OR sefurl LIKE 'index.php?option=com\_virtuemart&category\_id=0&page=shop.browse&Itemid=1&limit=20&limitstart=240&vmcchk=1&Itemid=1%'
  9. SELECT newurl
      FROM jos_sh404sef_aliases
      WHERE alias = 'index.php?option=com_virtuemart&category_id=0&page=shop.browse&Itemid=1&limit=20&limitstart=240&vmcchk=1&Itemid=1'
  10. SELECT oldurl, dateadd
      FROM jos_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=1&category_id=0&lang=bg&limit=20&limitstart=240&page=shop.browse&vmcchk=1'
  11. SELECT template
      FROM jos_templates_menu
      WHERE client_id = 0
      AND (menuid = 0 OR menuid = 1)
      ORDER BY menuid DESC
      LIMIT 0, 1
  12. SELECT group_id,group_name,group_level
      FROM `jos_vm_auth_group`
      ORDER BY group_level
  13. SELECT jos_vm_shopper_group.shopper_group_id, show_price_including_tax, `default`, shopper_group_discount
                   
      FROM `jos_vm_shopper_group`
      WHERE jos_vm_shopper_group.vendor_id='1'
      AND `default`='1'
  14. SELECT `name`
      FROM `jos_core_acl_aro_groups`
      WHERE `id` =29
  15. SELECT vendor_id, vendor_min_pov,vendor_name,vendor_store_name,contact_email,vendor_full_image, vendor_freeshipping,
                                            vendor_address_1,vendor_address_2, vendor_url, vendor_city, vendor_state, vendor_country, country_2_code, country_3_code,
                                            vendor_zip, vendor_phone, vendor_store_desc, vendor_currency, vendor_currency_display_style,
                                            vendor_accepted_currencies, vendor_address_format, vendor_date_format, state_name
                                   
      FROM (`jos_vm_vendor` v, `jos_vm_country` c)
                                   
      LEFT JOIN jos_vm_state s
      ON (v.vendor_state=s.state_2_code
      AND s.country_id=c.country_id)
                                   
      WHERE `v`.`vendor_id`=1
                                   
      AND (`v`.`vendor_country`=`c`.`country_2_code` OR `v`.`vendor_country`=`c`.`country_3_code`);
  16. SELECT module_perms
      FROM jos_vm_module
      WHERE module_name='shop'
  17. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND published=1
  18. SELECT COUNT(*) AS parentcnt
      FROM jos_vm_product
      WHERE product_parent_id>0
  19. SELECT COUNT(DISTINCT `jos_vm_product`.`product_sku`) AS num_rows
      FROM (`jos_vm_product`, `jos_vm_category`, `jos_vm_product_category_xref`,`jos_vm_shopper_group`)
      LEFT JOIN `jos_vm_product_price`
      ON `jos_vm_product`.`product_id` = `jos_vm_product_price`.`product_id`
      WHERE (`jos_vm_product_category_xref`.`product_id`=`jos_vm_product`.`product_id` OR `jos_vm_product_category_xref`.`product_id`=`jos_vm_product`.`product_parent_id`)
     
      AND `jos_vm_product_category_xref`.`category_id`=`jos_vm_category`.`category_id`
     
      AND ((`jos_vm_product`.`product_id`=`jos_vm_product_price`.`product_id`
      AND `jos_vm_shopper_group`.`shopper_group_id`=`jos_vm_product_price`.`shopper_group_id`) OR `jos_vm_product_price`.`product_id` IS NULL)
     
      AND `jos_vm_shopper_group`.`default` = 1
     
      AND `product_parent_id`=0
     
      AND `product_publish`='Y'
     
      AND `category_publish`='Y'
  20. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%page=shop.browse%'
      AND published=1
  21. SELECT DISTINCT `jos_vm_product`.`product_id`, `product_name`, `products_per_row`, `category_browsepage`, `category_flypage`, `jos_vm_category`.`category_id`, `product_full_image`, `product_thumb_image`, `product_s_desc`, `product_parent_id`, `product_publish`, `product_in_stock`, `product_sku`, `product_url`, `product_weight`, `product_weight_uom`, `product_length`, `product_width`, `product_height`, `product_lwh_uom`, `product_available_date`, `product_availability`, `jos_vm_product`.`mdate`, `jos_vm_product`.`cdate`
      FROM (`jos_vm_product`, `jos_vm_category`, `jos_vm_product_category_xref`,`jos_vm_shopper_group`)
      LEFT JOIN `jos_vm_product_price`
      ON `jos_vm_product`.`product_id` = `jos_vm_product_price`.`product_id`
      WHERE (`jos_vm_product_category_xref`.`product_id`=`jos_vm_product`.`product_id` OR `jos_vm_product_category_xref`.`product_id`=`jos_vm_product`.`product_parent_id`)
     
      AND `jos_vm_product_category_xref`.`category_id`=`jos_vm_category`.`category_id`
     
      AND ((`jos_vm_product`.`product_id`=`jos_vm_product_price`.`product_id`
      AND `jos_vm_shopper_group`.`shopper_group_id`=`jos_vm_product_price`.`shopper_group_id`) OR `jos_vm_product_price`.`product_id` IS NULL)
     
      AND `jos_vm_shopper_group`.`default` = 1
     
      AND `product_parent_id`=0
     
      AND `product_publish`='Y'
     
      AND `category_publish`='Y'
     
      GROUP BY `jos_vm_product`.`product_sku`
     
      ORDER BY `jos_vm_product`.`product_name` ASC
      LIMIT 240, 20
  22. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%product_id=362%'
      AND published=1
  23. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%category_id=41%'
      AND published=1
  24. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%flypage=flypage.tpl%'
      AND published=1
  25. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%page=shop.product_details%'
      AND published=1
  26. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=362
  27. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='362'
      AND (start_date<='1696148487' OR start_date=0)
      AND (end_date>='1696116960' OR end_date=0)
      AND product_discount_id=discount_id
  28. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=362
  29. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1696148487' OR start_date=0)
      AND (end_date>='1696116960' OR end_date=0)
      AND product_discount_id=discount_id
  30. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='362'
  31. SELECT shopper_group_id,shopper_group_discount
      FROM jos_vm_shopper_group
      WHERE vendor_id='1'
      AND `default`='1'
  32. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=362
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  33. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=362
  34. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=362
  35. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=362
      AND `file_is_image`=1
      AND `file_published`=1
  36. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=362
  37. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=1
      AND `file_published`=1
  38. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=362
      AND `file_is_image`=0
      AND `file_published`=1
  39. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id='362'
  40. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=0
      AND `file_published`=1
  41. SELECT votes, allvotes, rating
      FROM jos_vm_product_votes
      WHERE product_id='362'
  42. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=362
  43. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=362
  44. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%product_id=360%'
      AND published=1
  45. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%category_id=41%'
      AND published=1
  46. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%flypage=flypage.tpl%'
      AND published=1
  47. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%page=shop.product_details%'
      AND published=1
  48. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=360
  49. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='360'
      AND (start_date<='1696148487' OR start_date=0)
      AND (end_date>='1696116960' OR end_date=0)
      AND product_discount_id=discount_id
  50. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=360
  51. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1696148487' OR start_date=0)
      AND (end_date>='1696116960' OR end_date=0)
      AND product_discount_id=discount_id
  52. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='360'
  53. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=360
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  54. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=360
  55. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=360
  56. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=360
      AND `file_is_image`=1
      AND `file_published`=1
  57. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=360
  58. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=1
      AND `file_published`=1
  59. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=360
      AND `file_is_image`=0
      AND `file_published`=1
  60. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id='360'
  61. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=0
      AND `file_published`=1
  62. SELECT votes, allvotes, rating
      FROM jos_vm_product_votes
      WHERE product_id='360'
  63. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=360
  64. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=360
  65. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%product_id=361%'
      AND published=1
  66. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%category_id=41%'
      AND published=1
  67. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%flypage=flypage.tpl%'
      AND published=1
  68. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%page=shop.product_details%'
      AND published=1
  69. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=361
  70. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='361'
      AND (start_date<='1696148487' OR start_date=0)
      AND (end_date>='1696116960' OR end_date=0)
      AND product_discount_id=discount_id
  71. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=361
  72. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1696148487' OR start_date=0)
      AND (end_date>='1696116960' OR end_date=0)
      AND product_discount_id=discount_id
  73. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='361'
  74. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=361
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  75. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=361
  76. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=361
  77. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=361
      AND `file_is_image`=1
      AND `file_published`=1
  78. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=361
  79. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=1
      AND `file_published`=1
  80. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=361
      AND `file_is_image`=0
      AND `file_published`=1
  81. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id='361'
  82. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=0
      AND `file_published`=1
  83. SELECT votes, allvotes, rating
      FROM jos_vm_product_votes
      WHERE product_id='361'
  84. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=361
  85. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=361
  86. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%product_id=3087%'
      AND published=1
  87. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%category_id=46%'
      AND published=1
  88. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%flypage=flypage.tpl%'
      AND published=1
  89. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%page=shop.product_details%'
      AND published=1
  90. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=3087
  91. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='3087'
      AND (start_date<='1696148487' OR start_date=0)
      AND (end_date>='1696116960' OR end_date=0)
      AND product_discount_id=discount_id
  92. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=3087
  93. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1696148487' OR start_date=0)
      AND (end_date>='1696116960' OR end_date=0)
      AND product_discount_id=discount_id
  94. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='3087'
  95. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=3087
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  96. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=3087
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  97. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=3087
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  98. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=3087
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  99. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%product_id=3087%'
      AND published=1
  100. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%page=shop.ask%'
      AND published=1
  101. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=3087
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  102. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=3087
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  103. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=3087
  104. SELECT `tax_rate`
      FROM jos_vm_vendor, jos_vm_tax_rate
      WHERE tax_country=vendor_country
      AND jos_vm_vendor.vendor_id=1
      ORDER BY `tax_rate` DESC
  105. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=3087
      AND `file_is_image`=1
      AND `file_published`=1
  106. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=3087
  107. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=1
      AND `file_published`=1
  108. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=3087
      AND `file_is_image`=0
      AND `file_published`=1
  109. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id='3087'
  110. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=0
      AND `file_published`=1
  111. SELECT votes, allvotes, rating
      FROM jos_vm_product_votes
      WHERE product_id='3087'
  112. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%product_id=2678%'
      AND published=1
  113. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%category_id=2%'
      AND published=1
  114. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%flypage=flypage.tpl%'
      AND published=1
  115. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%page=shop.product_details%'
      AND published=1
  116. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=2678
  117. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='2678'
      AND (start_date<='1696148487' OR start_date=0)
      AND (end_date>='1696116960' OR end_date=0)
      AND product_discount_id=discount_id
  118. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=2678
  119. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1696148487' OR start_date=0)
      AND (end_date>='1696116960' OR end_date=0)
      AND product_discount_id=discount_id
  120. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='2678'
  121. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=2678
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  122. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=2678
  123. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=2678
  124. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=2678
      AND `file_is_image`=1
      AND `file_published`=1
  125. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=2678
  126. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=1
      AND `file_published`=1
  127. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=2678
      AND `file_is_image`=0
      AND `file_published`=1
  128. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id='2678'
  129. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=0
      AND `file_published`=1
  130. SELECT votes, allvotes, rating
      FROM jos_vm_product_votes
      WHERE product_id='2678'
  131. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=2678
  132. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=2678
  133. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%product_id=1502%'
      AND published=1
  134. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%category_id=65%'
      AND published=1
  135. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%flypage=flypage.tpl%'
      AND published=1
  136. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%page=shop.product_details%'
      AND published=1
  137. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=1502
  138. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='1502'
      AND (start_date<='1696148487' OR start_date=0)
      AND (end_date>='1696116960' OR end_date=0)
      AND product_discount_id=discount_id
  139. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=1502
  140. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1696148487' OR start_date=0)
      AND (end_date>='1696116960' OR end_date=0)
      AND product_discount_id=discount_id
  141. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='1502'
  142. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=1502
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  143. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=1502
  144. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=1502
  145. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=1502
      AND `file_is_image`=1
      AND `file_published`=1
  146. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=1502
  147. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=1
      AND `file_published`=1
  148. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=1502
      AND `file_is_image`=0
      AND `file_published`=1
  149. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id='1502'
  150. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=0
      AND `file_published`=1
  151. SELECT votes, allvotes, rating
      FROM jos_vm_product_votes
      WHERE product_id='1502'
  152. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=1502
  153. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=1502
  154. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%product_id=303%'
      AND published=1
  155. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%category_id=41%'
      AND published=1
  156. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%flypage=flypage.tpl%'
      AND published=1
  157. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%page=shop.product_details%'
      AND published=1
  158. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=303
  159. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='303'
      AND (start_date<='1696148487' OR start_date=0)
      AND (end_date>='1696116960' OR end_date=0)
      AND product_discount_id=discount_id
  160. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=303
  161. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1696148487' OR start_date=0)
      AND (end_date>='1696116960' OR end_date=0)
      AND product_discount_id=discount_id
  162. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='303'
  163. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=303
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  164. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=303
  165. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=303
  166. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=303
      AND `file_is_image`=1
      AND `file_published`=1
  167. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=303
  168. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=1
      AND `file_published`=1
  169. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=303
      AND `file_is_image`=0
      AND `file_published`=1
  170. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id='303'
  171. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=0
      AND `file_published`=1
  172. SELECT votes, allvotes, rating
      FROM jos_vm_product_votes
      WHERE product_id='303'
  173. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=303
  174. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=303
  175. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%product_id=304%'
      AND published=1
  176. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%category_id=41%'
      AND published=1
  177. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%flypage=flypage.tpl%'
      AND published=1
  178. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%page=shop.product_details%'
      AND published=1
  179. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=304
  180. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='304'
      AND (start_date<='1696148487' OR start_date=0)
      AND (end_date>='1696116960' OR end_date=0)
      AND product_discount_id=discount_id
  181. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=304
  182. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1696148487' OR start_date=0)
      AND (end_date>='1696116960' OR end_date=0)
      AND product_discount_id=discount_id
  183. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='304'
  184. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=304
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  185. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=304
  186. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=304
  187. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=304
      AND `file_is_image`=1
      AND `file_published`=1
  188. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=304
  189. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=1
      AND `file_published`=1
  190. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=304
      AND `file_is_image`=0
      AND `file_published`=1
  191. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id='304'
  192. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=0
      AND `file_published`=1
  193. SELECT votes, allvotes, rating
      FROM jos_vm_product_votes
      WHERE product_id='304'
  194. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=304
  195. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=304
  196. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%product_id=299%'
      AND published=1
  197. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%category_id=41%'
      AND published=1
  198. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%flypage=flypage.tpl%'
      AND published=1
  199. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%page=shop.product_details%'
      AND published=1
  200. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=299
  201. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='299'
      AND (start_date<='1696148487' OR start_date=0)
      AND (end_date>='1696116960' OR end_date=0)
      AND product_discount_id=discount_id
  202. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=299
  203. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1696148487' OR start_date=0)
      AND (end_date>='1696116960' OR end_date=0)
      AND product_discount_id=discount_id
  204. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='299'
  205. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=299
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  206. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=299
  207. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=299
  208. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=299
      AND `file_is_image`=1
      AND `file_published`=1
  209. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=299
  210. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=1
      AND `file_published`=1
  211. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=299
      AND `file_is_image`=0
      AND `file_published`=1
  212. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id='299'
  213. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=0
      AND `file_published`=1
  214. SELECT votes, allvotes, rating
      FROM jos_vm_product_votes
      WHERE product_id='299'
  215. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=299
  216. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=299
  217. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%product_id=3089%'
      AND published=1
  218. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%category_id=46%'
      AND published=1
  219. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%flypage=flypage.tpl%'
      AND published=1
  220. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%page=shop.product_details%'
      AND published=1
  221. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=3089
  222. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='3089'
      AND (start_date<='1696148487' OR start_date=0)
      AND (end_date>='1696116960' OR end_date=0)
      AND product_discount_id=discount_id
  223. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=3089
  224. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1696148487' OR start_date=0)
      AND (end_date>='1696116960' OR end_date=0)
      AND product_discount_id=discount_id
  225. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='3089'
  226. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=3089
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  227. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=3089
  228. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=3089
  229. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=3089
      AND `file_is_image`=1
      AND `file_published`=1
  230. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=3089
  231. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=1
      AND `file_published`=1
  232. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=3089
      AND `file_is_image`=0
      AND `file_published`=1
  233. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id='3089'
  234. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=0
      AND `file_published`=1
  235. SELECT votes, allvotes, rating
      FROM jos_vm_product_votes
      WHERE product_id='3089'
  236. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=3089
  237. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=3089
  238. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%product_id=1812%'
      AND published=1
  239. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%category_id=82%'
      AND published=1
  240. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%flypage=flypage.tpl%'
      AND published=1
  241. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%page=shop.product_details%'
      AND published=1
  242. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=1812
  243. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='1812'
      AND (start_date<='1696148487' OR start_date=0)
      AND (end_date>='1696116960' OR end_date=0)
      AND product_discount_id=discount_id
  244. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=1812
  245. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1696148487' OR start_date=0)
      AND (end_date>='1696116960' OR end_date=0)
      AND product_discount_id=discount_id
  246. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='1812'
  247. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=1812
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  248. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=1812
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  249. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=1812
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  250. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=1812
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  251. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%product_id=1812%'
      AND published=1
  252. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%page=shop.ask%'
      AND published=1
  253. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=1812
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  254. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=1812
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  255. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=1812
  256. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=1812
      AND `file_is_image`=1
      AND `file_published`=1
  257. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=1812
  258. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=1
      AND `file_published`=1
  259. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=1812
      AND `file_is_image`=0
      AND `file_published`=1
  260. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id='1812'
  261. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=0
      AND `file_published`=1
  262. SELECT votes, allvotes, rating
      FROM jos_vm_product_votes
      WHERE product_id='1812'
  263. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%product_id=1813%'
      AND published=1
  264. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%category_id=82%'
      AND published=1
  265. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%flypage=flypage.tpl%'
      AND published=1
  266. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%page=shop.product_details%'
      AND published=1
  267. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=1813
  268. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='1813'
      AND (start_date<='1696148487' OR start_date=0)
      AND (end_date>='1696116960' OR end_date=0)
      AND product_discount_id=discount_id
  269. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=1813
  270. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1696148487' OR start_date=0)
      AND (end_date>='1696116960' OR end_date=0)
      AND product_discount_id=discount_id
  271. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='1813'
  272. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=1813
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  273. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=1813
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  274. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=1813
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  275. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=1813
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  276. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%product_id=1813%'
      AND published=1
  277. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%page=shop.ask%'
      AND published=1
  278. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=1813
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  279. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=1813
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  280. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=1813
  281. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=1813
      AND `file_is_image`=1
      AND `file_published`=1
  282. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=1813
  283. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=1
      AND `file_published`=1
  284. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=1813
      AND `file_is_image`=0
      AND `file_published`=1
  285. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id='1813'
  286. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=0
      AND `file_published`=1
  287. SELECT votes, allvotes, rating
      FROM jos_vm_product_votes
      WHERE product_id='1813'
  288. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%product_id=1814%'
      AND published=1
  289. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%category_id=82%'
      AND published=1
  290. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%flypage=flypage.tpl%'
      AND published=1
  291. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%page=shop.product_details%'
      AND published=1
  292. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=1814
  293. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='1814'
      AND (start_date<='1696148487' OR start_date=0)
      AND (end_date>='1696116960' OR end_date=0)
      AND product_discount_id=discount_id
  294. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=1814
  295. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1696148487' OR start_date=0)
      AND (end_date>='1696116960' OR end_date=0)
      AND product_discount_id=discount_id
  296. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='1814'
  297. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=1814
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  298. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=1814
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  299. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=1814
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  300. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=1814
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  301. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%product_id=1814%'
      AND published=1
  302. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%page=shop.ask%'
      AND published=1
  303. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=1814
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  304. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=1814
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  305. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=1814
  306. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=1814
      AND `file_is_image`=1
      AND `file_published`=1
  307. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=1814
  308. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=1
      AND `file_published`=1
  309. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=1814
      AND `file_is_image`=0
      AND `file_published`=1
  310. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id='1814'
  311. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=0
      AND `file_published`=1
  312. SELECT votes, allvotes, rating
      FROM jos_vm_product_votes
      WHERE product_id='1814'
  313. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%product_id=1811%'
      AND published=1
  314. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%category_id=82%'
      AND published=1
  315. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%flypage=flypage.tpl%'
      AND published=1
  316. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%page=shop.product_details%'
      AND published=1
  317. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=1811
  318. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='1811'
      AND (start_date<='1696148487' OR start_date=0)
      AND (end_date>='1696116960' OR end_date=0)
      AND product_discount_id=discount_id
  319. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=1811
  320. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1696148487' OR start_date=0)
      AND (end_date>='1696116960' OR end_date=0)
      AND product_discount_id=discount_id
  321. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='1811'
  322. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=1811
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  323. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=1811
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  324. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=1811
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  325. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=1811
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  326. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%product_id=1811%'
      AND published=1
  327. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%page=shop.ask%'
      AND published=1
  328. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=1811
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  329. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=1811
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  330. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=1811
  331. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=1811
      AND `file_is_image`=1
      AND `file_published`=1
  332. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=1811
  333. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=1
      AND `file_published`=1
  334. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=1811
      AND `file_is_image`=0
      AND `file_published`=1
  335. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id='1811'
  336. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=0
      AND `file_published`=1
  337. SELECT votes, allvotes, rating
      FROM jos_vm_product_votes
      WHERE product_id='1811'
  338. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%product_id=1526%'
      AND published=1
  339. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%category_id=57%'
      AND published=1
  340. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%flypage=flypage.tpl%'
      AND published=1
  341. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%page=shop.product_details%'
      AND published=1
  342. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=1526
  343. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='1526'
      AND (start_date<='1696148487' OR start_date=0)
      AND (end_date>='1696116960' OR end_date=0)
      AND product_discount_id=discount_id
  344. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=1526
  345. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1696148487' OR start_date=0)
      AND (end_date>='1696116960' OR end_date=0)
      AND product_discount_id=discount_id
  346. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='1526'
  347. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=1526
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  348. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=1526
  349. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=1526
  350. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=1526
      AND `file_is_image`=1
      AND `file_published`=1
  351. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=1526
  352. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=1
      AND `file_published`=1
  353. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=1526
      AND `file_is_image`=0
      AND `file_published`=1
  354. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id='1526'
  355. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=0
      AND `file_published`=1
  356. SELECT votes, allvotes, rating
      FROM jos_vm_product_votes
      WHERE product_id='1526'
  357. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=1526
  358. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=1526
  359. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%product_id=3086%'
      AND published=1
  360. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%category_id=46%'
      AND published=1
  361. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%flypage=flypage.tpl%'
      AND published=1
  362. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%page=shop.product_details%'
      AND published=1
  363. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=3086
  364. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='3086'
      AND (start_date<='1696148487' OR start_date=0)
      AND (end_date>='1696116960' OR end_date=0)
      AND product_discount_id=discount_id
  365. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=3086
  366. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1696148487' OR start_date=0)
      AND (end_date>='1696116960' OR end_date=0)
      AND product_discount_id=discount_id
  367. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='3086'
  368. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=3086
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  369. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=3086
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  370. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=3086
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  371. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=3086
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  372. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%product_id=3086%'
      AND published=1
  373. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%page=shop.ask%'
      AND published=1
  374. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=3086
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  375. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=3086
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  376. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=3086
  377. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=3086
      AND `file_is_image`=1
      AND `file_published`=1
  378. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=3086
  379. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=1
      AND `file_published`=1
  380. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=3086
      AND `file_is_image`=0
      AND `file_published`=1
  381. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id='3086'
  382. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=0
      AND `file_published`=1
  383. SELECT votes, allvotes, rating
      FROM jos_vm_product_votes
      WHERE product_id='3086'
  384. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%product_id=305%'
      AND published=1
  385. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%category_id=41%'
      AND published=1
  386. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%flypage=flypage.tpl%'
      AND published=1
  387. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%page=shop.product_details%'
      AND published=1
  388. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=305
  389. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='305'
      AND (start_date<='1696148487' OR start_date=0)
      AND (end_date>='1696116960' OR end_date=0)
      AND product_discount_id=discount_id
  390. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=305
  391. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1696148487' OR start_date=0)
      AND (end_date>='1696116960' OR end_date=0)
      AND product_discount_id=discount_id
  392. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='305'
  393. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=305
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  394. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=305
  395. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=305
  396. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=305
      AND `file_is_image`=1
      AND `file_published`=1
  397. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=305
  398. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=1
      AND `file_published`=1
  399. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=305
      AND `file_is_image`=0
      AND `file_published`=1
  400. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id='305'
  401. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=0
      AND `file_published`=1
  402. SELECT votes, allvotes, rating
      FROM jos_vm_product_votes
      WHERE product_id='305'
  403. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=305
  404. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=305
  405. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%product_id=310%'
      AND published=1
  406. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%category_id=41%'
      AND published=1
  407. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%flypage=flypage.tpl%'
      AND published=1
  408. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%page=shop.product_details%'
      AND published=1
  409. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=310
  410. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='310'
      AND (start_date<='1696148487' OR start_date=0)
      AND (end_date>='1696116960' OR end_date=0)
      AND product_discount_id=discount_id
  411. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=310
  412. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1696148487' OR start_date=0)
      AND (end_date>='1696116960' OR end_date=0)
      AND product_discount_id=discount_id
  413. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='310'
  414. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=310
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  415. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=310
  416. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=310
  417. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=310
      AND `file_is_image`=1
      AND `file_published`=1
  418. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=310
  419. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=1
      AND `file_published`=1
  420. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=310
      AND `file_is_image`=0
      AND `file_published`=1
  421. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id='310'
  422. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=0
      AND `file_published`=1
  423. SELECT votes, allvotes, rating
      FROM jos_vm_product_votes
      WHERE product_id='310'
  424. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=310
  425. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=310
  426. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%product_id=311%'
      AND published=1
  427. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%category_id=41%'
      AND published=1
  428. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%flypage=flypage.tpl%'
      AND published=1
  429. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%page=shop.product_details%'
      AND published=1
  430. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=311
  431. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='311'
      AND (start_date<='1696148487' OR start_date=0)
      AND (end_date>='1696116960' OR end_date=0)
      AND product_discount_id=discount_id
  432. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=311
  433. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1696148487' OR start_date=0)
      AND (end_date>='1696116960' OR end_date=0)
      AND product_discount_id=discount_id
  434. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='311'
  435. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=311
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  436. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=311
  437. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=311
  438. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=311
      AND `file_is_image`=1
      AND `file_published`=1
  439. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=311
  440. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=1
      AND `file_published`=1
  441. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=311
      AND `file_is_image`=0
      AND `file_published`=1
  442. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id='311'
  443. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=0
      AND `file_published`=1
  444. SELECT votes, allvotes, rating
      FROM jos_vm_product_votes
      WHERE product_id='311'
  445. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=311
  446. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=311
  447. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%product_id=312%'
      AND published=1
  448. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%category_id=41%'
      AND published=1
  449. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%flypage=flypage.tpl%'
      AND published=1
  450. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%page=shop.product_details%'
      AND published=1
  451. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=312
  452. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='312'
      AND (start_date<='1696148487' OR start_date=0)
      AND (end_date>='1696116960' OR end_date=0)
      AND product_discount_id=discount_id
  453. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=312
  454. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1696148487' OR start_date=0)
      AND (end_date>='1696116960' OR end_date=0)
      AND product_discount_id=discount_id
  455. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='312'
  456. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=312
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  457. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=312
  458. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=312
  459. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=312
      AND `file_is_image`=1
      AND `file_published`=1
  460. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=312
  461. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=1
      AND `file_published`=1
  462. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=312
      AND `file_is_image`=0
      AND `file_published`=1
  463. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id='312'
  464. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=0
      AND `file_published`=1
  465. SELECT votes, allvotes, rating
      FROM jos_vm_product_votes
      WHERE product_id='312'
  466. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=312
  467. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=312
  468. SELECT DISTINCT product_sku,product_id,product_name,product_s_desc,product_thumb_image, product_full_image, product_in_stock, product_url
      FROM jos_vm_product
      WHERE (jos_vm_product.product_parent_id='' OR jos_vm_product.product_parent_id='0')
      AND vendor_id='1'
      AND jos_vm_product.product_publish='Y'
      AND jos_vm_product.product_special='Y'
      ORDER BY RAND()
      LIMIT 0, 10
  469. SELECT `pageid`
      FROM jos_sh404sef_pageids
      WHERE `newurl`='index.php?option=com_virtuemart&Itemid=1&category_id=0&lang=bg&limit=20&limitstart=240&page=shop.browse&vmcchk=1';
  470. 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 = 1 OR mm.menuid = 0 )
      ORDER BY POSITION, ordering
  471. SELECT p.product_sku, p.product_id, p.product_name, p.product_url, p.product_s_desc, product_thumb_image, product_full_image, c.category_id, c.category_flypage
      FROM jos_vm_product AS p JOIN jos_vm_product_category_xref AS pc
      ON p.product_id=pc.product_id JOIN jos_vm_category AS c
      ON pc.category_id=c.category_id
      WHERE p.product_publish = 'Y'
      AND c.category_publish = 'Y'
      AND product_parent_id=0  
      ORDER BY RAND()
      LIMIT 20
  472. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%product_id=79%'
      AND published=1
  473. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%category_id=7%'
      AND published=1
  474. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%flypage=flypage.tpl%'
      AND published=1
  475. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%page=shop.product_details%'
      AND published=1
  476. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%product_id=1810%'
      AND published=1
  477. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%category_id=83%'
      AND published=1
  478. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%flypage=flypage.tpl%'
      AND published=1
  479. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%page=shop.product_details%'
      AND published=1
  480. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%product_id=2094%'
      AND published=1
  481. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%category_id=86%'
      AND published=1
  482. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%flypage=flypage.tpl%'
      AND published=1
  483. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%page=shop.product_details%'
      AND published=1
  484. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%product_id=27%'
      AND published=1
  485. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%category_id=2%'
      AND published=1
  486. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%flypage=flypage.tpl%'
      AND published=1
  487. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%page=shop.product_details%'
      AND published=1
  488. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%product_id=1786%'
      AND published=1
  489. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%category_id=76%'
      AND published=1
  490. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%flypage=flypage.tpl%'
      AND published=1
  491. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%page=shop.product_details%'
      AND published=1
  492. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%product_id=3053%'
      AND published=1
  493. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%category_id=37%'
      AND published=1
  494. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%flypage=flypage.tpl%'
      AND published=1
  495. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%page=shop.product_details%'
      AND published=1
  496. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%product_id=1737%'
      AND published=1
  497. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%category_id=71%'
      AND published=1
  498. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%flypage=flypage.tpl%'
      AND published=1
  499. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%page=shop.product_details%'
      AND published=1
  500. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%product_id=2462%'
      AND published=1
  501. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%category_id=101%'
      AND published=1
  502. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%flypage=flypage.tpl%'
      AND published=1
  503. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%page=shop.product_details%'
      AND published=1
  504. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%product_id=338%'
      AND published=1
  505. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%category_id=41%'
      AND published=1
  506. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%flypage=flypage.tpl%'
      AND published=1
  507. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%page=shop.product_details%'
      AND published=1
  508. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%product_id=2823%'
      AND published=1
  509. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%category_id=127%'
      AND published=1
  510. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%flypage=flypage.tpl%'
      AND published=1
  511. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%page=shop.product_details%'
      AND published=1
  512. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%product_id=1671%'
      AND published=1
  513. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%category_id=69%'
      AND published=1
  514. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%flypage=flypage.tpl%'
      AND published=1
  515. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%page=shop.product_details%'
      AND published=1
  516. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%product_id=1835%'
      AND published=1
  517. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%category_id=84%'
      AND published=1
  518. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%flypage=flypage.tpl%'
      AND published=1
  519. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%page=shop.product_details%'
      AND published=1
  520. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%product_id=105%'
      AND published=1
  521. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%category_id=10%'
      AND published=1
  522. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%flypage=flypage.tpl%'
      AND published=1
  523. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%page=shop.product_details%'
      AND published=1
  524. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%product_id=3049%'
      AND published=1
  525. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%category_id=128%'
      AND published=1
  526. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%flypage=flypage.tpl%'
      AND published=1
  527. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%page=shop.product_details%'
      AND published=1
  528. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%product_id=310%'
      AND published=1
  529. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%category_id=41%'
      AND published=1
  530. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%flypage=flypage.tpl%'
      AND published=1
  531. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%page=shop.product_details%'
      AND published=1
  532. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%product_id=137%'
      AND published=1
  533. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%category_id=21%'
      AND published=1
  534. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%flypage=flypage.tpl%'
      AND published=1
  535. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%page=shop.product_details%'
      AND published=1
  536. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%product_id=70%'
      AND published=1
  537. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%category_id=7%'
      AND published=1
  538. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%flypage=flypage.tpl%'
      AND published=1
  539. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%page=shop.product_details%'
      AND published=1
  540. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%product_id=166%'
      AND published=1
  541. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%category_id=23%'
      AND published=1
  542. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%flypage=flypage.tpl%'
      AND published=1
  543. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%page=shop.product_details%'
      AND published=1
  544. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%product_id=1845%'
      AND published=1
  545. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%category_id=84%'
      AND published=1
  546. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%flypage=flypage.tpl%'
      AND published=1
  547. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%page=shop.product_details%'
      AND published=1
  548. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%product_id=2210%'
      AND published=1
  549. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%category_id=87%'
      AND published=1
  550. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%flypage=flypage.tpl%'
      AND published=1
  551. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%page=shop.product_details%'
      AND published=1
  552. SELECT category_name, category_id, category_child_id
      FROM jos_vm_category AS a, jos_vm_category_xref AS b
      WHERE a.category_publish='Y'
      AND  b.category_parent_id='0'
      AND a.category_id=b.category_child_id
      ORDER BY category_parent_id, list_order, category_name ASC
  553. SELECT category_name, category_id, category_child_id
      FROM jos_vm_category AS a, jos_vm_category_xref AS b
      WHERE a.category_publish='Y'
      AND  b.category_parent_id='1'
      AND a.category_id=b.category_child_id
      ORDER BY category_parent_id, list_order, category_name ASC
  554. SELECT category_name, category_id, category_child_id
      FROM jos_vm_category AS a, jos_vm_category_xref AS b
      WHERE a.category_publish='Y'
      AND  b.category_parent_id='17'
      AND a.category_id=b.category_child_id
      ORDER BY category_parent_id, list_order, category_name ASC
  555. SELECT category_name, category_id, category_child_id
      FROM jos_vm_category AS a, jos_vm_category_xref AS b
      WHERE a.category_publish='Y'
      AND  b.category_parent_id='43'
      AND a.category_id=b.category_child_id
      ORDER BY category_parent_id, list_order, category_name ASC
  556. SELECT category_name, category_id, category_child_id
      FROM jos_vm_category AS a, jos_vm_category_xref AS b
      WHERE a.category_publish='Y'
      AND  b.category_parent_id='42'
      AND a.category_id=b.category_child_id
      ORDER BY category_parent_id, list_order, category_name ASC
  557. SELECT category_name, category_id, category_child_id
      FROM jos_vm_category AS a, jos_vm_category_xref AS b
      WHERE a.category_publish='Y'
      AND  b.category_parent_id='97'
      AND a.category_id=b.category_child_id
      ORDER BY category_parent_id, list_order, category_name ASC
  558. SELECT category_name, category_id, category_child_id
      FROM jos_vm_category AS a, jos_vm_category_xref AS b
      WHERE a.category_publish='Y'
      AND  b.category_parent_id='41'
      AND a.category_id=b.category_child_id
      ORDER BY category_parent_id, list_order, category_name ASC
  559. SELECT category_name, category_id, category_child_id
      FROM jos_vm_category AS a, jos_vm_category_xref AS b
      WHERE a.category_publish='Y'
      AND  b.category_parent_id='44'
      AND a.category_id=b.category_child_id
      ORDER BY category_parent_id, list_order, category_name ASC
  560. SELECT category_name, category_id, category_child_id
      FROM jos_vm_category AS a, jos_vm_category_xref AS b
      WHERE a.category_publish='Y'
      AND  b.category_parent_id='45'
      AND a.category_id=b.category_child_id
      ORDER BY category_parent_id, list_order, category_name ASC
  561. SELECT category_name, category_id, category_child_id
      FROM jos_vm_category AS a, jos_vm_category_xref AS b
      WHERE a.category_publish='Y'
      AND  b.category_parent_id='47'
      AND a.category_id=b.category_child_id
      ORDER BY category_parent_id, list_order, category_name ASC
  562. SELECT category_name, category_id, category_child_id
      FROM jos_vm_category AS a, jos_vm_category_xref AS b
      WHERE a.category_publish='Y'
      AND  b.category_parent_id='19'
      AND a.category_id=b.category_child_id
      ORDER BY category_parent_id, list_order, category_name ASC
  563. SELECT category_name, category_id, category_child_id
      FROM jos_vm_category AS a, jos_vm_category_xref AS b
      WHERE a.category_publish='Y'
      AND  b.category_parent_id='2'
      AND a.category_id=b.category_child_id
      ORDER BY category_parent_id, list_order, category_name ASC
  564. SELECT category_name, category_id, category_child_id
      FROM jos_vm_category AS a, jos_vm_category_xref AS b
      WHERE a.category_publish='Y'
      AND  b.category_parent_id='51'
      AND a.category_id=b.category_child_id
      ORDER BY category_parent_id, list_order, category_name ASC
  565. SELECT category_name, category_id, category_child_id
      FROM jos_vm_category AS a, jos_vm_category_xref AS b
      WHERE a.category_publish='Y'
      AND  b.category_parent_id='131'
      AND a.category_id=b.category_child_id
      ORDER BY category_parent_id, list_order, category_name ASC
  566. SELECT category_name, category_id, category_child_id
      FROM jos_vm_category AS a, jos_vm_category_xref AS b
      WHERE a.category_publish='Y'
      AND  b.category_parent_id='73'
      AND a.category_id=b.category_child_id
      ORDER BY category_parent_id, list_order, category_name ASC
  567. SELECT category_name, category_id, category_child_id
      FROM jos_vm_category AS a, jos_vm_category_xref AS b
      WHERE a.category_publish='Y'
      AND  b.category_parent_id='71'
      AND a.category_id=b.category_child_id
      ORDER BY category_parent_id, list_order, category_name ASC
  568. SELECT category_name, category_id, category_child_id
      FROM jos_vm_category AS a, jos_vm_category_xref AS b
      WHERE a.category_publish='Y'
      AND  b.category_parent_id='75'
      AND a.category_id=b.category_child_id
      ORDER BY category_parent_id, list_order, category_name ASC
  569. SELECT category_name, category_id, category_child_id
      FROM jos_vm_category AS a, jos_vm_category_xref AS b
      WHERE a.category_publish='Y'
      AND  b.category_parent_id='74'
      AND a.category_id=b.category_child_id
      ORDER BY category_parent_id, list_order, category_name ASC
  570. SELECT category_name, category_id, category_child_id
      FROM jos_vm_category AS a, jos_vm_category_xref AS b
      WHERE a.category_publish='Y'
      AND  b.category_parent_id='81'
      AND a.category_id=b.category_child_id
      ORDER BY category_parent_id, list_order, category_name ASC
  571. SELECT category_name, category_id, category_child_id
      FROM jos_vm_category AS a, jos_vm_category_xref AS b
      WHERE a.category_publish='Y'
      AND  b.category_parent_id='130'
      AND a.category_id=b.category_child_id
      ORDER BY category_parent_id, list_order, category_name ASC
  572. SELECT category_name, category_id, category_child_id
      FROM jos_vm_category AS a, jos_vm_category_xref AS b
      WHERE a.category_publish='Y'
      AND  b.category_parent_id='39'
      AND a.category_id=b.category_child_id
      ORDER BY category_parent_id, list_order, category_name ASC
  573. SELECT category_name, category_id, category_child_id
      FROM jos_vm_category AS a, jos_vm_category_xref AS b
      WHERE a.category_publish='Y'
      AND  b.category_parent_id='109'
      AND a.category_id=b.category_child_id
      ORDER BY category_parent_id, list_order, category_name ASC
  574. SELECT category_name, category_id, category_child_id
      FROM jos_vm_category AS a, jos_vm_category_xref AS b
      WHERE a.category_publish='Y'
      AND  b.category_parent_id='112'
      AND a.category_id=b.category_child_id
      ORDER BY category_parent_id, list_order, category_name ASC
  575. SELECT category_name, category_id, category_child_id
      FROM jos_vm_category AS a, jos_vm_category_xref AS b
      WHERE a.category_publish='Y'
      AND  b.category_parent_id='113'
      AND a.category_id=b.category_child_id
      ORDER BY category_parent_id, list_order, category_name ASC
  576. SELECT category_name, category_id, category_child_id
      FROM jos_vm_category AS a, jos_vm_category_xref AS b
      WHERE a.category_publish='Y'
      AND  b.category_parent_id='114'
      AND a.category_id=b.category_child_id
      ORDER BY category_parent_id, list_order, category_name ASC
  577. SELECT category_name, category_id, category_child_id
      FROM jos_vm_category AS a, jos_vm_category_xref AS b
      WHERE a.category_publish='Y'
      AND  b.category_parent_id='115'
      AND a.category_id=b.category_child_id
      ORDER BY category_parent_id, list_order, category_name ASC
  578. SELECT category_name, category_id, category_child_id
      FROM jos_vm_category AS a, jos_vm_category_xref AS b
      WHERE a.category_publish='Y'
      AND  b.category_parent_id='116'
      AND a.category_id=b.category_child_id
      ORDER BY category_parent_id, list_order, category_name ASC
  579. SELECT category_name, category_id, category_child_id
      FROM jos_vm_category AS a, jos_vm_category_xref AS b
      WHERE a.category_publish='Y'
      AND  b.category_parent_id='117'
      AND a.category_id=b.category_child_id
      ORDER BY category_parent_id, list_order, category_name ASC
  580. SELECT category_name, category_id, category_child_id
      FROM jos_vm_category AS a, jos_vm_category_xref AS b
      WHERE a.category_publish='Y'
      AND  b.category_parent_id='122'
      AND a.category_id=b.category_child_id
      ORDER BY category_parent_id, list_order, category_name ASC
  581. SELECT category_name, category_id, category_child_id
      FROM jos_vm_category AS a, jos_vm_category_xref AS b
      WHERE a.category_publish='Y'
      AND  b.category_parent_id='110'
      AND a.category_id=b.category_child_id
      ORDER BY category_parent_id, list_order, category_name ASC
  582. SELECT category_name, category_id, category_child_id
      FROM jos_vm_category AS a, jos_vm_category_xref AS b
      WHERE a.category_publish='Y'
      AND  b.category_parent_id='49'
      AND a.category_id=b.category_child_id
      ORDER BY category_parent_id, list_order, category_name ASC
  583. SELECT category_name, category_id, category_child_id
      FROM jos_vm_category AS a, jos_vm_category_xref AS b
      WHERE a.category_publish='Y'
      AND  b.category_parent_id='86'
      AND a.category_id=b.category_child_id
      ORDER BY category_parent_id, list_order, category_name ASC
  584. SELECT category_name, category_id, category_child_id
      FROM jos_vm_category AS a, jos_vm_category_xref AS b
      WHERE a.category_publish='Y'
      AND  b.category_parent_id='87'
      AND a.category_id=b.category_child_id
      ORDER BY category_parent_id, list_order, category_name ASC
  585. SELECT category_name, category_id, category_child_id
      FROM jos_vm_category AS a, jos_vm_category_xref AS b
      WHERE a.category_publish='Y'
      AND  b.category_parent_id='50'
      AND a.category_id=b.category_child_id
      ORDER BY category_parent_id, list_order, category_name ASC
  586. SELECT category_name, category_id, category_child_id
      FROM jos_vm_category AS a, jos_vm_category_xref AS b
      WHERE a.category_publish='Y'
      AND  b.category_parent_id='85'
      AND a.category_id=b.category_child_id
      ORDER BY category_parent_id, list_order, category_name ASC
  587. SELECT category_name, category_id, category_child_id
      FROM jos_vm_category AS a, jos_vm_category_xref AS b
      WHERE a.category_publish='Y'
      AND  b.category_parent_id='48'
      AND a.category_id=b.category_child_id
      ORDER BY category_parent_id, list_order, category_name ASC
  588. SELECT category_name, category_id, category_child_id
      FROM jos_vm_category AS a, jos_vm_category_xref AS b
      WHERE a.category_publish='Y'
      AND  b.category_parent_id='123'
      AND a.category_id=b.category_child_id
      ORDER BY category_parent_id, list_order, category_name ASC
  589. SELECT category_name, category_id, category_child_id
      FROM jos_vm_category AS a, jos_vm_category_xref AS b
      WHERE a.category_publish='Y'
      AND  b.category_parent_id='12'
      AND a.category_id=b.category_child_id
      ORDER BY category_parent_id, list_order, category_name ASC
  590. SELECT category_name, category_id, category_child_id
      FROM jos_vm_category AS a, jos_vm_category_xref AS b
      WHERE a.category_publish='Y'
      AND  b.category_parent_id='6'
      AND a.category_id=b.category_child_id
      ORDER BY category_parent_id, list_order, category_name ASC
  591. SELECT category_name, category_id, category_child_id
      FROM jos_vm_category AS a, jos_vm_category_xref AS b
      WHERE a.category_publish='Y'
      AND  b.category_parent_id='3'
      AND a.category_id=b.category_child_id
      ORDER BY category_parent_id, list_order, category_name ASC
  592. SELECT category_name, category_id, category_child_id
      FROM jos_vm_category AS a, jos_vm_category_xref AS b
      WHERE a.category_publish='Y'
      AND  b.category_parent_id='9'
      AND a.category_id=b.category_child_id
      ORDER BY category_parent_id, list_order, category_name ASC
  593. SELECT category_name, category_id, category_child_id
      FROM jos_vm_category AS a, jos_vm_category_xref AS b
      WHERE a.category_publish='Y'
      AND  b.category_parent_id='10'
      AND a.category_id=b.category_child_id
      ORDER BY category_parent_id, list_order, category_name ASC
  594. SELECT category_name, category_id, category_child_id
      FROM jos_vm_category AS a, jos_vm_category_xref AS b
      WHERE a.category_publish='Y'
      AND  b.category_parent_id='126'
      AND a.category_id=b.category_child_id
      ORDER BY category_parent_id, list_order, category_name ASC
  595. SELECT category_name, category_id, category_child_id
      FROM jos_vm_category AS a, jos_vm_category_xref AS b
      WHERE a.category_publish='Y'
      AND  b.category_parent_id='127'
      AND a.category_id=b.category_child_id
      ORDER BY category_parent_id, list_order, category_name ASC
  596. SELECT category_name, category_id, category_child_id
      FROM jos_vm_category AS a, jos_vm_category_xref AS b
      WHERE a.category_publish='Y'
      AND  b.category_parent_id='128'
      AND a.category_id=b.category_child_id
      ORDER BY category_parent_id, list_order, category_name ASC
  597. SELECT category_name, category_id, category_child_id
      FROM jos_vm_category AS a, jos_vm_category_xref AS b
      WHERE a.category_publish='Y'
      AND  b.category_parent_id='129'
      AND a.category_id=b.category_child_id
      ORDER BY category_parent_id, list_order, category_name ASC
  598. SELECT category_name, category_id, category_child_id
      FROM jos_vm_category AS a, jos_vm_category_xref AS b
      WHERE a.category_publish='Y'
      AND  b.category_parent_id='132'
      AND a.category_id=b.category_child_id
      ORDER BY category_parent_id, list_order, category_name ASC
  599. SELECT category_name, category_id, category_child_id
      FROM jos_vm_category AS a, jos_vm_category_xref AS b
      WHERE a.category_publish='Y'
      AND  b.category_parent_id='133'
      AND a.category_id=b.category_child_id
      ORDER BY category_parent_id, list_order, category_name ASC
  600. SELECT category_name, category_id, category_child_id
      FROM jos_vm_category AS a, jos_vm_category_xref AS b
      WHERE a.category_publish='Y'
      AND  b.category_parent_id='14'
      AND a.category_id=b.category_child_id
      ORDER BY category_parent_id, list_order, category_name ASC
  601. SELECT category_name, category_id, category_child_id
      FROM jos_vm_category AS a, jos_vm_category_xref AS b
      WHERE a.category_publish='Y'
      AND  b.category_parent_id='13'
      AND a.category_id=b.category_child_id
      ORDER BY category_parent_id, list_order, category_name ASC
  602. SELECT category_name, category_id, category_child_id
      FROM jos_vm_category AS a, jos_vm_category_xref AS b
      WHERE a.category_publish='Y'
      AND  b.category_parent_id='7'
      AND a.category_id=b.category_child_id
      ORDER BY category_parent_id, list_order, category_name ASC
  603. SELECT category_name, category_id, category_child_id
      FROM jos_vm_category AS a, jos_vm_category_xref AS b
      WHERE a.category_publish='Y'
      AND  b.category_parent_id='77'
      AND a.category_id=b.category_child_id
      ORDER BY category_parent_id, list_order, category_name ASC
  604. SELECT category_name, category_id, category_child_id
      FROM jos_vm_category AS a, jos_vm_category_xref AS b
      WHERE a.category_publish='Y'
      AND  b.category_parent_id='82'
      AND a.category_id=b.category_child_id
      ORDER BY category_parent_id, list_order, category_name ASC
  605. SELECT category_name, category_id, category_child_id
      FROM jos_vm_category AS a, jos_vm_category_xref AS b
      WHERE a.category_publish='Y'
      AND  b.category_parent_id='96'
      AND a.category_id=b.category_child_id
      ORDER BY category_parent_id, list_order, category_name ASC
  606. SELECT category_name, category_id, category_child_id
      FROM jos_vm_category AS a, jos_vm_category_xref AS b
      WHERE a.category_publish='Y'
      AND  b.category_parent_id='78'
      AND a.category_id=b.category_child_id
      ORDER BY category_parent_id, list_order, category_name ASC
  607. SELECT category_name, category_id, category_child_id
      FROM jos_vm_category AS a, jos_vm_category_xref AS b
      WHERE a.category_publish='Y'
      AND  b.category_parent_id='83'
      AND a.category_id=b.category_child_id
      ORDER BY category_parent_id, list_order, category_name ASC
  608. SELECT category_name, category_id, category_child_id
      FROM jos_vm_category AS a, jos_vm_category_xref AS b
      WHERE a.category_publish='Y'
      AND  b.category_parent_id='8'
      AND a.category_id=b.category_child_id
      ORDER BY category_parent_id, list_order, category_name ASC
  609. SELECT category_name, category_id, category_child_id
      FROM jos_vm_category AS a, jos_vm_category_xref AS b
      WHERE a.category_publish='Y'
      AND  b.category_parent_id='84'
      AND a.category_id=b.category_child_id
      ORDER BY category_parent_id, list_order, category_name ASC
  610. SELECT category_name, category_id, category_child_id
      FROM jos_vm_category AS a, jos_vm_category_xref AS b
      WHERE a.category_publish='Y'
      AND  b.category_parent_id='22'
      AND a.category_id=b.category_child_id
      ORDER BY category_parent_id, list_order, category_name ASC
  611. SELECT category_name, category_id, category_child_id
      FROM jos_vm_category AS a, jos_vm_category_xref AS b
      WHERE a.category_publish='Y'
      AND  b.category_parent_id='69'
      AND a.category_id=b.category_child_id
      ORDER BY category_parent_id, list_order, category_name ASC
  612. SELECT category_name, category_id, category_child_id
      FROM jos_vm_category AS a, jos_vm_category_xref AS b
      WHERE a.category_publish='Y'
      AND  b.category_parent_id='20'
      AND a.category_id=b.category_child_id
      ORDER BY category_parent_id, list_order, category_name ASC
  613. SELECT category_name, category_id, category_child_id
      FROM jos_vm_category AS a, jos_vm_category_xref AS b
      WHERE a.category_publish='Y'
      AND  b.category_parent_id='70'
      AND a.category_id=b.category_child_id
      ORDER BY category_parent_id, list_order, category_name ASC
  614. SELECT category_name, category_id, category_child_id
      FROM jos_vm_category AS a, jos_vm_category_xref AS b
      WHERE a.category_publish='Y'
      AND  b.category_parent_id='21'
      AND a.category_id=b.category_child_id
      ORDER BY category_parent_id, list_order, category_name ASC
  615. SELECT category_name, category_id, category_child_id
      FROM jos_vm_category AS a, jos_vm_category_xref AS b
      WHERE a.category_publish='Y'
      AND  b.category_parent_id='25'
      AND a.category_id=b.category_child_id
      ORDER BY category_parent_id, list_order, category_name ASC
  616. SELECT category_name, category_id, category_child_id
      FROM jos_vm_category AS a, jos_vm_category_xref AS b
      WHERE a.category_publish='Y'
      AND  b.category_parent_id='24'
      AND a.category_id=b.category_child_id
      ORDER BY category_parent_id, list_order, category_name ASC
  617. SELECT category_name, category_id, category_child_id
      FROM jos_vm_category AS a, jos_vm_category_xref AS b
      WHERE a.category_publish='Y'
      AND  b.category_parent_id='23'
      AND a.category_id=b.category_child_id
      ORDER BY category_parent_id, list_order, category_name ASC
  618. SELECT category_name, category_id, category_child_id
      FROM jos_vm_category AS a, jos_vm_category_xref AS b
      WHERE a.category_publish='Y'
      AND  b.category_parent_id='76'
      AND a.category_id=b.category_child_id
      ORDER BY category_parent_id, list_order, category_name ASC
  619. SELECT category_name, category_id, category_child_id
      FROM jos_vm_category AS a, jos_vm_category_xref AS b
      WHERE a.category_publish='Y'
      AND  b.category_parent_id='80'
      AND a.category_id=b.category_child_id
      ORDER BY category_parent_id, list_order, category_name ASC
  620. SELECT category_name, category_id, category_child_id
      FROM jos_vm_category AS a, jos_vm_category_xref AS b
      WHERE a.category_publish='Y'
      AND  b.category_parent_id='79'
      AND a.category_id=b.category_child_id
      ORDER BY category_parent_id, list_order, category_name ASC
  621. SELECT category_name, category_id, category_child_id
      FROM jos_vm_category AS a, jos_vm_category_xref AS b
      WHERE a.category_publish='Y'
      AND  b.category_parent_id='118'
      AND a.category_id=b.category_child_id
      ORDER BY category_parent_id, list_order, category_name ASC
  622. SELECT category_name, category_id, category_child_id
      FROM jos_vm_category AS a, jos_vm_category_xref AS b
      WHERE a.category_publish='Y'
      AND  b.category_parent_id='125'
      AND a.category_id=b.category_child_id
      ORDER BY category_parent_id, list_order, category_name ASC
  623. SELECT category_name, category_id, category_child_id
      FROM jos_vm_category AS a, jos_vm_category_xref AS b
      WHERE a.category_publish='Y'
      AND  b.category_parent_id='119'
      AND a.category_id=b.category_child_id
      ORDER BY category_parent_id, list_order, category_name ASC
  624. SELECT category_name, category_id, category_child_id
      FROM jos_vm_category AS a, jos_vm_category_xref AS b
      WHERE a.category_publish='Y'
      AND  b.category_parent_id='46'
      AND a.category_id=b.category_child_id
      ORDER BY category_parent_id, list_order, category_name ASC
  625. SELECT category_name, category_id, category_child_id
      FROM jos_vm_category AS a, jos_vm_category_xref AS b
      WHERE a.category_publish='Y'
      AND  b.category_parent_id='53'
      AND a.category_id=b.category_child_id
      ORDER BY category_parent_id, list_order, category_name ASC
  626. SELECT category_name, category_id, category_child_id
      FROM jos_vm_category AS a, jos_vm_category_xref AS b
      WHERE a.category_publish='Y'
      AND  b.category_parent_id='54'
      AND a.category_id=b.category_child_id
      ORDER BY category_parent_id, list_order, category_name ASC
  627. SELECT category_name, category_id, category_child_id
      FROM jos_vm_category AS a, jos_vm_category_xref AS b
      WHERE a.category_publish='Y'
      AND  b.category_parent_id='55'
      AND a.category_id=b.category_child_id
      ORDER BY category_parent_id, list_order, category_name ASC
  628. SELECT category_name, category_id, category_child_id
      FROM jos_vm_category AS a, jos_vm_category_xref AS b
      WHERE a.category_publish='Y'
      AND  b.category_parent_id='56'
      AND a.category_id=b.category_child_id
      ORDER BY category_parent_id, list_order, category_name ASC
  629. SELECT category_name, category_id, category_child_id
      FROM jos_vm_category AS a, jos_vm_category_xref AS b
      WHERE a.category_publish='Y'
      AND  b.category_parent_id='57'
      AND a.category_id=b.category_child_id
      ORDER BY category_parent_id, list_order, category_name ASC
  630. SELECT category_name, category_id, category_child_id
      FROM jos_vm_category AS a, jos_vm_category_xref AS b
      WHERE a.category_publish='Y'
      AND  b.category_parent_id='58'
      AND a.category_id=b.category_child_id
      ORDER BY category_parent_id, list_order, category_name ASC
  631. SELECT category_name, category_id, category_child_id
      FROM jos_vm_category AS a, jos_vm_category_xref AS b
      WHERE a.category_publish='Y'
      AND  b.category_parent_id='59'
      AND a.category_id=b.category_child_id
      ORDER BY category_parent_id, list_order, category_name ASC
  632. SELECT category_name, category_id, category_child_id
      FROM jos_vm_category AS a, jos_vm_category_xref AS b
      WHERE a.category_publish='Y'
      AND  b.category_parent_id='60'
      AND a.category_id=b.category_child_id
      ORDER BY category_parent_id, list_order, category_name ASC
  633. SELECT category_name, category_id, category_child_id
      FROM jos_vm_category AS a, jos_vm_category_xref AS b
      WHERE a.category_publish='Y'
      AND  b.category_parent_id='61'
      AND a.category_id=b.category_child_id
      ORDER BY category_parent_id, list_order, category_name ASC
  634. SELECT category_name, category_id, category_child_id
      FROM jos_vm_category AS a, jos_vm_category_xref AS b
      WHERE a.category_publish='Y'
      AND  b.category_parent_id='62'
      AND a.category_id=b.category_child_id
      ORDER BY category_parent_id, list_order, category_name ASC
  635. SELECT category_name, category_id, category_child_id
      FROM jos_vm_category AS a, jos_vm_category_xref AS b
      WHERE a.category_publish='Y'
      AND  b.category_parent_id='63'
      AND a.category_id=b.category_child_id
      ORDER BY category_parent_id, list_order, category_name ASC
  636. SELECT category_name, category_id, category_child_id
      FROM jos_vm_category AS a, jos_vm_category_xref AS b
      WHERE a.category_publish='Y'
      AND  b.category_parent_id='64'
      AND a.category_id=b.category_child_id
      ORDER BY category_parent_id, list_order, category_name ASC
  637. SELECT category_name, category_id, category_child_id
      FROM jos_vm_category AS a, jos_vm_category_xref AS b
      WHERE a.category_publish='Y'
      AND  b.category_parent_id='65'
      AND a.category_id=b.category_child_id
      ORDER BY category_parent_id, list_order, category_name ASC
  638. SELECT category_name, category_id, category_child_id
      FROM jos_vm_category AS a, jos_vm_category_xref AS b
      WHERE a.category_publish='Y'
      AND  b.category_parent_id='134'
      AND a.category_id=b.category_child_id
      ORDER BY category_parent_id, list_order, category_name ASC
  639. SELECT category_id, category_description, category_name,category_child_id AS cid, category_parent_id AS pid,list_order, category_publish
                                                   
      FROM jos_vm_category, jos_vm_category_xref
      WHERE jos_vm_category.category_publish='Y'
      AND jos_vm_category.category_id=jos_vm_category_xref.category_child_id
      ORDER BY jos_vm_category.list_order ASC, jos_vm_category.category_name ASC
  640. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%category_id=1%'
      AND published=1
  641. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%page=shop.browse%'
      AND published=1
  642. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%category_id=53%'
      AND published=1
  643. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%page=shop.browse%'
      AND published=1
  644. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%category_id=134%'
      AND published=1
  645. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%page=shop.browse%'
      AND published=1
  646. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%page=shop.browse%'
      AND published=1
  647. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%page=shop.search%'
      AND published=1
  648. SELECT group_id,group_name,group_level
      FROM `jos_vm_auth_group`
      ORDER BY group_level
  649. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%page=shop.registration%'
      AND published=1
  650. SELECT published
      FROM jos_modules
      WHERE module='mod_virtuemart_cart'
  651. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%page=shop.cart%'
      AND published=1
  652. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%page=shop.cart%'
      AND published=1
  653. SELECT *
      FROM jos_jstats_configuration
  654. SELECT exclude, TYPE, tld, id, useragent
      FROM jos_jstats_ipaddresses
      WHERE ip = '44.200.117.166'
  655. SELECT visit_id
      FROM jos_jstats_visits
      WHERE visitor_id = 140270  
      AND CAST(CONCAT(visit_date, ' ', visit_time) AS DATETIME) >= DATE_ADD('2023-10-01 08:21:36', INTERVAL -15 MINUTE)
  656. UPDATE jos_jstats_visits
      SET  visit_date = '2023-10-01', visit_time = '08:21:36'
      WHERE visit_id = '1843528'
  657. SELECT   page_id,   page_title
      FROM   jos_jstats_pages
      WHERE   page = 'http://online.merkury-bg.biz/Joomla/index.php?option=com_virtuemart&amp;category_id=0&amp;page=shop.browse&amp;Itemid=1&amp;limit=20&amp;limitstart=240&amp;vmcchk=1'
      LIMIT 1
  658. INSERT INTO `jos_jstats_impressions` (`page_id`, `visit_id`)
      VALUES (133444,1843528)

Записани заявки от режима на съвместимост

  1. SELECT `lft`, `rgt`
      FROM `jos_core_acl_aro_groups`
      WHERE `name`='Public Frontend'
  2. SELECT g1.id, g1.name, COUNT(g2.name) AS level

      FROM jos_core_acl_aro_groups AS g1

      INNER JOIN jos_core_acl_aro_groups AS g2
      ON g1.lft BETWEEN g2.lft
      AND g2.rgt

      WHERE g1.lft BETWEEN 3
      AND 12

      GROUP BY g1.name

      ORDER BY g1.lft
  3. SELECT `lft`, `rgt`
      FROM `jos_core_acl_aro_groups`
      WHERE `name`='Public Backend'
  4. SELECT g1.id, g1.name, COUNT(g2.name) AS level

      FROM jos_core_acl_aro_groups AS g1

      INNER JOIN jos_core_acl_aro_groups AS g2
      ON g1.lft BETWEEN g2.lft
      AND g2.rgt

      WHERE g1.lft BETWEEN 13
      AND 20

      GROUP BY g1.name

      ORDER BY g1.lft

Езиковите файлове са заредени

Непреведени изрази диагностика

Няма

Непреведени изрази дизайнер

Няма