1
Hi,
I have a query, and it doesn't execute when I enter the page,
Example, I use the button in the menu to enter the page, than the query doesn't execute. When I send something through POST on this page, the query does execute...
So in my opinion, XOOPS only executes query's when the page is accessed through post... But the query I had before this one worked...
The query I use is:
Quote:
select
id, descr, freq, event_count
from
xoops_servex_event sa
LEFT OUTER JOIN
(select
event_id, count(*) as event_count
from
(select
distinct location_id, event_id
from
xoops_servex_event_link
where
time_until < now() OR time_until > now() OR false
) as foo
GROUP BY
event_id
) as foo
ON sa.id = foo.event_id
where
event_count > 0 OR true
ORDER BY
lower(descr) asc;
This is the database dump after a post from the site.. This query isn't executed when I open the page a normal way...
Is there a way around this??