Bigcheese

1 Comet Storm
1 Elesh Norn, Grand Cenobite
1 Iona, Shield of Emeria
1 Tezzeret the Seeker
1 Dark Confidant
1 Tarmogoyf
1 Mox Opal
1 Ulamog, the Infinite Gyre
1 Profane Command
1 Precursor Golem

Bigcheese

range

last, function-object
range 1 first mismatch, range 2 first mismatch
input last, output last
range 1 last, range 2 last
min, max

input 1 last, input 2 last, output last
input last, output 1 last, output 2 last

Bigcheese

+ (203.1a) The colors are blue, pink, white, purple, yellow, and orange.
+ (207.1b) Some traits have icons associated with them; these traits may also be referenced using the associated icon.
+ (212) Home Limit: Mane Characters have a home limit, which indicates how many Friends a player controlling that Mane Character can have in their Home at the end of their turn.
- (409.6) A card that changes zones or changes position in an ordered zone becomes a different card. Modifiers or effects which applied to it no longer apply, even if it returns to its original zone or position.
+ (409.6) A card that changes zones or changes position in an ordered zone becomes a different card. Modifiers or effects which applied to it no longer apply, even if that card returns to its original zone or position. A card is not considered to have changed position in an ordered zone unless that card is directly put in a particular position or the cards in the zone are shuffled.
- (506.1) Moving is the act of putting a card from one ar

Bigcheese

Bigcheese

WITH bob AS (
  WITH adena AS (
    SELECT
      prices.guid,prices.type,prices.store,prices.url,prices.datetime,prices.quantity,prices.price,prices.currency
    FROM prices
    INNER JOIN (
      SELECT
        guid,store,type,max(datetime) m
      FROM prices
      GROUP BY guid,store,type

Bigcheese

--
-- PostgreSQL database dump
--

-- Dumped from database version 9.4.1
-- Dumped by pg_dump version 9.4.1
-- Started on 2015-03-22 05:38:53

SET statement_timeout = 0;
SET lock_timeout = 0;

Bigcheese

BEGIN;
  BEGIN TRANSACTION;
    INSERT INTO urls (url)
      SELECT 'sefsefefsves'
      WHERE NOT EXISTS (SELECT id FROM urls WHERE urls.url = 'sefsefefsves');
  COMMIT;
  INSERT INTO prices (price, guid, currency, url, datetime, store)
  VALUES (100.00, 4, 'USD', SELECT id FROM urls WHERE url = 'sefsefefsves', '2015-03-22T06:34:45.926013+00:00', SELECT id FROM stores WHERE name = 'Win Condition Cards');
END;

Bigcheese

--
-- PostgreSQL database dump
--

-- Dumped from database version 9.4.1
-- Dumped by pg_dump version 9.4.1
-- Started on 2015-03-22 01:43:06

SET statement_timeout = 0;
SET lock_timeout = 0;

Bigcheese

import wsgiref
from wsgiref.util import setup_testing_defaults
from wsgiref.simple_server import make_server

def simple_app(environ, start_response):
    setup_testing_defaults(environ)
    
    if 'HTTP_AUTHORIZATION' in environ:
      print('Authed!')
      status = '200 OK'

Bigcheese

// Compile with -avx. Will emit movaps instead of movups.

struct v4 {
  float x;
  float y;
  float z;
  float w;
};

typedef v4 v4_aligned __attribute__((aligned(16)));