We are a commune of inquiring, skeptical, politically centrist, capitalist, anglophile, traditionalist New England Yankee humans, humanoids, and animals with many interests beyond and above politics. Each of us has had a high-school education (or GED), but all had ADD so didn't pay attention very well, especially the dogs. Each one of us does "try my best to be just like I am," and none of us enjoys working for others, including for Maggie, from whom we receive neither a nickel nor a dime. Freedom from nags, cranks, government, do-gooders, control-freaks and idiots is all that we ask for.
SELECT c.categoryid,
c.category_name,
c.category_icon,
c.category_description,
c.authorid,
c.category_left,
c.category_right,
c.parentid,
a.username,
a.username AS loginname,
a.realname
FROM csg_category AS c
LEFT OUTER JOIN csg_authors AS a
ON c.authorid = a.authorid
LEFT OUTER JOIN csg_authorgroups AS ag
ON ag.authorid = c.authorid
LEFT OUTER JOIN csg_access AS acl
ON (ag.groupid = acl.groupid AND acl.artifact_id = c.categoryid)
GROUP BY c.categoryid
ORDER BY category_name ASC
It's getting closer to the time to begin Christmas shopping. Whether you like Bezos or not, Amazon Prime is your friend. A daughter says Macy's is her friend now, too (the big store in Manhattan).
I am not convinced that the SAT is a measure of merit. It's really just an IQ test. Achievements tests are better merit measures but lots of schools do not have AP courses. Grades are not very reliable measures these days. If I ran a school, I'd use an IQ test, a Curiosity test, a Talent test, and an Energy test. No straight-A drones please.