Test Date
来源:互联网 发布:java软件开发自学 编辑:程序博客网 时间:2024/06/06 14:04
select travel0_.travelid as col_0_0_,
prices1_.priceid as col_1_0_,
travelagen2_.travelagencyid as col_2_0_,
prices1_.name as col_3_0_,
travelagen2_.name as col_4_0_
from travel travel0_ , price prices1_ , travelagency travelagen2_
where travel0_.travelagencyid=travelagen2_.travelagencyid
and travel0_.traveltypeid<=2
and travel0_.stat=1
and to_days(travel0_.startdate)>=to_days('2006-7-1')
and to_days(travel0_.enddate)<=to_days('2006-12-11')
and travel0_.travelid=prices1_.travelid
order by travel0_.lastdate Desc limit 40
prices1_.priceid as col_1_0_,
travelagen2_.travelagencyid as col_2_0_,
prices1_.name as col_3_0_,
travelagen2_.name as col_4_0_
from travel travel0_ , price prices1_ , travelagency travelagen2_
where travel0_.travelagencyid=travelagen2_.travelagencyid
and travel0_.traveltypeid<=2
and travel0_.stat=1
and to_days(travel0_.startdate)>=to_days('2006-7-1')
and to_days(travel0_.enddate)<=to_days('2006-12-11')
and travel0_.travelid=prices1_.travelid
order by travel0_.lastdate Desc limit 40
- Test Date
- date
- date
- date
- Date
- date
- date
- date
- date
- date
- date
- date
- date
- date
- date
- date
- date
- date
- 日本人的生活
- 我的日记本--- 2006.08.15 (之我的pizza梦)
- 日本一年纪行之吃在日本
- 日本一年纪行之吃在日本(续)
- Dom4j 学习笔记
- Test Date
- SAP推出Enterprise SOA架构
- 余世维眼中的2015年中日战争
- 关于赴东京留学的省钱问题(转载)
- Test Java
- 从今天开始,在半年内掌握JAVA应用于实际项目的技能
- 再谈单例模式
- 偏执狂才能生存,flickr的若干举措如是说
- precompile