Changeset 4981


Ignore:
Timestamp:
02/27/10 16:01:24 (10 years ago)
Author:
patdenice
Message:

Sql query corrected

File:
1 edited

Legend:

Unmodified
Added
Removed
  • extensions/PWG_Stuffs/modules/FeaturedPhotos/main.inc.php

    r4968 r4981  
    1919SELECT DISTINCT(i.id) 
    2020  FROM '.IMAGES_TABLE.' AS i 
    21     INNER JOIN '.FAVORITES_TABLE.' AS f       ON image_id = id 
     21    INNER JOIN '.FAVORITES_TABLE.' AS f       ON f.image_id = i.id 
    2222    INNER JOIN '.IMAGE_CATEGORY_TABLE.' AS ic ON i.id = ic.image_id 
    2323    INNER JOIN '.CATEGORIES_TABLE.' AS c      ON ic.category_id = c.id 
Note: See TracChangeset for help on using the changeset viewer.