I am trying to add where in collection but it return
Varien_Db_Select Object
instead of return collection object.
$collection = Mage::getModel('orderoutofuk/orderitem')->getCollection()->getSelect()->where('main_table.send_payment_request_date >= DATE(NOW()) - INTERVAL 7 DAY ');
and I want specific column value in array instead of looping through each object.