SELECT distinct(t1.vender_id),t1.*,province_master.province_name,province_master.province_name_eng FROM t_vender t1 left join t_content_category t2
on t1.vender_id=t2.content_id
left join province_master
on province_master.province_id=t1.province_id
where t2.type_id='3' and (t1.status_flg='A' || t1.status_flg='P') and (t1.pay_type='2' or t1.pay_type='1') and t1.province_id='60' order by t1.pay_type desc , rand()
SELECT distinct(t1.vender_id),t1.*,province_master.province_name,province_master.province_name_eng FROM t_vender t1 left join t_content_category t2
on t1.vender_id=t2.content_id
left join province_master
on province_master.province_id=t1.province_id
where t2.type_id='3' and (t1.status_flg='A' || t1.status_flg='P') and (t1.pay_type='2' or t1.pay_type='1') and t1.province_id='60' order by t1.pay_type desc , rand() limit 0,10
SELECT distinct(t1.vender_id),t1.*,province_master.province_name,province_master.province_name_eng FROM t_vender t1 left join t_content_category t2
on t1.vender_id=t2.content_id
left join province_master
on province_master.province_id=t1.province_id
where t2.type_id='3' and (t1.status_flg='A' || t1.status_flg='P') and ( t2.cat_id='9' ) and t1.province_id='60' order by t1.vender_name
SELECT distinct(t1.vender_id),t1.*,province_master.province_name,province_master.province_name_eng FROM t_vender t1 left join t_content_category t2
on t1.vender_id=t2.content_id
left join province_master
on province_master.province_id=t1.province_id
where t2.type_id='3' and (t1.status_flg='A' || t1.status_flg='P') and ( t2.cat_id='9' ) and t1.province_id='60' order by t1.vender_name
SELECT distinct(t1.vender_id),t1.*,province_master.province_name,province_master.province_name_eng FROM t_vender t1 left join t_content_category t2
on t1.vender_id=t2.content_id
left join province_master
on province_master.province_id=t1.province_id
where t2.type_id='3' and (t1.status_flg='A' || t1.status_flg='P') and ( t2.cat_id='9' ) and t1.status_flg='A' and t1.vender_id not in (Array) and t1.province_id='60' order by t1.vender_name
SELECT distinct(t1.vender_id),t1.*,province_master.province_name,province_master.province_name_eng FROM t_vender t1 left join t_content_category t2
on t1.vender_id=t2.content_id
left join province_master
on province_master.province_id=t1.province_id
where t2.type_id='3' and (t1.status_flg='A' || t1.status_flg='P') and ( t2.cat_id='9' ) and t1.province_id='60' order by t1.vender_name
SELECT distinct(t1.vender_id),t1.*,province_master.province_name,province_master.province_name_eng FROM t_vender t1 left join t_content_category t2
on t1.vender_id=t2.content_id
left join province_master
on province_master.province_id=t1.province_id
where t2.type_id='3' and (t1.status_flg='A' || t1.status_flg='P') and ( t2.cat_id='9' ) and t1.province_id='60' order by t1.vender_name
SELECT distinct(t1.vender_id),t1.*,province_master.province_name,province_master.province_name_eng FROM t_vender t1 left join t_content_category t2
on t1.vender_id=t2.content_id
left join province_master
on province_master.province_id=t1.province_id
where t2.type_id='3' and (t1.status_flg='A' || t1.status_flg='P') and ( t2.cat_id='9' ) and and t1.vender_id not in (Array) and t1.province_id='60' order by t1.vender_name
