Geofit Tunisie recrute BIM Modeleur –TCE Profil Issu d'une formation supérieure dans le domaine du BTP. vous justifiez d'une première expérience en tant que Modeleur sur logiciel Revit. Vous êtes reconnu pour… ...
Requête SQL générée : SELECT SQL_CALC_FOUND_ROWS net_posts.*
FROM net_posts
WHERE 1=1 AND (
net_posts.post_date > '2024-04-19 10:30:25'
) AND (
(
SELECT COUNT(1)
FROM net_term_relationships
WHERE term_taxonomy_id IN (4,1052634)
AND object_id = net_posts.ID
) = 2
) AND ((net_posts.post_type = 'post' AND (net_posts.post_status = 'publish')))
GROUP BY net_posts.ID
ORDER BY net_posts.post_date DESC
LIMIT 0, 10
Requête SQL générée : SELECT SQL_CALC_FOUND_ROWS net_posts.*
FROM net_posts LEFT JOIN net_term_relationships ON (net_posts.ID = net_term_relationships.object_id)
WHERE 1=1 AND (
net_posts.post_date_gmt > '2024-04-19 10:30:25'
) AND (
net_term_relationships.term_taxonomy_id IN (4)
AND
net_posts.ID NOT IN (
SELECT object_id
FROM net_term_relationships
WHERE term_taxonomy_id IN (1052634)
)
) AND ((net_posts.post_type = 'post' AND (net_posts.post_status = 'publish')))
GROUP BY net_posts.ID
ORDER BY net_posts.post_date DESC
LIMIT 0, 6