Welcome! Thanks for stopping by.

Array
(
    [pass] => Array
        (
        )

    [named] => Array
        (
        )

    [site] => moovein.com
    [id] => 9
    [plugin] => 
    [controller] => coupons
    [action] => feed
    [form] => Array
        (
        )

    [url] => Array
        (
            [url] => coupons/feed/moovein.com/9
        )

)

SELECT Coupon.*  FROM `coupons` AS `Coupon`
               LEFT JOIN related_coupons rc ON rc.coupon_id = Coupon.id
               LEFT JOIN locations ON rc.location_id = locations.id
               WHERE 1=1 AND end_date > NOW() AND NOW() > start_date
                AND locations.website = 'moovein.com