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