2020-01-22 22:29:52 MAGAFOR
I NOSTRI PRODOTTI
CENTRATURA - CENTRATURA NC
LAVORAZIONI MULTI-FUNZIONE
SVASATURA
PUNTE A GRADINO
SVASATURA - SBAVATURA MACCHINA
SVASATURA SBAVATURA A MANO
FILETTATURE
LAVORAZIONI DI GOLE
MICRO LAVORAZIONI
FRESATURA
ALESATURA
BROCCIATURA
LAVORAZIONI DI LAMIERE
ESTRATTORI DI VITI
Scie cloche VIKING
Supporti magnetici NOGAFLEX
Sistema di bloccaggio
Combio Pallet MITTE-BITE
PERÇAGE ÉLECTROMAGNÉTIQUE
FRAISES À CAROTTER
Lubrification et accessoires NOGA
RICERCA VELOCE
Codice articolo
Famiglia
Full Text
MAGAZZINO - ORDINI
Login
User id  
Password
Paul-Henri
21/11/2019
Ricerca
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='it' JOIN groupe g2 ON g1.id_grp_parent=g2.id_grp AND g2.id_lng='it' LEFT OUTER JOIN revetement r ON r.id_revetement=fd.id_revetement AND r.id_lng='it' 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='it' LEFT OUTER JOIN serie ON serie.id_serie=fd.id_serie AND serie.id_lng='it' LEFT OUTER JOIN matiere ON matiere.id_matiere=fd.id_matiere AND matiere.id_lng='it' WHERE f.id_lng='it' 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='it' JOIN groupe g2 ON g1.id_grp_parent=g2.id_grp AND g2.id_lng='it' LEFT OUTER JOIN revetement r ON r.id_revetement=fd.id_revetement AND r.id_lng='it' 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='it' LEFT OUTER JOIN serie ON serie.id_serie=fd.id_serie AND serie.id_lng='it' LEFT OUTER JOIN matiere ON matiere.id_matiere=fd.id_matiere AND matiere.id_lng='it' WHERE f.id_lng='it' GROUP BY code ORDER BY code desc〈ue=uk;