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 13.0460-2787.2','B7 0263.03/REM','A8 258 535','A5 77328','B1 LUCGDB1504','C9 0986424751','A3 CIF 822-100-1','A3 FER FDB4260','C4 FDB1083','A2 FE FDB4222','A8 230 478','A1 0986494518','A9 0986494399','B1 BOS0986424751','A2 13.04602820.2','B7 0263.00/REM','A8 241 413','A2 RH 2263.03','A2 RH 2263.05','A3 FER FDB4222','B1 ATE13.0460-2819','C4 0986494399','A1 GDB1458','A2 23554 172 14','A1 GDB2040','C9 0252096117','A9 FE FDB1083','A1 GDB1467','B7 23554.170.3','A2 RH 2263.16','A5 42596','A1 16052 FE','C4 LP571','A1 598474','A1 16406 FE','C9 13.0460-2775.2','C9 VAL598242','A1 0986461769','C4 LP565','C4 GDB1416','A1 13.0460-2820.2','A2 GDB1328','A9 RH 2263.00','A3 ROA 226301','A1 16342 FE','D1 BP ADV184206','C9 23554-17,2 1 4','C9 VAL301463','A1 116216 FE','B7 05P634/SUZ','A9 T 2355481','C9 FE16406','B7 0263.50/REM','A2 05P634','C9 PP-0901AF','A3 BOS 0986494514','A3 TEX 2355402','B7 0263.01/REM','A1 WBP350','A1 0986494516','A2 GDB1973','A2 FE FSL1083','C9 2355402','C9 0986494516','A8 230 114','A2 RH 2263.01','B1 BOS0986494514','B1 ZIM23554.170.1','A1 0986495231','A2 0986424751','C4 GDB1578','A3 DLP LP571','A2 LP571','A9 GDB1328','A2 GDB1504','A9 13.04602894.2','C4 602775','A5 165392','C4 0986424751','C9 13.0460-2787.2','A9 GDB1578','A9 0986424751','C4 GDB1330','A1 13.0460-2819.2','B7 0263.16/REM','A1 13.0460-2823.2','C4 LP2254','A2 GDB1578','A1 LP571','B7 20961.172.1','C9 0986494399','A8 236 862','A2 13.04602775.2','A2 FE FDB1083','A1 13.0460-2894.2','A3 BOS 0986494399','C9 VAL598474','C4 602819','A1 LP1713','A9 13.04602775.2','A2 LP565','A2 FE FDB4260','B1 BOS0986494596','A9 13.04602984.2','A1 GDB1055','C4 GDB1813','A3 FER FDB4178','A2 0986494518','A3 TEX 2096110','A5 270841','A1 GDB1504','A1 16344 FE','A2 13.04602823.2','B1 LUCGDB1813','A9 FE FDB4260','B1 BLPADV184206','B1 FEB116045','A1 573032JC JRD','C9 13.0460-2823.2','A8 222 055','C9 0986494518','A2 FE FDB1788','A5 150151','B1 FEB16834','A8 217 810','A8 200 292','A1 FDB1083-PROMO','C4 602984','A1 13.0460-2775.2','A2 FE FDB1637','A8 230 196','A9 GDB1330','B1 BOS0986494923','C9 13.0460-2819.2','A3 BOS 0986494516','A9 0986461769','C9 GDB1504','C4 20961.172.1','C9 23554-17,2 EPAD','A9 GDB1504','B1 LUCGDB1973','B7 23554.170.1','C4 23554.170.3','C9 0986494621','A2 RH 2263.50','A1 0986424751','A3 BOS 0986424751','A1 0986494514','A8 236 938','A1 GDB1328','C9 ADV184206','A1 116045 FE','C9 23554-17,2','C9 0986494514','A1 GDB1813','A1 598463','B1 ATE13.0460-2820','C9 0986494596','A8 219 787','C9 VAL872960','A3 ROA 226387','B7 0263.05/REM','B1 ATE13.0460-2984','C4 602740','A1 FDB4260','A2 0986461769','C9 20961-17,4 1 4','B1 VAL301463','A3 TEX 2355481','A1 GDB1196','A1 573005JC JRD','A3 ROA 226317','A2 23554.170.1','B1 BOS0986494516','A2 GDB1330','B1 LUCGDB1330','C4 602823','A3 ROA 226303','A2 0986494399','A1 FDB4178','C4 602787','A8 254 312','A1 571906JC JRD','A3 BOS 0986494518','A3 DLP LP565','C9 0986494923','C4 FDB4178','A5 138171','C9 FDB1083','B1 FEB16344','C9 PP-0903AF','B1 CIF822-100-5','C4 FDB4260','B1 CIF822-100-2','B1 FEB16457','A3 ROA 226314','C4 05P634','A1 GDB1267','B7 0263.14/REM','C4 0986461769','B1 FEB16052','A3 FER FDB1083','A1 2355402 TEX','B1 LUCGDB1416','A1 GDB1372','A2 13.04602984.2','A2 RH 2263.00','A1 16404 FE','A1 WBP272','A3 BOS 0986461769','A2 13.04602740.2','C9 19-0428','B1 CIF822-938-1','B1 ATE13.0460-2894','B1 LUCGDB1578','C9 20961 10 704 00','C9 GDB1973','A1 GDB1416','A9 FE FDB1637','C4 2355402TX','B1 BOS0986494399','A1 WBP275','A5 113386','A1 FDB1637','A1 FDB1788','A9 13.04602820.2','A5 206677','A9 GDB1416','B1 CIF822-100-1','C4 16344F','A9 05P634','A1 GDB1578','A3 ROA 226300','A9 FE FDB1788','A9 RH 2263.16','A5 386533','C9 13.0460-2984.2','A1 FSL1083','C4 602820','A1 WBP271','B1 FEB116216','A2 13.04602894.2','C4 05P868','A9 13.04602819.2','C9 FDB1788','B1 ATE13.0460-2823','A2 GDB1416','A9 GDB1973','A5 172832','B1 ATE13.0460-2787','C9 VAL598463','B1 BOS0986461769','C9 GDB1813','A1 GDB1311','C9 GDB1328','B1 ATE13.0460-2740','A1 LP2254','D2 8671016188','B1 ABS35351','C4 23554.170.1','C9 0986461769','E3 20961.172.1','A1 13.0460-2740.2','A8 205 625','C4 16488F','A1 FDB1083','A3 ROA 226392','A3 ROA 226316','C4 FDB1788','B1 ZIM23554.170.3','A1 GDB1973','C4 GDB1328','A3 ROA 226350','A1 FDB1788-PROMO','A9 13.04602787.2','A3 ROA 226304','B1 FEB16406','A9 FE FDB4178','C4 KRO1330','C9 GDB1578','A2 13.04602787.2','C4 FSL1083','A1 16834 FE','A5 206766','A9 RH 2263.50','B1 ATE13.0460-2775','A2 0986495231','C4 GDB1504','C9 13.0460-2740.2','A1 0986494399','E1 30 91 6540','A1 LP565','A1 13.0460-2984.2','A9 13.04602740.2','A3 DLP LP2254','C9 13.0460-2820.2','A9 GDB1813','A3 FER FDB1637','B1 ZIM20961.172.1','B7 0263.06/REM','A5 74906','B1 ZIM20961.972.1','B1 FEB16404','A2 LP2254','A1 16457 FE','A1 0986494923','A2 GDB1813','B1 LUCGDB1328','A3 ROA 226305','A2 FE FDB4178','A2 13.04602819.2','A1 16488 FE','A1 571906D JRD','A9 23554 172 14','A8 220 133','C9 PP-0018AF','C9 13.0460-2894.2','B1 BOS0986494518','C9 GDB1330','C4 FDB1083W','C4 602894','C9 GDB1416','A9 05P868','A2 05P868','B1 BOS0986494621','A2 T 2355481','C4 0986494514','C4 16052F','A2 FE FDB4004','B1 FEB16488','A5 17709','A2 RH 2263.14','A1 GDB1330','C4 GDB1973','A3 FER FDB1788','A1 0986494387','A1 0986495226','A1 13.0460-2623.2','A1 13.0460-2860.2','A1 13.0460-2886.2','A1 13.0470-2740.2','A1 13.0470-2820.2','A1 13.0470-2886.2','A1 13.0470-2894.2','A1 GDB1330DTE','A1 WBP1182','A2 0986466683','A2 0986494387','A2 13.04602886.2','A2 13.04702820.2','A2 13.04702886.2','A2 GDB1330DTE','A2 Q109-1211','A3 BOS 0986466683','A3 BOS 0986494387','A3 BOS 0986495226','A3 QUI 109-1211','A5 206681','A5 206748','A5 206750','A5 281792','A5 289249','A5 341384','A8 206 982','A8 234 054','A8 236 863','A9 0986466683','A9 0986494387','A9 13.04602860.2','A9 13.04602886.2','A9 13.04702740.2','A9 13.04702820.2','A9 13.04702860.2','A9 13.04702886.2','A9 13.04702894.2','A9 GDB1330DTE','A9 Q109-1211','B1 ABS36623/1','B1 ATE13.0460-2623','B1 ATE13.0460-2860','B1 ATE13.0460-2886','B1 ATE13.0470-2623','B1 ATE13.0470-2740','B1 ATE13.0470-2787','B1 ATE13.0470-2820','B1 ATE13.0470-2886','B1 ATE13.0470-2894','B1 BLPADR164201','B1 BOS0986494597','B1 FEB16146','B1 KAMJQ1012166','B1 LUCGDB1330DTE','B1 QB109-1211','B1 VAL301180','B7 B110041/DKM','C4 07.35.105','C4 0986494387','C4 0986495226','C4 16146F','C4 602886','C4 GDB1330DTE','C4 LD2820','C4 LD2886','C4 LD2894','C9 0252096115/PD','C9 0252096117/PD','C9 0252355417/PD','C9 0252355417/W','C9 0986466683','C9 0986494597','C9 13.0460-2623.2','C9 13.0460-2860.2','C9 13.0460-2886.2','C9 13.0470-2623.2','C9 13.0470-2740.2','C9 13.0470-2820.2','C9 13.0470-2860.2','C9 13.0470-2886.2','C9 13.0470-2894.2','C9 GDB1330DTE','C9 QB109-1211','C9 QP8078','C9 QP8078C','D1 BP ADR164201')) and (keszlet>0) and (cikk_tecdoc.cikkszam is not null)) #