2019-08-19 19:02:36 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
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 acceßoires NOGA
RECHERCHE RAPIDE
Code article
Famille
Full Text
STOCK - COMMANDES
Connexion
Identifiant  
Mot de paße
Paul-Henri
26/04/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=fr' 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=fr;