Notice: Undefined index: location_radius in /var/www/uua.org/html/directory/congregations/application/results.php on line 209
database error: Invalid SQL: (SELECT geolat, geolong, congregations.code, name, district, members, multidenom_members, welcoming, welcoming_datefrom, emerging, ParentOrg, IsParent, nfml, wheelchair, listening_assist, congaddresses.address_id, congaddresses.congregation_id, congaddresses.address_line_1, congaddresses.address_line_2, congaddresses.city, congaddresses.state, congaddresses.zip, congaddresses.country, congaddresses.address_type, congaddresses.latitude, congaddresses.longitude, congaddresses.address_timestamp, (POW((69.1*(longitude-(-72.1439830 ))*cos(43.6406440 /57.3)),2)+POW((69.1*(latitude-(43.6406440 ))),2)) AS distance FROM congregations RIGHT JOIN congaddresses ON congregations.code = congaddresses.congregation_id GROUP BY congaddresses.congregation_id HAVING ((Count(congaddresses.address_id) = 1) AND (congaddresses.address_type = 'Mailing Address') AND (distance < (*)))) UNION (SELECT geolat, geolong, congregations.code, name, district, members, multidenom_members, welcoming, welcoming_datefrom, emerging, ParentOrg, IsParent, nfml, wheelchair, listening_assist, congaddresses.address_id, congaddresses.congregation_id, congaddresses.address_line_1, congaddresses.address_line_2, congaddresses.city, congaddresses.state, congaddresses.zip, congaddresses.country, congaddresses.address_type, congaddresses.latitude, congaddresses.longitude, congaddresses.address_timestamp, (POW((69.1*(longitude-(-72.1439830 ))*cos(43.6406440 /57.3)),2)+POW((69.1*(latitude-(43.6406440 ))),2)) AS distance FROM congregations RIGHT JOIN congaddresses ON congregations.code = congaddresses.congregation_id HAVING ((congaddresses.address_type = 'Meeting Address') AND (distance < (*)))) ORDER BY distance
MySQL error: 1064 (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 '*)))) UNION (SELECT geolat, geolong, congregations.cod)
Session halted