脳疾患の術後のリハビリをお願いします。 - Dr.Agent (F1303005)

TOP > 脳疾患の術後のリハビリをお願いします。 - Dr.Agent (F1303005)

この求人へのお申し込み・お問い合わせは、ページ内のお問い合わせフォームもしくはお電話で承ります。
お問い合わせフォームをご利用の方は会員登録をしていただくと次回からご入力を短縮していただけます。
脳疾患の術後のリハビリをお願いします。
勤務地 福岡県福岡市 JOB番号 F1303005
募集科目 脳神経外科 お気に入り
年収 1500~1800万円(税込)
こだわり
当直無し 週4-4.5日 救急告示なし
担当者からの「ここがポイント!」 松本 泰英 担当者:松本 泰英
(⇒その他の担当案件

福岡市にある病院です。術後の脳疾患患者のリハビリをメインにお願いします。
JR駅近くの交通の便の良い病院です。

<募集科目>-----------------------------------------------------
・脳神経外科または神経内科
地域中核の病院との連携パスによる疾患別の患者受け入れ可能な常勤医師の体制作りのための募集です。

<募集科目の業務内容について>----------------------------------
脳疾患の急性期からのリハビリを主とした患者の受け入れ。
・病棟担当(15~20人程度)
・専門外来1~2コマ(相談)

<担当エージェントより>------------------------------------------
「当直無し」「週4.5日勤務」の案件です。
回復リハビリ病棟を有しており、近隣の急性期病院からの術後患者さんを受け入れており(脳疾患・整形疾患)、その患者さんの術後のリハビリなどをメインにご担当いただける方。
交通の便利の良い地域に立地していますので、公共交通機関(JR)や車での通勤も便利ですので、市内や近隣のお住まいの先生にはお 奨めします。Uターンでの就職希望の先生も歓迎いたします。
勤務条件については、ご相談に応じますので、まずはご希望の条件など弊社担当者までお問合せ下さい。

 

↓横幅1021px



 



<施設概要>------------------------------------------------------
□病 床 数:200床未満(内訳:一般・回復期)
□標榜科目:内科・外科・整形外科・他

<勤務条件>-----------------------------------------------------
□勤務時間:平日9:00~17:00、土曜日9:00~13:00
      ※週1回早出(7:30)、居残(19時)があります。
□休  日:週2.5日(土半日・日・研修日)
□当  直:無し
□給  与:1300万円~1800万円
      ※給与については一応の目安として記載になります。
□学会参加:有
□交通費:年俸に含む

病院ID 医師会員様のみ公開 救急告示 なし
施設名 医師会員様のみ公開 業種(区分) 一般
所在地 医師会員様のみ公開
病床数 医師会員様のみ公開
主な診療科目 医師会員様のみ公開
追記事項 医師会員様のみ公開

この求人へのお申し込み・お問い合わせ

非会員の方は、以下の求人お問い合わせフォームをご利用下さい

お問い合わせフォーム
名 前
必須
 
姓と名の間にスペースを入れて下さい(例:求人 太郎)
フリガナ
必須
性 別
必須
男性 女性 
メールアドレス
必須
電話番号 自宅電話  ※ハイフンなし(例:00000000000)
携帯電話  ※ハイフンなし(例:00000000000)
住 所
必須
  ※都道府県のみ必須です
※市区町村以下をご入力下さい
医師免許取得年
必須
西暦年  ※西暦で入力下さい(例:1995)
専門科目
必須
転職時期
必須
決まり次第  3ヶ月以内  半年以内  1年以内  未定  
ご質問・ご希望勤務地、その他ご要望など
>>文例を見る
無料会員登録
医師のアルバイト・スポット・定期非常勤
エージェントの情報ひろば
原 良彰
東京 原です
東京Office
原 良彰
東京都の求人を今後掲載します。
小林 久美子
東京から・・・
福岡Office
小林 久美子
5月から東京の求人を掲載します…
山崎 和彦
関西を担当しています
福岡Office
山崎 和彦
山崎です。天草出身ですが・・・…
宮崎 敬二
テスト
福岡Office
宮崎 敬二
てすとてすとてすとてすとてすと…
松本 泰英
松本です
福岡Office
松本 泰英
福岡を中心に掲載します。
運営会社からのお知らせ
(default) 31 queries took 3 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1SELECT `Prefecture`.`id`, `Prefecture`.`name` FROM `aa127a1w3g`.`develop-dajp_prefectures` AS `Prefecture` WHERE 1 = 1 ORDER BY `Prefecture`.`id` asc47470
2SELECT `Agent`.`id`, `Agent`.`name` FROM `aa127a1w3g`.`develop-dajp_agents` AS `Agent` WHERE `Agent`.`delflg` = 0 ORDER BY `Agent`.`branch` asc, `Agent`.`id` asc880
3SELECT `Department`.`id`, `Department`.`name` FROM `aa127a1w3g`.`develop-dajp_departments` AS `Department` WHERE 1 = 1 ORDER BY `Department`.`odrno` asc33330
4SELECT `Job`.`id`, `Job`.`jobid`, `Job`.`ymd`, `Job`.`hospital_id`, `Job`.`prefecture_id`, `Job`.`address1`, `Job`.`address2`, `Job`.`department_id`, `Job`.`income`, `Job`.`agent_id`, `Job`.`title`, `Job`.`body`, `Job`.`addinfo`, `Job`.`open_flg`, `Job`.`flg1`, `Job`.`flg2`, `Job`.`flg3`, `Job`.`flg4`, `Job`.`flg5`, `Job`.`flg6`, `Job`.`flg7`, `Job`.`flg8`, `Job`.`flg9`, `Job`.`flg10`, `Job`.`adminfo`, `Job`.`stopflg`, `Job`.`delflg`, `Job`.`created`, `Job`.`modified`, `HospitalDepartment`.`id`, `HospitalDepartment`.`dept1`, `HospitalDepartment`.`dept2`, `HospitalDepartment`.`dept3`, `HospitalDepartment`.`dept4`, `HospitalDepartment`.`dept5`, `HospitalDepartment`.`dept6`, `HospitalDepartment`.`dept7`, `HospitalDepartment`.`dept8`, `HospitalDepartment`.`dept9`, `HospitalDepartment`.`dept10`, `HospitalDepartment`.`dept11`, `HospitalDepartment`.`dept12`, `HospitalDepartment`.`dept13`, `HospitalDepartment`.`dept14`, `HospitalDepartment`.`dept15`, `HospitalDepartment`.`dept16`, `HospitalDepartment`.`dept17`, `HospitalDepartment`.`dept18`, `HospitalDepartment`.`dept19`, `HospitalDepartment`.`dept20`, `HospitalDepartment`.`dept21`, `HospitalDepartment`.`dept22`, `HospitalDepartment`.`dept23`, `HospitalDepartment`.`dept24`, `HospitalDepartment`.`dept25`, `HospitalDepartment`.`dept26`, `HospitalDepartment`.`dept27`, `HospitalDepartment`.`dept28`, `HospitalDepartment`.`dept29`, `HospitalDepartment`.`dept30`, `HospitalDepartment`.`dept31`, `HospitalDepartment`.`dept32`, `HospitalDepartment`.`dept33`, `HospitalDepartment`.`dept34`, `HospitalDepartment`.`dept35`, `HospitalDepartment`.`dept36`, `HospitalDepartment`.`dept37`, `HospitalDepartment`.`dept38`, `HospitalDepartment`.`dept39`, `HospitalDepartment`.`dept40`, `HospitalDepartment`.`dept41`, `HospitalDepartment`.`dept42`, `HospitalDepartment`.`dept43`, `HospitalDepartment`.`dept44`, `HospitalDepartment`.`dept45`, `HospitalDepartment`.`dept46`, `HospitalDepartment`.`dept47`, `HospitalDepartment`.`dept48`, `HospitalDepartment`.`dept49`, `HospitalDepartment`.`dept50`, `HospitalDepartment`.`dept51`, `HospitalDepartment`.`dept52`, `HospitalDepartment`.`dept53`, `HospitalDepartment`.`dept54`, `HospitalDepartment`.`dept55`, `HospitalDepartment`.`dept56`, `HospitalDepartment`.`dept57`, `HospitalDepartment`.`dept58`, `HospitalDepartment`.`dept59`, `HospitalDepartment`.`dept60`, `HospitalDepartment`.`dept61`, `HospitalDepartment`.`dept62`, `HospitalDepartment`.`dept63`, `HospitalDepartment`.`dept64`, `HospitalDepartment`.`dept65`, `HospitalDepartment`.`dept66`, `HospitalDepartment`.`dept67`, `HospitalDepartment`.`dept68`, `HospitalDepartment`.`dept69`, `HospitalDepartment`.`dept70`, `HospitalDepartment`.`dept71`, `HospitalDepartment`.`dept72`, `HospitalDepartment`.`dept73`, `HospitalDepartment`.`dept74`, `HospitalDepartment`.`dept75`, `HospitalDepartment`.`dept76`, `HospitalDepartment`.`dept77`, `HospitalDepartment`.`dept78`, `HospitalDepartment`.`dept79`, `HospitalDepartment`.`dept80`, `HospitalDepartment`.`dept81`, `HospitalDepartment`.`dept82`, `HospitalDepartment`.`dept83`, `HospitalDepartment`.`dept84`, `HospitalDepartment`.`dept85`, `HospitalDepartment`.`dept86`, `HospitalDepartment`.`dept87`, `HospitalDepartment`.`dept88`, `HospitalDepartment`.`dept89`, `HospitalDepartment`.`dept90`, `HospitalDepartment`.`dept91`, `HospitalDepartment`.`dept92`, `HospitalDepartment`.`dept93`, `HospitalDepartment`.`dept94`, `HospitalDepartment`.`dept95`, `HospitalDepartment`.`dept96`, `HospitalDepartment`.`dept97`, `HospitalDepartment`.`dept98`, `HospitalDepartment`.`dept99`, `HospitalDepartment`.`created`, `HospitalDepartment`.`modified`, `Agent`.`id`, `Agent`.`branch`, `Agent`.`name`, `Agent`.`name2`, `Agent`.`email`, `Agent`.`imgurl`, `Agent`.`odrno`, `Agent`.`delflg`, `Agent`.`created`, `Agent`.`modified`, `Prefecture`.`id`, `Prefecture`.`area_id`, `Prefecture`.`westflg`, `Prefecture`.`name`, `Hospital`.`id`, `Hospital`.`hosid`, `Hospital`.`name`, `Hospital`.`prefecture_id`, `Hospital`.`address1`, `Hospital`.`address2`, `Hospital`.`erflg`, `Hospital`.`gyocd`, `Hospital`.`bedinfo`, `Hospital`.`addinfo`, `Hospital`.`adminfo`, `Hospital`.`delflg`, `Hospital`.`stopflg`, `Hospital`.`created`, `Hospital`.`modified` FROM `aa127a1w3g`.`develop-dajp_jobs` AS `Job` LEFT JOIN `aa127a1w3g`.`develop-dajp_hospital_departments` AS `HospitalDepartment` ON (`Job`.`hospital_id` = `HospitalDepartment`.`id`) LEFT JOIN `aa127a1w3g`.`develop-dajp_agents` AS `Agent` ON (`Job`.`agent_id` = `Agent`.`id`) LEFT JOIN `aa127a1w3g`.`develop-dajp_prefectures` AS `Prefecture` ON (`Job`.`prefecture_id` = `Prefecture`.`id`) LEFT JOIN `aa127a1w3g`.`develop-dajp_hospitals` AS `Hospital` ON (`Job`.`hospital_id` = `Hospital`.`id`) WHERE `Job`.`id` = 5 AND `Job`.`delflg` = 0 AND `Job`.`ymd` <= '2024/12/01' LIMIT 1111
5SELECT `Prefecture`.`id`, `Prefecture`.`area_id`, `Prefecture`.`westflg`, `Prefecture`.`name` FROM `aa127a1w3g`.`develop-dajp_prefectures` AS `Prefecture` WHERE `Prefecture`.`id` = 40 LIMIT 1110
6SELECT `Prefecture`.`id`, `Prefecture`.`area_id`, `Prefecture`.`westflg`, `Prefecture`.`name` FROM `aa127a1w3g`.`develop-dajp_prefectures` AS `Prefecture` WHERE `Prefecture`.`id` = 40 LIMIT 1110
7SELECT `Prefecture`.`id`, `Prefecture`.`area_id`, `Prefecture`.`westflg`, `Prefecture`.`name` FROM `aa127a1w3g`.`develop-dajp_prefectures` AS `Prefecture` WHERE `Prefecture`.`id` = 40 LIMIT 1110
8SELECT `Department`.`id`, `Department`.`name`, `Department`.`odrno`, `Department`.`flg1`, `Department`.`flg2`, `Department`.`flg3` FROM `aa127a1w3g`.`develop-dajp_departments` AS `Department` WHERE `Department`.`id` = 24 LIMIT 1110
9SELECT `Prefecture`.`id`, `Prefecture`.`area_id`, `Prefecture`.`westflg`, `Prefecture`.`name` FROM `aa127a1w3g`.`develop-dajp_prefectures` AS `Prefecture` WHERE `Prefecture`.`id` = 40 LIMIT 1110
10SELECT `Prefecture`.`id`, `Prefecture`.`area_id`, `Prefecture`.`westflg`, `Prefecture`.`name` FROM `aa127a1w3g`.`develop-dajp_prefectures` AS `Prefecture` WHERE `Prefecture`.`id` = 40 LIMIT 1110
11SELECT `Department`.`id`, `Department`.`name`, `Department`.`odrno`, `Department`.`flg1`, `Department`.`flg2`, `Department`.`flg3` FROM `aa127a1w3g`.`develop-dajp_departments` AS `Department` WHERE `Department`.`id` = 24 LIMIT 1110
12SELECT `Department`.`id`, `Department`.`name`, `Department`.`odrno`, `Department`.`flg1`, `Department`.`flg2`, `Department`.`flg3` FROM `aa127a1w3g`.`develop-dajp_departments` AS `Department` WHERE `Department`.`id` = 24 LIMIT 1110
13SELECT `Department`.`id`, `Department`.`name`, `Department`.`odrno`, `Department`.`flg1`, `Department`.`flg2`, `Department`.`flg3` FROM `aa127a1w3g`.`develop-dajp_departments` AS `Department` WHERE `Department`.`id` = 24 LIMIT 1110
14SELECT `Job`.`id`, `Job`.`jobid`, `Job`.`ymd`, `Job`.`hospital_id`, `Job`.`prefecture_id`, `Job`.`address1`, `Job`.`address2`, `Job`.`department_id`, `Job`.`income`, `Job`.`agent_id`, `Job`.`title`, `Job`.`body`, `Job`.`addinfo`, `Job`.`open_flg`, `Job`.`flg1`, `Job`.`flg2`, `Job`.`flg3`, `Job`.`flg4`, `Job`.`flg5`, `Job`.`flg6`, `Job`.`flg7`, `Job`.`flg8`, `Job`.`flg9`, `Job`.`flg10`, `Job`.`adminfo`, `Job`.`stopflg`, `Job`.`delflg`, `Job`.`created`, `Job`.`modified`, `HospitalDepartment`.`id`, `HospitalDepartment`.`dept1`, `HospitalDepartment`.`dept2`, `HospitalDepartment`.`dept3`, `HospitalDepartment`.`dept4`, `HospitalDepartment`.`dept5`, `HospitalDepartment`.`dept6`, `HospitalDepartment`.`dept7`, `HospitalDepartment`.`dept8`, `HospitalDepartment`.`dept9`, `HospitalDepartment`.`dept10`, `HospitalDepartment`.`dept11`, `HospitalDepartment`.`dept12`, `HospitalDepartment`.`dept13`, `HospitalDepartment`.`dept14`, `HospitalDepartment`.`dept15`, `HospitalDepartment`.`dept16`, `HospitalDepartment`.`dept17`, `HospitalDepartment`.`dept18`, `HospitalDepartment`.`dept19`, `HospitalDepartment`.`dept20`, `HospitalDepartment`.`dept21`, `HospitalDepartment`.`dept22`, `HospitalDepartment`.`dept23`, `HospitalDepartment`.`dept24`, `HospitalDepartment`.`dept25`, `HospitalDepartment`.`dept26`, `HospitalDepartment`.`dept27`, `HospitalDepartment`.`dept28`, `HospitalDepartment`.`dept29`, `HospitalDepartment`.`dept30`, `HospitalDepartment`.`dept31`, `HospitalDepartment`.`dept32`, `HospitalDepartment`.`dept33`, `HospitalDepartment`.`dept34`, `HospitalDepartment`.`dept35`, `HospitalDepartment`.`dept36`, `HospitalDepartment`.`dept37`, `HospitalDepartment`.`dept38`, `HospitalDepartment`.`dept39`, `HospitalDepartment`.`dept40`, `HospitalDepartment`.`dept41`, `HospitalDepartment`.`dept42`, `HospitalDepartment`.`dept43`, `HospitalDepartment`.`dept44`, `HospitalDepartment`.`dept45`, `HospitalDepartment`.`dept46`, `HospitalDepartment`.`dept47`, `HospitalDepartment`.`dept48`, `HospitalDepartment`.`dept49`, `HospitalDepartment`.`dept50`, `HospitalDepartment`.`dept51`, `HospitalDepartment`.`dept52`, `HospitalDepartment`.`dept53`, `HospitalDepartment`.`dept54`, `HospitalDepartment`.`dept55`, `HospitalDepartment`.`dept56`, `HospitalDepartment`.`dept57`, `HospitalDepartment`.`dept58`, `HospitalDepartment`.`dept59`, `HospitalDepartment`.`dept60`, `HospitalDepartment`.`dept61`, `HospitalDepartment`.`dept62`, `HospitalDepartment`.`dept63`, `HospitalDepartment`.`dept64`, `HospitalDepartment`.`dept65`, `HospitalDepartment`.`dept66`, `HospitalDepartment`.`dept67`, `HospitalDepartment`.`dept68`, `HospitalDepartment`.`dept69`, `HospitalDepartment`.`dept70`, `HospitalDepartment`.`dept71`, `HospitalDepartment`.`dept72`, `HospitalDepartment`.`dept73`, `HospitalDepartment`.`dept74`, `HospitalDepartment`.`dept75`, `HospitalDepartment`.`dept76`, `HospitalDepartment`.`dept77`, `HospitalDepartment`.`dept78`, `HospitalDepartment`.`dept79`, `HospitalDepartment`.`dept80`, `HospitalDepartment`.`dept81`, `HospitalDepartment`.`dept82`, `HospitalDepartment`.`dept83`, `HospitalDepartment`.`dept84`, `HospitalDepartment`.`dept85`, `HospitalDepartment`.`dept86`, `HospitalDepartment`.`dept87`, `HospitalDepartment`.`dept88`, `HospitalDepartment`.`dept89`, `HospitalDepartment`.`dept90`, `HospitalDepartment`.`dept91`, `HospitalDepartment`.`dept92`, `HospitalDepartment`.`dept93`, `HospitalDepartment`.`dept94`, `HospitalDepartment`.`dept95`, `HospitalDepartment`.`dept96`, `HospitalDepartment`.`dept97`, `HospitalDepartment`.`dept98`, `HospitalDepartment`.`dept99`, `HospitalDepartment`.`created`, `HospitalDepartment`.`modified`, `Agent`.`id`, `Agent`.`branch`, `Agent`.`name`, `Agent`.`name2`, `Agent`.`email`, `Agent`.`imgurl`, `Agent`.`odrno`, `Agent`.`delflg`, `Agent`.`created`, `Agent`.`modified`, `Prefecture`.`id`, `Prefecture`.`area_id`, `Prefecture`.`westflg`, `Prefecture`.`name`, `Hospital`.`id`, `Hospital`.`hosid`, `Hospital`.`name`, `Hospital`.`prefecture_id`, `Hospital`.`address1`, `Hospital`.`address2`, `Hospital`.`erflg`, `Hospital`.`gyocd`, `Hospital`.`bedinfo`, `Hospital`.`addinfo`, `Hospital`.`adminfo`, `Hospital`.`delflg`, `Hospital`.`stopflg`, `Hospital`.`created`, `Hospital`.`modified` FROM `aa127a1w3g`.`develop-dajp_jobs` AS `Job` LEFT JOIN `aa127a1w3g`.`develop-dajp_hospital_departments` AS `HospitalDepartment` ON (`Job`.`hospital_id` = `HospitalDepartment`.`id`) LEFT JOIN `aa127a1w3g`.`develop-dajp_agents` AS `Agent` ON (`Job`.`agent_id` = `Agent`.`id`) LEFT JOIN `aa127a1w3g`.`develop-dajp_prefectures` AS `Prefecture` ON (`Job`.`prefecture_id` = `Prefecture`.`id`) LEFT JOIN `aa127a1w3g`.`develop-dajp_hospitals` AS `Hospital` ON (`Job`.`hospital_id` = `Hospital`.`id`) WHERE `Job`.`jobid` <> '' AND NOT (`Job`.`jobid` IS NULL) AND `Job`.`delflg` = 0 AND `Agent`.`delflg` = 0 AND `Hospital`.`delflg` = 0 AND `Job`.`prefecture_id` = (40) AND `Job`.`department_id` = 24 AND `Job`.`ymd` <= '2024/12/01' AND `Job`.`id` <> 5 ORDER BY `Job`.`stopflg` asc, `Job`.`ymd` desc, `Job`.`modified` desc, `Job`.`id` desc LIMIT 3001
15SELECT COUNT(*) AS `count` FROM `aa127a1w3g`.`develop-dajp_jobs` AS `Job` LEFT JOIN `aa127a1w3g`.`develop-dajp_hospital_departments` AS `HospitalDepartment` ON (`Job`.`hospital_id` = `HospitalDepartment`.`id`) LEFT JOIN `aa127a1w3g`.`develop-dajp_agents` AS `Agent` ON (`Job`.`agent_id` = `Agent`.`id`) LEFT JOIN `aa127a1w3g`.`develop-dajp_prefectures` AS `Prefecture` ON (`Job`.`prefecture_id` = `Prefecture`.`id`) LEFT JOIN `aa127a1w3g`.`develop-dajp_hospitals` AS `Hospital` ON (`Job`.`hospital_id` = `Hospital`.`id`) WHERE `Job`.`jobid` <> '' AND NOT (`Job`.`jobid` IS NULL) AND `Job`.`delflg` = 0 AND `Agent`.`delflg` = 0 AND `Hospital`.`delflg` = 0 AND `Job`.`prefecture_id` = (40) AND `Job`.`department_id` = 24 AND `Job`.`ymd` <= '2024/12/01' AND `Job`.`id` <> 5110
16SELECT `Department`.`id`, `Department`.`name`, `Department`.`odrno`, `Department`.`flg1`, `Department`.`flg2`, `Department`.`flg3` FROM `aa127a1w3g`.`develop-dajp_departments` AS `Department` WHERE `Department`.`id` = 24 LIMIT 1110
17SELECT `Department`.`id`, `Department`.`name`, `Department`.`odrno`, `Department`.`flg1`, `Department`.`flg2`, `Department`.`flg3` FROM `aa127a1w3g`.`develop-dajp_departments` AS `Department` WHERE `Department`.`id` = 24 LIMIT 1110
18SELECT * FROM (SELECT agent_id as id,name,TBL.ymd FROM (SELECT agent_id,max(ymd) as ymd FROM `develop-dajp_recommends` WHERE ymd<='20241201' AND delflg=0 GROUP BY agent_id) AS TBL LEFT JOIN `develop-dajp_agents` ON `develop-dajp_agents`.id = TBL.agent_id WHERE delflg=0 and branch=0) AS Agent ORDER BY ymd desc441
19SELECT `Recommend`.`id`, `Recommend`.`recomid`, `Recommend`.`job_id`, `Recommend`.`ymd`, `Recommend`.`agent_id`, `Recommend`.`title`, `Recommend`.`body`, `Recommend`.`delflg`, `Recommend`.`created`, `Recommend`.`modified`, `Agent`.`id`, `Agent`.`branch`, `Agent`.`name`, `Agent`.`name2`, `Agent`.`email`, `Agent`.`imgurl`, `Agent`.`odrno`, `Agent`.`delflg`, `Agent`.`created`, `Agent`.`modified` FROM `aa127a1w3g`.`develop-dajp_recommends` AS `Recommend` LEFT JOIN `aa127a1w3g`.`develop-dajp_agents` AS `Agent` ON (`Recommend`.`agent_id` = `Agent`.`id`) WHERE `Recommend`.`delflg` = 0 AND `Recommend`.`ymd` <= '2024/12/01' AND `Recommend`.`agent_id` = 5 ORDER BY `Recommend`.`ymd` desc, `Recommend`.`modified` desc LIMIT 1110
20SELECT `Recommend`.`id`, `Recommend`.`recomid`, `Recommend`.`job_id`, `Recommend`.`ymd`, `Recommend`.`agent_id`, `Recommend`.`title`, `Recommend`.`body`, `Recommend`.`delflg`, `Recommend`.`created`, `Recommend`.`modified`, `Agent`.`id`, `Agent`.`branch`, `Agent`.`name`, `Agent`.`name2`, `Agent`.`email`, `Agent`.`imgurl`, `Agent`.`odrno`, `Agent`.`delflg`, `Agent`.`created`, `Agent`.`modified` FROM `aa127a1w3g`.`develop-dajp_recommends` AS `Recommend` LEFT JOIN `aa127a1w3g`.`develop-dajp_agents` AS `Agent` ON (`Recommend`.`agent_id` = `Agent`.`id`) WHERE `Recommend`.`delflg` = 0 AND `Recommend`.`ymd` <= '2024/12/01' AND `Recommend`.`agent_id` = 4 ORDER BY `Recommend`.`ymd` desc, `Recommend`.`modified` desc LIMIT 1110
21SELECT `Recommend`.`id`, `Recommend`.`recomid`, `Recommend`.`job_id`, `Recommend`.`ymd`, `Recommend`.`agent_id`, `Recommend`.`title`, `Recommend`.`body`, `Recommend`.`delflg`, `Recommend`.`created`, `Recommend`.`modified`, `Agent`.`id`, `Agent`.`branch`, `Agent`.`name`, `Agent`.`name2`, `Agent`.`email`, `Agent`.`imgurl`, `Agent`.`odrno`, `Agent`.`delflg`, `Agent`.`created`, `Agent`.`modified` FROM `aa127a1w3g`.`develop-dajp_recommends` AS `Recommend` LEFT JOIN `aa127a1w3g`.`develop-dajp_agents` AS `Agent` ON (`Recommend`.`agent_id` = `Agent`.`id`) WHERE `Recommend`.`delflg` = 0 AND `Recommend`.`ymd` <= '2024/12/01' AND `Recommend`.`agent_id` = 2 ORDER BY `Recommend`.`ymd` desc, `Recommend`.`modified` desc LIMIT 1110
22SELECT `Recommend`.`id`, `Recommend`.`recomid`, `Recommend`.`job_id`, `Recommend`.`ymd`, `Recommend`.`agent_id`, `Recommend`.`title`, `Recommend`.`body`, `Recommend`.`delflg`, `Recommend`.`created`, `Recommend`.`modified`, `Agent`.`id`, `Agent`.`branch`, `Agent`.`name`, `Agent`.`name2`, `Agent`.`email`, `Agent`.`imgurl`, `Agent`.`odrno`, `Agent`.`delflg`, `Agent`.`created`, `Agent`.`modified` FROM `aa127a1w3g`.`develop-dajp_recommends` AS `Recommend` LEFT JOIN `aa127a1w3g`.`develop-dajp_agents` AS `Agent` ON (`Recommend`.`agent_id` = `Agent`.`id`) WHERE `Recommend`.`delflg` = 0 AND `Recommend`.`ymd` <= '2024/12/01' AND `Recommend`.`agent_id` = 3 ORDER BY `Recommend`.`ymd` desc, `Recommend`.`modified` desc LIMIT 1110
23SELECT * FROM (SELECT agent_id as id,name,TBL.ymd FROM (SELECT agent_id,max(ymd) as ymd FROM `develop-dajp_recommends` WHERE ymd<='20241201' AND delflg=0 GROUP BY agent_id) AS TBL LEFT JOIN `develop-dajp_agents` ON `develop-dajp_agents`.id = TBL.agent_id WHERE delflg=0 and branch=1) AS Agent ORDER BY ymd desc110
24SELECT `Recommend`.`id`, `Recommend`.`recomid`, `Recommend`.`job_id`, `Recommend`.`ymd`, `Recommend`.`agent_id`, `Recommend`.`title`, `Recommend`.`body`, `Recommend`.`delflg`, `Recommend`.`created`, `Recommend`.`modified`, `Agent`.`id`, `Agent`.`branch`, `Agent`.`name`, `Agent`.`name2`, `Agent`.`email`, `Agent`.`imgurl`, `Agent`.`odrno`, `Agent`.`delflg`, `Agent`.`created`, `Agent`.`modified` FROM `aa127a1w3g`.`develop-dajp_recommends` AS `Recommend` LEFT JOIN `aa127a1w3g`.`develop-dajp_agents` AS `Agent` ON (`Recommend`.`agent_id` = `Agent`.`id`) WHERE `Recommend`.`delflg` = 0 AND `Recommend`.`ymd` <= '2024/12/01' AND `Recommend`.`agent_id` = 6 ORDER BY `Recommend`.`ymd` desc, `Recommend`.`modified` desc LIMIT 1110
25SELECT * FROM (SELECT agent_id as id,name,TBL.ymd FROM (SELECT agent_id,max(ymd) as ymd FROM `develop-dajp_recommends` WHERE ymd<='20241201' AND delflg=0 GROUP BY agent_id) AS TBL LEFT JOIN `develop-dajp_agents` ON `develop-dajp_agents`.id = TBL.agent_id WHERE delflg=0) AS Agent ORDER BY ymd desc550
26SELECT `Recommend`.`id`, `Recommend`.`recomid`, `Recommend`.`job_id`, `Recommend`.`ymd`, `Recommend`.`agent_id`, `Recommend`.`title`, `Recommend`.`body`, `Recommend`.`delflg`, `Recommend`.`created`, `Recommend`.`modified`, `Agent`.`id`, `Agent`.`branch`, `Agent`.`name`, `Agent`.`name2`, `Agent`.`email`, `Agent`.`imgurl`, `Agent`.`odrno`, `Agent`.`delflg`, `Agent`.`created`, `Agent`.`modified` FROM `aa127a1w3g`.`develop-dajp_recommends` AS `Recommend` LEFT JOIN `aa127a1w3g`.`develop-dajp_agents` AS `Agent` ON (`Recommend`.`agent_id` = `Agent`.`id`) WHERE `Recommend`.`delflg` = 0 AND `Recommend`.`ymd` <= '2024/12/01' AND `Recommend`.`agent_id` = 6 ORDER BY `Recommend`.`ymd` desc, `Recommend`.`modified` desc LIMIT 1110
27SELECT `Recommend`.`id`, `Recommend`.`recomid`, `Recommend`.`job_id`, `Recommend`.`ymd`, `Recommend`.`agent_id`, `Recommend`.`title`, `Recommend`.`body`, `Recommend`.`delflg`, `Recommend`.`created`, `Recommend`.`modified`, `Agent`.`id`, `Agent`.`branch`, `Agent`.`name`, `Agent`.`name2`, `Agent`.`email`, `Agent`.`imgurl`, `Agent`.`odrno`, `Agent`.`delflg`, `Agent`.`created`, `Agent`.`modified` FROM `aa127a1w3g`.`develop-dajp_recommends` AS `Recommend` LEFT JOIN `aa127a1w3g`.`develop-dajp_agents` AS `Agent` ON (`Recommend`.`agent_id` = `Agent`.`id`) WHERE `Recommend`.`delflg` = 0 AND `Recommend`.`ymd` <= '2024/12/01' AND `Recommend`.`agent_id` = 5 ORDER BY `Recommend`.`ymd` desc, `Recommend`.`modified` desc LIMIT 1110
28SELECT `Recommend`.`id`, `Recommend`.`recomid`, `Recommend`.`job_id`, `Recommend`.`ymd`, `Recommend`.`agent_id`, `Recommend`.`title`, `Recommend`.`body`, `Recommend`.`delflg`, `Recommend`.`created`, `Recommend`.`modified`, `Agent`.`id`, `Agent`.`branch`, `Agent`.`name`, `Agent`.`name2`, `Agent`.`email`, `Agent`.`imgurl`, `Agent`.`odrno`, `Agent`.`delflg`, `Agent`.`created`, `Agent`.`modified` FROM `aa127a1w3g`.`develop-dajp_recommends` AS `Recommend` LEFT JOIN `aa127a1w3g`.`develop-dajp_agents` AS `Agent` ON (`Recommend`.`agent_id` = `Agent`.`id`) WHERE `Recommend`.`delflg` = 0 AND `Recommend`.`ymd` <= '2024/12/01' AND `Recommend`.`agent_id` = 4 ORDER BY `Recommend`.`ymd` desc, `Recommend`.`modified` desc LIMIT 1110
29SELECT `Recommend`.`id`, `Recommend`.`recomid`, `Recommend`.`job_id`, `Recommend`.`ymd`, `Recommend`.`agent_id`, `Recommend`.`title`, `Recommend`.`body`, `Recommend`.`delflg`, `Recommend`.`created`, `Recommend`.`modified`, `Agent`.`id`, `Agent`.`branch`, `Agent`.`name`, `Agent`.`name2`, `Agent`.`email`, `Agent`.`imgurl`, `Agent`.`odrno`, `Agent`.`delflg`, `Agent`.`created`, `Agent`.`modified` FROM `aa127a1w3g`.`develop-dajp_recommends` AS `Recommend` LEFT JOIN `aa127a1w3g`.`develop-dajp_agents` AS `Agent` ON (`Recommend`.`agent_id` = `Agent`.`id`) WHERE `Recommend`.`delflg` = 0 AND `Recommend`.`ymd` <= '2024/12/01' AND `Recommend`.`agent_id` = 2 ORDER BY `Recommend`.`ymd` desc, `Recommend`.`modified` desc LIMIT 1110
30SELECT `Recommend`.`id`, `Recommend`.`recomid`, `Recommend`.`job_id`, `Recommend`.`ymd`, `Recommend`.`agent_id`, `Recommend`.`title`, `Recommend`.`body`, `Recommend`.`delflg`, `Recommend`.`created`, `Recommend`.`modified`, `Agent`.`id`, `Agent`.`branch`, `Agent`.`name`, `Agent`.`name2`, `Agent`.`email`, `Agent`.`imgurl`, `Agent`.`odrno`, `Agent`.`delflg`, `Agent`.`created`, `Agent`.`modified` FROM `aa127a1w3g`.`develop-dajp_recommends` AS `Recommend` LEFT JOIN `aa127a1w3g`.`develop-dajp_agents` AS `Agent` ON (`Recommend`.`agent_id` = `Agent`.`id`) WHERE `Recommend`.`delflg` = 0 AND `Recommend`.`ymd` <= '2024/12/01' AND `Recommend`.`agent_id` = 3 ORDER BY `Recommend`.`ymd` desc, `Recommend`.`modified` desc LIMIT 1110
31SELECT `News`.`id`, `News`.`ymd`, `News`.`title`, `News`.`body`, `News`.`delflg`, `News`.`created`, `News`.`modified` FROM `aa127a1w3g`.`develop-dajp_news` AS `News` WHERE `News`.`delflg` = 0 AND `News`.`ymd` <= '2024/12/01' ORDER BY `News`.`ymd` desc, `News`.`modified` desc LIMIT 10000