Please go back and try something else.
You can check your installation configuration.
(database) line N/A: Unknown column 'field12' in 'order clause'<br/><br/>select distinct *,r2.total_hit_count score from (select r.ref, r.resource_type, r.has_image, r.is_transcoding, r.creation_date, r.rating, r.user_rating, r.user_rating_count, r.user_rating_total, r.file_extension, r.preview_extension, r.image_red, r.image_green, r.image_blue, r.thumb_width, r.thumb_height, r.archive, r.access, r.colour_key, r.created_by, r.file_modified, r.file_checksum, r.request_count, r.new_hit_count, r.expiry_notification_sent, r.preview_tweaks, r.file_path ,null group_access, null user_access , r.hit_count total_hit_count from resource r where archive in (0) and r.ref>0 order by ref desc limit 1000 ) r2 order by user_rating DESC,total_hit_count DESC,field12 DESC,r2.ref DESC