1 2 3 4 5 6 7 8 9 10 11 12 13
|
SELECT c.id_client,nom_societe,logo_client,prestation_client,fiche_vue_client, m.id_metier AS id_metier, nom_metier, cm.id_cat, nom_cat, com.id as id_ville, com.ncc as nom_ville,d.dep as id_dep FROM client c
JOIN ville_du_client vc ON vc.id_client = c.id_client
JOIN communes com ON com.id = vc.id_ville
JOIN departements d ON d.dep = com.dep
JOIN metier_du_client mc ON mc.id_client = c.id_client
JOIN metier m ON m.id_metier = mc.id_metier
JOIN categorie_du_metier cdm ON cdm.id_metier = mc.id_metier
JOIN categorie_metier cm ON cm.id_cat = cdm.id_cat
WHERE valider_client=1 AND prestation_client != ''
GROUP BY c.id_client
ORDER BY c.id_client DESC
LIMIT 0,5 |
Partager