Unfortunately, ES is not like SQL in this respect. You'll need to denormalize somewhat because ES is more "document-oriented". You'd probably need to either denormalize offer_id into categorytype, or category into offertype to get all the data you want returned in 1 query.
-- You received this message because you are subscribed to the Google Groups "elasticsearch" group. To unsubscribe from this group and stop receiving emails from it, send an email to elasticsearch+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/elasticsearch/750f1c19-4eca-4204-9da0-25783feda996%40googlegroups.com. For more options, visit https://groups.google.com/groups/opt_out.