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