All pastes #657474 Raw Edit

Miscellany

public text v1 · immutable
#657474 ·published 2007-08-14 21:41 UTC
rendered paste body
SELECT cuid AS gt_cuid, SUM(product_price * quantity) AS total_spent, (SELECT vitamin_cuid FROM autoresponder_products WHERE cuid = gt_cuid) AS gv_cuid GROUP BY cuid LIMIT 10;