心リハを行っています循環器内科医 急募!! - Dr.Agent (F1303002)

TOP > 心リハを行っています循環器内科医 急募!! - Dr.Agent (F1303002)

この求人へのお申し込み・お問い合わせは、ページ内のお問い合わせフォームもしくはお電話で承ります。
お問い合わせフォームをご利用の方は会員登録をしていただくと次回からご入力を短縮していただけます。
心リハを行っています循環器内科医 急募!!
勤務地 福岡県福岡市 JOB番号 F1303002
募集科目 循環器内科 お気に入り
年収 1500万円~1800万円(税込)
こだわり
当直無し 週4-4.5日 救急告示なし
担当者からの「ここがポイント!」 松本 泰英 担当者:松本 泰英
(⇒その他の担当案件
福岡市にある中規模病院で予防から治療(急性期~慢性期まで)、リハビリテーションから在宅診療まで一貫した医療サービスを実践している歴史のある病院です。

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

<募集科目の業務内容について>-----------------------------------
★循環器内科
術後の心疾患の患者の受け入れと、リハビリをメインにお願いします。
要:心臓リハビリテーション指導士

病棟や外来のコマ数などご希望によりご相談にて。

<担当エージェントより>------------------------------------------
交通の便利の良い地域に立地していますので、公共交通機関(JR)や車での通勤も便利ですので、市内や近隣のお住まいの先生にはお 奨めします。Uターンでの就職希望の先生も歓迎いたします。
勤務条件については、ご相談に応じますので、まずはご希望の条件など弊社担当者までお問合せ下さい。

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

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

病院ID 40037 救急告示 なし
施設名 医療法人愛風会 さく病院 業種(区分) 一般
所在地 福岡県福岡市博多区竹下4-6-25
病床数 172床(一般44・回復期52・障害施設等一般40・療養36)
主な診療科目 一般内科 整形外科 皮膚科 泌尿器科 一般外科 リハビリテーション科 
追記事項 病院までの地図


病院の外観




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

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

お問い合わせフォーム
名 前
必須
 
姓と名の間にスペースを入れて下さい(例:求人 太郎)
フリガナ
必須
性 別
必須
男性 女性 
メールアドレス
必須
電話番号 自宅電話  ※ハイフンなし(例:00000000000)
携帯電話  ※ハイフンなし(例:00000000000)
住 所
必須
  ※都道府県のみ必須です
※市区町村以下をご入力下さい
医師免許取得年
必須
西暦年  ※西暦で入力下さい(例:1995)
専門科目
必須
転職時期
必須
決まり次第  3ヶ月以内  半年以内  1年以内  未定  
ご質問・ご希望勤務地、その他ご要望など
>>文例を見る
無料会員登録
医師のアルバイト・スポット・定期非常勤
エージェントの情報ひろば
原 良彰
東京 原です
東京Office
原 良彰
東京都の求人を今後掲載します。
小林 久美子
東京から・・・
福岡Office
小林 久美子
5月から東京の求人を掲載します…
山崎 和彦
関西を担当しています
福岡Office
山崎 和彦
山崎です。天草出身ですが・・・…
宮崎 敬二
テスト
福岡Office
宮崎 敬二
てすとてすとてすとてすとてすと…
松本 泰英
松本です
福岡Office
松本 泰英
福岡を中心に掲載します。
運営会社からのお知らせ
(default) 37 queries took 5 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` asc33331
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` = 2 AND `Job`.`delflg` = 0 AND `Job`.`ymd` <= '2024/11/28' 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` = 3 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` = 3 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` = 3 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` = 3 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` = 3 AND `Job`.`ymd` <= '2024/11/28' AND `Job`.`id` <> 2 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` = 3 AND `Job`.`ymd` <= '2024/11/28' AND `Job`.`id` <> 2111
16SELECT `Department`.`id`, `Department`.`name`, `Department`.`odrno`, `Department`.`flg1`, `Department`.`flg2`, `Department`.`flg3` FROM `aa127a1w3g`.`develop-dajp_departments` AS `Department` WHERE `Department`.`id` = 3 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` = 1 LIMIT 1110
18SELECT `Department`.`id`, `Department`.`name`, `Department`.`odrno`, `Department`.`flg1`, `Department`.`flg2`, `Department`.`flg3` FROM `aa127a1w3g`.`develop-dajp_departments` AS `Department` WHERE `Department`.`id` = 6 LIMIT 1110
19SELECT `Department`.`id`, `Department`.`name`, `Department`.`odrno`, `Department`.`flg1`, `Department`.`flg2`, `Department`.`flg3` FROM `aa127a1w3g`.`develop-dajp_departments` AS `Department` WHERE `Department`.`id` = 12 LIMIT 1110
20SELECT `Department`.`id`, `Department`.`name`, `Department`.`odrno`, `Department`.`flg1`, `Department`.`flg2`, `Department`.`flg3` FROM `aa127a1w3g`.`develop-dajp_departments` AS `Department` WHERE `Department`.`id` = 13 LIMIT 1110
21SELECT `Department`.`id`, `Department`.`name`, `Department`.`odrno`, `Department`.`flg1`, `Department`.`flg2`, `Department`.`flg3` FROM `aa127a1w3g`.`develop-dajp_departments` AS `Department` WHERE `Department`.`id` = 23 LIMIT 1110
22SELECT `Department`.`id`, `Department`.`name`, `Department`.`odrno`, `Department`.`flg1`, `Department`.`flg2`, `Department`.`flg3` FROM `aa127a1w3g`.`develop-dajp_departments` AS `Department` WHERE `Department`.`id` = 25 LIMIT 1110
23SELECT `Department`.`id`, `Department`.`name`, `Department`.`odrno`, `Department`.`flg1`, `Department`.`flg2`, `Department`.`flg3` FROM `aa127a1w3g`.`develop-dajp_departments` AS `Department` WHERE `Department`.`id` = 3 LIMIT 1110
24SELECT * FROM (SELECT agent_id as id,name,TBL.ymd FROM (SELECT agent_id,max(ymd) as ymd FROM `develop-dajp_recommends` WHERE ymd<='20241128' 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
25SELECT `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/11/28' AND `Recommend`.`agent_id` = 5 ORDER BY `Recommend`.`ymd` desc, `Recommend`.`modified` desc LIMIT 1110
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/11/28' AND `Recommend`.`agent_id` = 4 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/11/28' AND `Recommend`.`agent_id` = 2 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/11/28' AND `Recommend`.`agent_id` = 3 ORDER BY `Recommend`.`ymd` desc, `Recommend`.`modified` desc LIMIT 1110
29SELECT * FROM (SELECT agent_id as id,name,TBL.ymd FROM (SELECT agent_id,max(ymd) as ymd FROM `develop-dajp_recommends` WHERE ymd<='20241128' 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
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/11/28' AND `Recommend`.`agent_id` = 6 ORDER BY `Recommend`.`ymd` desc, `Recommend`.`modified` desc LIMIT 1110
31SELECT * FROM (SELECT agent_id as id,name,TBL.ymd FROM (SELECT agent_id,max(ymd) as ymd FROM `develop-dajp_recommends` WHERE ymd<='20241128' 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
32SELECT `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/11/28' AND `Recommend`.`agent_id` = 6 ORDER BY `Recommend`.`ymd` desc, `Recommend`.`modified` desc LIMIT 1110
33SELECT `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/11/28' AND `Recommend`.`agent_id` = 5 ORDER BY `Recommend`.`ymd` desc, `Recommend`.`modified` desc LIMIT 1110
34SELECT `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/11/28' AND `Recommend`.`agent_id` = 4 ORDER BY `Recommend`.`ymd` desc, `Recommend`.`modified` desc LIMIT 1110
35SELECT `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/11/28' AND `Recommend`.`agent_id` = 2 ORDER BY `Recommend`.`ymd` desc, `Recommend`.`modified` desc LIMIT 1110
36SELECT `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/11/28' AND `Recommend`.`agent_id` = 3 ORDER BY `Recommend`.`ymd` desc, `Recommend`.`modified` desc LIMIT 1110
37SELECT `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/11/28' ORDER BY `News`.`ymd` desc, `News`.`modified` desc LIMIT 10000