A.R:B=Q
george_washington.time_served:year=8
john_adams.time_served:year=4
thomas_jefferson.time_served:year=8
james_madison.time_served:year=8
james_monroe.time_served:year=8
john_quincy_adams.time_served:year=4
andrew_jackson.time_served:year=8
martin_van_buren.time_served:year=4
william_harrison.time_served:year=1
john_tyler.time_served:year=3
james_polk.time_served:year=4
zachary_taylor.time_served:year=1
millard_fillmore.time_served:year=3
franklin_pierce.time_served:year=4
james_buchanan.time_served:year=4
abraham_lincoln.time_served:year=4
andrew_johnson.time_served:year=3
ulysses_grant.time_served:year=8
rutherford_hayes.time_served:year=4
chester_arthur.time_served:year=4
grover_cleveland.time_served:year=8
benjamin_harrison.time_served:year=4
william_mckinley.time_served:year=4
theodore_roosevelt.time_served:year=8
william_taft.time_served:year=4
woodrow_wilson.time_served:year=8
warren_harding.time_served:year=2
calvin_coolidge.time_served:year=6
herbert_hoover.time_served:year=4
franklin_roosevelt.time_served:year=12
harry_truman.time_served:year=8
dwight_eisenhower.time_served:year=8
john_kennedy.time_served:year=3
lyndon_johnson.time_served:year=5
richard_nixon.time_served:year=5
gerald_ford.time_served:year=2
james_carter.time_served:year=4
ronald_reagan.time_served:year=8
george_bush.time_served:year=4
william_clinton.time_served:year=8
george_hw_bush.time_served:year=8
barack_obama.time_served:year=8
donald_trump.time_served:year=4
/* SQL */
SELECT * FROM meme WHERE bid='year' AND qnt!=0;
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