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


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


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





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

Количка

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: 2020-12-01 18:31:48        
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

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

Резултати 121 - 140 от 638

Michelin - Зимни гуми Pilot Alpin PA3

Michelin - Зимни гуми Pilot Alpin PA3 - Различни размери
[Допълнителна информация...]

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

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

Michelin - Зимни гуми Primacy PA3

Michelin - Зимни гуми Primacy PA3 - Различни размери
[Допълнителна информация...]

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

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

MOTUL 100 2T 1L

Двигателно масло MOTUL 100 2T 1L
[Допълнителна информация...]

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

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


MOTUL 2100 POWER+ 10W40 1L


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

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


MOTUL 2100 POWER+ 10W40 4L


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

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


MOTUL 3000 10W30 4T 1L


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

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


MOTUL 3000 10W40 4T 1L


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

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


MOTUL 3000 10W40 4T 4L


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

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


MOTUL 3000 20W50 4T 1L


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

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


MOTUL 3000 20W50 4T 4L


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

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


MOTUL 300V 10W40 4T FL 1L


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

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


MOTUL 300V 10W40 4T FL 4L


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

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


MOTUL 300V 15W50 4T FL 1L


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

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


MOTUL 300V 15W50 4T FL 4L


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

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


MOTUL 300V 5W30 4T FL 1L


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

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


MOTUL 300V 5W30 4T FL 4L


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

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


MOTUL 300V COMPETITION 15W50 2L


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

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


MOTUL 300V LE MANS 20W60 2L


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

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


MOTUL 300V OFF ROAD 15W60 1L


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

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


MOTUL 300V POWER RACING 5W30 2L


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

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





Покажи №  
Резултати 121 - 140 от 638
Обновено на: Tuesday, 01 December 2020 18:31


 

Времето

Любопитно

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

Application afterLoad: 0.000 seconds, 0.88 MB
Application afterInitialise: 0.042 seconds, 7.68 MB
Application afterRoute: 0.077 seconds, 12.00 MB
Application afterDispatch: 1.713 seconds, 20.76 MB
Application afterRender: 11.523 seconds, 28.01 MB

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

