gistfile1.php

<?php
$posts = DB::table('posts')
	->join('image_post', 'posts.id', '=', 'image_post.post_id')
	->join('images', 'image_post.image_id', '=', 'images.id')
	->join('artist_post', 'posts.id', '=', 'artist_post.post_id')
	->join('artists', 'artist_post.artist_id', '=', 'artists.id')
	->where('posts.category', '!=', 'news')
	->where('posts.status', '=', 'published')
	->order_by('posts.created_at', 'desc')
	->distinct()
	->paginate($per_page, array('posts.id', 'artists.name', 'artists.forename', 'artists.surname', 'posts.title', 'posts.slug', 'posts.category', 'posts.created_at', 'images.saved_to', 'images.filename'));