FF 11007015 11007019 SELECT * FROM RunLog_onl.beamInfo b where beginTime > "2010" and blueIntensity < 1 and yellowIntensity < 1 and blueIntensity > 0 and blueEnergy > 90 order by beginTime limit 50; 111003032 Junk 33 -"- 34 -"- 12066 Pedestal 22018 36080 38063 mysql> SELECT beginTime,runNumber,blueEnergy,blueIntensity,yellowEnergy,yellowIntensity FROM RunLog_onl.beamInfo b where beginTime > "2010" and blueIntensity < 10 and yellowIntensity < 10 and blueIntensity > 0 and blueEnergy > 90 and yellowIntensity > 0 order by beginTime limit 50; +---------------------+-----------+-------------+---------------+--------------+-----------------+ | beginTime | runNumber | blueEnergy | blueIntensity | yellowEnergy | yellowIntensity | +---------------------+-----------+-------------+---------------+--------------+-----------------+ | 2010-01-05 16:58:56 | 11005051 | 99.90799713 | 5.05800009 | 99.90799713 | 5.26300001 | junk | 2010-01-05 16:59:22 | 11005052 | 99.90799713 | 5.05800009 | 99.90799713 | 5.26300001 | tune_2010 | 2010-01-06 23:56:48 | 11006081 | 99.90799713 | 6.46400023 | 99.90799713 | 6.40000010 | | 2010-01-07 21:37:57 | 11007095 | 99.90799713 | 0.76700002 | 99.90799713 | 5.30999994 | | 2010-01-07 21:42:23 | 11007096 | 99.90799713 | 0.65700001 | 99.90799713 | 5.27400017 | | 2010-01-08 03:02:33 | 11007104 | 99.90799713 | 2.98300004 | 99.90799713 | 3.80399990 | | 2010-01-08 04:12:36 | 11007116 | 99.90799713 | 5.29600000 | 99.90799713 | 3.11700010 | | 2010-01-08 05:01:52 | 11008001 | 99.90799713 | 0.25400001 | 99.90799713 | 2.25300002 | | 2010-01-09 03:29:19 | 11008068 | 99.90799713 | 6.71999979 | 99.90799713 | 4.21799994 | | 2010-01-09 03:31:51 | 11008069 | 99.90799713 | 6.38899994 | 99.90799713 | 4.05100012 | | 2010-01-09 03:42:19 | 11008070 | 99.90799713 | 5.34700012 | 99.90799713 | 3.37400007 | | 2010-01-09 03:51:46 | 11008071 | 99.90799713 | 4.93499994 | 99.90799713 | 2.28099990 | | 2010-01-09 03:57:27 | 11008072 | 99.90799713 | 4.84100008 | 99.90799713 | 1.94400001 | | 2010-01-09 04:01:01 | 11008073 | 99.90799713 | 4.74499989 | 99.90799713 | 1.94000006 | | 2010-01-09 04:03:26 | 11008074 | 99.90799713 | 4.68699980 | 99.90799713 | 1.93799996 | | 2010-01-09 04:10:40 | 11008075 | 99.90799713 | 4.52899981 | 99.90799713 | 1.92200005 | | 2010-01-09 05:43:55 | 11009007 | 99.90799713 | 9.24899960 | 99.90799713 | 8.62699986 | | 2010-01-13 03:42:36 | 11012082 | 99.90799713 | 4.90100002 | 99.90799713 | 2.63599992 | | 2010-01-13 03:44:35 | 11012083 | 99.90799713 | 4.88800001 | 99.90799713 | 2.62199998 | | 2010-01-13 03:48:57 | 11012084 | 99.90799713 | 4.86499977 | 99.90799713 | 2.59599996 | | 2010-01-20 13:49:20 | 11020025 | 99.90799713 | 5.83099985 | 99.90799713 | 6.24300003 | | 2010-01-20 13:51:25 | 11020026 | 99.90799713 | 5.82900000 | 99.90799713 | 6.23899984 | | 2010-01-20 14:14:40 | 11020027 | 99.90799713 | 5.79899979 | 99.90799713 | 6.13700008 | | 2010-01-20 14:16:35 | 11020028 | 99.90799713 | 5.79699993 | 99.90799713 | 6.13199997 | | 2010-01-20 14:44:32 | 11020029 | 99.90799713 | 5.60599995 | 99.90799713 | 5.61199999 | | 2010-01-20 23:24:23 | 11020048 | 99.90799713 | 6.10500002 | 99.90799713 | 0.00100000 | | 2010-01-20 23:30:21 | 11020049 | 99.90799713 | 6.06199980 | 99.90799713 | 0.00100000 | | 2010-01-28 18:13:08 | 11028038 | 99.90799713 | 6.21299982 | 99.90799713 | 6.66900015 | | 2010-01-28 18:15:23 | 11028039 | 99.90799713 | 6.19799995 | 99.90799713 | 6.65799999 | | 2010-01-28 18:16:09 | 11028040 | 99.90799713 | 6.19000006 | 99.90799713 | 6.65000010 | | 2010-01-28 18:20:09 | 11028041 | 99.90799713 | 6.16300011 | 99.90799713 | 6.63199997 | | 2010-02-04 17:35:11 | 11035034 | 99.90799713 | 6.00199986 | 99.90799713 | 6.68800020 | | 2010-02-05 17:35:09 | 11036065 | 92.93599701 | 6.83300018 | 92.93599701 | 7.08400011 | +---------------------+-----------+-------------+---------------+--------------+-----------------+ 33 rows in set, 1 warning (0.13 sec)