Wyniki wyszukiwania:

SELECT `vf_search`.`sea_id`, `vf_search`.`sea_parent`, `vf_search`.`sea_parent_id`, `vf_search`.`sea_parent_lg`, `vf_search`.`sea_usr_id`, `vf_search`.`sea_tags`, `vf_search`.`sea_type`, `vf_search`.`sea_path`, `vf_search`.`sea_path_link`, `vf_search`.`sea_refresh_date`, `vf_search`.`sea_title`, `vf_search`.`sea_lead`, `vf_search`.`sea_autor`, `vf_search`.`sea_create_date`, `vf_search`.`sea_ico`, `vf_search`.`sea_ico_crop_info`, `ac_contents`.`cnt_id`, `ac_contents`.`cnt_nnd_id`, `ac_contents`.`cnt_title`, `ac_contents`.`cnt_update_date`, `ac_contents`.`cnt_start_date`, `ac_contents`.`cnt_status`, `ac_contents`.`cnt_is_public`, `ac_contents`.`cnt_uri`, `ac_contents`.`cnt_lead`, `ac_contents`.`cnt_ico`, `ac_contents`.`cnt_ico_size`, `ac_contents`.`cnt_ico_crop_info`, `ac_contents`.`cnt_attach`, `ac_contents`.`cnt_attach_size`, `ac_contents`.`cnt_string_1`, `ac_contents`.`cnt_string_2`, `ac_contents`.`cnt_string_4`, `ac_contents`.`cnt_string_5`, `ac_contents`.`cnt_string_6`, `ac_contents`.`cnt_ico_2`, `ac_contents`.`cnt_ico_2_size`, `ac_contents`.`cnt_ico_2_crop_info`, `ac_contents`.`cnt_ico_3`, `ac_contents`.`cnt_ico_3_size`, `ac_contents`.`cnt_ico_3_crop_info`, `ac_contents`.`cnt_ico_4`, `ac_contents`.`cnt_ico_4_size`, `ac_contents`.`cnt_ico_4_crop_info`, `ac_nodes`.`nnd_id`, `ac_nodes`.`nnd_plg_id`, `ac_nodes`.`nnd_lg`, `ac_nodes`.`nnd_lg_multi`, `ac_nodes`.`nnd_lg_nnd_id`, `ac_nodes`.`nnd_nnd_id`, `ac_nodes`.`nnd_title`, `ac_nodes`.`nnd_status`, `ac_nodes`.`nnd_is_public`, `ac_nodes`.`nnd_type`, `ac_nodes`.`nnd_ico`, `ac_nodes`.`nnd_ico_crop_info`, `ac_nodes`.`nnd_ico_2`, `ac_nodes`.`nnd_ico_2_crop_info`, `ac_nodes`.`nnd_subdomain`, `ac_nodes`.`nnd_text_head`, `ac_nodes`.`nnd_access_adg_id`, `ac_nodes`.`nnd_subtree_block`, `ac_nodes`.`nnd_tree_sort`, `ac_nodes`.`nnd_tree_ident`, `ac_nodes`.`nnd_css_class`, `ac_nodes`.`nnd_hide_main_menu`, `ac_nodes`.`nnd_hide_side_menu`, `ac_nodes`.`nnd_attach`, `ac_nodes`.`nnd_video`, `ac_nodes`.`nnd_hide_foot_menu`, `ac_nodes`.`nnd_subtitle_1`, `ac_nodes`.`nnd_subtitle_2`, `vf_seo`.`seo_id`, `vf_seo`.`seo_uri`, `vf_seo`.`seo_uri_md5`, `vf_seo`.`seo_route_name`, `vf_seo`.`seo_route_options`, `vf_seo`.`seo_type`, `vf_seo`.`seo_object_name`, `vf_seo`.`seo_object_id`, `vf_seo`.`seo_title`, `vf_seo`.`seo_description`, `vf_seo`.`seo_keywords`, `vf_seo`.`seo_canonical`, `vf_seo`.`seo_create_date`, `vf_seo`.`seo_update_date`, `seo2`.`seo_id` AS `cseo_id`, `seo2`.`seo_uri` AS `cseo_uri`, `seo2`.`seo_uri_md5` AS `cseo_uri_md5`, `seo2`.`seo_route_name` AS `cseo_route_name`, `seo2`.`seo_route_options` AS `cseo_route_options`, `seo2`.`seo_type` AS `cseo_type`, `seo2`.`seo_object_name` AS `cseo_object_name`, `seo2`.`seo_object_id` AS `cseo_object_id`, `seo2`.`seo_title` AS `cseo_title`, `seo2`.`seo_description` AS `cseo_description`, `seo2`.`seo_keywords` AS `cseo_keywords`, `seo2`.`seo_canonical` AS `cseo_canonical`, `seo2`.`seo_create_date` AS `cseo_create_date`, `seo2`.`seo_update_date` AS `cseo_update_date` FROM `vf_search` INNER JOIN `ac_contents` ON sea_parent_id = cnt_id INNER JOIN `ac_nodes` ON cnt_nnd_id = nnd_id LEFT JOIN `vf_seo` ON seo_object_name = 'Agicon_Node' and seo_object_id = nnd_id and seo_type = 'ROUTE' LEFT JOIN `vf_seo` AS `seo2` ON seo2.seo_object_name = 'Agicon_Content' and seo2.seo_object_id = cnt_id and seo2.seo_type = 'ROUTE' INNER JOIN `vf_categories_content` ON ccn_cnt_id = cnt_id WHERE (ccn_ctg_id in (2)) AND (sea_parent_lg = 'pl') GROUP BY `cnt_id` ORDER BY `sea_create_date` desc