Ignore:
Timestamp:
Jan 19, 2004, 10:18:34 PM (20 years ago)
Author:
z0rglub
Message:

Performances improved : replacing the useless LEFT JOIN by INNER JOIN

File:
1 edited

Legend:

Unmodified
Added
Removed

  • branches/release-1_3/admin/infos_images.php

    r258 r301  
    5050    $query = 'SELECT id,file';
    5151    $query.= ' FROM '.PREFIX_TABLE.'images';
    52     $query.= ' LEFT JOIN '.PREFIX_TABLE.'image_category ON id = image_id';
     52    $query.= ' INNER JOIN '.PREFIX_TABLE.'image_category ON id = image_id';
    5353    $query.= ' WHERE category_id = '.$page['cat'];
    5454    $query.= ';';
    … …  
    177177      $query = 'SELECT id,keywords';
    178178      $query.= ' FROM '.PREFIX_TABLE.'images';
    179       $query.= ' LEFT JOIN '.PREFIX_TABLE.'image_category ON id = image_id';
     179      $query.= ' INNER JOIN '.PREFIX_TABLE.'image_category ON id = image_id';
    180180      $query.= ' WHERE category_id = '.$page['cat'];
    181181      $query.= ';';
    … …  
    280280  $query.= ',storage_category_id,category_id';
    281281  $query.= ' FROM '.PREFIX_TABLE.'images';
    282   $query.= ' LEFT JOIN '.PREFIX_TABLE.'image_category ON id = image_id';
     282  $query.= ' INNER JOIN '.PREFIX_TABLE.'image_category ON id = image_id';
    283283  $query.= ' WHERE category_id = '.$page['cat'];
    284284  $query.= $conf['order_by'];
Note: See TracChangeset for help on using the changeset viewer.