Recherchez un commerce ou un service par thème
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' |
