QSTR SELECT
tc.city_id,
tc.city_sr,
tc.city_sr_ascii,
tc.city_en,
tc.city_de,
tc.city_it,
tc.city_hu,
tbl_cities.city_sr AS near_sr,
tbl_cities.city_sr_ascii AS near_sr_ascii,
tbl_cities.city_en AS near_en,
tbl_cities.city_de AS near_de,
tbl_cities.city_it AS near_it,
tbl_cities.city_hu AS near_hu
FROM
tbl_cities AS tc
Left Join tbl_near ON tc.city_id = tbl_near.city_id
Left Join tbl_cities ON tbl_near.near_id = tbl_cities.city_id
WHERE
tc.city_sr LIKE 'Loznica%'
or tc.city_sr_ascii LIKE 'Loznica%'
or tc.city_en LIKE 'Loznica%'
or tc.city_de LIKE 'Loznica%'
or tc.city_it LIKE 'Loznica%'
or tc.city_hu LIKE 'Loznica%'
or tbl_cities.city_sr  LIKE 'Loznica%'
or tbl_cities.city_sr_ascii  LIKE 'Loznica%'
or tbl_cities.city_en  LIKE 'Loznica%'
or tbl_cities.city_de  LIKE 'Loznica%'
or tbl_cities.city_it  LIKE 'Loznica%'
or tbl_cities.city_hu  LIKE 'Loznica%'

<div style='border: 1px solid red'> SQL error. Query was: <strong>SELECT 
`ID`,
`name_of_hotel`,
`town-city`,
`rating`,
`rs_annual_breakfast_included`,
`breakfast_rate`,
`breakfast_rate_eur`,
`city-town_centre_-_distance`,
`main_station_-_distance`,
`highway_exit`,
`airport_1_-_distance`,
`hotel_parking_lot`,
`number_of_non-smoking_rooms`,
`number_of_restaurants`,
`internet_tv`,
`dsl-highspeed_internet_connection_in__rooms`,
`internet_access_in__rooms`,
`wellness_centar`,
`spa_gardens`,
`spa_hotel`,
`spa_clinic`,
`currency_options`,
`rs_weekend_type`,
`rs_weekend_sgl_rate`,
`rs_weekend_sgl_rate_eur`,
`rs_weekend_dbl_rate`,
`rs_weekend_dbl_rate_eur`,
`rs_weekend_breakfast_included`,
`rs_annual_sgl_rate`,
`rs_annual_sgl_rate_eur`,
`rs_annual_dbl_rate`,
`rs_annual_dbl_rate_eur`,
`rs_annual_breakfast_included`,
`general_booking_type_select`,
`hotel_for_cyclist-bikers`,
`locked_parking_spaces_for_bicycles-motorbikes`,
`bike_hire`,
`gmap_x`,
`gmap_y`
 FROM hotels WHERE 1=1 AND 0  AND visible=1 AND general_booking_type_select<>3</strong><br>
MySQL said: <strong>Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (111)</strong></div>