SELECT DISTINCT a.*, b.marque FROM produits a LEFT JOIN marque b ON a.id_marque=b.id WHERE descriptif LIKE '%Boots%' AND (descriptif LIKE '%,20%' OR descriptif LIKE '%20,%') SELECT DISTINCT a.*, b.marque FROM produits a LEFT JOIN marque b ON a.id_marque=b.id WHERE descriptif LIKE '%Boots%' AND (descriptif LIKE '%,21%' OR descriptif LIKE '%21,%') SELECT DISTINCT a.*, b.marque FROM produits a LEFT JOIN marque b ON a.id_marque=b.id WHERE descriptif LIKE '%Boots%' AND (descriptif LIKE '%,22%' OR descriptif LIKE '%22,%') SELECT DISTINCT a.*, b.marque FROM produits a LEFT JOIN marque b ON a.id_marque=b.id WHERE descriptif LIKE '%Boots%' AND (descriptif LIKE '%,23%' OR descriptif LIKE '%23,%') SELECT DISTINCT a.*, b.marque FROM produits a LEFT JOIN marque b ON a.id_marque=b.id WHERE descriptif LIKE '%Boots%' AND (descriptif LIKE '%,24%' OR descriptif LIKE '%24,%') SELECT DISTINCT a.*, b.marque FROM produits a LEFT JOIN marque b ON a.id_marque=b.id WHERE descriptif LIKE '%Boots%' AND (descriptif LIKE '%,25%' OR descriptif LIKE '%25,%') SELECT DISTINCT a.*, b.marque FROM produits a LEFT JOIN marque b ON a.id_marque=b.id WHERE descriptif LIKE '%Boots%' AND (descriptif LIKE '%,26%' OR descriptif LIKE '%26,%') SELECT DISTINCT a.*, b.marque FROM produits a LEFT JOIN marque b ON a.id_marque=b.id WHERE descriptif LIKE '%Boots%' AND (descriptif LIKE '%,27%' OR descriptif LIKE '%27,%') SELECT DISTINCT a.*, b.marque FROM produits a LEFT JOIN marque b ON a.id_marque=b.id WHERE descriptif LIKE '%Boots%' AND (descriptif LIKE '%,28%' OR descriptif LIKE '%28,%') SELECT DISTINCT a.*, b.marque FROM produits a LEFT JOIN marque b ON a.id_marque=b.id WHERE descriptif LIKE '%Boots%' AND (descriptif LIKE '%,29%' OR descriptif LIKE '%29,%') SELECT DISTINCT a.*, b.marque FROM produits a LEFT JOIN marque b ON a.id_marque=b.id WHERE descriptif LIKE '%Boots%' AND (descriptif LIKE '%,30%' OR descriptif LIKE '%30,%') SELECT DISTINCT a.*, b.marque FROM produits a LEFT JOIN marque b ON a.id_marque=b.id WHERE descriptif LIKE '%Boots%' AND (descriptif LIKE '%,31%' OR descriptif LIKE '%31,%') SELECT DISTINCT a.*, b.marque FROM produits a LEFT JOIN marque b ON a.id_marque=b.id WHERE descriptif LIKE '%Boots%' AND (descriptif LIKE '%,32%' OR descriptif LIKE '%32,%') SELECT DISTINCT a.*, b.marque FROM produits a LEFT JOIN marque b ON a.id_marque=b.id WHERE descriptif LIKE '%Boots%' AND (descriptif LIKE '%,33%' OR descriptif LIKE '%33,%') SELECT DISTINCT a.*, b.marque FROM produits a LEFT JOIN marque b ON a.id_marque=b.id WHERE descriptif LIKE '%Boots%' AND (descriptif LIKE '%,34%' OR descriptif LIKE '%34,%') SELECT DISTINCT a.*, b.marque FROM produits a LEFT JOIN marque b ON a.id_marque=b.id WHERE descriptif LIKE '%Boots%' AND (descriptif LIKE '%,35%' OR descriptif LIKE '%35,%') Taille 35 SELECT DISTINCT a.*, b.marque FROM produits a LEFT JOIN marque b ON a.id_marque=b.id WHERE descriptif LIKE '%Boots%' AND (descriptif LIKE '%,36%' OR descriptif LIKE '%36,%') Taille 36 SELECT DISTINCT a.*, b.marque FROM produits a LEFT JOIN marque b ON a.id_marque=b.id WHERE descriptif LIKE '%Boots%' AND (descriptif LIKE '%,37%' OR descriptif LIKE '%37,%') Taille 37 SELECT DISTINCT a.*, b.marque FROM produits a LEFT JOIN marque b ON a.id_marque=b.id WHERE descriptif LIKE '%Boots%' AND (descriptif LIKE '%,38%' OR descriptif LIKE '%38,%') Taille 38 SELECT DISTINCT a.*, b.marque FROM produits a LEFT JOIN marque b ON a.id_marque=b.id WHERE descriptif LIKE '%Boots%' AND (descriptif LIKE '%,39%' OR descriptif LIKE '%39,%') Taille 39 SELECT DISTINCT a.*, b.marque FROM produits a LEFT JOIN marque b ON a.id_marque=b.id WHERE descriptif LIKE '%Boots%' AND (descriptif LIKE '%,40%' OR descriptif LIKE '%40,%') Taille 40 SELECT DISTINCT a.*, b.marque FROM produits a LEFT JOIN marque b ON a.id_marque=b.id WHERE descriptif LIKE '%Boots%' AND (descriptif LIKE '%,41%' OR descriptif LIKE '%41,%') Taille 41 SELECT DISTINCT a.*, b.marque FROM produits a LEFT JOIN marque b ON a.id_marque=b.id WHERE descriptif LIKE '%Boots%' AND (descriptif LIKE '%,42%' OR descriptif LIKE '%42,%') Taille 42 SELECT DISTINCT a.*, b.marque FROM produits a LEFT JOIN marque b ON a.id_marque=b.id WHERE descriptif LIKE '%Boots%' AND (descriptif LIKE '%,43%' OR descriptif LIKE '%43,%') Taille 43 SELECT DISTINCT a.*, b.marque FROM produits a LEFT JOIN marque b ON a.id_marque=b.id WHERE descriptif LIKE '%Boots%' AND (descriptif LIKE '%,44%' OR descriptif LIKE '%44,%') Taille 44 SELECT DISTINCT a.*, b.marque FROM produits a LEFT JOIN marque b ON a.id_marque=b.id WHERE descriptif LIKE '%Boots%' AND (descriptif LIKE '%,45%' OR descriptif LIKE '%45,%') Taille 45 SELECT DISTINCT a.*, b.marque FROM produits a LEFT JOIN marque b ON a.id_marque=b.id WHERE descriptif LIKE '%Boots%' AND (descriptif LIKE '%,46%' OR descriptif LIKE '%46,%') Taille 46 SELECT DISTINCT a.*, b.marque FROM produits a LEFT JOIN marque b ON a.id_marque=b.id WHERE descriptif LIKE '%Boots%' AND (descriptif LIKE '%,47%' OR descriptif LIKE '%47,%') Taille 47 SELECT DISTINCT a.*, b.marque FROM produits a LEFT JOIN marque b ON a.id_marque=b.id WHERE descriptif LIKE '%Boots%' AND (descriptif LIKE '%,48%' OR descriptif LIKE '%48,%') Taille 48 SELECT DISTINCT a.*, b.marque FROM produits a LEFT JOIN marque b ON a.id_marque=b.id WHERE descriptif LIKE '%Boots%' AND (descriptif LIKE '%,49%' OR descriptif LIKE '%49,%') Taille 49 Toutes les tailles