Table 'trafflw45_lens.#__TV_INLINKS' doesn't exist SQL=SELECT #__menu.alias as alias,
#__menu.title as linkname,
#__menu.home as home,
#__menu.parent_id as parent_id,
#__TV_INLINKS.id as inlink_id,
#__TV_INLINKS.keyword as keyword,
#__TV_INLINKS.menulink_id as menulink_id,
PARENT.alias as parent
FROM `#__TV_INLINKS`
LEFT OUTER JOIN #__menu ON #__menu.id=#__TV_INLINKS.menulink_id
LEFT OUTER JOIN #__menu as PARENT ON PARENT.id=#__menu.parent_id
WHERE #__menu.published = '1'
AND #__TV_INLINKS.status = 'active'
AND #__TV_INLINKS.menulink_id != '101'
ORDER BY CHAR_LENGTH(keyword) DESC