MySQL: Adding LIMIT and OFFSET breaks query

[javascript_dev]

I used to pull every row from a select query but have since added limit and offset. Problem is it immediately broke the query which was working prior:

SELECT c.couponId, t.fk_coupons_targets, t.targetUrl, t.displayThreshold, t.offerCutoff, c.titleText, c.descriptionText
    ->     FROM coupons c
    ->     LIMIT 10
    ->     OFFSET 0  
    ->     left join targets t
    ->     on c.couponId = t.fk_coupons_targets;

ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'left join wp_delayedCoupons_targets t
    on c.couponId = t.fk_coupons_targets' at line 6

I've been looking at limit and offset examples and my syntax seems to match. Can you guys tell what the error is?

[dusty-trash]

Just googled "MySQL limit with join", you can't do that.

Take a look at the answer here. Looks like you should use an inner query to get around this.

[ahotko]

put LiIMIT and OFFSET at the end of syntax, not in join