| A | .R | :B | =Q |
|---|---|---|---|
| barack_obama | .college | :columbia | =1 |
| barack_obama | .occupation | :lawyer | =1 |
/* SQL */ SELECT m.* FROM meme m JOIN (SELECT aid FROM meme GROUP BY aid HAVING SUM(CASE WHEN (rid='college' AND bid='columbia') THEN 1 ELSE 0 END) > 0 AND SUM(CASE WHEN (rid='occupation' AND bid='lawyer') THEN 1 ELSE 0 END) > 0) AS aids ON m.aid = aids.aid WHERE (rid='college' AND bid='columbia') OR (rid='occupation' AND bid='lawyer');
| 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 |