Template:Query base passive skills/count: Difference between revisions
Jump to navigation
Jump to search
>Illviljan (Created page with "<includeonly>{{#cargo_query: |fields=COUNT(DISTINCT passive_skills.name) |tables={{#if: {{{tables|}}}|, {{{tables|}}}|}} |join on={{#if: {{{join|}}}|, {{{join|}}}|}} |where=...") |
>Illviljan mNo edit summary |
||
Line 1: | Line 1: | ||
<includeonly>{{#cargo_query: | <includeonly>{{#cargo_query: | ||
|fields=COUNT(DISTINCT passive_skills.name) | |fields=COUNT(DISTINCT passive_skills.name) | ||
|tables={{#if: {{{tables|}}}|, {{{tables|}}}|}} | |tables=passive_skills, passive_skill_stats{{#if: {{{tables|}}}|,{{{tables|}}}|}} | ||
|join on={{#if: {{{join|}}}|, {{{join|}}}|}} | |join on=passive_skills._pageID=passive_skill_stats._pageID{{#if: {{{join|}}}|,{{{join|}}}|}} | ||
|where= | |where= | ||
passive_skills.connections__full IS NOT NULL | passive_skills.connections__full IS NOT NULL |