<?php
$past_months_total = DB::query(Database::SELECT, 'SELECT COUNT(*) as uploaded FROM `photos`
WHERE `photos`.`created`
BETWEEN DATE_SUB(NOW(), INTERVAL 30 DAY) AND NOW()
AND `photos`.`user_id` = '. $this->user->id)->execute();