User Channels
Erro
  • Unknown column 'a.title' in 'order clause' SQL=SELECT DISTINCT u.id,u.name AS title,u.email AS email,a.thumbnail_ext_id, a.key, a.description, a.alias, a.checked_out, a.checked_out_time,a.hits, a.published, a.likes, a.dislikes, a.featured,a.status, a.publish_up, a.publish_down, a.created, a.access,a.language,CASE WHEN a.published > ' ' THEN a.published ELSE 1 END AS published,CASE WHEN a.created_user_id_alias > ' ' THEN a.created_user_id_alias ELSE ua.username END AS author FROM xxvqh_users AS u LEFT JOIN `xxvqh_hwdms_users` AS a ON a.id = u.id LEFT JOIN xxvqh_users AS ua ON ua.id = a.created_user_id LEFT JOIN xxvqh_users AS uam ON uam.id = a.modified_user_id WHERE a.access IN (1,1) AND a.private = 0 AND a.published = 1 AND a.status = 1 AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2017-03-23 22:02:54') AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2017-03-23 22:02:54') AND 1 = 1 OR NOT EXISTS (SELECT 1 FROM xxvqh_hwdms_users WHERE xxvqh_hwdms_users.id = u.id) ORDER BY a.title DESC Unknown column 'a.title' in 'order clause' SQL=SELECT DISTINCT u.id,u.name AS title,u.email AS email,a.thumbnail_ext_id, a.key, a.description, a.alias, a.checked_out, a.checked_out_time,a.hits, a.published, a.likes, a.dislikes, a.featured,a.status, a.publish_up, a.publish_down, a.created, a.access,a.language,CASE WHEN a.published > ' ' THEN a.published ELSE 1 END AS published,CASE WHEN a.created_user_id_alias > ' ' THEN a.created_user_id_alias ELSE ua.username END AS author FROM xxvqh_users AS u LEFT JOIN `xxvqh_hwdms_users` AS a ON a.id = u.id LEFT JOIN xxvqh_users AS ua ON ua.id = a.created_user_id LEFT JOIN xxvqh_users AS uam ON uam.id = a.modified_user_id WHERE a.access IN (1,1) AND a.private = 0 AND a.published = 1 AND a.status = 1 AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2017-03-23 22:02:54') AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2017-03-23 22:02:54') AND 1 = 1 OR NOT EXISTS (SELECT 1 FROM xxvqh_hwdms_users WHERE xxvqh_hwdms_users.id = u.id) ORDER BY a.title DESC LIMIT 0, 15 Unknown column 'a.title' in 'order clause' SQL=SELECT DISTINCT u.id,u.name AS title,u.email AS email,a.thumbnail_ext_id, a.key, a.description, a.alias, a.checked_out, a.checked_out_time,a.hits, a.published, a.likes, a.dislikes, a.featured,a.status, a.publish_up, a.publish_down, a.created, a.access,a.language,CASE WHEN a.published > ' ' THEN a.published ELSE 1 END AS published,CASE WHEN a.created_user_id_alias > ' ' THEN a.created_user_id_alias ELSE ua.username END AS author FROM xxvqh_users AS u LEFT JOIN `xxvqh_hwdms_users` AS a ON a.id = u.id LEFT JOIN xxvqh_users AS ua ON ua.id = a.created_user_id LEFT JOIN xxvqh_users AS uam ON uam.id = a.modified_user_id WHERE a.access IN (1,1) AND a.private = 0 AND a.published = 1 AND a.status = 1 AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2017-03-23 22:02:54') AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2017-03-23 22:02:54') AND 1 = 1 OR NOT EXISTS (SELECT 1 FROM xxvqh_hwdms_users WHERE xxvqh_hwdms_users.id = u.id) ORDER BY a.title DESC

 

Compartilhe