SELECT id,created_at,lottery_no FROM wind_test WHERE deleted_at IS NULL AND ( (account_name = ‘5_feb029’) AND (created_at >= ‘2020-03-10’) AND ( created_at <= ‘2020-03-10 23:59:59’ ) AND (site_id = 5) ) ORDER BY created_at desc, lottery_no desc;
SELECT id,created_at,lottery_no FROM wind_test WHERE deleted_at IS NULL AND ( (account_name = ‘5_feb029’) AND (created_at >= ‘2020-03-10’) AND ( created_at <= ‘2020-03-10 23:59:59’ ) AND (site_id = 5) ) ORDER BY created_at desc, lottery_no desc limit 10;
SELECT id,created_at,lottery_no FROM wind_test WHERE deleted_at IS NULL AND ( (account_name = ‘5_feb029’) AND (created_at >= ‘2020-03-10 00:00:00’) AND ( created_at <= ‘2020-03-10 23:59:59’ ) AND (site_id = 5) ) ORDER BY created_at desc, lottery_no desc limit 0,5;
SELECT id,created_at,lottery_no FROM wind_test WHERE deleted_at IS NULL AND ( (account_name = ‘5_feb029’) AND (created_at >= ‘2020-03-10 00:00:00’) AND ( created_at <= ‘2020-03-10 23:59:59’ ) AND (site_id = 5) ) ORDER BY created_at desc, lottery_no desc limit 5,5;