2020-08-12 17:51:13 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
ROTARY BURS Cerin
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
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;