SELECT p.pid, p.filename, AVG(v.vote) as avgv, COUNT(v.vote) as avgc
			FROM wp_ngg_pictures p
			LEFT JOIN wp_nggv_votes v ON (p.pid = v.pid)
...

$(function(){
  $("a").each(function(){
    var _this = $(this);
...

public static class Fnv1Hash
{
    public static uint ComputeHash32(IEnumerable<byte> bytes)
...

import sys 
from math import log 

...

input = [9,9,9,9,9,9,9,9,9,9,9,9]
input.uniq == 9

...

// this is in the global scope of my program. normally accepted as bad code, 
// but it seems to make sense in the context of an embedded platform.
// "global" cache
...

def remove_blanks(hash)
    values = {}
    hash.each do |k,v|
...

function demortonize($n)
{
	$row = $col = 0;
...

$css = preg_replace('/\s\s+/', '', preg_replace('@/\\*([\\s\\S]*?)\\*/@','',$css));

function deinterleave(base4_arr)
{
	var x='',y='',rc;
...

asdf a

def render_page_sitemap(scope, sitemapname,statics, machines, lang)
...

;(function($) {
        $.fn.extend(
...

<?php
//class
	class Collection{
...

private static void Log(object message, MessageType type)
		{
			string str = message.ToString();
...

require 'net/sftp'

class Net::SFTP::Session
...

<?php
function word_limiter( $text, $limit = 30, $chars = '0123456789' ) {
    if( strlen( $text ) > $limit ) {
...

using System;
using System.Collections.Generic;
using System.Linq;
...

class Array

   # insert i between each element in the array
...

#!/bin/bash

# Global variables
...

public static String findsite(InputStream text) {
      String site, line = null;
      Boolean nospace = true;
...

class Item
  def raw_tag_list; "one, two, three, four, five"; end
  def public_tags; [<#Tag name=two>, <#Tag name=five>, <#Tag name=one>, <#Tag name=four>, <#Tag name=three>]; end
...

def haar_1d(a)
	r = []
	(Math.log(a.length) / Math.log(2) - 1).to_i.downto(0) { |j|
...

public static String[] loadFile(final String f) {
		String thisLine;
		final SortedSet<String> s = new TreeSet<String>();
...

// For faster converting of dates to strings
char* sLeadingZeroIntegerValues[] = {
"00","01","02","03","04","05","06","07","08","09",
...