| query | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| RESULTSET |
|
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| CACHED | false | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| EXECUTIONTIME | 1 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| 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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| SQLPARAMETERS |
|
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
VAT No:238213031. Company Registration No:03896150 Copyright © whichfranchise.com 2022.
Registered Office
272 London Road
Wallington
Surrey, UK
SM6 7DJ