SELECT DISTINCT(e.id) as id, e.code_barre, e.flag_fusion, f.libelle as famille, sf.libelle as sousFamille, m.nom, pl.libelle as plateforme, et.libelle as etat, e.quantite_reserve, e.stock_magasin, e.stock_amazon, e.stock_cdiscount_fbc, m.prix_vente_ht,m.prix_vente_ttc, m.cree_automatiquement, emp.code as emplacement, m.id as materielId, m.prix_achat_moyen_ht as prixAchatMoyenHt, e.asin FROM materiel_code_barre AS e LEFT JOIN materiel as m ON e.materiel_id = m.id LEFT JOIN stock_emplacement as emp ON e.ean_emplacement = emp.id LEFT JOIN materiel_etat as et ON m.etat_id = et.id LEFT JOIN materiel_plateforme as pl ON m.plateforme_id = pl.id LEFT JOIN categorie as f ON m.famille_id = f.id LEFT JOIN categorie as sf ON m.sous_famille_id = f.id WHERE e.code_barre is not null AND e.code_barre <> ''AND ( e.id LIKE "%5056208812636%" OR f.libelle LIKE "%5056208812636%" OR sf.libelle LIKE "%5056208812636%" OR m.nom LIKE "%5056208812636%" OR pl.libelle LIKE "%5056208812636%" OR et.libelle LIKE "%5056208812636%" OR e.stock_magasin LIKE "%5056208812636%" OR e.code_barre LIKE "%5056208812636%" OR e.asin LIKE "%5056208812636%" OR ( SELECT COUNT(e.id) FROM materiel_code_barre e2 JOIN stock_emplacement as em2 on e2.ean_emplacement = em2.id WHERE em2.id = e.id AND em2.code LIKE "%5056208812636%") > 0) ORDER BY e.id desc LIMIT 0, 10;