SELECT SQL_CALC_FOUND_ROWS
* FROM tbl_classi_iva LIMIT 1

SELECT SQL_CALC_FOUND_ROWS
tbl_classi_iva.id,
tbl_classi_iva.codice_iva,
tbl_classi_iva.aliquota,
tbl_classi_iva.descrizione_it AS descrizione,
tbl_classi_iva.predefinito,
tbl_classi_iva.*
FROM tbl_classi_iva

SELECT FOUND_ROWS() AS totrow

SELECT SQL_CALC_FOUND_ROWS
* FROM tbl_vetrine WHERE
url = "www.indoorline.com"
LIMIT 1

SELECT SQL_CALC_FOUND_ROWS
* FROM tbl_azienda LIMIT 1

SELECT SQL_CALC_FOUND_ROWS
tbl_azienda.visualizzazione_prezzi FROM tbl_azienda
WHERE
id_vetrina = 0
LIMIT 1

SELECT SQL_CALC_FOUND_ROWS
* FROM tbl_vetrine WHERE
url = "www.indoorline.com"
LIMIT 1

SELECT SQL_CALC_FOUND_ROWS
* FROM tbl_azienda LIMIT 1

SELECT SQL_CALC_FOUND_ROWS
tbl_azienda.prezzo_vendita FROM tbl_azienda
WHERE
id_vetrina = 0
LIMIT 1

SELECT SQL_CALC_FOUND_ROWS
tbl_listini.*
FROM tbl_listini
WHERE tbl_listini.id = 9
LIMIT 0, 1 

SELECT FOUND_ROWS() AS totrow

SELECT SQL_CALC_FOUND_ROWS
* FROM tbl_products_categories LIMIT 1

SELECT SQL_CALC_FOUND_ROWS
tbl_products_categories.id
FROM tbl_products_categories
WHERE parent_id = 0
LIMIT 0, 1 

SELECT FOUND_ROWS() AS totrow

SELECT SQL_CALC_FOUND_ROWS
* FROM tbl_vetrine WHERE
url = "www.indoorline.com"
LIMIT 1

SELECT SQL_CALC_FOUND_ROWS
* FROM tbl_vetrine WHERE
url = "www.indoorline.com"
LIMIT 1

SELECT SQL_CALC_FOUND_ROWS
* FROM tbl_vetrine WHERE
url = "www.indoorline.com"
LIMIT 1

SELECT SQL_CALC_FOUND_ROWS
* FROM tbl_vetrine WHERE
url = "www.indoorline.com"
LIMIT 1

SELECT SQL_CALC_FOUND_ROWS
* FROM tbl_vetrine WHERE
url = "www.indoorline.com"
LIMIT 1

SELECT SQL_CALC_FOUND_ROWS
* FROM tbl_vetrine WHERE
url = "www.indoorline.com"
LIMIT 1

SELECT SQL_CALC_FOUND_ROWS
tbl_azienda.* FROM tbl_azienda
WHERE
id_vetrina = 0
LIMIT 1

SELECT SQL_CALC_FOUND_ROWS
* FROM tbl_products_categories LIMIT 1

SELECT SQL_CALC_FOUND_ROWS
tbl_products_categories.id
FROM tbl_products_categories
WHERE parent_id = 0
LIMIT 0, 1 

SELECT FOUND_ROWS() AS totrow

SELECT SQL_CALC_FOUND_ROWS
tbl_products_categories.id,
tbl_products_categories.descrizione_it AS descrizione,
tbl_products_categories.parent_id,
tbl_products_categories.title_it AS title,
tbl_products_categories.nleft,
tbl_products_categories.nright,
tbl_products_categories.nlevel,
tbl_products_categories.enabled,
tbl_products_categories.protetto,
tbl_products_categories.parent_id AS parent
FROM tbl_products_categories
WHERE tbl_products_categories.enabled = 1 AND tbl_products_categories.protetto = 0
ORDER BY
tbl_products_categories.title_it asc

SELECT FOUND_ROWS() AS totrow

SELECT SQL_CALC_FOUND_ROWS
* FROM tbl_products LIMIT 1

SELECT SQL_CALC_FOUND_ROWS
* FROM tbl_producers_images LIMIT 1

