2020-01-22 21:31:48 MAGAFOR
OUR PRODUCTS
CENTERING - SPOTTING
MULTI FUNCTIONS MACHINING
COUNTERBORING
STEP DRILLING
MACHINE DEBURRING COUNTERSINKING
HAND DEBURRING AND SCRAPING
THREADING
MACHINING OF GROOVES
MINIATURE MACHINING
MILLING
REAMING
BROACHING
MACHINING OF SHEET STEEL
SCREWS EXTRACTORS
Scie cloche VIKING
NOGAFLEX Holding systems
MITEE-BITE Clamping systems
and pallet changer
PERÇAGE ÉLECTROMAGNÉTIQUE
FRAISES À CAROTTER
Cooling and accessories NOGA
QUICK SEARCH
Part of article code
Range
Full Text
STOCK - ORDERS
Sign In
User ID  
Password
Paul-Henri
21/11/2019
Search Result
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'desc〈ue=uk' at line 45
SELECT f.code_famille AS code, MIN(marque.lbl) as marquelbl, MIN(fd.angle) as fdangle, MIN(norme.lbl) as normelbl, MIN(REPLACE(serie.lbl,'
',' ')) AS serielbl, MIN(matiere.lbl) as matierelbl, MIN(r.lbl) as revetementlbl, MIN(r.couleuron) as revetementcouleuron, MIN(gfd1.id_grp) AS groupe FROM famille f JOIN famille_detail fd ON f.code_famille=fd.code_famille JOIN groupe_famille_detail gfd1 ON gfd1.code_famille=f.code_famille JOIN groupe g1 ON g1.id_grp=gfd1.id_grp AND g1.id_lng='uk' JOIN groupe g2 ON g1.id_grp_parent=g2.id_grp AND g2.id_lng='uk' LEFT OUTER JOIN revetement r ON r.id_revetement=fd.id_revetement AND r.id_lng='uk' LEFT OUTER JOIN marque ON marque.id_marque=fd.id_marque LEFT OUTER JOIN norme ON norme.id_norme=fd.id_norme AND norme.id_lng='uk' LEFT OUTER JOIN serie ON serie.id_serie=fd.id_serie AND serie.id_lng='uk' LEFT OUTER JOIN matiere ON matiere.id_matiere=fd.id_matiere AND matiere.id_lng='uk' WHERE f.id_lng='uk' AND fd.id_ajustement=1 GROUP BY code UNION SELECT f.code_famille AS code, MIN(marque.lbl) as marquelbl, MIN(fd.angle) as fdangle, MIN(norme.lbl) as normelbl, MIN(REPLACE(serie.lbl,'
',' ')) AS serielbl, MIN(matiere.lbl) as matierelbl, MIN(r.lbl) as revetementlbl, MIN(r.couleuron) as revetementcouleuron, MIN(gfd1.id_grp) AS groupe FROM famille f JOIN famille_detail fd ON f.code_famille=fd.code_famille_alias JOIN groupe_famille_detail gfd1 ON gfd1.code_famille=fd.code_famille JOIN groupe g1 ON g1.id_grp=gfd1.id_grp AND g1.id_lng='uk' JOIN groupe g2 ON g1.id_grp_parent=g2.id_grp AND g2.id_lng='uk' LEFT OUTER JOIN revetement r ON r.id_revetement=fd.id_revetement AND r.id_lng='uk' LEFT OUTER JOIN marque ON marque.id_marque=fd.id_marque LEFT OUTER JOIN norme ON norme.id_norme=fd.id_norme AND norme.id_lng='uk' LEFT OUTER JOIN serie ON serie.id_serie=fd.id_serie AND serie.id_lng='uk' LEFT OUTER JOIN matiere ON matiere.id_matiere=fd.id_matiere AND matiere.id_lng='uk' WHERE f.id_lng='uk' GROUP BY code ORDER BY code desc〈ue=uk;