$limit=15; $offset=($this->page*$limit)-$limit; SELECT DISTINCT submission_id AS id FROM wppk_e_submissions_values LIMIT ".$offset.",".$limit;