Skip to content

Instantly share code, notes, and snippets.

View danahern's full-sized avatar

Dan Ahern danahern

View GitHub Profile
mysql> explain select count(*), category_specific_fields.field_name, meta_fields.value from meta_fields LEFT JOIN category_specific_fields on meta_fields.category_specific_field_id = category_specific_fields.id LEFT JOIN categories on meta_fields.category_id = categories.id where categorizable_type = 'Listing' and categorizable_id in (SELECT distinct(`listings`.id) FROM `listings` where (expires_on IS NOT NULL)) and categories.lft BETWEEN 34204 and 35319 group by category_specific_fields.field_name, meta_fields.value;
+----+--------------------+--------------------------+-----------------+---------------------------------+---------+---------+----------------------------------------------------------------+--------+----------------------------------------------+
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra
<script type="text/javascript">
function displaycal<%= params[:passfield] %>()
{
var globalday = '';
var globalweek = '';
var globalcounter = '';
var globalrangecounter = 0;
var daterange1;
var daterange2;
var startdate = new Date();
/* @override
http://192.168.11.10:8000/stylesheets/main.new.css
http://192.168.11.11:3000/stylesheets/main.new.css
http://127.0.0.1:3000/stylesheets/main.new.css
*/
body {
margin: 0;
padding: 0;
font-family: Arial, Helvetica, sans-serif;
# IRBRC file by Iain Hecker, http://iain.nl
# put all this in your ~/.irbrc
require 'rubygems'
require 'yaml'
alias q exit
class Object
def local_methods
(methods - Object.instance_methods).sort
module HomebrewEnvExtension
# -w: keep signal to noise high
SAFE_CFLAGS_FLAGS = "-w -pipe"
def setup_build_environment
# Clear CDPATH to avoid make issues that depend on changing directories
delete('CDPATH')
delete('CPPFLAGS')
delete('LDFLAGS')