Public feed #888309

Unnamed

public text v1 · immutable
Raw Edit
·published 2008-02-02 00:23 UTC
rendered paste body
one page of one object:

SELECT left_table.* from crm_project left_table WHERE 1 ORDER BY project_id desc LIMIT 0, 20

one page with a join, making 2 objects:

SELECT left_table.* , `RIGHT_TABLE_0`.`title`,`RIGHT_TABLE_0`.`type`,`RIGHT_TABLE_0`.`asset_id` from block left_table LEFT JOIN media_asset AS RIGHT_TABLE_0 ON left_table.genre = RIGHT_TABLE_0.asset_id WHERE 1 ORDER BY blockid desc LIMIT 0, 20