SELECT
	ac.*,
	COUNT(*) count,
	a.albums_link
FROM
	albums_categories ac
JOIN
	albums a
USING
	(categories_id)
WHERE
	ac.categories_active = 1
	AND ac.categories_name != "scroller"
	AND ac.sites_id = 1
   	AND ac.languages_id = 1
GROUP BY
	ac.categories_id
ORDER BY
	categories_order, a.albums_order DESC

Expression #9 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'fahmyenf_cms.a.albums_link' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by