| SELECT DISTINCT(CONCAT("Q",ips_item_id)) as Item, name.wbx_text as Name,... |
4 months ago |
| SELECT DISTINCT(CONCAT("Q",ips_item_id)) as Item, COALESCE(MAX(CASE WHEN... |
4 months ago |
| SELECT DISTINCT(CONCAT("Q",ips_item_id)) as Item, Name, Description,... |
4 months ago |
| SELECT DISTINCT(CONCAT("Q",ips_item_id)) as Item, COALESCE(wbx_text,... |
4 months ago |
| SELECT DISTINCT(CONCAT("Q",ips_item_id)) as Item, COALESCE(wbx_text,... |
4 months ago |
| SELECT CONCAT("Q",DISTINCT(ips_item_id)) as Item, COALESCE(wbx_text,... |
4 months ago |
| SELECT CONCAT("Q",ips_item_id) as Item, Number of articles
FROM (
SELECT... |
4 months ago |
| SELECT CONCAT("Q",ips_item_id) as Item, COALESCE(wbx_text, 'UNKNOWN') as... |
4 months ago |
| SELECT CONCAT("Q",ips_item_id) as Item, COALESCE(wbx_text, 'UNKNOWN') as... |
4 months ago |
| SELECT CONCAT("Q",ips_item_id) as Item, CASE WHEN wbx_text IS NOT NULL THEN... |
4 months ago |
| SELECT CONCAT("Q",ips_item_id) as Item, COALESCE(wbt_text.wbx_text,... |
4 months ago |
| SELECT CONCAT("Q",ips_item_id), COUNT(ips_site_id) as number_of_wikis
FROM... |
4 months ago |
| SELECT ips_item_id, COUNT(ips_site_id) as number_of_wikis
FROM... |
4 months ago |
| SELECT ips_item_id
FROM wb_items_per_site
WHERE ips_item_id NOT IN (
SELECT... |
4 months ago |
| SELECT ips_item_id
FROM wb_items_per_site
WHERE ips_item_id NOT IN (
SELECT... |
4 months ago |
