Redfern_89

search_model.php (output)

Jul 7th, 2018
365
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
MySQL 1.59 KB | None | 0 0
  1. SELECT
  2.     SQL_CALC_FOUND_ROWS
  3.     `p`.`id`
  4. FROM `ex_posts` AS `p`
  5.     JOIN `ex_term_relationships` AS `tr1` ON `tr1`.`object_id` = `p`.`id`
  6.     JOIN `ex_term_taxonomy` AS `tt1` ON `tt1`.`term_id` = `tr1`.`term_taxonomy_id`
  7.     JOIN `ex_terms` AS `t1` ON `t1`.`id` = `tt1`.`term_id`
  8.         AND (`tt1`.`taxonomy` = 'post_tag' AND `t1`.`name` = 'php')
  9.  
  10.     JOIN `ex_term_relationships` AS `tr2` ON `tr2`.`object_id` = `p`.`id`
  11.     JOIN `ex_term_taxonomy` AS `tt2` ON `tt2`.`term_id` = `tr2`.`term_taxonomy_id`
  12.     JOIN `ex_terms` AS `t2` ON `t2`.`id` = `tt2`.`term_id`
  13.         AND (`tt2`.`taxonomy` = 'post_tag' AND `t2`.`name` = 'mysql')
  14.  
  15.     JOIN `ex_term_relationships` AS `tr3` ON `tr3`.`object_id` = `p`.`id`
  16.     JOIN `ex_term_taxonomy` AS `tt3` ON `tt3`.`term_id` = `tr3`.`term_taxonomy_id`
  17.     JOIN `ex_terms` AS `t3` ON `t3`.`id` = `tt3`.`term_id`
  18.         AND (`tt3`.`taxonomy` = 'post_tag' AND `t3`.`name` = 'delphi')
  19.  
  20.     JOIN `ex_term_relationships` AS `tr4` ON `tr4`.`object_id` = `p`.`id`
  21.     JOIN `ex_term_taxonomy` AS `tt4` ON `tt4`.`term_id` = `tr4`.`term_taxonomy_id`
  22.     JOIN `ex_terms` AS `t4` ON `t4`.`id` = `tt4`.`term_id`
  23.         AND (`tt4`.`taxonomy` = 'category' AND `t4`.`name` = 'programming')
  24.  
  25. WHERE (
  26.     ((`p`.`post_title` LIKE '%Ключевые%') AND (`p`.`post_title` LIKE '%слова%') AND (`p`.`post_title` LIKE '%для%') AND (`p`.`post_title` LIKE '%поиска%')) OR
  27.     ((MATCH `p`.`post_content` AGAINST ('"Ключевые"')) AND (MATCH `p`.`post_content` AGAINST ('"слова"')) AND (MATCH `p`.`post_content` AGAINST ('"для"')) AND (MATCH `p`.`post_content` AGAINST ('"поиска"')))
  28.     )
  29. GROUP BY `p`.`id` LIMIT 0, 10
Advertisement
Add Comment
Please, Sign In to add comment