Com&Dev recrute Developpeur Android Expérimenté Mission : *Conception, développement et maintenance de l’application Android en coordination avec une équipe en France *Evaluation des coûts temporels de différentes fonctionnalités, ainsi que le maintien… ...
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:29:32'
) 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:29:32'
) 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
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_gmt > '2024-03-19 10:29:33'
) AND (
net_posts.ID NOT IN (
SELECT object_id
FROM net_term_relationships
WHERE term_taxonomy_id IN (2,4,8958,10216,1052634)
)
) AND ((net_posts.post_type = 'post' AND (net_posts.post_status = 'publish')))
GROUP BY net_posts.ID
ORDER BY RAND()
LIMIT 0, 9