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