SELECT *,affaire.titre as ttl,affaire.id as affaireID,affaire.aff_premium,affaire.supprimer as suppaffaire, affaire.s_activite, affaire.*,affaire.DATEMODIF as ddaffaire, societe.id as societeID, societe.societe as SOC, societe.date as ddfg, affaire.commentaire as COMMENTAIREaffaire, affaire.IA AS IA, societe.*,societe.complet as societecomplet, societe.ville, societe.modifier as societemodifier, societe.PAYS as PAYSsociete, societe.DATE AS SCTDATE FROM affaire INNER JOIN societe ON affaire.societe = societe.ID where affaire.ID=515084 and (affaire.escroc = 0) and affaire.attente= 0 and affaire.afficher=-1
L'annonceur declare etre SANS ENTREPRISE |