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 05P868','A3 ROA 2139110','C4 2355402TX','A1 13.0470-2820.2','B1 BOS0986494516','A8 217 810','A5 165392','A2 BD S030','B1 ABS36623/1','C9 0986424751','A2 23823 172 15','C9 QP8041C','A8 239 355','A1 0986494923','A9 BP85020','C4 07.35.105','C9 19-2060','A3 FER FDB1770','A2 GDB1330DTE','C4 FDB4260','A3 CIF 822-100-1','B7 1163706310/JP','A2 RH 2263.74','A9 GDB823DTE','A9 T 2355481','B1 TOM1522','B1 VKA66980001501','C4 0986495226','A1 GDB823','B1 VAI10-8174-1','B1 ATE13.0470-2860','A2 RH 8263.03','A2 RH 2263.10','B7 23554.150.1','B1 ATE13.0460-2886','A2 05P868','A9 RH 2263.50','B1 BLPADV184206','A9 GDB1415','A9 0986424751','A9 RH 2263.00','A3 DLP LP1556','C4 20961.152.1','C4 602820','C4 602864','A8 236 938','C9 19-0430','C9 GDB1415','A3 TRU 07.35.105','A2 0986495231','B1 ZIM20961.950.1','E3 23554.150.1','A9 05P294','B1 ABS37214','A3 BOS 0986494514','A9 66980001601','A3 DLP LP565','B1 LUCGDB823','A1 GDB1121','A1 P68024','C9 VAL301180','A8 200 286','B1 CIF822-100-2','A3 VAC V10-8178-1','A3 TRW GDB1415','A2 13.04602820.2','C9 PF0348','C4 GDB1415','B1 LUCGDB1330DTE','C9 0252355417/W','C4 602886','A1 573065JC JRD','C4 LP2255','A3 DLP LP2255','A1 GDB1330','C9 13.0460-2820.2','A2 FE FSL1083','C9 QP8078','A1 0986461769','B1 BREP85066','C9 VAL301674','A1 FSL1481','A1 GDB1813','A2 T 2355406','B1 KAMJQ1011082','C9 13.0460-2860.2','E1 30 91 6488','C9 FDB1788','B1 ATE13.0470-2886','A1 FSL1083','C6 018242','B1 BOS0986494923','C9 2355482','C4 GDB1416','A3 BOS 0986461769','C9 PP-0901AF','A2 13.04602864.2','A8 230 478','A1 FDB1770','A2 FE FDB1083','A9 BP68024','C6 019532','A2 LP571','B7 05P634/SUZ','A5 113386','A5 179569','A3 FER FDB1788','A2 0986461769','B1 TOM1078','A9 13.04602894.2','C9 13.0470-2894.2','A2 13.04602819.2','A2 RH 2263.00','A9 GDB1330','A2 13.04602984.2','A9 GDB823','B1 ATE13.0470-2623','C9 QP7107','B1 ZIM23554.150.1','A1 13.0460-2753.2','A9 13.04602787.2','C4 LP571','A3 TEX 2382301','C4 LD2820','A3 FER FDB4178','A1 13.0470-2894.2','A1 GDB1973','A9 13.04602820.2','C9 19-0429','A1 0986494399','A2 13.04702820.2','A1 13.0460-2864.2','A2 23554 152 14','A3 FER FDB4222','A9 GDB1330DTE','A3 FER FDB1491','C4 FDB4178','A3 BOS 0986494516','A9 13.04602984.2','A9 ABS36623','A3 VAC V10-8178','A5 206748','A9 GDB1328','A2 13.04702894.2','B1 ATE13.0470-2740','A2 13.04602860.2','A9 13.04702845.2','A5 342235','B1 ZIM20961.172.1','A9 FE FDB4260','C4 FSL1481','B1 VAI10-8168','A2 BP85020','A1 WBP182','A1 LP565','A1 0986495231','A1 13.0460-2787.2','A2 RH 2263.03','A1 WBP272','C6 000666','B7 20961.152.1','A8 233 944','A1 13.0470-2740.2','A2 RH 8263.01','B7 1163705410/JP','A3 VAC V10-8168','A8 230 153','A5 206750','B1 ATE13.0460-2819','C9 13.0460-2775.2','C4 LD2894','B7 0263.01/REM','A2 LP2254','C4 602894','A1 13.0460-2894.2','C9 PF0131','C9 PP-0018AF','A2 23554 172 14','B1 VAL301674','C9 13.0460-2819.2','A2 FE FDB1770','C9 0986494621','C4 602845','C9 0986461769','A2 BP85066','A1 WBP562','B1 KAMJQ1011083','C9 13.0470-2740.2','B1 BOS0986494399','A9 13.04702886.2','C9 VAL598674','C9 23823-17,2','A2 0986424751','A5 17709','B7 B110041/DKM','A1 LP2255','B7 SP 113','A5 206677','C4 GDB1330','B1 BOS0986494514','A3 VAC V10-8168-1','A1 573032JC JRD','B1 VKA66981408701','A2 FE FDB4004','A2 GDB1504','A2 ABS36623','B7 B110852/DKM','A2 13.04602753.2','B7 0263.16/REM','C9 0986494516','A1 GDB1311','A2 RH 2263.16','A9 13.04602845.2','A1 LP1815','A3 BOS 0986424751','A1 WBP350','C4 KRO823','C9 VAL301681','A9 13.04702820.2','A5 341384','A2 LP1815','A5 206681','C9 FDB1083','A1 P85020','B1 BOS0986494596','B1 LUCGDB1328','B1 ATE13.0460-2787','C4 FDB1788','A9 FE FDB1788','A1 13.0460-2845.2','A2 FE FDB4222','A2 13.04702886.2','C4 LP1556','A1 2355406 TEX','C4 GDB823DTE','B7 0263.03/REM','A8 241 413','A9 13.04602886.2','A1 0986424751','C9 13.0470-2860.2','B7 B110860/DKM','A9 GDB1416','B1 ABS36623','B1 VAI10-8178-1','C9 GDB1330DTE','A1 GDB823DTE','A9 RH 2263.16','C1 RH 2263.41','B1 ZIM23554.170.1','A9 FE FDB1083','C9 VAL598474','C9 0252096117/PD','A1 0986495226','A1 13.0460-2886.2','A5 206766','C4 FDB1083W','A5 386818','A5 386533','C4 602775','B7 0263.74/REM','C9 23823 10 704 10','A1 598180','C4 GDB1973','A2 0986494387','A1 GDB1439','C9 GDB1330','A2 GDB823','A2 GDB1328','C4 FDB1491','A1 GDB1504','B1 ATE13.0470-2787','A9 13.04602864.2','A2 T 2355481','A1 FDB1645','B1 ATE13.0460-2894','C9 13.0460-2845.2','A5 138171','A3 ROA 226341','C9 23554-15,2','A9 GDB1504','D2 8671016188','C9 2355406','A2 13.04602845.2','A9 FE FDB1491','B1 ATE13.0460-2740','A8 220 133','A1 0986494387','C4 2355406TX','B1 TOM1624','B1 ZIM20961.152.1','B1 LUCGDB1504','C4 GDB1330DTE','A9 RH 2263.41','A1 571906D JRD','C9 13.0460-2753.2','A5 206852','B7 20961.160.1','B1 LUCGDB1415','C4 20961.160.1','C9 PF0444','C9 0986494596','A1 GDB1330DTE','B7 0263.14/REM','A2 13.04702740.2','A2 GDB1330','C4 LP2254','A1 FDB4178','A9 05P868','A1 P85066','A3 TEX 2355481','A1 2355401 TEX','B1 CIF822-100-5','C9 13.0460-2864.2','B1 LUCGDB823DTE','A1 598674','C9 VAL598180','A5 150151','B1 BOS0986424751','B7 B110046/DKM','B1 ATE13.0460-2775','A9 13.04602819.2','A9 23554 152 14','A2 GDB1813','A2 13.04602894.2','C4 20961.172.1','A2 13.04602886.2','C9 0986494399','C4 0986461769','A8 222 055','A3 BOS 0986494399','C4 0986494514','A1 WBP1182','A9 FE FDB4178','A1 573005JC JRD','C4 KRO1330','B1 BOS0986494600','A8 234 129','B7 23554.170.3','A2 RH 2263.05','B7 0263.41/REM','A3 ROA 226305','A5 77455','A2 RH 2263.41','B1 ATE13.0460-2864','A8 236 860','C9 23554-17,2','A1 GDB1267','C9 13.0460-2740.2','A3 VAC V10-8174-1','A3 DLP LP2254','A8 236 862','C4 23554.170.1','B1 LUCGDB1973','B1 ATE13.0470-2845','B1 KAMJQ1012166','C9 13.0460-2894.2','A9 0986494387','A9 05P634','A3 BOS 0986495226','A1 13.0470-2860.2','B1 VAI10-8178','A3 ROA 226300','A3 TRW GDB823','B1 LUCGDB1813','C9 2382301','B1 ATE13.0470-2894','B1 ATE13.0470-2820','A2 GDB823DTE','C9 0986494387','A9 23554 172 14','B1 KAMJQ1013576','A1 13.0460-2775.2','A1 FDB1491','A8 205 625','A9 T 2355406','C9 PF0144','A3 ROA 226301','C4 GDB1328','C9 QP7107C','A2 FE FDB4260','A5 50426','B1 VAL301180','B1 BOS0986494621','A1 13.0460-2860.2','B7 23554.170.1','C9 13.0470-2623.2','C4 2382301TX','B1 CIF822-100-0','B1 BOS0986494598','C4 GDB823','C9 13.0470-2820.2','A9 0986494399','C9 0986494598','C9 QP8538C','B1 BREP85020','A2 13.04602740.2','C9 VAL301463','E3 20961.172.1','A1 0986494600','C9 13.0460-2886.2','C9 GDB823','C9 0252355417/PD','A1 0986495239','A2 05P634','B7 1163705310/JP','A2 GDB1415','A1 13.0460-2819.2','A1 598463','C4 0986494387','B1 BREP85020X','A9 RH 2263.74','C6 104442','C9 VAL872960','B7 1391.00/REM','A3 ROA 226374','B1 LUCGDB1330','A1 FDB1083-PROMO','A9 0986461769','A8 201 645','A3 ROA 226350','C9 VAL598463','A2 FE FDB1645','A3 ROA 2139100','A1 GDB1360','C9 19-0428','A1 GDB1196','B1 ATE13.0460-2820','C4 LP1815','A3 DLP LP571','C9 20961 00 704 00','C4 602819','C4 0986495239','B1 BREP68024','A1 WBP351','A1 0986494516','C9 BSS6625','A2 13.04702845.2','C9 23554-15,2 EPAD','A9 13.04702860.2','B1 VAL301474','C9 QP8078C','C9 GDB1813','A8 200 292','A3 TEX 2355482','A2 BP68024','A1 2382301 TEX','A8 230 114','A2 FE FDB1491','A1 P85020X','B1 ZIM20961.972.1','A1 FDB1788-PROMO','B1 ATE13.0460-2860','A9 GDB1973','C4 05P294','A1 GDB1415','A2 66980001601','C9 23554-17,2 EPAD','C9 GDB1328','A2 RH 8263.00','A1 598474','A9 13.04602740.2','C9 0252096115/PD','A9 RH 21391.00','C9 23554 10 704 10','B7 20961.172.1','C4 FDB1645','C9 2355402','A3 TEX 2355401','C4 05P634','C4 FDB1083','B7 0263.05/REM','A1 LP2254','B7 0263.00/REM','C9 0986494514','A2 13.04702860.2','B1 BOS0986461769','C9 0252391417/PD','A5 270841','C4 0986424751','A9 13.04602860.2','A2 GDB1416','A3 CIF 822-100-0','A9 13.04702894.2','A3 DLP LP1815','B1 BREP68024X','B1 VAL301681','A9 BP85066','C4 0986494399','C4 602740','C9 GDB823DTE','C9 13.0470-2886.2','A1 GDB1416','C9 QP8041','A1 13.0460-2820.2','C4 23554.170.3','A1 LP571','C4 FSL1083','C4 602787','A2 LP565','A2 RH 2263.50','A3 TEX 2355402','B1 VAI10-8177','C9 PF0442','C6 104432','A5 77328','A2 13.04602787.2','A8 254 312','B1 ATE13.0460-2984','B1 TOM1615','A1 FDB1788','A5 74906','A1 13.0470-2845.2','A1 13.0460-2984.2','B1 KAMJQ1012110','C9 PF0443','C9 0252096115','B1 VAI10-8168-1','B7 B110861/DKM','B7 05P294/SUZ','C4 GDB1813','A1 GDB1467','A2 FE FDB4178','A3 BOS 0986494387','B1 KAMJQ202007','A5 289249','A2 LP1556','A1 571906JC JRD','A3 TEX 2355406','C4 KRO1415','C9 13.0460-2787.2','B1 CIF822-100-1','A8 236 936','A1 FDB1083','A5 275177','C9 GDB1504','A1 LP1556','B1 VAL301463','B1 TRU07.35.105','A8 230 238','A8 238 970','C9 VAL301474','C4 602984','D1 BP ADV184206','B1 TOM10781','A1 WBP275','C9 2355401','A1 2355402 TEX','B1 BOS0986494387','A9 13.04702740.2','A1 FDB4260','A9 13.04602775.2','A8 230 196','A3 VAC V10-8177','C4 LD2845','A3 FER FDB1645','A8 234 054','C4 LP565','A8 219 787','A9 13.04602753.2','C9 QP8538','A3 FER FDB1083','A1 GDB1372','C9 0986494600','A1 13.0470-2886.2','A2 23554.170.1','A2 13.04602775.2','A5 172832','C9 ADV184206','A3 TEX 2096110','A2 GDB1973','C9 0252096117','A2 0986495239','A1 0986494514','A1 13.0460-2740.2','B1 ZIM23554.170.3','A1 GDB1328','A3 ROA 226303','A9 GDB1813','C9 0252391417','A2 0986494399','A2 RH 21391.00','A1 WBP271','C9 23554-16,2','C9 GDB1416','A3 FER FDB4260','C4 2355401TX','B1 ATE13.0460-2753','A5 42596','A2 05P294','B1 LUCGDB1416','A2 FE FDB1788','A2 RH 2263.01','A1 GDB2040','B1 ABS37334','A3 ROA 226310','B7 0263.50/REM','C9 20961-17,4 1 4','A2 LP2255','B1 ATE13.0460-2845','C9 13.0460-2984.2','C9 0986494923','C9 20961 10 704 00','C9 13.0470-2845.2','C9 GDB1973','B1 ZIM20961.160.1','A3 ROA 226316','C4 LD2886','C4 GDB1504','A3 JAP PA-0312AF','C9 PP-0903AF')) and (keszlet>0) and (cikk_tecdoc.cikkszam is not null)) #