Bienvenue sur Elgg.

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') AND (((msn1.string = 'itemtype' AND BINARY msv1.string
= 'plaque' AND ' at line 20

QUERY: SELECT count(DISTINCT e.guid) as total FROM elgg_entities e JOIN elgg_metadata custom_table3 on custom_table3.entity_guid=e.guid JOIN elgg_metadata custom_table4 on custom_table4.entity_guid=e.guid JOIN elgg_metastrings custom_msn3 on custom_table3.name_id = custom_msn3.id JOIN elgg_metastrings custom_msn4 on custom_table3.value_id = custom_msn4.id JOIN elgg_metastrings custom_msn5 on custom_table4.name_id = custom_msn5.id JOIN elgg_metastrings custom_msn6 on custom_table4.value_id = custom_msn6.id JOIN elgg_metadata n_table on
e.guid = n_table.entity_guid JOIN elgg_metadata n_table1
on e.guid = n_table1.entity_guid JOIN elgg_metastrings msn1
on n_table1.name_id = msn1.id JOIN elgg_metastrings msv1
on n_table1.value_id = msv1.id JOIN elgg_metadata n_table2
on e.guid = n_table2.entity_guid JOIN elgg_metastrings msn2
on n_table2.name_id = msn2.id JOIN elgg_metastrings msv2
on n_table2.value_id = msv2.id JOIN elgg_metadata n_table3
on e.guid = n_table3.entity_guid JOIN elgg_metastrings msn3
on n_table3.name_id = msn3.id JOIN elgg_metastrings msv3
on n_table3.value_id = msv3.id JOIN elgg_metadata n_table4
on e.guid = n_table4.entity_guid JOIN elgg_metastrings msn4
on n_table4.name_id = msn4.id JOIN elgg_metastrings msv4
on n_table4.value_id = msv4.id JOIN elgg_metadata n_table5
on e.guid = n_table5.entity_guid JOIN elgg_metastrings msn5
on n_table5.name_id = msn5.id JOIN elgg_metastrings msv5
on n_table5.value_id = msv5.id JOIN elgg_metadata n_table6
on e.guid = n_table6.entity_guid JOIN elgg_metastrings msn6
on n_table6.name_id = msn6.id JOIN elgg_metastrings msv6
on n_table6.value_id = msv6.id WHERE () AND (((msn1.string = 'itemtype' AND BINARY msv1.string
= 'plaque' AND ( (n_table1.access_id IN (2)
OR (n_table1.owner_guid = -1)
OR (
n_table1.access_id = 0
AND n_table1.owner_guid = -1
)
)) and n_table1.enabled='yes') AND (msn2.string = 'itemcategory' AND BINARY msv2.string
= 'tags' AND ( (n_table2.access_id IN (2)
OR (n_table2.owner_guid = -1)
OR (
n_table2.access_id = 0
AND n_table2.owner_guid = -1
)
)) and n_table2.enabled='yes') AND (msn3.string = 'pet' AND BINARY msv3.string
= 'no' AND ( (n_table3.access_id IN (2)
OR (n_table3.owner_guid = -1)
OR (
n_table3.access_id = 0
AND n_table3.owner_guid = -1
)
)) and n_table3.enabled='yes') AND (msn4.string = 'qrcode' AND BINARY msv4.string
= 'flower' AND ( (n_table4.access_id IN (2)
OR (n_table4.owner_guid = -1)
OR (
n_table4.access_id = 0
AND n_table4.owner_guid = -1
)
)) and n_table4.enabled='yes') AND (msn5.string = 'itemsubtype' AND BINARY msv5.string
= 'tags' AND ( (n_table5.access_id IN (2)
OR (n_table5.owner_guid = -1)
OR (
n_table5.access_id = 0
AND n_table5.owner_guid = -1
)
)) and n_table5.enabled='yes') AND (msn6.string = 'size' AND BINARY msv6.string
= 'no' AND ( (n_table6.access_id IN (2)
OR (n_table6.owner_guid = -1)
OR (
n_table6.access_id = 0
AND n_table6.owner_guid = -1
)
)) and n_table6.enabled='yes'))) AND ((e.type = 'object' AND e.subtype IN (18))) AND ( (e.access_id IN (2)
OR (e.owner_guid = -1)
OR (
e.access_id = 0
AND e.owner_guid = -1
)
)) and e.enabled='yes'