Changeset 4981

Timestamp:

02/27/10 16:01:24 (3 years ago)

Author:

patdenice

Message:

Sql query corrected

Files:

• extensions/PWG_Stuffs/modules/FeaturedPhotos/main.inc.php (modified) (1 diff)

extensions/PWG_Stuffs/modules/FeaturedPhotos/main.inc.php

@@ -19 +19 @@
 SELECT DISTINCT(i.id)
   FROM '.IMAGES_TABLE.' AS i
-    INNER JOIN '.FAVORITES_TABLE.' AS f       ON image_id = id
+    INNER JOIN '.FAVORITES_TABLE.' AS f       ON f.image_id = i.id
     INNER JOIN '.IMAGE_CATEGORY_TABLE.' AS ic ON i.id = ic.image_id
     INNER JOIN '.CATEGORIES_TABLE.' AS c      ON ic.category_id = c.id