Something

SELECT * FROM (
       SELECT
             product.product_guid,
             product.name,
             product.product_code,
             price_information.price as price,
             price_information.offer as offer
       FROM product
       INNER JOIN filter_product_price_information as price_information
             ON product.product_guid = price_information.product_guid
       LEFT OUTER JOIN filter_product_do_not_display as do_not_display
            ON product.product_guid = do_not_display.product_guid
       WHERE do_not_display.product_guid IS NULL
) as filter_dview
LIMIT 6;