Questions tagged [query-module]

The tag has no usage guidance.

4 questions with no upvoted or accepted answers
Filter by
Sorted by
Tagged with
0
votes
1answer
41 views

Get average rating from a Super Search results set

I have a series of super search results listing pages displaying lists that are all rated with the Ratings module. I want to get the average rating of all the entries in the list to put into schema ...
0
votes
1answer
66 views

Query Module: Error escaping quotes

We recently moved over some of our templates to use the Query module to reduce the number of DB queries happening. However I'm now experiencing an issue where some of the field data is being returned ...
0
votes
1answer
73 views

Query exp_channel_data but exclude expired entries

I'm on EE2.10.1, and trying to grab unique countries from a channel that has one field for "country name" and one field for "country code". So I've got the following query: {exp:query sql="SELECT ...
0
votes
1answer
153 views

SQL query issue while trying to count the entry (row)

Trying to produce a current entry count / total entries within a channel_entry tag by using a SQL query. {exp:channel:entries channel="{channel}" limit="1" require_entry="yes" status="open" ...