User:Alephander/attributes: Difference between revisions

Line 59: Line 59:
             CONCAT('{{(}}qud text{{!}}&', CASE WHEN EgoBonus IS NOT NULL AND EgoBonus >= 0 THEN 'G+ ' ELSE 'R ' END,  
             CONCAT('{{(}}qud text{{!}}&', CASE WHEN EgoBonus IS NOT NULL AND EgoBonus >= 0 THEN 'G+ ' ELSE 'R ' END,  
                 CASE WHEN ObjectID = 'Cyclopean Prism' THEN '?' ELSE EgoBonus END, '{{)}}')=Ego,
                 CASE WHEN ObjectID = 'Cyclopean Prism' THEN '?' ELSE EgoBonus END, '{{)}}')=Ego,
             Description
             Description,
            Right(Description, 10) AS 'Desc10'
   | where = _pageNamespace = 0 AND Description LIKE '%Strength%'
   | where = _pageNamespace = 0 AND Description LIKE '%Strength%'
   | order by = _pageName ASC
   | order by = _pageName ASC
69

edits