Results

ARBQ
john_adamschildjohn_quincy_adams1
john_quincy_adamspresident_orderfirst6
george_hw_bushchildgeorge_w_bush1
george_w_bushpresident_orderfirst43

Code

Memelang:  .child.president_order

SQL:  SELECT m0.aid as aid, CONCAT(m0.rid, ' ', m1.rid) AS rid, CONCAT(m0.bid, ' ', m1.bid) AS bid, CONCAT(m0.qnt, ' ', m1.qnt) AS qnt FROM meme m0 JOIN meme m1 ON m0.bid=m1.aid WHERE m0.rid='child' AND m1.rid="president_order" AND m0.qnt!=0 AND m1.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