Q&A for Joomla! administrators, users, developers and designers
with pg_tags as (select *
where TagName like '%postgre%' or
(TagName like '%pg%' and TagName not like '%upgrade%'
and TagName not like '%p-g%' and TagName not like '%graph%'
and TagName not in ('fpga','upgrade','gpgpu','http-get','gnupg','pgiaccelerator')))
select * from posts
where creationdate > '2018-01-01' and Tags in (select TagName from pg_tags)