Cantine della Toscana

Storia della Tenuta San Guido: La  storia della Tenuta San Guido è indissolubilmente legata al nome dei Marchesi Incisa della Rocchetta , ed in particolar modo a quello di Leopoldo Incisa da sempre studioso ed appassionato di enologia e viticoltura. Gli studi di Leopoldo portano alla pubblicazione, nel 1845,  di uno studio sulla stagione più adatta allo svinare , intitolata “Nozioni generali”. Ma le sue ricerche raggiungono l'apice con il famoso catalogo del 1862, in cui sono raccolte ben 175 varietà di viti in vaso, ed attirano l’interesse di ampelografi e vitivinicoltori che si recano in visita al castello della Rocchetta. Nel 1869 Leopoldo pubblica il secondo volume:  “Descrittivo e ragionato”, dedicato alla sua collezione di vitigni italiani e stranieri. Sarà il pronipote di Leopoldo,  Mario Incisa della Rocchetta, giovane studente di agraria, che trae ispirazione da quei volumi . Decide di stabilirsi con la sua famiglia nella Tenuta San Guido per poter sperimentare alcuni vitigni francesi, fino a trovare il bouquet tanto ricercato. Incomincia ad operare trapianti di barbatelle bordolesi prima sui terreni della Rocchetta e successivamente nei vitigni di Bolgheri. Nessuno aveva mai pensato di produrre  un vino "bordolese" in Italia, in particolar modo in una zona senza alcuna tradizione vinicola. Mario decide di piantare questa varietà nella Tenuta San Guido poiché scorge una analogia nelle caratteristiche morfologiche tra questa zona della Toscana e Graves, a Bordeaux. Sarà Castiglioncello il luogo ideale dove impiantare il suo cabernet: quel Sassicaia che si farà conoscere nel mondo come vino di qualità.  Malgrado le ottime premesse, i primi giudizi non furono positivi, infatti dal 1948 al 1960, il Sassicaia rimase una produzione privata e solo poche casse venivano messe a invecchiare nella cantina di Castiglioncello. Mario Incisa intuisce subito che invecchiando  il vino migliora notevolmente, i difetti si trasformano in pregi,  fin quando nel 1985 il Sassicaia è valutato unanimemente uno dei più grandi vini mai assaggiati in qualunque zona del mondo. Dove si trova la cantina Tenuta San Guido: I vigneti della Tenuta San Guido si dilatano su una superficie globale di circa 70 ettari ed hanno la peculiarità di essere frazionati in varie zone scelte all’interno della tenuta per le tipiche particolarità sia di esposizione che di composizione del terreno. Troviamo i vigneti di Castiglioncello, Doccino e Quercione ubicati nella parte collinare della tenuta ad un’altitudine che varia dai 200 ai 300 metri s.l.m.. A ridosso delle colline nella zona centrale della Tenuta troviamo i vigneti di San Martino e Mandrioli, mentre i vigneti Sassicaia ed Aianova sono situati a basso ad un’altitudine di 80 metri s.l.m. La tipologia delle uve è suddivisa per l’85% da Cabernet Sauvignon e per il restante 15% da Cabernet Franc. Il vino viene fatto invecchiare in barriques di rovere Francesi per 24 mesi, per poi essere imbottigliato per ulteriore affinato in bottiglia per altri 6 mesi prima della messa in commercio   I vini dell'Azienda Tenuta San Guido: Sassicaia Guidalberto Le Difese Dove comprare i vini della Tenuta San Guido : puoi acquistare i vini della Tenuta San Guido nell'enoteca online di guida-vino.com   Premi e riconoscimenti per i vini della Tenuta San Guido: Nel 2006 la guida Vini d'Italia del Gambero Rosso conferisce al Sassicaia 2002 il premio “Tre Bicchieri, mentre l'Associazione Italiana Sommelier gli assegna il prestigioso premio “Cinque Grappoli”.   Per contattare l'azienda : Tenuta San Guido C.I.T.A.I. spa Loc. Le Capanne 27 I-57022 Bolgheri – Livorno (Italy) Questo indirizzo e-mail è protetto dallo spam bot. Abilita Javascript per vederlo.

Cantine della Toscana - Tenuta San Guido - Marchesi Incisa della Rocchetta

