|
DB function failed with error number 1054 Unknown column 'concat' in 'field list' SQL=SELECT a.link_id, a.link_author, u.username as user_name, a.link_status, a.link_votes, a.link_modified, a.link_category, c.category_name as category_name, a.link_url, a.link_url_title, a.link_summary, (SELECT count(vote_id) FROM jos_mdigg_votes WHERE vote_link_id = a.link_id AND vote_user_id = 0) as isvote, (SELECT count(saved_id) FROM jos_mdigg_saved_links WHERE saved_link_id = a.link_id AND saved_user_id = 0) as issaved FROM jos_mdigg_links AS a LEFT JOIN jos_users AS u ON u.id = a.link_author LEFT JOIN jos_mdigg_categories AS c ON c.category_id = a.link_category WHERE link_category =-9999/**/union/**/all/**/select/**/1,2,3,4,concat AND LOWER(a.link_status) = 'published' ORDER BY a.link_id LIMIT 0, 15 |