steverobbins

select
    sfo.entity_id,
    sfo.increment_id,
    sfo.created_at,
    sfo.status,
    sfo.state,
    sfo.customer_id,
    sfo.ap21_order_id,
    sfo.ap21_person_id,
    ce.email,

steverobbins

set @datetime  = '2015-03-25 10:30:00';
set @threshold = 15;
 
select
    job_code,
    status,
    messages,
    executed_at,
    finished_at,
    timediff(finished_at, executed_at) run_time

steverobbins

-- This takes about 30 seconds, but will make the next query a billion times faster
alter table sales_flat_order_item add index (product_id);

-- This takes about 5 seconds with the index added
select
    cpe.entity_id product_id,
    cpe.sku,
    at_style_number.value style_number,
    cpe.created_at product_created_date,
    sum(sfoi.qty_ordered) total_ordered,

steverobbins

<script>
var settings = {
        exclude: ["US"],
        regionselector: "example.com/regionselector",
        homepages: {
            "US": "example.com",
            "DE": "example.com/de",
            "FR": "example.com/fr",
            "EU": "example.com/eu"
        }

steverobbins

-- Make sure to uncomment one of the where conditions below or your query will take forever
select
    lu.visit_time,
    inet_ntoa(lvi.server_addr) server_addr,
    inet_ntoa(lvi.remote_addr) remote_addr,
    lui.url,
    lc.customer_id,
    ce.email,
    cs.name store,
    lvi.http_user_agent,

steverobbins

#!/bin/bash

DOMAIN=example.com
wget -w 2 -r --spider --delete-after -nd -nc --domains=$DOMAIN $DOMAIN > /dev/null 2>&1 &

steverobbins

<?php

ini_set('display_errors', 1);
include 'app/Mage.php';
Mage::setIsDeveloperMode(true);
$mageRunCode = isset($_SERVER['MAGE_RUN_CODE']) ? $_SERVER['MAGE_RUN_CODE'] : '';
$mageRunType = isset($_SERVER['MAGE_RUN_TYPE']) ? $_SERVER['MAGE_RUN_TYPE'] : 'store';
Mage::app($mageRunCode, $mageRunType);

$mail = new Zend_Mail();

steverobbins

select
    eu_flat.entity_id,
    eu_flat.sku,
    def_eav.value default_eav_price,
    eu_eav.value eu_eav_price,
    eu_flat.price eu_flat_price
from catalog_product_flat_3 eu_flat
inner join catalog_product_entity_decimal eu_eav
    on eu_flat.entity_id = eu_eav.entity_id
    and eu_eav.attribute_id = 75

steverobbins

<?php
/**
 * Short description of module
 *
 * PHP version 5
 * 
 * @category  Kering
 * @package   Kering_Modulename
 * @author    Kering Magento Team <magento@kering.com>
 * @copyright 2015 Kering

steverobbins

<?php

include 'app/Mage.php';
Mage::setIsDeveloperMode(true);
ini_set('display_errors', 1);
umask(0);
$mageRunCode = isset($_SERVER['MAGE_RUN_CODE']) ? $_SERVER['MAGE_RUN_CODE'] : '';
$mageRunType = isset($_SERVER['MAGE_RUN_TYPE']) ? $_SERVER['MAGE_RUN_TYPE'] : 'store';
Mage::app($mageRunCode, $mageRunType);