SQL: Phrase Construction Review

About

This report shows all phrases in your Phrase Construction Notebooks and where those phrases are located.

A sample image of this SQL report run in the Database Viewer is shown below:

Caveats

None.

Code

To highlight and copy the code below to your clipboard, simply click the Copy button.

select notebooks.userid, notebooktitle,  notebooks_data.volume, label_data, rowscount, columnscount from notebooks_data
inner join notebook_titles on notebook_titles.volumeid = notebooks_data.volumeid
inner join notebooks on notebooks.notebook_id = notebook_titles.notebook_id