Cuidadores Disponibles
- user warning: Expression #6 of SELECT list is not in GROUP BY clause and contains nonaggregated column 's043d5c5_cuidotumascota.location.province' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
query: SELECT COUNT(*) FROM (SELECT DISTINCT(node.nid) AS nid,
users.name AS users_name,
users.uid AS users_uid,
node.type AS node_type,
node.vid AS node_vid,
location.province AS location_province,
location.country AS location_country,
node_data_field_disponible.field_desde_value AS node_data_field_disponible_field_desde_value,
node_data_field_disponible.field_hasta_value AS node_data_field_disponible_field_hasta_value,
node_data_field_disponible.field_precio_value AS node_data_field_disponible_field_precio_value,
'BUSCADOR_cuidadores:page_1' AS view_name
FROM node node
LEFT JOIN votingapi_cache votingapi_cache_node_percent_vote_average ON node.nid = votingapi_cache_node_percent_vote_average.content_id AND (votingapi_cache_node_percent_vote_average.content_type = 'node' AND votingapi_cache_node_percent_vote_average.value_type = 'percent' AND votingapi_cache_node_percent_vote_average.tag = 'vote' AND votingapi_cache_node_percent_vote_average.function = 'average')
INNER JOIN content_type_perfil_usuario node_data_field_perfil ON node.vid = node_data_field_perfil.vid
LEFT JOIN content_type_perfil_usuario node_data_field_disponible ON node.vid = node_data_field_disponible.vid
INNER JOIN users users ON node.uid = users.uid
LEFT JOIN location_instance location_instance ON node.vid = location_instance.vid
LEFT JOIN location location ON location_instance.lid = location.lid
WHERE (node_data_field_perfil.field_perfil_value = 'Cuidador') AND (UPPER(node_data_field_disponible.field_disponible_value) = UPPER('Si')) AND (users.access != 0) AND (users.status <> 0)
GROUP BY nid
ORDER BY users_name DESC
) count_alias in /home/s043d5c5/public_html/cuidotumascota.es/sites/all/modules/views/includes/view.inc on line 739.
- user warning: Expression #6 of SELECT list is not in GROUP BY clause and contains nonaggregated column 's043d5c5_cuidotumascota.location.province' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
query: SELECT DISTINCT(node.nid) AS nid,
users.name AS users_name,
users.uid AS users_uid,
node.type AS node_type,
node.vid AS node_vid,
location.province AS location_province,
location.country AS location_country,
node_data_field_disponible.field_desde_value AS node_data_field_disponible_field_desde_value,
node_data_field_disponible.field_hasta_value AS node_data_field_disponible_field_hasta_value,
node_data_field_disponible.field_precio_value AS node_data_field_disponible_field_precio_value,
'BUSCADOR_cuidadores:page_1' AS view_name
FROM node node
LEFT JOIN votingapi_cache votingapi_cache_node_percent_vote_average ON node.nid = votingapi_cache_node_percent_vote_average.content_id AND (votingapi_cache_node_percent_vote_average.content_type = 'node' AND votingapi_cache_node_percent_vote_average.value_type = 'percent' AND votingapi_cache_node_percent_vote_average.tag = 'vote' AND votingapi_cache_node_percent_vote_average.function = 'average')
INNER JOIN content_type_perfil_usuario node_data_field_perfil ON node.vid = node_data_field_perfil.vid
LEFT JOIN content_type_perfil_usuario node_data_field_disponible ON node.vid = node_data_field_disponible.vid
INNER JOIN users users ON node.uid = users.uid
LEFT JOIN location_instance location_instance ON node.vid = location_instance.vid
LEFT JOIN location location ON location_instance.lid = location.lid
WHERE (node_data_field_perfil.field_perfil_value = 'Cuidador') AND (UPPER(node_data_field_disponible.field_disponible_value) = UPPER('Si')) AND (users.access != 0) AND (users.status <> 0)
GROUP BY nid
ORDER BY users_name DESC
LIMIT 0, 25 in /home/s043d5c5/public_html/cuidotumascota.es/sites/all/modules/views/includes/view.inc on line 765.
|