SELECT pg_anken.anken_id, pg_anken_kind.anken_kind_id, pg_anken_kind.anken_kind_data, pg_anken.anken_name, pg_anken.employment, pg_anken.comment, pg_anken.period, pg_anken.limit_age, pg_anken.number_pv, pg_anken.anken_mode, pg_prefectures.pref_name, DATE_FORMAT( pg_anken.change_date, '%m/%d' ) AS change_date_str , DATE_FORMAT( pg_anken.anken_updated_at, '%m/%d' ) AS anken_updated_at_str , DATE_FORMAT( pg_anken.anken_updated_at, '%Y%m%d' ) AS anken_updated_at_int , DATE_FORMAT( pg_anken.anken_created_at, '%Y%m%d' ) AS anken_created_at_int FROM pg_anken, pg_anken_kind, pg_prefectures WHERE pg_anken.anken_kind_id = pg_anken_kind.anken_kind_id AND pg_anken.pref_id = pg_prefectures.pref_id AND pg_anken.anken_mode IN ( 1, 2 ) ORDER BY pg_anken.anken_id DESC LIMIT 0,12
SELECT pg_anken_code.anken_id, pg_code.code_id, pg_code.code_disp, pg_code.code_data FROM pg_anken_code, pg_code WHERE pg_anken_code.code_id = pg_code.code_id AND pg_anken_code.anken_id IN ( 19,18,17,16,15 ) ORDER BY pg_anken_code.anken_id ASC, pg_code.code_disp ASC
SELECT pg_anken_category.anken_id, pg_category.category_id, pg_category.category_disp, pg_category.category_data FROM pg_anken_category, pg_category WHERE pg_anken_category.category_id = pg_category.category_id AND pg_anken_category.anken_id IN ( 19,18,17,16,15 ) ORDER BY pg_anken_category.anken_id ASC, pg_category.category_disp ASC
SELECT COUNT(anken_id) AS CNT FROM pg_anken WHERE anken_mode IN ( 1, 2 )
SELECT COUNT(member_id) AS CNT FROM pg_member
今日のお仕事 | エンジニア向けのビジネスマッチングサイト【PGstation】