Not tagged answers

0

Please login or register to vote for this query.

(click on this box to dismiss)

Esperanto Language

Q&A for teachers and students of the Esperanto language

select p.Id, p.ParentId, p.Score, p.PostTypeId, ans.Tags, 'https://stackoverflow.com/questions/' + CONVERT(VARCHAR(12), p.ParentId)
from Posts p
inner join Posts ans on p.ParentId = ans.Id
where p.OwnerUserId = 7606764
and p.PostTypeId = 2
and p.Score > 0
and len(ans.Tags) - len(replace(ans.Tags, '<', '')) < 5
and p.ParentId not in (63609320, 63967245, 63704389, 63355822, 62493385, 64498229, 62393531, 63354179, 62147472, 62395299, 62739225, 63463469, 62168203, 61492744, 62650242, 62503091, 62419822, 61430364, 61273078, 61192687, 61181797, 61472929, 61426794, 61181871, 61360961, 61482185, 61151734, 61244155, 61173133, 61193994, 61435759, 61420637, 60792773, 60896483, 61003063, 58346334, 60753268, 60642332, 55849682, 60502178, 60484577, 60784376, 60768221, 60737489, 60638147, 60466931, 60432670, 60427503, 49689317, 58109390, 58046438, 55177945, 54987423, 60709540, 57864403, 57791992, 57725741, 57620510, 55804473, 55750957, 55373464, 55193680, 55086628, 54887483, 60594998, 49681524, 55032293, 55193861, 60612490, 60641793, 55074963, 55171820, 55357184, 55683081, 55327417, 60474508, 60463641, 60457623, 60437409, 60420743, 60399499, 60397257, 60307961, 60065038, 60101124, 60065038, 59825870, 59782149, 59442046, 59414954, 59274566, 58900008, 59236809, 58688304, 58460771, 58263626, 58003509, 57781269, 57849271, 57781263, 57728260, 56624987, 55729360, 55747079, 54712454, 54736891, 55066007, 55079986, 55218484, 55314217, 55321500, 55411389, 60457623, 60690813, 54987423, 60446258, 60853196, 60854224, 60853196, 60868238, 60887009, 60784376, 55162003, 61058232, 61152498, 61050709, 61070979)
order by p.Score, p.Id

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results