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 LD7176','A1 598640','A8 221 250','A2 GDB1559','A9 BP06036','B1 LUCGDB1559','A9 13.04707176.2','A2 LP1956','A1 13.0470-7176.2','A3 DLP LP1956','B1 ATE13.0470-7176','A5 206940','C4 KRO1559','A2 13.04707176.2','A3 FER FDB1773','C4 2379401TX','A9 GDB1559','A2 FE FDB1773','C9 23794-20,3','A1 13.0460-7176.2','E7 AC0581512D','C4 607176','C4 LP1956','A2 13.04607176.2','C9 VAL598640','A9 13.04607176.2','C4 FDB1773','C9 FDB1773','A5 165426','A9 23794 203 05','C4 GDB1559','A5 57792','A5 73229','A1 GDB1559','A1 FDB1773','A1 2379401 TEX','C9 13.0470-7176.2','B1 BREP06036','C9 2379401','A8 230 221','A2 23794 203 05','A1 P06036','C9 GDB1559','A3 TEX 2379401','C9 13.0460-7176.2','B1 ATE13.0460-7176','A2 BP06036','A1 LP1956','A1 13.0460-7216.2','A1 13.0460-7268.2','A1 13.0470-7216.2','A1 573151JC JRD','A1 573364JC JRD','A1 FDB4380','A1 GDB1559DTE','A1 GDB1882','A1 P06036X','A1 P06040','A1 P06040X','A1 P06057','A1 P06057X','A1 P06060','A2 13.04607216.2','A2 13.04607268.2','A2 13.04707216.2','A2 23794.200.9','A2 ADB114205','A2 BP06040','A2 BP06057','A2 BP06060','A2 GDB1559DTE','A2 GDB1882','A2 Q109-1751','A2 QWS0218A','A2 QWS0224A','A2 QWS0259A','A2 QWS0289A','A2 QWS0317A','A2 RH 21052.00','A2 RH 2857.10','A2 T 2379301','A2 T 2409601','A3 QUI 109-1751','A3 QUI WS0218A','A3 QUI WS0224A','A3 QUI WS0259A','A3 QUI WS0289A','A3 QUI WS0294A','A3 QUI WS0317A','A3 ROA 2105200','A3 ROA 285710','A3 TEX 2379301','A3 TEX 2409601','A3 TEX 2469701','A3 TEX 2469781','A5 119322','A5 130790','A5 139951','A5 267252','A5 73076','A8 221 249','A8 227 340','A8 228 208','A8 229 384','A8 234 087','A8 237 661','A8 524 100','A8 524 102','A8 524 105','A8 524 166','A8 562 880','A9 13.04607216.2','A9 13.04607268.2','A9 13.04707216.2','A9 BP06040','A9 BP06057','A9 BP06060','A9 GDB1559DTE','A9 GDB1882','A9 Q109-1751','A9 QWS0218A','A9 QWS0224A','A9 QWS0259A','A9 QWS0289A','A9 QWS0292A','A9 QWS0317A','A9 RH 21052.00','A9 T 2379301','A9 T 2409601','A9 T 2469701','B1 ABS37409','B1 ABS37786','B1 ATE13.0460-7216','B1 ATE13.0460-7268','B1 ATE13.0470-7216','B1 BLPADB114205','B1 BREP06036X','B1 BREP06040','B1 BREP06040X','B1 BREP06057','B1 BREP06057X','B1 BREP06060','B1 CIF822-557-3','B1 FEB16503','B1 FEB16825','B1 KAMJQ101175','B1 KAMJQ1013546','B1 LUCGDB1559DTE','B1 LUCGDB1882','B1 QB109-1751','B1 QBWS0218A','B1 QBWS0224A','B1 QBWS0259A','B1 QBWS0289A','B1 QBWS0317A','B1 VAL301640','B1 ZIM23793.200.1','B1 ZIM23793.200.9','B1 ZIM23793.900.1','B1 ZIM23794.200.1','B1 ZIM23794.200.9','B1 ZIM24255.200.1','B1 ZIM24697.190.1','B7 0857.10/REM','B7 1052.00/REM','B7 23793.200.1','B7 23794.200.1','B7 24255.200.1','B7 24697.190.1','B7 B110982/DKM','B7 B111228/DKM','C4 05P1271','C4 05P1512','C4 08.34.110','C4 1170078','C4 16825F','C4 23793.200.1','C4 2379301TX','C4 23794.200.1','C4 23794.200.9','C4 2409601TX','C4 24255.200.1','C4 24697.190.1','C4 2469701TX','C4 607216','C4 607268','C4 GDB1559DTE','C4 GDB1882','C4 KRO1882','C4 LD7216','C4 LP3534','C9 0252379420','C9 0252379420/PD','C9 0252409620','C9 0252469719','C9 0252469719/PD','C9 13.0460-7216.2','C9 13.0460-7268.2','C9 13.0470-7216.2','C9 19-0637','C9 19-2888','C9 19-2904','C9 2379301','C9 23793-20,3','C9 2379381','C9 23794 00 701 00','C9 2409601','C9 2409681','C9 2469701','C9 2469781','C9 GDB1559DTE','C9 GDB1882','C9 QB109-1751','C9 QBWS 0218 A','C9 QBWS 0259 A','C9 QBWS 0286 A','C9 QBWS 0289 A','C9 QBWS 0292 A','C9 QBWS 0294 A','C9 QP0556','C9 QP0556C','C9 QP1970','C9 QP1970C','C9 QP3677','C9 QP3677C')) and (keszlet>0) and (cikk_tecdoc.cikkszam is not null)) #