Storia la Tenuta dell’Ornellaia:  La Tenuta dell’Ornellaia  nasce nel  1981 in Toscana, con l’obiettivo di creare un vino d’eccellenza, che sia l’espressione assoluta del suo territorio di origine. Il proposito del  Marchese Lodovico Antinori è quello di dare vita ad una nuova realtà vinicola su una proprietà ereditata dai Della Gherardesca, ereditata dal ramo materno della famiglia. La tenuta dell’Ornellaia  è nata con l’idea di dover dare un nuovo corso alla viticoltura italiana, percorrendo un percorso enologico esclusivo, alla ricerca della qualità e dell’eccellenza. In questi vigneti, coltivati da mani esperte, si è alla continua ricerca di un prodotto sempre migliore, rispetto alla passata vendemmia. Un microclima unico, la produzione limitata in base all’andamento dell’annata, la vendemmia ancora condotta a mano e solo dopo la piena maturazione, la vinificazione individuale adottata per ogni vigneto, il rispetto di un terroir esclusivo e pregiato, fanno dei vini prodotti in questa Tenuta, dei prodotti gran valore, ed hanno reso il marchio dell’ Ornellaia, un nome annoverato tra le più importanti case vinicole del mondo. Il gruppo che oggi pilota l'azienda si ispira con coerenza e costanza agli stessi principi che hanno portato in questi anni fama e riconoscimenti alla Tenuta dell'Ornellaia, dal 2002 proprietà delle famiglie vitivinicole Mondavi e Marchesi de' Frescobaldi. Dove si trova la Tenuta dell’Ornellaia: La Tenuta dell’Ornellaia  si trova sulla costa centrale della Toscana, ubicata tra dolci colline, puntellate di cipressi e boschi che conducono al mare. La Tenuta sorge in una zona costiera ancora selvaggia della Maremma Toscana e si estende, complessivamente, per 192 ettari: tra vigneti e cantina situati all’Ornellaia e il vicino terreno di Bellaria, a nord-ovest di Bolgheri. L'estrema diversità dei terreni, di natura marina, alluvionale e vulcanica, è l’ideale per creare dei di terroir unici, ideali per dare vita al Cabernet Sauvignon, Cabernet Franc, Merlot e Petit Verdot d’eccellenza, ed è stata proprio questa la scelta vinicolo di Lodovico Antinori. Nella Tenuta dell’Ornellaia è possibile assaporate dei prodotti unici, direttamente nel posto dove vengono elaborati e conservati. Sarà possibile partecipare alla degustazione dei vini e fermarsi a visitare la Tenuta nel suo complesso. I vini della Tenuta dell’Ornellaia: Masseto, Le Volte, Le serre nuove dell’Ornnellaia, Ornnellaia Dove comprare i vini della Tenuta dell’Ornellaia : puoi acquistare i vini della Tenuta dell’Ornellaia nell'enoteca online di guida-vino.com   Premi e riconoscimenti per i vini della Tenuta dell’Ornellaia: Essendo i riconoscimenti a livello mondiale conferiti alla Tenuta dell’Ornellaia molto numerosi, ci limitiamo a citarne solo alcuni:  Ornellaia 2006 Wine AdvocateUSA, punteggio 97/100.  Ornellaia 2004 Wine SpectatorUSA, punteggio 97/100. Ornellaia 2004 Gambero Rosso "vini d'Italia", 3 Bicchieri. Ornellaia 2004 Duemilavini AisItalia, 5 grappoli. Ornellaia 2004 Decanter UK, 5 stelle.   Per contattare l'azienda :   Tenuta dell'Ornellaia Via Bolgherese 191 - Bolgheri 57022 Castagneto Carducci (LI) Italy   http://www.ornellaia.com/home.html

Cantine della Toscana - Tenuta dell'Ornellaia

gianfranco solderaStoria dell'azienda Di Gianfranco Soldera: la tenuta Soldero nasce intorno agli anni '70 quando Gianfranco e Graziella, i coniugi Soldera, decidono di acquistare un appezzamento di terra abbandonato nel tempo dai mezzadri. Nonostante lo stato di abbandono i coniugi scoprono la bellezza e l'incanto di Casa Basse e per questo decidono di dedicarsi alla terra unendo la tradizione alla ricerca con la mission di ottenere un Brunello pregiato e di altissima qualità.

 

giardino solderaDove si trova la cantina di Gianfranco Soldera: La tenuta Casa Basse sorge nella zona sud ovest di Montalcino, luogo in cui si coltiva il vitigno Sangiovese Grosso, vitigno che permette di ottenere il famoso Brunello. Oggi la tenuta si estende su una superficie di 23 ettari caratterizzati da un terreno di origine eocenica e da un clima asciutto, privo di nebbia e molto soleggiato. Al centro della tenuta vi sono due ettari di giardino all'interno del quale troviamo circa 1.500 rose antiche e una moltitudine di piante. Inoltre vi è uno stagno e dei nidi artificiali costituiti appositamente per ospitare le numerose specie di uccelli e insetti.

 

