Hello! Can you tell me what is error there is in my query SQL?
I checked common number of each table's fields and check syntax, but i dont understand, how fix error.
Error Number: 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 'as ssss FROM typeorder UNION SELECT "estate", idTYPE, TYPENAME_AZ, T' at line 1
SELECT "type", idTYPEORDER AS "id", TYPEORDERNAME_AZ AS "name", TYPEORDERNAME_AZ as name_d, TYPEORDERNAME as name_ru, DEFAULT as ssss FROM typeorder
UNION
SELECT "estate", idTYPE, TYPENAME_AZ, TYPENAME_AZ,TYPENAME,DEFAULT FROM type_estate
UNION
SELECT "flats", idAPARTAMENT_FLATS, APARTAMENT_FLATSNAME_AZ, APARTAMENT_FLATSNAME_AZ, APARTAMENT_FLATSNAME, DEFAULT FROM apartament_flats
UNION
SELECT "currency", idCURRENCY, CURRENCYNAME_AZ, CURRENCYNAME_AZ, CURRENCYNAME, DEFAULT FROM currency
UNION
SELECT "country", idCOUNTRY, COUNTRYNAME_AZ, COUNTRYNAME_AZ, COUNTRYNAME , DEFAULTFROM country
UNION
SELECT "region", idREGION, REGIONNAME_AZ, REGIONNAME_AZ, REGIONNAME, DEFAULT FROM region
UNION
SELECT "city", idCITY, CITYNAME_AZ, CITYNAME_AZ, CITYNAME, DEFAULT FROM city
UNION
SELECT "village", idVILLAGE, VILLAGENAME_AZ,VILLAGENAME_AZ, VILLAGENAME, DEFAULT FROM village
UNION
SELECT "bedroom", idBEDROOM, BEDROOMNAME_AZ, BEDROOMNAME_AZ, BEDROOMNAME, DEFAULT FROM bedroom
UNION
SELECT "position", idPOSITION, POSITIONNAME_AZ, POSITIONNAME_AZ, POSITIONNAME, DEFAULT FROM position
UNION
SELECT "toilet", idTOILET, TOILETNAME_AZ, TOILETNAME_AZ, TOILETNAME, DEFAULT FROM toilet
UNION
SELECT "view", idVIEW, VIEWNAME_AZ, VIEWNAME_AZ, VIEWNAME, DEFAULT FROM view
UNION
SELECT "flat", idAPARTAMENT_FLAT, APARTAMENT_FLATNAME_AZ, APARTAMENT_FLATNAME_AZ, APARTAMENT_FLATNAME, DEFAULT FROM apartament_flat
UNION
SELECT "repair", idREPAIRTYPE, REPAIRTYPENAME_AZ, REPAIRTYPENAME_AZ, REPAIRTYPENAME, DEFAULT FROM repairtype
UNION
SELECT "project", idPROJECT, PROJECTNAME_AZ, PROJECTNAME_AZ, PROJECTNAME, DEFAULT FROM project
UNION
SELECT "rooms", idApartamentrooms, APARTAMENTROOMS_AZ, APARTAMENTROOMS_AZ, APARTAMENTROOMS, DEFAULT FROM apartament_rooms
UNION
SELECT "position_type", idPOSITION, POSITIONNAME_AZ, POSITIONNAME_AZ, POSITIONNAME, DEFAULT FROM position_type
UNION
SELECT "comfort", idCOMFORT, COMFORTNAME_AZ, COMFORTNAME_AZ, COMFORTNAME, DEFAULT FROM comfort
UNION
SELECT "metro", idMETRO, METRONAME_AZ, METRONAME_AZ, METRONAME, DEFAULT FROM metro ORDER BY name