Query on SQL manager doesn't update on products edit

[djatwork]

Hi, 

i'm using this query to download csv of products as import and i noticed that some product's names ending with double quotes as inches measure and this cause a bad export of products as double quote is used as separator. So i changed the names of relative products but when i export again the csv, it seems not updated. Is this a permission error or i've done something wrong? also tried to clean the cache but still nothing happened.

SELECT

p.id_product AS `ID`,

p.active AS `Attivo (0=no/1=si)`,

pl.`name` AS `Nome`,

GROUP_CONCAT(DISTINCT(cl.name) SEPARATOR ',') AS `Categorie (x,y,z...)`,

ROUND(p.price,2) AS `Prezzo per privato i.i.`,

ROUND(p.price / 2,2) AS `Prezzo per grossista i.e.`,

p.id_tax_rules_group AS `Regola tasse ID (53=IVA 22%)`,

ROUND(p.wholesale_price,2) AS `Prezzo di acquisto`,

p.on_sale AS `In saldo (0/1)`,

IF(pr.reduction_type='amount',pr.reduction,'') AS `Somma dello sconto`,

IF(pr.reduction_type='percentage',pr.reduction,'') AS `Percentuale di sconto`,

pr.`from` AS `Sconto dal (aaaa-mm-gg)`,

pr.`to` AS `Sconto al (aaaa-mm-gg)`,

p.reference AS `Codice Riferimento #`,

pps.product_supplier_reference AS `Riferimento Fornitore #`,

ps.`name` AS `Fornitore`,

pm.`name` AS `Produttore`,

p.ean13 AS `EAN13`,

p.upc AS `UPC`,

p.ecotax AS `Ecotasse`,

p.width AS `Larghezza`,

p.height AS `Lunghezza`,

p.depth AS `Profondità`,

p.weight AS `Peso`,

pq.quantity AS `Quantità`,

p.minimal_quantity AS `Qta minima`,

p.visibility AS `Visibilità (both)`,

p.additional_shipping_cost AS `Costi di spedizione aggiuntivi`,

p.unity AS `Unità per il prezzo unitario`,

p.unit_price_ratio AS `Prezzo unitario`,

pl.description_short AS `Descrizione breve`,

pl.description AS `Descrizione`,

IF(t.`name` IS NOT NULL, GROUP_CONCAT(DISTINCT(t.`name`) SEPARATOR ','), '') AS `Tags (x,y,z...)`,

pl.meta_title AS `Meta title`,

pl.meta_keywords AS `Parole chiave`,

pl.meta_description AS `Meta descrizione`,

pl.link_rewrite AS `URL amichevole`,

pl.available_now AS `Testo quando in stock`,

pl.available_later AS `Testo quando attivo backorder`,

p.available_for_order AS `Disponibile per l'ordine (0 = No, 1 = Si)`,

'' AS `Data disponibilità prodotto`,

p.date_add `Data creazione prodotto`,

p.show_price AS `Visualizza prezzo (0 = No, 1 = Si)`,

 

0 AS `Elimina immagini esistenti (0 = No, 1 = Si)`,

GROUP_CONCAT(DISTINCT(CONCAT((fl.`name`), ':', (fvl.`value`), ':' , (f.position), ':' , (fv.custom))) SEPARATOR ',') AS `Feature (Name:Value:Position:Customized)`,

p.online_only AS `Disponibili solo online (0 = No, 1 = Si)`,

p.condition AS `Condizione`,

0 AS `Personalizzabile (0 = No, 1 = Yes)`,

0 AS `File caricabili (0 = No, 1 = Yes)`,

0 AS `Campi di testo (0 = No, 1 = Yes)`,

'' AS `Azione quando non in stock`,

p.id_shop_default AS `ID / Nome dello shop`,

p.advanced_stock_management AS `Gestione avanzata magazzino`,

'' AS `Dipendenze in stock`,

'' AS `Magazzino`

FROM ip_product p

LEFT JOIN ip_product_lang pl ON (p.id_product = pl.id_product)

LEFT JOIN ip_category_product cp ON (p.id_product = cp.id_product)

LEFT JOIN ip_category_lang cl ON (cp.id_category = cl.id_category)

LEFT JOIN ip_category c ON (cp.id_category = c.id_category)

LEFT JOIN ip_specific_price pr ON (p.id_product = pr.id_product)

LEFT JOIN ip_product_tag pt ON (p.id_product = pt.id_product)

LEFT JOIN ip_tag t ON ( pt.id_tag = t.id_tag )

LEFT JOIN ip_image pi ON ( p.id_product = pi.id_product)

LEFT JOIN ip_manufacturer pm ON (p.id_manufacturer = pm.id_manufacturer)

LEFT JOIN ip_supplier ps ON (p.id_supplier = ps.id_supplier)

LEFT JOIN ip_product_supplier pps ON (p.id_supplier = pps.id_supplier)

LEFT JOIN ip_stock_available pq ON (p.id_product = pq.id_product)

LEFT JOIN ip_configuration conf ON conf.`name` = 'PS_SHOP_DOMAIN'

LEFT JOIN ip_feature_product fp ON p.id_product = fp.id_product

LEFT JOIN ip_feature_lang fl ON fp.id_feature = fl.id_feature

LEFT JOIN ip_feature_value_lang fvl ON fp.id_feature_value = fvl.id_feature_value

LEFT JOIN ip_feature f ON fp.id_feature = f.id_feature

LEFT JOIN ip_feature_value fv ON fp.id_feature_value = fv.id_feature_value

WHERE pl.id_lang = 1

AND cl.id_lang = 1

AND p.id_shop_default = 1

AND c.id_shop_default = 1

GROUP BY p.id_product;