I vini dell'Azienda di Gianfranco Soldera: nell'azienda i coniugi Soldera vengono vinificate solo uve provenienti dai vigneti di Case Base e il tutto avviene in tini e in botti di rovere. La maturazione dell'uva non avviene per mezzo dell'aggiunta di lieviti e/o sostanze simili, né tantomeno attraverso dei controlli di temperatura. Vengono soltanto posti in essere dei monitoraggi e degli assaggi continui; inoltre vengono effettuati dei controlli microbiologici da parte dell'Università di Firenze. Frutto di questo lavoro è il Brunello Soldera; prima della vendita viene tenuto in grandi botti di rovere di Slavonia dove riposa per ben cinque anni ed in un luogo lontano da sbalzi di temperatura e rumori in modo tale da permettere al vino stesso un ottmo invecchiamento. Infine vi è un periodo che va dai 6 ai 12 mesi in cui vi è l'affinamento in bottiglia. Oltre al Brunello Soldera, in passato e solo in alcune annate, è stato prodotto, sempre con le uve di Sangiovese, il vino IGT "Intistieti" ottenuto però in una durata di tempo inferiore a quella del Brunello.

 

Dove acquistare i vini dell'Azienda di Gianfranco Soldera??? ---> PUOI FARLO NELL'ENOTECA ONLINE guida-vino.com Sorridente

 

Per contattare l'azienda Soldera:

Azienda Agricola "Case Basse" di G. Soldera
Loc. Case Basse 
53024 Montalcino (Siena)

www.soldera.it

Cantine della Toscana - Gianfranco Soldera

Il Tumulo di Montefortini , nei pressi del quale si trova il vigneto Montefortini della Fattoria Ambra che da il nome all'omonimo Cru di Carmignano

Storia della Fattoria Ambra: la storia della Fattoria Ambra nasce negli anni '50, quando diventa di proprietà della famiglia Romei Rigoli, che la acquista insieme ai 20 ettari di terreno all'interno di quella che poi diverrà la DOCG Carmignano. Ben più antica è la storia del Carmignano, che invece risale addirittura ai tempi medicei, quando ne vennero fissate le prime regole di produzione, nelle quali molti vedono l'archetipo degli attuali disciplinari, fino ad indicare il Carmignano come il primo vino "di origine controllata" della storia.

dove si trova

Dove si trova la Fattoria Ambra: I vigneti della Fattoria Ambra sono posti in quattro zone fra le più rinomate della DOCG Carmignano e danno vita ad altrettanti omonimi Crus : la collina di Montalbiolo, l'Elzana, Santa Cristina in Pilli e Montefortini. Molto particolare è anche la classificazione della zona come di estremo interesse archeologico per la presenza di numerose tombe etrusche  che rendono doppiamente interessanti anche le visite ai vigneti e all'azienda.

 

I vini della Fattoria Ambra: Fattoria Ambra produce quattro Crus di Carmignano DOCG, ognuna proveniente da uno dei vigneti sopra citati. Due danno luogo a dei Carmignano Riserva : il Carmignano Riserva Elzanza, il Carmignano Riserva Vigne Alte dalla collina di Montalbiolo. Gli altri due danno luogo al Carmignano Montefortini e al Carmignano Santa Cristina in Pilli. Sebbene la produzione del Carmignano sia il "core business" dell'azienda di Beppe Rigoli, vengono prodotti anche un Rosato, un Barco Reale ( la "versione giovane del Carmignano" , ottenuta dalle stesse uve Sangiovese, Cabernet Franc e Canaiolo Nero ma affinate soltanto 6-8 mesi prevalentemente in vasche di cemento ) e un Vin Santo di Carmignano.

ambra

Premi e riconoscimenti per i vini della Fattoria Ambra: I vini di Veronelli 2009: 3 stelle, 93 punti per Carmignano DOCG “Riserva Elzana” 2005; 3 stelle, 92 punti per Carmignano DOCG “Riserva Le Vigne Alte Montalbiolo” 2005; 3 stelle, 91 punti per il Carmignano DOCG “S. Cristina in Pilli” 2006. Rober Parker, The Wine Advocat: punteggio 92 per il Carmignano DOCG “Riserva Elzana” 2004; punteggio 92 per il Carmignano DOCG “Le Vigne Alte Montalbiolo” 2004; punteggio 90 per il Carmignano DOCG “Montefortini” 2005.

