User Tools

Site Tools


american_dad:combo_cards:air_guitar_stan

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revision Previous revision
Next revision
Previous revision
american_dad:combo_cards:air_guitar_stan [2017/02/13 08:44]
mikepardon
american_dad:combo_cards:air_guitar_stan [2017/02/13 23:18] (current)
Line 12: Line 12:
 <​html></​div></​html>​ <​html></​div></​html>​
  
-====== ​Air Guitar Stan ====== +====== ​Hank Hell's Haunted House ====== 
-Description ​to be added.+<​sql><​0>​Description</​0><​sqlstart>​Select D.Description from CardDescs D left join Cards C on C.ID = D.CardID where C.Name = '​THISCARD'​ and C.Commander <> 1</​sqlstart></​sql>​
  
 <​html><​div style="​float:​ none;"></​html>​ <​html><​div style="​float:​ none;"></​html>​
Line 32: Line 32:
 inner join Cards C on C.ID = CL.CardID inner join Cards C on C.ID = CL.CardID
 inner join CardLevelConvert CLC on CLC.Level = CL.Level inner join CardLevelConvert CLC on CLC.Level = CL.Level
- 
-where C.Name = '​THISCARD'​ and C.Commander <> 1 group by C.Name, CL.Level Order by C.Name, CL.Level </​sqlstart></​sql>​ <​html></​div></​html>​ 
- 
-** Combos ** 
-<sql> 
-<​0>​ComboList</​0>​ 
-<​sqlstart>​ 
-select c1.Name as 'Combo Card' 
-, case when c3.Name = '​THISCARD'​ then c2.Name else c3.Name end as '​Combos With' 
-from Combos C 
-left join Cards c1 on c1.ID = C.EndCard 
-left join Cards c2 on c2.ID = C.Card1 
-left join Cards c3 on c3.ID = C.Card2 
-where c2.Name = '​THISCARD'​ or c3.Name = '​THISCARD'​ and c2.Name is not null order by c1.Name, c3.Name 
- 
-</​sqlstart>​ 
-</​sql>​ 
  
american_dad/combo_cards/air_guitar_stan.txt · Last modified: 2017/02/13 23:18 (external edit)