SQL Failed
SQL:
SELECT
attorneys.*,
`attorneys`.`ID` as `AID`,
attorney_addresses.*,
states.FullName AS StateName,
states.Abbreviation AS StateAbbr
states.FullName_URL AS FullName_URL
FROM attorneys, states, attorney_addresses
WHERE attorneys.RefID = '31339487'
AND states.ID = attorney_addresses.State
AND attorney_addresses.Attorney = attorneys.RefID
AND attorneys.Deleted = 0
AND (SELECT COUNT(*) FROM attorney_scores WHERE `attorney_scores`.`Attorney` = `attorneys`.`RefID` AND `Site` = 'lawyers.lawyerlegion.com') > 0
ORDER BY attorneys.RefID ASC, attorney_addresses.`Primary` DESC
LIMIT 1;
ERROR: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'states.FullName_URL AS FullName_URL FROM attorneys, states, attorney_addres...' at line 7