SQL |
SELECT resale_details.ID, business_description, resale_details.company_name, resale_details.location,
resale_details.investment, resale_details.no_of_staff, resale_details.established,
resale_details.long_description, resale_details.email_contact, resale_details.logo,
resale_details.image, resale_details.clients,textHtmlLeads,
resale_details.turnover, resale_details.hours, resale_details.emailPref, resale_details.funds,
companies.companyId, companies.advertisor, companies.resalesForm, companies.imageTwo, companies.heroAlt,
ctaResales.franchiseId,
ctaResales.firstname,
ctaResales.secondname,
ctaResales.position,
ctaResales.mobile,
ctaResales.email,
ctaResales.linkedin,
ctaResales.whatsapp,
ctaResales.hascta,
ctaResales.calendy,
ctaResales.ctaimage,
ctaResales.website
FROM resale_details, companies, ctaResales
WHERE resale_details.company_name = companies.companyName
and resale_details.ID = ?
and
ctaResales.franchiseId = resale_details.ID
and resale_details.suspended != 1 |