Export from MySQL

Hi all,

We'd like to export two fields (title & item_id) for a collection with 5k items ... but title doesn't seem to have its own field in the 'element_texts' table ... is there an easy or better way to do this?

Thanks in advance!

Things in the element_texts table, like Dublin Core data, aren't stored in separate fields or columns, they're identified by particular element_id values. The Dublin Core Title element ID is generally 50.

If you just want those two values, they should be directly retrievable by looking at the element_texts table and selecting only the rows with the Item record type and the right element_id.