GRJ recrute Software Developer C++ Responsibilities • Software development, implementation and test of new features of CIM product • Working closely with the Development teams in Tunis and with Projects Managers in… ...
Requête SQL générée : SELECT SQL_CALC_FOUND_ROWS net_posts.ID
FROM net_posts
WHERE 1=1 AND (
net_posts.post_date > '2024-04-19 10:31:11'
) 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:31:11'
) 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