29489672

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

  1. SELECT *
      FROM jos_session
      WHERE session_id = 'd3dce008d25b50435184cdde6d7bd2a3'
  2. DELETE
      FROM jos_session
      WHERE ( TIME < '1606843896' )
  3. SELECT *
      FROM jos_session
      WHERE session_id = 'd3dce008d25b50435184cdde6d7bd2a3'
  4. INSERT INTO `jos_session` ( `session_id`,`time`,`username`,`gid`,`guest`,`client_id` )
      VALUES ( 'd3dce008d25b50435184cdde6d7bd2a3','1606847496','','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=120&vmcchk=1&Itemid=1%' OR sefurl LIKE 'option=com\_virtuemart&category\_id=0&page=shop.browse&Itemid=1&limit=20&limitstart=120&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=120&vmcchk=1&Itemid=1%' OR sefurl LIKE 'index.php?option=com\_virtuemart&category\_id=0&page=shop.browse&Itemid=1&limit=20&limitstart=120&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=120&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=120&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 120, 20
  22. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%product_id=2514%'
      AND published=1
  23. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%category_id=117%'
      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`=2514
  27. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='2514'
      AND (start_date<='1606847498' OR start_date=0)
      AND (end_date>='1606779360' OR end_date=0)
      AND product_discount_id=discount_id
  28. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=2514
  29. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1606847498' OR start_date=0)
      AND (end_date>='1606779360' OR end_date=0)
      AND product_discount_id=discount_id
  30. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='2514'
  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=2514
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  33. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=2514
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  34. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=2514
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  35. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=2514
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  36. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%product_id=2514%'
      AND published=1
  37. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%page=shop.ask%'
      AND published=1
  38. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=2514
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  39. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=2514
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  40. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=2514
  41. 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
  42. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=2514
      AND `file_is_image`=1
      AND `file_published`=1
  43. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=2514
  44. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=1
      AND `file_published`=1
  45. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=2514
      AND `file_is_image`=0
      AND `file_published`=1
  46. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id='2514'
  47. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=0
      AND `file_published`=1
  48. SELECT votes, allvotes, rating
      FROM jos_vm_product_votes
      WHERE product_id='2514'
  49. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%product_id=2515%'
      AND published=1
  50. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%category_id=117%'
      AND published=1
  51. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%flypage=flypage.tpl%'
      AND published=1
  52. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%page=shop.product_details%'
      AND published=1
  53. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=2515
  54. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='2515'
      AND (start_date<='1606847498' OR start_date=0)
      AND (end_date>='1606779360' OR end_date=0)
      AND product_discount_id=discount_id
  55. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=2515
  56. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1606847498' OR start_date=0)
      AND (end_date>='1606779360' OR end_date=0)
      AND product_discount_id=discount_id
  57. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='2515'
  58. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=2515
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  59. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=2515
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  60. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=2515
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  61. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=2515
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  62. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%product_id=2515%'
      AND published=1
  63. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%page=shop.ask%'
      AND published=1
  64. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=2515
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  65. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=2515
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  66. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=2515
  67. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=2515
      AND `file_is_image`=1
      AND `file_published`=1
  68. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=2515
  69. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=1
      AND `file_published`=1
  70. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=2515
      AND `file_is_image`=0
      AND `file_published`=1
  71. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id='2515'
  72. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=0
      AND `file_published`=1
  73. SELECT votes, allvotes, rating
      FROM jos_vm_product_votes
      WHERE product_id='2515'
  74. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%product_id=2788%'
      AND published=1
  75. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%category_id=127%'
      AND published=1
  76. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%flypage=flypage.tpl%'
      AND published=1
  77. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%page=shop.product_details%'
      AND published=1
  78. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=2788
  79. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='2788'
      AND (start_date<='1606847498' OR start_date=0)
      AND (end_date>='1606779360' OR end_date=0)
      AND product_discount_id=discount_id
  80. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=2788
  81. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1606847498' OR start_date=0)
      AND (end_date>='1606779360' OR end_date=0)
      AND product_discount_id=discount_id
  82. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='2788'
  83. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=2788
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  84. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=2788
  85. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=2788
  86. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=2788
      AND `file_is_image`=1
      AND `file_published`=1
  87. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=2788
  88. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=1
      AND `file_published`=1
  89. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=2788
      AND `file_is_image`=0
      AND `file_published`=1
  90. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id='2788'
  91. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=0
      AND `file_published`=1
  92. SELECT votes, allvotes, rating
      FROM jos_vm_product_votes
      WHERE product_id='2788'
  93. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=2788
  94. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=2788
  95. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%product_id=2774%'
      AND published=1
  96. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%category_id=127%'
      AND published=1
  97. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%flypage=flypage.tpl%'
      AND published=1
  98. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%page=shop.product_details%'
      AND published=1
  99. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=2774
  100. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='2774'
      AND (start_date<='1606847498' OR start_date=0)
      AND (end_date>='1606779360' OR end_date=0)
      AND product_discount_id=discount_id
  101. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=2774
  102. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1606847498' OR start_date=0)
      AND (end_date>='1606779360' OR end_date=0)
      AND product_discount_id=discount_id
  103. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='2774'
  104. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=2774
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  105. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=2774
  106. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=2774
  107. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=2774
      AND `file_is_image`=1
      AND `file_published`=1
  108. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=2774
  109. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=1
      AND `file_published`=1
  110. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=2774
      AND `file_is_image`=0
      AND `file_published`=1
  111. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id='2774'
  112. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=0
      AND `file_published`=1
  113. SELECT votes, allvotes, rating
      FROM jos_vm_product_votes
      WHERE product_id='2774'
  114. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=2774
  115. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=2774
  116. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%product_id=2813%'
      AND published=1
  117. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%category_id=127%'
      AND published=1
  118. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%flypage=flypage.tpl%'
      AND published=1
  119. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%page=shop.product_details%'
      AND published=1
  120. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=2813
  121. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='2813'
      AND (start_date<='1606847498' OR start_date=0)
      AND (end_date>='1606779360' OR end_date=0)
      AND product_discount_id=discount_id
  122. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=2813
  123. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1606847498' OR start_date=0)
      AND (end_date>='1606779360' OR end_date=0)
      AND product_discount_id=discount_id
  124. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='2813'
  125. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=2813
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  126. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=2813
  127. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=2813
  128. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=2813
      AND `file_is_image`=1
      AND `file_published`=1
  129. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=2813
  130. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=1
      AND `file_published`=1
  131. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=2813
      AND `file_is_image`=0
      AND `file_published`=1
  132. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id='2813'
  133. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=0
      AND `file_published`=1
  134. SELECT votes, allvotes, rating
      FROM jos_vm_product_votes
      WHERE product_id='2813'
  135. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=2813
  136. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=2813
  137. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%product_id=2832%'
      AND published=1
  138. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%category_id=127%'
      AND published=1
  139. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%flypage=flypage.tpl%'
      AND published=1
  140. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%page=shop.product_details%'
      AND published=1
  141. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=2832
  142. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='2832'
      AND (start_date<='1606847498' OR start_date=0)
      AND (end_date>='1606779360' OR end_date=0)
      AND product_discount_id=discount_id
  143. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=2832
  144. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1606847498' OR start_date=0)
      AND (end_date>='1606779360' OR end_date=0)
      AND product_discount_id=discount_id
  145. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='2832'
  146. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=2832
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  147. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=2832
  148. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=2832
  149. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=2832
      AND `file_is_image`=1
      AND `file_published`=1
  150. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=2832
  151. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=1
      AND `file_published`=1
  152. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=2832
      AND `file_is_image`=0
      AND `file_published`=1
  153. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id='2832'
  154. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=0
      AND `file_published`=1
  155. SELECT votes, allvotes, rating
      FROM jos_vm_product_votes
      WHERE product_id='2832'
  156. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=2832
  157. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=2832
  158. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%product_id=2833%'
      AND published=1
  159. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%category_id=127%'
      AND published=1
  160. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%flypage=flypage.tpl%'
      AND published=1
  161. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%page=shop.product_details%'
      AND published=1
  162. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=2833
  163. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='2833'
      AND (start_date<='1606847498' OR start_date=0)
      AND (end_date>='1606779360' OR end_date=0)
      AND product_discount_id=discount_id
  164. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=2833
  165. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1606847498' OR start_date=0)
      AND (end_date>='1606779360' OR end_date=0)
      AND product_discount_id=discount_id
  166. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='2833'
  167. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=2833
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  168. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=2833
  169. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=2833
  170. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=2833
      AND `file_is_image`=1
      AND `file_published`=1
  171. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=2833
  172. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=1
      AND `file_published`=1
  173. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=2833
      AND `file_is_image`=0
      AND `file_published`=1
  174. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id='2833'
  175. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=0
      AND `file_published`=1
  176. SELECT votes, allvotes, rating
      FROM jos_vm_product_votes
      WHERE product_id='2833'
  177. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=2833
  178. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=2833
  179. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%product_id=2821%'
      AND published=1
  180. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%category_id=127%'
      AND published=1
  181. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%flypage=flypage.tpl%'
      AND published=1
  182. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%page=shop.product_details%'
      AND published=1
  183. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=2821
  184. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='2821'
      AND (start_date<='1606847498' OR start_date=0)
      AND (end_date>='1606779360' OR end_date=0)
      AND product_discount_id=discount_id
  185. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=2821
  186. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1606847498' OR start_date=0)
      AND (end_date>='1606779360' OR end_date=0)
      AND product_discount_id=discount_id
  187. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='2821'
  188. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=2821
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  189. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=2821
  190. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=2821
  191. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=2821
      AND `file_is_image`=1
      AND `file_published`=1
  192. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=2821
  193. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=1
      AND `file_published`=1
  194. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=2821
      AND `file_is_image`=0
      AND `file_published`=1
  195. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id='2821'
  196. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=0
      AND `file_published`=1
  197. SELECT votes, allvotes, rating
      FROM jos_vm_product_votes
      WHERE product_id='2821'
  198. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=2821
  199. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=2821
  200. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%product_id=2777%'
      AND published=1
  201. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%category_id=127%'
      AND published=1
  202. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%flypage=flypage.tpl%'
      AND published=1
  203. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%page=shop.product_details%'
      AND published=1
  204. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=2777
  205. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='2777'
      AND (start_date<='1606847498' OR start_date=0)
      AND (end_date>='1606779360' OR end_date=0)
      AND product_discount_id=discount_id
  206. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=2777
  207. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1606847498' OR start_date=0)
      AND (end_date>='1606779360' OR end_date=0)
      AND product_discount_id=discount_id
  208. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='2777'
  209. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=2777
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  210. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=2777
  211. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=2777
  212. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=2777
      AND `file_is_image`=1
      AND `file_published`=1
  213. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=2777
  214. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=1
      AND `file_published`=1
  215. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=2777
      AND `file_is_image`=0
      AND `file_published`=1
  216. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id='2777'
  217. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=0
      AND `file_published`=1
  218. SELECT votes, allvotes, rating
      FROM jos_vm_product_votes
      WHERE product_id='2777'
  219. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=2777
  220. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=2777
  221. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%product_id=2803%'
      AND published=1
  222. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%category_id=127%'
      AND published=1
  223. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%flypage=flypage.tpl%'
      AND published=1
  224. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%page=shop.product_details%'
      AND published=1
  225. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=2803
  226. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='2803'
      AND (start_date<='1606847498' OR start_date=0)
      AND (end_date>='1606779360' OR end_date=0)
      AND product_discount_id=discount_id
  227. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=2803
  228. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1606847498' OR start_date=0)
      AND (end_date>='1606779360' OR end_date=0)
      AND product_discount_id=discount_id
  229. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='2803'
  230. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=2803
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  231. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=2803
  232. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=2803
  233. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=2803
      AND `file_is_image`=1
      AND `file_published`=1
  234. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=2803
  235. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=1
      AND `file_published`=1
  236. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=2803
      AND `file_is_image`=0
      AND `file_published`=1
  237. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id='2803'
  238. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=0
      AND `file_published`=1
  239. SELECT votes, allvotes, rating
      FROM jos_vm_product_votes
      WHERE product_id='2803'
  240. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=2803
  241. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=2803
  242. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%product_id=2773%'
      AND published=1
  243. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%category_id=127%'
      AND published=1
  244. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%flypage=flypage.tpl%'
      AND published=1
  245. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%page=shop.product_details%'
      AND published=1
  246. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=2773
  247. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='2773'
      AND (start_date<='1606847498' OR start_date=0)
      AND (end_date>='1606779360' OR end_date=0)
      AND product_discount_id=discount_id
  248. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=2773
  249. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1606847498' OR start_date=0)
      AND (end_date>='1606779360' OR end_date=0)
      AND product_discount_id=discount_id
  250. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='2773'
  251. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=2773
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  252. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=2773
  253. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=2773
  254. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=2773
      AND `file_is_image`=1
      AND `file_published`=1
  255. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=2773
  256. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=1
      AND `file_published`=1
  257. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=2773
      AND `file_is_image`=0
      AND `file_published`=1
  258. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id='2773'
  259. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=0
      AND `file_published`=1
  260. SELECT votes, allvotes, rating
      FROM jos_vm_product_votes
      WHERE product_id='2773'
  261. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=2773
  262. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=2773
  263. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%product_id=2826%'
      AND published=1
  264. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%category_id=127%'
      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`=2826
  268. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='2826'
      AND (start_date<='1606847498' OR start_date=0)
      AND (end_date>='1606779360' OR end_date=0)
      AND product_discount_id=discount_id
  269. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=2826
  270. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1606847498' OR start_date=0)
      AND (end_date>='1606779360' OR end_date=0)
      AND product_discount_id=discount_id
  271. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='2826'
  272. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=2826
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  273. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=2826
  274. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=2826
  275. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=2826
      AND `file_is_image`=1
      AND `file_published`=1
  276. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=2826
  277. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=1
      AND `file_published`=1
  278. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=2826
      AND `file_is_image`=0
      AND `file_published`=1
  279. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id='2826'
  280. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=0
      AND `file_published`=1
  281. SELECT votes, allvotes, rating
      FROM jos_vm_product_votes
      WHERE product_id='2826'
  282. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=2826
  283. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=2826
  284. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%product_id=2795%'
      AND published=1
  285. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%category_id=127%'
      AND published=1
  286. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%flypage=flypage.tpl%'
      AND published=1
  287. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%page=shop.product_details%'
      AND published=1
  288. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=2795
  289. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='2795'
      AND (start_date<='1606847498' OR start_date=0)
      AND (end_date>='1606779360' OR end_date=0)
      AND product_discount_id=discount_id
  290. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=2795
  291. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1606847498' OR start_date=0)
      AND (end_date>='1606779360' OR end_date=0)
      AND product_discount_id=discount_id
  292. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='2795'
  293. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=2795
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  294. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=2795
  295. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=2795
  296. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=2795
      AND `file_is_image`=1
      AND `file_published`=1
  297. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=2795
  298. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=1
      AND `file_published`=1
  299. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=2795
      AND `file_is_image`=0
      AND `file_published`=1
  300. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id='2795'
  301. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=0
      AND `file_published`=1
  302. SELECT votes, allvotes, rating
      FROM jos_vm_product_votes
      WHERE product_id='2795'
  303. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=2795
  304. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=2795
  305. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%product_id=2825%'
      AND published=1
  306. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%category_id=127%'
      AND published=1
  307. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%flypage=flypage.tpl%'
      AND published=1
  308. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%page=shop.product_details%'
      AND published=1
  309. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=2825
  310. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='2825'
      AND (start_date<='1606847498' OR start_date=0)
      AND (end_date>='1606779360' OR end_date=0)
      AND product_discount_id=discount_id
  311. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=2825
  312. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1606847498' OR start_date=0)
      AND (end_date>='1606779360' OR end_date=0)
      AND product_discount_id=discount_id
  313. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='2825'
  314. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=2825
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  315. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=2825
  316. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=2825
  317. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=2825
      AND `file_is_image`=1
      AND `file_published`=1
  318. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=2825
  319. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=1
      AND `file_published`=1
  320. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=2825
      AND `file_is_image`=0
      AND `file_published`=1
  321. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id='2825'
  322. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=0
      AND `file_published`=1
  323. SELECT votes, allvotes, rating
      FROM jos_vm_product_votes
      WHERE product_id='2825'
  324. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=2825
  325. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=2825
  326. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%product_id=2802%'
      AND published=1
  327. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%category_id=127%'
      AND published=1
  328. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%flypage=flypage.tpl%'
      AND published=1
  329. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%page=shop.product_details%'
      AND published=1
  330. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=2802
  331. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='2802'
      AND (start_date<='1606847498' OR start_date=0)
      AND (end_date>='1606779360' OR end_date=0)
      AND product_discount_id=discount_id
  332. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=2802
  333. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1606847498' OR start_date=0)
      AND (end_date>='1606779360' OR end_date=0)
      AND product_discount_id=discount_id
  334. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='2802'
  335. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=2802
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  336. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=2802
  337. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=2802
  338. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=2802
      AND `file_is_image`=1
      AND `file_published`=1
  339. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=2802
  340. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=1
      AND `file_published`=1
  341. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=2802
      AND `file_is_image`=0
      AND `file_published`=1
  342. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id='2802'
  343. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=0
      AND `file_published`=1
  344. SELECT votes, allvotes, rating
      FROM jos_vm_product_votes
      WHERE product_id='2802'
  345. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=2802
  346. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=2802
  347. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%product_id=2822%'
      AND published=1
  348. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%category_id=127%'
      AND published=1
  349. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%flypage=flypage.tpl%'
      AND published=1
  350. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%page=shop.product_details%'
      AND published=1
  351. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=2822
  352. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='2822'
      AND (start_date<='1606847498' OR start_date=0)
      AND (end_date>='1606779360' OR end_date=0)
      AND product_discount_id=discount_id
  353. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=2822
  354. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1606847498' OR start_date=0)
      AND (end_date>='1606779360' OR end_date=0)
      AND product_discount_id=discount_id
  355. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='2822'
  356. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=2822
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  357. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=2822
  358. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=2822
  359. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=2822
      AND `file_is_image`=1
      AND `file_published`=1
  360. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=2822
  361. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=1
      AND `file_published`=1
  362. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=2822
      AND `file_is_image`=0
      AND `file_published`=1
  363. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id='2822'
  364. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=0
      AND `file_published`=1
  365. SELECT votes, allvotes, rating
      FROM jos_vm_product_votes
      WHERE product_id='2822'
  366. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=2822
  367. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=2822
  368. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%product_id=2801%'
      AND published=1
  369. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%category_id=127%'
      AND published=1
  370. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%flypage=flypage.tpl%'
      AND published=1
  371. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%page=shop.product_details%'
      AND published=1
  372. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=2801
  373. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='2801'
      AND (start_date<='1606847498' OR start_date=0)
      AND (end_date>='1606779360' OR end_date=0)
      AND product_discount_id=discount_id
  374. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=2801
  375. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1606847498' OR start_date=0)
      AND (end_date>='1606779360' OR end_date=0)
      AND product_discount_id=discount_id
  376. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='2801'
  377. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=2801
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  378. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=2801
  379. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=2801
  380. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=2801
      AND `file_is_image`=1
      AND `file_published`=1
  381. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=2801
  382. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=1
      AND `file_published`=1
  383. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=2801
      AND `file_is_image`=0
      AND `file_published`=1
  384. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id='2801'
  385. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=0
      AND `file_published`=1
  386. SELECT votes, allvotes, rating
      FROM jos_vm_product_votes
      WHERE product_id='2801'
  387. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=2801
  388. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=2801
  389. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%product_id=2792%'
      AND published=1
  390. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%category_id=127%'
      AND published=1
  391. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%flypage=flypage.tpl%'
      AND published=1
  392. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%page=shop.product_details%'
      AND published=1
  393. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=2792
  394. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='2792'
      AND (start_date<='1606847498' OR start_date=0)
      AND (end_date>='1606779360' OR end_date=0)
      AND product_discount_id=discount_id
  395. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=2792
  396. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1606847498' OR start_date=0)
      AND (end_date>='1606779360' OR end_date=0)
      AND product_discount_id=discount_id
  397. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='2792'
  398. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=2792
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  399. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=2792
  400. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=2792
  401. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=2792
      AND `file_is_image`=1
      AND `file_published`=1
  402. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=2792
  403. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=1
      AND `file_published`=1
  404. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=2792
      AND `file_is_image`=0
      AND `file_published`=1
  405. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id='2792'
  406. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=0
      AND `file_published`=1
  407. SELECT votes, allvotes, rating
      FROM jos_vm_product_votes
      WHERE product_id='2792'
  408. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=2792
  409. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=2792
  410. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%product_id=2797%'
      AND published=1
  411. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%category_id=127%'
      AND published=1
  412. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%flypage=flypage.tpl%'
      AND published=1
  413. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%page=shop.product_details%'
      AND published=1
  414. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=2797
  415. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='2797'
      AND (start_date<='1606847498' OR start_date=0)
      AND (end_date>='1606779360' OR end_date=0)
      AND product_discount_id=discount_id
  416. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=2797
  417. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1606847498' OR start_date=0)
      AND (end_date>='1606779360' OR end_date=0)
      AND product_discount_id=discount_id
  418. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='2797'
  419. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=2797
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  420. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=2797
  421. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=2797
  422. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=2797
      AND `file_is_image`=1
      AND `file_published`=1
  423. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=2797
  424. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=1
      AND `file_published`=1
  425. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=2797
      AND `file_is_image`=0
      AND `file_published`=1
  426. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id='2797'
  427. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=0
      AND `file_published`=1
  428. SELECT votes, allvotes, rating
      FROM jos_vm_product_votes
      WHERE product_id='2797'
  429. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=2797
  430. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=2797
  431. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%product_id=2800%'
      AND published=1
  432. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%category_id=127%'
      AND published=1
  433. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%flypage=flypage.tpl%'
      AND published=1
  434. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%page=shop.product_details%'
      AND published=1
  435. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=2800
  436. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='2800'
      AND (start_date<='1606847498' OR start_date=0)
      AND (end_date>='1606779360' OR end_date=0)
      AND product_discount_id=discount_id
  437. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=2800
  438. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1606847498' OR start_date=0)
      AND (end_date>='1606779360' OR end_date=0)
      AND product_discount_id=discount_id
  439. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='2800'
  440. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=2800
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  441. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=2800
  442. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=2800
  443. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=2800
      AND `file_is_image`=1
      AND `file_published`=1
  444. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=2800
  445. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=1
      AND `file_published`=1
  446. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=2800
      AND `file_is_image`=0
      AND `file_published`=1
  447. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id='2800'
  448. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=0
      AND `file_published`=1
  449. SELECT votes, allvotes, rating
      FROM jos_vm_product_votes
      WHERE product_id='2800'
  450. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=2800
  451. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=2800
  452. 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
  453. SELECT `pageid`
      FROM jos_sh404sef_pageids
      WHERE `newurl`='index.php?option=com_virtuemart&Itemid=1&category_id=0&lang=bg&limit=20&limitstart=120&page=shop.browse&vmcchk=1';
  454. 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
  455. 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
  456. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%product_id=2093%'
      AND published=1
  457. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%category_id=86%'
      AND published=1
  458. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%flypage=flypage.tpl%'
      AND published=1
  459. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%page=shop.product_details%'
      AND published=1
  460. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%product_id=2727%'
      AND published=1
  461. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%category_id=128%'
      AND published=1
  462. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%flypage=flypage.tpl%'
      AND published=1
  463. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%page=shop.product_details%'
      AND published=1
  464. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%product_id=144%'
      AND published=1
  465. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%category_id=21%'
      AND published=1
  466. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%flypage=flypage.tpl%'
      AND published=1
  467. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%page=shop.product_details%'
      AND published=1
  468. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%product_id=1748%'
      AND published=1
  469. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%category_id=74%'
      AND published=1
  470. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%flypage=flypage.tpl%'
      AND published=1
  471. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%page=shop.product_details%'
      AND published=1
  472. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%product_id=1714%'
      AND published=1
  473. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%category_id=70%'
      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=14%'
      AND published=1
  477. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%category_id=2%'
      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=305%'
      AND published=1
  481. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%category_id=41%'
      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=1518%'
      AND published=1
  485. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%category_id=55%'
      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=3057%'
      AND published=1
  489. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%category_id=130%'
      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=1945%'
      AND published=1
  493. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%category_id=86%'
      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=2462%'
      AND published=1
  497. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%category_id=101%'
      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=1770%'
      AND published=1
  501. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%category_id=74%'
      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=294%'
      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=1944%'
      AND published=1
  509. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%category_id=86%'
      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=133%'
      AND published=1
  513. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%category_id=21%'
      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=341%'
      AND published=1
  517. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%category_id=41%'
      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=1821%'
      AND published=1
  521. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%category_id=84%'
      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=3084%'
      AND published=1
  525. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%category_id=46%'
      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=2812%'
      AND published=1
  529. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%category_id=127%'
      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=288%'
      AND published=1
  533. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%category_id=41%'
      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 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
  537. 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
  538. 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
  539. 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
  540. 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
  541. 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
  542. 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
  543. 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
  544. 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
  545. 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
  546. 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
  547. 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
  548. 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
  549. 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
  550. 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
  551. 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
  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='75'
      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='74'
      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='81'
      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='130'
      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='39'
      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='109'
      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='112'
      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='113'
      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='114'
      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='115'
      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='116'
      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='117'
      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='122'
      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='110'
      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='49'
      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='86'
      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='87'
      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='50'
      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='85'
      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='48'
      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='123'
      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='12'
      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='6'
      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='3'
      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='9'
      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='10'
      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='126'
      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='127'
      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='128'
      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='129'
      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='132'
      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='133'
      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='14'
      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='13'
      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='7'
      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='77'
      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='82'
      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='96'
      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='78'
      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='83'
      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='8'
      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='84'
      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='22'
      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='69'
      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='20'
      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='70'
      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='21'
      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='25'
      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='24'
      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='23'
      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='76'
      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='80'
      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='79'
      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='118'
      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='125'
      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='119'
      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='46'
      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='53'
      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='54'
      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='55'
      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='56'
      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='57'
      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='58'
      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='59'
      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='60'
      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='61'
      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='62'
      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='63'
      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='64'
      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='65'
      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='134'
      AND a.category_id=b.category_child_id
      ORDER BY category_parent_id, list_order, category_name ASC
  623. 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
  624. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%category_id=1%'
      AND published=1
  625. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%page=shop.browse%'
      AND published=1
  626. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%category_id=53%'
      AND published=1
  627. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%page=shop.browse%'
      AND published=1
  628. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%category_id=134%'
      AND published=1
  629. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%page=shop.browse%'
      AND published=1
  630. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%page=shop.browse%'
      AND published=1
  631. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%page=shop.search%'
      AND published=1
  632. SELECT group_id,group_name,group_level
      FROM `jos_vm_auth_group`
      ORDER BY group_level
  633. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%page=shop.registration%'
      AND published=1
  634. SELECT published
      FROM jos_modules
      WHERE module='mod_virtuemart_cart'
  635. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%page=shop.cart%'
      AND published=1
  636. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%page=shop.cart%'
      AND published=1
  637. SELECT *
      FROM jos_jstats_configuration
  638. SELECT exclude, TYPE, tld, id, useragent
      FROM jos_jstats_ipaddresses
      WHERE ip = '18.213.192.104'
  639. SELECT visit_id
      FROM jos_jstats_visits
      WHERE visitor_id = 124786  
      AND CAST(CONCAT(visit_date, ' ', visit_time) AS DATETIME) >= DATE_ADD('2020-12-01 18:31:48', INTERVAL -15 MINUTE)
  640. UPDATE jos_jstats_visits
      SET  visit_date = '2020-12-01', visit_time = '18:31:48'
      WHERE visit_id = '1168745'
  641. 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=120&amp;vmcchk=1'
      LIMIT 1
  642. INSERT INTO `jos_jstats_impressions` (`page_id`, `visit_id`)
      VALUES (26739,1168745)

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

  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

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

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

Няма

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

Няма