alfred-dub

SELECT 
  SUBSTRING_INDEX(number, '.', 1) AS FIRST_INT, 
  SUBSTRING_INDEX(SUBSTRING_INDEX(number, '.', 2), '.', -1) AS SECOND_INT, 
  SUBSTRING_INDEX(number, '.', -1) AS THIRD_INT,
  number as VERSION, 
  description as TITLE 
FROM _version 
ORDER BY
  LENGTH(SUBSTRING_INDEX(number, '.', 1)) DESC,
  SUBSTRING_INDEX(number, '.', 1) DESC, 

alfred-dub

<?php
// @see http://stackoverflow.com/a/28769763/1977778
$queryBuilder = $this->getDI()->getModelsManager()
    ->createBuilder()
    ->columns(['p.id','participants.*'])
    ->addFrom('Entity\Projects', 'p')
    ->leftJoin('Entity\Participants', 'participants.projectId = p.id', 'participants')
    ->groupBy('p.id, participants.id')
    ->orderBy('p.id ASC');

alfred-dub

`emacs --daemon` to run in the background.
`emacsclient.emacs24 <filename/dirname>` to open in terminal

NOTE: "M-m and SPC can be used interchangeably".

* Undo - `C-/`
* Redo - `C-?`
* Change case: 1. Camel Case : `M-c`
               2. Upper Case : `M-u`
               3. Lower Case : `M-l`