Ignore:
Timestamp:
Feb 16, 2014, 11:56:22 PM (10 years ago)
Author:
ddtddt
Message:

[extensions] - see_photos_by_user - erreur count select user list

File:
1 edited

Legend:

Unmodified
Added
Removed
  • extensions/see_photos_by_user/pagespba.php

    r27392 r27396  
    6161
    6262$query = '
    63 SELECT UT.id, UT.username, COUNT(IT.id) AS PBU, IT.id
     63SELECT UT.id, UT.username, COUNT(DISTINCT(IT.id)) AS PBU, IT.id
    6464 FROM ' . USERS_TABLE . ' as UT
    6565 INNER JOIN '.IMAGES_TABLE.' AS IT ON IT.added_by = UT.id
Note: See TracChangeset for help on using the changeset viewer.