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 GDB1469DTE','C9 500038667','A2 13.04607194.2','A1 FSL1540','B1 TOM1295','B1 LUCGDB2086','A9 J3611045','A2 RH 2842.60','A1 FSL1540-PROMO','C9 VAL301472','B1 ATE13.0460-7137','C9 QP2195','E1 60 91 6428','B1 VAI40-8028','A2 13.04607287.2','C1 RH 2842.00','A8 240 462','A1 16428 FE','A9 13.04707194.2','A1 LP2259','A1 FDB1540','A1 0986424617','C9 PP-138AF','A1 LP1701','B1 ATE13.0460-7160','A2 BD S829P','B1 ABS37216','C4 05P1236','C9 QP5169C','A2 24137 167 05','C4 607137','B1 CIF822-337-1','A3 ROA 284260','A2 13.04607160.2','C9 19-0523','A5 194981','B7 23482.165.1','A9 13.04607160.2','C9 0252348216','B1 ATE13.0470-7137','A2 GDB1469DTE','C9 23482 00 702 00','A1 GDB2086','A3 DLP LP1701','C9 GDB2086','A5 131044','A9 23482 168 05','B1 VAL301472','B1 ZIM24137.968.1','A1 573018J JRD','C9 13.0460-7287.2','C9 PP-005AF','C9 13.0470-7194.2','A2 FE FDB1540','C9 2413701','B1 LUCGDB1621DTE','B7 0842.00/REM','A1 GDB1469','B1 CIF822-337-0','A9 0986494032','A1 13.0460-7194.2','B1 ZIM23482.965.1','A3 JAP PP-138AF','A9 BP59044','A2 13.04707194.2','C9 2526501','C4 2413701TX','C4 0986494032','C9 13.0470-7137.2','C4 J3611045','B1 ZIM24137.168.1','B1 KAMJQ1013532','A8 226 640','A2 RH 2842.00','B1 LUCGDB1469DTE','A3 CIF 822-337-1','C4 GDB1469','A2 23482 168 05','B1 KAMJQ1013080','C9 13.0460-7194.2','A1 P59044','A3 JAP PP-005AF','A8 230 175','C9 19-0524','A9 13.04607194.2','A1 0986494032','C9 GDB1469DTE','A9 GDB1621DTE','A9 13.04707137.2','C9 VAL598472','A9 GDB1469','A1 13.0460-7137.2','A2 BP59044','A1 13.0460-7287.2','B1 FEB16428','C4 GDB2086','C9 PF0243','A3 BOS 0986494032','A5 126375','B1 TOM1428','A8 234 094','C9 24137-16,8','A1 GDB1469DTE','A9 13.04607137.2','C9 24137 00 702 00','A5 51602','C9 25265-16,2','C9 2348202','A1 WBP261','A2 13.04707137.2','C4 KRO1469','C9 PF0349','B1 ZIM23482.165.1','A1 51-00-005ASK','C4 1170080','B7 24137.168.1','C4 LP1701','C9 13.0460-7160.2','B7 SP 357','B7 1263700610/JP','A3 ROA 284200','C4 607287','C4 GDB1621DTE','A3 CIF 822-337-0','B7 51138/JAPKO','A8 224 322','A9 05P815','B7 BP-6563/KAVO','A3 TEX 2526501','A9 24137 167 05','B7 B110857/DKM','A9 FE FDB1540','A1 GDB1621DTE','B1 ATE13.0470-7194','A2 05P815','A1 13.0470-7194.2','B7 51005/JAPKO','A9 GDB1469DTE','C9 QP2195C','B7 B110650/DKM','A9 RH 2842.00','B1 ATE13.0460-7287','C4 KRO2086','A1 13.0470-7137.2','A1 598472','A8 215 830','A3 DLP LP2259','A9 BD S829P','C4 FDB1540','C9 13.0460-7137.2','A2 LP1701','B1 VAL301783','C4 23482.165.1','C9 0252348216/PD','C9 FDB1540','A2 0986494032','A2 GDB1469','A2 GDB1621DTE','A5 44896','C9 0986494032','C4 607194','A9 GDB2086','B1 ATE13.0460-7194','C4 05P815','A8 217 305','C4 2348202TX','C4 24137.168.1','A9 RH 2842.60','A8 207 978','A5 76446','A2 J3611045','B1 BOS0986494032','A1 51-01-138ASK','A3 TEX 2348202','C9 23482-16,8','A3 TEX 2413701','C4 16428F','A3 FER FDB1540','A1 13.0460-7160.2','C9 VAL598783','A8 234 070','C9 VAL301783','C9 GDB1469','A5 77651','C4 607160','A5 194973','A2 GDB2086','D2 8671016680','C9 PF0431','A8 228 746','C9 QP5169','E2 700 647 755','A2 05P1236','B1 LUCGDB1469','A2 13.04607137.2','B1 BREP59044','C9 GDB1621DTE','A5 78802','A3 VAC V40-8028','A1 GDB1621','C4 GDB1621','C4 KRO1621','C9 GDB1621','D1 BP ADA104249','E1 40 91 6744','A1 J3613019HB','A1 LP1958','A1 WBP334','A3 DLP LP1958','B1 VAI25-0226','C4 1170006','C4 LP1958','A2 RH 2842.20','A8 230 381','B5 1809458','C4 N3613022')) and (keszlet>0) and (cikk_tecdoc.cikkszam is not null)) #