The code is supposed to show the other art from the artist. This is in the Art template.
I have:
[[!pdoResources?
&parents=`6`
&showLog=`0`
&depth=`1`
&sortby=`{"artid":"ASC"}`
&includeTVs=`ArtistsID,ArtTitle,artid`
&where=`{ "ArtistsID:=" : "[[*ArtistsID]]", "AND:artid:!=" : "[[*artid]]" }`
&returnIds=`0`
&toPlaceholder=`MoreListings`
&setTotal=`1`
&tpl=`ArtListing`
]]
<p> Total: [[+total]]</p>
<p>[[+total:greaterthan=`0`:then=`SHOW ME`:else=`HIDE ME`]]</p>
[[+MoreListings]]
The where links the artists and the art together and the second part excludes the current page thjat we are on from the listing. This is displayed by MoreListings and works fine.
For Total, I am getting 1 and HIDE ME
Logs are:
0.0000751: pdoTools loaded 0.0000210: xPDO query object created 0.0006931: Included list of tvs: **artid, ArtistsID, ArtTitle** 0.0001431: leftJoined *modTemplateVarResource* as **TVartid** 0.0000870: leftJoined *modTemplateVarResource* as **TVartistsid** 0.0000830: leftJoined *modTemplateVarResource* as **TVarttitle** 0.0001402: Added selection of **modResource** : <small>SQL_CALC_FOUND_ROWS
id,
type,
contentType,
pagetitle,
longtitle,
description,
alias,
alias_visible,
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.0000069: Added selection of **modTemplateVarResource** : <small>IFNULL(
value, '') AS
tv.artid</small> 0.0000050: Added selection of **modTemplateVarResource** : <small>IFNULL(
value, '') AS
tv.ArtistsID</small> 0.0000041: Added selection of **modTemplateVarResource** : <small>IFNULL(
value, '') AS
tv.ArtTitle</small> 0.0000260: Replaced TV conditions 0.0004599: Processed additional conditions 0.0006661: Added where condition: **
TVartistsid.
value:==4, AND:
TVartid.
value:!==A23, modResource.parent:IN(6,7,8,9), modResource.published=1, modResource.deleted=0** 0.0000100: Replaced TV conditions 0.0000720: Sorted by **
TVartid.
value** , **ASC** 0.0000019: Limited to **10** , offset **0** 0.0003080: SQL prepared <small>"SELECT SQL_CALC_FOUND_ROWS
modResource.
id,
modResource.
type,
modResource.
contentType,
modResource.
pagetitle,
modResource.
longtitle,
modResource.
description,
modResource.
alias,
modResource.
alias_visible,
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(
TVartid.
value, '') AS
tv.artid, IFNULL(
TVartistsid.
value, '') AS
tv.ArtistsID, IFNULL(
TVarttitle.
value, '') AS
tv.ArtTitleFROM
modx_site_contentAS
modResourceLEFT JOIN
modx_site_tmplvar_contentvalues
TVartidON
TVartid.
contentid=
modResource.
idAND
TVartid.
tmplvarid= 11 LEFT JOIN
modx_site_tmplvar_contentvalues
TVartistsidON
TVartistsid.
contentid=
modResource.
idAND
TVartistsid.
tmplvarid= 13 LEFT JOIN
modx_site_tmplvar_contentvalues
TVarttitleON
TVarttitle.
contentid=
modResource.
idAND
TVarttitle.
tmplvarid= 9 WHERE (
TVartistsid.
value= '4' AND
TVartid.
value!= 'A23' AND
modResource.
parentIN (6,7,8,9) AND
modResource.
published= 1 AND
modResource.
deleted= 0 ) ORDER BY
TVartid.
value ASC LIMIT 10 "</small> 0.0017581: SQL executed 0.0001910: Total rows: **1** 0.0000219: Rows fetched 0.0046301: Prepared and processed TVs 0.0026400: Loaded "modChunk" with name "ArtListing" 0.0030320: Returning processed chunks 0.0121272: **Total time** 4 194 304: **Memory usage**