jhedstrom

$> drush use @existing-d7-site
$> drush dl composer_generate
$> mkdir /tmp/new-site
$> drush composer-generate > /tmp/new-site/composer.json
$> cd /tmp/new-site
$> composer install
$> composer require drupal/views

SQL for Blobs

SELECT
  FROM_UNIXTIME(
      SUBSTRING_INDEX(
          SUBSTRING_INDEX(
              SUBSTRING_INDEX(uo.data, 'created', -1),
              ';}', 1),
          ';i:', -1)
  )
    AS `Created Date`
FROM bitch_prod.uc_orders uo

joetower

Preprocess 

// Slideshow wrapper to allow absolute placement of slideshow content//

function theme-name_preprocess_views_view_fields(&$vars, $hook){
  if ($vars['view']->name == 'slideshow') {
    $vars['fields']['title']->wrapper_prefix = '<div class="slideshow-content-wrapper">' . $vars['fields']['title']->wrapper_prefix;
    $vars['fields']['field_slide_button_link']->wrapper_suffix .= '</div>';
  }
}