Smart pack recrute Commerciale Mission: - Assurer le suivie client de la commande jusqu’à la facturation et la livraison, - Prospection des nouveaux client. - Répondre à toutes les demandes internes et… ...
Smart pack recrute Commercial Description de l'annonce: Nous recrutons pour le compte de notre client, Commercial MISSIONS : · Assurer le traitement des commandes jusqu’à la facturation et la livraison, · Répondre… ...
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:31:05'
) 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:05'
) 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