You are here

function node_gallery_views_handler_image_date::query in Node Gallery 6.3

File

views2inc/node_gallery_views_handler_image_date.inc, line 9: Creates an image date handler for galleries.

Class

node_gallery_views_handler_image_date: @file Creates an image date handler for galleries.

Code

function query() {
  $table = $this
    ->ensure_my_table();
  $sql = "SELECT n.changed FROM {node_gallery_images} ng JOIN {node} n on ng.nid = n.nid WHERE n.status = 1 AND ng.gid = node.nid ORDER BY changed DESC LIMIT 1";
  $this->field_alias = $this->query
    ->add_field(NULL, "({$sql})", 'image_date');
}