[SQL] pobierz, plaintext 
CREATE VIEW `search_view` 
AS 
	SELECT `news`.`id` 
		AS `id`,`news`.`title` 
		AS `title`,`news`.`content` 
		AS `content`,'news' 
		AS `type` FROM `news` 
	UNION SELECT `custom_pages`.`id` 
		AS `id`,`custom_pages`.`title` 
		AS `title`,`custom_pages`.`content` 
		AS `content`,'custom_page' 
		AS `type` FROM `custom_pages` 
	UNION SELECT `classifieds`.`id` 
		AS `id`,`classifieds`.`title` 
		AS `title`,`classifieds`.`content` 
		AS `content`,'classifieds' 
		AS `type` FROM `classifieds` WHERE ((`classifieds`.`active` = 1) AND (unix_timestamp() >= `classifieds`.`date_start`) AND (unix_timestamp() <= `classifieds`.`date_end`)) 
	UNION SELECT `catalog`.`id` 
		AS `id`,`catalog`.`company_name` 
		AS `title`,`catalog`.`company_description` 
		AS `content`,'catalog' 
		AS `type` FROM `catalog` 
	UNION SELECT `calendar`.`id` 
		AS `id`,`calendar`.`title` 
		AS `title`,`calendar`.`description` 
		AS `content`,'calendar' 
		AS `type` FROM `calendar` WHERE (convert(`calendar`.`date_end` USING utf8) >= convert(now() USING utf8)) 
	UNION SELECT `portal`.`panos`.`panos_id` 
		AS `id`,`portal`.`panos_meta`.`title` 
		AS `title`,`portal`.`panos`.`hash` 
		AS `content`,'panos' AS `type` FROM (`portal`.`panos` JOIN `portal`.`panos_meta` ON((`portal`.`panos_meta`.`panos_id` = `portal`.`panos`.`panos_id`)));
[SQL] pobierz, plaintext