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 ('C9 GDB1469DTE','C4 GDB1469DTE','A2 13.04607137.2','A1 13.0460-7137.2','A2 0986494032','A9 0986494032','A2 05P815','B1 ZIM23482.165.1','A1 GDB1469','C9 VAL598472','A2 J3611045','C9 13.0470-7137.2','C4 2348202TX','C4 23482.165.1','A1 WBP261','A8 215 830','B1 BREP59044','A1 LP1701','A9 13.04607160.2','A1 GDB1469DTE','A2 GDB1469','A9 J3611045','A9 RH 2842.00','A2 FE FDB1540','A1 0986494032','A3 DLP LP2259','A1 GDB3292','A3 ROA 284200','A5 131044','C9 FDB1540','A2 23482 168 05','A1 13.0470-7137.2','C9 VAL872137','A1 LP2259','C4 FDB1540','B1 ABS37216','A9 GDB1469','B1 ATE13.0460-7137','A3 DLP LP1701','A1 P68057','A8 207 978','A8 217 305','B7 0842.00/REM','B1 FEB16428','A8 230 175','A2 GDB1469DTE','A3 TEX 2348202','A2 BP59044','A3 BOS 0986494032','E6 BP1392','A2 LP1701','C4 1170080','A1 LP1726','B1 LUCGDB1469DTE','C4 16428F','C4 05P815','C9 23482-16,8','C9 PP-0017AF','A8 234 070','B7 23482.165.1','B1 BREP68057','A5 194981','A1 13.0460-7160.2','C9 VAL598783','A9 13.04607137.2','C4 607160','C9 VAL301472','C4 607137','C9 GDB1469','A1 FDB1540','A9 05P815','A9 13.04707137.2','C4 KRO1469','B1 BOS0986494032','C1 RH 2842.00','B1 ATE13.0460-7160','B1 ZIM23482.965.1','C9 ADN142114','A2 RH 2842.00','C9 2348202','A1 WBP512','A9 BP59044','A1 598472','D2 8671016680','C9 13.0460-7160.2','B1 BLPADN142114','A3 FER FDB1540','C4 LP1701','A1 P59044','A9 GDB1469DTE','A2 13.04607160.2','C4 GDB1469','B1 VAL301472','A2 13.04707137.2','C9 13.0460-7137.2','B1 LUCGDB1469','C4 J3611045','A1 16428 FE','D1 BP ADN142114','C9 0986494032','C4 0986494032','A9 FE FDB1540','A5 44896','B1 ATE13.0470-7137','A9 23482 168 05','A5 77651','A1 573018J JRD','A1 0986494528','A1 GDB1621','A1 GDB2086','A1 J3613019HB','A1 P61110','A2 0986494528','A2 BD S253','A2 BD S829P','A2 GDB1621','A2 GDB2086','A2 Q109-1189','A2 Q109-1755','A2 RH 2842.20','A3 BOS 0986494528','A3 CIF 822-337-0','A3 JAP PP-138AF','A3 QUI 109-1189','A3 QUI 109-1755','A3 ROA 284220','A5 112895','A5 194973','A5 274009','A5 51602','A8 223 661','A8 230 381','A8 234 094','A8 240 462','A8 250 533','A9 0986494528','A9 BD S253','A9 BD S829P','A9 GDB1621','A9 GDB1621DTE','A9 GDB2086','A9 Q109-1189','A9 Q109-1755','A9 RH 2842.20','B1 BLPADA104249','B1 BOS0986494528','B1 BREP61110','B1 CIF822-337-0','B1 FEB16718','B1 KAMJQ1013080','B1 LUCGDB1621','B1 LUCGDB1621DTE','B1 LUCGDB2086','B1 QB109-1189','B1 QB109-1755','B1 VAI25-0226','B1 VAL301783','B7 0842.20/REM','B7 B110650/DKM','B7 B110857/DKM','C4 0986494528','C4 GDB1621','C4 GDB1621DTE','C4 GDB2086','C4 KRO1621','C4 KRO2086','C9 0252348216','C9 0252348216/PD','C9 0252413716/PD','C9 0252413717','C9 0252413717/PD','C9 0986494528','C9 19-0524','C9 ADA104249','C9 GDB1621','C9 GDB1621DTE','C9 GDB2086','C9 PP-138AF','C9 QB109-1189','C9 QB109-1755','C9 QP5169','C9 QP5169C','D1 BP ADA104249','E1 60 91 6428')) and (keszlet>0) and (cikk_tecdoc.cikkszam is not null)) #