SELECT SQL_CALC_FOUND_ROWS
tbl_producers.id,
tbl_producers.nome,
tbl_producers.descrizione_it AS descrizione,
tbl_producers.sito,
tbl_producers.portale,
COUNT(DISTINCT(tbl_products.id)) AS tot_products
FROM tbl_producers
INNER JOIN tbl_products ON (tbl_producers.id = tbl_products.id_produttore)
INNER JOIN tbl_categories_products ON (tbl_categories_products.id_prodotto = tbl_products.id) INNER JOIN tbl_products_categories ON (tbl_products_categories.id = tbl_categories_products.id_categoria AND tbl_products_categories.enabled = 1 AND tbl_products_categories.protetto = 0)
WHERE portale = 1
GROUP BY tbl_producers.id
ORDER BY tbl_producers.nome asc

SELECT FOUND_ROWS() AS totrow

SELECT SQL_CALC_FOUND_ROWS
path AS image, thumbnail, id_record FROM tbl_producers_images WHERE tidy = 1

SELECT SQL_CALC_FOUND_ROWS
* FROM tbl_ordini LIMIT 1

SELECT SQL_CALC_FOUND_ROWS
* FROM tbl_vetrine WHERE
url = "www.indoorline.com"
LIMIT 1

SELECT SQL_CALC_FOUND_ROWS
tbl_statiordine.*
FROM tbl_statiordine
ORDER BY
tbl_statiordine.codice asc

SELECT FOUND_ROWS() AS totrow

SELECT SQL_CALC_FOUND_ROWS
* FROM tbl_vetrine WHERE
url = "www.indoorline.com"
LIMIT 1

SELECT SQL_CALC_FOUND_ROWS
* FROM tbl_vetrine WHERE
url = "www.indoorline.com"
LIMIT 1

SELECT SQL_CALC_FOUND_ROWS
* FROM tbl_azienda LIMIT 1

SELECT SQL_CALC_FOUND_ROWS
tbl_azienda.prezzo_vendita FROM tbl_azienda
WHERE
id_vetrina = 0
LIMIT 1

SELECT SQL_CALC_FOUND_ROWS
tbl_listini.*
FROM tbl_listini
WHERE tbl_listini.id = 9
LIMIT 0, 1 

SELECT FOUND_ROWS() AS totrow

SELECT SQL_CALC_FOUND_ROWS
* FROM tbl_consumers LIMIT 1

SELECT SQL_CALC_FOUND_ROWS
* FROM tbl_vetrine WHERE
url = "www.indoorline.com"
LIMIT 1

SELECT SQL_CALC_FOUND_ROWS
* FROM tbl_azienda LIMIT 1

SELECT SQL_CALC_FOUND_ROWS
tbl_azienda.visualizzazione_prezzi FROM tbl_azienda
WHERE
id_vetrina = 0
LIMIT 1

SELECT SQL_CALC_FOUND_ROWS
* FROM tbl_vetrine WHERE
url = "www.indoorline.com"
LIMIT 1

SELECT SQL_CALC_FOUND_ROWS
* FROM tbl_vetrine WHERE
url = "www.indoorline.com"
LIMIT 1

SELECT SQL_CALC_FOUND_ROWS
* FROM tbl_azienda LIMIT 1

SELECT SQL_CALC_FOUND_ROWS
tbl_azienda.visualizzazione_prezzi FROM tbl_azienda
WHERE
id_vetrina = 0
LIMIT 1

SELECT SQL_CALC_FOUND_ROWS
* FROM tbl_vetrine WHERE
url = "www.indoorline.com"
LIMIT 1

SELECT SQL_CALC_FOUND_ROWS
* FROM tbl_spedizioni LIMIT 1

SELECT SQL_CALC_FOUND_ROWS
tbl_spedizioni.id,
tbl_spedizioni.codice,
tbl_spedizioni.nome_it AS nome,
tbl_spedizioni.descrizione_it AS descrizione,
(tbl_spedizioni.prezzo_vendita * (1+((IF(tbl_classi_iva.aliquota IS NOT NULL,tbl_classi_iva.aliquota,(SELECT aliquota FROM tbl_classi_iva WHERE predefinito = 1 LIMIT 1)))/100))) AS prezzo,
tbl_spedizioni.codice_iva,
IF(tbl_classi_iva.aliquota IS NOT NULL,tbl_classi_iva.aliquota,(SELECT aliquota FROM tbl_classi_iva WHERE predefinito = 1 LIMIT 1)) AS aliquotaiva,
tbl_spedizioni.prezzo_da_definire FROM tbl_spedizioni
LEFT OUTER JOIN tbl_classi_iva ON (tbl_classi_iva.codice_iva = tbl_spedizioni.codice_iva)
WHERE tbl_spedizioni.enabled = 1 AND tbl_spedizioni.predefinito = 1 AND (id_vetrina IS NULL OR id_vetrina = 0 OR id_vetrina = '')
GROUP BY
tbl_spedizioni.id
ORDER BY
tbl_spedizioni.prezzo_vendita asc

