Timeline for How many times has my question been cited?
Current License: CC BY-SA 3.0
14 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Mar 23, 2016 at 16:21 | comment | added | Emilio Pisanty | @tpg2114 If you're looking for in-site links, it would probably be easiest to use the PostLinks table as in ACuriousMind's query (a small change to this one should do it). But a challenge can also be fun. | |
| Mar 23, 2016 at 13:00 | comment | added | tpg2114 | @EmilioPisanty I was trying to build it, but ran out of SQL expertise and the time needed to finish it... maybe somebody can come along and finish it off for me. Although the query works as intended for physics.SE, it doesn't work for other sites (even though I want it to) and it's ugly/repetitive. If I can finish off my other work, I can return to it. | |
| Mar 23, 2016 at 2:01 | comment | added | Emilio Pisanty | @tgpg2114 Indeed the intention on that one was to include all links, though I cannot really remember why that was. (There was some reason, though.) Are you building a version with only in-house links? Yikes, that sounds ugly. | |
| Mar 22, 2016 at 17:52 | comment | added | tpg2114 | @EmilioPisanty If you want to finish off my updated query, I have run out of time on it -- data.stackexchange.com/physics/query/454674/… This will only count links to the site that the query is run on (so if you are looking at physics.SE, it will only count the links to other posts on physics.SE). But -- the DB_NAME(db_id()) should be put into a variable and the parsing statement RIGHT(... should also be stored, rather than repeated. And the magic numbers 14 and 13 should be 8+LEN(storedName) and 7+. | |
| Mar 22, 2016 at 15:27 | comment | added | tpg2114 | And it seems @JohnRennie shared in my expectation/confusion based on his edit to the answer below... | |
| Mar 22, 2016 at 15:26 | comment | added | tpg2114 | @EmilioPisanty Your query seems to include all links, not just links to other SE Q&A. Perhaps that was the intention, but I was expecting something that sorted based on number of times a post refers to other posts on the site. Not that I am suggesting changes (if changes were even possible), but I was surprised by the result. | |
| Mar 22, 2016 at 12:13 | comment | added | Emilio Pisanty | No worries, that was maybe an excess of tongue-in-cheekiness. Now that we're on the subject, though, the converse is Posts by a user ordered by number of links they contain. Not that I'm bringing that up in a comparative spirit or anything đŸ˜‰. | |
| Mar 22, 2016 at 12:07 | comment | added | John Rennie | @EmilioPisanty: somehow I had managed to miss the More links hyperlink that gives you the list of linked questions and the total number of links. But in any case what I really wanted was a report like the one ACuriousMind found and that tgp2114 has tweaked further. | |
| Mar 22, 2016 at 11:56 | comment | added | Emilio Pisanty | I'm confused. Is this not provided by the link see more linked questions… in the Linked sidebar of questions with more links than can be displayed there (e.g. this one)? | |
| Mar 21, 2016 at 19:06 | vote | accept | John Rennie | ||
| Mar 21, 2016 at 14:09 | history | edited | QmechanicMod | CC BY-SA 3.0 | distinguish between reference vs citation |
| Mar 21, 2016 at 13:46 | answer | added | David ZMod | timeline score: 6 | |
| Mar 21, 2016 at 13:30 | answer | added | ACuriousMindMod | timeline score: 6 | |
| Mar 21, 2016 at 13:10 | history | asked | John Rennie | CC BY-SA 3.0 |