mattm

view: mp_companies {
  derived_table: {
    sql:
      SELECT
        distinct_id,
        CAST(JSON_EXTRACT_SCALAR(properties, "$.com_id") AS INT64) AS com_id
      FROM mp.event
      WHERE name = "Signed Up" ;;
  }

mattm

SELECT
  time,
  name,
  current_url
FROM (
  SELECT
    distinct_id, 
    CAST(JSON_EXTRACT_SCALAR(properties, "$.com_id") AS INT64) AS com_id
  FROM mp.event
  WHERE name = "Signed Up"

mattm

SELECT 
  properties,
  JSON_EXTRACT_SCALAR(properties, "$.com_id") AS com_id
FROM mp.event
WHERE name = "Signed Up"
LIMIT 1

+-----------------+--------+
|   properties    | com_id |
+-----------------+--------+

mattm

SELECT COUNT(*) FROM mp.event WHERE city = "Tokyo" AND DATE(time) = "2018-04-03"

mattm

mixpanel.track("Signed Up", {
    com_id: comId
});

mattm

<script>
  mixpanel.track("Viewed Page");
</script>

mattm

javascript:(function(){ 
  var newReferrer = prompt('Set the referrer:');
  Object.defineProperty(document, "referrer", {configurable: true, get : function(){ return newReferrer; }})
})();

mattm

SET @mpy_id = (SELECT MAX(mpy_id) + 1 from members_payments);

DROP TABLE IF EXISTS members_payments_all_ids;

CREATE TEMPORARY TABLE members_payments_all_ids AS (
	SELECT @mpy_id := @mpy_id - 1 AS mpy_id
	FROM members_payments mp1, members_payments mp2
	WHERE @mpy_id > 1
);

mattm

SET @mpy_id = (SELECT MAX(mpy_id) + 1 from members_payments);

DROP TABLE IF EXISTS members_payments_all_ids;

CREATE TEMPORARY TABLE members_payments_all_ids AS (
	SELECT @mpy_id := @mpy_id - 1 AS mpy_id
	FROM members_payments mp1, members_payments mp2
	WHERE @mpy_id > 1
);

mattm

SELECT mpy_id FROM members_payments WHERE mpy_id BETWEEN 1 AND 10;

+--------+
| mpy_id |
+--------+
|      1 |
|      4 |
|      6 |
|      9 |
|     10 |