Skip to content

Instantly share code, notes, and snippets.

View feketegy's full-sized avatar
💻
The touch type baron.

George feketegy

💻
The touch type baron.
View GitHub Profile
@feketegy
feketegy / wtf.sql
Created February 2, 2016 21:24 — forked from Swader/wtf.sql
How would you rewrite this query to be MySQL 5.7 friendly? Currently fails due to new GROUP BY rules.
select extf.* from (
select ExternalTransactinId
from ebay_order_items
ExternalTransactionId is not null
group by ExternalTransactionID
) extf
extf.z_shipmentno is null
and extf.orderstatus = 'Completed'
and extf.timestamp > '2015-02-25'
order by extf.timestamp desc;

Kohana 3.4

Features

Fixes

Improvements

  • Database should support Mysqli
  • Namespaces
  • Full PSR-0, PSR-4 support by default