Parent child table query

SELECT p.*
FROM parent AS p
INNER JOIN other_table_has_child AS othc ON othc.child_parent_id=p.id
WHERE p.site_id=123 AND othc.other_table_id=321;

SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0;
SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0;
SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='TRADITIONAL,ALLOW_INVALID_DATES';

CREATE SCHEMA IF NOT EXISTS `mydb` DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci ;
USE `mydb` ;

-- -----------------------------------------------------
-- Table `mydb`.`site`
-- -----------------------------------------------------
CREATE  TABLE IF NOT EXISTS `mydb`.`site` (
  `id` INT UNSIGNED NOT NULL ,
  PRIMARY KEY (`id`) )
ENGINE = InnoDB;


-- -----------------------------------------------------
-- Table `mydb`.`parent`
-- -----------------------------------------------------
CREATE  TABLE IF NOT EXISTS `mydb`.`parent` (
  `id` INT UNSIGNED NOT NULL AUTO_INCREMENT ,
  `data` VARCHAR(45) NULL ,
  `site_id` INT UNSIGNED NOT NULL ,
  PRIMARY KEY (`id`) ,
  INDEX `fk_parent_site1_idx` (`site_id` ASC) ,
  CONSTRAINT `fk_parent_site1`
    FOREIGN KEY (`site_id` )
    REFERENCES `mydb`.`site` (`id` )
    ON DELETE NO ACTION
    ON UPDATE NO ACTION)
ENGINE = InnoDB;


-- -----------------------------------------------------
-- Table `mydb`.`child`
-- -----------------------------------------------------
CREATE  TABLE IF NOT EXISTS `mydb`.`child` (
  `parent_id` INT UNSIGNED NOT NULL ,
  `data` VARCHAR(45) NULL ,
  PRIMARY KEY (`parent_id`) ,
  CONSTRAINT `fk_table1_parent`
    FOREIGN KEY (`parent_id` )
    REFERENCES `mydb`.`parent` (`id` )
    ON DELETE NO ACTION
    ON UPDATE NO ACTION)
ENGINE = InnoDB;


-- -----------------------------------------------------
-- Table `mydb`.`other_table`
-- -----------------------------------------------------
CREATE  TABLE IF NOT EXISTS `mydb`.`other_table` (
  `id` INT UNSIGNED NOT NULL AUTO_INCREMENT ,
  `data` VARCHAR(45) NULL ,
  PRIMARY KEY (`id`) )
ENGINE = InnoDB;


-- -----------------------------------------------------
-- Table `mydb`.`other_table_has_child`
-- -----------------------------------------------------
CREATE  TABLE IF NOT EXISTS `mydb`.`other_table_has_child` (
  `other_table_id` INT UNSIGNED NOT NULL ,
  `child_parent_id` INT UNSIGNED NOT NULL ,
  PRIMARY KEY (`other_table_id`, `child_parent_id`) ,
  INDEX `fk_other_table_has_child_child1_idx` (`child_parent_id` ASC) ,
  INDEX `fk_other_table_has_child_other_table1_idx` (`other_table_id` ASC) ,
  CONSTRAINT `fk_other_table_has_child_other_table1`
    FOREIGN KEY (`other_table_id` )
    REFERENCES `mydb`.`other_table` (`id` )
    ON DELETE NO ACTION
    ON UPDATE NO ACTION,
  CONSTRAINT `fk_other_table_has_child_child1`
    FOREIGN KEY (`child_parent_id` )
    REFERENCES `mydb`.`child` (`parent_id` )
    ON DELETE NO ACTION
    ON UPDATE NO ACTION)
ENGINE = InnoDB;



SET SQL_MODE=@OLD_SQL_MODE;
SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS;
SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS;

id    	select_type    	table    	type    	possible_keys    	key    	key_len    	ref    	rows    	Extra   
1 	SIMPLE 	p 	ref 	PRIMARY,fk_parent_site1_idx 	fk_parent_site1_idx 	4 	const 	1 	
1 	SIMPLE 	othc 	eq_ref 	PRIMARY,fk_other_table_has_child_child1_idx,fk_other_table_has_child_other_table1_idx 	PRIMARY 	8 	const,mydb.p.id 	1 	Using index

no...

like
          this