SmartCJ Support Forum

Code: Select all

2016-07-19 12:29:11 : Mysql error: 1054 (Unknown column 'g.content_type' in 'where clause') in query select model_id as id, name, GROUP_CONCAT(thumb_id  ORDER BY total_ctr DESC) as thumbs_list from ( 
			SELECT gs.thumb_id, g2m.model_id, m.model_name as name,  gs.total_ctr FROM rot_gallery_info as gi
			LEFT JOIN rot_gallery_stats1 as gs ON gs.gallery_id = gi.gallery_id
			LEFT JOIN rot_gal2model as g2m ON gi.gallery_id = g2m.gallery_id
			LEFT JOIN rot_models as m ON m.model_id = g2m.model_id
			WHERE gs.best_thumb = 'yes' and gs.group_id = 0 and 
			gallery_status = 'active' and g2m.model_id IS NOT NULL 
			and gi.gallery_type = 0
			AND m.model_name IS NOT NULL  and g.content_type = '4'  ORDER BY g2m.model_id, gs.total_ctr desc 
			) as top_galleries 
			group by model_id