Results

ARBQ
john_quincy_adamssenatorusa1
andrew_jacksonsenatorusa1
martin_van_burensenatorusa1
john_tylersenatorusa1
franklin_piercesenatorusa1
james_buchanansenatorusa1
abraham_lincolnsenatorusa1
andrew_johnsonsenatorusa1
benjamin_harrisonsenatorusa1
warren_hardingsenatorusa1
harry_trumansenatorusa1
john_kennedysenatorusa1
lyndon_johnsonsenatorusa1
richard_nixonsenatorusa1
barack_obamasenatorusa1
joseph_bidensenatorusa1

Code

Memelang:  .senator

SQL:  SELECT * FROM meme m0 WHERE m0.rid='senator' AND m0.qnt!=0;

Memelang Demo

This is demonstration of translating Memelang to SQL for querying relational databases. See the PHP code in GitHub. A Python implementation is coming soon. Example queries:

Show all data in the database.

qry.all

All about George Washington.

george_washington

Who were children of the presidents?

.child

Which presidents were members of the Whig party?

.party:whig

Which presidents were born before 1820?

.birth.year:ad<1820

Which presidents attended Columbia and were lawyers?

.college:columbia .lawyer

Who were the spouses of the twentieth through thirtieth presidents?

.president_order>=20 .president_order<=30 .spouse

Which presidents did not have children?

.president_order .child=f

Use qry.all to return all memes related to the matching As.

.college:harvard .college:columbia qry.all

Get all about James Carter as well as Ronald Reagan.

james_carter; ronald_reagan

Which presidents were lawyers that attended Harvard or William and Mary?

.lawyer .college:harvard=t1 .college:william_and_mary=t1

What were the professions of the presidents?

?profession

What were the professions of George Washington?

george_washington?profession

Which presidents previously worked for New York state?

new_york'?profession

Which presidents has children that became presidents?

.child.president_order