Buscar um produto em junção de 3 tabelas?

public static function getPageSearch($search, $page = 1, $itemsPerPage = 10)
	{

		$start = ($page - 1) * $itemsPerPage;

		$sql = new Sql();

		$results = $sql->select("
			SELECT SQL_CALC_FOUND_ROWS *,name_artistas
			FROM tb_products p join tb_artistas a on (p.idartistas = a.idartistas) join tb_situacao s and (p.idsituacao = s.idsituacao) where
			 name_artistas LIKE :search  or observacao like :search or idproduct like :search 
			ORDER BY name_artistas
			LIMIT $start, $itemsPerPage;
		", [
			':search'=>'%'.$search.'%'
		]);