Per contattare l'azienda:
FATTORIA AMBRA
Via Lombarda, 85
59015 - Carmignano ( Prato )
www.fattoriaambra.it

Cantine della Toscana - Fattoria Ambra

Storia dell'Azienda Agricola Montevertine : L'azienda agricola Montevertine nasce nel 1967 per iniziativa dell'imprenditore siderurgico Sergio Manetti, che acquista e ristruttura un podere a Radda in Chianti, nelle colline del Chianti. Il primo vigneto impiantato nel 1968 da' il nome al vino di punta dell'azienda , che oggi è uno dei supertuscans più apprezzati a livello nazionale e internazionale : il Pergole Torte. Il successo di questo vino convinse Sergio Manetti ad abbandonare l'attività industriale per diventare viticoltore a tempo pieno.. Dal 2000 , anno della scomparsa di Sergio , l'azienda è guidata dal figlio Martino Manetti.

Dove si trova l'azienda Agricola Montevertine: l'Azienda Agricola Montevertine si trova a Radda in Chianti, in provincia di Siena.  Oltre al già citato vigneto Pergole Torte, altri vigneti via via impiantati nei terreni sulle colline del Chianti sono il Montevertine, il Casino, il Solevole, il Pian del Ciampolo, la Casa, il Borro ai Colli, il Villanova. I vigneti sono per il 90% di sangiovese e per il restante 10% si dividono fra Canaiolo e Colorino.

paesaggio

 

