Shadow6363 · February 21, 2013 16:48
diff --git a/gistfile1.sql b/gistfile1.sql
 SELECT
    *,
    @rowNum := @rowNum + 1 as row_number
 FROM `datalog`
 JOIN ( SELECT @rowNum := 0 )
 WHERE
    MOD(row_number, 4) = 0 AND
    sensorid = '$sensor'   AND
    time >= '$timeOffset'
	SELECT
	*,
	@rowNum := @rowNum + 1 as row_number
	FROM `datalog`
	JOIN ( SELECT @rowNum := 0 )
	WHERE
	MOD(row_number, 4) = 0 AND
	sensorid = '$sensor' AND
	time >= '$timeOffset'