Cantine del Veneto

Storia dell'azienda Agricola Allegrini:  La Famiglia Allegrini ha incominciato la sua attività agricola a partire dal XVI secolo. E’ stato Giovanni, esponente della nuova generazione della famiglia Allegrini a dare lustro a questo nome nel campo dell'enologia. Giovanni ha saputo stravolgere le abitudini della viticoltura locale,  applicando il rigore nella selezione delle uve alla conoscenza enologica, creando così un nuovo  modo di pensare e di produrre il vino di qualità, tanto da meritare negli anni tra il 1960 e il 1970, grandi riconoscimenti per i vini prodotti. Giovanni Allegrini  ha il grande merito di aver fatto conoscere i suoi vini in Italia e all'estero, grazie ad una attenda cura dedicata alla ricerca del meglio in campo enologico, fino a fare  dell'Azienda Allegrini un  marchio di qualità nella produzione dei grandi vini. Oggi l’azienda è guidata dai suoi figli, Walter, Marilisa e Franco. Il loro impegno, l’immenso amore per questa terra, il rispetto della tradizione vitivinicola, li ha portati a migliorarsi costantemente nella produzione del loro vino. Tale sforzo è stato premiato dal consenso totale e dalla stima dimostrata sia dai consumatori che dalla critica.

Dove si trova la cantina dell’ Agricola Allegrini:  L'Azienda Agricola Allegrini ha sede in Fumane di Valpolicella. La Valpolicella Classica, è situata in Veneto, a nord-ovest della citta' di Verona,  ed  e' considerata fra le piu' importanti aree viticole d'Italia.  I possedimenti della Famiglia Allegrini si estendono per circa 90 ettari e sono tutti situati in zona collinare all'internvendemmiao della Valpolicella Classica.  L’azienda Agricola Allegrini è stata fondamentale per lo sviluppo della viticoltura locale, infatti, è stata l’artefice di un modo di coltivare i vitigni, ossia quello di dedicarsi esclusivamente ad un unico vigneto, quindi alla  creazione di uve indirizzate unicamente ad un unico vino. I suoi vigneti sono diversi: La Grola, Palazzo della Torre, la Poja, che hanno resa famosa nel mondo la Valpolicella. I vigneti dai quali si estraggono le uve per la produzione dell'Amarone sono collocati nella superficie collinare della Valpolicella Classica,  a circa 250 mt  s.l.m. .Il luogo e' ideale, con clima benevolo e mite e grazie alla presenza nel terreno  di minerali vari, si presta in maniera appropriata alla coltura di vigneti ottimali. I vigneti sono impiantati con un sistema a pergola, circa 3.000 viti per ettaro, in questo modo si ottiene una maturazione completa delle uve indirizzate all' appassimento.

I vini dell' Agricola Allegrini:

Soave D.O.C.
Valpolicella Classico D.O.C.
Palazzo della Torre I.G.T (Veronese)
La Grola I.G.T (Veronese)
La Poja I.G.T. (Veronese)
Villa Giona I.G.T. (Veronese)
Amarone della Valpolicella Classico D.O.C.
"Giovanni Allegrini" Recioto della Valpolicella Classico D.O.C.

Le  grappe dell’ Agricola Allegrini. Le grappe prodotte da quest'azienda sono essenziamente due: la grappa di Recioto e quella di Amarone.


Dove comprare i vini dell’ Agricola Allegrini : puoi acquistare i vini dell’ Agricola Allegrini nell'enoteca online di guida-vino.com.

Premi e riconoscimenti per i vini dell’ Agricola Allegrini : I premi che sono stati conferiti all’ Agricola Allegrini nel corso degli anni sono veramente numerosi, noi ve ne citiamo solo alcuni. Per il Recioto Giovanni Allegrini:Vini d’Italia – Gambero Rosso 2007: 2 bicchieri; I Vini di Veronelli 2007: 3 stelle blu; I Vini d’Italia.Per l’Amarone della Valpolicella Classico D.O.C.: Vini d’Italia – Gambero Rosso 2008: 3 bicchieri per le annate ’93-’95-’96-’97-’98-’00-’01-’03.

Per contattare l'azienda:

Agricola Allegrini
Via Giare 9/11
37022 Fumane di Valpolicella
Verona - Italia

Cantine del Veneto - Allegrini

Romano dal Forno con un calice del suo prezioso Amarone

Storia dell'azienda Romano Dal Forno: Romano Dal Forno, nasce nel 1957 a Capovilla, a pochi chilometri da Illasi. Praticamente nasce già in un ambiente dove il vino è più che un prodotto, è una filosofia di vita, la sua famiglia produceva vino già da tre generazioni. A 22 anni Romano conobbe Giuseppe Quintarelli che fu per lui una scoperta. Quintarelli gli insegnò un nuovo modo di produrre vino e di impiantare vigneti, gli fece scoprire l’importanza di puntare sulla qualità piuttosto che sulla quantità. Romano non si lasciò sopraffare dalle difficoltà che la Valle d'Illasi presentava, volle tentare.  I primi tempi si presentarono con notevoli difficoltà, tentò di ridurre la produzione d'uva per pianta, ma raggiunse l'effetto contrario, ossia  grappoli dagli acini gonfi ed  annacquati. Le piante, infatti, essendo sottoposta ad un surplus di lavoro,  non potevano essere convertite da un giorno all’altro ad una nuova fase di produzione. Ci vollero anni, pazienza e conoscenza per comprendere i processi produttivi, la tecnica degli impianti e dell’appassimento.  I primi grandi risultati si sono avuti con la vendemmia 1983, una delle migliori annate dell'Amarone da allora la cantina Romano Dal Forno ha prodotto ventidue annate di Amarone della Valpolicella: di queste, diciotto sono già state commercializzate. Ha prodotto, inoltre, venticinque annate di Valpolicella DOC. Romano Dal Forno è oggi una delle aziende più rinomate ne mondo dei grandi vini, un marchio di prestigio e qualità che riscontra successi e elogi dai consumatori e dalla critica.

 

botti Dal FornoDove si trova la cantina Romano Dal Forno: L'azienda agricola Romano Dal Forno si trova in Val d'Illasi, una valle ad est di Verona che, insieme a molte altre, costituisce la catena dei Lessini, ossia quell’insieme collinare con la caratteristica forma di ventaglio che cinge la città a nord. L'azienda agricola è situata  a metà della valle, in una zona pianeggiante situata ridosso delle colline estremamente soleggiata. Se le zone più a nord della valle quelle dove è situata l'azienda, sono state  da sempre vocate alla produzione del vino e dell'olio. Per anni questa terra è stata fruttata nella coltivazione intensiva degli uvaggi, per ottenere il maggior numero possibile di uva per la spemitura. A Romano Dal Forno vanno molti meriti: prima di tutto la scelta di eliminare la Molinara dall'uvaggio dell'Amarone, e  la riscoperta dell'Oseleta, impiantata nel '91, e che oggi fa parte delle uve che confluiscono nell'Amarone. La radicale trasformazione del Valpolicella, un vino che veniva considerato di poco conto e che oggi è paragonabile per struttura e finezza ad un Brunello. La qualità dei vini di Dal Forno è eccezionale ed il loro prezzo è ovviamente e giustamente molto elevato, ma basti pensare che da 100 chili d'uva si ottengono 15 litri di Amarone.

La costruzione della cantina è incominciata, insieme al restauro della casa dove ha sede l’azienda,  nel 1990. Lo stile che si è deciso di seguire è quello delle ville padronali dell''800 di cui la Valpolicella  è ricca. La scelta di questo stile architettonico è molto semplice, prima di tutto si adatta perfettamente all'ambiente nel quale sorge l’azienda e all'attività della quale doveva essere immagine, sia perché rispecchia bene le caratteristiche del marchio che rappresenta: solidità, durata nel tempo, il rispetto per la storia e le tradizioni.

I vini dell'Azienda Romano Dal Forno:

Amarone della Valpolicella - Monte Lodoletta
Valpolicella Superiore

Nelle annate particolarmente felici, viene prodotto il passito rosso Vigna Serè.


Dove comprare i vini Romano Dal Forno : puoi acquistare i vini Romano Dal Forno nell'enoteca online di guida-vino.com

Premi e riconoscimenti per i vini Romano Dal Forno:
Gambero Rosso 2010, 3 bicchieri: Valpolicella Sup. Vign. di Monte Lodoletta 2004 Romano Dal Forno.

Per contattare l'azienda :

Azienda Romano Dal Forno
Località Lodoletta, 4
Frazione Cellore / Illasi  - Verona (Italy)
www.dalfornoromano.it

Cantine del Veneto - Romano dal Forno

-

Menu utente

Feed del sito

Catalogo


Tutti i prodotti


Ricerca Avanzata
Ricerca Avanzata (utilizza parametri preimpostati)
Mostra Carrello
Il carrello è vuoto.

Catalogo dei vini Regione per Regione

Informazioni Profilo

Application afterLoad: 0.001 seconds, 0.68 MB
Application afterInitialise: 0.062 seconds, 1.54 MB
Application afterRoute: 0.067 seconds, 2.18 MB
Application afterDispatch: 0.115 seconds, 3.02 MB
Application afterRender: 0.322 seconds, 6.80 MB

Utilizzo Memoria

7187056

