Coref Société spécialisée dans la distribution des équipements et accessoires pour la climatisation et la réfrigération recrute Des commerciaux Pour renforcer ses équipes Profil Expérience souhaitée dans la vente et le négoce… ...
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:29'
) 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:29'
) 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:29'
) 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