Confezioni Regalo confezioni-regalo

SELECT BERNABEI.dbo.listinoCompleto.chiave, BERNABEI.dbo.listinoCompleto.articolo, BERNABEI.dbo.FEBMAG3.WEBDESCR, BERNABEI.dbo.FEBMAG3.UM, BERNABEI.dbo.listinoCompleto.prezzo, BERNABEI.dbo.FEBSPR3.COMMENTO, BERNABEI.dbo.listinoCompleto.offerta, BERNABEI.dbo.EBWMAG.KEYWORDS, BERNABEI.dbo.EBWMAG.DESCRIZIONE, BERNABEI.dbo.FEBMAG3.IMMAGINE, BERNABEI.dbo.FEBMAG6.DATADA, BERNABEI.dbo.FEBMAG6.DATAA, BERNABEI.dbo.FEBMAG6.FINITOOFF, BERNABEI.dbo.EBWMAG.TAG, BERNABEI.dbo.FEBMAG3.ESCLUSIVA, BERNABEI.dbo.FEBMAG3.ESAURITO, BERNABEI.dbo.FEBMAG3.UMT, BERNABEI.dbo.FEBMAG3.UMV, BERNABEI.dbo.EBWMAG.RANK, BERNABEI.dbo.EBWMAG.MATCHURL FROM (((BERNABEI.dbo.listinoCompleto LEFT OUTER JOIN BERNABEI.dbo.FEBMAG3 ON BERNABEI.dbo.listinoCompleto.articolo = BERNABEI.dbo.FEBMAG3.ARTICOLO) LEFT OUTER JOIN BERNABEI.dbo.EBWMAG ON BERNABEI.dbo.listinoCompleto.articolo = BERNABEI.dbo.EBWMAG.ARTICOLO) LEFT OUTER JOIN BERNABEI.dbo.FEBSPR3 ON BERNABEI.dbo.listinoCompleto.articolo = BERNABEI.dbo.FEBSPR3.ARTICOLO) LEFT OUTER JOIN BERNABEI.dbo.FEBMAG6 ON BERNABEI.dbo.listinoCompleto.articolo = BERNABEI.dbo.FEBMAG6.ARTICOLO AND ( BERNABEI.dbo.FEBMAG6.TIPOOFF='PRIVATI' ) WHERE BERNABEI.dbo.FEBMAG3.IMMAGINE=1 AND listinoCompleto.chiave='ENO_0_20120518' AND EBWMAG.TAG Like '%|56|%' ORDER BY EBWMAG.RANK DESC,FEBMAG3.WEBDESCR