A.R:B=Q
james_garfield.pres_order:first=20
chester_arthur.pres_order:first=21
grover_cleveland.pres_order:first=22
benjamin_harrison.pres_order:first=23
grover_cleveland.pres_order:second=24
william_mckinley.pres_order:first=25
theodore_roosevelt.pres_order:first=26
william_taft.pres_order:first=27
woodrow_wilson.pres_order:first=28
warren_harding.pres_order:first=29
calvin_coolidge.pres_order:first=30
/* SQL */
SELECT m.* FROM meme m JOIN (SELECT aid FROM meme GROUP BY aid HAVING SUM(CASE WHEN (rid='pres_order' AND qnt>=20) THEN 1 ELSE 0 END) > 0 AND SUM(CASE WHEN (rid='pres_order' AND qnt<=30) THEN 1 ELSE 0 END) > 0) AS aids ON m.aid = aids.aid WHERE (rid='pres_order' AND qnt>=20) OR (rid='pres_order' AND qnt<=30);
Example Queries (Help)
qry.all Show all data in this DB.
george_washington All about George Washington.
.child Who were children of the presidents?
:lawyer Which presidents were lawyers?
.college:harvard Which presidents attended Harvard for college?
.pres_order=10 Who was the tenth president?
.college:columbia .occupation:lawyer Which presidents attended Columbia and were lawyers?
.pres_order>=20 .pres_order<=30 Who were the twentieth through thirtieth presidents?
.pres_order .child=f Which presidents did NOT have children?
.pres_order>=20 .pres_order<=30 .spouse=g Who were the spouses of the twentieth through thirtieth presidents?
.college:harvard .college:columbia qry.all Use qry.all to return all memes related to the matching As.
james_carter; ronald_reagan Get all about James Carter as well as Ronald Reagan