SELECT FOUND_ROWS() AS totrow

SELECT SQL_CALC_FOUND_ROWS
tbl_promozioni_spedizioni.*
FROM tbl_promozioni_spedizioni
WHERE enabled = 1 AND
tbl_promozioni_spedizioni.id_spedizione = "7"
ORDER BY
tbl_promozioni_spedizioni.valore_da asc

SELECT FOUND_ROWS() AS totrow

SELECT SQL_CALC_FOUND_ROWS
tbl_promozioni_spedizioni.*
FROM tbl_promozioni_spedizioni
WHERE enabled = 1 AND ((0 BETWEEN valore_da AND valore_a) OR ((valore_da IS NULL OR valore_da = '' OR valore_da = 0) AND valore_a > 0.000000) OR ((valore_a IS NULL OR valore_a = '' OR valore_a = 0) AND valore_da < 0.000000) OR ((valore_da IS NULL OR valore_da = '' OR valore_da = 0) AND (valore_a IS NULL OR valore_a = '' OR valore_a = 0))) AND
tbl_promozioni_spedizioni.id_spedizione = "7"
ORDER BY
tbl_promozioni_spedizioni.sconto desc

SELECT FOUND_ROWS() AS totrow

SELECT SQL_CALC_FOUND_ROWS
tbl_spedizioni.id,
tbl_spedizioni.codice,
tbl_spedizioni.nome_it AS nome,
tbl_spedizioni.descrizione_it AS descrizione,
(tbl_spedizioni.prezzo_vendita * (1+((IF(tbl_classi_iva.aliquota IS NOT NULL,tbl_classi_iva.aliquota,(SELECT aliquota FROM tbl_classi_iva WHERE predefinito = 1 LIMIT 1)))/100))) AS prezzo,
tbl_spedizioni.codice_iva,
IF(tbl_classi_iva.aliquota IS NOT NULL,tbl_classi_iva.aliquota,(SELECT aliquota FROM tbl_classi_iva WHERE predefinito = 1 LIMIT 1)) AS aliquotaiva,
tbl_spedizioni.prezzo_da_definire FROM tbl_spedizioni
LEFT OUTER JOIN tbl_classi_iva ON (tbl_classi_iva.codice_iva = tbl_spedizioni.codice_iva)
WHERE
tbl_spedizioni.id = 7 AND (id_vetrina IS NULL OR id_vetrina = 0 OR id_vetrina = '')
GROUP BY
tbl_spedizioni.id

SELECT FOUND_ROWS() AS totrow

SELECT SQL_CALC_FOUND_ROWS
tbl_promozioni_spedizioni.*
FROM tbl_promozioni_spedizioni
WHERE enabled = 1 AND
tbl_promozioni_spedizioni.id_spedizione = "7"
ORDER BY
tbl_promozioni_spedizioni.valore_da asc

SELECT FOUND_ROWS() AS totrow

SELECT SQL_CALC_FOUND_ROWS
tbl_promozioni_spedizioni.*
FROM tbl_promozioni_spedizioni
WHERE enabled = 1 AND ((0 BETWEEN valore_da AND valore_a) OR ((valore_da IS NULL OR valore_da = '' OR valore_da = 0) AND valore_a > 0.000000) OR ((valore_a IS NULL OR valore_a = '' OR valore_a = 0) AND valore_da < 0.000000) OR ((valore_da IS NULL OR valore_da = '' OR valore_da = 0) AND (valore_a IS NULL OR valore_a = '' OR valore_a = 0))) AND
tbl_promozioni_spedizioni.id_spedizione = "7"
ORDER BY
tbl_promozioni_spedizioni.sconto desc

SELECT FOUND_ROWS() AS totrow

SELECT SQL_CALC_FOUND_ROWS
* FROM tbl_pagamenti LIMIT 1

