Jump to content

pretashop 1.7 gestionnaire base données


Jluis

Recommended Posts

Hello , je voudrais afficher un retour à la ligne aprés l'affichage d'une caractériqtue : value au niveau de cette requeté sql 
ci-dessous non requête sql 

SELECT    `fp`.`id_product` AS 'ID', 
          p.reference       AS 'REFERENCE', 
         p.active            AS 'Actif',
          group_concat(DISTINCT( concat_ws(' ',fl.`NAME`,':',fvl.`value`)) SEPARATOR "\r\n") AS `features`
FROM      co_product p 
LEFT JOIN co_product_lang pl 
ON       ( 
                    p.id_product = pl.id_product ) 

LEFT JOIN co_feature_product fp 
ON       ( 
                    fp.id_product = p.id_product ) 
LEFT JOIN co_feature_lang fl 
ON       ( 
                    fl.id_feature = fp.id_feature AND fl.id_lang = 1 ) 
LEFT JOIN co_feature_value_lang fvl 
ON        ( 
                    fvl.id_feature_value = fp.id_feature_value ) 
WHERE pl.id_lang = 1    
                
GROUP BY  `p`.`id_product`  
ORDER BY `Actif` ASC

Un idée svp ?

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...