SELECT fs.plugin, mt.image, mt.menu_text, fs.folder, fs.status, fs.id, fs.link_to,
fs.shortcut_to,
if (ftmnu.parent_id = fs.parent_id and fs.default_load = 1, 1, 0) as default_load, fs.publish_date, fs.unpublish_date,
ftmnu.inMenuStatus, mt.ext_link, mt.title,
ftmnu.parent_id, sum(mc.status) as stat, count(mc.status) as stat_count,
mc.locked_by, mc.status as content_status
FROM neo_files_to_menu ftmnu
INNER JOIN neo_filesystem fs ON
ftmnu.file_id = fs.id
LEFT JOIN neo_menuTitles mt
ON mt.uid = concat(fs.id, '_en')
LEFT JOIN neo_files_to_modules ftm
ON ftm.file_id = fs.id AND ftm.mod_name = 'mod_content'
LEFT JOIN neo_mod_content mc
ON mc.id = ftm.mod_id AND mc.status >= 0 AND mc.language = 'en'
WHERE ftmnu.parent_id = '17' AND ftmnu.inMenuStatus = 1
AND ftmnu.menu_id = '1'
group by id
ORDER BY ftmnu.sort_or in /home/httpd/vhosts/gdk.be/httpdocs/admin/includes/functions/database.php on line 48
Notice: 1030 - Got error 28 from table handler
SELECT fs.plugin, mt.image, mt.menu_text, fs.folder, fs.status, fs.id, fs.link_to,
fs.shortcut_to,
if (ftmnu.parent_id = fs.parent_id and fs.default_load = 1, 1, 0) as default_load, fs.publish_date, fs.unpublish_date,
ftmnu.inMenuStatus, mt.ext_link, mt.title,
ftmnu.parent_id, sum(mc.status) as stat, count(mc.status) as stat_count,
mc.locked_by, mc.status as content_status
FROM neo_files_to_menu ftmnu
INNER JOIN neo_filesystem fs ON
ftmnu.file_id = fs.id
LEFT JOIN neo_menuTitles mt
ON mt.uid = concat(fs.id, '_en')
LEFT JOIN neo_files_to_modules ftm
ON ftm.file_id = fs.id AND ftm.mod_name = 'mod_content'
LEFT JOIN neo_mod_content mc
ON mc.id = ftm.mod_id AND mc.status >= 0 AND mc.language = 'en'
WHERE ftmnu.parent_id = '24' AND ftmnu.inMenuStatus = 1
AND ftmnu.menu_id = '1'
group by id
ORDER BY ftmnu.sort_or in /home/httpd/vhosts/gdk.be/httpdocs/admin/includes/functions/database.php on line 48
Notice: 1030 - Got error 28 from table handler
SELECT fs.plugin, mt.image, mt.menu_text, fs.folder, fs.status, fs.id, fs.link_to,
fs.shortcut_to,
if (ftmnu.parent_id = fs.parent_id and fs.default_load = 1, 1, 0) as default_load, fs.publish_date, fs.unpublish_date,
ftmnu.inMenuStatus, mt.ext_link, mt.title,
ftmnu.parent_id, sum(mc.status) as stat, count(mc.status) as stat_count,
mc.locked_by, mc.status as content_status
FROM neo_files_to_menu ftmnu
INNER JOIN neo_filesystem fs ON
ftmnu.file_id = fs.id
LEFT JOIN neo_menuTitles mt
ON mt.uid = concat(fs.id, '_en')
LEFT JOIN neo_files_to_modules ftm
ON ftm.file_id = fs.id AND ftm.mod_name = 'mod_content'
LEFT JOIN neo_mod_content mc
ON mc.id = ftm.mod_id AND mc.status >= 0 AND mc.language = 'en'
WHERE ftmnu.parent_id = '54' AND ftmnu.inMenuStatus = 1
AND ftmnu.menu_id = '1'
group by id
ORDER BY ftmnu.sort_or in /home/httpd/vhosts/gdk.be/httpdocs/admin/includes/functions/database.php on line 48 Sitemap
News
Sitemap
