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 ('A9 13.04702740.2','A1 FDB4183','A8 201 645','C9 VAL301463','B1 BOS0986424813','A2 GDB1330DTE','A1 LP2254','A9 0986494400','B7 05P294/SUZ','A1 FDB1788','A3 FER FDB4260','A3 BOS 0986494517','B1 ABS36623','C4 FDS1083','A9 13.04602775.2','A9 13.04602845.2','B1 FEB16834','C9 VAL598180','C9 13.0470-2886.2','B7 0263.74/REM','C4 602775','C4 16344F','B1 ATE13.0470-2740','B1 FEB16148','A2 LP2254','C4 16488F','A2 13.04602984.2','B1 FEB16344','A2 T 2355481','A9 13.04602894.2','A1 2355406 TEX','A3 DLP LP571','A9 23554 172 14','A3 BOS 0986494387','C9 13.0470-2740.2','C4 16476F','A1 WBP350','B7 23554.170.3','A1 FDB1491','C9 23554-16,2','C4 0986494387','C9 0986494514','A1 0986424813','A2 FE FSL1083','A1 0986461769','C4 602787','C9 13.0460-2819.2','A9 T 2355481','A3 FER FDB4178','A2 13.04602845.2','B1 FEB16052','B7 20961.160.1','A1 16527 FE','C9 223947','B7 0263.05/REM','A3 VAC V10-8177','B1 ZIM23554.170.3','A1 FDB1770','A2 0986424751','B1 FEB16406','A1 FQT1788','A3 TEX 2355406','A3 BOS 0986494516','B1 BOS0986494657','A5 206766','C9 0986494517','A2 13.04602823.2','C4 0986495239','C4 602823','A1 FDB4260','A2 23554 152 14','B1 BOS0986461769','C4 0986494434','A2 13.04702894.2','C9 0986494399','C9 13.0460-2820.2','A1 16146 FE','A9 0986461769','A9 ABS36623','A2 05P349','A9 0986466683','E1 30 91 6346','A1 2355402 TEX','A1 0986494600','C9 13.0460-2823.2','B1 BREP68024','A1 16834 FE','C9 23554-17,2 EPAD','A9 0986424813','B1 LUCGDB1330DTE','C9 0986461769','A1 0986424751','A1 13.0460-2787.2','B1 ATE13.0470-2894','B1 BOS0986494621','A2 13.04702886.2','B1 BOS0986494600','B1 ZIM20961.160.1','C4 LP2254','A1 16476 FE','A1 13.0460-2864.2','B7 0263.10/REM','A8 200 286','A3 BOS 0986494400','A5 179569','C4 602864','A9 0986494387','A1 0986494516','C9 23554-15,2','A3 FER FDB1788','A3 BOS 0986461769','A2 13.04602864.2','C9 13.0470-2894.2','A5 172832','A5 206748','B1 BOS0986494434','C4 FDB1788','A2 13.04702845.2','C4 23554.170.3','A1 2382301 TEX','A5 206677','A5 206750','A2 13.04702740.2','C9 0986424751','A9 13.04602820.2','A1 P61088','A1 13.0470-2740.2','C9 0986494598','B1 BOS0986494399','A8 233 944','A2 RH 8263.01','A2 LP2255','C4 07.35.105','C9 0986424813','C4 2355406TX','A2 T 2355406','E1 30 91 6344','B1 ATE13.0470-2886','A3 BOS 0986424813','A8 236 938','A1 16406 FE','A8 238 970','A9 13.04602819.2','A8 254 312','A1 0986466683','A9 0986494434','A9 13.04602886.2','C4 602894','B1 ATE13.0460-2740','C9 GDB1330DTE','A1 0986494514','A1 P85020','B7 0263.03/REM','A1 16346 FE','C9 0986494434','C9 0986494621','A2 13.04602753.2','A9 13.04702894.2','A1 F026000142','A3 BOS 0986494514','A1 13.0470-2823.2','A5 206681','A5 275177','A1 LP571','C4 2355402TX','A9 05P294','C9 VAL598752','A3 BOS 0986466683','C4 2355401TX','A1 0986494387','C4 2382301TX','B1 ATE13.0460-2820','A8 258 535','A5 206852','A1 WBP271','C4 16146F','C4 602886','C9 0986494600','B1 ATE13.0460-2823','B1 ATE13.0460-2775','C9 20961-17,4 1 4','C4 LP2255','B1 FEB16346','B1 ZIM23554.170.1','A1 WBP999','A2 LP571','A3 BOS 0986424751','A2 13.04702823.2','B1 ATE13.0460-2819','C9 2382301','A8 217 810','D1 BP ADV184206','C9 13.0470-2845.2','A9 FE FDB4183','A2 FE FDB4178','A9 13.04602740.2','C9 VAL598474','C9 0986494657','E1 32 91 6052','A8 228 705','A2 13.04602787.2','A1 WBP275','A1 16332 FE','A2 13.04602740.2','A1 13.0460-2819.2','A1 FSL1083','A2 13.04602894.2','A1 GDB1330DTE','C4 05P634','A3 DLP LP1824','E1 30 91 6404','A1 0986494399','A1 571906JC JRD','A3 FER FDB1770','C9 2355402','B1 BOS0986494521','B7 SP 113','C9 13.0460-2775.2','B7 0263.01/REM','B1 ATE13.0470-2845','E1 30 91 6148','C4 602845','B1 ATE13.0460-2753','A8 236 862','E1 30 91 6457','A3 TRU 07.35.105','A1 FDB1788-PROMO','C9 0252096117/PD','B1 BOS0986466683','C4 FDB1491','A8 236 863','C9 0986466683','B7 1391.00/REM','A2 13.04602886.2','A2 FE FDB1770','B1 VAI10-8177','C4 FDB4178','C9 13.0460-2886.2','A1 P68024','A9 0986424751','C4 05P294','A2 0986494517','A2 23554.170.1','A1 16342 FE','B1 VAI10-8168','C4 602984','C9 13.0460-2864.2','A1 0986494521','C4 0986424813','A1 573032JC JRD','A1 WBP1182','A8 219 787','A2 RH 8263.03','A2 FE FDB4260','A5 289249','A3 FER FDB1491','C9 ADV184206','A1 13.0470-2845.2','C9 FDB1083','C9 VAL301180','C9 0252096117','A3 DLP LP565','C4 23554.170.1','C9 2355401','C9 VAL598485','C4 LP1824','C4 GDB1330DTE','C9 0986494597','B1 FEB16476','C9 23554-17,2','C4 0986424751','A9 BP85020','B1 VAL301474','A2 0986495239','A3 TEX 2382301','A2 0986466683','A1 FQT1083','B1 ATE13.0460-2886','B1 ATE13.0460-2787','A3 BOS 0986494399','A1 16488 FE','C4 0986494399','A9 13.04602753.2','B1 ATE13.0470-2820','B1 BOS0986494596','C4 602819','C9 0252391417/PD','C4 LD2845','A1 13.0460-2775.2','A5 74906','D1 BP ADR164201','A1 0986494434','B1 ATE13.0460-2984','A2 FE FDB1083','A5 42596','A1 13.0470-2886.2','B1 BREP85020','A1 13.0460-2886.2','A2 0986494521','C9 0986494400','A8 222 055','B1 FEB16457','A2 13.04602775.2','A9 13.04702820.2','A1 0986494923','A1 FDB1083','E1 32 91 6406','A1 0986495239','A1 13.0460-2740.2','A3 TEX 2355482','A2 BP61088','C9 FE16148','A9 FE FDB1491','A2 FE FDB1788','A3 BOS 0986494434','A1 16404 FE','C4 LD2894','C9 0986494596','A5 138171','C4 FDB1083W','B1 BLPADR164201','A9 05P349','C9 13.0460-2845.2','A2 ABS36623','C9 13.0470-2820.2','A1 573005JC JRD','C9 13.0460-2787.2','A9 13.04602864.2','B1 FEB116026','C4 FDB4260','C9 VAL598463','A2 FE FDB4004','A1 GDB2040','A2 0986494434','A1 13.0460-2753.2','B1 BOS0986494387','A2 0986461769','A1 13.0460-2823.2','A9 13.04702845.2','B1 BOS0986424751','A8 236 860','A3 TEX 2096110','B1 BREP61088','A2 13.04602820.2','C4 05P868','A2 0986494399','A2 05P294','C9 13.0460-2753.2','A1 13.0460-2845.2','A1 FDB4178','B1 ATE13.0460-2894','A3 BOS 0986494521','E1 60 91 6527','B1 BOS0986494923','A1 16052 FE','C4 0986466683','A1 16344 FE','A3 VAC V10-8168','A2 BP85020','A1 598180','A2 23823 172 15','A1 598485','A1 F026000133','B7 23554.170.1','B1 BOS0986494400','B1 FEB16404','A1 WBP471','A8 236 949','A8 236 936','A2 LP1824','A9 13.04702886.2','A9 FE FDB1788','A8 200 292','A1 598463','C9 0986494923','A1 16148 FE','A5 17709','A9 FE FDB4260','A9 T 2355406','B1 FEB16488','A1 13.0460-2894.2','A1 0986494400','C9 0252391417','C4 FSL1083','C4 16148F','C9 VAL301474','A8 201 279','A1 13.0460-2984.2','C4 0986494514','A2 BP68024','A2 05P868','C9 0986494516','A3 TEX 2355401','B7 05P634/SUZ','C4 602740','A8 234 054','A3 TEX 2355481','A9 13.04602787.2','A2 FE FDB1491','C9 0986494521','A5 77455','C4 20961.160.1','A3 FER FDB4183','A1 13.0460-2820.2','A5 113386','B7 20961.172.1','C4 602820','C4 0986461769','B1 BLPADV184206','A8 239 355','A9 BP68024','A1 16457 FE','A1 LP1824','A3 DLP LP2255','C4 05P349','A1 598474','A1 16478 FE','C9 VAL598975','C9 2355482','C4 FDB4183','A3 TEX 2355402','A9 05P634','B1 ATE13.0460-2864','A1 LP565','A9 23554 152 14','C9 23554-15,2 EPAD','A9 13.04602984.2','C9 0986494387','A3 DLP LP2254','A1 116026 FE','A9 FE FDB4178','A2 05P634','B1 TRU07.35.105','A1 FDB1083-PROMO','A1 LP2255','A5 77328','B1 BOS0986494597','A1 0986494517','B1 VAL301463','E1 30 91 6488','B1 ATE13.0470-2823','B1 BOS0986494598','C9 13.0460-2984.2','C9 2355406','B7 0263.50/REM','A2 FE FDB4183','E3 20961.172.1','C4 LP571','A9 GDB1330DTE','A2 0986494387','A2 23554 172 14','C9 VAL872960','C9 23823-17,2','C4 LD2820','A2 13.04602819.2','C9 13.0460-2740.2','A1 571906D JRD','A2 LP565','A5 15945','B1 ZIM20961.172.1','A2 0986494400','B1 VAL301180','A1 13.0470-2820.2','C9 FE16406','A1 13.0470-2894.2','A1 2355401 TEX','B1 BOS0986494514','B1 FEB16332','B1 FEB16146','C4 LD2886','C9 FDB1788','A3 FER FDB1083','C4 LP565','A9 0986494399','A2 0986424813','C4 FDB1083','B1 BOS0986494516','A9 05P868','C4 16052F','A1 FQT1491','B1 BOS0986494517','B1 ATE13.0460-2845','C4 20961.172.1','A2 RH 8263.00','A2 13.04702820.2','C9 13.0460-2894.2','A9 FE FDB1083','A1 P85020X','A2 Q109-1211','A2 Q109-1749','A2 Q109-1827','A2 Q113-1301','A2 Q113-1302X','A2 RH 2263.03','A2 RH 2263.05','A3 CIF 822-100-1','A3 QUI 109-1211','A3 QUI 109-1749','A3 QUI 109-1827','A3 QUI 113-1301','A3 QUI 113-1302X','A3 ROA 226303','A3 ROA 226305','A8 206 982','A8 223 657','A9 Q109-1211','A9 Q109-1749','A9 Q109-1827','A9 Q113-1301','A9 Q113-1302X','B1 ABS36623/1','B1 ATE13.0470-2787','B1 BREP68024X','B1 BREP85020X','B1 CIF822-100-1','B1 KAMJQ1011082','B1 KAMJQ1012166','B1 KAMJQ1013576','B1 QB109-1211','B1 QB109-1749','B1 QB109-1827','B1 QB113-1302X','B7 B110041/DKM','C9 20961 10 704 00','C9 PP-0018AF','C9 QB109-1211','C9 QB109-1749','C9 QB109-1827','C9 QB113-1302X','C9 QP8078','C9 QP8078C')) and (keszlet>0) and (cikk_tecdoc.cikkszam is not null)) #