최근게시물

본문 바로가기
팜스트림을 시작페이지로 >
사이트 내 전체검색

메인메뉴


회원로그인

접속자집계

회원수 281명
일일방문자 150명
누적방문자 37,731명
오늘의 기업회원 소개

조회수 기준 ▲

고객만족도순위
월간베스트회원
  • 1위 농업의신 소금사막
  • 2위 예비농부 산다람쥐
  • 3위 박사농부 피터팬
  • 4위 박사농부 나빌레라
  • 5위 박사농부 보노보노
  • 6위 교수농부 콩블리
  • 7위 교수농부 민트베리
  • 8위 교수농부 에당아자르
  • 9위 선생농부 suri
  • 10위 교수농부 하늘농부

게시글+댓글+추천수 기준 ▲

SELECT COUNT(DISTINCT `wr_parent`,`bo_table`) AS `cnt` FROM (select n.bn_id, n.bo_table, n.bo_subject, w.wr_id, w.wr_parent, w.wr_num, w.mb_id, w.wr_name, w.wr_subject, w.wr_content, w.strip_tags_wr_content, w.wr_is_comment, w.wr_2 from (select b.bo_table,b.bo_subject,bn.bn_id,bn.wr_id from (select * from g5_board_new where bo_table = 'SelfIntroduce')as bn left join `g5_board` as b on bn.bo_table=b.bo_table) as n left join g5_write_SelfIntroduce as w on n.wr_id = w.wr_id union select n.bn_id, n.bo_table, n.bo_subject, w.wr_id, w.wr_parent, w.wr_num, w.mb_id, w.wr_name, w.wr_subject, w.wr_content, w.strip_tags_wr_content, w.wr_is_comment, w.wr_2 from (select b.bo_table,b.bo_subject,bn.bn_id,bn.wr_id from (select * from g5_board_new where bo_table = 'FunBoard')as bn left join `g5_board` as b on bn.bo_table=b.bo_table) as n left join g5_write_FunBoard as w on n.wr_id = w.wr_id union select n.bn_id, n.bo_table, n.bo_subject, w.wr_id, w.wr_parent, w.wr_num, w.mb_id, w.wr_name, w.wr_subject, w.wr_content, w.strip_tags_wr_content, w.wr_is_comment, w.wr_2 from (select b.bo_table,b.bo_subject,bn.bn_id,bn.wr_id from (select * from g5_board_new where bo_table = 'ShopNotice')as bn left join `g5_board` as b on bn.bo_table=b.bo_table) as n left join g5_write_ShopNotice as w on n.wr_id = w.wr_id union select n.bn_id, n.bo_table, n.bo_subject, w.wr_id, w.wr_parent, w.wr_num, w.mb_id, w.wr_name, w.wr_subject, w.wr_content, w.strip_tags_wr_content, w.wr_is_comment, w.wr_2 from (select b.bo_table,b.bo_subject,bn.bn_id,bn.wr_id from (select * from g5_board_new where bo_table = 'ShopAlliance')as bn left join `g5_board` as b on bn.bo_table=b.bo_table) as n left join g5_write_ShopAlliance as w on n.wr_id = w.wr_id union select n.bn_id, n.bo_table, n.bo_subject, w.wr_id, w.wr_parent, w.wr_num, w.mb_id, w.wr_name, w.wr_subject, w.wr_content, w.strip_tags_wr_content, w.wr_is_comment, w.wr_2 from (select b.bo_table,b.bo_subject,bn.bn_id,bn.wr_id from (select * from g5_board_new where bo_table = 'ShopAdverInquiry')as bn left join `g5_board` as b on bn.bo_table=b.bo_table) as n left join g5_write_ShopAdverInquiry as w on n.wr_id = w.wr_id union select n.bn_id, n.bo_table, n.bo_subject, w.wr_id, w.wr_parent, w.wr_num, w.mb_id, w.wr_name, w.wr_subject, w.wr_content, w.strip_tags_wr_content, w.wr_is_comment, w.wr_2 from (select b.bo_table,b.bo_subject,bn.bn_id,bn.wr_id from (select * from g5_board_new where bo_table = 'EvalSugg')as bn left join `g5_board` as b on bn.bo_table=b.bo_table) as n left join g5_write_EvalSugg as w on n.wr_id = w.wr_id union select n.bn_id, n.bo_table, n.bo_subject, w.wr_id, w.wr_parent, w.wr_num, w.mb_id, w.wr_name, w.wr_subject, w.wr_content, w.strip_tags_wr_content, w.wr_is_comment, w.wr_2 from (select b.bo_table,b.bo_subject,bn.bn_id,bn.wr_id from (select * from g5_board_new where bo_table = 'MarketTrip')as bn left join `g5_board` as b on bn.bo_table=b.bo_table) as n left join g5_write_MarketTrip as w on n.wr_id = w.wr_id union select n.bn_id, n.bo_table, n.bo_subject, w.wr_id, w.wr_parent, w.wr_num, w.mb_id, w.wr_name, w.wr_subject, w.wr_content, w.strip_tags_wr_content, w.wr_is_comment, w.wr_2 from (select b.bo_table,b.bo_subject,bn.bn_id,bn.wr_id from (select * from g5_board_new where bo_table = 'SugAskBoard')as bn left join `g5_board` as b on bn.bo_table=b.bo_table) as n left join g5_write_SugAskBoard as w on n.wr_id = w.wr_id union select n.bn_id, n.bo_table, n.bo_subject, w.wr_id, w.wr_parent, w.wr_num, w.mb_id, w.wr_name, w.wr_subject, w.wr_content, w.strip_tags_wr_content, w.wr_is_comment, w.wr_2 from (select b.bo_table,b.bo_subject,bn.bn_id,bn.wr_id from (select * from g5_board_new where bo_table = 'PoorMember')as bn left join `g5_board` as b on bn.bo_table=b.bo_table) as n left join g5_write_PoorMember as w on n.wr_id = w.wr_id union select n.bn_id, n.bo_table, n.bo_subject, w.wr_id, w.wr_parent, w.wr_num, w.mb_id, w.wr_name, w.wr_subject, w.wr_content, w.strip_tags_wr_content, w.wr_is_comment, w.wr_2 from (select b.bo_table,b.bo_subject,bn.bn_id,bn.wr_id from (select * from g5_board_new where bo_table = 'notice')as bn left join `g5_board` as b on bn.bo_table=b.bo_table) as n left join g5_write_notice as w on n.wr_id = w.wr_id union select n.bn_id, n.bo_table, n.bo_subject, w.wr_id, w.wr_parent, w.wr_num, w.mb_id, w.wr_name, w.wr_subject, w.wr_content, w.strip_tags_wr_content, w.wr_is_comment, w.wr_2 from (select b.bo_table,b.bo_subject,bn.bn_id,bn.wr_id from (select * from g5_board_new where bo_table = 'TodayInfo')as bn left join `g5_board` as b on bn.bo_table=b.bo_table) as n left join g5_write_TodayInfo as w on n.wr_id = w.wr_id union select n.bn_id, n.bo_table, n.bo_subject, w.wr_id, w.wr_parent, w.wr_num, w.mb_id, w.wr_name, w.wr_subject, w.wr_content, w.strip_tags_wr_content, w.wr_is_comment, w.wr_2 from (select b.bo_table,b.bo_subject,bn.bn_id,bn.wr_id from (select * from g5_board_new where bo_table = 'ReturnFarming')as bn left join `g5_board` as b on bn.bo_table=b.bo_table) as n left join g5_write_ReturnFarming as w on n.wr_id = w.wr_id union select n.bn_id, n.bo_table, n.bo_subject, w.wr_id, w.wr_parent, w.wr_num, w.mb_id, w.wr_name, w.wr_subject, w.wr_content, w.strip_tags_wr_content, w.wr_is_comment, w.wr_2 from (select b.bo_table,b.bo_subject,bn.bn_id,bn.wr_id from (select * from g5_board_new where bo_table = 'ProgramListings')as bn left join `g5_board` as b on bn.bo_table=b.bo_table) as n left join g5_write_ProgramListings as w on n.wr_id = w.wr_id union select n.bn_id, n.bo_table, n.bo_subject, w.wr_id, w.wr_parent, w.wr_num, w.mb_id, w.wr_name, w.wr_subject, w.wr_content, w.strip_tags_wr_content, w.wr_is_comment, w.wr_2 from (select b.bo_table,b.bo_subject,bn.bn_id,bn.wr_id from (select * from g5_board_new where bo_table = 'KnowHow')as bn left join `g5_board` as b on bn.bo_table=b.bo_table) as n left join g5_write_KnowHow as w on n.wr_id = w.wr_id union select n.bn_id, n.bo_table, n.bo_subject, w.wr_id, w.wr_parent, w.wr_num, w.mb_id, w.wr_name, w.wr_subject, w.wr_content, w.strip_tags_wr_content, w.wr_is_comment, w.wr_2 from (select b.bo_table,b.bo_subject,bn.bn_id,bn.wr_id from (select * from g5_board_new where bo_table = 'FestivalInfo')as bn left join `g5_board` as b on bn.bo_table=b.bo_table) as n left join g5_write_FestivalInfo as w on n.wr_id = w.wr_id union select n.bn_id, n.bo_table, n.bo_subject, w.wr_id, w.wr_parent, w.wr_num, w.mb_id, w.wr_name, w.wr_subject, w.wr_content, w.strip_tags_wr_content, w.wr_is_comment, w.wr_2 from (select b.bo_table,b.bo_subject,bn.bn_id,bn.wr_id from (select * from g5_board_new where bo_table = 'ExpertInfo')as bn left join `g5_board` as b on bn.bo_table=b.bo_table) as n left join g5_write_ExpertInfo as w on n.wr_id = w.wr_id union select n.bn_id, n.bo_table, n.bo_subject, w.wr_id, w.wr_parent, w.wr_num, w.mb_id, w.wr_name, w.wr_subject, w.wr_content, w.strip_tags_wr_content, w.wr_is_comment, w.wr_2 from (select b.bo_table,b.bo_subject,bn.bn_id,bn.wr_id from (select * from g5_board_new where bo_table = 'CityAgri')as bn left join `g5_board` as b on bn.bo_table=b.bo_table) as n left join g5_write_CityAgri as w on n.wr_id = w.wr_id union select n.bn_id, n.bo_table, n.bo_subject, w.wr_id, w.wr_parent, w.wr_num, w.mb_id, w.wr_name, w.wr_subject, w.wr_content, w.strip_tags_wr_content, w.wr_is_comment, w.wr_2 from (select b.bo_table,b.bo_subject,bn.bn_id,bn.wr_id from (select * from g5_board_new where bo_table = 'HumanResource')as bn left join `g5_board` as b on bn.bo_table=b.bo_table) as n left join g5_write_HumanResource as w on n.wr_id = w.wr_id union select n.bn_id, n.bo_table, n.bo_subject, w.wr_id, w.wr_parent, w.wr_num, w.mb_id, w.wr_name, w.wr_subject, w.wr_content, w.strip_tags_wr_content, w.wr_is_comment, w.wr_2 from (select b.bo_table,b.bo_subject,bn.bn_id,bn.wr_id from (select * from g5_board_new where bo_table = 'UsedMachine')as bn left join `g5_board` as b on bn.bo_table=b.bo_table) as n left join g5_write_UsedMachine as w on n.wr_id = w.wr_id union select n.bn_id, n.bo_table, n.bo_subject, w.wr_id, w.wr_parent, w.wr_num, w.mb_id, w.wr_name, w.wr_subject, w.wr_content, w.strip_tags_wr_content, w.wr_is_comment, w.wr_2 from (select b.bo_table,b.bo_subject,bn.bn_id,bn.wr_id from (select * from g5_board_new where bo_table = 'FreeShare')as bn left join `g5_board` as b on bn.bo_table=b.bo_table) as n left join g5_write_FreeShare as w on n.wr_id = w.wr_id union select n.bn_id, n.bo_table, n.bo_subject, w.wr_id, w.wr_parent, w.wr_num, w.mb_id, w.wr_name, w.wr_subject, w.wr_content, w.strip_tags_wr_content, w.wr_is_comment, w.wr_2 from (select b.bo_table,b.bo_subject,bn.bn_id,bn.wr_id from (select * from g5_board_new where bo_table = 'FoodMarket')as bn left join `g5_board` as b on bn.bo_table=b.bo_table) as n left join g5_write_FoodMarket as w on n.wr_id = w.wr_id union select n.bn_id, n.bo_table, n.bo_subject, w.wr_id, w.wr_parent, w.wr_num, w.mb_id, w.wr_name, w.wr_subject, w.wr_content, w.strip_tags_wr_content, w.wr_is_comment, w.wr_2 from (select b.bo_table,b.bo_subject,bn.bn_id,bn.wr_id from (select * from g5_board_new where bo_table = 'ExchangeBarter')as bn left join `g5_board` as b on bn.bo_table=b.bo_table) as n left join g5_write_ExchangeBarter as w on n.wr_id = w.wr_id union select n.bn_id, n.bo_table, n.bo_subject, w.wr_id, w.wr_parent, w.wr_num, w.mb_id, w.wr_name, w.wr_subject, w.wr_content, w.strip_tags_wr_content, w.wr_is_comment, w.wr_2 from (select b.bo_table,b.bo_subject,bn.bn_id,bn.wr_id from (select * from g5_board_new where bo_table = 'CrimeHelp')as bn left join `g5_board` as b on bn.bo_table=b.bo_table) as n left join g5_write_CrimeHelp as w on n.wr_id = w.wr_id union select n.bn_id, n.bo_table, n.bo_subject, w.wr_id, w.wr_parent, w.wr_num, w.mb_id, w.wr_name, w.wr_subject, w.wr_content, w.strip_tags_wr_content, w.wr_is_comment, w.wr_2 from (select b.bo_table,b.bo_subject,bn.bn_id,bn.wr_id from (select * from g5_board_new where bo_table = 'FreeBoard')as bn left join `g5_board` as b on bn.bo_table=b.bo_table) as n left join g5_write_FreeBoard as w on n.wr_id = w.wr_id union select n.bn_id, n.bo_table, n.bo_subject, w.wr_id, w.wr_parent, w.wr_num, w.mb_id, w.wr_name, w.wr_subject, w.wr_content, w.strip_tags_wr_content, w.wr_is_comment, w.wr_2 from (select b.bo_table,b.bo_subject,bn.bn_id,bn.wr_id from (select * from g5_board_new where bo_table = 'CeoInterview')as bn left join `g5_board` as b on bn.bo_table=b.bo_table) as n left join g5_write_CeoInterview as w on n.wr_id = w.wr_id union select n.bn_id, n.bo_table, n.bo_subject, w.wr_id, w.wr_parent, w.wr_num, w.mb_id, w.wr_name, w.wr_subject, w.wr_content, w.strip_tags_wr_content, w.wr_is_comment, w.wr_2 from (select b.bo_table,b.bo_subject,bn.bn_id,bn.wr_id from (select * from g5_board_new where bo_table = 'TourEpilogue')as bn left join `g5_board` as b on bn.bo_table=b.bo_table) as n left join g5_write_TourEpilogue as w on n.wr_id = w.wr_id union select n.bn_id, n.bo_table, n.bo_subject, w.wr_id, w.wr_parent, w.wr_num, w.mb_id, w.wr_name, w.wr_subject, w.wr_content, w.strip_tags_wr_content, w.wr_is_comment, w.wr_2 from (select b.bo_table,b.bo_subject,bn.bn_id,bn.wr_id from (select * from g5_board_new where bo_table = 'report')as bn left join `g5_board` as b on bn.bo_table=b.bo_table) as n left join g5_write_report as w on n.wr_id = w.wr_id union select n.bn_id, n.bo_table, n.bo_subject, w.wr_id, w.wr_parent, w.wr_num, w.mb_id, w.wr_name, w.wr_subject, w.wr_content, w.strip_tags_wr_content, w.wr_is_comment, w.wr_2 from (select b.bo_table,b.bo_subject,bn.bn_id,bn.wr_id from (select * from g5_board_new where bo_table = 'SmartFarm')as bn left join `g5_board` as b on bn.bo_table=b.bo_table) as n left join g5_write_SmartFarm as w on n.wr_id = w.wr_id union select n.bn_id, n.bo_table, n.bo_subject, w.wr_id, w.wr_parent, w.wr_num, w.mb_id, w.wr_name, w.wr_subject, w.wr_content, w.strip_tags_wr_content, w.wr_is_comment, w.wr_2 from (select b.bo_table,b.bo_subject,bn.bn_id,bn.wr_id from (select * from g5_board_new where bo_table = 'LandMarket')as bn left join `g5_board` as b on bn.bo_table=b.bo_table) as n left join g5_write_LandMarket as w on n.wr_id = w.wr_id union select n.bn_id, n.bo_table, n.bo_subject, w.wr_id, w.wr_parent, w.wr_num, w.mb_id, w.wr_name, w.wr_subject, w.wr_content, w.strip_tags_wr_content, w.wr_is_comment, w.wr_2 from (select b.bo_table,b.bo_subject,bn.bn_id,bn.wr_id from (select * from g5_board_new where bo_table = 'Alliance')as bn left join `g5_board` as b on bn.bo_table=b.bo_table) as n left join g5_write_Alliance as w on n.wr_id = w.wr_id union select n.bn_id, n.bo_table, n.bo_subject, w.wr_id, w.wr_parent, w.wr_num, w.mb_id, w.wr_name, w.wr_subject, w.wr_content, w.strip_tags_wr_content, w.wr_is_comment, w.wr_2 from (select b.bo_table,b.bo_subject,bn.bn_id,bn.wr_id from (select * from g5_board_new where bo_table = 'event')as bn left join `g5_board` as b on bn.bo_table=b.bo_table) as n left join g5_write_event as w on n.wr_id = w.wr_id union select n.bn_id, n.bo_table, n.bo_subject, w.wr_id, w.wr_parent, w.wr_num, w.mb_id, w.wr_name, w.wr_subject, w.wr_content, w.strip_tags_wr_content, w.wr_is_comment, w.wr_2 from (select b.bo_table,b.bo_subject,bn.bn_id,bn.wr_id from (select * from g5_board_new where bo_table = 'Food_Market')as bn left join `g5_board` as b on bn.bo_table=b.bo_table) as n left join g5_write_Food_Market as w on n.wr_id = w.wr_id union select n.bn_id, n.bo_table, n.bo_subject, w.wr_id, w.wr_parent, w.wr_num, w.mb_id, w.wr_name, w.wr_subject, w.wr_content, w.strip_tags_wr_content, w.wr_is_comment, w.wr_2 from (select b.bo_table,b.bo_subject,bn.bn_id,bn.wr_id from (select * from g5_board_new where bo_table = 'Used_Market')as bn left join `g5_board` as b on bn.bo_table=b.bo_table) as n left join g5_write_Used_Market as w on n.wr_id = w.wr_id union select n.bn_id, n.bo_table, n.bo_subject, w.wr_id, w.wr_parent, w.wr_num, w.mb_id, w.wr_name, w.wr_subject, w.wr_content, w.strip_tags_wr_content, w.wr_is_comment, w.wr_2 from (select b.bo_table,b.bo_subject,bn.bn_id,bn.wr_id from (select * from g5_board_new where bo_table = 'Land_Market')as bn left join `g5_board` as b on bn.bo_table=b.bo_table) as n left join g5_write_Land_Market as w on n.wr_id = w.wr_id )common WHERE ca_name = '팝니다' and wr_is_comment = '0' AND wr_2 != 'del' AND wr_2 != 'admin_del'

1054 : Unknown column 'ca_name' in 'where clause'

error file : /bbs/new.php