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 607195','A2 GDB2086','B1 BOS0986494032','A9 RH 2842.30','A9 N3613022','C9 GDB1621','C4 0986494032','C4 GDB2086','A8 240 462','B7 0842.20/REM','B1 VAI40-8028','A1 13.0460-7175.2','E1 50 91 6718','C4 KRO1621','A3 JAP PP-005AF','A1 16890 FE','C4 0986495216','A1 WBP334','A1 WBP261','B7 1263700610/JP','B1 LUCGDB1621','C9 13.0460-7209.2','C9 VAL872137','A3 FER FDB1675','A3 VAC V40-8028','B1 ATE13.0470-7251','A3 BOS 0986494127','A1 13.0470-7195.2','B1 ATE13.0460-7194','A9 RH 2842.70','A1 0986494127','A3 VAC V25-0824','C9 FDB1931','B7 24137.168.1','A3 VAC V40-8028-1','C4 LP1701','A2 N3613022','B1 BREP59042','A8 241 561','A2 13.04607253.2','A2 BD S253','A9 0986494032','C4 LP1958','C9 13.0470-7251.2','A2 T 2413781','B1 ATE13.0460-7195','A3 DLP LP1958','C4 16428F','A1 13.0460-7209.2','C4 GDB1621','A5 206736','A3 BOS 0986494032','A5 126375','C4 KRO2086','A9 13.04707194.2','E1 60 91 6428','A1 13.0470-7251.2','A3 ROA 284220','A5 76446','A3 TEX 2413781','A1 GDB2033','A2 BP59042','A9 T 2413781','A1 13.0460-7194.2','B1 ATE13.0460-7209','A3 BOS 0986495216','D1 BP ADA104249','A8 226 640','C4 0986494127','A5 77557','C9 13.0470-7195.2','A1 FDB1931','C1 RH 2842.20','B1 ABS37477','A2 GDB1621','C9 24137 00 702 00','A2 FE FDB1931','A5 206754','C9 24137-16,7 EPAD','A1 13.0460-7253.2','C4 05P1236','A1 FDB1675','B7 B110650/DKM','C9 GDB2033','A3 VAC V25-0226','B1 LUCGDB2086','B1 ZIM24137.168.1','A2 13.04607194.2','C4 24137.168.1','A1 13.0460-7251.2','A9 13.04607209.2','A1 LP1958','A2 FE FDB1766','C9 13.0460-7253.2','A2 13.04607209.2','A2 GDB2033','B1 ATE13.0470-7195','B1 ABS37216','C4 FDB1931','A1 13.0460-7195.2','A9 BD S253','A5 309187','C9 GDB2086','A9 13.04607195.2','A3 ROA 284230','A3 FER FDB1766','A9 13.04607253.2','A1 16718 FE','A9 13.04707195.2','A2 LP1701','C9 VAL598472','A2 13.04607251.2','A9 13.04607194.2','B1 LUCGDB2033','C4 607251','A9 RH 2842.20','A2 RH 2842.20','B7 0842.70/REM','B7 SP 357','C4 GDB2033','B1 VAI25-0824','A2 GDB1621DTE','A1 16744 FE','B1 LUCGDB1621DTE','A2 13.04607195.2','A1 P59042','A5 194973','A1 FDB1766','A3 ROA 284270','A1 13.0470-7194.2','C9 FDB1766','A9 FE FDB1931','C9 PP-005AF','C9 13.0460-7195.2','A1 LP1726','A8 234 094','C4 607209','B1 FEB16428','B1 VAI40-8028-1','C4 N3613022','A2 0986495216','A1 FQT1931','A2 RH 2842.30','A5 414205','C9 0986494032','C9 VAL601008','B1 FEB16890','B1 ZIM24137.968.1','C9 13.0460-7251.2','A5 78802','C9 GDB1621DTE','B1 FEB16744','C4 607194','A2 13.04707195.2','A2 0986494127','E1 62 91 6890','B1 BOS0986494127','C9 13.0470-7194.2','C1 RH 2842.30','A1 16428 FE','A2 0986494032','A1 GDB1621','C9 ADA104249','A3 FER FDB1931','B1 ATE13.0460-7251','A5 44896','A2 05P1236','B1 FEB16718','C4 LD7195','C4 GDB1621DTE','B7 0842.30/REM','A2 13.04707194.2','A5 274009','A1 598472','C9 VAL872482','B1 TOM1428','A8 215 830','C4 FDB1766','A2 LP1958','B7 KBP-6554/KAVO','A1 GDB1621DTE','A9 GDB1621','C4 1170006','A5 206735','C9 VAL598783','A9 BP59042','B1 ATE13.0470-7194','C9 0986494127','A8 230 381','B1 ATE13.0460-7253','A9 13.04607251.2','A9 FE FDB1766','A9 GDB1621DTE','C9 13.0460-7194.2','B1 VAI25-0226','B1 BLPADA104249','B1 BREP59042X','C9 19-0523','A1 0986494032','A9 GDB2086','A1 GDB2086','C9 0252413716','A3 DLP LP1701','A9 GDB2033','A1 573186JC JRD','A1 FSL1766','A1 LP1701','A1 0986495216','A2 50 91 6718','C9 PP-0006AF','A2 RH 2842.70','A1 13.0460-7137.2','A1 13.0460-7160.2','A1 GDB1469','A1 J3613019HB','A2 13.04607160.2','A2 BD S829P','A2 GDB1469','A2 GDB1469DTE','A2 Q109-1755','A2 QWS0313A','A2 RH 2888.40','A3 CIF 822-337-1','A3 JAP PP-138AF','A3 QUI 109-1755','A3 QUI WS0313A','A5 194981','A5 51602','A5 77651','A8 223 661','A8 230 175','A8 234 070','A9 13.04607137.2','A9 13.04607160.2','A9 13.04707137.2','A9 BD S829P','A9 GDB1469','A9 GDB1469DTE','A9 Q109-1755','A9 QWS0313A','A9 RH 2888.40','B1 ATE13.0460-7137','B1 ATE13.0460-7160','B1 ATE13.0470-7137','B1 BLPADN142114','B1 CIF822-337-1','B1 KAMJQ1013532','B1 LUCGDB1469','B1 LUCGDB1469DTE','B1 QB109-1755','B1 QBWS0313A','B1 VAL301019','B1 VAL301783','B7 0888.40/REM','B7 B110857/DKM','B7 B111338/DKM','C4 607137','C4 607160','C4 GDB1469','C4 GDB1469DTE','C4 KRO1469','C9 0252348216/PD','C9 0252413716/PD','C9 0252413717/PD','C9 13.0460-7137.2','C9 13.0470-7137.2','C9 23-0112','C9 ADN142114','C9 GDB1469','C9 GDB1469DTE','C9 PP-138AF','C9 QB109-1755','D1 BP ADN142114','E6 BP1392')) and (keszlet>0) and (cikk_tecdoc.cikkszam is not null)) #