Results

ARBQ
john_adamslawyervarious1
thomas_jeffersonlawyervarious1
james_madisonlawyervarious1
james_monroelawyervarious1
andrew_jacksonlawyervarious1
martin_van_burenlawyervarious1
john_tylerlawyervarious1
james_polklawyervarious1
millard_fillmorelawyervarious1
franklin_piercelawyervarious1
james_buchananlawyervarious1
abraham_lincolnlawyervarious1
rutherford_hayeslawyervarious1
chester_arthurlawyervarious1
grover_clevelandlawyervarious1
benjamin_harrisonlawyervarious1
william_mckinleylawyervarious1
william_taftlawyervarious1
calvin_coolidgelawyervarious1
franklin_rooseveltlawyervarious1
barack_obamalawyervarious1

Code

Memelang:  .lawyer

SQL:  SELECT * FROM meme m0 WHERE m0.rid='lawyer' 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