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 FDB1766','B1 LUCGDB2086','C9 GDB2033','A2 BP59044','A1 P61110','C4 0986494127','C4 FDB1766','A2 BP24148','C9 24137-16,7 EPAD','A2 24137 167 05','A2 0986495055','B1 CIF822-337-1','C4 KRO1621','B1 BOS0986494032','C4 GDB1621','A2 0986494528','A2 T 2413781','C9 GDB2086','A3 FER FDB1931','A9 0986494528','A1 0986494127','A8 241 561','C9 0986494032','A1 P59044','C9 GDB1621','A8 224 322','A2 GDB2033','B1 BLPADA104249','A1 P24148','B1 ABS37477','C9 FDB1766','C4 0986494528','A5 112895','C9 0986494528','A3 TEX 2521281','D1 BP ADA104249','A8 230 381','A9 BD S253','A9 25212 161 05','A3 BOS 0986494528','A9 BP59044','C1 RH 2842.20','C9 0986494127','C4 FDB1931','A9 0986494032','A1 0986494032','A3 VAC V40-8028','A3 FER FDB1766','C9 25212-16,1 EPAD','A1 P59042','A2 GDB1621','A2 BP59042','C4 KRO2086','C9 ADN142114','A9 FE FDB1766','A3 ROA 284230','B7 0842.70/REM','C4 GDB2086','B1 BREP59044','B1 BLPADN142114','A3 CIF 822-337-1','B1 VAI40-8028','B1 BOS0986494528','A1 GDB2086','A1 GDB1621','A5 274009','A9 RH 2842.30','A2 25212 161 05','A2 RH 2842.20','C9 2521201','A2 FE FDB1931','A2 FE FDB1766','B1 BREP61110','C9 25212-16,1','A5 414205','C4 2413701TX','A3 TEX 2413781','C9 ADA104249','A9 T 2413781','C9 24137-16,8','A3 BOS 0986495055','A5 44896','A1 FSL1931','A9 BP24148','A1 FQT1931','B7 0842.40/REM','C1 RH 2842.30','A1 FSL1766','D1 BP ADN142114','A9 FE FDB1931','A1 FDB1931','A9 GDB2086','A3 TEX 2521201','B1 LUCGDB1621','B1 BREP24148','A9 GDB2033','A5 194973','A3 TEX 2413701','A9 BP59042','A9 24137 167 05','B1 LUCGDB2033','A2 RH 2842.30','C4 2521201TX','B7 KBP-6554/KAVO','A8 215 830','A1 0986495055','A8 240 462','A2 0986494127','A1 0986494528','A2 0986494032','C9 VAL598783','E6 BP1392','A2 GDB2086','A3 BOS 0986494127','A8 250 533','C9 2413701','C4 0986494032','A3 ROA 284220','A9 RH 2842.20','B1 ZIM24137.968.1','A2 BD S253','C9 FDB1931','A9 GDB1621','A3 BOS 0986494032','C4 GDB2033','B1 BOS0986494127','A8 233 550','B1 BREP59042','A1 GDB2033','A1 13.0460-7195.2','A1 13.0460-7209.2','A1 13.0460-7278.2','A1 13.0470-7195.2','A1 573186JC JRD','A1 GDB1469','A1 J3613019HB','A2 13.04607195.2','A2 13.04607251.2','A2 13.04707195.2','A2 25212.160.1','A2 GDB1469','A2 GDB1469DTE','A2 N3613022','A2 RH 2842.00','A3 JAP PP-005AF','A3 ROA 284200','A5 194981','A5 205674','A5 206735','A5 206754','A5 309187','A5 77557','A5 78802','A8 230 175','A8 234 070','A8 234 094','A9 13.04607195.2','A9 13.04607209.2','A9 13.04607251.2','A9 13.04707195.2','A9 GDB1469','A9 GDB1469DTE','A9 GDB1621DTE','A9 N3613022','A9 RH 2842.00','B1 ABS37869','B1 ATE13.0460-7195','B1 ATE13.0460-7209','B1 ATE13.0460-7251','B1 ATE13.0460-7278','B1 ATE13.0470-7195','B1 ATE13.0470-7251','B1 BREP59042X','B1 FEB16718','B1 KAMJQ1013532','B1 LUCGDB1469','B1 LUCGDB1469DTE','B1 LUCGDB1621DTE','B1 VAI25-0226','B1 VAL301783','B1 ZIM23482.165.2','B1 ZIM25212.160.1','B7 0842.00/REM','B7 0842.20/REM','B7 25212.160.1','B7 B110650/DKM','B7 B111338/DKM','C4 1170006','C4 23482.165.2','C4 25212.160.1','C4 607195','C4 607209','C4 607278','C4 GDB1469','C4 GDB1469DTE','C4 GDB1621DTE','C4 KRO1469','C4 N3613022','C9 0252348216','C9 0252348216/PD','C9 0252413717','C9 0252413717/PD','C9 13.0460-7195.2','C9 13.0460-7209.2','C9 13.0460-7251.2','C9 13.0460-7278.2','C9 13.0470-7195.2','C9 13.0470-7251.2','C9 19-0523','C9 24137 00 702 00','C9 GDB1469','C9 GDB1469DTE','C9 GDB1621DTE','C9 QP2195','C9 QP2195C')) and (keszlet>0) and (cikk_tecdoc.cikkszam is not null)) #