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 ('C4 2413701TX','A2 FE FDB1766','A2 T 2413781','A2 FE FDB1931','C4 2521201TX','A5 414205','A8 224 322','C9 FDB1931','C9 FDB1766','A9 25212 161 05','A5 274009','A2 BP59042','A8 230 381','A3 BOS 0986494528','A9 BP59044','C9 25212-16,1 EPAD','B1 BOS0986494127','B1 VAI40-8028','A3 BOS 0986494127','B1 BLPADN142114','B1 BOS0986494528','C4 FDB1931','C9 ADA104249','B1 BOS0986494032','C4 KRO1621','A3 CIF 822-337-1','A8 241 561','A1 GDB1621','A1 GDB2033','A1 FSL1766','C9 2413701','A2 GDB1621','A8 240 462','A9 FE FDB1931','A3 BOS 0986495055','A2 0986494032','A1 P61110','A2 24137 167 05','A3 TEX 2413701','A9 0986494528','A2 RH 2842.30','A3 FER FDB1766','C9 24137-16,7 EPAD','C4 0986494528','D1 BP ADN142114','A3 ROA 284230','B1 BREP24148','C4 FDB1766','A2 GDB2033','A5 112895','A2 BP24148','C1 RH 2842.30','A1 FDB1931','C4 0986494032','A5 44896','A3 VAC V40-8028','A3 TEX 2413781','A2 25212 161 05','C9 0986494032','A1 0986494032','A9 T 2413781','C1 RH 2842.20','B1 BREP59042','A1 P59044','A2 0986494127','A2 GDB2086','C9 GDB2033','A9 RH 2842.30','A9 24137 167 05','C9 0986494528','A3 TEX 2521201','A5 194973','B1 BREP59044','B1 ABS37477','B1 ZIM24137.968.1','A9 GDB1621','A3 ROA 284220','C4 KRO2086','B1 LUCGDB2086','A8 233 550','C9 GDB1621','A9 BP59042','A8 250 533','C9 GDB2086','B1 BREP61110','A2 BD S253','A3 BOS 0986494032','B7 0842.40/REM','A9 BP24148','C9 ADN142114','A1 0986494127','C4 GDB2033','A3 TEX 2521281','C9 VAL598783','C9 0986494127','B1 LUCGDB2033','A3 FER FDB1931','B1 LUCGDB1621','A1 0986495055','A8 215 830','A9 FE FDB1766','A1 GDB2086','A1 FDB1766','B7 KBP-6554/KAVO','A1 0986494528','A9 BD S253','B1 CIF822-337-1','A2 0986495055','A1 FSL1931','E6 BP1392','A1 FQT1931','A2 RH 2842.20','B1 BLPADA104249','C9 25212-16,1','A9 GDB2033','D1 BP ADA104249','A9 0986494032','A1 P59042','C4 0986494127','B7 0842.70/REM','A2 0986494528','A2 BP59044','A9 RH 2842.20','A9 GDB2086','A1 P24148','C4 GDB1621','C9 2521201','C4 GDB2086','C9 24137-16,8','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)) #