I'm using the inner joins to get the list of pages that contain the hits, not the hits themselves. However, I realize now that this wouldn't get me an excerpt to go along with a page anyway.

I have a SQL2 query that returns the pages that include content matching my search terms. I'm usingjavax.jcr.query.QueryResult to get the results. I'd like to usecom.day.cq.search.result.SearchResult so I have excerpts to use. How can I convert this SQL2 query to predicates? Or is there a better way...

SOLVED:My template at "/conf/<root>/settings/wcm/templates/page-basic/initial" was missing the fragmentVariationPath property on the experience fragments. I'm not sure why it still worked on the author instance, though. Thanks for your suggestions.

That didn't seem to have an effect.

Root configuration is the same on both instances.

The value I have there is like /conf/<root>/settings/wcm/templates/page-(.*)

How do I check that? CRX only shows /content on the publish instance.

Going directly to the header/footer experience fragment works.

I'm using editable templates with the header and footer as experience fragments. On author this works as expected, but on publish the header and footer are missing. In the publish log, I see this:19.05.2022 17:01:30.302 *INFO* [127.0.0.1 [1652994090260] GET /home HTTP/1.1] com.day.cq.wcm.foundation....

Also, please don't assume that your reply is the answer. If you can change the correct answer for this post, please do.