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 16488 FE','B7 1163706310/JP','C9 FE16406','A1 GDB1578','B1 FEB16406','C9 20961 10 704 00','C4 LP2254','C9 VAL598463','A1 FDB4178','A8 254 312','A1 16406 FE','A9 13.04602820.2','A2 FE FDB1788','A9 13.04602775.2','B7 0263.00/REM','A1 WBP275','A2 13.04602823.2','A1 16344 FE','A1 GDB1330DTE','A3 VAC V10-8168','A9 GDB1416','A1 0986494516','A9 T 2355481','C9 GDB1578','A1 GDB1055','B1 CIF822-100-5','C9 13.0470-2894.2','A9 FE FDB1637','A1 16052 FE','A9 FE FDB1788','A3 FER FDB4178','A8 205 625','A9 0986494399','C4 602984','A5 206766','B1 BOS0986494518','A3 DLP LP2254','A2 GDB1578','B1 FEB116216','A3 BOS 0986494516','C9 0252096117','A2 FE FSL1083','A2 13.04602819.2','A9 GDB1578','A1 GDB1458','C4 KRO1330','B7 B110860/DKM','A8 234 129','C4 GDB1328','B7 0263.03/REM','A2 LP2254','A2 GDB1330','A9 GDB1813','A8 230 114','A3 FER FDB1083','B1 VAI10-8174-1','B1 ATE13.0460-2740','A1 GDB1504','A9 RH 2263.00','A2 05P634','C9 GDB1330','A9 BP85020','A5 42596','B1 ATE13.0470-2740','A1 13.0470-2894.2','A8 230 478','C4 GDB1330DTE','C4 16344F','B1 BLPADV184206','A2 0986494518','B1 VAI10-0766','A1 13.0460-2819.2','B1 CIF822-100-1','A9 13.04602787.2','A2 RH 2263.03','A1 P61088','A2 RH 2263.05','A2 13.04602740.2','A1 FQT1083','A3 TEX 2355481','D2 8671016188','A2 FE FDB4004','A3 ROA 226304','A8 234 054','A3 FER FDB4260','A8 230 196','A1 13.0460-2787.2','A9 FE FDB4260','A9 05P868','B1 BOS0986461769','A1 FDB1788-PROMO','C4 LD2894','C4 0986494514','C9 13.0470-2740.2','B1 ATE13.0460-2820','A9 GDB1504','A5 165392','B1 BOS0986494923','A3 FER FDB4222','A2 FE FDB4178','A9 FE FDB1083','B7 0263.14/REM','A1 0986461769','C4 602740','B1 TOM1624','C9 0986494923','A3 FER FDB1788','A3 CIF 822-100-1','A2 BP61088','A1 FQT1788','A1 GDB1311','A2 13.04702823.2','C9 PP-0901AF','C4 602787','C4 GDB1578','A3 VAC V10-8178-1','A1 P85020','A3 ROA 226387','A1 0986494514','A2 23554.170.1','A9 05P634','A1 GDB1328','A2 0986461769','A2 0986495231','B7 23554.170.1','C4 05P868','C9 13.0460-2787.2','B1 VAI10-8168','C9 13.0460-2984.2','C9 VAL598242','B1 LUCGDB1328','C9 0986494399','A1 0986494923','A2 RH 2263.14','C4 23554.170.3','B1 ATE13.0460-2775','A1 GDB1267','A3 ROA 226392','B1 ATE13.0470-2894','B1 FEB16344','A2 GDB1416','A1 FDB1083-PROMO','A2 13.04602775.2','A3 VAC V10-8178','B1 ATE13.0470-2787','A2 FE FDB1083','A3 ROA 226350','B7 0263.05/REM','A9 13.04702894.2','A1 598463','A3 BOS 0986494399','A1 571906D JRD','C9 GDB823DTE','B1 CIF822-100-2','A5 17709','C4 602819','C4 LD2820','A5 138171','A9 GDB1330DTE','A1 0986495231','A1 FDB1788','A1 FDB1637','B1 ZIM20961.972.1','B7 05P634/SUZ','A8 236 938','A5 206750','A1 WBP272','A2 GDB1813','A9 GDB1330','A1 13.0470-2740.2','A2 FE FDB4222','A3 ROA 226314','A1 GDB1330','B1 LUCGDB1578','C9 ADV184206','B1 BOS0986494596','A1 13.0460-2823.2','A9 GDB823DTE','B1 LUCGDB1330','A2 GDB1328','A5 289249','C9 19-0428','C4 602823','C4 LP565','A2 13.04602984.2','C9 0986494596','A1 598474','A1 13.0460-2984.2','E1 30 91 6540','B1 ATE13.0460-2984','A1 13.0460-2775.2','A3 BOS 0986461769','A2 BP85020','B1 LUCGDB1813','C4 0986461769','C4 0986494399','C4 FDB1788','B7 23554.170.3','C9 23554-17,2 1 4','A1 16342 FE','A1 GDB1813','C9 0986494514','A2 FE FDB1637','A1 573005JC JRD','A1 GDB823DTE','C9 GDB1328','A1 LP2254','A9 13.04602894.2','A5 206677','B1 LUCGDB1504','C4 GDB1504','A9 13.04702820.2','A5 150151','C4 FDB1083W','A8 241 413','B1 BOS0986494516','C9 13.0470-2820.2','C9 FDB1083','C4 GDB823DTE','B1 TOM10781','A2 GDB1504','B1 ATE13.0470-2823','A2 13.04602894.2','A5 74906','A9 RH 2263.50','A1 WBP350','A2 RH 2263.01','A2 13.04702894.2','C9 13.0460-2823.2','B7 0263.16/REM','A2 GDB823DTE','A2 T 2355481','A2 0986494399','A9 GDB1328','A3 BOS 0986494514','B1 LUCGDB1416','A8 258 535','B1 ATE13.0470-2820','C4 FDS1083','B1 TOM10782','C4 FDB4260','C9 GDB1416','C4 GDB1416','B1 VAI10-8178','B1 BOS0986494514','B1 FEB16404','B1 BOS0986494399','B1 BREP61088','A1 16457 FE','B1 FEB16488','B7 0263.06/REM','A1 GDB1416','A2 FE FDB4260','A2 LP565','A3 ROA 226305','A1 FDB1083','C4 FDB4178','A1 FSL1083','E3 20961.172.1','B1 CIF822-938-1','B7 B110041/DKM','A1 13.0460-2740.2','A8 217 810','A3 ROA 226317','B1 ZIM20961.172.1','B1 FEB16457','C4 20961.172.1','C4 GDB1330','A3 DLP LP565','A5 206748','A1 GDB2040','A9 0986461769','A2 13.04602820.2','B1 ATE13.0460-2819','B1 ATE13.0460-2823','C9 GDB1504','C9 0986494516','A1 0986494399','C9 13.0460-2820.2','B1 ATE13.0460-2894','C9 PP-0903AF','A2 13.04702740.2','C9 0986494621','C9 13.0460-2740.2','C4 FDB1083','B1 BREP85020','A9 RH 2263.16','B1 TOM1522','A3 VAC V10-8174-1','A2 13.04702820.2','B1 ABS35351','A1 GDB1372','A1 13.0470-2820.2','A5 386533','A3 ROA 226300','C4 602894','A2 GDB1330DTE','A3 ROA 226316','C9 GDB1813','C9 VAL301463','C9 0986494518','A5 172832','A3 VAC V10-0766','C9 VAL598474','A2 05P868','A3 ROA 226303','A1 573032JC JRD','A3 BOS 0986494518','C9 23554-17,2 EPAD','C4 16052F','A3 FER FDB1637','C9 VAL872960','C9 13.0460-2775.2','B7 0263.01/REM','C9 GDB1330DTE','A2 RH 2263.00','A5 113386','B1 FEB16052','C9 FDB1788','A1 LP565','B1 BOS0986494621','C4 16488F','A2 RH 2263.16','C4 23554.170.1','C4 602820','A1 116216 FE','A9 FE FDB4178','A8 236 862','C9 PP-0018AF','D1 BP ADV184206','C4 602775','A2 RH 2263.50','B7 0263.50/REM','B1 LUCGDB1330DTE','C4 05P634','B1 VAI10-8178-1','B1 ATE13.0460-2787','B7 20961.172.1','A9 13.04602819.2','A8 200 292','A1 0986494518','A9 13.04602984.2','A1 GDB1467','C4 GDB1813','A5 77328','A1 13.0460-2820.2','A1 13.0470-2823.2','A1 GDB1196','C9 13.0460-2819.2','A1 FDB4260','A1 16404 FE','A1 13.0460-2894.2','A1 571906JC JRD','C9 13.0460-2894.2','A9 13.04702740.2','B1 LUCGDB823DTE','A3 ROA 226301','B1 ZIM23554.170.3','B1 ZIM23554.170.1','A9 13.04602740.2','B1 VAL301463','C4 FSL1083','C9 0986461769','A2 13.04602787.2','A1 GDB1415','A1 GDB1973','A1 GDB823','A1 P85020X','A1 WBP562','A2 GDB1415','A2 GDB1973','A2 GDB823','A2 Q109-1606','A2 RH 2263.10','A2 RH 2263.41','A2 RH 2263.74','A3 QUI 109-1685','A3 ROA 226310','A3 ROA 226341','A3 ROA 226374','A5 270841','A5 386818','A8 220 133','A8 230 153','A8 230 238','A9 GDB1415','A9 GDB1973','A9 GDB823','A9 Q109-1606','A9 Q109-1685','A9 RH 2263.41','A9 RH 2263.74','B1 ABS36623/1','B1 BLPADR164201','B1 BREP85020X','B1 FEB16146','B1 KAMJQ1012166','B1 KAMJQ1013576','B1 LUCGDB1415','B1 LUCGDB1973','B1 LUCGDB823','B1 QB109-1606','B1 QB109-1685','B1 VAL301180','B1 VAL301474','B7 0263.10/REM','B7 0263.41/REM','B7 0263.74/REM','C4 16146F','C4 GDB1415','C4 GDB1973','C4 GDB823','C4 KRO1415','C4 KRO823','C9 0252096115/PD','C9 0252096117/PD','C9 GDB1415','C9 GDB1973','C9 GDB823','C9 QB109-1606','C9 QB109-1685','D1 BP ADR164201')) and (keszlet>0) and (cikk_tecdoc.cikkszam is not null)) #