[[pdoResources? &parents=`0` &depth=`1` &limit=`0` &context=`[[*context_key]]` &includeTVs=`categoryImage` &tvPrefix=`` &where=`{"template:=":6, "OR:template:=":5}` &sortby=`menuindex` &sortdir=`ASC` &idx=`1` &showUnpublished=`0` &showHidden=`1` &tpl=`ctaTPL` ]]
0.0001562: pdoTools loaded 0.0000339: xPDO query object created 0.0004380: Included list of tvs: <b>categoryImage</b> 0.0003159: leftJoined <i>modTemplateVarResource</i> as <b>TVcategoryimage</b> 0.0006249: Added selection of <b>modResource</b>: <small>SQL_CALC_FOUND_ROWS `id`, `type`, `contentType`, `pagetitle`, `longtitle`, `description`, `alias`, `link_attributes`, `published`, `pub_date`, `unpub_date`, `parent`, `isfolder`, `introtext`, `richtext`, `template`, `menuindex`, `searchable`, `cacheable`, `createdby`, `createdon`, `editedby`, `editedon`, `deleted`, `deletedon`, `deletedby`, `publishedon`, `publishedby`, `menutitle`, `donthit`, `privateweb`, `privatemgr`, `content_dispo`, `hidemenu`, `class_key`, `context_key`, `content_type`, `uri`, `uri_override`, `hide_children_in_tree`, `show_in_tree`, `properties`</small> 0.0000150: Added selection of <b>modTemplateVarResource</b>: <small>IFNULL(`value`, '') AS `categoryImage`</small> 0.0000939: Replaced TV conditions 0.0000441: Processed additional conditions 0.0005131: Added where condition: <b>template:==6, OR:template:==5, modResource.published=1, modResource.deleted=0, modResource.context_key=web</b> 0.0000281: Replaced TV conditions 0.0001490: Sorted by <b>modResource.menuindex</b>, <b>ASC</b> 0.0004420: SQL prepared <small>"SELECT SQL_CALC_FOUND_ROWS `modResource`.`id`, `modResource`.`type`, `modResource`.`contentType`, `modResource`.`pagetitle`, `modResource`.`longtitle`, `modResource`.`description`, `modResource`.`alias`, `modResource`.`link_attributes`, `modResource`.`published`, `modResource`.`pub_date`, `modResource`.`unpub_date`, `modResource`.`parent`, `modResource`.`isfolder`, `modResource`.`introtext`, `modResource`.`richtext`, `modResource`.`template`, `modResource`.`menuindex`, `modResource`.`searchable`, `modResource`.`cacheable`, `modResource`.`createdby`, `modResource`.`createdon`, `modResource`.`editedby`, `modResource`.`editedon`, `modResource`.`deleted`, `modResource`.`deletedon`, `modResource`.`deletedby`, `modResource`.`publishedon`, `modResource`.`publishedby`, `modResource`.`menutitle`, `modResource`.`donthit`, `modResource`.`privateweb`, `modResource`.`privatemgr`, `modResource`.`content_dispo`, `modResource`.`hidemenu`, `modResource`.`class_key`, `modResource`.`context_key`, `modResource`.`content_type`, `modResource`.`uri`, `modResource`.`uri_override`, `modResource`.`hide_children_in_tree`, `modResource`.`show_in_tree`, `modResource`.`properties`, IFNULL(`TVcategoryimage`.`value`, '') AS `categoryImage` FROM `modx_site_content` AS `modResource` LEFT JOIN `modx_site_tmplvar_contentvalues` `TVcategoryimage` ON `TVcategoryimage`.`contentid` = `modResource`.`id` AND `TVcategoryimage`.`tmplvarid` = 20 WHERE ( `modResource`.`template` = 6 OR `modResource`.`template` = 5 AND `modResource`.`published` = 1 AND `modResource`.`deleted` = 0 AND `modResource`.`context_key` = 'web' ) ORDER BY modResource.menuindex ASC "</small> 0.0008121: SQL executed 0.0000939: Total rows: <b>9</b> 0.0001268: Rows fetched 0.0052760: Prepared and processed TVs 0.0017941: Loaded "modChunk" with name "ctaTPL" 0.0149760: Returning processed chunks 0.0242412: <b>Total time</b> 12 320 768: <b>Memory usage</b>
This question has been answered by ferx77. See the first response.
&showUnpublished=`0`
0.0005131: Added where condition: <b>template:==6, OR:template:==5, modResource.published=1, modResource.deleted=0, modResource.context_key=web</b>
&where=`{ "template:IN" : [ 5,6 ] }`
&where=`{{"template:=":6, "OR:template:=":5}}`
&parents=`+0`
&parents=`0`
sorry for my error.
Can you test sql command manual directly ?
I think the problem is in the OR clause of SQL
Try change the where
&where=`{ "template:IN" : [ 5,6 ] }`
Or
&where=`{{"template:=":6, "OR:template:=":5}}`
&where=`{ "template:IN" : [ 5,6 ] }`