03/05/28 12:30 37obhOpS
>>196
select * from
(select *,1 AS tmp from テーブル名 where (検索条件) and dateが３日以内 )
union
(select *,2 AS tmp from テーブル名 where (検索条件)
order by tmp, date desc , point desc
ってのは？
03/05/28 12:30 37obhOpS
>>196
select * from
(select *,1 AS tmp from テーブル名 where (検索条件) and dateが３日以内 )
union
(select *,2 AS tmp from テーブル名 where (検索条件)
order by tmp, date desc , point desc
ってのは？