Skip to content

Instantly share code, notes, and snippets.

@JGrubb

JGrubb/gist:cafaec7661a609e051d255c703640873

Created June 2, 2016 03:00
Show Gist options
  • Save JGrubb/cafaec7661a609e051d255c703640873 to your computer and use it in GitHub Desktop.
Save JGrubb/cafaec7661a609e051d255c703640873 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
gistfile1.txt
mysql> select * from field_data_field_taxonomy where entity_id = 26221;
+-------------+---------------------+---------+-----------+-------------+----------+-------+--------------------+
| entity_type | bundle | deleted | entity_id | revision_id | language | delta | field_taxonomy_tid |
+-------------+---------------------+---------+-----------+-------------+----------+-------+--------------------+
| node | legacy_content_item | 0 | 26221 | 26221 | und | 0 | 12 |
+-------------+---------------------+---------+-----------+-------------+----------+-------+--------------------+
1 row in set (0.00 sec)
mysql> select * from taxonomy_index where nid = 26221;
+-------+-----+--------+------------+
| nid | tid | sticky | created |
+-------+-----+--------+------------+
| 26221 | 476 | 0 | 1464810080 |
| 26221 | 12 | 0 | 1464810080 |
| 26221 | 13 | 0 | 1464810080 |
+-------+-----+--------+------------+
3 rows in set (0.00 sec)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment