jsalazar

// ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
// ::::::::::::::::::: GIANT MAJORS MENU FOR SCHOOLS ::::::::::::::::::::::::::::
// ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~		

var schoolMenuContainers = $('div#schoolMenuContainer > div.schoolMenu');

// ON CLICK
$('.schoolBox, .menuActi').click(function () {
	var cVisible = $('#schoolMenuContainer').is(':visible');
	$('#schoolMenuPreview').slideUp('slow'); // hide the preview

jsalazar

SELECT DISTINCT click_linkid, count (*) as count, click_campaign, click_linkurl 
        FROM click_tracker
        where extract(YEAR from TIMESTAMP WITH TIME ZONE 'epoch' + click_timestamp * INTERVAL '1 second') = 2009        
        GROUP BY click_linkid, click_campaign, click_linkurl 
        ORDER BY click_campaign, count DESC ";    

jsalazar

select distinct click_hour::numeric, click_year, count(*) as count  
from click_tracker
where click_linkid = '12345678' and click_day_of_year = '88'
group by click_hour, click_year
order by click_year, click_hour::numeric;

jsalazar

Array.prototype.sum = function() {

    if (this instanceof Array) {

        return this.reduce(function(a,b) {

            return a+b;

        });