Advand | Autóalkatrész webáruház és autóápolás

#SELECT cikk_raktar.cikkszam, cikk_tecdoc.gyarto, cikk_tecdoc.keresoAZ, cikk_tecdoc.DLNr FROM cikk_tecdoc LEFT JOIN cikk_raktar on (cikk_raktar.eredeti=cikk_tecdoc.cikkszam) WHERE ((cikk_tecdoc.cikkszam IN ('A9 BD S344','A2 LP1861','A2 07.B314.26','B1 BREP59045X','B1 TOM1222','B1 LUCGDB1668','A1 0986424707','A3 VAC V40-8030','A3 VAC V40-8038','A8 215 800','A3 BOS 0986494509','B7 1263600310/JP','C9 19-3649','A5 170134','B1 ABS37361','A1 0986424479','C9 0986494508','C4 05P690','E1 40 91 6491','A1 GDB1350DTE','B1 ZIM23832.200.2','A1 16232 FE','A1 0986494508','C4 05P1197','C4 23057.195.1','B1 ZIM23832.900.2','B1 LUCGDB1668DTE','C4 0986424707','A9 0986424457','B7 23057.195.1','C9 23057 00 701 10','B1 VAI40-8038','C9 ADZ94240','A1 FSL1295-PROMO','B1 TOM1300','B1 BOS0986494509','B1 ATE13.0460-7116','C4 0986424457','A9 0986424707','C9 VAL598860','C9 0986424457','C9 GDB1350','A1 LP1309','B1 ABS37076','A2 T 2383281','C9 VAL872832','A3 BOS 0986494508','A2 RH 2683.02','A1 GDB1668','E1 40 91 6232','A3 BOS 0986424457','A5 42616','A1 0986494509','A3 BOS 0986424707','B1 BOS0986494508','C9 0986494509','E7 P7833.02/W','A2 GDB1668DTE','A1 FSL1295','C4 607179','C4 LD7116','A3 FER FDB1640','A1 P59045','A5 76429','A1 GDB1562','A2 13.04707179.2','A3 VAC V40-8020','C4 FDB1295','A2 0986424457','A3 TEX 2383202','A9 GDB1668DTE','A3 BOS 0986494513','A9 05P1197','D1 BP ADZ94240','A1 FSL1640','A9 13.04707116.2','A2 GDB1668','B7 23832.200.2','A9 RH 21036.02','A1 FDB1640','C4 KRO1668','B1 ZIM23057.995.1','B1 CIF822-258-0','A2 FE FDB1640','B1 LUCGDB1350','A9 T 2383281','A9 13.04707179.2','B1 ATE13.0460-7179','A2 0986424707','B1 VAI40-8020','A3 DLP LP1861','A8 209 669','C4 GDB1350DTE','A8 237 221','B1 ZIM23057.195.1','A9 GDB1350','A1 FDB1295','A9 13.04607116.2','C9 GDB1668DTE','A1 WBP412','A3 CIF 822-258-0','A8 230 401','A2 13.04607179.2','A1 16603 FE','A5 221709','A1 GDB1668DTE','A9 BP59045','C9 2383281','C9 13.0460-7116.2','C4 LP1309','C4 GDB1668','A5 48547','C9 PA-0073AF','A1 LP1861','C9 13.0470-7116.2','A1 WBP251','C4 LP1924','C4 FDB1640','A9 05P690','A2 BP59045','C9 19-0641','C4 KRO1350','B7 B111002/DKM','A1 FDB1295-PROMO','C9 13.0460-7179.2','A9 FE FDB1640','A8 234 101','C9 PA-0032AF','B1 ZIM23832.200.1','C9 13.0470-7179.2','C4 FDB1640W','B1 VAL301860','A1 13.0470-7116.2','A9 13.04607179.2','B1 BLPADZ94240','E1 40 91 6603','A1 0986424457','C4 LP1861','C9 0986424707','B1 VAI40-8030-1','A8 230 122','C9 23832 00 702 10','C4 23832.200.2','C9 23832-19,6 0 5','A3 DLP LP1309','A2 05P690','A3 VAC V40-8030-1','B1 VAL301454','A2 13.04707116.2','A2 BD S344','B7 1036.02/REM','C9 23832-19,6 EPAD','A2 05P1197','C4 607116','B1 ATE13.0470-7179','A1 GDB1350','A1 13.0470-7179.2','B1 VAI40-8030','B1 FEB16603','A1 WBP521','A5 125349','A9 GDB1350DTE','C9 GDB1350DTE','A1 LP1924','A9 ABS37361','A3 TEX 2383281','C9 0986494513','B1 BOS0986494513','A8 234 058','C9 FDB1640','C9 VAL301454','A1 13.0460-7116.2','C4 GDB1668DTE','B7 1263600410/JP','A2 LP1924','A3 ROA 2103602','A8 220 656','A2 LP1309','C9 VAL301860','A3 TRW GDB1350','A5 54023','C9 GDB1668','A8 219 993','A9 GDB1668','B1 CIF822-539-0','A8 233 955','A2 GDB1350DTE','A1 WBP465','A3 FER FDB1295','A2 GDB1350','A3 ROA 268302','B1 BREP59045','B1 LUCGDB1350DTE','C4 FDB1295W','C9 FDB1295','A8 235 259','C4 23832.200.1','A3 CIF 822-539-0','B1 ATE13.0470-7116','A2 13.04607116.2','A5 116034','A1 598454','C9 VAL598454','A2 ABS37361','B7 0683.02/REM','A2 RH 21036.02','B1 FEB16232','B1 BOS0986424707','B7 23832.200.1','C4 GDB1350','A3 DLP LP1924','B7 B110251/DKM','D2 EO GDB1350','A1 13.0460-7179.2','C1 RH 21036.02','A1 0986494513','B1 BOS0986424457','A5 76433','A2 Q109-1180','A2 QWS0255A','A3 QUI 109-1180','A3 QUI WS0231B','A3 QUI WS0255A','A3 ROA 2121402','A8 203 856','A9 Q109-1180','A9 QWS0231A','A9 QWS0255A','B1 BLPADW194211','B1 FEB16491','B1 KAMJQ1013280','B1 QB109-1180','B1 QBWS0231A','B1 QBWS0255A','C4 16491F','C9 0252305719/PD','C9 0252305719/W','C9 0252311619/W','C9 0252833219/PD','C9 0252833219/W','C9 23-0099','C9 QB109-1180','C9 QP0304')) and (keszlet>0) and (cikk_tecdoc.cikkszam is not null)) #