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 ('B1 TOM1428','A2 05P1236','C9 FDB1540','A1 FSL1766','A9 RH 2842.40','C4 2521201TX','B7 0842.40/REM','C9 VAL301019','A9 05P815','B1 VAI25-0226-1','B1 LUCGDB1621','A1 P59042','A1 J3613019HB','A1 P24148','A9 13.04707195.2','A1 FDB1675','B1 ABS37477','A1 0986495055','B7 B111338/DKM','C9 GDB2033','A8 234 094','A3 FER FDB1540','C4 05P1189','A9 GDB2033','A2 LP3303','C4 FDB1931','A3 TEX 2521801','A9 BP24148','A2 FE FDB1931','C9 19-2918','C9 0252413716','C9 13.0460-7195.2','A5 126375','A2 0986494127','B1 ATE13.0460-7195','A2 0986495055','B1 ATE13.0460-7194','A1 GDB2033','C9 13.0460-7278.2','A1 51-00-005ASK','B1 FRE940017','A2 13.04707195.2','A1 573018J JRD','B1 ATE13.0470-7251','C9 13.0460-7209.2','C9 13.0470-7195.2','A9 13.04607251.2','A8 241 187','A1 573209JC JRD','C4 05P1236','B7 23482.165.2','A1 13.0470-7195.2','C9 0986494528','A9 13.04607209.2','C4 25212.160.1','A9 24137 167 05','A3 VAC V25-0824','A3 DLP LP1958','C4 KRO1621','C9 VAL301783','A2 GDB1938','A2 13.04607251.2','A1 WBP334','A2 RH 2842.40','A2 13.04607195.2','A1 598472','A5 76446','A5 206754','A2 LP1958','B1 FEB16718','C9 PF0569','B1 ATE13.0470-7195','A2 24137 167 05','A2 50 91 6718','B1 ABS37869','A3 DLP LP3653','A5 206736','A9 FE FDB1766','B1 LUCGDB2033','C4 2521801TX','C4 05P815','A3 JAP PP-005AF','A1 P61110','B1 VAI40-8028','C9 25212 00 702 00','C9 GDB2086','B1 KAMJQ1013080','A8 226 640','B1 ZIM24137.168.1','A1 GDB1621DTE','B1 LUCGDB1938','B1 LUCGDB2086','A9 BP59042','C9 FDB1931','C9 GDB1621DTE','B1 ABS41381','B1 VAL301019','A5 284606','A9 N3613022','B7 51138/JAPKO','C9 2521201','A1 P24148X','B1 BREP24148X','A9 13.04607253.2','A9 BD S253','A2 RH 2842.20','C9 2521801','A2 13.04607209.2','A1 13.0460-7195.2','A3 VAC V40-8028-1','B1 ATE13.0460-7253','A3 TEX 2521201','C9 13.0460-7194.2','A3 FER FDB1766','A5 194973','A3 BOS 0986495216','A9 RH 2842.30','C9 VAL872482','A9 GDB1938','C4 607209','A2 05P1189','A9 T 2413781','C4 2413701TX','C9 0986494127','A1 0986495216','A3 BOS 0986494528','A8 240 462','C9 13.0460-7251.2','A8 241 561','C9 13.0470-7251.2','C9 PF0570','B7 SP 357','A3 BOS 0986494127','B1 VAI40-8028-1','A9 GDB1621','A8 233 550','A2 BP24148','A3 FER FDB1675','C4 N3613022','A3 VAC V25-0226-1','B7 25212.160.1','A9 25212.160.1','A2 BP59042','C9 PP-005AF','A2 BD S253','B1 ATE13.0470-7194','B1 BOS0986494528','A3 FER FDB1931','B7 BP-6563/KAVO','C4 0986494127','C9 0252413716/PD','C4 1170006','A9 FE FDB1540','A3 ROA 284220','C9 PF0243','B7 0842.20/REM','C4 GDB1621DTE','C9 0986424999','C9 25212-16,1 EPAD','C4 LP1958','A9 RH 2842.70','A3 ROA 284270','A2 FE FDB1766','A1 FSL1931','C9 VAL598472','A9 13.04607194.2','B1 BREP59042','A1 13.0470-7251.2','A5 131044','B7 24137.168.1','C9 13.0470-7194.2','C9 VAL598783','C9 24137-16,8','C9 QP5524','C1 RH 2842.30','A3 TEX 2413701','A2 T 2413781','B7 B110650/DKM','A3 VAC V40-8028','A1 0986494127','C4 GDB2086','A3 VAC V25-0226','C4 GDB1621','A8 224 322','B1 BREP61110','B1 ATE13.0460-7251','B7 51005/JAPKO','A3 TEX 2521281','A1 FDB1766','B1 BREP59042X','A8 256 778','C9 VAL601008','A9 GDB2086','C4 607195','A1 LP1958','B1 ATE13.0460-7209','A9 FE FDB1931','C9 500038667','C9 0252413717','C4 607194','B1 ZIM25212.160.1','C4 0986494528','B1 ATE13.0460-7278','A2 0986495216','A2 05P815','C9 PF0349','C4 KRO2086','B7 KBP-6554/KAVO','A2 13.04607194.2','B1 ABS37216','A2 RH 2842.70','A1 13.0460-7209.2','A9 RH 2842.20','C9 0252413717/PD','A2 0986494528','C4 0986495216','C4 24137.168.1','B7 0842.30/REM','A5 78802','C9 QP5524C','A3 ROA 284240','A3 ROA 284230','C9 25218 00 702 00','A1 16718 FE','E1 50 91 6718','C9 GDB1938','B1 BOS0986424999','A1 FDB1931','A2 13.04607253.2','A1 GDB1938','A1 13.0460-7278.2','A1 13.0470-7194.2','E7 346.2','C4 23482.165.2','B1 LUCGDB1621DTE','C9 2413701','B1 CIF822-337-3','A9 GDB1621DTE','B1 KAMJQ1013532','C9 24137-16,7 EPAD','B1 BOS0986494127','A8 250 533','B1 VAI25-0824','A1 13.0460-7253.2','B1 CIF822-337-2','A3 TEX 2413781','C4 FDB1540','C4 GDB2033','C4 607278','A2 25212 161 05','A1 FDB1540','A2 N3613022','C9 25218-16,3','B7 0842.70/REM','A1 13.0460-7251.2','A5 205674','A2 FE FDB1540','A5 112895','C1 RH 2842.20','A2 GDB1621','A2 GDB1621DTE','B1 VAL301783','A2 25212.160.1','C9 19-0523','C9 QP2195C','A1 GDB2086','A8 230 381','B1 BREP24148','B1 ZIM23482.165.2','A3 VAC V42-0406','C9 QP2195','C9 24137 00 702 00','C4 LP3653','A9 25212 161 05','A1 GDB1621','C4 FDB1766','A3 BOS 0986495055','A5 77557','A1 0986494528','A5 414205','A1 573209J JRD','A1 573186JC JRD','B1 VAI25-0226','B1 VAI42-0406','C9 VAL601044','C4 GDB1938','A2 13.04707194.2','C9 GDB1621','C9 PF0431','A3 CIF 822-337-1','A1 13.0460-7194.2','A5 206735','A2 RH 2842.30','C9 VAL872137','B1 ZIM24137.968.1','A2 GDB2086','B1 CIF822-337-1','A8 217 305','A9 0986494528','A9 13.04707194.2','A9 13.04607195.2','C9 25212-16,1','C9 13.0460-7253.2','C4 KRO1938','A2 GDB2033','A5 274009','A5 309187','B7 1263700610/JP','C9 FDB1766','C4 1170080')) and (keszlet>0) and (cikk_tecdoc.cikkszam is not null)) #