- PUBPAGE_MENULEFT_ABOUT_US
- PUBPAGE_MENULEFT_ACCESS
- PUBPAGE_MENULEFT_RESEARCH
- PUBPAGE_MENULEFT_EVENT
- PUBPAGE_MENULEFT_PUBLICATION
- PUBPAGE_MENULEFT_PUBRECENT
- PUBPAGE_MENULEFT_DIJPUBLICATIONS
- PUBPAGE_MENULEFT_JAPANSTUDIEN
- PUBPAGE_MENULEFT_MONOGRAPHS
- PUBPAGE_MENULEFT_BIBLIOGRAPHS
- PUBPAGE_MENULEFT_COLLOQUIA
- PUBPAGE_MENULEFT_MISCELLANEA
- PUBPAGE_MENULEFT_WORKINGPAPERS
- PUBPAGE_MENULEFT_NEWSLETTER
- PUBPAGE_MENULEFT_CATALOGUE
- PUBPAGE_MENULEFT_MOVIES
- PUBPAGE_MENULEFT_BULLETIN
- PUBPAGE_MENULEFT_LIBRARY
- PUBPAGE_MENULEFT_WEBRES
- PUBPAGE_MENULEFT_INSTLINKS
-
Error in query - 1054 - Unknown column '_data' in 'field list'
SQL:
select
l.id id,
l.type_id type_id,
t1.value_en/_data label,
t2.value_en/_data type,
t3.value_en/_data note,
t4.value_en/_data url
from
links l
left outer join object_textvalues_col t1
on t1.text_id = l.label_txtid
left outer join object_textvalues_col t3
on t3.text_id = l.note_txtid
left outer join object_textvalues_col t4
on t4.text_id = l.url_txtid
left outer join link_types lt on
l.type_id = lt.id
left outer join object_textvalues_col t2
on t2.text_id = lt.name_txtid
where
l.type_id <> '5'
order by
type, sort_order, label
| |||||||||||||||
