Sanary.com english deutsch italiano russian
Recherche personnalisée

commerces
Recherchez un commerce ou un service par thme

01 BARS - HOTELS - RESTAURANTS 02 ALIMENTATION - TABAC 03 CULTURE - COMMUNICATION 04 TRAVAUX - BATIMENTS 05 INDEPENDANTS - CONSULTANTS
06 VETEMENTS - ACCESSOIRES 07 BIEN ETRE - BEAUTE 08 DECORATION - ART - JARDINS 09 VEHICULES - TRANSPORTS 10 ASSURANCE - LOI - FINANCE
11 IMMOBILIER - VENTE - LOCATIF 12 NAUTISME - VOYAGES 13 SPORTS - LOISIRS 14 DEPANNAGE - SERVICES 15 MEDICAL - SANTE

ou par nom
| 4 | A | B | C | D | A | F | G | H | I | J | K | L | M | N | A | P | Q | R | S | T | U | V | W | X | Y | Z |


Erreur SQL !
(SELECT commerces_cat.nom as categorie,commerces.ID,t1.nom as type,t2.nom as type2,commerces.nom,adresse,tel,afiliation FROM commerces INNER JOIN commerces_type t1 ON t1.id=commerces.type LEFT JOIN commerces_type t2 on t2.id=commerces.type2 INNER JOIN commerces_cat ON commerces_cat.id=t1.categorie LEFT JOIN membre m ON m.ID = commerces.ID AND m.id_fiche NOT IN (SELECT lien FROM membre WHERE lien != '') AND validation = '1' WHERE commerces.nom LIKE 'A���%' AND commerces_cat.id NOT IN ('14','22') ORDER BY afiliation DESC,commerces.nom ASC) UNION (SELECT commerces_cat.nom as categorie,commerces.ID,t1.nom as type,t2.nom as type2,commerces.nom,adresse,tel,'0' as afiliation FROM commerces INNER JOIN commerces_type t1 ON t1.id=commerces.type LEFT JOIN commerces_type t2 on t2.id=commerces.type2 INNER JOIN commerces_cat ON commerces_cat.id=t1.categorie INNER JOIN membre m ON m.ID = commerces.ID AND m.id_fiche NOT IN (SELECT lien FROM membre WHERE lien != '') AND validation = '0' WHERE commerces.nom LIKE 'A���%' AND commerces_cat.id NOT IN ('14','22') GROUP BY commerces.ID ORDER BY commerces.nom ASC) ORDER BY afiliation DESC, nom ASC
Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8mb4_general_ci,COERCIBLE) for operation 'like'