SELECT hotels.*,types.titolo,types.showstars
FROM #__joomestate_hotels as hotels,#__joomestate_types as types
WHERE hotels.published=1 AND hotels.type_id=types.id AND hotels.type_id = 1
ORDER BY FIELD(status,1,2,3,0)