List/table with all creative work NIDs

[AlvaroSeica]

@steinmb could you fetch me this for class?

[AlvaroSeica]

@steinmb could you fetch me this for class during this week, max. on Wednesday, Sep. 6?

[steinmb]

Me fix! So Only the NID nothing else? Sorted by NID or do you sort it your self in excel etc anyway?

[steinmb]

While waiting for feedback. Here is the list of only the nid.

SELECT nid FROM node WHERE type = 'work' ORDER BY nid;

elmcip_all_work_nid.csv.zip

[AlvaroSeica]

@steinmb brilliant! thanks much! Just a CSV like that is perfect. Basically, we will be working with cross-ref Platform in ALL creative works during the semester so that we get that covered and done. Interestingly enough, the live site lists at https://elmcip.net/work 2852 records while your CSV lists 2854 records!

[steinmb]

2852 records while your CSV lists 2854 records!

It might be a few unpublished nodes. In my query I did not check the publish state.

[steinmb]

Yes, these two exist but are unpublished.

SELECT nid, title  FROM node WHERE type = 'work' AND status = 0 ORDER BY nid;

+------+----------+
| nid  | title    |
+------+----------+
| 7304 | FLUX RSS |
| 7305 | FLUX RSS |
+------+----------+
2 rows in set (0.00 sec)

[AlvaroSeica]

It makes sense! Thanks