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 ('B1 BREP85039','B1 BREP85035','A3 ROA 239001','A9 FE FDB1323','C9 VAL598303','B1 FEB16338','B1 BREP85036','A3 TEX 2191102','A2 05P669','C9 21624-20,4','A8 203 482','C4 2162402TX','C9 21911-20,6','A1 16280 FE','C9 2162402','B1 VAI10-8132','C9 2191102','A9 GDB1200','A2 07.B314.27','B1 VAI10-8130','A3 CIF 822-181-1','B1 BLPADF124235','A5 151925','A8 201 969','E7 188.1','A1 GDB1200','A1 P85036','A2 FE FDB1323','C4 GDB1200','A2 BP85035','D2 EO FDB1323','A2 21911 206 05','A1 598303','A3 FER FDB1323','A2 RH 2390.01','A3 VAC V10-8143-1','B1 CIF822-181-2','A8 217 267','C9 FDB1323','A9 BP85036','A1 P85039','A9 BP85039','A3 VAC V10-8130','B1 CIF822-181-1','A3 VAC V10-8143','A1 571921J JRD','B1 FEB16280','A1 WBP105','A9 21624 204 05','A3 TEX 2162402','C4 05P669','B1 VAI10-8143','A1 FDB1323','A1 P85035','A1 598067','A9 21911 206 05','A5 146878','C9 VAL598067','A2 21624 204 05','C4 FDB1323','A2 BP85039','A2 05P639','B1 LUCGDB1200','A3 VAC V10-8132','B1 VAI10-8131','A1 16338 FE','A1 FDB1323-PROMO','C4 05P639','C9 GDB1200','A3 VAC V10-8131','A2 GDB1200','A1 F026000050','A2 BP85036','A1 0986424481','A1 13.0460-7077.2','A1 13.0460-7081.2','A1 2339201 TEX','A1 FDB1167','A1 FDB969','A1 GDB1275','A1 GDB1376','A1 P85045','A2 0986424481','A2 13.04707081.2','A2 21624.200.1','A2 21848 197 05','A2 21911.200.1','A2 23392 206 05','A2 BP85045','A2 FE FDB969','A2 GDB1376','A2 Q109-1123','A2 RH 2390.00','A2 RH 2390.20','A2 RH 2390.40','A3 FER FDB1167','A3 FER FDB969','A3 QUI 109-1123','A3 ROA 239000','A3 ROA 239020','A3 TEX 2339201','A5 142846','A5 16902','A5 206820','A8 201 970','A8 203 699','A8 205 371','A8 215 162','A8 217 259','A8 230 075','A8 230 091','A8 230 135','A9 0986424481','A9 13.04607077.2','A9 13.04607081.2','A9 13.04707081.2','A9 21848 197 05','A9 23392 206 05','A9 BP85045','A9 FE FDB1167','A9 GDB1204','A9 GDB1275','A9 GDB1376','A9 Q109-1123','A9 RH 2390.00','A9 RH 2390.20','A9 RH 2390.40','B1 ABS36898','B1 ATE13.0460-7077','B1 ATE13.0460-7081','B1 ATE13.0470-7081','B1 BLPADV184213','B1 BOS0986424481','B1 BREP85045','B1 FEB16334','B1 FEB16447','B1 KAMJQ101193','B1 LUCGDB1204','B1 LUCGDB1275','B1 LUCGDB1376','B1 QB109-1123','B1 VAL301008','B1 VAL301355','B1 ZIM21624.200.1','B1 ZIM21911.200.1','B7 0390.00/REM','B7 0390.20/REM','B7 0390.40/REM','B7 21624.200.1','B7 21911.200.1','B7 B110040/DKM','B7 B110043/DKM','B7 B110872/DKM','C4 05P612','C4 0986424481','C4 16447F','C4 2339201TX','C4 607077','C4 607081','C4 FDB1167','C4 GDB1204','C4 GDB1376','C4 KRO1376','C4 LD7081','C9 0252162419','C9 0252162419/PD','C9 0252184819','C9 0252191119','C9 0986424481','C9 13.0460-7077.2','C9 13.0460-7081.2','C9 13.0470-7081.2','C9 19-0650','C9 19-0660','C9 19-0661','C9 19-1821','C9 2184802','C9 2339201','C9 23392-20,6','C9 GDB1204','C9 GDB1275','C9 GDB1376','C9 QB109-1123','C9 QP1752','C9 QP1752C','C9 QP5013','C9 QP5013C','C9 QP7733','C9 QP7733C','C9 QP8417','C9 QP8417C')) and (keszlet>0) and (cikk_tecdoc.cikkszam is not null)) #