SELECT "type", idTYPEORDER AS "id", TYPEORDERNAME'.$this->prefix.' AS "name", TYPEORDERNAME as name_d FROM typeorder UNION
SELECT "estate", idTYPE, TYPENAME'.$this->prefix.', TYPENAME FROM type_estate UNION
SELECT "flats", idAPARTAMENT_FLATS, APARTAMENT_FLATSNAME'.$this->prefix.', APARTAMENT_FLATSNAME FROM apartament_flats UNION
SELECT "currency", idCURRENCY, CURRENCYNAME, CURRENCYNAME FROM currency UNION
SELECT "country", idCOUNTRY, COUNTRYNAME'.$this->prefix.', COUNTRYNAME FROM country UNION
SELECT "region", idREGION, REGIONNAME'.$this->prefix.', REGIONNAME FROM region UNION
SELECT "city", idCITY, CITYNAME'.$this->prefix.', CITYNAME FROM city UNION
SELECT "village", idVILLAGE, VILLAGENAME'.$this->prefix.',VILLAGENAME FROM village UNION
SELECT "bedroom", idBEDROOM, BEDROOMNAME'.$this->prefix.', BEDROOMNAME FROM bedroom UNION
SELECT "position", idPOSITION, POSITIONNAME'.$this->prefix.', POSITIONNAME FROM position UNION
SELECT "toilet", idTOILET, TOILETNAME'.$this->prefix.', TOILETNAME FROM toilet UNION
SELECT "view", idVIEW, VIEWNAME'.$this->prefix.', VIEWNAME FROM view UNION
SELECT "flat", idAPARTAMENT_FLAT, APARTAMENT_FLATNAME'.$this->prefix.', APARTAMENT_FLATNAME FROM apartament_flat UNION
SELECT "repair", idREPAIRTYPE, REPAIRTYPENAME'.$this->prefix.', REPAIRTYPENAME FROM repairtype UNION
SELECT "project", idPROJECT, PROJECTNAME'.$this->prefix.', PROJECTNAME FROM project UNION
SELECT "rooms", idApartamentrooms, APARTAMENTROOMS'.$this->prefix.', APARTAMENTROOMS FROM apartament_rooms UNION
SELECT "position_type", idPOSITION, POSITIONNAME'.$this->prefix.', POSITIONNAME FROM position_type UNION
SELECT "comfort", idCOMFORT, COMFORTNAME'.$this->prefix.', COMFORTNAME FROM comfort UNION
SELECT "metro", idMETRO, METRONAME'.$this->prefix.', METRONAME FROM metro
I want that every SELECT will be with ORDER BY 'name_field' DESC
Is it possible?