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 ('A1 F8-6736','A2 AK.17772','A8 454 453','B7 00727732/IP','A8 461 070','B1 COR80001202','A2 AK.17422','C9 829010710','A9 JBU602','C9 985461','B7 D300027/DKM','A1 829 0107 10','B7 00727181/IP','A9 S857607','A9 40.16.742','C9 FE31253','B1 TED00721398','B1 TED00726013','C4 VKDS 331004','A2 40.16.742','C9 6Q0407183/MG','C9 1006100043','A5 191549','B1 BORB12230','B1 ABS270582','A1 TD410W','B1 ABS271126','A2 TD522W','B7 T404863/STC','C9 B11352','C9 00727181','A3 TRU 07.31.181','C9 111021586','C6 017046','B1 TED00726011','C4 SE-SB-0104','B1 HUT590021','A8 421 605','B7 829 0108 10','A3 DLP TD522W','A1 F8-6424','B1 GSP510333','A8 452 278','C9 985462','C9 2256001','B1 GSP510354','C4 TD410W','A3 FEB 31253','B1 VKA44070027801','C9 829031810','C4 V10-3251','A1 857607 SID','B1 MOZL29887','A1 F8-6425','A2 TD410W','B1 HP111 020','B7 D300080/DKM','B1 TEDTED42843','A3 HUT 590021','B1 RTS017.05995','A3 VAC V10-3251','A1 31253 FE','A2 S857607','E2 111 021 755','A3 BGD BSP20891','A5 352742','A9 AK.17772','C6 007660','A3 MEY 1001990086/HD','B1 VKA41990305801','A3 MON L29887','C9 988200','B7 510333/GSP','A3 MEY 1006100027/HD','C9 112463755','C6 000392','B1 TRWJBU602','A1 WRM276','B1 GSP510355','B7 1140200300/JP','C9 111020586','A2 S863632','A2 12.27.741','A8 473 474','C9 80001202','A3 RUV 985462','B7 1117900780/JP','C9 FSTVWAB-GVRH','A1 RU987805','B1 FAG829031810','A8 438 705','C6 007557','B7 52004508/MTZ','B7 00726013/IP','A4 100 610 0027/HD','B1 VKA41990305701','C4 VKDS 331005','A8 454 407','B1 SAS2256001','C4 109663HP','A5 194113','B1 MOZL29857','A1 TD523W','B7 00721398/IP','B7 D300079/DKM','A2 30 93 1253','B7 988200','B1 VAI10-1680','A3 COR 80001202','A3 MOG SE-SB-0104','A3 TRU 07.31.160','A9 AK.177851','A1 863632 SID','A3 MEY 1001990085/HD','B7 985461','A9 12.27.741','C9 00727175','A1 829 0318 10','C9 FSTVWAB-GVLH','C9 2256002','C9 829010810','C6 014314','C9 1006100027/HD','A4 109 663 755','C9 FSTVWAB-GVX','A3 DLP TD410W','B1 BORB11352','A9 TD410W','C9 1001990086/HD','A9 AK.17422','C9 1001990085/HD','B1 FAG829057810','B7 1117900770/JP','B1 FAG829010710','A3 DLP TD523W','C4 850029876T','C4 07.31.160','C9 B12230','A3 NKS 5104302PRO','C6 014101','B1 GSP510334','A2 12.27.740','A1 WRM305','A8 421 583','C4 31253F','A1 SE-SB-0104','C9 5104302PRO','B7 T404862/STC','B7 510334/GSP','B1 VKA44070384401','C9 5104302','A1 829 0108 10','C9 TED42843','C4 JBU602','C6 007661','B1 ABS270581','A5 352743','A8 042 204','C9 00727732','E2 109 663 755','B1 KAM8800161','B1 GSP510332','B7 TED42843/IP','C4 TD523W','C9 00726013','B7 985462','C9 2256003','A8 454 452','A3 RUV 985461','A1 TD522W','C4 TD522W','A5 353877','C9 00727745','C9 00721398','C4 100 610 0027/HDMY','B7 987805','A3 NKS 5104302','A8 461 071','A9 30 93 1253','C9 B11351','A3 VAC V10-1680','B1 FEB31253','A8 457 480','B1 BORB11351','A1 WRM274','B1 SAS2256002','A1 RU988200','C6 014315','B1 HP109 663','A5 12804','C4 VKDS 331037','E2 111 020 755','B1 TRU07.31.160','A8 447 610','B1 MOZL29876','A1 JBU602','B7 T404691/STC','B7 T406570/STC','B1 MOZL29861','A9 S863632','B1 TRU07.31.161','C4 100 610 0043MY','A1 F8-6428','A1 RU985461','B1 VAI10-3251','C4 07.31.161','B1 SAS2256003','B7 829 0318 10','C4 100 199 0086/HDMY','B7 00726011/IP','E3 SB489','C4 52004508','B1 FAG829010810','A2 AK.177851','A9 12.27.740','B7 829 0107 10','C4 100 199 0085/HDMY','A1 RU985462','C9 00726011','A8 419 291','A3 TRU 07.31.161','A2 JBU602','C4 07.31.278','A1 27069 FE','A1 27071 FE','A1 32541 FE','A1 32542 FE','A1 39228 FE','A2 30 92 7069','A2 30 92 7071','A2 32 93 2541','A2 32 93 2542','A3 RED 6-SB25','A5 159169','A5 205874','A5 66386','A5 66387','A8 430 361','A8 430 362','A8 440 250','A8 440 251','A8 457 217','A9 30 92 7069','A9 30 92 7071','A9 32 93 2541','A9 32 93 2542','B1 FEB27069','B1 FEB27071','B1 FEB32541','B1 FEB32542','B1 FEB39228','C4 27069F','C4 27071F','C4 32541F','C4 32542F','C4 39228F','C9 FE27069','C9 FE27071','C9 FE32541','C9 FE32542','C9 FE39228')) and (keszlet>0) and (cikk_tecdoc.cikkszam is not null)) #