内視鏡(上下)検査可能なドクター募集:消化器内科 - Dr.Agent (F1303003)

TOP > 内視鏡(上下)検査可能なドクター募集:消化器内科 - Dr.Agent (F1303003)

この求人へのお申し込み・お問い合わせは、ページ内のお問い合わせフォームもしくはお電話で承ります。
お問い合わせフォームをご利用の方は会員登録をしていただくと次回からご入力を短縮していただけます。
内視鏡(上下)検査可能なドクター募集:消化器内科
勤務地 福岡県福岡市 JOB番号 F1303003
募集科目 消化器内科 お気に入り
年収 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 医師会員様のみ公開 救急告示 なし
施設名 医師会員様のみ公開 業種(区分) 一般
所在地 医師会員様のみ公開
病床数 医師会員様のみ公開
主な診療科目 医師会員様のみ公開
追記事項 医師会員様のみ公開

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

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

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