|
|
|
Data
|
papers, year, month, with text or citation references to ModelDB
|
Pre-sql server version (oracle): select papers.object_id as OBJECTID,papers.object_name as PAPERNAME, paperusage.object_name as USAGE, year.value_ as pubyear, pub_month.value_ as pubmonth from
eav_string year, objects papers, eav_objects statedusage, objects paperusage,
eav_string pub_month
where papers.object_class=42 and
statedusage.attribute_id=452 and
papers.object_id=statedusage.object_id and
paperusage.object_id=statedusage.value_ AND
year.OBJECT_ID(+) = papers.OBJECT_ID AND
year.ATTRIBUTE_ID(+) = 154 and
pub_month.object_id(+) = papers.object_id and
pub_month.attribute_id(+) = 156
ORDER BY year.VALUE_(+) DESC, pubmonth(+) desc, papers.object_name
|
select papers.object_id as OBJECTID,papers.object_name as PAPERNAME, paperusage.object_name as USAGE, year.value_ as pubyear, pub_month.value_ as pubmonth from eav_string year, objects papers, eav_objects statedusage, objects paperusage, eav_string pub_month where papers.object_class=42 and statedusage.attribute_id=452 and papers.object_id=statedusage.object_id and paperusage.object_id=statedusage.value_ AND year.OBJECT_ID = papers.OBJECT_ID AND year.ATTRIBUTE_ID = 154 and pub_month.object_id = papers.object_id and pub_month.attribute_id = 156 ORDER BY year.VALUE_ DESC, pubmonth desc, papers.object_name
|
|
|
|
|