Gallery
user warning: Can't create/write to file '/tmp/#sql_c12_0.MYI' (Errcode: 13)
query: SELECT DISTINCT node.nid AS nid,
node_data_field_ca_gal_display_image.field_ca_gal_display_image_fid AS node_data_field_ca_gal_display_image_field_ca_gal_display_image_fid,
node_data_field_ca_gal_display_image.field_ca_gal_display_image_list AS node_data_field_ca_gal_display_image_field_ca_gal_display_image_list,
node_data_field_ca_gal_display_image.field_ca_gal_display_image_data AS node_data_field_ca_gal_display_image_field_ca_gal_display_image_data,
node.type AS node_type,
node.vid AS node_vid,
node.title AS node_title,
node_weight.sticky AS node_weight_sticky
FROM node node
LEFT JOIN content_field_ca_gal_parent_gallery node_data_field_ca_gal_parent_gallery ON node.vid = node_data_field_ca_gal_parent_gallery.vid
LEFT JOIN domain_access domain_access ON node.nid = domain_access.nid
LEFT JOIN content_type_ca_gallery node_data_field_ca_gal_display_image ON node.vid = node_data_field_ca_gal_display_image.vid
LEFT JOIN node node_weight ON node.nid = node_weight.nid
INNER JOIN node_access na ON na.nid = node.nid WHERE (na.grant_view >= 1 AND ((na.gid = 0 AND na.realm = 'all') OR (na.gid = 0 AND na.realm = 'domain_site') OR (na.gid = 0 AND na.realm = 'domain_id'))) AND ( (node_data_field_ca_gal_parent_gallery.field_ca_gal_parent_gallery_nid IS NULL) AND (node.status <> 0) AND (node.type in ('ca_gallery')) AND (((domain_access.realm = 'domain_id' AND domain_access.gid = 0) OR (domain_access.realm = 'domain_site' AND domain_access.gid = 0)))
)ORDER BY node_weight_sticky DESC
LIMIT 0, 16 in /var/aegir/platforms/worx_business-6.x-1.0-alpha7/profiles/worx/modules/contrib/views/includes/view.inc on line 771.
