Decoratiemateriaal Kant-en-klaar landschap modellbahnshop-lippe.com
MIJN WINKELWAGEN
product filter
____SELECT TA.MODELL_ID, TA.HERSTELLER_ID, TA.HERSTELLER_ARTIKEL_NR, TA.SPUR_ID, TA.BAHNGESELLSCHAFT_ID, TA.EPOCHE_ID, TA.STROMSYSTEM_ID, TA.MODELL_NEU, TA.HERSTELLER_AUSVERKAUFT, TA.BWARE, TA.SCHNAEPPCHEN, TA.VEDES_ARTIKEL, TA.VORBESTELLBAR, TA.KEIN_LIEFERTERMIN, TA.ID_MWST_SATZ FROM MB_ARTIKEL AS TA WITH(NOLOCK) INNER JOIN MB_HERSTELLER ON TA.HERSTELLER_ID = MB_HERSTELLER.HERSTELLER_ID INNER JOIN MB_GRUPPEN_ARTIKEL ON TA.MODELL_ID = MB_GRUPPEN_ARTIKEL.MODELL_ID INNER JOIN MB_GRUPPEN_NAMEN AS GRPGATTSHOP ON MB_GRUPPEN_ARTIKEL.SHORT_ENTRY = GRPGATTSHOP.SHORT_ENTRY LEFT JOIN MB_ARTIKEL_SUCHE_NL AS TS ON TA.modell_id = TS.modell_id WHERE (TA.FREIGABE = 1 AND MB_HERSTELLER.SHOPTYPE IN (0,1) AND MB_HERSTELLER.AKTIV = 1 AND (TA.PREMIUM_SPERRE IS NULL OR TA.PREMIUM_SPERRE = 'N')) AND (TA.IM_SHOP = 1) AND (GRPGATTSHOP.SHORT_ENTRY LIKE '004023%') ORDER BY TA.FREIGABE_DATUM DESC __
Artikelenoverzicht
Aantal per pagina