User:Reza1615/query

wb_items
+-------------+----------------+------------------+---------------+-------------+----------------------------------------+
| term_row_id | term_entity_id | term_entity_type  | term_language| term_type |term_text
+-------------+----------------+------------------+---------------+-------------+----------------------------------------+
|           5 |          11175 | item             | en            | description | The caret. An inverted V-shaped 
|           7 |          11175 | item             | en            | label       | 
|          29 |          11590 | item             | en            | description | American mathematician and
+-------------+----------------+------------------+---------------+-------------+-----------------------------------------+

wb_items_per_site
+------------+-------------+-------------+---------------------------+
| ips_row_id | ips_item_id | ips_site_id | ips_site_page             |
+------------+-------------+-------------+---------------------------+
|    2990697 |     4540205 | enwiki      | ! (album)                 |
|   22535161 |      117929 | enwiki      | " (disambiguation)        |
|    2990715 |     2547578 | enwiki      | "300"                     |
|    2990716 |     4540209 | enwiki      | "9" (Alice Nine album)    |
+------------+-------------+-------------+---------------------------+

SELECT ips_row_id,ips_item_id ,ips_site_id,ips_site_page FROM `wb_items_per_site` WHERE ips_site_id= 'enwiki' LIMIT 20;

SELECT term_row_id,term_entity_id,term_entity_type,term_language,term_type ,term_text FROM `wb_terms` WHERE term_language = 'en' LIMIT 20;