SELECT di.sku,di.nom,di.couleur ,s.name as size, m.name_model as modele_nom , m.id_model as modele_id ,
ma.name as marque_nom ,ma.id_mark as marque_id,di.qty,di.sexe,prix,di.etiquette,di.combined_width,
di.warranty,di.prescription
FROM product_simple as di
inner join models as m on m.name_model=di.modele_nom
inner join mark as ma on ma.name = di.marque_nom
left join size as s on s.mag_value=di.size limit 0,20