products with selling price query

SELECT product.sku, product.name, product.short_description, product.description, product.price
       , product.uri, product.weight, product.priority, product.gtin, product.canonical_sku
       , product.active, product.inventory_exempt, product.created, product.last_modified
       , price_modifier.selling_price
  FROM navigation_products me
  JOIN products product
  ON product.sku = me.sku
  LEFT JOIN ( SELECT me.sku, MIN (me.price) AS selling_price
                FROM price_modifiers me
           LEFT JOIN roles role ON role.roles_id = me.roles_id
               WHERE ( me.end_date IS NULL OR me.end_date >= '?' )
                 AND me.quantity = ?
		 AND ( me.start_date IS NULL OR me.start_date <= ? )
                 AND role.name IN ( ? )
            GROUP BY me.sku ) price_modifier
  ON product.sku = price_modifier.sku
  WHERE product.active = ?
  AND me.navigation_id = ?;