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.04607195.2','A1 0986424617','C9 13.0460-7195.2','C1 RH 2842.20','A3 TEX 2348202','C4 607194','A9 BP59044','C9 13.0460-7137.2','A1 LP1702','A8 230 175','C4 LP1702','C4 KRO1469','A2 FE FDB1540','A1 GDB3292','A3 DLP LP1702','B1 LUCGDB1469','A2 LP1702','A1 WBP512','D2 8671016680','A5 194981','C9 2348202','A1 P59044','C9 23482-16,8','C4 2348202TX','A1 573018J JRD','A9 23482 168 05','B1 ATE13.0460-7137','A2 13.04607195.2','A9 BD S253','A2 23482 168 05','A1 GDB1469','A1 598472','C4 GDB1469','A9 13.04607194.2','A3 FER FDB1540','A5 76446','A2 GDB1469','A2 BP59044','A2 RH 2842.20','A9 13.04607137.2','B1 BREP59044','C4 FDB1540','B1 ATE13.0460-7195','C9 VAL598472','C9 GDB1469','A5 77651','A8 207 978','A1 13.0460-7195.2','A3 ROA 284220','A5 77557','A2 BD S253','C4 607195','A9 RH 2842.20','A2 13.04607137.2','C4 607137','A1 13.0460-7137.2','C9 FDB1540','A9 GDB1469','A1 FDB1540','A2 13.04607194.2','B1 ATE13.0460-7194','C9 13.0460-7194.2','A9 FE FDB1540','A1 13.0460-7194.2','A1 13.0460-7160.2','A1 13.0470-7195.2','A1 GDB1621','A1 GDB2086','A1 J3613019HB','A1 LP1958','A1 P59042','A1 P61110','A1 WBP334','A2 05P815','A2 13.04607160.2','A2 13.04707195.2','A2 24137 167 05','A2 BP59042','A2 GDB1469DTE','A2 GDB1621','A2 GDB2086','A2 J3611045','A2 Q109-1755','A2 RH 2842.00','A3 CIF 822-337-0','A3 DLP LP1958','A3 JAP PP-138AF','A3 QUI 109-1755','A3 ROA 284200','A3 TEX 2413701','A5 131044','A5 194973','A5 206754','A5 274009','A5 51602','A8 217 305','A8 223 661','A8 224 322','A8 230 381','A8 234 070','A8 234 094','A8 240 462','A9 13.04607160.2','A9 13.04707194.2','A9 13.04707195.2','A9 24137 167 05','A9 BP59042','A9 GDB1469DTE','A9 GDB1621','A9 GDB1621DTE','A9 GDB2086','A9 Q109-1755','A9 RH 2842.00','B1 ABS37477','B1 ATE13.0460-7160','B1 ATE13.0470-7194','B1 ATE13.0470-7195','B1 BLPADN142114','B1 BREP59042','B1 BREP59042X','B1 BREP61110','B1 BREP68057','B1 CIF822-337-0','B1 FEB16428','B1 KAMJQ1013080','B1 KAMJQ1013532','B1 LUCGDB1469DTE','B1 LUCGDB1621','B1 LUCGDB1621DTE','B1 LUCGDB2086','B1 QB109-1755','B1 VAI25-0226','B1 VAL301472','B1 ZIM23482.165.1','B1 ZIM23482.965.1','B7 0842.00/REM','B7 0842.20/REM','B7 23482.165.1','B7 B110650/DKM','B7 B111338/DKM','C4 05P815','C4 1170006','C4 1170080','C4 23482.165.1','C4 2413701TX','C4 607160','C4 GDB1469DTE','C4 GDB1621','C4 GDB1621DTE','C4 GDB2086','C4 J3611045','C4 KRO1621','C4 KRO2086','C4 LP1958','C9 0252348216','C9 0252348216/PD','C9 0252413716/PD','C9 0252413717/PD','C9 13.0470-7194.2','C9 13.0470-7195.2','C9 19-0523','C9 19-0524','C9 2413701','C9 24137-16,8','C9 ADN142114','C9 GDB1469DTE','C9 GDB1621','C9 GDB1621DTE','C9 GDB2086','C9 PP-138AF','C9 QB109-1755','C9 QP2195','C9 QP2195C','C9 QP5169','C9 QP5169C','D1 BP ADN142114','E1 60 91 6428','E6 BP1392')) and (keszlet>0) and (cikk_tecdoc.cikkszam is not null)) #