Wózki-Samochody ciężarowe / transportowe Kibri, N, Pojazdy rolnicze modellbahnshop-lippe.com
MÓJ KOSZYK
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_GB 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 (TA.HERSTELLER_ID IN (43)) AND (TA.SPUR_ID IN (2,0,7,22,23)) AND (GRPGATTSHOP.SHORT_ENTRY LIKE '013009%') ORDER BY TA.FREIGABE_DATUM DESC __
Przegląd artykułów
Brak dostępnych produktów.