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 2379301','A1 P06057','B7 23793.200.1','B1 ZIM23793.200.2','C9 0986424822','C9 2379401','B1 FEB16503','A3 TEX 2379401','A8 221 250','C9 13.0460-7174.2','A2 13.04607174.2','B1 ABS37409','B1 ZIM23793.200.1','A2 0986494007','B1 ZIM23794.200.1','B1 BREP06036X','A5 165426','C9 0986494007','A8 224 631','A1 13.0460-7216.2','C9 2373201','B1 VAI20-8118','B1 ZIM23794.200.2','C9 23793-20,3','C9 FDB1773','A9 23732 173 05','A3 FER FDB1773','A9 13.04607176.2','A5 73229','A3 BOS 0986494007','A8 230 221','A9 13.04607216.2','A1 0986424400','A9 13.04607174.2','A9 BP06057','B1 ATE13.0460-7176','A3 BOS 0986494118','A1 0986494118','B7 23793.200.2','B7 23794.200.2','B7 23794.200.1','C4 23793.200.1','A8 221 252','B1 ATE13.0460-7216','C4 0986494118','C9 2379301','A9 23794 203 05','A9 RH 21052.00','C4 16503F','A1 P06057X','B1 BREP06036','C4 0986494007','A5 57792','A1 0986494007','A1 2373201 TEX','C4 23794.200.1','A9 T 2379301','A1 P06036','A9 BP06036','A2 BP06036','A3 ROA 2105200','B1 BREP06057','C4 607174','B1 BOS0986494118','C4 LP1956','A3 TEX 2379301','C4 FDB1773','C4 2373201TX','A8 228 208','A5 72991','A1 2379401 TEX','A2 FE FDB1773','A1 P06036X','C4 GDB1559','B1 LUCGDB1559','A2 23794 203 05','A3 TEX 2373201','A2 GDB1559','C9 13.0460-7176.2','A1 WBP558','C9 0986494118','C4 2379401TX','B1 BOS0986494007','A2 RH 21052.00','A2 13.04607176.2','A2 LP1956','C9 GDB1559','A3 VAC V20-8118','A1 GDB1559','A1 LP1956','A2 BP06057','A1 16503 FE','A1 0986424822','A2 0986494118','A1 13.0460-7174.2','A1 FDB1773','C4 2379301TX','C9 23794-20,3','A3 DLP LP1956','C9 23732-17,3','A5 73076','C9 13.0460-7216.2','A2 13.04607216.2','C4 607216','B1 BREP06057X','B1 VAI20-8126','A1 WBP728','A2 23732 173 05','B1 ATE13.0460-7174','C4 KRO1559','A3 VAC V20-8126','A1 13.0460-7176.2','A9 0986494118','E1 20 91 6503','C4 607176','A9 GDB1559','D3 RE 105200-AF','A1 13.0470-7174.2','A1 573151JC JRD','A1 GDB1559DTE','A1 GDB1882','A1 P06033','A1 P06033X','A1 P06060','A2 13.04707174.2','A2 23794.200.9','A2 ADB114205','A2 BP06033','A2 BP06060','A2 GDB1559DTE','A2 GDB1882','A2 Q109-1751','A3 CIF 822-557-0','A3 QUI 109-1751','A5 130790','A5 267252','A5 348443','A8 227 340','A8 234 087','A8 237 661','A9 13.04707174.2','A9 BP06033','A9 BP06060','A9 GDB1559DTE','A9 GDB1882','A9 Q109-1751','B1 ATE13.0470-7174','B1 BLPADB114205','B1 BREP06033','B1 BREP06033X','B1 BREP06060','B1 CIF822-557-0','B1 FEB16825','B1 LUCGDB1559DTE','B1 LUCGDB1882','B1 QB109-1751','B1 VAL301640','B1 ZIM23732.170.9','B1 ZIM23732.970.1','B1 ZIM23793.200.9','B1 ZIM23793.900.1','B1 ZIM23794.200.9','B1 ZIM24697.190.1','B7 24697.190.1','B7 B111228/DKM','C4 05P1271','C4 08.34.110','C4 1170078','C4 16825F','C4 23794.200.9','C4 24697.190.1','C4 GDB1559DTE','C4 GDB1882','C4 KRO1882','C4 LD7174','C9 0252379420','C9 0252379420/PD','C9 0252409620','C9 0252469719','C9 0252469719/PD','C9 13.0470-7174.2','C9 19-0511','C9 19-0637','C9 19-2904','C9 19-3672','C9 2379381','C9 GDB1559DTE','C9 GDB1882','C9 QB109-1751','C9 QP0556','C9 QP0556C','C9 QP3677','C9 QP3677C','C9 QP6562','C9 QP6562C','C9 QP8739C','D3 2RES1052.00/G')) and (keszlet>0) and (cikk_tecdoc.cikkszam is not null)) #