10 lines
302 B
MySQL
10 lines
302 B
MySQL
|
select count(*) c , phone
|
||
|
|
from orders_items as oi
|
||
|
|
left join orders as o on (o.orderid = oi.orderid)
|
||
|
|
left join customers as c on (c.customerid = o.customerid)
|
||
|
|
left join products as p on (p.sku = oi.sku)
|
||
|
|
where p.desc like 'Noah%'
|
||
|
|
group by o.customerid, c.phone
|
||
|
|
order by c desc limit 12
|
||
|
|
-- pick first one
|