LAMPES À POSER

Large choix de lampes à poser pour bureaux, lampes à poser pour buffet, lampes pour dessertes, lampes de table, lampes de chevet, contemporaines ou classiques. select a.ident as aident,m.nom as mnom,a.modele as amodele,a.version as aversion,a.prixcat as aprixcat,a.prix as aprix from armen_articles as a left join armen_marques as m on m.ident=a.marque where (a.rub='3' or a.rub2='3') and a.onair='1' and a.date<>0 and a.marque='2' and a.prix = (select min(prix) from armen_articles where modele=a.modele and (rub='3' or rub2='3') and onair='1' and date<>0 and marque='2') group by m.nom,a.modele order by a.modele,a.version,a.prix select a.ident as aident,m.nom as mnom,a.modele as amodele,a.version as aversion,a.prixcat as aprixcat,a.prix as aprix from armen_articles as a left join armen_marques as m on m.ident=a.marque where (a.rub='3' or a.rub2='3') and a.onair='1' and a.date<>0 and a.marque='6' and a.prix = (select min(prix) from armen_articles where modele=a.modele and (rub='3' or rub2='3') and onair='1' and date<>0 and marque='6') group by m.nom,a.modele order by a.modele,a.version,a.prix select a.ident as aident,m.nom as mnom,a.modele as amodele,a.version as aversion,a.prixcat as aprixcat,a.prix as aprix from armen_articles as a left join armen_marques as m on m.ident=a.marque where (a.rub='3' or a.rub2='3') and a.onair='1' and a.date<>0 and a.marque='4' and a.prix = (select min(prix) from armen_articles where modele=a.modele and (rub='3' or rub2='3') and onair='1' and date<>0 and marque='4') group by m.nom,a.modele order by a.modele,a.version,a.prix select a.ident as aident,m.nom as mnom,a.modele as amodele,a.version as aversion,a.prixcat as aprixcat,a.prix as aprix from armen_articles as a left join armen_marques as m on m.ident=a.marque where (a.rub='3' or a.rub2='3') and a.onair='1' and a.date<>0 and a.marque='5' and a.prix = (select min(prix) from armen_articles where modele=a.modele and (rub='3' or rub2='3') and onair='1' and date<>0 and marque='5') group by m.nom,a.modele order by a.modele,a.version,a.prix select a.ident as aident,m.nom as mnom,a.modele as amodele,a.version as aversion,a.prixcat as aprixcat,a.prix as aprix from armen_articles as a left join armen_marques as m on m.ident=a.marque where (a.rub='3' or a.rub2='3') and a.onair='1' and a.date<>0 and a.marque='3' and a.prix = (select min(prix) from armen_articles where modele=a.modele and (rub='3' or rub2='3') and onair='1' and date<>0 and marque='3') group by m.nom,a.modele order by a.modele,a.version,a.prix