exec sede_ineachdb @sqlcommand = ' select [$site name$] s...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Stack Overflow

Q&A for professional and enthusiast programmers

exec sede_ineachdb @sqlcommand = '
select 
       [$site name$] site
     , concat([$site url$], ''/tags/'', t.tagname, ''|'', t.tagname)  tagUrl
     , t.tagname
     , pe.body excerpt
     , pw.body wiki
     , t.count
from tags t 
inner join posts pe on pe.id = t.excerptpostid
inner join posts pw on pw.id = t.wikipostid
where t.tagname like ''##search##'' collate sql_latin1_general_cp1_ci_ai
or pe.body like ''##search##'' collate sql_latin1_general_cp1_ci_ai
or pw.body like ''##search##'' collate sql_latin1_general_cp1_ci_ai
'

Enter Parameters

Options:
Switch to meta site
loading Hold tight while we fetch your results