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