Changeset 4981 for extensions/PWG_Stuffs


Ignore:
Timestamp:
Feb 27, 2010, 4:01:24 PM (14 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.