Topic on Talk:Quarry

Saeidpourbabak (talkcontribs)

Hello,

This query finds parent and child categories of a particular article. It works properly when displaying either child or parent in different runs (by editing the 3rd line), but fails to display both in one run and gets stuck. Any idea what is wrong? Thanks.

P.S: I noticed that as the header it writes "cl_to" (and not "chld.cl_to"). Does it give a hint?

Saeidpourbabak (talkcontribs)

The problem is solved by adding titles to the headings in line 3:

SELECT page_title, chld.cl_to, prnt.cl_to > SELECT page_title page, chld.cl_to child_category, prnt.cl_to parent_category