2020-08-12 17:30:37 MAGAFOR
NOS PRODUITS
CENTRAGE - POINTAGE
USINAGES MULTI-FONCTIONS
LAMAGE
PERÇAGES ÉTAGÉS
ÉBAVURAGE CHANFREINAGE MACHINE
ÉBAVURAGE GRATTAGE À MAIN
FILETAGE
USINAGE DE GORGES
MICRO USINAGES
FRAISAGE
ALÉSAGE
FRAISES LIMES Cerin
BROCHAGE
USINAGES DE TOLES
EXTRACTEURS DE VIS
Scie cloche VIKING
Supports magnétiques NOGAFLEX
Systèmes pour le bridage
Palettisation MITTE-BITE
PERÇAGE ÉLECTROMAGNÉTIQUE
FRAISES À CAROTTER
Lubrification et accessoires
RECHERCHE RAPIDE
Code article
Famille
Full Text
STOCK - COMMANDES
Connexion
Identifiant  
Mot de passe
Paul-Henri
21/11/2019
Recherche
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='fr' JOIN groupe g2 ON g1.id_grp_parent=g2.id_grp AND g2.id_lng='fr' LEFT OUTER JOIN revetement r ON r.id_revetement=fd.id_revetement AND r.id_lng='fr' 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='fr' LEFT OUTER JOIN serie ON serie.id_serie=fd.id_serie AND serie.id_lng='fr' LEFT OUTER JOIN matiere ON matiere.id_matiere=fd.id_matiere AND matiere.id_lng='fr' WHERE f.id_lng='fr' 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='fr' JOIN groupe g2 ON g1.id_grp_parent=g2.id_grp AND g2.id_lng='fr' LEFT OUTER JOIN revetement r ON r.id_revetement=fd.id_revetement AND r.id_lng='fr' 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='fr' LEFT OUTER JOIN serie ON serie.id_serie=fd.id_serie AND serie.id_lng='fr' LEFT OUTER JOIN matiere ON matiere.id_matiere=fd.id_matiere AND matiere.id_lng='fr' WHERE f.id_lng='fr' GROUP BY code ORDER BY code desc〈ue=uk;