 |
Query failed : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '-50,50' at line 34
SELECT
DISTINCT
l.CompanyName,
l.StreetAddressCity,
ld.description,
ld.shortdescription,
l.email,
l.WebAddress,
l.id,
ac.adClassificationImportance,
l.PhoneNumber,
ld.logo,
l.StreetAddressState,
l.have_details,
lc.category_profile_description,
l.FranchiseSpecialty1
FROM lawyers l
JOIN lawyerstocateries lc
ON l.id=lc.lawyerid
LEFT JOIN lawyerDetails ld
ON l.id = ld.lawyerid
JOIN adClassification ac
ON lc.adClassificationId=ac.adClassificationId
WHERE
lc.categoryid=7 AND
l.StreetAddressState LIKE "%" AND
l.StreetAddressCity LIKE "irvine%"
AND ac.adClassificationImportance=4
AND adClassificationStatus=1
ORDER BY l.have_details DESC,l.CompanyName
LIMIT -50,50
| | |
