videoalliance/.svn/pristine/c2/c29377f1c097a48c04203b63fed454e372d7e2f7.svn-base

<?xml version="1.0" encoding="UTF-8"?>
<properties>
	
	<property name="queryUserOrders">
		<![CDATA[
			select a.cpid, a.userid, a.status, a.orderstatus, a.ordertime, a.canceltime, a.endtime, a.effecttime, a.orderchannel, a.cancelchannel, a.productid, a.spid, a.type, nvl(b.limitflow, 0) limitflow from (
			select a.userid, a.status, a.orderstatus, a.orderchannel, a.cancelchannel, to_char(a.ordertime, 'yyyymmddhh24miss') ordertime, to_char(a.canceltime, 'yyyymmddhh24miss') canceltime, 
			to_char(a.endtime, 'yyyymmddhh24miss') endtime, to_char(a.effecttime, 'yyyymmddhh24miss') effecttime, 
			a.spid productid, a.cpid, b.type type, c.sdspid spid, a.province 
			from td_order_relations a, tb_sp_info b, tb_cp_account_config c 
			where a.cpid = b.cpid and a.spid = b.spid and a.cpid = c.cpid and a.status in ('0', '1') and a.userid = ?
			) a, tb_sp_config b where a.productid = b.spid(+) and a.province = b.province(+)
		]]>
	</property>
	
</properties>