Performing an arbitrary number of self joins in mySQL
2880
MySQL dynamic cross tab
97639
Combine multiple rows into one MySQL Join
108832
Is a join optimized to a where clause at runtime?
11223
quick selection of a random row from a large table in mysql
152775
Alternative to Intersect in MySQL
22863
How to find all the tables in MySQL with specific column names in them?
95678
MYSQL: How to select all attributes of all duplicate entries?
105434
How do I select random rows in MySQL?
17548
How to join on the same table multiple times?
35704
How do you join on the same table, twice, in mysql?
95318
Retrieving Multiple Result sets with stored procedure in php/mysqli
64176
MySQL - Selecting data from multiple tables all with same structure but different data
16089
MySQL single table static and dynamic pivot
107938
How to handle fragmentation of auto_increment ID column in MySQL
124308
Simulating MySQL's ORDER BY FIELD() in Postgresql
65215
mysql select from n last rows
33417
Tune a simple inner join query