Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT
- SQL_CALC_FOUND_ROWS
- `p`.`id`
- FROM `ex_posts` AS `p`
- JOIN `ex_term_relationships` AS `tr1` ON `tr1`.`object_id` = `p`.`id`
- JOIN `ex_term_taxonomy` AS `tt1` ON `tt1`.`term_id` = `tr1`.`term_taxonomy_id`
- JOIN `ex_terms` AS `t1` ON `t1`.`id` = `tt1`.`term_id`
- AND (`tt1`.`taxonomy` = 'post_tag' AND `t1`.`name` = 'php')
- JOIN `ex_term_relationships` AS `tr2` ON `tr2`.`object_id` = `p`.`id`
- JOIN `ex_term_taxonomy` AS `tt2` ON `tt2`.`term_id` = `tr2`.`term_taxonomy_id`
- JOIN `ex_terms` AS `t2` ON `t2`.`id` = `tt2`.`term_id`
- AND (`tt2`.`taxonomy` = 'post_tag' AND `t2`.`name` = 'mysql')
- JOIN `ex_term_relationships` AS `tr3` ON `tr3`.`object_id` = `p`.`id`
- JOIN `ex_term_taxonomy` AS `tt3` ON `tt3`.`term_id` = `tr3`.`term_taxonomy_id`
- JOIN `ex_terms` AS `t3` ON `t3`.`id` = `tt3`.`term_id`
- AND (`tt3`.`taxonomy` = 'post_tag' AND `t3`.`name` = 'delphi')
- JOIN `ex_term_relationships` AS `tr4` ON `tr4`.`object_id` = `p`.`id`
- JOIN `ex_term_taxonomy` AS `tt4` ON `tt4`.`term_id` = `tr4`.`term_taxonomy_id`
- JOIN `ex_terms` AS `t4` ON `t4`.`id` = `tt4`.`term_id`
- AND (`tt4`.`taxonomy` = 'category' AND `t4`.`name` = 'programming')
- WHERE (
- ((`p`.`post_title` LIKE '%Ключевые%') AND (`p`.`post_title` LIKE '%слова%') AND (`p`.`post_title` LIKE '%для%') AND (`p`.`post_title` LIKE '%поиска%')) OR
- ((MATCH `p`.`post_content` AGAINST ('"Ключевые"')) AND (MATCH `p`.`post_content` AGAINST ('"слова"')) AND (MATCH `p`.`post_content` AGAINST ('"для"')) AND (MATCH `p`.`post_content` AGAINST ('"поиска"')))
- )
- GROUP BY `p`.`id` LIMIT 0, 10
Advertisement
Add Comment
Please, Sign In to add comment