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 ('A2 T 2332681','C9 2332601','A1 WBP433','C9 23326-17,7','A5 50436','A1 LP1911','A1 WBP663','C9 GDB1661','A9 BP85064','B1 BOS0986424056','C4 KRO1557','C6 018156','A2 GDB1557','A3 FER FDB1655','C9 FDB1655','A3 BOS 0986494303','B1 KAMJQ1013288','B1 ATE13.0460-2882','A1 P 85 143','B1 BOS0986494303','D1 BP ADV184228','B1 ABS37368','A3 TRU 07.35.239','A1 13.0460-2888.2','C9 2332602','C9 2332607','E1 30 91 6588','C9 QP5769C','B1 BREP85083','A2 BD S355','A8 230 198','A1 LP1920','C4 LP1860','A9 GDB1516','C4 LP1920','A9 BP85076','D2 EO 2332601','A3 VAC V10-8188-1','A9 T 2332601','A2 0986494119','C6 019524','A5 108173','A1 573219J JRD','B1 ATE13.0460-2889','C9 QP2724C','B7 B110854/DKM','A8 236 287','A1 LP1860','A5 282095','B1 BLPADV184228','A9 BP85083','B1 VAI10-8188','A1 2332601 TEX','B1 BREP85143','A9 13.04602882.2','A1 P85083','C9 23326 00 702 00','C4 602888','A5 73584','A1 0986494119','A9 GDB1557','A1 13.0460-2882.2','B1 ABS37366','C9 0252332617/PD','A2 13.04602882.2','C9 13.0470-2888.2','C4 23882.175.1','A9 0986494303','B1 LUCGDB1769','A8 230 220','A1 P85064','B1 TOM1396','B1 LUCGDB1557','A3 ROA 289700','A2 05P1398','A8 228 244','A3 VAC V10-8188','C9 GDB1769','A1 13.0460-2889.2','C9 0986494303','A1 GDB1516','A2 LP1911','C9 19-0497','C4 GDB1516','A3 TEX 2332602','A3 DLP LP1920','B1 VAL301004','E3 23882.175.1','B1 VAI10-8188-1','C4 LD2888','A1 13.0470-2888.2','A1 GDB1769','C4 LP1911','B7 23882.175.1','C9 PF0602','A3 VAC V10-8176','C9 23326-17,7 1 4','A9 13.04702888.2','A2 BP85064','A2 23326 177 24','A2 13.04602888.2','C9 0252332617','A1 P85076','C4 KRO1516','B1 ATE13.0460-2888','C9 0252332617/W','C9 23326-17,7 1 4 EPAD','B1 TRU07.35.239','C9 19-3324','A2 13.04702888.2','C4 2332681TX','B1 BREP85064','C9 2332611','C9 QP2724','C9 13.0460-2882.2','A1 0986494303','A9 FE FDB1655','C4 602882','A3 DLP LP1860','A1 WBP762','C4 2332602TX','A2 0986494303','C9 13.0470-2882.2','B1 VKA66981103101','B1 LUCGDB1661','C4 0986494303','C9 VAL301004','C4 FDB1655','A2 GDB1516','A2 BP85083','C4 GDB1769','A3 TEX 2332607','B7 B110853/DKM','A2 RH 2897.02','C4 602889','A2 RH 2897.00','C9 GDB1516','A1 2332602 TEX','C4 GDB1557','A8 215 486','C9 23326-17,7 5 4','B7 1163706510/JP','A2 BP85076','A2 LP1920','A2 FE FDB1655','B1 ATE13.0470-2882','A9 23326 177 24','A3 DLP LP1911','B1 CIF822-554-2','A9 13.04602888.2','B1 TOM13961','C9 GDB1557','A1 GDB1557','C9 0252332617-1/PD','B1 LUCGDB1516','A3 BOS 0986494119','C9 13.0460-2888.2','B1 VAI10-8176','A2 LP1860','C9 23326-17,7 4 4','A1 GDB1661','C9 QP8823C','A9 13.04602889.2','C4 2332601TX','A5 195005','A2 13.04602889.2','C4 05P1398','A2 T 2332607','A3 TEX 2332601','B7 0897.02/REM','A8 229 584','A2 T 2332601','A3 TEX 2332681','A3 ROA 289702','C9 13.0460-2889.2','A5 151859','B1 ZIM23882.175.1','B1 ATE13.0470-2888','A1 FDB1655','C9 500038662','B1 BREP85076','A9 RH 2897.00','B7 0897.00/REM')) and (keszlet>0) and (cikk_tecdoc.cikkszam is not null)) #