3225
3225
AND t1.ts BETWEEN "2006-01-01" AND "2006-12-31";
3226
3226
id select_type table type possible_keys key key_len ref rows Extra
3227
3227
1 SIMPLE t2 const PRIMARY PRIMARY 4 const 1
3229
3229
SELECT * FROM t1 LEFT JOIN t2 ON (t1.a=t2.a) WHERE t1.a=30
3230
3230
AND t1.ts BETWEEN t2.dt1 AND t2.dt2
3231
3231
AND t1.ts BETWEEN "2006-01-01" AND "2006-12-31";