神奈川県鎌倉市の病院で循環器内科医師募集！ - Dr.Agent (F1708001)

ようこそ　ゲスト様　　　ログイン　　　医師の求人を検索　　　会員登録　　　　医師募集ご担当者様へ　　　　サイトマップ

TOP > 神奈川県鎌倉市の病院で循環器内科医師募集！ - Dr.Agent (F1708001)

この求人へのお申し込み・お問い合わせは、ページ内のお問い合わせフォームもしくはお電話で承ります。
お問い合わせフォームをご利用の方は会員登録をしていただくと次回からご入力を短縮していただけます。
神奈川県鎌倉市の病院で循環器内科医師募集！
勤務地 神奈川県横浜市 JOB番号 F1708001
募集科目 循環器内科 お気に入り
お気に入りに追加
年収 1400万円～1700万円
こだわり
当直無し 週4-4.5日 年俸1800万以上 認定・専門医取得OK
担当者からの「ここがポイント！」 原　良彰 担当者：原　良彰
（⇒その他の担当案件）
■ドクター・エージェントより■
・週4.5日勤務
・各種保険完備
・当直無
　
【募集内容】
□募集科目：総合診療科　循環器内科　糖尿病内科
□勤務日数：週4.5日
□年　　収：1400万円～1700万円
□勤務時間：平日8:30から17:00まで、土曜8:30から12:30まで
□休　　日：日曜　祝日
　
【業務内容】
□外　　来：有
□病棟担当：有
□当　　直：無
□往　　診：無
□その他　：
　
【こだわり】
週4～4.5日　当直なし(相談可)　など
　
【病院概要】
□所在地　：神奈川県
□組織形態：法人
□施設区分：ケアミックス
□救急告知：有
　
━ Dr-agent 医師求人情報サイト ━
┏　─────────────　┓
　キャリア10年以上の担当者が
　個別に対応します。
　未公開情報・類似求人のご案内！
　ご希望条件をお知らせください。
┗　─────────────　┛
転職に関するご相談はお気軽にどうぞ！
■株式会社ドクター・エージェント■
病院ID 医師会員様のみ公開 救急告示 なし
施設名 医師会員様のみ公開 業種(区分) 療養型
所在地 医師会員様のみ公開
病床数 医師会員様のみ公開
主な診療科目 医師会員様のみ公開
追記事項 医師会員様のみ公開
この求人に問合せをする

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

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

お問い合わせフォーム
名　前
必須
 　
姓と名の間にスペースを入れて下さい（例：求人　太郎）
フリガナ
必須
 性　別
必須
 男性　女性　
メールアドレス
必須
電話番号 自宅電話  ※ハイフンなし（例：00000000000）
携帯電話  ※ハイフンなし（例：00000000000）
住　所
必須
  ※都道府県のみ必須です
※市区町村以下をご入力下さい
医師免許取得年
必須
 西暦年 　※西暦で入力下さい（例：1995）
専門科目
必須
転職時期
必須
 決まり次第　　３ヶ月以内　　半年以内　　１年以内　　未定　　
ご質問・ご希望勤務地、その他ご要望など
>>文例を見る
無料会員登録
医師のアルバイト・スポット・定期非常勤
エージェントの情報ひろば
原　良彰
 東京　原です
東京Office
原　良彰
東京都の求人を今後掲載します。
小林　久美子
 東京から・・・
福岡Office
小林　久美子
5月から東京の求人を掲載します…
山崎　和彦
 関西を担当しています
福岡Office
山崎　和彦
山崎です。天草出身ですが・・・…
宮崎　敬二
 テスト
福岡Office
宮崎　敬二
てすとてすとてすとてすとてすと…
松本　泰英
 松本です
福岡Office
松本　泰英
福岡を中心に掲載します。
運営会社からのお知らせ
医師求人検索｜サイトのご利用方法｜会員登録｜よくあるご質問｜会社概要｜サイトマップ｜お問い合わせ｜医師募集ご担当者様へ
 
株式会社ドクター・エージェント
https://www.dr-agent.co.jp
厚生労働大臣許可　40-ュ-010187
(c) Doctor Agent , Inc.
(default) 31 queries took 4 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` = 12 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` = 9 LIMIT 1110
6SELECT `Prefecture`.`id`, `Prefecture`.`area_id`, `Prefecture`.`westflg`, `Prefecture`.`name` FROM `aa127a1w3g`.`develop-dajp_prefectures` AS `Prefecture` WHERE `Prefecture`.`id` = 9 LIMIT 1110
7SELECT `Prefecture`.`id`, `Prefecture`.`area_id`, `Prefecture`.`westflg`, `Prefecture`.`name` FROM `aa127a1w3g`.`develop-dajp_prefectures` AS `Prefecture` WHERE `Prefecture`.`id` = 9 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` = 9 LIMIT 1110
10SELECT `Prefecture`.`id`, `Prefecture`.`area_id`, `Prefecture`.`westflg`, `Prefecture`.`name` FROM `aa127a1w3g`.`develop-dajp_prefectures` AS `Prefecture` WHERE `Prefecture`.`id` = 9 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` = (9) AND `Job`.`department_id` = 3 AND `Job`.`ymd` <= '2024/11/28' AND `Job`.`id` <> 12 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` = (9) AND `Job`.`department_id` = 3 AND `Job`.`ymd` <= '2024/11/28' AND `Job`.`id` <> 12111
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` = 3 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 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/11/28' 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/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 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<='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
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