当直なし(相談可) 常勤医師求人の募集情報一覧 | ドクターエージェント キャリア

検索結果一覧

TOP > 当直なし(相談可) 常勤医師求人の募集情報一覧

検索結果一覧
当直なし(相談可)で医師の求人をお探しですか?
この検索条件での求人件数は 11 件です。
検索条件を変更して求人をお探しの場合は、以下をご利用下さい。
先生にとっての求人をさがす時のポイントは? こちらで多様な求人データからお探しいただけます
勤務地
募集科目 ↓特に「老健」及び「人間ドック」希望の方は、必ずご選択をお願いします
業種:区分 一般    ケアミックス   療養型   クリニック  
老健施設等    その他(健診/企業等)
こだわり 当直無し(相談可) 週4~4.5日勤務     救急告示なし
年俸1,800万以上  認定・専門医取得施設
手術件数・症例数が多い
女性医師歓迎  訪問診療  管理者募集
11件中 11-11件  << 先頭へ    1 2  
施設名 医師会員様のみ公開
勤務地 熊本県熊本市内近郊 JOB番号 F1303001
募集科目 一般内科 業種 クリニック
  こだわり  
当直無し 救急告示なし
コメント 勤務時期:内定後3ヵ月後または8~9月頃(相談にて)
医師2名体制で常勤勤務医の募集です。(院長+常勤勤務医)
※一般内科外来と病棟診察がメインです
(胃カメラやエコーなど検査ができればなお可)。
月に1~2回 訪問診療(数件あり)
--------------------------------------------------
□所 在 地:熊本市近郊
□勤務時間:平日9:00~18:30(休憩90分)
      土曜9:00~13:00(休憩60分)
※週5日勤務
第1・3・5週の土曜日勤務(第2・4週土曜日休み)
第1・3・5週の水曜日午前勤務(第2・4週水曜日終日勤務)    
□当  直:当直なし
□休  日:日曜、祝祭日、他(隔週土曜日、隔週水曜午後)
□年  俸:1500万円位(経験年数による)
担当者
松本 泰英 松本 泰英 (担当求人一覧ページへ)
11件中 11-11件  << 先頭へ    1 2  
この検索条件での求人件数は 11 件です。
検索条件を変更して求人をお探しの場合は、以下をご利用下さい。
先生にとっての求人をさがす時のポイントは? こちらで多様な求人データからお探しいただけます
勤務地
募集科目 ↓特に「老健」及び「人間ドック」希望の方は、必ずご選択をお願いします
業種:区分 一般    ケアミックス   療養型   クリニック  
老健施設等    その他(健診/企業等)
こだわり 当直無し(相談可) 週4~4.5日勤務     救急告示なし
年俸1,800万以上  認定・専門医取得施設   手術件数・症例数が多い
女性医師歓迎  訪問診療  管理者募集
無料会員登録
医師のアルバイト・スポット・定期非常勤
エージェントの情報ひろば
原 良彰
東京 原です
東京Office
原 良彰
東京都の求人を今後掲載します。
小林 久美子
東京から・・・
福岡Office
小林 久美子
5月から東京の求人を掲載します…
山崎 和彦
関西を担当しています
福岡Office
山崎 和彦
山崎です。天草出身ですが・・・…
宮崎 敬二
テスト
福岡Office
宮崎 敬二
てすとてすとてすとてすとてすと…
松本 泰英
松本です
福岡Office
松本 泰英
福岡を中心に掲載します。
運営会社からのお知らせ
(default) 20 queries took 7 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`.`jobid` <> '' AND NOT (`Job`.`jobid` IS NULL) AND `Job`.`delflg` = 0 AND `Agent`.`delflg` = 0 AND `Hospital`.`delflg` = 0 AND `Job`.`flg1` = 1 AND `Job`.`ymd` <= '2024/11/28' ORDER BY `Job`.`stopflg` asc, `Job`.`ymd` desc, `Job`.`modified` desc, `Job`.`id` desc LIMIT 10, 10114
5SELECT 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`.`flg1` = 1 AND `Job`.`ymd` <= '2024/11/28'111
6SELECT `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
7SELECT * 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
8SELECT `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
9SELECT `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
10SELECT `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
11SELECT `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
12SELECT * 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
13SELECT `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
14SELECT * 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
15SELECT `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
16SELECT `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 1111
17SELECT `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
18SELECT `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
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` = 3 ORDER BY `Recommend`.`ymd` desc, `Recommend`.`modified` desc LIMIT 1110
20SELECT `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