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-6701','C9 00727732','A8 461 074','C9 00726011','B1 BORB11352','C4 VKDS 331009','C9 829029810','B1 VKA44070086001','C9 985462','A3 VAC V10-6272','B1 VKA44071723301','A2 S863637','B7 00721398/IP','B1 VKAK41483501','B1 ABS270582','C4 VKDS 331037','A1 WRM305','C9 111020586','A9 AK.17422','A2 12.27.741','C9 2256002','A1 TD523W','A1 829 0108 10','B1 BORB19204','B1 ABS270841','C9 985461','A3 COR 80001202','A1 829 0298 10','B1 KAM8800003','B7 D300081/DKM','A8 454 407','A9 40.16.742','C6 007661','A8 422 943','C9 B11352','B7 T404691/STC','A8 454 452','A1 863637 SID','C9 00721398','A2 S857607','B1 KAM8800108','B1 MOZL29857','A2 12.27.740','C9 6Q0407183/MG','B1 KAM8800161','B7 52004508/MTZ','C9 2256001','B7 985462','C4 850029876T','B7 T405342/STC','A8 421 605','B7 00726011/IP','C4 SE-SB-0104','C4 TD410W','A9 JBU602','A9 AK.177851','B1 FAG829029810','A2 AK.17422','C4 07.31.278','A8 461 071','B1 VKA44070027801','C6 101435','A2 TD522W','B1 VAI10-1680','A1 829 0318 10','C4 829029810','B1 MOZL29876','C9 5104757','B1 TRWJBU602','A5 194113','B7 T404862/STC','A8 461 070','A4 109 663 755','B1 HP111 020','A1 RU988200','C4 DSS1039DY','C4 109663HP','C9 2256007','A1 JBU602','C4 DSS1037DY','C4 100 610 0027/HDMY','A1 863632 SID','C4 VKDS 331004','A3 NKS 5104757PRO','C6 108596','B1 BORB11353','A2 40.16.742','C6 013417','A8 473 474','C4 DSS1040DY','C6 020312','A3 MON L29887','C6 014878','B1 BORB11351','A3 TRU 07.31.181','C6 014315','A8 421 583','B7 D300027/DKM','A2 AK.17772','B1 BORB12230','B7 1117900780/JP','B1 VKA44070384401','B1 MOZL29861','B7 985461','C9 829031810','A2 AK.177851','A2 JBU602','B1 SAS2256002','B1 HUT590021','B1 GSP510332','B7 00727181/IP','A9 12.27.740','C6 007557','B1 VKA44071707401','C6 014877','C6 106104','B1 TEDTED42843','B1 FAG829057810','C9 B19204','A8 457 480','B1 KAM8800004','A1 F8-6428','A9 S863632','C4 TD522W','C4 100 610 0043MY','A9 42.79.741','B1 VKA41990305801','C9 MGZ-501016','A3 MOG SE-SB-0104','A3 RUV 985461','C9 MGZ-501002','C4 VKDS 331005','B1 VKA44071707601','A3 DLP TD410W','A8 452 278','C4 07.31.161','A8 447 610','B1 VKA44070087001','B7 988200','A4 100 610 0027/HD','B1 TED00726011','A5 433061','B1 VKA41990746501','C6 020716','C6 014101','A8 419 291','B1 GSP510333','B1 KAM2120093','C6 017046','A3 DLP TD522W','B7 D300079/DKM','A9 AK.17786','B7 00726013/IP','C9 00727181','A5 191549','A3 TRU 07.31.161','B1 VKA44071707501','B1 GSP510356','C6 007660','B7 T404863/STC','C6 101918','E2 111 084 755','C9 2256003','B7 TED42843/IP','B1 KAM2120129','A1 RU985462','B1 COR80001202','C9 TED42843','C6 108595','C9 00727745','B7 510333/GSP','C9 80001202','A1 RU985461','B7 1117900770/JP','C9 5104302PRO','C4 TD523W','C9 111021586','A1 TD522W','A9 12.27.741','C4 52004508','A1 RU987805','A8 454 453','A2 TD410W','C9 00726013','C6 000392','C9 B11351','A3 DLP TD523W','A3 TRU 07.31.160','C6 101434','A3 MEY 1006100027/HD','C9 FSTVWAB-GVRH','E2 111 021 755','C6 106105','B1 MOZL29887','A1 F8-6425','C9 B11353','C9 988200','B1 VKA44071707701','C4 JBU602','A2 S863632','B1 VKAK41483801','A3 NKS 5104302PRO','C6 014324','C6 014314','A3 HUT 590021','A3 VAC V10-1680','C9 FSTVWAB-GVLH','E3 SB489','B1 TED00721398','A1 SE-SB-0104','A9 30 93 1253','C6 013418','A3 RUV 985462','C6 020720','A1 857607 SID','A8 042 204','E2 109 663 755','A9 TD410W','C9 1006100043','B1 FAG829010710','B7 1140200300/JP','C4 07.31.160','B1 FAG829031810','A1 WRM276','A2 30 93 1253','C4 07.31.277','E2 111 020 755','A2 42.79.741','B7 829 0298 10','B1 VKA41990305701','C9 1006100027/HD','C9 5104757PRO','C9 MGZ-501001','B1 FAG829010810','B1 SAS2256001','B7 510334/GSP','B1 GSP510334','A3 NKS 5104757','A1 829 0107 10','B1 RTS017.05995','B1 FAG829057910','C4 DSS1013DY','A8 454 454','A1 F8-6736','B7 829 0318 10','C9 112463755','C4 850029877T','B1 ABS271126','B1 TED00726013','A2 AK.17786','B7 00727732/IP','B7 987805','B1 VKA44071723401','A9 S863637','A9 S857607','C9 829010710','C9 829010810','B7 829 0107 10','A1 TD410W','B7 1117900600/JP','B1 HP109 663','C9 FSTVWAB-009','C9 00727175','A3 NKS 5104302','C6 102660','B1 TRU07.31.160','C9 FSTVWAB-GVX','B7 D300080/DKM','C9 B12230','A1 F8-6424','C9 5104302','A5 353877','B1 TRU07.31.161','B1 SAS2256003','A1 WRM274','A9 AK.17772','B7 829 0108 10','B1 VAI10-6272','B1 RTS017.90929','B1 ABS270581','A1 JBU690','A1 JBU691','A1 VO-SB-0430','A1 VO-SB-2337','A2 JBU690','A2 JBU691','A3 NKS 5104737','A3 NKS 5104737PRO','A3 NKS 5104738','A3 VAC V10-0707','A5 104504','A5 104505','A5 143921','A5 143922','A5 352742','A5 352743','A5 353878','A9 JBU690','A9 JBU691','B1 TRWJBU690','B1 TRWJBU691','B1 VAI10-0707','B7 52005101/MTZ','B7 52071402/MTZ','B7 52071501/MTZ','B7 52072108/MTZ','C4 100 199 0085/HDMY','C4 100 199 0086/HDMY','C4 100 610 0014/HDMY','C4 100 610 0037/HDMY','C4 100 610 0041MY','C4 100 610 0042MY','C4 100 610 0044MY','C4 100 610 0046MY','C4 100 610 0062/HDMY','C4 100 610 0085/HDMY','C4 100 610 0086/HDMY','C4 52005002','C4 52005101','C4 52005308','C4 52071402','C4 52071501','C4 52072108','C4 850029861T','C4 JBU690','C4 JBU691','C4 V10-0707','C4 VO-SB-0430','C4 VO-SB-2337','C9 1001990085/HD','C9 1001990086/HD','C9 1006100014/HD','C9 1006100037/HD','C9 1006100041','C9 1006100042','C9 1006100044','C9 1006100046','C9 1006100062/HD','C9 1006100085/HD','C9 1006100086/HD','C9 5104737','C9 5104738')) and (keszlet>0) and (cikk_tecdoc.cikkszam is not null)) #