1054 - Unknown column 'l.links_id' in 'field list'
select count(l.links_id) as total from (select l.links_image_url, ld.links_title, ld.links_description, l.links_url, l.links_clicked, l.links_id from links_description ld, links l, links_to_link_categories l2lc where ( l.links_status = '2' or l.links_status = '4' ) and l.links_id = l2lc.links_id and ld.links_id = l2lc.links_id and ld.language_id = '4' and l2lc.link_categories_id = '7' order by ld.links_title) as t