string(704) "select
o.*
,c.is_public
,c.name
,c.display_name
,c.pref_code
,c.industry_code
,pref.pref_name
,pref.area_code
,oex.priority
,oex.role
from t_offer as o
LEFT JOIN t_offer_ext as oex using(offer_code)
LEFT JOIN admin_user as admin using(admin_code)
LEFT JOIN t_company as c on(c.company_code = o.company_code)
LEFT JOIN m_pref as pref on(pref.pref_code = o.search_pref)
LEFT JOIN m_area as area using(area_code)
LEFT JOIN m_pref as pref_search on(pref_search.pref_code = o.search_pref)
LEFT JOIN m_area as area_search on(area_search.area_code = pref_search.area_code)
WHERE o.is_active = 1
AND( o.status IN(1,2)) AND o.division = 'side' ORDER BY o.status ASC, o.start_at DESC "
====
地方副業の求人を探す｜地方転職・地方副業ならGMJ - グローカルミッションジョブズ
地方にこそ活躍の場がある。管理職・経営幹部のための地方求人メディアGMJ
string(768) "select
o.*
,c.is_public
,c.name
,c.display_name
,c.pref_code
,c.industry_code
,pref.pref_name
,pref.area_code
,oex.priority
,oex.role
from t_offer as o
LEFT JOIN t_offer_ext as oex using(offer_code)
LEFT JOIN admin_user as admin using(admin_code)
LEFT JOIN t_company as c on(c.company_code = o.company_code)
LEFT JOIN m_pref as pref on(pref.pref_code = o.search_pref)
LEFT JOIN m_area as area using(area_code)
LEFT JOIN m_pref as pref_search on(pref_search.pref_code = o.search_pref)
LEFT JOIN m_area as area_search on(area_search.area_code = pref_search.area_code)
WHERE o.is_active = 1
AND( oex.income_limit is null OR oex.income_limit = 700 ) AND( o.status IN(1,2,9)) AND o.division = 'main' ORDER BY o.updated_at DESC limit 10 offset 0"
====
