Forum sur le droit du travail

Posez votre question à la communauté LégiSocial ou répondez pour apporter votre contribution au forum sur le droit du travail de LégiSocial.

M'abonner aux alertes du forum

Filtrer par métier

Poser ma question

Thème	Nombre de réponses	Dernière réponse
How Win In Online Casino Bangladesh Comptabilité	0	VD Vilan Dust le 25 sept. 2024 à 14:29
Nexalyn - Nexalyn Male Enhancement,Nexalyn Testosterone Booster,Nexalyn Cápsulas...	0	NM Nexalyn Male Enhancement le 25 sept. 2024 à 11:39
Downloading YouTube videos on Mac	1	SJ Sam Jonson le 24 sept. 2024 à 20:58
How to improve user experience?	2	GB Gobla Bobla le 24 sept. 2024 à 17:57
Résolu Football Accumulator Betting: Tips and Tricks Comptabilité	0	DK Denis Kloud le 24 sept. 2024 à 08:54
I am thinking about changing my style Comptabilité	1	ES Emory Scott le 23 sept. 2024 à 20:37
Choisir une université pour étudier Comptabilité	2	DR Drevor Romit le 23 sept. 2024 à 17:19
Troubleshooting Pin-Up Casino Login Issues: A Quick Guide Comptabilité	0	VD Vilan Dust le 23 sept. 2024 à 16:28
Supprimez le filigrane de vos photos avec l'IA	3	RK rukia krom le 23 sept. 2024 à 12:49
giochi da casinò	2	VD Vilan Dust le 22 sept. 2024 à 14:33
Bonus et incitations en Celsius casino en ligne en France? Finance	2	JJ jonaton58 jonaton le 20 sept. 2024 à 09:42
İlk Kez Casino Oynayacaklara Tavsiyeler Finance	0	DK Denis Kloud le 19 sept. 2024 à 20:47
Stay Updated with Pin-Up Blog – Your Ultimate Source for Sports News Comptabilité	0	WD William Dust le 19 sept. 2024 à 16:39
Nutrazenith Neoflex : composition et ingrédients principaux RH - Hygiène et sécurité	0	NN Nutrazenith Neoflex le 19 sept. 2024 à 11:23
Find a partner Comptabilité	1	SJ Sam Jonson le 17 sept. 2024 à 22:37

1 2 3 4

...

409 410 411

	0	1
0	SELECT count(*) FROM legisocial.forum_question WHERE supprime IS NOT TRUE	0.0048110485076904
1	SELECT tq.*, UNIX_TIMESTAMP(tq.date_dernier_message) as date_dernier_mess...	0.014709949493408
2	SELECT *, nom as title FROM legisocial.cms_metier	0.00033092498779297

SELECT tq.*, UNIX_TIMESTAMP(tq.date_dernier_message) as date_dernier_message, UNIX_TIMESTAMP(tq.date_creation) as date_creation, UNIX_TIMESTAMP(tq.date_supprime) as date_supprime, (SELECT id FROM legisocial.forum_message WHERE legisocial.forum_message.question_id = tq.id AND supprime = 0 ORDER BY date DESC LIMIT 1) as dernier_message_id, (SELECT COUNT(DISTINCT client_id) FROM legisocial.forum_message WHERE legisocial.forum_message.question_id = tq.id) as nbr_participants, (SELECT id FROM legisocial.forum_message WHERE legisocial.forum_message.question_id = tq.id AND supprime = 0 ORDER BY date ASC LIMIT 1) as message_id, (SELECT nom FROM legisocial.cms_metier WHERE id = tq.metier_id) as metier, tq.id as id, (SELECT COUNT(*) FROM legisocial.forum_message WHERE legisocial.forum_message.question_id = tq.id AND supprime = 0) as reponses, "legisocial" as site, IF (ne.username != "", ne.username, CONCAT(ne.firstname," ", ne.lastname)) as auteur, IF (ne2.username != "", ne2.username, CONCAT(ne2.firstname," ", ne2.lastname)) as auteur_dernier_message, ne.id as auteur_id, ne2.id as dernier_message_client_id FROM legisocial.forum_question tq LEFT JOIN legisocial.forum_message tm ON tm.id = (SELECT id FROM legisocial.forum_message WHERE legisocial.forum_message.question_id = tq.id AND supprime = 0 ORDER BY date ASC LIMIT 1) LEFT JOIN legisocial.forum_message tm2 ON tm2.id = (SELECT id FROM legisocial.forum_message WHERE legisocial.forum_message.question_id = tq.id AND supprime = 0 ORDER BY date DESC LIMIT 1) LEFT JOIN netlegis.emails ne ON ne.id = tm.client_id LEFT JOIN netlegis.emails ne2 ON ne2.id = tm2.client_id WHERE tq.supprime IS NOT TRUE AND tq.attente_moderation = 0 ORDER BY date_dernier_message DESC LIMIT 15, 15