Expression #26 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'imazh_data.i.id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by SQL=select g.*,g.name as galleryname,g.name as gallery_dir,u.user ,count(distinct i.id) as imgs ,sum(i.views) as totalviews,sum(i.size) as totalsize,count(distinct c.comment_id) as totalcomments, sum(i.views) + count(distinct c.comment_id) as totals ,i.id,i.name,i.file,i.height,i.width,s.domain from gallery as g LEFT JOIN images4g as i on i.gallery_id=g.gallery_id LEFT JOIN users as u on u.id=g.uid LEFT JOIN groups as gps on u.gid=gps.id LEFT JOIN comments as c on c.img_id=i.id LEFT JOIN server as s on i.server_id=s.server_id WHERE (gps.bandwidth=0 or gps.bandwidth>=u.bandwidth) and g.category_id='17' and (i.deleted=0 or i.id is null) and g.status!=0 GROUP BY g.gallery_id ORDER BY totals DESC LIMIT 0,25
Expression #12 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'imazh_data.i.id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by SQL=SELECT g.gallery_id,g.name as gallery_name,g.name as gallery_dir,g.create_date, count(distinct i.id) as imgs,sum(i.views) as totalviews,count(distinct c.comment_id) as totalcomments, sum(i.views) + count(distinct c.comment_id) as totals, sum(i.ratings) as totalratings,sum(i.votes) as totalvotes, sum(i.ratings)/sum(i.votes) as totalrated, i.id,i.name,i.views,i.height,i.width,s.domain FROM gallery as g LEFT JOIN images4g as i on i.gallery_id=g.gallery_id LEFT JOIN users as u on u.id=g.uid LEFT JOIN groups as gps on u.gid=gps.id LEFT JOIN comments as c on c.img_id=i.id LEFT JOIN server as s on i.server_id=s.server_id WHERE (gps.bandwidth=0 OR gps.bandwidth>=u.bandwidth) and u.status=1 and (u.expire_date>1566356851 or gps.subscr_fee='') and (i.deleted=0) and i.id!=0 AND g.status!=0 GROUP BY g.gallery_id ORDER BY totals DESC LIMIT 0,5
Expression #12 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'imazh_data.i.id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by SQL=SELECT g.gallery_id,g.name as gallery_name,g.name as gallery_dir,g.create_date, count(distinct i.id) as imgs,sum(i.views) as totalviews,count(distinct c.comment_id) as totalcomments, sum(i.views) + count(distinct c.comment_id) as totals, sum(i.ratings) as totalratings,sum(i.votes) as totalvotes, sum(i.ratings)/sum(i.votes) as totalrated, i.id,i.name,i.views,i.height,i.width,s.domain FROM gallery as g LEFT JOIN images4g as i on i.gallery_id=g.gallery_id LEFT JOIN users as u on u.id=g.uid LEFT JOIN groups as gps on u.gid=gps.id LEFT JOIN comments as c on c.img_id=i.id LEFT JOIN server as s on i.server_id=s.server_id WHERE (gps.bandwidth=0 OR gps.bandwidth>=u.bandwidth) and u.status=1 and (u.expire_date>1566356851 or gps.subscr_fee='') and (i.deleted=0) and i.id!=0 AND g.status!=0 GROUP BY g.gallery_id ORDER BY totalrated DESC LIMIT 0,5
Imazhe Lirenti.com
Home Galeria Direktoria Identifikohu Rregjistrohu Sherbimi Pyetje Rregullorja
fr it sq en


Search a Gallery::
Home::Reality - Real World
Reality - Real World
Reality - Real World
0 galleries
Gallery Name Images Used space Views Comments Owner Flash


Copyright © 2005 - Imazhe Lirenti.com. All rights reserved.

Syndicate | E Re | Popular | Top Rated | Random | Link to us