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