SELECT SQL_CALC_FOUND_ROWS
tbl_pagamenti.id,
tbl_pagamenti.nome_it AS nome,
tbl_pagamenti.descrizione_it AS descrizione,
tbl_pagamenti.codice_variazione_ordine AS codice_variazione,
tbl_pagamenti.descrizione_variazione_ordine AS descrizione_variazione,
tbl_pagamenti.valore_variazione_ordine AS valore_variazione,
tbl_pagamenti.calcolasu_variazione_ordine AS calcolasu_variazione,
tbl_pagamenti.codiceiva_variazione_ordine AS codiceiva_variazione,
tbl_pagamenti.tipo_variazione,
tbl_pagamenti.valore_sconto AS sconto_variazione,
tbl_pagamenti.aggiungi_sconto_senza_sconto,
tbl_pagamenti.massimo_ordine,
tbl_pagamenti.notifiche_it AS notifiche,
tbl_pagamenti.codice_fe,
IF(tbl_classi_iva.aliquota IS NOT NULL,tbl_classi_iva.aliquota,(SELECT aliquota FROM tbl_classi_iva WHERE predefinito = 1 LIMIT 1)) AS aliquotaiva_variazione FROM tbl_pagamenti
LEFT OUTER JOIN tbl_classi_iva ON (tbl_classi_iva.codice_iva = tbl_pagamenti.codiceiva_variazione_ordine)
WHERE tbl_pagamenti.enabled = 1 AND tbl_pagamenti.predefinito = 1 AND (id_vetrina IS NULL OR id_vetrina = 0 OR id_vetrina = '')
GROUP BY
tbl_pagamenti.id
ORDER BY
tbl_pagamenti.nome_it asc 

SELECT FOUND_ROWS() AS totrow

SELECT SQL_CALC_FOUND_ROWS
* FROM tbl_vetrine WHERE
url = "www.indoorline.com"
LIMIT 1

SELECT SQL_CALC_FOUND_ROWS
tbl_products_categories.id,
tbl_products_categories.descrizione_it AS descrizione,
tbl_products_categories.parent_id,
tbl_products_categories.title_it AS title,
tbl_products_categories.nleft,
tbl_products_categories.nright,
tbl_products_categories.nlevel,
tbl_products_categories.enabled,
tbl_products_categories.protetto,
tbl_products_categories.parent_id AS parent
FROM tbl_products_categories
WHERE tbl_products_categories.enabled = 1 AND tbl_products_categories.protetto = 0
ORDER BY
tbl_products_categories.title_it asc

SELECT FOUND_ROWS() AS totrow

SELECT SQL_CALC_FOUND_ROWS
* FROM tbl_pagine LIMIT 1

SELECT SQL_CALC_FOUND_ROWS
tbl_pagine.id,
tbl_pagine.title_it AS title,
tbl_pagine.contenuto_it AS contenuto,
tbl_pagine.nome_file,
tbl_pagine.enabled
FROM tbl_pagine
WHERE
nome_file = "index.php" AND enabled = 1
AND (id_vetrina IS NULL OR id_vetrina = 0 OR id_vetrina = '')
LIMIT 0, 1 

SELECT FOUND_ROWS() AS totrow

SELECT SQL_CALC_FOUND_ROWS
id, filename, path, thumbnail, tidy, title_it AS title, text_it AS text FROM tbl_pagine_images
WHERE id_record = 2
ORDER BY tidy asc

SELECT SQL_CALC_FOUND_ROWS
tbl_pagine.id,
tbl_pagine.title_it AS title,
tbl_pagine.contenuto_it AS contenuto,
tbl_pagine.nome_file,
tbl_pagine.enabled
FROM tbl_pagine
WHERE
nome_file = "modalita-pagamento.php" AND enabled = 1
AND (id_vetrina IS NULL OR id_vetrina = 0 OR id_vetrina = '')
LIMIT 0, 1 

SELECT FOUND_ROWS() AS totrow

SELECT SQL_CALC_FOUND_ROWS
id, filename, path, thumbnail, tidy, title_it AS title, text_it AS text FROM tbl_pagine_images
WHERE id_record = 3
ORDER BY tidy asc

SELECT SQL_CALC_FOUND_ROWS
id, filename, path, thumbnail, tidy, title_it AS title, text_it AS text FROM tbl_products_categories_images
WHERE id_record = 1
ORDER BY tidy asc LIMIT 1

SELECT SQL_CALC_FOUND_ROWS
* FROM tbl_producers LIMIT 1

SELECT SQL_CALC_FOUND_ROWS
* FROM tbl_fornitori LIMIT 1

SELECT SQL_CALC_FOUND_ROWS
* FROM tbl_raee LIMIT 1

SELECT SQL_CALC_FOUND_ROWS
* FROM tbl_products_sconti LIMIT 1

