Mysql error:: 1052 (Column 'gallery_md5' in where clause is
Posted: Sat Jan 11, 2014 7:30 pm
V 1.50 Build 201310031106
Если зайти в Rotation - List Thumbs
Переключить Search in на Gallery ID и поикать произвольную циферку, то получаем только:
Mysql error:: 1052 (Column 'gallery_md5' in where clause is ambiguous) (db_link) in query select SQL_CALC_FOUND_ROWS g.id, gs.total_ctr as max_ctr, gs.total_shows as casts, gs.total_clicks as clicks, g.priority as gs_priority FROM rot_galleries as g JOIN rot_gallery_data as gd on gd.gallery_md5 = g.gallery_md5 JOIN rot_gallery_info as gi on gi.gallery_md5 = g.gallery_md5 JOIN rot_gal2group as g2gr on g2gr.gal_id = g.id JOIN rot_gallery_stats as gs on gs.thumb_id = g.id WHERE 1 = 1 and gs.best_thumb = "yes" and not (g.rgroup = '0' and sponsor_id = 3) and gallery_md5 like '%222%' and g.status IN ( 0,1,2) group by g.gallery_md5 order by max_ctr desc limit 0, 15. (pornwithgranny.com)
Если зайти в Rotation - List Thumbs
Переключить Search in на Gallery ID и поикать произвольную циферку, то получаем только:
Mysql error:: 1052 (Column 'gallery_md5' in where clause is ambiguous) (db_link) in query select SQL_CALC_FOUND_ROWS g.id, gs.total_ctr as max_ctr, gs.total_shows as casts, gs.total_clicks as clicks, g.priority as gs_priority FROM rot_galleries as g JOIN rot_gallery_data as gd on gd.gallery_md5 = g.gallery_md5 JOIN rot_gallery_info as gi on gi.gallery_md5 = g.gallery_md5 JOIN rot_gal2group as g2gr on g2gr.gal_id = g.id JOIN rot_gallery_stats as gs on gs.thumb_id = g.id WHERE 1 = 1 and gs.best_thumb = "yes" and not (g.rgroup = '0' and sponsor_id = 3) and gallery_md5 like '%222%' and g.status IN ( 0,1,2) group by g.gallery_md5 order by max_ctr desc limit 0, 15. (pornwithgranny.com)