193 queries logged

  1. SELECT *
      FROM jos_session
      WHERE session_id = 'jn7j0d046hg4qdb8f3j974h4q2'
  2. DELETE
      FROM jos_session
      WHERE ( TIME < '1726204560' )
  3. SELECT *
      FROM jos_session
      WHERE session_id = 'jn7j0d046hg4qdb8f3j974h4q2'
  4. INSERT INTO `jos_session` ( `session_id`,`time`,`username`,`gid`,`guest`,`client_id` )
      VALUES ( 'jn7j0d046hg4qdb8f3j974h4q2','1726205460','','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 template
      FROM jos_templates_menu
      WHERE client_id = 0
      AND (menuid = 0 OR menuid = 67)
      ORDER BY menuid DESC
      LIMIT 0, 1
  8. SELECT *
      FROM jos_sections
      WHERE id = 25
      LIMIT 0, 1
  9. SELECT a.id, a.title, a.alias, a.title_alias, a.introtext, a.fulltext, a.sectionid, a.state, a.catid, a.created, a.created_by, a.created_by_alias, a.modified, a.modified_by, a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.attribs, a.hits, a.images, a.urls, a.ordering, a.metakey, a.metadesc, a.access, CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(':', a.id, a.alias) ELSE a.id END AS slug, CASE WHEN CHAR_LENGTH(cc.alias) THEN CONCAT_WS(":", cc.id, cc.alias) ELSE cc.id END AS catslug, CHAR_LENGTH( a.`fulltext` ) AS readmore, u.name AS author, u.usertype, cc.title AS category, g.name AS groups, u.email AS author_email
      FROM jos_content AS a
      INNER JOIN jos_categories AS cc
      ON cc.id = a.catid
      LEFT JOIN jos_sections AS s
      ON s.id = a.sectionid
      LEFT JOIN jos_users AS u
      ON u.id = a.created_by
      LEFT JOIN jos_groups AS g
      ON a.access = g.id
      WHERE a.access <= 0
      AND s.id = 25
      AND s.access <= 0
      AND cc.access <= 0
      AND s.published = 1
      AND cc.published = 1
      AND a.state = 1
      AND ( publish_up = '0000-00-00 00:00:00' OR publish_up <= '2024-09-13 05:31:00' )
      AND ( publish_down = '0000-00-00 00:00:00' OR publish_down >= '2024-09-13 05:31:00' )
      ORDER BY  a.created DESC
      LIMIT 0, 9
  10. SELECT a.id, a.title, a.alias, a.title_alias, a.introtext, a.fulltext, a.sectionid, a.state, a.catid, a.created, a.created_by, a.created_by_alias, a.modified, a.modified_by, a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.attribs, a.hits, a.images, a.urls, a.ordering, a.metakey, a.metadesc, a.access, CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(':', a.id, a.alias) ELSE a.id END AS slug, CASE WHEN CHAR_LENGTH(cc.alias) THEN CONCAT_WS(":", cc.id, cc.alias) ELSE cc.id END AS catslug, CHAR_LENGTH( a.`fulltext` ) AS readmore, u.name AS author, u.usertype, cc.title AS category, g.name AS groups, u.email AS author_email
      FROM jos_content AS a
      INNER JOIN jos_categories AS cc
      ON cc.id = a.catid
      LEFT JOIN jos_sections AS s
      ON s.id = a.sectionid
      LEFT JOIN jos_users AS u
      ON u.id = a.created_by
      LEFT JOIN jos_groups AS g
      ON a.access = g.id
      WHERE a.access <= 0
      AND s.id = 25
      AND s.access <= 0
      AND cc.access <= 0
      AND s.published = 1
      AND cc.published = 1
      AND a.state = 1
      AND ( publish_up = '0000-00-00 00:00:00' OR publish_up <= '2024-09-13 05:31:00' )
      AND ( publish_down = '0000-00-00 00:00:00' OR publish_down >= '2024-09-13 05:31:00' )
      ORDER BY  a.created DESC
  11. SELECT a.*, COUNT( b.id ) AS numitems, CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(':', a.id, a.alias) ELSE a.id END AS slug
      FROM jos_categories AS a
      LEFT JOIN jos_content AS b
      ON b.catid = a.id
      AND b.state = 1
      AND ( b.publish_up = '0000-00-00 00:00:00' OR b.publish_up <= '2024-09-13 05:31' )
      AND ( b.publish_down = '0000-00-00 00:00:00' OR b.publish_down >= '2024-09-13 05:31' )
      AND b.access <= 0
      WHERE a.SECTION = 25
      AND a.published = 1
      AND a.access <= 0
      GROUP BY a.id
      HAVING numitems > 0
      ORDER BY a.ordering
  12. SELECT *
      FROM jos_tagmeta
      WHERE ( (('/cantine-del-veneto-produttori-di-vino-veneti' REGEXP BINARY uri)>0
      AND case_sensitive<>'0') OR (('/cantine-del-veneto-produttori-di-vino-veneti' REGEXP uri)>0
      AND case_sensitive='0') )
      AND published='1'
      ORDER BY ordering
  13. UPDATE jos_tagmeta
      SET hits = hits + 1, last_visit = '2024-09-13 07:31:00'
      WHERE id = '20'
  14. 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 = 67 OR mm.menuid = 0 )
      ORDER BY POSITION, ordering
  15. SELECT a.*, CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(":", a.id, a.alias) ELSE a.id END AS slug, CASE WHEN CHAR_LENGTH(cc.alias) THEN CONCAT_WS(":", cc.id, cc.alias) ELSE cc.id END AS catslug
      FROM jos_content AS a
      INNER JOIN jos_categories AS cc
      ON cc.id = a.catid
      INNER JOIN jos_sections AS s
      ON s.id = a.sectionid
      WHERE a.state = 1  
      AND a.access <= 0
      AND cc.access <= 0
      AND s.access <= 0
      AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2024-09-13 05:31:00' )  
      AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-09-13 05:31:00' )
      AND cc.id = 102
      AND cc.SECTION = s.id
      AND cc.published = 1
      AND s.published = 1
      ORDER BY a.ordering
  16. SELECT *, RAND() AS ordering
      FROM jos_banner
      WHERE showBanner = 1
      AND (imptotal = 0 OR impmade < imptotal)
      AND cid = 1
      AND catid = 14
      ORDER BY sticky DESC, ordering
      LIMIT 0, 1
  17. UPDATE jos_banner
      SET impmade = impmade + 1
      WHERE bid = 1
  18. SELECT a.*, CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(":", a.id, a.alias) ELSE a.id END AS slug, CASE WHEN CHAR_LENGTH(cc.alias) THEN CONCAT_WS(":", cc.id, cc.alias) ELSE cc.id END AS catslug
      FROM jos_content AS a
      INNER JOIN jos_categories AS cc
      ON cc.id = a.catid
      INNER JOIN jos_sections AS s
      ON s.id = a.sectionid
      WHERE a.state = 1  
      AND a.access <= 0
      AND cc.access <= 0
      AND s.access <= 0
      AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2024-09-13 05:31:00' )  
      AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-09-13 05:31:00' )
      AND cc.id = 102
      AND cc.SECTION = s.id
      AND cc.published = 1
      AND s.published = 1
      ORDER BY a.ordering
  19. SELECT group_id,group_name,group_level
      FROM `jos_vm_auth_group`
      ORDER BY group_level
  20. 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'
  21. SELECT `name`
      FROM `jos_core_acl_aro_groups`
      WHERE `id` =29
  22. SELECT `lft`, `rgt`
      FROM `jos_core_acl_aro_groups`
      WHERE `name`='Public Frontend'
  23. 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
  24. SELECT `lft`, `rgt`
      FROM `jos_core_acl_aro_groups`
      WHERE `name`='Public Backend'
  25. 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
  26. 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`);
  27. SELECT m.manufacturer_id,m.mf_name
      FROM jos_vm_manufacturer m
      ORDER BY m.mf_name ASC
  28. SELECT id, params
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND published=1
  29. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND published=1
  30. SELECT mf_name
      FROM jos_vm_manufacturer AS t1  
      WHERE t1.manufacturer_id = 15;
  31. SELECT mf_name
      FROM jos_vm_manufacturer AS t1  
      WHERE t1.manufacturer_id = 13;
  32. SELECT mf_name
      FROM jos_vm_manufacturer AS t1  
      WHERE t1.manufacturer_id = 6;
  33. SELECT mf_name
      FROM jos_vm_manufacturer AS t1  
      WHERE t1.manufacturer_id = 8;
  34. SELECT mf_name
      FROM jos_vm_manufacturer AS t1  
      WHERE t1.manufacturer_id = 9;
  35. SELECT mf_name
      FROM jos_vm_manufacturer AS t1  
      WHERE t1.manufacturer_id = 4;
  36. SELECT mf_name
      FROM jos_vm_manufacturer AS t1  
      WHERE t1.manufacturer_id = 2;
  37. SELECT mf_name
      FROM jos_vm_manufacturer AS t1  
      WHERE t1.manufacturer_id = 3;
  38. SELECT mf_name
      FROM jos_vm_manufacturer AS t1  
      WHERE t1.manufacturer_id = 5;
  39. SELECT mf_name
      FROM jos_vm_manufacturer AS t1  
      WHERE t1.manufacturer_id = 11;
  40. SELECT mf_name
      FROM jos_vm_manufacturer AS t1  
      WHERE t1.manufacturer_id = 10;
  41. SELECT mf_name
      FROM jos_vm_manufacturer AS t1  
      WHERE t1.manufacturer_id = 12;
  42. SELECT mf_name
      FROM jos_vm_manufacturer AS t1  
      WHERE t1.manufacturer_id = 7;
  43. SELECT mf_name
      FROM jos_vm_manufacturer AS t1  
      WHERE t1.manufacturer_id = 14;
  44. SELECT DISTINCT product_sku
      FROM jos_vm_product, jos_vm_product_category_xref, jos_vm_category
      WHERE product_parent_id=''
      AND jos_vm_product.product_id=jos_vm_product_category_xref.product_id
      AND jos_vm_category.category_id=jos_vm_product_category_xref.category_id
      AND jos_vm_category.category_id='29'
      AND jos_vm_product.product_publish='Y'
      ORDER BY product_name DESC
  45. SELECT product_id, product_name, product_parent_id, product_thumb_image
      FROM jos_vm_product
      WHERE product_sku='GUI VERNACCIA'
  46. SELECT category_id
      FROM `jos_vm_product_category_xref`
      WHERE product_id=20
  47. SELECT
                                    `jos_vm_product`.`product_parent_id` AS product_parent_id,
                                    `jos_vm_category`.`category_flypage`
                           
      FROM
                                    `jos_vm_product`

                           
      LEFT JOIN `jos_vm_product_category_xref`
      ON `jos_vm_product_category_xref`.`product_id` = `jos_vm_product`.`product_id`
                           
      LEFT JOIN `jos_vm_category`
      ON `jos_vm_product_category_xref`.`category_id` = `jos_vm_category`.`category_id`

                           
      WHERE `jos_vm_product`.`product_id`='20'
  48. SELECT t1.category_child_id AS lev1, t2.category_child_id AS lev2, t3.category_child_id AS lev3
                           
      FROM  jos_vm_category_xref AS t1
                           
      LEFT JOIN jos_vm_category_xref AS t2
      ON t2.category_child_id = t1.category_parent_id
                           
      LEFT JOIN jos_vm_category_xref AS t3
      ON t3.category_child_id = t2.category_parent_id
                           
      WHERE t1.category_child_id= 29
  49. SELECT GROUP_CONCAT( category_name
                            SEPARATOR  '/' )
                           
      FROM jos_vm_category
                           
      WHERE category_id IN (6,24,29)
  50. SELECT product_name
      FROM jos_vm_product  
      WHERE product_id = 20
  51. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=20
  52. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='20'
      AND (start_date<='1726205460' OR start_date=0)
      AND (end_date>='1726184160' OR end_date=0)
      AND product_discount_id=discount_id
  53. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=20
  54. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1726205460' OR start_date=0)
      AND (end_date>='1726184160' OR end_date=0)
      AND product_discount_id=discount_id
  55. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='20'
  56. SELECT shopper_group_id,shopper_group_discount
      FROM jos_vm_shopper_group
      WHERE vendor_id='1'
      AND `default`='1'
  57. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=20
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  58. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=20
  59. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='20'
  60. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=20
  61. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=20
  62. SELECT product_id, product_name, product_parent_id, product_thumb_image
      FROM jos_vm_product
      WHERE product_sku='GUI IGT SANGIOVESE'
  63. SELECT category_id
      FROM `jos_vm_product_category_xref`
      WHERE product_id=23
  64. SELECT
                                    `jos_vm_product`.`product_parent_id` AS product_parent_id,
                                    `jos_vm_category`.`category_flypage`
                           
      FROM
                                    `jos_vm_product`

                           
      LEFT JOIN `jos_vm_product_category_xref`
      ON `jos_vm_product_category_xref`.`product_id` = `jos_vm_product`.`product_id`
                           
      LEFT JOIN `jos_vm_category`
      ON `jos_vm_product_category_xref`.`category_id` = `jos_vm_category`.`category_id`

                           
      WHERE `jos_vm_product`.`product_id`='23'
  65. SELECT t1.category_child_id AS lev1, t2.category_child_id AS lev2, t3.category_child_id AS lev3
                           
      FROM  jos_vm_category_xref AS t1
                           
      LEFT JOIN jos_vm_category_xref AS t2
      ON t2.category_child_id = t1.category_parent_id
                           
      LEFT JOIN jos_vm_category_xref AS t3
      ON t3.category_child_id = t2.category_parent_id
                           
      WHERE t1.category_child_id= 29
  66. SELECT GROUP_CONCAT( category_name
                            SEPARATOR  '/' )
                           
      FROM jos_vm_category
                           
      WHERE category_id IN (6,24,29)
  67. SELECT product_name
      FROM jos_vm_product  
      WHERE product_id = 23
  68. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=23
  69. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='23'
      AND (start_date<='1726205460' OR start_date=0)
      AND (end_date>='1726184160' OR end_date=0)
      AND product_discount_id=discount_id
  70. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=23
  71. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1726205460' OR start_date=0)
      AND (end_date>='1726184160' OR end_date=0)
      AND product_discount_id=discount_id
  72. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='23'
  73. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=23
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  74. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=23
  75. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='23'
  76. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=23
  77. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=23
  78. SELECT product_id, product_name, product_parent_id, product_thumb_image
      FROM jos_vm_product
      WHERE product_sku='GUI CHARDONNAY'
  79. SELECT category_id
      FROM `jos_vm_product_category_xref`
      WHERE product_id=21
  80. SELECT
                                    `jos_vm_product`.`product_parent_id` AS product_parent_id,
                                    `jos_vm_category`.`category_flypage`
                           
      FROM
                                    `jos_vm_product`

                           
      LEFT JOIN `jos_vm_product_category_xref`
      ON `jos_vm_product_category_xref`.`product_id` = `jos_vm_product`.`product_id`
                           
      LEFT JOIN `jos_vm_category`
      ON `jos_vm_product_category_xref`.`category_id` = `jos_vm_category`.`category_id`

                           
      WHERE `jos_vm_product`.`product_id`='21'
  81. SELECT t1.category_child_id AS lev1, t2.category_child_id AS lev2, t3.category_child_id AS lev3
                           
      FROM  jos_vm_category_xref AS t1
                           
      LEFT JOIN jos_vm_category_xref AS t2
      ON t2.category_child_id = t1.category_parent_id
                           
      LEFT JOIN jos_vm_category_xref AS t3
      ON t3.category_child_id = t2.category_parent_id
                           
      WHERE t1.category_child_id= 29
  82. SELECT GROUP_CONCAT( category_name
                            SEPARATOR  '/' )
                           
      FROM jos_vm_category
                           
      WHERE category_id IN (6,24,29)
  83. SELECT product_name
      FROM jos_vm_product  
      WHERE product_id = 21
  84. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=21
  85. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='21'
      AND (start_date<='1726205460' OR start_date=0)
      AND (end_date>='1726184160' OR end_date=0)
      AND product_discount_id=discount_id
  86. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=21
  87. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1726205460' OR start_date=0)
      AND (end_date>='1726184160' OR end_date=0)
      AND product_discount_id=discount_id
  88. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='21'
  89. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=21
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  90. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=21
  91. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='21'
  92. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=21
  93. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=21
  94. SELECT product_id, product_name, product_parent_id, product_thumb_image
      FROM jos_vm_product
      WHERE product_sku='GUI CHIANTI'
  95. SELECT category_id
      FROM `jos_vm_product_category_xref`
      WHERE product_id=22
  96. SELECT
                                    `jos_vm_product`.`product_parent_id` AS product_parent_id,
                                    `jos_vm_category`.`category_flypage`
                           
      FROM
                                    `jos_vm_product`

                           
      LEFT JOIN `jos_vm_product_category_xref`
      ON `jos_vm_product_category_xref`.`product_id` = `jos_vm_product`.`product_id`
                           
      LEFT JOIN `jos_vm_category`
      ON `jos_vm_product_category_xref`.`category_id` = `jos_vm_category`.`category_id`

                           
      WHERE `jos_vm_product`.`product_id`='22'
  97. SELECT t1.category_child_id AS lev1, t2.category_child_id AS lev2, t3.category_child_id AS lev3
                           
      FROM  jos_vm_category_xref AS t1
                           
      LEFT JOIN jos_vm_category_xref AS t2
      ON t2.category_child_id = t1.category_parent_id
                           
      LEFT JOIN jos_vm_category_xref AS t3
      ON t3.category_child_id = t2.category_parent_id
                           
      WHERE t1.category_child_id= 29
  98. SELECT GROUP_CONCAT( category_name
                            SEPARATOR  '/' )
                           
      FROM jos_vm_category
                           
      WHERE category_id IN (6,24,29)
  99. SELECT product_name
      FROM jos_vm_product  
      WHERE product_id = 22
  100. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=22
  101. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='22'
      AND (start_date<='1726205460' OR start_date=0)
      AND (end_date>='1726184160' OR end_date=0)
      AND product_discount_id=discount_id
  102. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=22
  103. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1726205460' OR start_date=0)
      AND (end_date>='1726184160' OR end_date=0)
      AND product_discount_id=discount_id
  104. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='22'
  105. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=22
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  106. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=22
  107. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='22'
  108. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=22
  109. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=22
  110. 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
  111. SELECT t1.category_child_id AS lev1, t2.category_child_id AS lev2, t3.category_child_id AS lev3
                           
      FROM  jos_vm_category_xref AS t1
                           
      LEFT JOIN jos_vm_category_xref AS t2
      ON t2.category_child_id = t1.category_parent_id
                           
      LEFT JOIN jos_vm_category_xref AS t3
      ON t3.category_child_id = t2.category_parent_id
                           
      WHERE t1.category_child_id= 6
  112. SELECT GROUP_CONCAT( category_name
                            SEPARATOR  '/' )
                           
      FROM jos_vm_category
                           
      WHERE category_id IN (6)
  113. 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
  114. SELECT t1.category_child_id AS lev1, t2.category_child_id AS lev2, t3.category_child_id AS lev3
                           
      FROM  jos_vm_category_xref AS t1
                           
      LEFT JOIN jos_vm_category_xref AS t2
      ON t2.category_child_id = t1.category_parent_id
                           
      LEFT JOIN jos_vm_category_xref AS t3
      ON t3.category_child_id = t2.category_parent_id
                           
      WHERE t1.category_child_id= 13
  115. SELECT GROUP_CONCAT( category_name
                            SEPARATOR  '/' )
                           
      FROM jos_vm_category
                           
      WHERE category_id IN (6,13)
  116. 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
  117. SELECT t1.category_child_id AS lev1, t2.category_child_id AS lev2, t3.category_child_id AS lev3
                           
      FROM  jos_vm_category_xref AS t1
                           
      LEFT JOIN jos_vm_category_xref AS t2
      ON t2.category_child_id = t1.category_parent_id
                           
      LEFT JOIN jos_vm_category_xref AS t3
      ON t3.category_child_id = t2.category_parent_id
                           
      WHERE t1.category_child_id= 32
  118. SELECT GROUP_CONCAT( category_name
                            SEPARATOR  '/' )
                           
      FROM jos_vm_category
                           
      WHERE category_id IN (6,13,32)
  119. 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='32'
      AND a.category_id=b.category_child_id
      ORDER BY category_parent_id, list_order, category_name ASC
  120. SELECT t1.category_child_id AS lev1, t2.category_child_id AS lev2, t3.category_child_id AS lev3
                           
      FROM  jos_vm_category_xref AS t1
                           
      LEFT JOIN jos_vm_category_xref AS t2
      ON t2.category_child_id = t1.category_parent_id
                           
      LEFT JOIN jos_vm_category_xref AS t3
      ON t3.category_child_id = t2.category_parent_id
                           
      WHERE t1.category_child_id= 14
  121. SELECT GROUP_CONCAT( category_name
                            SEPARATOR  '/' )
                           
      FROM jos_vm_category
                           
      WHERE category_id IN (6,14)
  122. 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
  123. SELECT t1.category_child_id AS lev1, t2.category_child_id AS lev2, t3.category_child_id AS lev3
                           
      FROM  jos_vm_category_xref AS t1
                           
      LEFT JOIN jos_vm_category_xref AS t2
      ON t2.category_child_id = t1.category_parent_id
                           
      LEFT JOIN jos_vm_category_xref AS t3
      ON t3.category_child_id = t2.category_parent_id
                           
      WHERE t1.category_child_id= 36
  124. SELECT GROUP_CONCAT( category_name
                            SEPARATOR  '/' )
                           
      FROM jos_vm_category
                           
      WHERE category_id IN (6,14,36)
  125. 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='36'
      AND a.category_id=b.category_child_id
      ORDER BY category_parent_id, list_order, category_name ASC
  126. SELECT t1.category_child_id AS lev1, t2.category_child_id AS lev2, t3.category_child_id AS lev3
                           
      FROM  jos_vm_category_xref AS t1
                           
      LEFT JOIN jos_vm_category_xref AS t2
      ON t2.category_child_id = t1.category_parent_id
                           
      LEFT JOIN jos_vm_category_xref AS t3
      ON t3.category_child_id = t2.category_parent_id
                           
      WHERE t1.category_child_id= 9
  127. SELECT GROUP_CONCAT( category_name
                            SEPARATOR  '/' )
                           
      FROM jos_vm_category
                           
      WHERE category_id IN (6,9)
  128. 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
  129. SELECT t1.category_child_id AS lev1, t2.category_child_id AS lev2, t3.category_child_id AS lev3
                           
      FROM  jos_vm_category_xref AS t1
                           
      LEFT JOIN jos_vm_category_xref AS t2
      ON t2.category_child_id = t1.category_parent_id
                           
      LEFT JOIN jos_vm_category_xref AS t3
      ON t3.category_child_id = t2.category_parent_id
                           
      WHERE t1.category_child_id= 41
  130. SELECT GROUP_CONCAT( category_name
                            SEPARATOR  '/' )
                           
      FROM jos_vm_category
                           
      WHERE category_id IN (6,9,41)
  131. 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
  132. SELECT t1.category_child_id AS lev1, t2.category_child_id AS lev2, t3.category_child_id AS lev3
                           
      FROM  jos_vm_category_xref AS t1
                           
      LEFT JOIN jos_vm_category_xref AS t2
      ON t2.category_child_id = t1.category_parent_id
                           
      LEFT JOIN jos_vm_category_xref AS t3
      ON t3.category_child_id = t2.category_parent_id
                           
      WHERE t1.category_child_id= 20
  133. SELECT GROUP_CONCAT( category_name
                            SEPARATOR  '/' )
                           
      FROM jos_vm_category
                           
      WHERE category_id IN (6,20)
  134. 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
  135. SELECT t1.category_child_id AS lev1, t2.category_child_id AS lev2, t3.category_child_id AS lev3
                           
      FROM  jos_vm_category_xref AS t1
                           
      LEFT JOIN jos_vm_category_xref AS t2
      ON t2.category_child_id = t1.category_parent_id
                           
      LEFT JOIN jos_vm_category_xref AS t3
      ON t3.category_child_id = t2.category_parent_id
                           
      WHERE t1.category_child_id= 34
  136. SELECT GROUP_CONCAT( category_name
                            SEPARATOR  '/' )
                           
      FROM jos_vm_category
                           
      WHERE category_id IN (6,20,34)
  137. 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='34'
      AND a.category_id=b.category_child_id
      ORDER BY category_parent_id, list_order, category_name ASC
  138. SELECT t1.category_child_id AS lev1, t2.category_child_id AS lev2, t3.category_child_id AS lev3
                           
      FROM  jos_vm_category_xref AS t1
                           
      LEFT JOIN jos_vm_category_xref AS t2
      ON t2.category_child_id = t1.category_parent_id
                           
      LEFT JOIN jos_vm_category_xref AS t3
      ON t3.category_child_id = t2.category_parent_id
                           
      WHERE t1.category_child_id= 23
  139. SELECT GROUP_CONCAT( category_name
                            SEPARATOR  '/' )
                           
      FROM jos_vm_category
                           
      WHERE category_id IN (6,23)
  140. 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
  141. SELECT t1.category_child_id AS lev1, t2.category_child_id AS lev2, t3.category_child_id AS lev3
                           
      FROM  jos_vm_category_xref AS t1
                           
      LEFT JOIN jos_vm_category_xref AS t2
      ON t2.category_child_id = t1.category_parent_id
                           
      LEFT JOIN jos_vm_category_xref AS t3
      ON t3.category_child_id = t2.category_parent_id
                           
      WHERE t1.category_child_id= 37
  142. SELECT GROUP_CONCAT( category_name
                            SEPARATOR  '/' )
                           
      FROM jos_vm_category
                           
      WHERE category_id IN (6,23,37)
  143. 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='37'
      AND a.category_id=b.category_child_id
      ORDER BY category_parent_id, list_order, category_name ASC
  144. SELECT t1.category_child_id AS lev1, t2.category_child_id AS lev2, t3.category_child_id AS lev3
                           
      FROM  jos_vm_category_xref AS t1
                           
      LEFT JOIN jos_vm_category_xref AS t2
      ON t2.category_child_id = t1.category_parent_id
                           
      LEFT JOIN jos_vm_category_xref AS t3
      ON t3.category_child_id = t2.category_parent_id
                           
      WHERE t1.category_child_id= 39
  145. SELECT GROUP_CONCAT( category_name
                            SEPARATOR  '/' )
                           
      FROM jos_vm_category
                           
      WHERE category_id IN (6,23,39)
  146. 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
  147. SELECT t1.category_child_id AS lev1, t2.category_child_id AS lev2, t3.category_child_id AS lev3
                           
      FROM  jos_vm_category_xref AS t1
                           
      LEFT JOIN jos_vm_category_xref AS t2
      ON t2.category_child_id = t1.category_parent_id
                           
      LEFT JOIN jos_vm_category_xref AS t3
      ON t3.category_child_id = t2.category_parent_id
                           
      WHERE t1.category_child_id= 24
  148. SELECT GROUP_CONCAT( category_name
                            SEPARATOR  '/' )
                           
      FROM jos_vm_category
                           
      WHERE category_id IN (6,24)
  149. 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
  150. SELECT t1.category_child_id AS lev1, t2.category_child_id AS lev2, t3.category_child_id AS lev3
                           
      FROM  jos_vm_category_xref AS t1
                           
      LEFT JOIN jos_vm_category_xref AS t2
      ON t2.category_child_id = t1.category_parent_id
                           
      LEFT JOIN jos_vm_category_xref AS t3
      ON t3.category_child_id = t2.category_parent_id
                           
      WHERE t1.category_child_id= 29
  151. SELECT GROUP_CONCAT( category_name
                            SEPARATOR  '/' )
                           
      FROM jos_vm_category
                           
      WHERE category_id IN (6,24,29)
  152. 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='29'
      AND a.category_id=b.category_child_id
      ORDER BY category_parent_id, list_order, category_name ASC
  153. SELECT t1.category_child_id AS lev1, t2.category_child_id AS lev2, t3.category_child_id AS lev3
                           
      FROM  jos_vm_category_xref AS t1
                           
      LEFT JOIN jos_vm_category_xref AS t2
      ON t2.category_child_id = t1.category_parent_id
                           
      LEFT JOIN jos_vm_category_xref AS t3
      ON t3.category_child_id = t2.category_parent_id
                           
      WHERE t1.category_child_id= 25
  154. SELECT GROUP_CONCAT( category_name
                            SEPARATOR  '/' )
                           
      FROM jos_vm_category
                           
      WHERE category_id IN (6,25)
  155. 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
  156. SELECT t1.category_child_id AS lev1, t2.category_child_id AS lev2, t3.category_child_id AS lev3
                           
      FROM  jos_vm_category_xref AS t1
                           
      LEFT JOIN jos_vm_category_xref AS t2
      ON t2.category_child_id = t1.category_parent_id
                           
      LEFT JOIN jos_vm_category_xref AS t3
      ON t3.category_child_id = t2.category_parent_id
                           
      WHERE t1.category_child_id= 31
  157. SELECT GROUP_CONCAT( category_name
                            SEPARATOR  '/' )
                           
      FROM jos_vm_category
                           
      WHERE category_id IN (6,25,31)
  158. 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='31'
      AND a.category_id=b.category_child_id
      ORDER BY category_parent_id, list_order, category_name ASC
  159. SELECT t1.category_child_id AS lev1, t2.category_child_id AS lev2, t3.category_child_id AS lev3
                           
      FROM  jos_vm_category_xref AS t1
                           
      LEFT JOIN jos_vm_category_xref AS t2
      ON t2.category_child_id = t1.category_parent_id
                           
      LEFT JOIN jos_vm_category_xref AS t3
      ON t3.category_child_id = t2.category_parent_id
                           
      WHERE t1.category_child_id= 27
  160. SELECT GROUP_CONCAT( category_name
                            SEPARATOR  '/' )
                           
      FROM jos_vm_category
                           
      WHERE category_id IN (6,27)
  161. 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='27'
      AND a.category_id=b.category_child_id
      ORDER BY category_parent_id, list_order, category_name ASC
  162. SELECT t1.category_child_id AS lev1, t2.category_child_id AS lev2, t3.category_child_id AS lev3
                           
      FROM  jos_vm_category_xref AS t1
                           
      LEFT JOIN jos_vm_category_xref AS t2
      ON t2.category_child_id = t1.category_parent_id
                           
      LEFT JOIN jos_vm_category_xref AS t3
      ON t3.category_child_id = t2.category_parent_id
                           
      WHERE t1.category_child_id= 35
  163. SELECT GROUP_CONCAT( category_name
                            SEPARATOR  '/' )
                           
      FROM jos_vm_category
                           
      WHERE category_id IN (6,27,35)
  164. 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='35'
      AND a.category_id=b.category_child_id
      ORDER BY category_parent_id, list_order, category_name ASC
  165. SELECT t1.category_child_id AS lev1, t2.category_child_id AS lev2, t3.category_child_id AS lev3
                           
      FROM  jos_vm_category_xref AS t1
                           
      LEFT JOIN jos_vm_category_xref AS t2
      ON t2.category_child_id = t1.category_parent_id
                           
      LEFT JOIN jos_vm_category_xref AS t3
      ON t3.category_child_id = t2.category_parent_id
                           
      WHERE t1.category_child_id= 43
  166. SELECT GROUP_CONCAT( category_name
                            SEPARATOR  '/' )
                           
      FROM jos_vm_category
                           
      WHERE category_id IN (43)
  167. 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
  168. SELECT t1.category_child_id AS lev1, t2.category_child_id AS lev2, t3.category_child_id AS lev3
                           
      FROM  jos_vm_category_xref AS t1
                           
      LEFT JOIN jos_vm_category_xref AS t2
      ON t2.category_child_id = t1.category_parent_id
                           
      LEFT JOIN jos_vm_category_xref AS t3
      ON t3.category_child_id = t2.category_parent_id
                           
      WHERE t1.category_child_id= 44
  169. SELECT GROUP_CONCAT( category_name
                            SEPARATOR  '/' )
                           
      FROM jos_vm_category
                           
      WHERE category_id IN (43,44)
  170. 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
  171. SELECT t1.category_child_id AS lev1, t2.category_child_id AS lev2, t3.category_child_id AS lev3
                           
      FROM  jos_vm_category_xref AS t1
                           
      LEFT JOIN jos_vm_category_xref AS t2
      ON t2.category_child_id = t1.category_parent_id
                           
      LEFT JOIN jos_vm_category_xref AS t3
      ON t3.category_child_id = t2.category_parent_id
                           
      WHERE t1.category_child_id= 42
  172. SELECT GROUP_CONCAT( category_name
                            SEPARATOR  '/' )
                           
      FROM jos_vm_category
                           
      WHERE category_id IN (43,44,42)
  173. 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
  174. SELECT t1.category_child_id AS lev1, t2.category_child_id AS lev2, t3.category_child_id AS lev3
                           
      FROM  jos_vm_category_xref AS t1
                           
      LEFT JOIN jos_vm_category_xref AS t2
      ON t2.category_child_id = t1.category_parent_id
                           
      LEFT JOIN jos_vm_category_xref AS t3
      ON t3.category_child_id = t2.category_parent_id
                           
      WHERE t1.category_child_id= 7
  175. SELECT GROUP_CONCAT( category_name
                            SEPARATOR  '/' )
                           
      FROM jos_vm_category
                           
      WHERE category_id IN (7)
  176. 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
  177. SELECT t1.category_child_id AS lev1, t2.category_child_id AS lev2, t3.category_child_id AS lev3
                           
      FROM  jos_vm_category_xref AS t1
                           
      LEFT JOIN jos_vm_category_xref AS t2
      ON t2.category_child_id = t1.category_parent_id
                           
      LEFT JOIN jos_vm_category_xref AS t3
      ON t3.category_child_id = t2.category_parent_id
                           
      WHERE t1.category_child_id= 40
  178. SELECT GROUP_CONCAT( category_name
                            SEPARATOR  '/' )
                           
      FROM jos_vm_category
                           
      WHERE category_id IN (7,40)
  179. 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='40'
      AND a.category_id=b.category_child_id
      ORDER BY category_parent_id, list_order, category_name ASC
  180. SELECT t1.category_child_id AS lev1, t2.category_child_id AS lev2, t3.category_child_id AS lev3
                           
      FROM  jos_vm_category_xref AS t1
                           
      LEFT JOIN jos_vm_category_xref AS t2
      ON t2.category_child_id = t1.category_parent_id
                           
      LEFT JOIN jos_vm_category_xref AS t3
      ON t3.category_child_id = t2.category_parent_id
                           
      WHERE t1.category_child_id= 8
  181. SELECT GROUP_CONCAT( category_name
                            SEPARATOR  '/' )
                           
      FROM jos_vm_category
                           
      WHERE category_id IN (8)
  182. 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
  183. 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
  184. SELECT t1.category_child_id AS lev1, t2.category_child_id AS lev2, t3.category_child_id AS lev3
                           
      FROM  jos_vm_category_xref AS t1
                           
      LEFT JOIN jos_vm_category_xref AS t2
      ON t2.category_child_id = t1.category_parent_id
                           
      LEFT JOIN jos_vm_category_xref AS t3
      ON t3.category_child_id = t2.category_parent_id
                           
      WHERE t1.category_child_id= 6
  185. SELECT GROUP_CONCAT( category_name
                            SEPARATOR  '/' )
                           
      FROM jos_vm_category
                           
      WHERE category_id IN (6)
  186. SELECT t1.category_child_id AS lev1, t2.category_child_id AS lev2, t3.category_child_id AS lev3
                           
      FROM  jos_vm_category_xref AS t1
                           
      LEFT JOIN jos_vm_category_xref AS t2
      ON t2.category_child_id = t1.category_parent_id
                           
      LEFT JOIN jos_vm_category_xref AS t3
      ON t3.category_child_id = t2.category_parent_id
                           
      WHERE t1.category_child_id= 43
  187. SELECT GROUP_CONCAT( category_name
                            SEPARATOR  '/' )
                           
      FROM jos_vm_category
                           
      WHERE category_id IN (43)
  188. SELECT t1.category_child_id AS lev1, t2.category_child_id AS lev2, t3.category_child_id AS lev3
                           
      FROM  jos_vm_category_xref AS t1
                           
      LEFT JOIN jos_vm_category_xref AS t2
      ON t2.category_child_id = t1.category_parent_id
                           
      LEFT JOIN jos_vm_category_xref AS t3
      ON t3.category_child_id = t2.category_parent_id
                           
      WHERE t1.category_child_id= 7
  189. SELECT GROUP_CONCAT( category_name
                            SEPARATOR  '/' )
                           
      FROM jos_vm_category
                           
      WHERE category_id IN (7)
  190. SELECT t1.category_child_id AS lev1, t2.category_child_id AS lev2, t3.category_child_id AS lev3
                           
      FROM  jos_vm_category_xref AS t1
                           
      LEFT JOIN jos_vm_category_xref AS t2
      ON t2.category_child_id = t1.category_parent_id
                           
      LEFT JOIN jos_vm_category_xref AS t3
      ON t3.category_child_id = t2.category_parent_id
                           
      WHERE t1.category_child_id= 8
  191. SELECT GROUP_CONCAT( category_name
                            SEPARATOR  '/' )
                           
      FROM jos_vm_category
                           
      WHERE category_id IN (8)
  192. SELECT group_id,group_name,group_level
      FROM `jos_vm_auth_group`
      ORDER BY group_level
  193. SELECT published
      FROM jos_modules
      WHERE module='mod_virtuemart_cart'

193 legacy queries logged

  1. SELECT *
      FROM jos_session
      WHERE session_id = 'jn7j0d046hg4qdb8f3j974h4q2'
  2. DELETE
      FROM jos_session
      WHERE ( TIME < '1726204560' )
  3. SELECT *
      FROM jos_session
      WHERE session_id = 'jn7j0d046hg4qdb8f3j974h4q2'
  4. INSERT INTO `jos_session` ( `session_id`,`time`,`username`,`gid`,`guest`,`client_id` )
      VALUES ( 'jn7j0d046hg4qdb8f3j974h4q2','1726205460','','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 template
      FROM jos_templates_menu
      WHERE client_id = 0
      AND (menuid = 0 OR menuid = 67)
      ORDER BY menuid DESC
      LIMIT 0, 1
  8. SELECT *
      FROM jos_sections
      WHERE id = 25
      LIMIT 0, 1
  9. SELECT a.id, a.title, a.alias, a.title_alias, a.introtext, a.fulltext, a.sectionid, a.state, a.catid, a.created, a.created_by, a.created_by_alias, a.modified, a.modified_by, a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.attribs, a.hits, a.images, a.urls, a.ordering, a.metakey, a.metadesc, a.access, CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(':', a.id, a.alias) ELSE a.id END AS slug, CASE WHEN CHAR_LENGTH(cc.alias) THEN CONCAT_WS(":", cc.id, cc.alias) ELSE cc.id END AS catslug, CHAR_LENGTH( a.`fulltext` ) AS readmore, u.name AS author, u.usertype, cc.title AS category, g.name AS groups, u.email AS author_email
      FROM jos_content AS a
      INNER JOIN jos_categories AS cc
      ON cc.id = a.catid
      LEFT JOIN jos_sections AS s
      ON s.id = a.sectionid
      LEFT JOIN jos_users AS u
      ON u.id = a.created_by
      LEFT JOIN jos_groups AS g
      ON a.access = g.id
      WHERE a.access <= 0
      AND s.id = 25
      AND s.access <= 0
      AND cc.access <= 0
      AND s.published = 1
      AND cc.published = 1
      AND a.state = 1
      AND ( publish_up = '0000-00-00 00:00:00' OR publish_up <= '2024-09-13 05:31:00' )
      AND ( publish_down = '0000-00-00 00:00:00' OR publish_down >= '2024-09-13 05:31:00' )
      ORDER BY  a.created DESC
      LIMIT 0, 9
  10. SELECT a.id, a.title, a.alias, a.title_alias, a.introtext, a.fulltext, a.sectionid, a.state, a.catid, a.created, a.created_by, a.created_by_alias, a.modified, a.modified_by, a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.attribs, a.hits, a.images, a.urls, a.ordering, a.metakey, a.metadesc, a.access, CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(':', a.id, a.alias) ELSE a.id END AS slug, CASE WHEN CHAR_LENGTH(cc.alias) THEN CONCAT_WS(":", cc.id, cc.alias) ELSE cc.id END AS catslug, CHAR_LENGTH( a.`fulltext` ) AS readmore, u.name AS author, u.usertype, cc.title AS category, g.name AS groups, u.email AS author_email
      FROM jos_content AS a
      INNER JOIN jos_categories AS cc
      ON cc.id = a.catid
      LEFT JOIN jos_sections AS s
      ON s.id = a.sectionid
      LEFT JOIN jos_users AS u
      ON u.id = a.created_by
      LEFT JOIN jos_groups AS g
      ON a.access = g.id
      WHERE a.access <= 0
      AND s.id = 25
      AND s.access <= 0
      AND cc.access <= 0
      AND s.published = 1
      AND cc.published = 1
      AND a.state = 1
      AND ( publish_up = '0000-00-00 00:00:00' OR publish_up <= '2024-09-13 05:31:00' )
      AND ( publish_down = '0000-00-00 00:00:00' OR publish_down >= '2024-09-13 05:31:00' )
      ORDER BY  a.created DESC
  11. SELECT a.*, COUNT( b.id ) AS numitems, CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(':', a.id, a.alias) ELSE a.id END AS slug
      FROM jos_categories AS a
      LEFT JOIN jos_content AS b
      ON b.catid = a.id
      AND b.state = 1
      AND ( b.publish_up = '0000-00-00 00:00:00' OR b.publish_up <= '2024-09-13 05:31' )
      AND ( b.publish_down = '0000-00-00 00:00:00' OR b.publish_down >= '2024-09-13 05:31' )
      AND b.access <= 0
      WHERE a.SECTION = 25
      AND a.published = 1
      AND a.access <= 0
      GROUP BY a.id
      HAVING numitems > 0
      ORDER BY a.ordering
  12. SELECT *
      FROM jos_tagmeta
      WHERE ( (('/cantine-del-veneto-produttori-di-vino-veneti' REGEXP BINARY uri)>0
      AND case_sensitive<>'0') OR (('/cantine-del-veneto-produttori-di-vino-veneti' REGEXP uri)>0
      AND case_sensitive='0') )
      AND published='1'
      ORDER BY ordering
  13. UPDATE jos_tagmeta
      SET hits = hits + 1, last_visit = '2024-09-13 07:31:00'
      WHERE id = '20'
  14. 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 = 67 OR mm.menuid = 0 )
      ORDER BY POSITION, ordering
  15. SELECT a.*, CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(":", a.id, a.alias) ELSE a.id END AS slug, CASE WHEN CHAR_LENGTH(cc.alias) THEN CONCAT_WS(":", cc.id, cc.alias) ELSE cc.id END AS catslug
      FROM jos_content AS a
      INNER JOIN jos_categories AS cc
      ON cc.id = a.catid
      INNER JOIN jos_sections AS s
      ON s.id = a.sectionid
      WHERE a.state = 1  
      AND a.access <= 0
      AND cc.access <= 0
      AND s.access <= 0
      AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2024-09-13 05:31:00' )  
      AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-09-13 05:31:00' )
      AND cc.id = 102
      AND cc.SECTION = s.id
      AND cc.published = 1
      AND s.published = 1
      ORDER BY a.ordering
  16. SELECT *, RAND() AS ordering
      FROM jos_banner
      WHERE showBanner = 1
      AND (imptotal = 0 OR impmade < imptotal)
      AND cid = 1
      AND catid = 14
      ORDER BY sticky DESC, ordering
      LIMIT 0, 1
  17. UPDATE jos_banner
      SET impmade = impmade + 1
      WHERE bid = 1
  18. SELECT a.*, CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(":", a.id, a.alias) ELSE a.id END AS slug, CASE WHEN CHAR_LENGTH(cc.alias) THEN CONCAT_WS(":", cc.id, cc.alias) ELSE cc.id END AS catslug
      FROM jos_content AS a
      INNER JOIN jos_categories AS cc
      ON cc.id = a.catid
      INNER JOIN jos_sections AS s
      ON s.id = a.sectionid
      WHERE a.state = 1  
      AND a.access <= 0
      AND cc.access <= 0
      AND s.access <= 0
      AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2024-09-13 05:31:00' )  
      AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-09-13 05:31:00' )
      AND cc.id = 102
      AND cc.SECTION = s.id
      AND cc.published = 1
      AND s.published = 1
      ORDER BY a.ordering
  19. SELECT group_id,group_name,group_level
      FROM `jos_vm_auth_group`
      ORDER BY group_level
  20. 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'
  21. SELECT `name`
      FROM `jos_core_acl_aro_groups`
      WHERE `id` =29
  22. SELECT `lft`, `rgt`
      FROM `jos_core_acl_aro_groups`
      WHERE `name`='Public Frontend'
  23. 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
  24. SELECT `lft`, `rgt`
      FROM `jos_core_acl_aro_groups`
      WHERE `name`='Public Backend'
  25. 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
  26. 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`);
  27. SELECT m.manufacturer_id,m.mf_name
      FROM jos_vm_manufacturer m
      ORDER BY m.mf_name ASC
  28. SELECT id, params
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND published=1
  29. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND published=1
  30. SELECT mf_name
      FROM jos_vm_manufacturer AS t1  
      WHERE t1.manufacturer_id = 15;
  31. SELECT mf_name
      FROM jos_vm_manufacturer AS t1  
      WHERE t1.manufacturer_id = 13;
  32. SELECT mf_name
      FROM jos_vm_manufacturer AS t1  
      WHERE t1.manufacturer_id = 6;
  33. SELECT mf_name
      FROM jos_vm_manufacturer AS t1  
      WHERE t1.manufacturer_id = 8;
  34. SELECT mf_name
      FROM jos_vm_manufacturer AS t1  
      WHERE t1.manufacturer_id = 9;
  35. SELECT mf_name
      FROM jos_vm_manufacturer AS t1  
      WHERE t1.manufacturer_id = 4;
  36. SELECT mf_name
      FROM jos_vm_manufacturer AS t1  
      WHERE t1.manufacturer_id = 2;
  37. SELECT mf_name
      FROM jos_vm_manufacturer AS t1  
      WHERE t1.manufacturer_id = 3;
  38. SELECT mf_name
      FROM jos_vm_manufacturer AS t1  
      WHERE t1.manufacturer_id = 5;
  39. SELECT mf_name
      FROM jos_vm_manufacturer AS t1  
      WHERE t1.manufacturer_id = 11;
  40. SELECT mf_name
      FROM jos_vm_manufacturer AS t1  
      WHERE t1.manufacturer_id = 10;
  41. SELECT mf_name
      FROM jos_vm_manufacturer AS t1  
      WHERE t1.manufacturer_id = 12;
  42. SELECT mf_name
      FROM jos_vm_manufacturer AS t1  
      WHERE t1.manufacturer_id = 7;
  43. SELECT mf_name
      FROM jos_vm_manufacturer AS t1  
      WHERE t1.manufacturer_id = 14;
  44. SELECT DISTINCT product_sku
      FROM jos_vm_product, jos_vm_product_category_xref, jos_vm_category
      WHERE product_parent_id=''
      AND jos_vm_product.product_id=jos_vm_product_category_xref.product_id
      AND jos_vm_category.category_id=jos_vm_product_category_xref.category_id
      AND jos_vm_category.category_id='29'
      AND jos_vm_product.product_publish='Y'
      ORDER BY product_name DESC
  45. SELECT product_id, product_name, product_parent_id, product_thumb_image
      FROM jos_vm_product
      WHERE product_sku='GUI VERNACCIA'
  46. SELECT category_id
      FROM `jos_vm_product_category_xref`
      WHERE product_id=20
  47. SELECT
                                    `jos_vm_product`.`product_parent_id` AS product_parent_id,
                                    `jos_vm_category`.`category_flypage`
                           
      FROM
                                    `jos_vm_product`

                           
      LEFT JOIN `jos_vm_product_category_xref`
      ON `jos_vm_product_category_xref`.`product_id` = `jos_vm_product`.`product_id`
                           
      LEFT JOIN `jos_vm_category`
      ON `jos_vm_product_category_xref`.`category_id` = `jos_vm_category`.`category_id`

                           
      WHERE `jos_vm_product`.`product_id`='20'
  48. SELECT t1.category_child_id AS lev1, t2.category_child_id AS lev2, t3.category_child_id AS lev3
                           
      FROM  jos_vm_category_xref AS t1
                           
      LEFT JOIN jos_vm_category_xref AS t2
      ON t2.category_child_id = t1.category_parent_id
                           
      LEFT JOIN jos_vm_category_xref AS t3
      ON t3.category_child_id = t2.category_parent_id
                           
      WHERE t1.category_child_id= 29
  49. SELECT GROUP_CONCAT( category_name
                            SEPARATOR  '/' )
                           
      FROM jos_vm_category
                           
      WHERE category_id IN (6,24,29)
  50. SELECT product_name
      FROM jos_vm_product  
      WHERE product_id = 20
  51. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=20
  52. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='20'
      AND (start_date<='1726205460' OR start_date=0)
      AND (end_date>='1726184160' OR end_date=0)
      AND product_discount_id=discount_id
  53. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=20
  54. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1726205460' OR start_date=0)
      AND (end_date>='1726184160' OR end_date=0)
      AND product_discount_id=discount_id
  55. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='20'
  56. SELECT shopper_group_id,shopper_group_discount
      FROM jos_vm_shopper_group
      WHERE vendor_id='1'
      AND `default`='1'
  57. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=20
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  58. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=20
  59. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='20'
  60. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=20
  61. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=20
  62. SELECT product_id, product_name, product_parent_id, product_thumb_image
      FROM jos_vm_product
      WHERE product_sku='GUI IGT SANGIOVESE'
  63. SELECT category_id
      FROM `jos_vm_product_category_xref`
      WHERE product_id=23
  64. SELECT
                                    `jos_vm_product`.`product_parent_id` AS product_parent_id,
                                    `jos_vm_category`.`category_flypage`
                           
      FROM
                                    `jos_vm_product`

                           
      LEFT JOIN `jos_vm_product_category_xref`
      ON `jos_vm_product_category_xref`.`product_id` = `jos_vm_product`.`product_id`
                           
      LEFT JOIN `jos_vm_category`
      ON `jos_vm_product_category_xref`.`category_id` = `jos_vm_category`.`category_id`

                           
      WHERE `jos_vm_product`.`product_id`='23'
  65. SELECT t1.category_child_id AS lev1, t2.category_child_id AS lev2, t3.category_child_id AS lev3
                           
      FROM  jos_vm_category_xref AS t1
                           
      LEFT JOIN jos_vm_category_xref AS t2
      ON t2.category_child_id = t1.category_parent_id
                           
      LEFT JOIN jos_vm_category_xref AS t3
      ON t3.category_child_id = t2.category_parent_id
                           
      WHERE t1.category_child_id= 29
  66. SELECT GROUP_CONCAT( category_name
                            SEPARATOR  '/' )
                           
      FROM jos_vm_category
                           
      WHERE category_id IN (6,24,29)
  67. SELECT product_name
      FROM jos_vm_product  
      WHERE product_id = 23
  68. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=23
  69. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='23'
      AND (start_date<='1726205460' OR start_date=0)
      AND (end_date>='1726184160' OR end_date=0)
      AND product_discount_id=discount_id
  70. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=23
  71. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1726205460' OR start_date=0)
      AND (end_date>='1726184160' OR end_date=0)
      AND product_discount_id=discount_id
  72. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='23'
  73. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=23
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  74. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=23
  75. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='23'
  76. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=23
  77. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=23
  78. SELECT product_id, product_name, product_parent_id, product_thumb_image
      FROM jos_vm_product
      WHERE product_sku='GUI CHARDONNAY'
  79. SELECT category_id
      FROM `jos_vm_product_category_xref`
      WHERE product_id=21
  80. SELECT
                                    `jos_vm_product`.`product_parent_id` AS product_parent_id,
                                    `jos_vm_category`.`category_flypage`
                           
      FROM
                                    `jos_vm_product`

                           
      LEFT JOIN `jos_vm_product_category_xref`
      ON `jos_vm_product_category_xref`.`product_id` = `jos_vm_product`.`product_id`
                           
      LEFT JOIN `jos_vm_category`
      ON `jos_vm_product_category_xref`.`category_id` = `jos_vm_category`.`category_id`

                           
      WHERE `jos_vm_product`.`product_id`='21'
  81. SELECT t1.category_child_id AS lev1, t2.category_child_id AS lev2, t3.category_child_id AS lev3
                           
      FROM  jos_vm_category_xref AS t1
                           
      LEFT JOIN jos_vm_category_xref AS t2
      ON t2.category_child_id = t1.category_parent_id
                           
      LEFT JOIN jos_vm_category_xref AS t3
      ON t3.category_child_id = t2.category_parent_id
                           
      WHERE t1.category_child_id= 29
  82. SELECT GROUP_CONCAT( category_name
                            SEPARATOR  '/' )
                           
      FROM jos_vm_category
                           
      WHERE category_id IN (6,24,29)
  83. SELECT product_name
      FROM jos_vm_product  
      WHERE product_id = 21
  84. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=21
  85. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='21'
      AND (start_date<='1726205460' OR start_date=0)
      AND (end_date>='1726184160' OR end_date=0)
      AND product_discount_id=discount_id
  86. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=21
  87. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1726205460' OR start_date=0)
      AND (end_date>='1726184160' OR end_date=0)
      AND product_discount_id=discount_id
  88. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='21'
  89. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=21
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  90. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=21
  91. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='21'
  92. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=21
  93. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=21
  94. SELECT product_id, product_name, product_parent_id, product_thumb_image
      FROM jos_vm_product
      WHERE product_sku='GUI CHIANTI'
  95. SELECT category_id
      FROM `jos_vm_product_category_xref`
      WHERE product_id=22
  96. SELECT
                                    `jos_vm_product`.`product_parent_id` AS product_parent_id,
                                    `jos_vm_category`.`category_flypage`
                           
      FROM
                                    `jos_vm_product`

                           
      LEFT JOIN `jos_vm_product_category_xref`
      ON `jos_vm_product_category_xref`.`product_id` = `jos_vm_product`.`product_id`
                           
      LEFT JOIN `jos_vm_category`
      ON `jos_vm_product_category_xref`.`category_id` = `jos_vm_category`.`category_id`

                           
      WHERE `jos_vm_product`.`product_id`='22'
  97. SELECT t1.category_child_id AS lev1, t2.category_child_id AS lev2, t3.category_child_id AS lev3
                           
      FROM  jos_vm_category_xref AS t1
                           
      LEFT JOIN jos_vm_category_xref AS t2
      ON t2.category_child_id = t1.category_parent_id
                           
      LEFT JOIN jos_vm_category_xref AS t3
      ON t3.category_child_id = t2.category_parent_id
                           
      WHERE t1.category_child_id= 29
  98. SELECT GROUP_CONCAT( category_name
                            SEPARATOR  '/' )
                           
      FROM jos_vm_category
                           
      WHERE category_id IN (6,24,29)
  99. SELECT product_name
      FROM jos_vm_product  
      WHERE product_id = 22
  100. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=22
  101. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='22'
      AND (start_date<='1726205460' OR start_date=0)
      AND (end_date>='1726184160' OR end_date=0)
      AND product_discount_id=discount_id
  102. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=22
  103. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1726205460' OR start_date=0)
      AND (end_date>='1726184160' OR end_date=0)
      AND product_discount_id=discount_id
  104. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='22'
  105. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=22
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  106. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=22
  107. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='22'
  108. SELECT `product_id`
      FROM `jos_vm_product_attribute_sku`
      WHERE `product_id`=22
  109. SELECT `attribute`,`custom_attribute`
      FROM `jos_vm_product`
      WHERE `product_id`=22
  110. 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
  111. SELECT t1.category_child_id AS lev1, t2.category_child_id AS lev2, t3.category_child_id AS lev3
                           
      FROM  jos_vm_category_xref AS t1
                           
      LEFT JOIN jos_vm_category_xref AS t2
      ON t2.category_child_id = t1.category_parent_id
                           
      LEFT JOIN jos_vm_category_xref AS t3
      ON t3.category_child_id = t2.category_parent_id
                           
      WHERE t1.category_child_id= 6
  112. SELECT GROUP_CONCAT( category_name
                            SEPARATOR  '/' )
                           
      FROM jos_vm_category
                           
      WHERE category_id IN (6)
  113. 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
  114. SELECT t1.category_child_id AS lev1, t2.category_child_id AS lev2, t3.category_child_id AS lev3
                           
      FROM  jos_vm_category_xref AS t1
                           
      LEFT JOIN jos_vm_category_xref AS t2
      ON t2.category_child_id = t1.category_parent_id
                           
      LEFT JOIN jos_vm_category_xref AS t3
      ON t3.category_child_id = t2.category_parent_id
                           
      WHERE t1.category_child_id= 13
  115. SELECT GROUP_CONCAT( category_name
                            SEPARATOR  '/' )
                           
      FROM jos_vm_category
                           
      WHERE category_id IN (6,13)
  116. 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
  117. SELECT t1.category_child_id AS lev1, t2.category_child_id AS lev2, t3.category_child_id AS lev3
                           
      FROM  jos_vm_category_xref AS t1
                           
      LEFT JOIN jos_vm_category_xref AS t2
      ON t2.category_child_id = t1.category_parent_id
                           
      LEFT JOIN jos_vm_category_xref AS t3
      ON t3.category_child_id = t2.category_parent_id
                           
      WHERE t1.category_child_id= 32
  118. SELECT GROUP_CONCAT( category_name
                            SEPARATOR  '/' )
                           
      FROM jos_vm_category
                           
      WHERE category_id IN (6,13,32)
  119. 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='32'
      AND a.category_id=b.category_child_id
      ORDER BY category_parent_id, list_order, category_name ASC
  120. SELECT t1.category_child_id AS lev1, t2.category_child_id AS lev2, t3.category_child_id AS lev3
                           
      FROM  jos_vm_category_xref AS t1
                           
      LEFT JOIN jos_vm_category_xref AS t2
      ON t2.category_child_id = t1.category_parent_id
                           
      LEFT JOIN jos_vm_category_xref AS t3
      ON t3.category_child_id = t2.category_parent_id
                           
      WHERE t1.category_child_id= 14
  121. SELECT GROUP_CONCAT( category_name
                            SEPARATOR  '/' )
                           
      FROM jos_vm_category
                           
      WHERE category_id IN (6,14)
  122. 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
  123. SELECT t1.category_child_id AS lev1, t2.category_child_id AS lev2, t3.category_child_id AS lev3
                           
      FROM  jos_vm_category_xref AS t1
                           
      LEFT JOIN jos_vm_category_xref AS t2
      ON t2.category_child_id = t1.category_parent_id
                           
      LEFT JOIN jos_vm_category_xref AS t3
      ON t3.category_child_id = t2.category_parent_id
                           
      WHERE t1.category_child_id= 36
  124. SELECT GROUP_CONCAT( category_name
                            SEPARATOR  '/' )
                           
      FROM jos_vm_category
                           
      WHERE category_id IN (6,14,36)
  125. 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='36'
      AND a.category_id=b.category_child_id
      ORDER BY category_parent_id, list_order, category_name ASC
  126. SELECT t1.category_child_id AS lev1, t2.category_child_id AS lev2, t3.category_child_id AS lev3
                           
      FROM  jos_vm_category_xref AS t1
                           
      LEFT JOIN jos_vm_category_xref AS t2
      ON t2.category_child_id = t1.category_parent_id
                           
      LEFT JOIN jos_vm_category_xref AS t3
      ON t3.category_child_id = t2.category_parent_id
                           
      WHERE t1.category_child_id= 9
  127. SELECT GROUP_CONCAT( category_name
                            SEPARATOR  '/' )
                           
      FROM jos_vm_category
                           
      WHERE category_id IN (6,9)
  128. 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
  129. SELECT t1.category_child_id AS lev1, t2.category_child_id AS lev2, t3.category_child_id AS lev3
                           
      FROM  jos_vm_category_xref AS t1
                           
      LEFT JOIN jos_vm_category_xref AS t2
      ON t2.category_child_id = t1.category_parent_id
                           
      LEFT JOIN jos_vm_category_xref AS t3
      ON t3.category_child_id = t2.category_parent_id
                           
      WHERE t1.category_child_id= 41
  130. SELECT GROUP_CONCAT( category_name
                            SEPARATOR  '/' )
                           
      FROM jos_vm_category
                           
      WHERE category_id IN (6,9,41)
  131. 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
  132. SELECT t1.category_child_id AS lev1, t2.category_child_id AS lev2, t3.category_child_id AS lev3
                           
      FROM  jos_vm_category_xref AS t1
                           
      LEFT JOIN jos_vm_category_xref AS t2
      ON t2.category_child_id = t1.category_parent_id
                           
      LEFT JOIN jos_vm_category_xref AS t3
      ON t3.category_child_id = t2.category_parent_id
                           
      WHERE t1.category_child_id= 20
  133. SELECT GROUP_CONCAT( category_name
                            SEPARATOR  '/' )
                           
      FROM jos_vm_category
                           
      WHERE category_id IN (6,20)
  134. 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
  135. SELECT t1.category_child_id AS lev1, t2.category_child_id AS lev2, t3.category_child_id AS lev3
                           
      FROM  jos_vm_category_xref AS t1
                           
      LEFT JOIN jos_vm_category_xref AS t2
      ON t2.category_child_id = t1.category_parent_id
                           
      LEFT JOIN jos_vm_category_xref AS t3
      ON t3.category_child_id = t2.category_parent_id
                           
      WHERE t1.category_child_id= 34
  136. SELECT GROUP_CONCAT( category_name
                            SEPARATOR  '/' )
                           
      FROM jos_vm_category
                           
      WHERE category_id IN (6,20,34)
  137. 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='34'
      AND a.category_id=b.category_child_id
      ORDER BY category_parent_id, list_order, category_name ASC
  138. SELECT t1.category_child_id AS lev1, t2.category_child_id AS lev2, t3.category_child_id AS lev3
                           
      FROM  jos_vm_category_xref AS t1
                           
      LEFT JOIN jos_vm_category_xref AS t2
      ON t2.category_child_id = t1.category_parent_id
                           
      LEFT JOIN jos_vm_category_xref AS t3
      ON t3.category_child_id = t2.category_parent_id
                           
      WHERE t1.category_child_id= 23
  139. SELECT GROUP_CONCAT( category_name
                            SEPARATOR  '/' )
                           
      FROM jos_vm_category
                           
      WHERE category_id IN (6,23)
  140. 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
  141. SELECT t1.category_child_id AS lev1, t2.category_child_id AS lev2, t3.category_child_id AS lev3
                           
      FROM  jos_vm_category_xref AS t1
                           
      LEFT JOIN jos_vm_category_xref AS t2
      ON t2.category_child_id = t1.category_parent_id
                           
      LEFT JOIN jos_vm_category_xref AS t3
      ON t3.category_child_id = t2.category_parent_id
                           
      WHERE t1.category_child_id= 37
  142. SELECT GROUP_CONCAT( category_name
                            SEPARATOR  '/' )
                           
      FROM jos_vm_category
                           
      WHERE category_id IN (6,23,37)
  143. 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='37'
      AND a.category_id=b.category_child_id
      ORDER BY category_parent_id, list_order, category_name ASC
  144. SELECT t1.category_child_id AS lev1, t2.category_child_id AS lev2, t3.category_child_id AS lev3
                           
      FROM  jos_vm_category_xref AS t1
                           
      LEFT JOIN jos_vm_category_xref AS t2
      ON t2.category_child_id = t1.category_parent_id
                           
      LEFT JOIN jos_vm_category_xref AS t3
      ON t3.category_child_id = t2.category_parent_id
                           
      WHERE t1.category_child_id= 39
  145. SELECT GROUP_CONCAT( category_name
                            SEPARATOR  '/' )
                           
      FROM jos_vm_category
                           
      WHERE category_id IN (6,23,39)
  146. 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
  147. SELECT t1.category_child_id AS lev1, t2.category_child_id AS lev2, t3.category_child_id AS lev3
                           
      FROM  jos_vm_category_xref AS t1
                           
      LEFT JOIN jos_vm_category_xref AS t2
      ON t2.category_child_id = t1.category_parent_id
                           
      LEFT JOIN jos_vm_category_xref AS t3
      ON t3.category_child_id = t2.category_parent_id
                           
      WHERE t1.category_child_id= 24
  148. SELECT GROUP_CONCAT( category_name
                            SEPARATOR  '/' )
                           
      FROM jos_vm_category
                           
      WHERE category_id IN (6,24)
  149. 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
  150. SELECT t1.category_child_id AS lev1, t2.category_child_id AS lev2, t3.category_child_id AS lev3
                           
      FROM  jos_vm_category_xref AS t1
                           
      LEFT JOIN jos_vm_category_xref AS t2
      ON t2.category_child_id = t1.category_parent_id
                           
      LEFT JOIN jos_vm_category_xref AS t3
      ON t3.category_child_id = t2.category_parent_id
                           
      WHERE t1.category_child_id= 29
  151. SELECT GROUP_CONCAT( category_name
                            SEPARATOR  '/' )
                           
      FROM jos_vm_category
                           
      WHERE category_id IN (6,24,29)
  152. 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='29'
      AND a.category_id=b.category_child_id
      ORDER BY category_parent_id, list_order, category_name ASC
  153. SELECT t1.category_child_id AS lev1, t2.category_child_id AS lev2, t3.category_child_id AS lev3
                           
      FROM  jos_vm_category_xref AS t1
                           
      LEFT JOIN jos_vm_category_xref AS t2
      ON t2.category_child_id = t1.category_parent_id
                           
      LEFT JOIN jos_vm_category_xref AS t3
      ON t3.category_child_id = t2.category_parent_id
                           
      WHERE t1.category_child_id= 25
  154. SELECT GROUP_CONCAT( category_name
                            SEPARATOR  '/' )
                           
      FROM jos_vm_category
                           
      WHERE category_id IN (6,25)
  155. 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
  156. SELECT t1.category_child_id AS lev1, t2.category_child_id AS lev2, t3.category_child_id AS lev3
                           
      FROM  jos_vm_category_xref AS t1
                           
      LEFT JOIN jos_vm_category_xref AS t2
      ON t2.category_child_id = t1.category_parent_id
                           
      LEFT JOIN jos_vm_category_xref AS t3
      ON t3.category_child_id = t2.category_parent_id
                           
      WHERE t1.category_child_id= 31
  157. SELECT GROUP_CONCAT( category_name
                            SEPARATOR  '/' )
                           
      FROM jos_vm_category
                           
      WHERE category_id IN (6,25,31)
  158. 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='31'
      AND a.category_id=b.category_child_id
      ORDER BY category_parent_id, list_order, category_name ASC
  159. SELECT t1.category_child_id AS lev1, t2.category_child_id AS lev2, t3.category_child_id AS lev3
                           
      FROM  jos_vm_category_xref AS t1
                           
      LEFT JOIN jos_vm_category_xref AS t2
      ON t2.category_child_id = t1.category_parent_id
                           
      LEFT JOIN jos_vm_category_xref AS t3
      ON t3.category_child_id = t2.category_parent_id
                           
      WHERE t1.category_child_id= 27
  160. SELECT GROUP_CONCAT( category_name
                            SEPARATOR  '/' )
                           
      FROM jos_vm_category
                           
      WHERE category_id IN (6,27)
  161. 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='27'
      AND a.category_id=b.category_child_id
      ORDER BY category_parent_id, list_order, category_name ASC
  162. SELECT t1.category_child_id AS lev1, t2.category_child_id AS lev2, t3.category_child_id AS lev3
                           
      FROM  jos_vm_category_xref AS t1
                           
      LEFT JOIN jos_vm_category_xref AS t2
      ON t2.category_child_id = t1.category_parent_id
                           
      LEFT JOIN jos_vm_category_xref AS t3
      ON t3.category_child_id = t2.category_parent_id
                           
      WHERE t1.category_child_id= 35
  163. SELECT GROUP_CONCAT( category_name
                            SEPARATOR  '/' )
                           
      FROM jos_vm_category
                           
      WHERE category_id IN (6,27,35)
  164. 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='35'
      AND a.category_id=b.category_child_id
      ORDER BY category_parent_id, list_order, category_name ASC
  165. SELECT t1.category_child_id AS lev1, t2.category_child_id AS lev2, t3.category_child_id AS lev3
                           
      FROM  jos_vm_category_xref AS t1
                           
      LEFT JOIN jos_vm_category_xref AS t2
      ON t2.category_child_id = t1.category_parent_id
                           
      LEFT JOIN jos_vm_category_xref AS t3
      ON t3.category_child_id = t2.category_parent_id
                           
      WHERE t1.category_child_id= 43
  166. SELECT GROUP_CONCAT( category_name
                            SEPARATOR  '/' )
                           
      FROM jos_vm_category
                           
      WHERE category_id IN (43)
  167. 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
  168. SELECT t1.category_child_id AS lev1, t2.category_child_id AS lev2, t3.category_child_id AS lev3
                           
      FROM  jos_vm_category_xref AS t1
                           
      LEFT JOIN jos_vm_category_xref AS t2
      ON t2.category_child_id = t1.category_parent_id
                           
      LEFT JOIN jos_vm_category_xref AS t3
      ON t3.category_child_id = t2.category_parent_id
                           
      WHERE t1.category_child_id= 44
  169. SELECT GROUP_CONCAT( category_name
                            SEPARATOR  '/' )
                           
      FROM jos_vm_category
                           
      WHERE category_id IN (43,44)
  170. 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
  171. SELECT t1.category_child_id AS lev1, t2.category_child_id AS lev2, t3.category_child_id AS lev3
                           
      FROM  jos_vm_category_xref AS t1
                           
      LEFT JOIN jos_vm_category_xref AS t2
      ON t2.category_child_id = t1.category_parent_id
                           
      LEFT JOIN jos_vm_category_xref AS t3
      ON t3.category_child_id = t2.category_parent_id
                           
      WHERE t1.category_child_id= 42
  172. SELECT GROUP_CONCAT( category_name
                            SEPARATOR  '/' )
                           
      FROM jos_vm_category
                           
      WHERE category_id IN (43,44,42)
  173. 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
  174. SELECT t1.category_child_id AS lev1, t2.category_child_id AS lev2, t3.category_child_id AS lev3
                           
      FROM  jos_vm_category_xref AS t1
                           
      LEFT JOIN jos_vm_category_xref AS t2
      ON t2.category_child_id = t1.category_parent_id
                           
      LEFT JOIN jos_vm_category_xref AS t3
      ON t3.category_child_id = t2.category_parent_id
                           
      WHERE t1.category_child_id= 7
  175. SELECT GROUP_CONCAT( category_name
                            SEPARATOR  '/' )
                           
      FROM jos_vm_category
                           
      WHERE category_id IN (7)
  176. 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
  177. SELECT t1.category_child_id AS lev1, t2.category_child_id AS lev2, t3.category_child_id AS lev3
                           
      FROM  jos_vm_category_xref AS t1
                           
      LEFT JOIN jos_vm_category_xref AS t2
      ON t2.category_child_id = t1.category_parent_id
                           
      LEFT JOIN jos_vm_category_xref AS t3
      ON t3.category_child_id = t2.category_parent_id
                           
      WHERE t1.category_child_id= 40
  178. SELECT GROUP_CONCAT( category_name
                            SEPARATOR  '/' )
                           
      FROM jos_vm_category
                           
      WHERE category_id IN (7,40)
  179. 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='40'
      AND a.category_id=b.category_child_id
      ORDER BY category_parent_id, list_order, category_name ASC
  180. SELECT t1.category_child_id AS lev1, t2.category_child_id AS lev2, t3.category_child_id AS lev3
                           
      FROM  jos_vm_category_xref AS t1
                           
      LEFT JOIN jos_vm_category_xref AS t2
      ON t2.category_child_id = t1.category_parent_id
                           
      LEFT JOIN jos_vm_category_xref AS t3
      ON t3.category_child_id = t2.category_parent_id
                           
      WHERE t1.category_child_id= 8
  181. SELECT GROUP_CONCAT( category_name
                            SEPARATOR  '/' )
                           
      FROM jos_vm_category
                           
      WHERE category_id IN (8)
  182. 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
  183. 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
  184. SELECT t1.category_child_id AS lev1, t2.category_child_id AS lev2, t3.category_child_id AS lev3
                           
      FROM  jos_vm_category_xref AS t1
                           
      LEFT JOIN jos_vm_category_xref AS t2
      ON t2.category_child_id = t1.category_parent_id
                           
      LEFT JOIN jos_vm_category_xref AS t3
      ON t3.category_child_id = t2.category_parent_id
                           
      WHERE t1.category_child_id= 6
  185. SELECT GROUP_CONCAT( category_name
                            SEPARATOR  '/' )
                           
      FROM jos_vm_category
                           
      WHERE category_id IN (6)
  186. SELECT t1.category_child_id AS lev1, t2.category_child_id AS lev2, t3.category_child_id AS lev3
                           
      FROM  jos_vm_category_xref AS t1
                           
      LEFT JOIN jos_vm_category_xref AS t2
      ON t2.category_child_id = t1.category_parent_id
                           
      LEFT JOIN jos_vm_category_xref AS t3
      ON t3.category_child_id = t2.category_parent_id
                           
      WHERE t1.category_child_id= 43
  187. SELECT GROUP_CONCAT( category_name
                            SEPARATOR  '/' )
                           
      FROM jos_vm_category
                           
      WHERE category_id IN (43)
  188. SELECT t1.category_child_id AS lev1, t2.category_child_id AS lev2, t3.category_child_id AS lev3
                           
      FROM  jos_vm_category_xref AS t1
                           
      LEFT JOIN jos_vm_category_xref AS t2
      ON t2.category_child_id = t1.category_parent_id
                           
      LEFT JOIN jos_vm_category_xref AS t3
      ON t3.category_child_id = t2.category_parent_id
                           
      WHERE t1.category_child_id= 7
  189. SELECT GROUP_CONCAT( category_name
                            SEPARATOR  '/' )
                           
      FROM jos_vm_category
                           
      WHERE category_id IN (7)
  190. SELECT t1.category_child_id AS lev1, t2.category_child_id AS lev2, t3.category_child_id AS lev3
                           
      FROM  jos_vm_category_xref AS t1
                           
      LEFT JOIN jos_vm_category_xref AS t2
      ON t2.category_child_id = t1.category_parent_id
                           
      LEFT JOIN jos_vm_category_xref AS t3
      ON t3.category_child_id = t2.category_parent_id
                           
      WHERE t1.category_child_id= 8
  191. SELECT GROUP_CONCAT( category_name
                            SEPARATOR  '/' )
                           
      FROM jos_vm_category
                           
      WHERE category_id IN (8)
  192. SELECT group_id,group_name,group_level
      FROM `jos_vm_auth_group`
      ORDER BY group_level
  193. SELECT published
      FROM jos_modules
      WHERE module='mod_virtuemart_cart'

File Lingua caricati

Stringhe Diagnostica non tradotte

Nessuno

Stringhe Designer non tradotte

Nessuno