lvwiki esošie attēli, kas Commons ir ar citu nosaukumu

This query is marked as a draft This query has been published by Edgars2007.

4000 (laikam pāri 4100)

SQL

SELECT
#CONCAT('#[[:Attēls:',DISTINCT(lvwiki_p.page.page_title),']]') as "Nosaukums lvwiki",
  DISTINCT(lvwiki_p.page.page_title) as "Nosaukums lvwiki",
  commonswiki_p.image.img_name as "Nosaukums Commons",
  lvwiki_p.imagelinks.il_from
FROM lvwiki_p.image, commonswiki_p.image, lvwiki_p.categorylinks, lvwiki_p.page
left join lvwiki_p.imagelinks on lvwiki_p.imagelinks.il_to=lvwiki_p.page.page_title
WHERE lvwiki_p.image.img_sha1 = commonswiki_p.image.img_sha1 and lvwiki_p.page.page_title != commonswiki_p.image.img_name
and lvwiki_p.page.page_title like "%COA%"
AND lvwiki_p.page.page_title = lvwiki_p.image.img_name
AND lvwiki_p.categorylinks.cl_from = lvwiki_p.page.page_id
AND lvwiki_p.image.img_sha1 != 'phoiac9h4m842xq45sp7s6u21eteeq1'
order by lvwiki_p.imagelinks.il_from
limit 500;
/* veca versija
SELECT
#CONCAT('#[[:Attēls:',DISTINCT(lvwiki_p.page.page_title),']]') as "Nosaukums lvwiki",
  DISTINCT(lvwiki_p.page.page_title) as "Nosaukums lvwiki",
  commonswiki_p.image.img_name as "Nosaukums Commons"
FROM lvwiki_p.image, commonswiki_p.image, lvwiki_p.categorylinks, lvwiki_p.page
WHERE lvwiki_p.image.img_sha1 = commonswiki_p.image.img_sha1 and lvwiki_p.page.page_title != commonswiki_p.image.img_name
AND lvwiki_p.page.page_title = lvwiki_p.image.img_name
AND lvwiki_p.categorylinks.cl_from = lvwiki_p.page.page_id
AND lvwiki_p.image.img_sha1 != 'phoiac9h4m842xq45sp7s6u21eteeq1';
*/

AخA
 
SELECT#CONCAT('#[[:Attēls:',DISTINCT(lvwiki_p.page.page_title),']]') as "Nosaukums lvwiki",  DISTINCT(lvwiki_p.page.page_title) as "Nosaukums lvwiki",  commonswiki_p.image.img_name as "Nosaukums Commons",  lvwiki_p.imagelinks.il_fromFROM lvwiki_p.image, commonswiki_p.image, lvwiki_p.categorylinks, lvwiki_p.pageleft join lvwiki_p.imagelinks on lvwiki_p.imagelinks.il_to=lvwiki_p.page.page_titleWHERE lvwiki_p.image.img_sha1 = commonswiki_p.image.img_sha1 and lvwiki_p.page.page_title != commonswiki_p.image.img_nameand lvwiki_p.page.page_title like "%COA%"AND lvwiki_p.page.page_title = lvwiki_p.image.img_nameAND lvwiki_p.categorylinks.cl_from = lvwiki_p.page.page_idAND lvwiki_p.image.img_sha1 != 'phoiac9h4m842xq45sp7s6u21eteeq1'order by lvwiki_p.imagelinks.il_fromlimit 500;/* veca versijaSELECT#CONCAT('#[[:Attēls:',DISTINCT(lvwiki_p.page.page_title),']]') as "Nosaukums lvwiki",  DISTINCT(lvwiki_p.page.page_title) as "Nosaukums lvwiki",  commonswiki_p.image.img_name as "Nosaukums Commons"FROM lvwiki_p.image, commonswiki_p.image, lvwiki_p.categorylinks, lvwiki_p.pageWHERE lvwiki_p.image.img_sha1 = commonswiki_p.image.img_sha1 and lvwiki_p.page.page_title != commonswiki_p.image.img_nameAND lvwiki_p.page.page_title = lvwiki_p.image.img_nameAND lvwiki_p.categorylinks.cl_from = lvwiki_p.page.page_idAND lvwiki_p.image.img_sha1 != 'phoiac9h4m842xq45sp7s6u21eteeq1';*/

By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.

Submit Query Stop Query

All SQL code is licensed under CC0 License.

SQL

Checking query status...