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