- Code: Select all
<cms:set my_custom_field_str="tags=<cms:show k_page_name />" />
<cms:query
sql="SELECT p.id, p.template_id
FROM <cms:php>echo K_TBL_PAGES;</cms:php> p
inner join <cms:php>echo K_TBL_TEMPLATES;</cms:php> t
on p.template_id = t.id
WHERE (t.name='web-trendovi.php' or t.name='internet-usluge.php')
AND publish_date < '<cms:date format='Y-m-d H:i:s' />'
AND NOT publish_date = '0000-00-00 00:00:00'
ORDER BY publish_date desc;"
fetch_pages='1'
>
<div class="blog-posts">
<article class="post post-medium">
<div class="post-content">
<h2><a href="<cms:show k_page_link />"><cms:show k_page_title /></a></h2>
<cms:if k_template_name='web-trendovi.php'>
<p class="blog-tekst"><cms:excerptHTML trail=" (...)" count='60' ignore='img' ><cms:show blog_sadrzaj /></cms:excerptHTML></p>
<cms:else_if k_template_name='internet-usluge.php' />
<p class="blog-tekst"><cms:excerptHTML trail=" (...)" count='60' ignore='img' ><cms:show usluga_sadrzaj /></cms:excerptHTML></p>
</cms:if>
<span class="d-block d-md-inline-block float-md-right mt-3 mt-md-0"><a href="<cms:show k_page_link />" title="<cms:show k_page_title />" alt="<cms:show k_page_title />" class="btn btn-primary btn-lg btn-send">Pročitaj više</a></span>
</div>
</article>
</div>
</cms:query>
I'm using this code. This code shows all articles from masterpages "web-trendovi.php" and "internet-usluge.php", not only those connected with specific tag. What should I change, where's the problem?