I have a query which joins several tables, the query works fine until I try to incorporate pagination into the mix. To do so I need to add another on condition but I cannot seem to make it work.
(edit MYSQL/PHP)

The original query which works just fine is this:

FROM (table1
LEFT JOIN table2
ON table1.id = table2.id)

LEFT JOIN table3
ON table1.id = table3.id

LEFT JOIN table4
ON table1.id = table4.id

LEFT JOIN table5
ON table1.id = table5.id ORDER BY table1.id DESC LIMIT 10;";

Then I try to add another condition at the end.

FROM (table1
LEFT JOIN table2
ON table1.id = table2.id)

LEFT JOIN table3
ON table1.id = table3.id

LEFT JOIN table4
ON table1.id = table4.id

LEFT JOIN table5
ON table1.id = table5.id < '$lid' ORDER BY table1.id DESC LIMIT 10;";

It fails! It still gets results, it just does not limit them.

Any one have any ideas? Is what I am trying to do even possible using this method?
Any help greatly appreciated.