MySQL と MariaDBの プリペアドステートメント　バインドパラメーターがSQL関数だった時の挙動の違い ref: http://qiita.com/AKB428/items/8be7059e7e2919cea090

file0.sql

SELECT h.follower, h.updated_at
      from twitter_status_histories as h,
      (SELECT id FROM bases WHERE twitter_account = 'usagi_anime' order by id desc limit 1) b
       where h.bases_id = b.id AND h.updated_at < ? order by h.updated_at desc limit 100

file1.sql

SELECT h.follower, h.updated_at
      from twitter_status_histories as h,
      (SELECT id FROM bases WHERE twitter_account = 'usagi_anime' order by id desc limit 1) b
       where h.bases_id = b.id AND h.updated_at < 'now()' order by h.updated_at desc limit 100

file1.txt

follower    updated_at
51345   2014-09-23 18:53:27
50606   2014-09-14 14:55:02
50607   2014-09-14 14:50:04
46350   2014-08-11 16:44:05

file2.txt

follower    updated_at
51345   2014-09-23 18:53:27
50606   2014-09-14 14:55:02
50607   2014-09-14 14:50:04
46350   2014-08-11 16:44:05

file3.txt

Empty set, 1 warning (0.00 sec)

file4.sql

SELECT h.follower, h.updated_at
      from twitter_status_histories as h,
      (SELECT id FROM bases WHERE twitter_account = 'usagi_anime' order by id desc limit 1) b
       where h.bases_id = b.id AND h.updated_at < now() order by h.updated_at desc limit 100

file4.txt

|   133727 | 2015-11-07 12:00:06 |
|   133717 | 2015-11-07 11:30:07 |
|   133707 | 2015-11-07 11:00:07 |
|   133701 | 2015-11-07 10:30:06 |

file5.txt

|   133727 | 2015-11-07 12:00:06 |
|   133717 | 2015-11-07 11:30:07 |
|   133707 | 2015-11-07 11:00:07 |
|   133701 | 2015-11-07 10:30:06 |