#sql
#quarry
#globustut
#commons: files from a specific user in a non-existing categories, #sql:

sql
SELECT
    img_name,
    cl_to AS missing_category
  FROM image
  JOIN actor ON actor_id = img_actor
  JOIN page ON page_namespace = 6 AND page_title = img_name
  JOIN categorylinks ON cl_from = page_id
  LEFT JOIN page AS cat
    ON cat.page_namespace = 14
   AND cat.page_title = cl_to
  WHERE actor_name = 'Globustut'
    AND cat.page_id IS NULL
  ORDER BY img_name;

https://quarry.wmcloud.org/query/101097

#belarus
#architecture
#castle
#globustut

Kosava Castle

Source

#saint
#scull
#fashion

Saint Francis of Assisi, by José de Ribera, 1643

Source

#belarus
#church
#globustut
#abandone

Source

#macOS: to install #git I need 25 GB

#monument
https://orda.of.by/.add/gallery.php?arabovschi/tail#belarus
#globustut
#airplane

Source

#wikipedia
#bewiki
#betarask

I was not active here.

The Earth, centred around #new_zealand

Source

Wow #wikipedia semi-automatic editing by a #python script

https://gitlab.com/vitaly-zdanevich/globustut-domain-move-on-wikipedia

Wow on #wikimedia_commons we can write #sql, for example to get red categories with files, for a specific user https://quarry.wmcloud.org/query/100891

#games
#gamazine
#igromania

Source

#belarus
#nature
#globustut
#year2004

Source

#belarus
#building
#globustut
#year2004

Source

#belarus
#building
#globustut
#year2004

Source

#belarus
#building
#globustut

Source

#belarus
#building
#globustut

Source

#belarus
#building
#globustut

Source

#belarus
#building
#globustut

Source

#belarus
#building
#globustut

Source

#belarus
#building
#globustut

Source