SELECT SQL_CALC_FOUND_ROWS
tbl_products.id AS id_prodotto,
tbl_products.url_key_it AS url_key,
tbl_products.codice,
tbl_products.codice_produttore,
tbl_products.id_produttore,
tbl_producers.nome AS nome_produttore,
tbl_products.codice_fornitore,
tbl_products.id_fornitore,
tbl_fornitori.nome AS nome_fornitore,
tbl_products.nome_it AS nome,
tbl_products.descrizione_it AS descrizione,
tbl_products.descrizione_breve_it AS descrizione_breve,
tbl_products.pezzi_box,
tbl_products.peso,
tbl_products.volume,
tbl_products.altezza,
tbl_products.larghezza,
tbl_products.profondita,
tbl_products.watt,
tbl_products.lumen,
tbl_products.diametro,
tbl_products.portata,
tbl_products.codice_iva,
tbl_raee.codice AS codice_raee,
tbl_products.tipo,
tbl_products.publication_date AS data_pubblicazione,
tbl_products.enabled,
tbl_products.novita,
tbl_products.data_scadenza_novita,
tbl_products.offerta,
tbl_products.data_scadenza_offerta,
tbl_products.homepage,
tbl_products.data_scadenza_homepage,
tbl_products.offerta_in_evidenza,
tbl_products.collocazione_magazzino,
tbl_products.giacenza,
tbl_products.quantita_minima,
tbl_products.quantita_consigliata,
MAX(tbl_products_sconti.sconto) AS sconto,
tbl_products_sconti.codice_partners AS sconto_codice_partners,
tbl_products_sconti.codice_consumers AS sconto_codice_consumers,
tbl_products.prezzo_vendita AS prezzo_vendita_catalogo,
tbl_products.listino9 AS prezzo_vendita,
tbl_products.listino9
FROM
tbl_products
LEFT OUTER JOIN tbl_producers ON (tbl_products.id_produttore = tbl_producers.id)
LEFT OUTER JOIN tbl_fornitori ON (tbl_products.id_fornitore = tbl_fornitori.id)
INNER JOIN tbl_categories_products ON (tbl_categories_products.id_prodotto = tbl_products.id) INNER JOIN tbl_products_categories ON (tbl_products_categories.id = tbl_categories_products.id_categoria AND tbl_products_categories.enabled = 1 AND tbl_products_categories.protetto = 0)
LEFT OUTER JOIN tbl_products_sconti ON (tbl_products_sconti.codice_prodotto = tbl_products.codice AND tbl_products_sconti.codice_consumers = "0" AND tbl_products_sconti.codice_partners = "0" AND tbl_products_sconti.enabled = 1 AND tbl_products_sconti.sconto>0 AND tbl_products_sconti.quantita_da=0 AND tbl_products_sconti.quantita_a=0 AND ((1547593201 BETWEEN tbl_products_sconti.data_validita_inizio AND tbl_products_sconti.data_validita_fine) OR ((tbl_products_sconti.data_validita_inizio = 0 OR tbl_products_sconti.data_validita_inizio is NULL OR tbl_products_sconti.data_validita_inizio = "") AND tbl_products_sconti.data_validita_fine >= 1547593200) OR ((tbl_products_sconti.data_validita_fine = 0 OR tbl_products_sconti.data_validita_fine IS NULL OR tbl_products_sconti.data_validita_fine = "") AND tbl_products_sconti.data_validita_inizio <= 1547593200) OR ((tbl_products_sconti.data_validita_fine = 0 OR tbl_products_sconti.data_validita_fine IS NULL OR tbl_products_sconti.data_validita_fine = "") AND (tbl_products_sconti.data_validita_inizio = 0 OR tbl_products_sconti.data_validita_inizio IS NULL OR tbl_products_sconti.data_validita_inizio = ""))))
LEFT OUTER JOIN tbl_raee ON (tbl_raee.id = tbl_products.id_raee)
WHERE
tbl_products.id_produttore = 104
AND
tbl_products_categories.nleft >= 1 AND tbl_products_categories.nright <= 518
GROUP BY tbl_products.id
ORDER BY
tbl_products.codice asc
LIMIT 0, 15 

SELECT FOUND_ROWS() AS totrow

SELECT SQL_CALC_FOUND_ROWS
id, filename, path, thumbnail, tidy, title_it AS title, text_it AS text FROM tbl_products_images
WHERE id_record = 993
ORDER BY tidy asc