SELECT job.*, cat.name as categorie, cat.name_EN as categorie_EN, section.section as section,
cust.customers_id as id_customer,
mem.desc_residence as description_residence
FROM emplois as job
LEFT JOIN emplois_categories as cat ON cat.id = job.id_category
left JOIN membership__section as section ON section.id = job.id_region
LEFT JOIN membership as mem ON mem.id_member = job.id_member
INNER JOIN z_customers as cust ON cust.customers_id = job.id_customer
WHERE job.fin_pub > NOW()
AND job.debut_pub < NOW()
AND job.id_status = 1
AND job.paye = 1
AND job.id = 8%3Ch3%20style=
