Wedding ring presentation boxes

FIRSTSELECT SQL_CALC_FOUND_ROWS _prix.id_article, a.uk, IFNULL( _prix.conditionnement_uk , IFNULL( _prix.conditionnement_uk, _prix.conditionnement_fr )) AS 'titre_uk', IF( _prix.conditionnement_uk IS NULL , IF( _prix.conditionnement_uk IS NULL , 'fr' , 'uk'), 'uk' ) AS 'titre_langue', _prix.ref_prix as 'reference', a.id_categorieA, a.id_categorieB, a.id_categorieC, a.selection , _prix.id_article, Couleur.Nom_fr FROM _articles a INNER JOIN _prix on a.id_article = _prix.id_article LEFT OUTER JOIN Tri_Trieur on _prix.id_prix = Tri_Trieur.ID_Prix LEFT OUTER JOIN Tri_Caract as Couleur on Couleur.ID_Caract = Tri_Trieur.ID_Caract3 WHERE a.uk = '1' AND Tri_Trieur.ID_Caract1 = ( SELECT MIN(Tri_Trieur.ID_Caract1) FROM Tri_Trieur WHERE ID_Article = a.id_article AND Tri_Trieur.ID_Caract3 = Couleur.ID_Caract ) AND _prix.actif = '1' AND ( (_prix.stock > 0 ) ) AND ( (_prix.indispo = 0 ) OR ( _prix.indispo = 1 AND _prix.indispo_date < ADDDATE(_prix.indispo_date, INTERVAL 7 DAY) ) ) AND _prix.SE = 1 AND a.id_categorieA = '6' AND a.id_categorieB = '137702' GROUP BY a.id_article, Tri_Trieur.ID_Caract3 ORDER BY Tri_Trieur.ID_Caract1, _prix.date_miseenligne DESC, a.ordre, a.id_article DESC LIMIT 0, 12