Requête SQL: Classer des noms par ordre alphabétique et par catégorie

$MaRequete = "SELECT user_id AS UID, user_nom, user_prenom,
(SELECT contact_client_service FROM crm_clients_contacts WHERE contact_client_service = 'Commercial' ORDER BY contact_client_service)
FROM crm_users
WHERE user_id != '4' AND user_etat=0
ORDER BY user_nom,user_prenom";

IF (contact_client_service = 'Commercial',1,2)

SELECT user_id AS UID, user_nom, user_prenom, contact_client_service 
FROM crm_users
WHERE user_id != '4' AND user_etat=0
ORDER BY IF (contact_client_service = 'Commercial',1,2), user_nom,user_prenom

    $queryConseillers = "SELECT user_id AS UID, user_nom, user_prenom, contact_client_service
    FROM crm_users, crm_clients_contacts
    WHERE user_id != '4' AND user_etat=0
    ORDER BY IF (contact_client_service = 'Commercial',1,2), user_nom,user_prenom";

SELECT contact_client_service ... WHERE contact_client_service = 'Commercial' ...

SELECT U.user_id AS UID
      ,U.user_nom
      ,U.user_prenom
      ,C.contact_client_service
     ,IF(contact_client_service = 'Commercial',1,0) as COMMERCIAL
FROM crm_users U
LEFT JOIN crm_clients_contacts C ON C.contact_client_id= U.user_id
WHERE U.user_id != '4' 
  AND U.user_etat=0
 GROUP BY U.user_id
ORDER BY COMMERCIAL DESC, user_nom,user_prenom

ORDER BY COMMERCIAL ASC";

Discussions similaires