Please go back and try something else.
(database) line N/A: Unknown column 'title' in 'order clause'<br/><br/>SELECT DISTINCT r.hit_count score, 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, r.modified, r.file_size ,rca.access group_access,rca2.access user_access , r.field8 , r.field12 , r.field18 , r.field51 , r.field3 , rty.order_by , r.hit_count total_hit_count FROM resource r join resource_related t on (t.related=r.ref AND t.resource='42078') LEFT OUTER JOIN resource_custom_access rca2 ON r.ref=rca2.resource AND rca2.user='29' AND (rca2.user_expires IS null or rca2.user_expires>now()) AND rca2.access<>2 LEFT OUTER JOIN resource_custom_access rca ON r.ref=rca.resource AND rca.usergroup='11' AND rca.access<>2 JOIN resource_type AS rty ON r.resource_type = rty.ref WHERE (r.access<>'2' OR (r.access=2 AND ((rca.access IS NOT null AND rca.access<>2) OR (rca2.access IS NOT null AND rca2.access<>2)))) AND (((r.archive<>-2 OR r.created_by='29') AND (r.archive<>-1 OR r.created_by='29')) ) AND (archive NOT IN ('-2','-1','1','2','3','4') OR created_by='29') AND r.ref>0 AND NOT (rca.resource IS null AND r.access=3) GROUP BY r.ref UNION SELECT DISTINCT r.hit_count score, 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, r.modified, r.file_size ,rca.access group_access,rca2.access user_access , r.field8 , r.field12 , r.field18 , r.field51 , r.field3 , rty.order_by , r.hit_count total_hit_count FROM resource r join resource_related t on (t.resource=r.ref AND t.related='42078') LEFT OUTER JOIN resource_custom_access rca2 ON r.ref=rca2.resource AND rca2.user='29' AND (rca2.user_expires IS null or rca2.user_expires>now()) AND rca2.access<>2 LEFT OUTER JOIN resource_custom_access rca ON r.ref=rca.resource AND rca.usergroup='11' AND rca.access<>2 JOIN resource_type AS rty ON r.resource_type = rty.ref WHERE (r.access<>'2' OR (r.access=2 AND ((rca.access IS NOT null AND rca.access<>2) OR (rca2.access IS NOT null AND rca2.access<>2)))) AND (((r.archive<>-2 OR r.created_by='29') AND (r.archive<>-1 OR r.created_by='29')) ) AND (archive NOT IN ('-2','-1','1','2','3','4') OR created_by='29') AND r.ref>0 AND NOT (rca.resource IS null AND r.access=3) GROUP BY r.ref ORDER BY title DESC,ref DESC