viniI vini dell'Azienda Agricola Montevertine: il vino che ha reso famosa l'azienda in Italia e nel mondo è senz'altro il Pergole Torte, un Toscana Rosso IGT ottenuto con sangiovese in purezza invecchiato 18 mesi in botti di rovere di Slavonia, 6 mesi in barriques e circa 6 mesi in bottiglia che a buon ragione può essere annoverato tra i famosi Supertuscans. A rimorchio e sempre più apprezati sono anche gli altri due vini rossi dell'azienda, il Pian del Ciampolo e il Montevertine, dove il sangiovese resta il vitigno principale ( circa il 90% dell'uvaggio ), ma concorrono anche il canaiolo e il colorino.

Ogni anno l'artista Alberto Manfredi realizza una diversa etichetta per il Pergole Torte , vino di punta dell'Azienda Montevertine

Premi e riconoscimenti per i vini dell'Azienda Agricola Montevertine: il Toscana IGT Pergole Torte è stato premiato con i Tre Bicchieri della Guida ai Vini d'Italia del Gambero Rosso nel 2011 ( con l'annata 2007 ), nel 2010 ( con l'annata 2006 ), nel 2008 ( con l'annata 2004 ). Nel 2005 il Pergole Torte non è stato prodotto.

Per contattare l'azienda:
Azienda Agricola Montevertine S.S. di Sergio e Martino Manetti & C.
Località Montevertine
53017 Radda in Chianti (Siena) - Italy
www.montevertine.it

Note : alcune delle informazioni e delle immagini contenute in questo articolo sono tratte dal sito dell'azienda www.montevertine.it . Per segnalare eventuali imprecisioni o per richiesta di integrazioni contattaci all'indirizzo info[at]cantine-italiane.info

Cantine della Toscana - Azienda Agricola Montevertine

-

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.004 seconds, 0.69 MB
Application afterInitialise: 0.074 seconds, 1.54 MB
Application afterRoute: 0.086 seconds, 2.18 MB
Application afterDispatch: 0.193 seconds, 3.16 MB
Application afterRender: 0.664 seconds, 6.96 MB

Utilizzo Memoria

7359112

193 queries logged

  1. SELECT *
      FROM jos_session
      WHERE session_id = 'cj7ck7uf220jd0pdqct1dkbrr2'
  2. DELETE
      FROM jos_session
      WHERE ( TIME < '1695839854' )
  3. SELECT *
      FROM jos_session
      WHERE session_id = 'cj7ck7uf220jd0pdqct1dkbrr2'
  4. INSERT INTO `jos_session` ( `session_id`,`time`,`username`,`gid`,`guest`,`client_id` )
      VALUES ( 'cj7ck7uf220jd0pdqct1dkbrr2','1695840754','','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 = 63)
      ORDER BY menuid DESC
      LIMIT 0, 1
  8. SELECT *
      FROM jos_sections
      WHERE id = 21
      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 = 21
      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 <= '2023-09-27 18:52:34' )
      AND ( publish_down = '0000-00-00 00:00:00' OR publish_down >= '2023-09-27 18:52:34' )
      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 = 21
      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 <= '2023-09-27 18:52:34' )
      AND ( publish_down = '0000-00-00 00:00:00' OR publish_down >= '2023-09-27 18:52:34' )
      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 <= '2023-09-27 18:52' )
      AND ( b.publish_down = '0000-00-00 00:00:00' OR b.publish_down >= '2023-09-27 18:52' )
      AND b.access <= 0
      WHERE a.SECTION = 21
      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-della-toscana-produttori-di-vino-toscani' REGEXP BINARY uri)>0
      AND case_sensitive<>'0') OR (('/cantine-della-toscana-produttori-di-vino-toscani' REGEXP uri)>0
      AND case_sensitive='0') )
      AND published='1'
      ORDER BY ordering
  13. UPDATE jos_tagmeta
      SET hits = hits + 1, last_visit = '2023-09-27 20:52:34'
      WHERE id = '3'
  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 = 63 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 <= '2023-09-27 18:52:34' )  
      AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2023-09-27 18:52:34' )
      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 <= '2023-09-27 18:52:34' )  
      AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2023-09-27 18:52:34' )
      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<='1695840755' OR start_date=0)
      AND (end_date>='1695771360' 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<='1695840755' OR start_date=0)
      AND (end_date>='1695771360' 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<='1695840755' OR start_date=0)
      AND (end_date>='1695771360' 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<='1695840755' OR start_date=0)
      AND (end_date>='1695771360' 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<='1695840755' OR start_date=0)
      AND (end_date>='1695771360' 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<='1695840755' OR start_date=0)
      AND (end_date>='1695771360' 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<='1695840755' OR start_date=0)
      AND (end_date>='1695771360' 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<='1695840755' OR start_date=0)
      AND (end_date>='1695771360' 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 = 'cj7ck7uf220jd0pdqct1dkbrr2'
  2. DELETE
      FROM jos_session
      WHERE ( TIME < '1695839854' )
  3. SELECT *
      FROM jos_session
      WHERE session_id = 'cj7ck7uf220jd0pdqct1dkbrr2'
  4. INSERT INTO `jos_session` ( `session_id`,`time`,`username`,`gid`,`guest`,`client_id` )
      VALUES ( 'cj7ck7uf220jd0pdqct1dkbrr2','1695840754','','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 = 63)
      ORDER BY menuid DESC
      LIMIT 0, 1
  8. SELECT *
      FROM jos_sections
      WHERE id = 21
      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 = 21
      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 <= '2023-09-27 18:52:34' )
      AND ( publish_down = '0000-00-00 00:00:00' OR publish_down >= '2023-09-27 18:52:34' )
      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 = 21
      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 <= '2023-09-27 18:52:34' )
      AND ( publish_down = '0000-00-00 00:00:00' OR publish_down >= '2023-09-27 18:52:34' )
      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 <= '2023-09-27 18:52' )
      AND ( b.publish_down = '0000-00-00 00:00:00' OR b.publish_down >= '2023-09-27 18:52' )
      AND b.access <= 0
      WHERE a.SECTION = 21
      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-della-toscana-produttori-di-vino-toscani' REGEXP BINARY uri)>0
      AND case_sensitive<>'0') OR (('/cantine-della-toscana-produttori-di-vino-toscani' REGEXP uri)>0
      AND case_sensitive='0') )
      AND published='1'
      ORDER BY ordering
  13. UPDATE jos_tagmeta
      SET hits = hits + 1, last_visit = '2023-09-27 20:52:34'
      WHERE id = '3'
  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 = 63 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 <= '2023-09-27 18:52:34' )  
      AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2023-09-27 18:52:34' )
      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 <= '2023-09-27 18:52:34' )  
      AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2023-09-27 18:52:34' )
      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<='1695840755' OR start_date=0)
      AND (end_date>='1695771360' 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<='1695840755' OR start_date=0)
      AND (end_date>='1695771360' 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<='1695840755' OR start_date=0)
      AND (end_date>='1695771360' 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<='1695840755' OR start_date=0)
      AND (end_date>='1695771360' 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<='1695840755' OR start_date=0)
      AND (end_date>='1695771360' 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<='1695840755' OR start_date=0)
      AND (end_date>='1695771360' 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<='1695840755' OR start_date=0)
      AND (end_date>='1695771360' 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<='1695840755' OR start_date=0)
      AND (end_date>='1695771360' 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