loading constant through settings.GLOBAL_SETTINGS['ki_adjust']
made GROUP BY query compliant with canonical SQL - should check if output changes