LAMPES À POSER

Large choix de lampes à poser pour bureaux, lampes à poser pour buffet, lampes pour dessertes, lampes de table, lampes de chevet, originales, éco-conçues, contemporaines, classiques, minimalistes ou encore nomades. 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