I am querying the products from a particular price book as below.
Select p.Name, p.Id, (Select Pricebook2Id, Product2Id From PricebookEntries where Pricebook2Id = '01sd0000000Pd8n') From Product2 p.
But above query is not evaluating the where condition.
I want to use this in pagination to show only related products based on pricebook.
Thanks in advance.