SELECT
IF(`l`.`en`='',`l`.`hu`, `l`.`en`) AS `childBreed`,
`child`.`cid` AS `childCid`,
`child`.`uid` AS `childUid`,
`child`.`post_id` AS `childPost`,
`child`.`id` AS `childId`,
`child`.`data` AS `child`,
`child`.`public` AS `childPublic`,
`child`.`notown` AS `childNotown`,
`child`.`offspringsLength` AS `childoffspringsLength`,
`child`.`offspringsLitter` AS `childoffspringsLitter`,
IF(`l2`.`en`='',`l2`.`hu`, `l2`.`en`) AS `breedName`,
`c`.`species` AS `breedSpecies`,
`c`.`categorys` AS `breedCategorys`,
`c`.`icon` AS `breedicon`,
`c`.`latin`,
concat('[',SUBSTRING(`child`.`interested`,1,CHAR_LENGTH(`child`.`interested`) - 1),']') AS `interested`,
`treefather`.`id` AS `treefatherId`,
`treefather`.`uid` AS `treefatherUid`,
`treefather`.`data` AS `treefather`,
`treefather`.`public` AS `treefatherPublic`,
`treefather`.`notown` AS `treefatherNotown`,
`treemother`.`id` AS `treemotherId`,
`treemother`.`uid` AS `treemotherUid`,
`treemother`.`data` AS `treemother`,
`treemother`.`public` AS `treemotherPublic`,
`treemother`.`notown` AS `treemotherNotown`,
`child`.`day_last_edit` AS `meday_last_edit`
FROM `animals` AS `child`
LEFT JOIN (`animals` AS `treefather`) ON (`treefather`.`id`=child.father_id)
LEFT JOIN (`animals` AS `treemother`) ON (`treemother`.`id`=child.mother_id)
LEFT JOIN (`category` AS `c`) ON (`c`.`id` = `child`.`cid`)
LEFT JOIN (`lang` AS `l2`) ON (`l2`.`id` = `c`.`name`)
LEFT JOIN (`breed` AS `b`) ON (`b`.`id` = SUBSTRING_INDEX(SUBSTRING_INDEX(`child`.`data`, '"breed":"', -1),'"', 1))
LEFT JOIN (`lang` AS `l`) ON (`l`.`id` = `b`.`name`)
WHERE `child`.`id`=17636SELECT
IF(`l`.`en`='',`l`.`hu`, `l`.`en`) AS `childBreed`,
`child`.`cid` AS `childCid`,
`child`.`uid` AS `childUid`,
`child`.`post_id` AS `childPost`,
`child`.`id` AS `childId`,
`child`.`data` AS `child`,
`child`.`public` AS `childPublic`,
`child`.`notown` AS `childNotown`,
`child`.`offspringsLength` AS `childoffspringsLength`,
`child`.`offspringsLitter` AS `childoffspringsLitter`,
IF(`l2`.`en`='',`l2`.`hu`, `l2`.`en`) AS `breedName`,
`c`.`species` AS `breedSpecies`,
`c`.`categorys` AS `breedCategorys`,
`c`.`icon` AS `breedicon`,
`c`.`latin`,
concat('[',SUBSTRING(`child`.`interested`,1,CHAR_LENGTH(`child`.`interested`) - 1),']') AS `interested`,
`treefather`.`id` AS `treefatherId`,
`treefather`.`uid` AS `treefatherUid`,
`treefather`.`data` AS `treefather`,
`treefather`.`public` AS `treefatherPublic`,
`treefather`.`notown` AS `treefatherNotown`,
`treemother`.`id` AS `treemotherId`,
`treemother`.`uid` AS `treemotherUid`,
`treemother`.`data` AS `treemother`,
`treemother`.`public` AS `treemotherPublic`,
`treemother`.`notown` AS `treemotherNotown`,
`child`.`day_last_edit` AS `meday_last_edit`
FROM `animals` AS `child`
LEFT JOIN (`animals` AS `treefather`) ON (`treefather`.`id`=child.father_id)
LEFT JOIN (`animals` AS `treemother`) ON (`treemother`.`id`=child.mother_id)
LEFT JOIN (`category` AS `c`) ON (`c`.`id` = `child`.`cid`)
LEFT JOIN (`lang` AS `l2`) ON (`l2`.`id` = `c`.`name`)
LEFT JOIN (`breed` AS `b`) ON (`b`.`id` = SUBSTRING_INDEX(SUBSTRING_INDEX(`child`.`data`, '"breed":"', -1),'"', 1))
LEFT JOIN (`lang` AS `l`) ON (`l`.`id` = `b`.`name`)
WHERE `child`.`id`=14685SELECT
IF(`l`.`en`='',`l`.`hu`, `l`.`en`) AS `childBreed`,
`child`.`cid` AS `childCid`,
`child`.`uid` AS `childUid`,
`child`.`post_id` AS `childPost`,
`child`.`id` AS `childId`,
`child`.`data` AS `child`,
`child`.`public` AS `childPublic`,
`child`.`notown` AS `childNotown`,
`child`.`offspringsLength` AS `childoffspringsLength`,
`child`.`offspringsLitter` AS `childoffspringsLitter`,
IF(`l2`.`en`='',`l2`.`hu`, `l2`.`en`) AS `breedName`,
`c`.`species` AS `breedSpecies`,
`c`.`categorys` AS `breedCategorys`,
`c`.`icon` AS `breedicon`,
`c`.`latin`,
concat('[',SUBSTRING(`child`.`interested`,1,CHAR_LENGTH(`child`.`interested`) - 1),']') AS `interested`,
`treefather`.`id` AS `treefatherId`,
`treefather`.`uid` AS `treefatherUid`,
`treefather`.`data` AS `treefather`,
`treefather`.`public` AS `treefatherPublic`,
`treefather`.`notown` AS `treefatherNotown`,
`treemother`.`id` AS `treemotherId`,
`treemother`.`uid` AS `treemotherUid`,
`treemother`.`data` AS `treemother`,
`treemother`.`public` AS `treemotherPublic`,
`treemother`.`notown` AS `treemotherNotown`,
`child`.`day_last_edit` AS `meday_last_edit`
FROM `animals` AS `child`
LEFT JOIN (`animals` AS `treefather`) ON (`treefather`.`id`=child.father_id)
LEFT JOIN (`animals` AS `treemother`) ON (`treemother`.`id`=child.mother_id)
LEFT JOIN (`category` AS `c`) ON (`c`.`id` = `child`.`cid`)
LEFT JOIN (`lang` AS `l2`) ON (`l2`.`id` = `c`.`name`)
LEFT JOIN (`breed` AS `b`) ON (`b`.`id` = SUBSTRING_INDEX(SUBSTRING_INDEX(`child`.`data`, '"breed":"', -1),'"', 1))
LEFT JOIN (`lang` AS `l`) ON (`l`.`id` = `b`.`name`)
WHERE `child`.`id`=12747SELECT
IF(`l`.`en`='',`l`.`hu`, `l`.`en`) AS `childBreed`,
`child`.`cid` AS `childCid`,
`child`.`uid` AS `childUid`,
`child`.`post_id` AS `childPost`,
`child`.`id` AS `childId`,
`child`.`data` AS `child`,
`child`.`public` AS `childPublic`,
`child`.`notown` AS `childNotown`,
`child`.`offspringsLength` AS `childoffspringsLength`,
`child`.`offspringsLitter` AS `childoffspringsLitter`,
IF(`l2`.`en`='',`l2`.`hu`, `l2`.`en`) AS `breedName`,
`c`.`species` AS `breedSpecies`,
`c`.`categorys` AS `breedCategorys`,
`c`.`icon` AS `breedicon`,
`c`.`latin`,
concat('[',SUBSTRING(`child`.`interested`,1,CHAR_LENGTH(`child`.`interested`) - 1),']') AS `interested`,
`treefather`.`id` AS `treefatherId`,
`treefather`.`uid` AS `treefatherUid`,
`treefather`.`data` AS `treefather`,
`treefather`.`public` AS `treefatherPublic`,
`treefather`.`notown` AS `treefatherNotown`,
`treemother`.`id` AS `treemotherId`,
`treemother`.`uid` AS `treemotherUid`,
`treemother`.`data` AS `treemother`,
`treemother`.`public` AS `treemotherPublic`,
`treemother`.`notown` AS `treemotherNotown`,
`child`.`day_last_edit` AS `meday_last_edit`
FROM `animals` AS `child`
LEFT JOIN (`animals` AS `treefather`) ON (`treefather`.`id`=child.father_id)
LEFT JOIN (`animals` AS `treemother`) ON (`treemother`.`id`=child.mother_id)
LEFT JOIN (`category` AS `c`) ON (`c`.`id` = `child`.`cid`)
LEFT JOIN (`lang` AS `l2`) ON (`l2`.`id` = `c`.`name`)
LEFT JOIN (`breed` AS `b`) ON (`b`.`id` = SUBSTRING_INDEX(SUBSTRING_INDEX(`child`.`data`, '"breed":"', -1),'"', 1))
LEFT JOIN (`lang` AS `l`) ON (`l`.`id` = `b`.`name`)
WHERE `child`.`id`=12829SELECT
IF(`l`.`en`='',`l`.`hu`, `l`.`en`) AS `childBreed`,
`child`.`cid` AS `childCid`,
`child`.`uid` AS `childUid`,
`child`.`post_id` AS `childPost`,
`child`.`id` AS `childId`,
`child`.`data` AS `child`,
`child`.`public` AS `childPublic`,
`child`.`notown` AS `childNotown`,
`child`.`offspringsLength` AS `childoffspringsLength`,
`child`.`offspringsLitter` AS `childoffspringsLitter`,
IF(`l2`.`en`='',`l2`.`hu`, `l2`.`en`) AS `breedName`,
`c`.`species` AS `breedSpecies`,
`c`.`categorys` AS `breedCategorys`,
`c`.`icon` AS `breedicon`,
`c`.`latin`,
concat('[',SUBSTRING(`child`.`interested`,1,CHAR_LENGTH(`child`.`interested`) - 1),']') AS `interested`,
`treefather`.`id` AS `treefatherId`,
`treefather`.`uid` AS `treefatherUid`,
`treefather`.`data` AS `treefather`,
`treefather`.`public` AS `treefatherPublic`,
`treefather`.`notown` AS `treefatherNotown`,
`treemother`.`id` AS `treemotherId`,
`treemother`.`uid` AS `treemotherUid`,
`treemother`.`data` AS `treemother`,
`treemother`.`public` AS `treemotherPublic`,
`treemother`.`notown` AS `treemotherNotown`,
`child`.`day_last_edit` AS `meday_last_edit`
FROM `animals` AS `child`
LEFT JOIN (`animals` AS `treefather`) ON (`treefather`.`id`=child.father_id)
LEFT JOIN (`animals` AS `treemother`) ON (`treemother`.`id`=child.mother_id)
LEFT JOIN (`category` AS `c`) ON (`c`.`id` = `child`.`cid`)
LEFT JOIN (`lang` AS `l2`) ON (`l2`.`id` = `c`.`name`)
LEFT JOIN (`breed` AS `b`) ON (`b`.`id` = SUBSTRING_INDEX(SUBSTRING_INDEX(`child`.`data`, '"breed":"', -1),'"', 1))
LEFT JOIN (`lang` AS `l`) ON (`l`.`id` = `b`.`name`)
WHERE `child`.`id`=9434SELECT
IF(`l`.`en`='',`l`.`hu`, `l`.`en`) AS `childBreed`,
`child`.`cid` AS `childCid`,
`child`.`uid` AS `childUid`,
`child`.`post_id` AS `childPost`,
`child`.`id` AS `childId`,
`child`.`data` AS `child`,
`child`.`public` AS `childPublic`,
`child`.`notown` AS `childNotown`,
`child`.`offspringsLength` AS `childoffspringsLength`,
`child`.`offspringsLitter` AS `childoffspringsLitter`,
IF(`l2`.`en`='',`l2`.`hu`, `l2`.`en`) AS `breedName`,
`c`.`species` AS `breedSpecies`,
`c`.`categorys` AS `breedCategorys`,
`c`.`icon` AS `breedicon`,
`c`.`latin`,
concat('[',SUBSTRING(`child`.`interested`,1,CHAR_LENGTH(`child`.`interested`) - 1),']') AS `interested`,
`treefather`.`id` AS `treefatherId`,
`treefather`.`uid` AS `treefatherUid`,
`treefather`.`data` AS `treefather`,
`treefather`.`public` AS `treefatherPublic`,
`treefather`.`notown` AS `treefatherNotown`,
`treemother`.`id` AS `treemotherId`,
`treemother`.`uid` AS `treemotherUid`,
`treemother`.`data` AS `treemother`,
`treemother`.`public` AS `treemotherPublic`,
`treemother`.`notown` AS `treemotherNotown`,
`child`.`day_last_edit` AS `meday_last_edit`
FROM `animals` AS `child`
LEFT JOIN (`animals` AS `treefather`) ON (`treefather`.`id`=child.father_id)
LEFT JOIN (`animals` AS `treemother`) ON (`treemother`.`id`=child.mother_id)
LEFT JOIN (`category` AS `c`) ON (`c`.`id` = `child`.`cid`)
LEFT JOIN (`lang` AS `l2`) ON (`l2`.`id` = `c`.`name`)
LEFT JOIN (`breed` AS `b`) ON (`b`.`id` = SUBSTRING_INDEX(SUBSTRING_INDEX(`child`.`data`, '"breed":"', -1),'"', 1))
LEFT JOIN (`lang` AS `l`) ON (`l`.`id` = `b`.`name`)
WHERE `child`.`id`=6380SELECT
IF(`l`.`en`='',`l`.`hu`, `l`.`en`) AS `childBreed`,
`child`.`cid` AS `childCid`,
`child`.`uid` AS `childUid`,
`child`.`post_id` AS `childPost`,
`child`.`id` AS `childId`,
`child`.`data` AS `child`,
`child`.`public` AS `childPublic`,
`child`.`notown` AS `childNotown`,
`child`.`offspringsLength` AS `childoffspringsLength`,
`child`.`offspringsLitter` AS `childoffspringsLitter`,
IF(`l2`.`en`='',`l2`.`hu`, `l2`.`en`) AS `breedName`,
`c`.`species` AS `breedSpecies`,
`c`.`categorys` AS `breedCategorys`,
`c`.`icon` AS `breedicon`,
`c`.`latin`,
concat('[',SUBSTRING(`child`.`interested`,1,CHAR_LENGTH(`child`.`interested`) - 1),']') AS `interested`,
`treefather`.`id` AS `treefatherId`,
`treefather`.`uid` AS `treefatherUid`,
`treefather`.`data` AS `treefather`,
`treefather`.`public` AS `treefatherPublic`,
`treefather`.`notown` AS `treefatherNotown`,
`treemother`.`id` AS `treemotherId`,
`treemother`.`uid` AS `treemotherUid`,
`treemother`.`data` AS `treemother`,
`treemother`.`public` AS `treemotherPublic`,
`treemother`.`notown` AS `treemotherNotown`,
`child`.`day_last_edit` AS `meday_last_edit`
FROM `animals` AS `child`
LEFT JOIN (`animals` AS `treefather`) ON (`treefather`.`id`=child.father_id)
LEFT JOIN (`animals` AS `treemother`) ON (`treemother`.`id`=child.mother_id)
LEFT JOIN (`category` AS `c`) ON (`c`.`id` = `child`.`cid`)
LEFT JOIN (`lang` AS `l2`) ON (`l2`.`id` = `c`.`name`)
LEFT JOIN (`breed` AS `b`) ON (`b`.`id` = SUBSTRING_INDEX(SUBSTRING_INDEX(`child`.`data`, '"breed":"', -1),'"', 1))
LEFT JOIN (`lang` AS `l`) ON (`l`.`id` = `b`.`name`)
WHERE `child`.`id`=6276SELECT
IF(`l`.`en`='',`l`.`hu`, `l`.`en`) AS `childBreed`,
`child`.`cid` AS `childCid`,
`child`.`uid` AS `childUid`,
`child`.`post_id` AS `childPost`,
`child`.`id` AS `childId`,
`child`.`data` AS `child`,
`child`.`public` AS `childPublic`,
`child`.`notown` AS `childNotown`,
`child`.`offspringsLength` AS `childoffspringsLength`,
`child`.`offspringsLitter` AS `childoffspringsLitter`,
IF(`l2`.`en`='',`l2`.`hu`, `l2`.`en`) AS `breedName`,
`c`.`species` AS `breedSpecies`,
`c`.`categorys` AS `breedCategorys`,
`c`.`icon` AS `breedicon`,
`c`.`latin`,
concat('[',SUBSTRING(`child`.`interested`,1,CHAR_LENGTH(`child`.`interested`) - 1),']') AS `interested`,
`treefather`.`id` AS `treefatherId`,
`treefather`.`uid` AS `treefatherUid`,
`treefather`.`data` AS `treefather`,
`treefather`.`public` AS `treefatherPublic`,
`treefather`.`notown` AS `treefatherNotown`,
`treemother`.`id` AS `treemotherId`,
`treemother`.`uid` AS `treemotherUid`,
`treemother`.`data` AS `treemother`,
`treemother`.`public` AS `treemotherPublic`,
`treemother`.`notown` AS `treemotherNotown`,
`child`.`day_last_edit` AS `meday_last_edit`
FROM `animals` AS `child`
LEFT JOIN (`animals` AS `treefather`) ON (`treefather`.`id`=child.father_id)
LEFT JOIN (`animals` AS `treemother`) ON (`treemother`.`id`=child.mother_id)
LEFT JOIN (`category` AS `c`) ON (`c`.`id` = `child`.`cid`)
LEFT JOIN (`lang` AS `l2`) ON (`l2`.`id` = `c`.`name`)
LEFT JOIN (`breed` AS `b`) ON (`b`.`id` = SUBSTRING_INDEX(SUBSTRING_INDEX(`child`.`data`, '"breed":"', -1),'"', 1))
LEFT JOIN (`lang` AS `l`) ON (`l`.`id` = `b`.`name`)
WHERE `child`.`id`=6370SELECT
IF(`l`.`en`='',`l`.`hu`, `l`.`en`) AS `childBreed`,
`child`.`cid` AS `childCid`,
`child`.`uid` AS `childUid`,
`child`.`post_id` AS `childPost`,
`child`.`id` AS `childId`,
`child`.`data` AS `child`,
`child`.`public` AS `childPublic`,
`child`.`notown` AS `childNotown`,
`child`.`offspringsLength` AS `childoffspringsLength`,
`child`.`offspringsLitter` AS `childoffspringsLitter`,
IF(`l2`.`en`='',`l2`.`hu`, `l2`.`en`) AS `breedName`,
`c`.`species` AS `breedSpecies`,
`c`.`categorys` AS `breedCategorys`,
`c`.`icon` AS `breedicon`,
`c`.`latin`,
concat('[',SUBSTRING(`child`.`interested`,1,CHAR_LENGTH(`child`.`interested`) - 1),']') AS `interested`,
`treefather`.`id` AS `treefatherId`,
`treefather`.`uid` AS `treefatherUid`,
`treefather`.`data` AS `treefather`,
`treefather`.`public` AS `treefatherPublic`,
`treefather`.`notown` AS `treefatherNotown`,
`treemother`.`id` AS `treemotherId`,
`treemother`.`uid` AS `treemotherUid`,
`treemother`.`data` AS `treemother`,
`treemother`.`public` AS `treemotherPublic`,
`treemother`.`notown` AS `treemotherNotown`,
`child`.`day_last_edit` AS `meday_last_edit`
FROM `animals` AS `child`
LEFT JOIN (`animals` AS `treefather`) ON (`treefather`.`id`=child.father_id)
LEFT JOIN (`animals` AS `treemother`) ON (`treemother`.`id`=child.mother_id)
LEFT JOIN (`category` AS `c`) ON (`c`.`id` = `child`.`cid`)
LEFT JOIN (`lang` AS `l2`) ON (`l2`.`id` = `c`.`name`)
LEFT JOIN (`breed` AS `b`) ON (`b`.`id` = SUBSTRING_INDEX(SUBSTRING_INDEX(`child`.`data`, '"breed":"', -1),'"', 1))
LEFT JOIN (`lang` AS `l`) ON (`l`.`id` = `b`.`name`)
WHERE `child`.`id`=6372SELECT
IF(`l`.`en`='',`l`.`hu`, `l`.`en`) AS `childBreed`,
`child`.`cid` AS `childCid`,
`child`.`uid` AS `childUid`,
`child`.`post_id` AS `childPost`,
`child`.`id` AS `childId`,
`child`.`data` AS `child`,
`child`.`public` AS `childPublic`,
`child`.`notown` AS `childNotown`,
`child`.`offspringsLength` AS `childoffspringsLength`,
`child`.`offspringsLitter` AS `childoffspringsLitter`,
IF(`l2`.`en`='',`l2`.`hu`, `l2`.`en`) AS `breedName`,
`c`.`species` AS `breedSpecies`,
`c`.`categorys` AS `breedCategorys`,
`c`.`icon` AS `breedicon`,
`c`.`latin`,
concat('[',SUBSTRING(`child`.`interested`,1,CHAR_LENGTH(`child`.`interested`) - 1),']') AS `interested`,
`treefather`.`id` AS `treefatherId`,
`treefather`.`uid` AS `treefatherUid`,
`treefather`.`data` AS `treefather`,
`treefather`.`public` AS `treefatherPublic`,
`treefather`.`notown` AS `treefatherNotown`,
`treemother`.`id` AS `treemotherId`,
`treemother`.`uid` AS `treemotherUid`,
`treemother`.`data` AS `treemother`,
`treemother`.`public` AS `treemotherPublic`,
`treemother`.`notown` AS `treemotherNotown`,
`child`.`day_last_edit` AS `meday_last_edit`
FROM `animals` AS `child`
LEFT JOIN (`animals` AS `treefather`) ON (`treefather`.`id`=child.father_id)
LEFT JOIN (`animals` AS `treemother`) ON (`treemother`.`id`=child.mother_id)
LEFT JOIN (`category` AS `c`) ON (`c`.`id` = `child`.`cid`)
LEFT JOIN (`lang` AS `l2`) ON (`l2`.`id` = `c`.`name`)
LEFT JOIN (`breed` AS `b`) ON (`b`.`id` = SUBSTRING_INDEX(SUBSTRING_INDEX(`child`.`data`, '"breed":"', -1),'"', 1))
LEFT JOIN (`lang` AS `l`) ON (`l`.`id` = `b`.`name`)
WHERE `child`.`id`=6373SELECT
IF(`l`.`en`='',`l`.`hu`, `l`.`en`) AS `childBreed`,
`child`.`cid` AS `childCid`,
`child`.`uid` AS `childUid`,
`child`.`post_id` AS `childPost`,
`child`.`id` AS `childId`,
`child`.`data` AS `child`,
`child`.`public` AS `childPublic`,
`child`.`notown` AS `childNotown`,
`child`.`offspringsLength` AS `childoffspringsLength`,
`child`.`offspringsLitter` AS `childoffspringsLitter`,
IF(`l2`.`en`='',`l2`.`hu`, `l2`.`en`) AS `breedName`,
`c`.`species` AS `breedSpecies`,
`c`.`categorys` AS `breedCategorys`,
`c`.`icon` AS `breedicon`,
`c`.`latin`,
concat('[',SUBSTRING(`child`.`interested`,1,CHAR_LENGTH(`child`.`interested`) - 1),']') AS `interested`,
`treefather`.`id` AS `treefatherId`,
`treefather`.`uid` AS `treefatherUid`,
`treefather`.`data` AS `treefather`,
`treefather`.`public` AS `treefatherPublic`,
`treefather`.`notown` AS `treefatherNotown`,
`treemother`.`id` AS `treemotherId`,
`treemother`.`uid` AS `treemotherUid`,
`treemother`.`data` AS `treemother`,
`treemother`.`public` AS `treemotherPublic`,
`treemother`.`notown` AS `treemotherNotown`,
`child`.`day_last_edit` AS `meday_last_edit`
FROM `animals` AS `child`
LEFT JOIN (`animals` AS `treefather`) ON (`treefather`.`id`=child.father_id)
LEFT JOIN (`animals` AS `treemother`) ON (`treemother`.`id`=child.mother_id)
LEFT JOIN (`category` AS `c`) ON (`c`.`id` = `child`.`cid`)
LEFT JOIN (`lang` AS `l2`) ON (`l2`.`id` = `c`.`name`)
LEFT JOIN (`breed` AS `b`) ON (`b`.`id` = SUBSTRING_INDEX(SUBSTRING_INDEX(`child`.`data`, '"breed":"', -1),'"', 1))
LEFT JOIN (`lang` AS `l`) ON (`l`.`id` = `b`.`name`)
WHERE `child`.`id`=6235SELECT
IF(`l`.`en`='',`l`.`hu`, `l`.`en`) AS `childBreed`,
`child`.`cid` AS `childCid`,
`child`.`uid` AS `childUid`,
`child`.`post_id` AS `childPost`,
`child`.`id` AS `childId`,
`child`.`data` AS `child`,
`child`.`public` AS `childPublic`,
`child`.`notown` AS `childNotown`,
`child`.`offspringsLength` AS `childoffspringsLength`,
`child`.`offspringsLitter` AS `childoffspringsLitter`,
IF(`l2`.`en`='',`l2`.`hu`, `l2`.`en`) AS `breedName`,
`c`.`species` AS `breedSpecies`,
`c`.`categorys` AS `breedCategorys`,
`c`.`icon` AS `breedicon`,
`c`.`latin`,
concat('[',SUBSTRING(`child`.`interested`,1,CHAR_LENGTH(`child`.`interested`) - 1),']') AS `interested`,
`treefather`.`id` AS `treefatherId`,
`treefather`.`uid` AS `treefatherUid`,
`treefather`.`data` AS `treefather`,
`treefather`.`public` AS `treefatherPublic`,
`treefather`.`notown` AS `treefatherNotown`,
`treemother`.`id` AS `treemotherId`,
`treemother`.`uid` AS `treemotherUid`,
`treemother`.`data` AS `treemother`,
`treemother`.`public` AS `treemotherPublic`,
`treemother`.`notown` AS `treemotherNotown`,
`child`.`day_last_edit` AS `meday_last_edit`
FROM `animals` AS `child`
LEFT JOIN (`animals` AS `treefather`) ON (`treefather`.`id`=child.father_id)
LEFT JOIN (`animals` AS `treemother`) ON (`treemother`.`id`=child.mother_id)
LEFT JOIN (`category` AS `c`) ON (`c`.`id` = `child`.`cid`)
LEFT JOIN (`lang` AS `l2`) ON (`l2`.`id` = `c`.`name`)
LEFT JOIN (`breed` AS `b`) ON (`b`.`id` = SUBSTRING_INDEX(SUBSTRING_INDEX(`child`.`data`, '"breed":"', -1),'"', 1))
LEFT JOIN (`lang` AS `l`) ON (`l`.`id` = `b`.`name`)
WHERE `child`.`id`=6239SELECT
IF(`l`.`en`='',`l`.`hu`, `l`.`en`) AS `childBreed`,
`child`.`cid` AS `childCid`,
`child`.`uid` AS `childUid`,
`child`.`post_id` AS `childPost`,
`child`.`id` AS `childId`,
`child`.`data` AS `child`,
`child`.`public` AS `childPublic`,
`child`.`notown` AS `childNotown`,
`child`.`offspringsLength` AS `childoffspringsLength`,
`child`.`offspringsLitter` AS `childoffspringsLitter`,
IF(`l2`.`en`='',`l2`.`hu`, `l2`.`en`) AS `breedName`,
`c`.`species` AS `breedSpecies`,
`c`.`categorys` AS `breedCategorys`,
`c`.`icon` AS `breedicon`,
`c`.`latin`,
concat('[',SUBSTRING(`child`.`interested`,1,CHAR_LENGTH(`child`.`interested`) - 1),']') AS `interested`,
`treefather`.`id` AS `treefatherId`,
`treefather`.`uid` AS `treefatherUid`,
`treefather`.`data` AS `treefather`,
`treefather`.`public` AS `treefatherPublic`,
`treefather`.`notown` AS `treefatherNotown`,
`treemother`.`id` AS `treemotherId`,
`treemother`.`uid` AS `treemotherUid`,
`treemother`.`data` AS `treemother`,
`treemother`.`public` AS `treemotherPublic`,
`treemother`.`notown` AS `treemotherNotown`,
`child`.`day_last_edit` AS `meday_last_edit`
FROM `animals` AS `child`
LEFT JOIN (`animals` AS `treefather`) ON (`treefather`.`id`=child.father_id)
LEFT JOIN (`animals` AS `treemother`) ON (`treemother`.`id`=child.mother_id)
LEFT JOIN (`category` AS `c`) ON (`c`.`id` = `child`.`cid`)
LEFT JOIN (`lang` AS `l2`) ON (`l2`.`id` = `c`.`name`)
LEFT JOIN (`breed` AS `b`) ON (`b`.`id` = SUBSTRING_INDEX(SUBSTRING_INDEX(`child`.`data`, '"breed":"', -1),'"', 1))
LEFT JOIN (`lang` AS `l`) ON (`l`.`id` = `b`.`name`)
WHERE `child`.`id`=6240SELECT
IF(`l`.`en`='',`l`.`hu`, `l`.`en`) AS `childBreed`,
`child`.`cid` AS `childCid`,
`child`.`uid` AS `childUid`,
`child`.`post_id` AS `childPost`,
`child`.`id` AS `childId`,
`child`.`data` AS `child`,
`child`.`public` AS `childPublic`,
`child`.`notown` AS `childNotown`,
`child`.`offspringsLength` AS `childoffspringsLength`,
`child`.`offspringsLitter` AS `childoffspringsLitter`,
IF(`l2`.`en`='',`l2`.`hu`, `l2`.`en`) AS `breedName`,
`c`.`species` AS `breedSpecies`,
`c`.`categorys` AS `breedCategorys`,
`c`.`icon` AS `breedicon`,
`c`.`latin`,
concat('[',SUBSTRING(`child`.`interested`,1,CHAR_LENGTH(`child`.`interested`) - 1),']') AS `interested`,
`treefather`.`id` AS `treefatherId`,
`treefather`.`uid` AS `treefatherUid`,
`treefather`.`data` AS `treefather`,
`treefather`.`public` AS `treefatherPublic`,
`treefather`.`notown` AS `treefatherNotown`,
`treemother`.`id` AS `treemotherId`,
`treemother`.`uid` AS `treemotherUid`,
`treemother`.`data` AS `treemother`,
`treemother`.`public` AS `treemotherPublic`,
`treemother`.`notown` AS `treemotherNotown`,
`child`.`day_last_edit` AS `meday_last_edit`
FROM `animals` AS `child`
LEFT JOIN (`animals` AS `treefather`) ON (`treefather`.`id`=child.father_id)
LEFT JOIN (`animals` AS `treemother`) ON (`treemother`.`id`=child.mother_id)
LEFT JOIN (`category` AS `c`) ON (`c`.`id` = `child`.`cid`)
LEFT JOIN (`lang` AS `l2`) ON (`l2`.`id` = `c`.`name`)
LEFT JOIN (`breed` AS `b`) ON (`b`.`id` = SUBSTRING_INDEX(SUBSTRING_INDEX(`child`.`data`, '"breed":"', -1),'"', 1))
LEFT JOIN (`lang` AS `l`) ON (`l`.`id` = `b`.`name`)
WHERE `child`.`id`=6236SELECT
IF(`l`.`en`='',`l`.`hu`, `l`.`en`) AS `childBreed`,
`child`.`cid` AS `childCid`,
`child`.`uid` AS `childUid`,
`child`.`post_id` AS `childPost`,
`child`.`id` AS `childId`,
`child`.`data` AS `child`,
`child`.`public` AS `childPublic`,
`child`.`notown` AS `childNotown`,
`child`.`offspringsLength` AS `childoffspringsLength`,
`child`.`offspringsLitter` AS `childoffspringsLitter`,
IF(`l2`.`en`='',`l2`.`hu`, `l2`.`en`) AS `breedName`,
`c`.`species` AS `breedSpecies`,
`c`.`categorys` AS `breedCategorys`,
`c`.`icon` AS `breedicon`,
`c`.`latin`,
concat('[',SUBSTRING(`child`.`interested`,1,CHAR_LENGTH(`child`.`interested`) - 1),']') AS `interested`,
`treefather`.`id` AS `treefatherId`,
`treefather`.`uid` AS `treefatherUid`,
`treefather`.`data` AS `treefather`,
`treefather`.`public` AS `treefatherPublic`,
`treefather`.`notown` AS `treefatherNotown`,
`treemother`.`id` AS `treemotherId`,
`treemother`.`uid` AS `treemotherUid`,
`treemother`.`data` AS `treemother`,
`treemother`.`public` AS `treemotherPublic`,
`treemother`.`notown` AS `treemotherNotown`,
`child`.`day_last_edit` AS `meday_last_edit`
FROM `animals` AS `child`
LEFT JOIN (`animals` AS `treefather`) ON (`treefather`.`id`=child.father_id)
LEFT JOIN (`animals` AS `treemother`) ON (`treemother`.`id`=child.mother_id)
LEFT JOIN (`category` AS `c`) ON (`c`.`id` = `child`.`cid`)
LEFT JOIN (`lang` AS `l2`) ON (`l2`.`id` = `c`.`name`)
LEFT JOIN (`breed` AS `b`) ON (`b`.`id` = SUBSTRING_INDEX(SUBSTRING_INDEX(`child`.`data`, '"breed":"', -1),'"', 1))
LEFT JOIN (`lang` AS `l`) ON (`l`.`id` = `b`.`name`)
WHERE `child`.`id`=6375SELECT
IF(`l`.`en`='',`l`.`hu`, `l`.`en`) AS `childBreed`,
`child`.`cid` AS `childCid`,
`child`.`uid` AS `childUid`,
`child`.`post_id` AS `childPost`,
`child`.`id` AS `childId`,
`child`.`data` AS `child`,
`child`.`public` AS `childPublic`,
`child`.`notown` AS `childNotown`,
`child`.`offspringsLength` AS `childoffspringsLength`,
`child`.`offspringsLitter` AS `childoffspringsLitter`,
IF(`l2`.`en`='',`l2`.`hu`, `l2`.`en`) AS `breedName`,
`c`.`species` AS `breedSpecies`,
`c`.`categorys` AS `breedCategorys`,
`c`.`icon` AS `breedicon`,
`c`.`latin`,
concat('[',SUBSTRING(`child`.`interested`,1,CHAR_LENGTH(`child`.`interested`) - 1),']') AS `interested`,
`treefather`.`id` AS `treefatherId`,
`treefather`.`uid` AS `treefatherUid`,
`treefather`.`data` AS `treefather`,
`treefather`.`public` AS `treefatherPublic`,
`treefather`.`notown` AS `treefatherNotown`,
`treemother`.`id` AS `treemotherId`,
`treemother`.`uid` AS `treemotherUid`,
`treemother`.`data` AS `treemother`,
`treemother`.`public` AS `treemotherPublic`,
`treemother`.`notown` AS `treemotherNotown`,
`child`.`day_last_edit` AS `meday_last_edit`
FROM `animals` AS `child`
LEFT JOIN (`animals` AS `treefather`) ON (`treefather`.`id`=child.father_id)
LEFT JOIN (`animals` AS `treemother`) ON (`treemother`.`id`=child.mother_id)
LEFT JOIN (`category` AS `c`) ON (`c`.`id` = `child`.`cid`)
LEFT JOIN (`lang` AS `l2`) ON (`l2`.`id` = `c`.`name`)
LEFT JOIN (`breed` AS `b`) ON (`b`.`id` = SUBSTRING_INDEX(SUBSTRING_INDEX(`child`.`data`, '"breed":"', -1),'"', 1))
LEFT JOIN (`lang` AS `l`) ON (`l`.`id` = `b`.`name`)
WHERE `child`.`id`=6237SELECT
IF(`l`.`en`='',`l`.`hu`, `l`.`en`) AS `childBreed`,
`child`.`cid` AS `childCid`,
`child`.`uid` AS `childUid`,
`child`.`post_id` AS `childPost`,
`child`.`id` AS `childId`,
`child`.`data` AS `child`,
`child`.`public` AS `childPublic`,
`child`.`notown` AS `childNotown`,
`child`.`offspringsLength` AS `childoffspringsLength`,
`child`.`offspringsLitter` AS `childoffspringsLitter`,
IF(`l2`.`en`='',`l2`.`hu`, `l2`.`en`) AS `breedName`,
`c`.`species` AS `breedSpecies`,
`c`.`categorys` AS `breedCategorys`,
`c`.`icon` AS `breedicon`,
`c`.`latin`,
concat('[',SUBSTRING(`child`.`interested`,1,CHAR_LENGTH(`child`.`interested`) - 1),']') AS `interested`,
`treefather`.`id` AS `treefatherId`,
`treefather`.`uid` AS `treefatherUid`,
`treefather`.`data` AS `treefather`,
`treefather`.`public` AS `treefatherPublic`,
`treefather`.`notown` AS `treefatherNotown`,
`treemother`.`id` AS `treemotherId`,
`treemother`.`uid` AS `treemotherUid`,
`treemother`.`data` AS `treemother`,
`treemother`.`public` AS `treemotherPublic`,
`treemother`.`notown` AS `treemotherNotown`,
`child`.`day_last_edit` AS `meday_last_edit`
FROM `animals` AS `child`
LEFT JOIN (`animals` AS `treefather`) ON (`treefather`.`id`=child.father_id)
LEFT JOIN (`animals` AS `treemother`) ON (`treemother`.`id`=child.mother_id)
LEFT JOIN (`category` AS `c`) ON (`c`.`id` = `child`.`cid`)
LEFT JOIN (`lang` AS `l2`) ON (`l2`.`id` = `c`.`name`)
LEFT JOIN (`breed` AS `b`) ON (`b`.`id` = SUBSTRING_INDEX(SUBSTRING_INDEX(`child`.`data`, '"breed":"', -1),'"', 1))
LEFT JOIN (`lang` AS `l`) ON (`l`.`id` = `b`.`name`)
WHERE `child`.`id`=6377SELECT
IF(`l`.`en`='',`l`.`hu`, `l`.`en`) AS `childBreed`,
`child`.`cid` AS `childCid`,
`child`.`uid` AS `childUid`,
`child`.`post_id` AS `childPost`,
`child`.`id` AS `childId`,
`child`.`data` AS `child`,
`child`.`public` AS `childPublic`,
`child`.`notown` AS `childNotown`,
`child`.`offspringsLength` AS `childoffspringsLength`,
`child`.`offspringsLitter` AS `childoffspringsLitter`,
IF(`l2`.`en`='',`l2`.`hu`, `l2`.`en`) AS `breedName`,
`c`.`species` AS `breedSpecies`,
`c`.`categorys` AS `breedCategorys`,
`c`.`icon` AS `breedicon`,
`c`.`latin`,
concat('[',SUBSTRING(`child`.`interested`,1,CHAR_LENGTH(`child`.`interested`) - 1),']') AS `interested`,
`treefather`.`id` AS `treefatherId`,
`treefather`.`uid` AS `treefatherUid`,
`treefather`.`data` AS `treefather`,
`treefather`.`public` AS `treefatherPublic`,
`treefather`.`notown` AS `treefatherNotown`,
`treemother`.`id` AS `treemotherId`,
`treemother`.`uid` AS `treemotherUid`,
`treemother`.`data` AS `treemother`,
`treemother`.`public` AS `treemotherPublic`,
`treemother`.`notown` AS `treemotherNotown`,
`child`.`day_last_edit` AS `meday_last_edit`
FROM `animals` AS `child`
LEFT JOIN (`animals` AS `treefather`) ON (`treefather`.`id`=child.father_id)
LEFT JOIN (`animals` AS `treemother`) ON (`treemother`.`id`=child.mother_id)
LEFT JOIN (`category` AS `c`) ON (`c`.`id` = `child`.`cid`)
LEFT JOIN (`lang` AS `l2`) ON (`l2`.`id` = `c`.`name`)
LEFT JOIN (`breed` AS `b`) ON (`b`.`id` = SUBSTRING_INDEX(SUBSTRING_INDEX(`child`.`data`, '"breed":"', -1),'"', 1))
LEFT JOIN (`lang` AS `l`) ON (`l`.`id` = `b`.`name`)
WHERE `child`.`id`=6466SELECT
IF(`l`.`en`='',`l`.`hu`, `l`.`en`) AS `childBreed`,
`child`.`cid` AS `childCid`,
`child`.`uid` AS `childUid`,
`child`.`post_id` AS `childPost`,
`child`.`id` AS `childId`,
`child`.`data` AS `child`,
`child`.`public` AS `childPublic`,
`child`.`notown` AS `childNotown`,
`child`.`offspringsLength` AS `childoffspringsLength`,
`child`.`offspringsLitter` AS `childoffspringsLitter`,
IF(`l2`.`en`='',`l2`.`hu`, `l2`.`en`) AS `breedName`,
`c`.`species` AS `breedSpecies`,
`c`.`categorys` AS `breedCategorys`,
`c`.`icon` AS `breedicon`,
`c`.`latin`,
concat('[',SUBSTRING(`child`.`interested`,1,CHAR_LENGTH(`child`.`interested`) - 1),']') AS `interested`,
`treefather`.`id` AS `treefatherId`,
`treefather`.`uid` AS `treefatherUid`,
`treefather`.`data` AS `treefather`,
`treefather`.`public` AS `treefatherPublic`,
`treefather`.`notown` AS `treefatherNotown`,
`treemother`.`id` AS `treemotherId`,
`treemother`.`uid` AS `treemotherUid`,
`treemother`.`data` AS `treemother`,
`treemother`.`public` AS `treemotherPublic`,
`treemother`.`notown` AS `treemotherNotown`,
`child`.`day_last_edit` AS `meday_last_edit`
FROM `animals` AS `child`
LEFT JOIN (`animals` AS `treefather`) ON (`treefather`.`id`=child.father_id)
LEFT JOIN (`animals` AS `treemother`) ON (`treemother`.`id`=child.mother_id)
LEFT JOIN (`category` AS `c`) ON (`c`.`id` = `child`.`cid`)
LEFT JOIN (`lang` AS `l2`) ON (`l2`.`id` = `c`.`name`)
LEFT JOIN (`breed` AS `b`) ON (`b`.`id` = SUBSTRING_INDEX(SUBSTRING_INDEX(`child`.`data`, '"breed":"', -1),'"', 1))
LEFT JOIN (`lang` AS `l`) ON (`l`.`id` = `b`.`name`)
WHERE `child`.`id`=6225SELECT
IF(`l`.`en`='',`l`.`hu`, `l`.`en`) AS `childBreed`,
`child`.`cid` AS `childCid`,
`child`.`uid` AS `childUid`,
`child`.`post_id` AS `childPost`,
`child`.`id` AS `childId`,
`child`.`data` AS `child`,
`child`.`public` AS `childPublic`,
`child`.`notown` AS `childNotown`,
`child`.`offspringsLength` AS `childoffspringsLength`,
`child`.`offspringsLitter` AS `childoffspringsLitter`,
IF(`l2`.`en`='',`l2`.`hu`, `l2`.`en`) AS `breedName`,
`c`.`species` AS `breedSpecies`,
`c`.`categorys` AS `breedCategorys`,
`c`.`icon` AS `breedicon`,
`c`.`latin`,
concat('[',SUBSTRING(`child`.`interested`,1,CHAR_LENGTH(`child`.`interested`) - 1),']') AS `interested`,
`treefather`.`id` AS `treefatherId`,
`treefather`.`uid` AS `treefatherUid`,
`treefather`.`data` AS `treefather`,
`treefather`.`public` AS `treefatherPublic`,
`treefather`.`notown` AS `treefatherNotown`,
`treemother`.`id` AS `treemotherId`,
`treemother`.`uid` AS `treemotherUid`,
`treemother`.`data` AS `treemother`,
`treemother`.`public` AS `treemotherPublic`,
`treemother`.`notown` AS `treemotherNotown`,
`child`.`day_last_edit` AS `meday_last_edit`
FROM `animals` AS `child`
LEFT JOIN (`animals` AS `treefather`) ON (`treefather`.`id`=child.father_id)
LEFT JOIN (`animals` AS `treemother`) ON (`treemother`.`id`=child.mother_id)
LEFT JOIN (`category` AS `c`) ON (`c`.`id` = `child`.`cid`)
LEFT JOIN (`lang` AS `l2`) ON (`l2`.`id` = `c`.`name`)
LEFT JOIN (`breed` AS `b`) ON (`b`.`id` = SUBSTRING_INDEX(SUBSTRING_INDEX(`child`.`data`, '"breed":"', -1),'"', 1))
LEFT JOIN (`lang` AS `l`) ON (`l`.`id` = `b`.`name`)
WHERE `child`.`id`=8284SELECT
IF(`l`.`en`='',`l`.`hu`, `l`.`en`) AS `childBreed`,
`child`.`cid` AS `childCid`,
`child`.`uid` AS `childUid`,
`child`.`post_id` AS `childPost`,
`child`.`id` AS `childId`,
`child`.`data` AS `child`,
`child`.`public` AS `childPublic`,
`child`.`notown` AS `childNotown`,
`child`.`offspringsLength` AS `childoffspringsLength`,
`child`.`offspringsLitter` AS `childoffspringsLitter`,
IF(`l2`.`en`='',`l2`.`hu`, `l2`.`en`) AS `breedName`,
`c`.`species` AS `breedSpecies`,
`c`.`categorys` AS `breedCategorys`,
`c`.`icon` AS `breedicon`,
`c`.`latin`,
concat('[',SUBSTRING(`child`.`interested`,1,CHAR_LENGTH(`child`.`interested`) - 1),']') AS `interested`,
`treefather`.`id` AS `treefatherId`,
`treefather`.`uid` AS `treefatherUid`,
`treefather`.`data` AS `treefather`,
`treefather`.`public` AS `treefatherPublic`,
`treefather`.`notown` AS `treefatherNotown`,
`treemother`.`id` AS `treemotherId`,
`treemother`.`uid` AS `treemotherUid`,
`treemother`.`data` AS `treemother`,
`treemother`.`public` AS `treemotherPublic`,
`treemother`.`notown` AS `treemotherNotown`,
`child`.`day_last_edit` AS `meday_last_edit`
FROM `animals` AS `child`
LEFT JOIN (`animals` AS `treefather`) ON (`treefather`.`id`=child.father_id)
LEFT JOIN (`animals` AS `treemother`) ON (`treemother`.`id`=child.mother_id)
LEFT JOIN (`category` AS `c`) ON (`c`.`id` = `child`.`cid`)
LEFT JOIN (`lang` AS `l2`) ON (`l2`.`id` = `c`.`name`)
LEFT JOIN (`breed` AS `b`) ON (`b`.`id` = SUBSTRING_INDEX(SUBSTRING_INDEX(`child`.`data`, '"breed":"', -1),'"', 1))
LEFT JOIN (`lang` AS `l`) ON (`l`.`id` = `b`.`name`)
WHERE `child`.`id`=8283SELECT
IF(`l`.`en`='',`l`.`hu`, `l`.`en`) AS `childBreed`,
`child`.`cid` AS `childCid`,
`child`.`uid` AS `childUid`,
`child`.`post_id` AS `childPost`,
`child`.`id` AS `childId`,
`child`.`data` AS `child`,
`child`.`public` AS `childPublic`,
`child`.`notown` AS `childNotown`,
`child`.`offspringsLength` AS `childoffspringsLength`,
`child`.`offspringsLitter` AS `childoffspringsLitter`,
IF(`l2`.`en`='',`l2`.`hu`, `l2`.`en`) AS `breedName`,
`c`.`species` AS `breedSpecies`,
`c`.`categorys` AS `breedCategorys`,
`c`.`icon` AS `breedicon`,
`c`.`latin`,
concat('[',SUBSTRING(`child`.`interested`,1,CHAR_LENGTH(`child`.`interested`) - 1),']') AS `interested`,
`treefather`.`id` AS `treefatherId`,
`treefather`.`uid` AS `treefatherUid`,
`treefather`.`data` AS `treefather`,
`treefather`.`public` AS `treefatherPublic`,
`treefather`.`notown` AS `treefatherNotown`,
`treemother`.`id` AS `treemotherId`,
`treemother`.`uid` AS `treemotherUid`,
`treemother`.`data` AS `treemother`,
`treemother`.`public` AS `treemotherPublic`,
`treemother`.`notown` AS `treemotherNotown`,
`child`.`day_last_edit` AS `meday_last_edit`
FROM `animals` AS `child`
LEFT JOIN (`animals` AS `treefather`) ON (`treefather`.`id`=child.father_id)
LEFT JOIN (`animals` AS `treemother`) ON (`treemother`.`id`=child.mother_id)
LEFT JOIN (`category` AS `c`) ON (`c`.`id` = `child`.`cid`)
LEFT JOIN (`lang` AS `l2`) ON (`l2`.`id` = `c`.`name`)
LEFT JOIN (`breed` AS `b`) ON (`b`.`id` = SUBSTRING_INDEX(SUBSTRING_INDEX(`child`.`data`, '"breed":"', -1),'"', 1))
LEFT JOIN (`lang` AS `l`) ON (`l`.`id` = `b`.`name`)
WHERE `child`.`id`=8286SELECT
IF(`l`.`en`='',`l`.`hu`, `l`.`en`) AS `childBreed`,
`child`.`cid` AS `childCid`,
`child`.`uid` AS `childUid`,
`child`.`post_id` AS `childPost`,
`child`.`id` AS `childId`,
`child`.`data` AS `child`,
`child`.`public` AS `childPublic`,
`child`.`notown` AS `childNotown`,
`child`.`offspringsLength` AS `childoffspringsLength`,
`child`.`offspringsLitter` AS `childoffspringsLitter`,
IF(`l2`.`en`='',`l2`.`hu`, `l2`.`en`) AS `breedName`,
`c`.`species` AS `breedSpecies`,
`c`.`categorys` AS `breedCategorys`,
`c`.`icon` AS `breedicon`,
`c`.`latin`,
concat('[',SUBSTRING(`child`.`interested`,1,CHAR_LENGTH(`child`.`interested`) - 1),']') AS `interested`,
`treefather`.`id` AS `treefatherId`,
`treefather`.`uid` AS `treefatherUid`,
`treefather`.`data` AS `treefather`,
`treefather`.`public` AS `treefatherPublic`,
`treefather`.`notown` AS `treefatherNotown`,
`treemother`.`id` AS `treemotherId`,
`treemother`.`uid` AS `treemotherUid`,
`treemother`.`data` AS `treemother`,
`treemother`.`public` AS `treemotherPublic`,
`treemother`.`notown` AS `treemotherNotown`,
`child`.`day_last_edit` AS `meday_last_edit`
FROM `animals` AS `child`
LEFT JOIN (`animals` AS `treefather`) ON (`treefather`.`id`=child.father_id)
LEFT JOIN (`animals` AS `treemother`) ON (`treemother`.`id`=child.mother_id)
LEFT JOIN (`category` AS `c`) ON (`c`.`id` = `child`.`cid`)
LEFT JOIN (`lang` AS `l2`) ON (`l2`.`id` = `c`.`name`)
LEFT JOIN (`breed` AS `b`) ON (`b`.`id` = SUBSTRING_INDEX(SUBSTRING_INDEX(`child`.`data`, '"breed":"', -1),'"', 1))
LEFT JOIN (`lang` AS `l`) ON (`l`.`id` = `b`.`name`)
WHERE `child`.`id`=8285SELECT
IF(`l`.`en`='',`l`.`hu`, `l`.`en`) AS `childBreed`,
`child`.`cid` AS `childCid`,
`child`.`uid` AS `childUid`,
`child`.`post_id` AS `childPost`,
`child`.`id` AS `childId`,
`child`.`data` AS `child`,
`child`.`public` AS `childPublic`,
`child`.`notown` AS `childNotown`,
`child`.`offspringsLength` AS `childoffspringsLength`,
`child`.`offspringsLitter` AS `childoffspringsLitter`,
IF(`l2`.`en`='',`l2`.`hu`, `l2`.`en`) AS `breedName`,
`c`.`species` AS `breedSpecies`,
`c`.`categorys` AS `breedCategorys`,
`c`.`icon` AS `breedicon`,
`c`.`latin`,
concat('[',SUBSTRING(`child`.`interested`,1,CHAR_LENGTH(`child`.`interested`) - 1),']') AS `interested`,
`treefather`.`id` AS `treefatherId`,
`treefather`.`uid` AS `treefatherUid`,
`treefather`.`data` AS `treefather`,
`treefather`.`public` AS `treefatherPublic`,
`treefather`.`notown` AS `treefatherNotown`,
`treemother`.`id` AS `treemotherId`,
`treemother`.`uid` AS `treemotherUid`,
`treemother`.`data` AS `treemother`,
`treemother`.`public` AS `treemotherPublic`,
`treemother`.`notown` AS `treemotherNotown`,
`child`.`day_last_edit` AS `meday_last_edit`
FROM `animals` AS `child`
LEFT JOIN (`animals` AS `treefather`) ON (`treefather`.`id`=child.father_id)
LEFT JOIN (`animals` AS `treemother`) ON (`treemother`.`id`=child.mother_id)
LEFT JOIN (`category` AS `c`) ON (`c`.`id` = `child`.`cid`)
LEFT JOIN (`lang` AS `l2`) ON (`l2`.`id` = `c`.`name`)
LEFT JOIN (`breed` AS `b`) ON (`b`.`id` = SUBSTRING_INDEX(SUBSTRING_INDEX(`child`.`data`, '"breed":"', -1),'"', 1))
LEFT JOIN (`lang` AS `l`) ON (`l`.`id` = `b`.`name`)
WHERE `child`.`id`=6463SELECT
IF(`l`.`en`='',`l`.`hu`, `l`.`en`) AS `childBreed`,
`child`.`cid` AS `childCid`,
`child`.`uid` AS `childUid`,
`child`.`post_id` AS `childPost`,
`child`.`id` AS `childId`,
`child`.`data` AS `child`,
`child`.`public` AS `childPublic`,
`child`.`notown` AS `childNotown`,
`child`.`offspringsLength` AS `childoffspringsLength`,
`child`.`offspringsLitter` AS `childoffspringsLitter`,
IF(`l2`.`en`='',`l2`.`hu`, `l2`.`en`) AS `breedName`,
`c`.`species` AS `breedSpecies`,
`c`.`categorys` AS `breedCategorys`,
`c`.`icon` AS `breedicon`,
`c`.`latin`,
concat('[',SUBSTRING(`child`.`interested`,1,CHAR_LENGTH(`child`.`interested`) - 1),']') AS `interested`,
`treefather`.`id` AS `treefatherId`,
`treefather`.`uid` AS `treefatherUid`,
`treefather`.`data` AS `treefather`,
`treefather`.`public` AS `treefatherPublic`,
`treefather`.`notown` AS `treefatherNotown`,
`treemother`.`id` AS `treemotherId`,
`treemother`.`uid` AS `treemotherUid`,
`treemother`.`data` AS `treemother`,
`treemother`.`public` AS `treemotherPublic`,
`treemother`.`notown` AS `treemotherNotown`,
`child`.`day_last_edit` AS `meday_last_edit`
FROM `animals` AS `child`
LEFT JOIN (`animals` AS `treefather`) ON (`treefather`.`id`=child.father_id)
LEFT JOIN (`animals` AS `treemother`) ON (`treemother`.`id`=child.mother_id)
LEFT JOIN (`category` AS `c`) ON (`c`.`id` = `child`.`cid`)
LEFT JOIN (`lang` AS `l2`) ON (`l2`.`id` = `c`.`name`)
LEFT JOIN (`breed` AS `b`) ON (`b`.`id` = SUBSTRING_INDEX(SUBSTRING_INDEX(`child`.`data`, '"breed":"', -1),'"', 1))
LEFT JOIN (`lang` AS `l`) ON (`l`.`id` = `b`.`name`)
WHERE `child`.`id`=6254SELECT
IF(`l`.`en`='',`l`.`hu`, `l`.`en`) AS `childBreed`,
`child`.`cid` AS `childCid`,
`child`.`uid` AS `childUid`,
`child`.`post_id` AS `childPost`,
`child`.`id` AS `childId`,
`child`.`data` AS `child`,
`child`.`public` AS `childPublic`,
`child`.`notown` AS `childNotown`,
`child`.`offspringsLength` AS `childoffspringsLength`,
`child`.`offspringsLitter` AS `childoffspringsLitter`,
IF(`l2`.`en`='',`l2`.`hu`, `l2`.`en`) AS `breedName`,
`c`.`species` AS `breedSpecies`,
`c`.`categorys` AS `breedCategorys`,
`c`.`icon` AS `breedicon`,
`c`.`latin`,
concat('[',SUBSTRING(`child`.`interested`,1,CHAR_LENGTH(`child`.`interested`) - 1),']') AS `interested`,
`treefather`.`id` AS `treefatherId`,
`treefather`.`uid` AS `treefatherUid`,
`treefather`.`data` AS `treefather`,
`treefather`.`public` AS `treefatherPublic`,
`treefather`.`notown` AS `treefatherNotown`,
`treemother`.`id` AS `treemotherId`,
`treemother`.`uid` AS `treemotherUid`,
`treemother`.`data` AS `treemother`,
`treemother`.`public` AS `treemotherPublic`,
`treemother`.`notown` AS `treemotherNotown`,
`child`.`day_last_edit` AS `meday_last_edit`
FROM `animals` AS `child`
LEFT JOIN (`animals` AS `treefather`) ON (`treefather`.`id`=child.father_id)
LEFT JOIN (`animals` AS `treemother`) ON (`treemother`.`id`=child.mother_id)
LEFT JOIN (`category` AS `c`) ON (`c`.`id` = `child`.`cid`)
LEFT JOIN (`lang` AS `l2`) ON (`l2`.`id` = `c`.`name`)
LEFT JOIN (`breed` AS `b`) ON (`b`.`id` = SUBSTRING_INDEX(SUBSTRING_INDEX(`child`.`data`, '"breed":"', -1),'"', 1))
LEFT JOIN (`lang` AS `l`) ON (`l`.`id` = `b`.`name`)
WHERE `child`.`id`=6227SELECT
IF(`l`.`en`='',`l`.`hu`, `l`.`en`) AS `childBreed`,
`child`.`cid` AS `childCid`,
`child`.`uid` AS `childUid`,
`child`.`post_id` AS `childPost`,
`child`.`id` AS `childId`,
`child`.`data` AS `child`,
`child`.`public` AS `childPublic`,
`child`.`notown` AS `childNotown`,
`child`.`offspringsLength` AS `childoffspringsLength`,
`child`.`offspringsLitter` AS `childoffspringsLitter`,
IF(`l2`.`en`='',`l2`.`hu`, `l2`.`en`) AS `breedName`,
`c`.`species` AS `breedSpecies`,
`c`.`categorys` AS `breedCategorys`,
`c`.`icon` AS `breedicon`,
`c`.`latin`,
concat('[',SUBSTRING(`child`.`interested`,1,CHAR_LENGTH(`child`.`interested`) - 1),']') AS `interested`,
`treefather`.`id` AS `treefatherId`,
`treefather`.`uid` AS `treefatherUid`,
`treefather`.`data` AS `treefather`,
`treefather`.`public` AS `treefatherPublic`,
`treefather`.`notown` AS `treefatherNotown`,
`treemother`.`id` AS `treemotherId`,
`treemother`.`uid` AS `treemotherUid`,
`treemother`.`data` AS `treemother`,
`treemother`.`public` AS `treemotherPublic`,
`treemother`.`notown` AS `treemotherNotown`,
`child`.`day_last_edit` AS `meday_last_edit`
FROM `animals` AS `child`
LEFT JOIN (`animals` AS `treefather`) ON (`treefather`.`id`=child.father_id)
LEFT JOIN (`animals` AS `treemother`) ON (`treemother`.`id`=child.mother_id)
LEFT JOIN (`category` AS `c`) ON (`c`.`id` = `child`.`cid`)
LEFT JOIN (`lang` AS `l2`) ON (`l2`.`id` = `c`.`name`)
LEFT JOIN (`breed` AS `b`) ON (`b`.`id` = SUBSTRING_INDEX(SUBSTRING_INDEX(`child`.`data`, '"breed":"', -1),'"', 1))
LEFT JOIN (`lang` AS `l`) ON (`l`.`id` = `b`.`name`)
WHERE `child`.`id`=6261SELECT
IF(`l`.`en`='',`l`.`hu`, `l`.`en`) AS `childBreed`,
`child`.`cid` AS `childCid`,
`child`.`uid` AS `childUid`,
`child`.`post_id` AS `childPost`,
`child`.`id` AS `childId`,
`child`.`data` AS `child`,
`child`.`public` AS `childPublic`,
`child`.`notown` AS `childNotown`,
`child`.`offspringsLength` AS `childoffspringsLength`,
`child`.`offspringsLitter` AS `childoffspringsLitter`,
IF(`l2`.`en`='',`l2`.`hu`, `l2`.`en`) AS `breedName`,
`c`.`species` AS `breedSpecies`,
`c`.`categorys` AS `breedCategorys`,
`c`.`icon` AS `breedicon`,
`c`.`latin`,
concat('[',SUBSTRING(`child`.`interested`,1,CHAR_LENGTH(`child`.`interested`) - 1),']') AS `interested`,
`treefather`.`id` AS `treefatherId`,
`treefather`.`uid` AS `treefatherUid`,
`treefather`.`data` AS `treefather`,
`treefather`.`public` AS `treefatherPublic`,
`treefather`.`notown` AS `treefatherNotown`,
`treemother`.`id` AS `treemotherId`,
`treemother`.`uid` AS `treemotherUid`,
`treemother`.`data` AS `treemother`,
`treemother`.`public` AS `treemotherPublic`,
`treemother`.`notown` AS `treemotherNotown`,
`child`.`day_last_edit` AS `meday_last_edit`
FROM `animals` AS `child`
LEFT JOIN (`animals` AS `treefather`) ON (`treefather`.`id`=child.father_id)
LEFT JOIN (`animals` AS `treemother`) ON (`treemother`.`id`=child.mother_id)
LEFT JOIN (`category` AS `c`) ON (`c`.`id` = `child`.`cid`)
LEFT JOIN (`lang` AS `l2`) ON (`l2`.`id` = `c`.`name`)
LEFT JOIN (`breed` AS `b`) ON (`b`.`id` = SUBSTRING_INDEX(SUBSTRING_INDEX(`child`.`data`, '"breed":"', -1),'"', 1))
LEFT JOIN (`lang` AS `l`) ON (`l`.`id` = `b`.`name`)
WHERE `child`.`id`=6256SELECT
IF(`l`.`en`='',`l`.`hu`, `l`.`en`) AS `childBreed`,
`child`.`cid` AS `childCid`,
`child`.`uid` AS `childUid`,
`child`.`post_id` AS `childPost`,
`child`.`id` AS `childId`,
`child`.`data` AS `child`,
`child`.`public` AS `childPublic`,
`child`.`notown` AS `childNotown`,
`child`.`offspringsLength` AS `childoffspringsLength`,
`child`.`offspringsLitter` AS `childoffspringsLitter`,
IF(`l2`.`en`='',`l2`.`hu`, `l2`.`en`) AS `breedName`,
`c`.`species` AS `breedSpecies`,
`c`.`categorys` AS `breedCategorys`,
`c`.`icon` AS `breedicon`,
`c`.`latin`,
concat('[',SUBSTRING(`child`.`interested`,1,CHAR_LENGTH(`child`.`interested`) - 1),']') AS `interested`,
`treefather`.`id` AS `treefatherId`,
`treefather`.`uid` AS `treefatherUid`,
`treefather`.`data` AS `treefather`,
`treefather`.`public` AS `treefatherPublic`,
`treefather`.`notown` AS `treefatherNotown`,
`treemother`.`id` AS `treemotherId`,
`treemother`.`uid` AS `treemotherUid`,
`treemother`.`data` AS `treemother`,
`treemother`.`public` AS `treemotherPublic`,
`treemother`.`notown` AS `treemotherNotown`,
`child`.`day_last_edit` AS `meday_last_edit`
FROM `animals` AS `child`
LEFT JOIN (`animals` AS `treefather`) ON (`treefather`.`id`=child.father_id)
LEFT JOIN (`animals` AS `treemother`) ON (`treemother`.`id`=child.mother_id)
LEFT JOIN (`category` AS `c`) ON (`c`.`id` = `child`.`cid`)
LEFT JOIN (`lang` AS `l2`) ON (`l2`.`id` = `c`.`name`)
LEFT JOIN (`breed` AS `b`) ON (`b`.`id` = SUBSTRING_INDEX(SUBSTRING_INDEX(`child`.`data`, '"breed":"', -1),'"', 1))
LEFT JOIN (`lang` AS `l`) ON (`l`.`id` = `b`.`name`)
WHERE `child`.`id`=6257SELECT
IF(`l`.`en`='',`l`.`hu`, `l`.`en`) AS `childBreed`,
`child`.`cid` AS `childCid`,
`child`.`uid` AS `childUid`,
`child`.`post_id` AS `childPost`,
`child`.`id` AS `childId`,
`child`.`data` AS `child`,
`child`.`public` AS `childPublic`,
`child`.`notown` AS `childNotown`,
`child`.`offspringsLength` AS `childoffspringsLength`,
`child`.`offspringsLitter` AS `childoffspringsLitter`,
IF(`l2`.`en`='',`l2`.`hu`, `l2`.`en`) AS `breedName`,
`c`.`species` AS `breedSpecies`,
`c`.`categorys` AS `breedCategorys`,
`c`.`icon` AS `breedicon`,
`c`.`latin`,
concat('[',SUBSTRING(`child`.`interested`,1,CHAR_LENGTH(`child`.`interested`) - 1),']') AS `interested`,
`treefather`.`id` AS `treefatherId`,
`treefather`.`uid` AS `treefatherUid`,
`treefather`.`data` AS `treefather`,
`treefather`.`public` AS `treefatherPublic`,
`treefather`.`notown` AS `treefatherNotown`,
`treemother`.`id` AS `treemotherId`,
`treemother`.`uid` AS `treemotherUid`,
`treemother`.`data` AS `treemother`,
`treemother`.`public` AS `treemotherPublic`,
`treemother`.`notown` AS `treemotherNotown`,
`child`.`day_last_edit` AS `meday_last_edit`
FROM `animals` AS `child`
LEFT JOIN (`animals` AS `treefather`) ON (`treefather`.`id`=child.father_id)
LEFT JOIN (`animals` AS `treemother`) ON (`treemother`.`id`=child.mother_id)
LEFT JOIN (`category` AS `c`) ON (`c`.`id` = `child`.`cid`)
LEFT JOIN (`lang` AS `l2`) ON (`l2`.`id` = `c`.`name`)
LEFT JOIN (`breed` AS `b`) ON (`b`.`id` = SUBSTRING_INDEX(SUBSTRING_INDEX(`child`.`data`, '"breed":"', -1),'"', 1))
LEFT JOIN (`lang` AS `l`) ON (`l`.`id` = `b`.`name`)
WHERE `child`.`id`=6228SELECT
IF(`l`.`en`='',`l`.`hu`, `l`.`en`) AS `childBreed`,
`child`.`cid` AS `childCid`,
`child`.`uid` AS `childUid`,
`child`.`post_id` AS `childPost`,
`child`.`id` AS `childId`,
`child`.`data` AS `child`,
`child`.`public` AS `childPublic`,
`child`.`notown` AS `childNotown`,
`child`.`offspringsLength` AS `childoffspringsLength`,
`child`.`offspringsLitter` AS `childoffspringsLitter`,
IF(`l2`.`en`='',`l2`.`hu`, `l2`.`en`) AS `breedName`,
`c`.`species` AS `breedSpecies`,
`c`.`categorys` AS `breedCategorys`,
`c`.`icon` AS `breedicon`,
`c`.`latin`,
concat('[',SUBSTRING(`child`.`interested`,1,CHAR_LENGTH(`child`.`interested`) - 1),']') AS `interested`,
`treefather`.`id` AS `treefatherId`,
`treefather`.`uid` AS `treefatherUid`,
`treefather`.`data` AS `treefather`,
`treefather`.`public` AS `treefatherPublic`,
`treefather`.`notown` AS `treefatherNotown`,
`treemother`.`id` AS `treemotherId`,
`treemother`.`uid` AS `treemotherUid`,
`treemother`.`data` AS `treemother`,
`treemother`.`public` AS `treemotherPublic`,
`treemother`.`notown` AS `treemotherNotown`,
`child`.`day_last_edit` AS `meday_last_edit`
FROM `animals` AS `child`
LEFT JOIN (`animals` AS `treefather`) ON (`treefather`.`id`=child.father_id)
LEFT JOIN (`animals` AS `treemother`) ON (`treemother`.`id`=child.mother_id)
LEFT JOIN (`category` AS `c`) ON (`c`.`id` = `child`.`cid`)
LEFT JOIN (`lang` AS `l2`) ON (`l2`.`id` = `c`.`name`)
LEFT JOIN (`breed` AS `b`) ON (`b`.`id` = SUBSTRING_INDEX(SUBSTRING_INDEX(`child`.`data`, '"breed":"', -1),'"', 1))
LEFT JOIN (`lang` AS `l`) ON (`l`.`id` = `b`.`name`)
WHERE `child`.`id`=6223SELECT
IF(`l`.`en`='',`l`.`hu`, `l`.`en`) AS `childBreed`,
`child`.`cid` AS `childCid`,
`child`.`uid` AS `childUid`,
`child`.`post_id` AS `childPost`,
`child`.`id` AS `childId`,
`child`.`data` AS `child`,
`child`.`public` AS `childPublic`,
`child`.`notown` AS `childNotown`,
`child`.`offspringsLength` AS `childoffspringsLength`,
`child`.`offspringsLitter` AS `childoffspringsLitter`,
IF(`l2`.`en`='',`l2`.`hu`, `l2`.`en`) AS `breedName`,
`c`.`species` AS `breedSpecies`,
`c`.`categorys` AS `breedCategorys`,
`c`.`icon` AS `breedicon`,
`c`.`latin`,
concat('[',SUBSTRING(`child`.`interested`,1,CHAR_LENGTH(`child`.`interested`) - 1),']') AS `interested`,
`treefather`.`id` AS `treefatherId`,
`treefather`.`uid` AS `treefatherUid`,
`treefather`.`data` AS `treefather`,
`treefather`.`public` AS `treefatherPublic`,
`treefather`.`notown` AS `treefatherNotown`,
`treemother`.`id` AS `treemotherId`,
`treemother`.`uid` AS `treemotherUid`,
`treemother`.`data` AS `treemother`,
`treemother`.`public` AS `treemotherPublic`,
`treemother`.`notown` AS `treemotherNotown`,
`child`.`day_last_edit` AS `meday_last_edit`
FROM `animals` AS `child`
LEFT JOIN (`animals` AS `treefather`) ON (`treefather`.`id`=child.father_id)
LEFT JOIN (`animals` AS `treemother`) ON (`treemother`.`id`=child.mother_id)
LEFT JOIN (`category` AS `c`) ON (`c`.`id` = `child`.`cid`)
LEFT JOIN (`lang` AS `l2`) ON (`l2`.`id` = `c`.`name`)
LEFT JOIN (`breed` AS `b`) ON (`b`.`id` = SUBSTRING_INDEX(SUBSTRING_INDEX(`child`.`data`, '"breed":"', -1),'"', 1))
LEFT JOIN (`lang` AS `l`) ON (`l`.`id` = `b`.`name`)
WHERE `child`.`id`=6224SELECT
IF(`l`.`en`='',`l`.`hu`, `l`.`en`) AS `childBreed`,
`child`.`cid` AS `childCid`,
`child`.`uid` AS `childUid`,
`child`.`post_id` AS `childPost`,
`child`.`id` AS `childId`,
`child`.`data` AS `child`,
`child`.`public` AS `childPublic`,
`child`.`notown` AS `childNotown`,
`child`.`offspringsLength` AS `childoffspringsLength`,
`child`.`offspringsLitter` AS `childoffspringsLitter`,
IF(`l2`.`en`='',`l2`.`hu`, `l2`.`en`) AS `breedName`,
`c`.`species` AS `breedSpecies`,
`c`.`categorys` AS `breedCategorys`,
`c`.`icon` AS `breedicon`,
`c`.`latin`,
concat('[',SUBSTRING(`child`.`interested`,1,CHAR_LENGTH(`child`.`interested`) - 1),']') AS `interested`,
`treefather`.`id` AS `treefatherId`,
`treefather`.`uid` AS `treefatherUid`,
`treefather`.`data` AS `treefather`,
`treefather`.`public` AS `treefatherPublic`,
`treefather`.`notown` AS `treefatherNotown`,
`treemother`.`id` AS `treemotherId`,
`treemother`.`uid` AS `treemotherUid`,
`treemother`.`data` AS `treemother`,
`treemother`.`public` AS `treemotherPublic`,
`treemother`.`notown` AS `treemotherNotown`,
`child`.`day_last_edit` AS `meday_last_edit`
FROM `animals` AS `child`
LEFT JOIN (`animals` AS `treefather`) ON (`treefather`.`id`=child.father_id)
LEFT JOIN (`animals` AS `treemother`) ON (`treemother`.`id`=child.mother_id)
LEFT JOIN (`category` AS `c`) ON (`c`.`id` = `child`.`cid`)
LEFT JOIN (`lang` AS `l2`) ON (`l2`.`id` = `c`.`name`)
LEFT JOIN (`breed` AS `b`) ON (`b`.`id` = SUBSTRING_INDEX(SUBSTRING_INDEX(`child`.`data`, '"breed":"', -1),'"', 1))
LEFT JOIN (`lang` AS `l`) ON (`l`.`id` = `b`.`name`)
WHERE `child`.`id`=6220SELECT
IF(`l`.`en`='',`l`.`hu`, `l`.`en`) AS `childBreed`,
`child`.`cid` AS `childCid`,
`child`.`uid` AS `childUid`,
`child`.`post_id` AS `childPost`,
`child`.`id` AS `childId`,
`child`.`data` AS `child`,
`child`.`public` AS `childPublic`,
`child`.`notown` AS `childNotown`,
`child`.`offspringsLength` AS `childoffspringsLength`,
`child`.`offspringsLitter` AS `childoffspringsLitter`,
IF(`l2`.`en`='',`l2`.`hu`, `l2`.`en`) AS `breedName`,
`c`.`species` AS `breedSpecies`,
`c`.`categorys` AS `breedCategorys`,
`c`.`icon` AS `breedicon`,
`c`.`latin`,
concat('[',SUBSTRING(`child`.`interested`,1,CHAR_LENGTH(`child`.`interested`) - 1),']') AS `interested`,
`treefather`.`id` AS `treefatherId`,
`treefather`.`uid` AS `treefatherUid`,
`treefather`.`data` AS `treefather`,
`treefather`.`public` AS `treefatherPublic`,
`treefather`.`notown` AS `treefatherNotown`,
`treemother`.`id` AS `treemotherId`,
`treemother`.`uid` AS `treemotherUid`,
`treemother`.`data` AS `treemother`,
`treemother`.`public` AS `treemotherPublic`,
`treemother`.`notown` AS `treemotherNotown`,
`child`.`day_last_edit` AS `meday_last_edit`
FROM `animals` AS `child`
LEFT JOIN (`animals` AS `treefather`) ON (`treefather`.`id`=child.father_id)
LEFT JOIN (`animals` AS `treemother`) ON (`treemother`.`id`=child.mother_id)
LEFT JOIN (`category` AS `c`) ON (`c`.`id` = `child`.`cid`)
LEFT JOIN (`lang` AS `l2`) ON (`l2`.`id` = `c`.`name`)
LEFT JOIN (`breed` AS `b`) ON (`b`.`id` = SUBSTRING_INDEX(SUBSTRING_INDEX(`child`.`data`, '"breed":"', -1),'"', 1))
LEFT JOIN (`lang` AS `l`) ON (`l`.`id` = `b`.`name`)
WHERE `child`.`id`=6221SELECT
IF(`l`.`en`='',`l`.`hu`, `l`.`en`) AS `childBreed`,
`child`.`cid` AS `childCid`,
`child`.`uid` AS `childUid`,
`child`.`post_id` AS `childPost`,
`child`.`id` AS `childId`,
`child`.`data` AS `child`,
`child`.`public` AS `childPublic`,
`child`.`notown` AS `childNotown`,
`child`.`offspringsLength` AS `childoffspringsLength`,
`child`.`offspringsLitter` AS `childoffspringsLitter`,
IF(`l2`.`en`='',`l2`.`hu`, `l2`.`en`) AS `breedName`,
`c`.`species` AS `breedSpecies`,
`c`.`categorys` AS `breedCategorys`,
`c`.`icon` AS `breedicon`,
`c`.`latin`,
concat('[',SUBSTRING(`child`.`interested`,1,CHAR_LENGTH(`child`.`interested`) - 1),']') AS `interested`,
`treefather`.`id` AS `treefatherId`,
`treefather`.`uid` AS `treefatherUid`,
`treefather`.`data` AS `treefather`,
`treefather`.`public` AS `treefatherPublic`,
`treefather`.`notown` AS `treefatherNotown`,
`treemother`.`id` AS `treemotherId`,
`treemother`.`uid` AS `treemotherUid`,
`treemother`.`data` AS `treemother`,
`treemother`.`public` AS `treemotherPublic`,
`treemother`.`notown` AS `treemotherNotown`,
`child`.`day_last_edit` AS `meday_last_edit`
FROM `animals` AS `child`
LEFT JOIN (`animals` AS `treefather`) ON (`treefather`.`id`=child.father_id)
LEFT JOIN (`animals` AS `treemother`) ON (`treemother`.`id`=child.mother_id)
LEFT JOIN (`category` AS `c`) ON (`c`.`id` = `child`.`cid`)
LEFT JOIN (`lang` AS `l2`) ON (`l2`.`id` = `c`.`name`)
LEFT JOIN (`breed` AS `b`) ON (`b`.`id` = SUBSTRING_INDEX(SUBSTRING_INDEX(`child`.`data`, '"breed":"', -1),'"', 1))
LEFT JOIN (`lang` AS `l`) ON (`l`.`id` = `b`.`name`)
WHERE `child`.`id`=6232SELECT
IF(`l`.`en`='',`l`.`hu`, `l`.`en`) AS `childBreed`,
`child`.`cid` AS `childCid`,
`child`.`uid` AS `childUid`,
`child`.`post_id` AS `childPost`,
`child`.`id` AS `childId`,
`child`.`data` AS `child`,
`child`.`public` AS `childPublic`,
`child`.`notown` AS `childNotown`,
`child`.`offspringsLength` AS `childoffspringsLength`,
`child`.`offspringsLitter` AS `childoffspringsLitter`,
IF(`l2`.`en`='',`l2`.`hu`, `l2`.`en`) AS `breedName`,
`c`.`species` AS `breedSpecies`,
`c`.`categorys` AS `breedCategorys`,
`c`.`icon` AS `breedicon`,
`c`.`latin`,
concat('[',SUBSTRING(`child`.`interested`,1,CHAR_LENGTH(`child`.`interested`) - 1),']') AS `interested`,
`treefather`.`id` AS `treefatherId`,
`treefather`.`uid` AS `treefatherUid`,
`treefather`.`data` AS `treefather`,
`treefather`.`public` AS `treefatherPublic`,
`treefather`.`notown` AS `treefatherNotown`,
`treemother`.`id` AS `treemotherId`,
`treemother`.`uid` AS `treemotherUid`,
`treemother`.`data` AS `treemother`,
`treemother`.`public` AS `treemotherPublic`,
`treemother`.`notown` AS `treemotherNotown`,
`child`.`day_last_edit` AS `meday_last_edit`
FROM `animals` AS `child`
LEFT JOIN (`animals` AS `treefather`) ON (`treefather`.`id`=child.father_id)
LEFT JOIN (`animals` AS `treemother`) ON (`treemother`.`id`=child.mother_id)
LEFT JOIN (`category` AS `c`) ON (`c`.`id` = `child`.`cid`)
LEFT JOIN (`lang` AS `l2`) ON (`l2`.`id` = `c`.`name`)
LEFT JOIN (`breed` AS `b`) ON (`b`.`id` = SUBSTRING_INDEX(SUBSTRING_INDEX(`child`.`data`, '"breed":"', -1),'"', 1))
LEFT JOIN (`lang` AS `l`) ON (`l`.`id` = `b`.`name`)
WHERE `child`.`id`=10048SELECT
IF(`l`.`en`='',`l`.`hu`, `l`.`en`) AS `childBreed`,
`child`.`cid` AS `childCid`,
`child`.`uid` AS `childUid`,
`child`.`post_id` AS `childPost`,
`child`.`id` AS `childId`,
`child`.`data` AS `child`,
`child`.`public` AS `childPublic`,
`child`.`notown` AS `childNotown`,
`child`.`offspringsLength` AS `childoffspringsLength`,
`child`.`offspringsLitter` AS `childoffspringsLitter`,
IF(`l2`.`en`='',`l2`.`hu`, `l2`.`en`) AS `breedName`,
`c`.`species` AS `breedSpecies`,
`c`.`categorys` AS `breedCategorys`,
`c`.`icon` AS `breedicon`,
`c`.`latin`,
concat('[',SUBSTRING(`child`.`interested`,1,CHAR_LENGTH(`child`.`interested`) - 1),']') AS `interested`,
`treefather`.`id` AS `treefatherId`,
`treefather`.`uid` AS `treefatherUid`,
`treefather`.`data` AS `treefather`,
`treefather`.`public` AS `treefatherPublic`,
`treefather`.`notown` AS `treefatherNotown`,
`treemother`.`id` AS `treemotherId`,
`treemother`.`uid` AS `treemotherUid`,
`treemother`.`data` AS `treemother`,
`treemother`.`public` AS `treemotherPublic`,
`treemother`.`notown` AS `treemotherNotown`,
`child`.`day_last_edit` AS `meday_last_edit`
FROM `animals` AS `child`
LEFT JOIN (`animals` AS `treefather`) ON (`treefather`.`id`=child.father_id)
LEFT JOIN (`animals` AS `treemother`) ON (`treemother`.`id`=child.mother_id)
LEFT JOIN (`category` AS `c`) ON (`c`.`id` = `child`.`cid`)
LEFT JOIN (`lang` AS `l2`) ON (`l2`.`id` = `c`.`name`)
LEFT JOIN (`breed` AS `b`) ON (`b`.`id` = SUBSTRING_INDEX(SUBSTRING_INDEX(`child`.`data`, '"breed":"', -1),'"', 1))
LEFT JOIN (`lang` AS `l`) ON (`l`.`id` = `b`.`name`)
WHERE `child`.`id`=6348SELECT
IF(`l`.`en`='',`l`.`hu`, `l`.`en`) AS `childBreed`,
`child`.`cid` AS `childCid`,
`child`.`uid` AS `childUid`,
`child`.`post_id` AS `childPost`,
`child`.`id` AS `childId`,
`child`.`data` AS `child`,
`child`.`public` AS `childPublic`,
`child`.`notown` AS `childNotown`,
`child`.`offspringsLength` AS `childoffspringsLength`,
`child`.`offspringsLitter` AS `childoffspringsLitter`,
IF(`l2`.`en`='',`l2`.`hu`, `l2`.`en`) AS `breedName`,
`c`.`species` AS `breedSpecies`,
`c`.`categorys` AS `breedCategorys`,
`c`.`icon` AS `breedicon`,
`c`.`latin`,
concat('[',SUBSTRING(`child`.`interested`,1,CHAR_LENGTH(`child`.`interested`) - 1),']') AS `interested`,
`treefather`.`id` AS `treefatherId`,
`treefather`.`uid` AS `treefatherUid`,
`treefather`.`data` AS `treefather`,
`treefather`.`public` AS `treefatherPublic`,
`treefather`.`notown` AS `treefatherNotown`,
`treemother`.`id` AS `treemotherId`,
`treemother`.`uid` AS `treemotherUid`,
`treemother`.`data` AS `treemother`,
`treemother`.`public` AS `treemotherPublic`,
`treemother`.`notown` AS `treemotherNotown`,
`child`.`day_last_edit` AS `meday_last_edit`
FROM `animals` AS `child`
LEFT JOIN (`animals` AS `treefather`) ON (`treefather`.`id`=child.father_id)
LEFT JOIN (`animals` AS `treemother`) ON (`treemother`.`id`=child.mother_id)
LEFT JOIN (`category` AS `c`) ON (`c`.`id` = `child`.`cid`)
LEFT JOIN (`lang` AS `l2`) ON (`l2`.`id` = `c`.`name`)
LEFT JOIN (`breed` AS `b`) ON (`b`.`id` = SUBSTRING_INDEX(SUBSTRING_INDEX(`child`.`data`, '"breed":"', -1),'"', 1))
LEFT JOIN (`lang` AS `l`) ON (`l`.`id` = `b`.`name`)
WHERE `child`.`id`=6501SELECT
IF(`l`.`en`='',`l`.`hu`, `l`.`en`) AS `childBreed`,
`child`.`cid` AS `childCid`,
`child`.`uid` AS `childUid`,
`child`.`post_id` AS `childPost`,
`child`.`id` AS `childId`,
`child`.`data` AS `child`,
`child`.`public` AS `childPublic`,
`child`.`notown` AS `childNotown`,
`child`.`offspringsLength` AS `childoffspringsLength`,
`child`.`offspringsLitter` AS `childoffspringsLitter`,
IF(`l2`.`en`='',`l2`.`hu`, `l2`.`en`) AS `breedName`,
`c`.`species` AS `breedSpecies`,
`c`.`categorys` AS `breedCategorys`,
`c`.`icon` AS `breedicon`,
`c`.`latin`,
concat('[',SUBSTRING(`child`.`interested`,1,CHAR_LENGTH(`child`.`interested`) - 1),']') AS `interested`,
`treefather`.`id` AS `treefatherId`,
`treefather`.`uid` AS `treefatherUid`,
`treefather`.`data` AS `treefather`,
`treefather`.`public` AS `treefatherPublic`,
`treefather`.`notown` AS `treefatherNotown`,
`treemother`.`id` AS `treemotherId`,
`treemother`.`uid` AS `treemotherUid`,
`treemother`.`data` AS `treemother`,
`treemother`.`public` AS `treemotherPublic`,
`treemother`.`notown` AS `treemotherNotown`,
`child`.`day_last_edit` AS `meday_last_edit`
FROM `animals` AS `child`
LEFT JOIN (`animals` AS `treefather`) ON (`treefather`.`id`=child.father_id)
LEFT JOIN (`animals` AS `treemother`) ON (`treemother`.`id`=child.mother_id)
LEFT JOIN (`category` AS `c`) ON (`c`.`id` = `child`.`cid`)
LEFT JOIN (`lang` AS `l2`) ON (`l2`.`id` = `c`.`name`)
LEFT JOIN (`breed` AS `b`) ON (`b`.`id` = SUBSTRING_INDEX(SUBSTRING_INDEX(`child`.`data`, '"breed":"', -1),'"', 1))
LEFT JOIN (`lang` AS `l`) ON (`l`.`id` = `b`.`name`)
WHERE `child`.`id`=6434SELECT
IF(`l`.`en`='',`l`.`hu`, `l`.`en`) AS `childBreed`,
`child`.`cid` AS `childCid`,
`child`.`uid` AS `childUid`,
`child`.`post_id` AS `childPost`,
`child`.`id` AS `childId`,
`child`.`data` AS `child`,
`child`.`public` AS `childPublic`,
`child`.`notown` AS `childNotown`,
`child`.`offspringsLength` AS `childoffspringsLength`,
`child`.`offspringsLitter` AS `childoffspringsLitter`,
IF(`l2`.`en`='',`l2`.`hu`, `l2`.`en`) AS `breedName`,
`c`.`species` AS `breedSpecies`,
`c`.`categorys` AS `breedCategorys`,
`c`.`icon` AS `breedicon`,
`c`.`latin`,
concat('[',SUBSTRING(`child`.`interested`,1,CHAR_LENGTH(`child`.`interested`) - 1),']') AS `interested`,
`treefather`.`id` AS `treefatherId`,
`treefather`.`uid` AS `treefatherUid`,
`treefather`.`data` AS `treefather`,
`treefather`.`public` AS `treefatherPublic`,
`treefather`.`notown` AS `treefatherNotown`,
`treemother`.`id` AS `treemotherId`,
`treemother`.`uid` AS `treemotherUid`,
`treemother`.`data` AS `treemother`,
`treemother`.`public` AS `treemotherPublic`,
`treemother`.`notown` AS `treemotherNotown`,
`child`.`day_last_edit` AS `meday_last_edit`
FROM `animals` AS `child`
LEFT JOIN (`animals` AS `treefather`) ON (`treefather`.`id`=child.father_id)
LEFT JOIN (`animals` AS `treemother`) ON (`treemother`.`id`=child.mother_id)
LEFT JOIN (`category` AS `c`) ON (`c`.`id` = `child`.`cid`)
LEFT JOIN (`lang` AS `l2`) ON (`l2`.`id` = `c`.`name`)
LEFT JOIN (`breed` AS `b`) ON (`b`.`id` = SUBSTRING_INDEX(SUBSTRING_INDEX(`child`.`data`, '"breed":"', -1),'"', 1))
LEFT JOIN (`lang` AS `l`) ON (`l`.`id` = `b`.`name`)
WHERE `child`.`id`=6427SELECT
IF(`l`.`en`='',`l`.`hu`, `l`.`en`) AS `childBreed`,
`child`.`cid` AS `childCid`,
`child`.`uid` AS `childUid`,
`child`.`post_id` AS `childPost`,
`child`.`id` AS `childId`,
`child`.`data` AS `child`,
`child`.`public` AS `childPublic`,
`child`.`notown` AS `childNotown`,
`child`.`offspringsLength` AS `childoffspringsLength`,
`child`.`offspringsLitter` AS `childoffspringsLitter`,
IF(`l2`.`en`='',`l2`.`hu`, `l2`.`en`) AS `breedName`,
`c`.`species` AS `breedSpecies`,
`c`.`categorys` AS `breedCategorys`,
`c`.`icon` AS `breedicon`,
`c`.`latin`,
concat('[',SUBSTRING(`child`.`interested`,1,CHAR_LENGTH(`child`.`interested`) - 1),']') AS `interested`,
`treefather`.`id` AS `treefatherId`,
`treefather`.`uid` AS `treefatherUid`,
`treefather`.`data` AS `treefather`,
`treefather`.`public` AS `treefatherPublic`,
`treefather`.`notown` AS `treefatherNotown`,
`treemother`.`id` AS `treemotherId`,
`treemother`.`uid` AS `treemotherUid`,
`treemother`.`data` AS `treemother`,
`treemother`.`public` AS `treemotherPublic`,
`treemother`.`notown` AS `treemotherNotown`,
`child`.`day_last_edit` AS `meday_last_edit`
FROM `animals` AS `child`
LEFT JOIN (`animals` AS `treefather`) ON (`treefather`.`id`=child.father_id)
LEFT JOIN (`animals` AS `treemother`) ON (`treemother`.`id`=child.mother_id)
LEFT JOIN (`category` AS `c`) ON (`c`.`id` = `child`.`cid`)
LEFT JOIN (`lang` AS `l2`) ON (`l2`.`id` = `c`.`name`)
LEFT JOIN (`breed` AS `b`) ON (`b`.`id` = SUBSTRING_INDEX(SUBSTRING_INDEX(`child`.`data`, '"breed":"', -1),'"', 1))
LEFT JOIN (`lang` AS `l`) ON (`l`.`id` = `b`.`name`)
WHERE `child`.`id`=6431SELECT
IF(`l`.`en`='',`l`.`hu`, `l`.`en`) AS `childBreed`,
`child`.`cid` AS `childCid`,
`child`.`uid` AS `childUid`,
`child`.`post_id` AS `childPost`,
`child`.`id` AS `childId`,
`child`.`data` AS `child`,
`child`.`public` AS `childPublic`,
`child`.`notown` AS `childNotown`,
`child`.`offspringsLength` AS `childoffspringsLength`,
`child`.`offspringsLitter` AS `childoffspringsLitter`,
IF(`l2`.`en`='',`l2`.`hu`, `l2`.`en`) AS `breedName`,
`c`.`species` AS `breedSpecies`,
`c`.`categorys` AS `breedCategorys`,
`c`.`icon` AS `breedicon`,
`c`.`latin`,
concat('[',SUBSTRING(`child`.`interested`,1,CHAR_LENGTH(`child`.`interested`) - 1),']') AS `interested`,
`treefather`.`id` AS `treefatherId`,
`treefather`.`uid` AS `treefatherUid`,
`treefather`.`data` AS `treefather`,
`treefather`.`public` AS `treefatherPublic`,
`treefather`.`notown` AS `treefatherNotown`,
`treemother`.`id` AS `treemotherId`,
`treemother`.`uid` AS `treemotherUid`,
`treemother`.`data` AS `treemother`,
`treemother`.`public` AS `treemotherPublic`,
`treemother`.`notown` AS `treemotherNotown`,
`child`.`day_last_edit` AS `meday_last_edit`
FROM `animals` AS `child`
LEFT JOIN (`animals` AS `treefather`) ON (`treefather`.`id`=child.father_id)
LEFT JOIN (`animals` AS `treemother`) ON (`treemother`.`id`=child.mother_id)
LEFT JOIN (`category` AS `c`) ON (`c`.`id` = `child`.`cid`)
LEFT JOIN (`lang` AS `l2`) ON (`l2`.`id` = `c`.`name`)
LEFT JOIN (`breed` AS `b`) ON (`b`.`id` = SUBSTRING_INDEX(SUBSTRING_INDEX(`child`.`data`, '"breed":"', -1),'"', 1))
LEFT JOIN (`lang` AS `l`) ON (`l`.`id` = `b`.`name`)
WHERE `child`.`id`=6354SELECT
IF(`l`.`en`='',`l`.`hu`, `l`.`en`) AS `childBreed`,
`child`.`cid` AS `childCid`,
`child`.`uid` AS `childUid`,
`child`.`post_id` AS `childPost`,
`child`.`id` AS `childId`,
`child`.`data` AS `child`,
`child`.`public` AS `childPublic`,
`child`.`notown` AS `childNotown`,
`child`.`offspringsLength` AS `childoffspringsLength`,
`child`.`offspringsLitter` AS `childoffspringsLitter`,
IF(`l2`.`en`='',`l2`.`hu`, `l2`.`en`) AS `breedName`,
`c`.`species` AS `breedSpecies`,
`c`.`categorys` AS `breedCategorys`,
`c`.`icon` AS `breedicon`,
`c`.`latin`,
concat('[',SUBSTRING(`child`.`interested`,1,CHAR_LENGTH(`child`.`interested`) - 1),']') AS `interested`,
`treefather`.`id` AS `treefatherId`,
`treefather`.`uid` AS `treefatherUid`,
`treefather`.`data` AS `treefather`,
`treefather`.`public` AS `treefatherPublic`,
`treefather`.`notown` AS `treefatherNotown`,
`treemother`.`id` AS `treemotherId`,
`treemother`.`uid` AS `treemotherUid`,
`treemother`.`data` AS `treemother`,
`treemother`.`public` AS `treemotherPublic`,
`treemother`.`notown` AS `treemotherNotown`,
`child`.`day_last_edit` AS `meday_last_edit`
FROM `animals` AS `child`
LEFT JOIN (`animals` AS `treefather`) ON (`treefather`.`id`=child.father_id)
LEFT JOIN (`animals` AS `treemother`) ON (`treemother`.`id`=child.mother_id)
LEFT JOIN (`category` AS `c`) ON (`c`.`id` = `child`.`cid`)
LEFT JOIN (`lang` AS `l2`) ON (`l2`.`id` = `c`.`name`)
LEFT JOIN (`breed` AS `b`) ON (`b`.`id` = SUBSTRING_INDEX(SUBSTRING_INDEX(`child`.`data`, '"breed":"', -1),'"', 1))
LEFT JOIN (`lang` AS `l`) ON (`l`.`id` = `b`.`name`)
WHERE `child`.`id`=6355SELECT
IF(`l`.`en`='',`l`.`hu`, `l`.`en`) AS `childBreed`,
`child`.`cid` AS `childCid`,
`child`.`uid` AS `childUid`,
`child`.`post_id` AS `childPost`,
`child`.`id` AS `childId`,
`child`.`data` AS `child`,
`child`.`public` AS `childPublic`,
`child`.`notown` AS `childNotown`,
`child`.`offspringsLength` AS `childoffspringsLength`,
`child`.`offspringsLitter` AS `childoffspringsLitter`,
IF(`l2`.`en`='',`l2`.`hu`, `l2`.`en`) AS `breedName`,
`c`.`species` AS `breedSpecies`,
`c`.`categorys` AS `breedCategorys`,
`c`.`icon` AS `breedicon`,
`c`.`latin`,
concat('[',SUBSTRING(`child`.`interested`,1,CHAR_LENGTH(`child`.`interested`) - 1),']') AS `interested`,
`treefather`.`id` AS `treefatherId`,
`treefather`.`uid` AS `treefatherUid`,
`treefather`.`data` AS `treefather`,
`treefather`.`public` AS `treefatherPublic`,
`treefather`.`notown` AS `treefatherNotown`,
`treemother`.`id` AS `treemotherId`,
`treemother`.`uid` AS `treemotherUid`,
`treemother`.`data` AS `treemother`,
`treemother`.`public` AS `treemotherPublic`,
`treemother`.`notown` AS `treemotherNotown`,
`child`.`day_last_edit` AS `meday_last_edit`
FROM `animals` AS `child`
LEFT JOIN (`animals` AS `treefather`) ON (`treefather`.`id`=child.father_id)
LEFT JOIN (`animals` AS `treemother`) ON (`treemother`.`id`=child.mother_id)
LEFT JOIN (`category` AS `c`) ON (`c`.`id` = `child`.`cid`)
LEFT JOIN (`lang` AS `l2`) ON (`l2`.`id` = `c`.`name`)
LEFT JOIN (`breed` AS `b`) ON (`b`.`id` = SUBSTRING_INDEX(SUBSTRING_INDEX(`child`.`data`, '"breed":"', -1),'"', 1))
LEFT JOIN (`lang` AS `l`) ON (`l`.`id` = `b`.`name`)
WHERE `child`.`id`=6429SELECT
IF(`l`.`en`='',`l`.`hu`, `l`.`en`) AS `childBreed`,
`child`.`cid` AS `childCid`,
`child`.`uid` AS `childUid`,
`child`.`post_id` AS `childPost`,
`child`.`id` AS `childId`,
`child`.`data` AS `child`,
`child`.`public` AS `childPublic`,
`child`.`notown` AS `childNotown`,
`child`.`offspringsLength` AS `childoffspringsLength`,
`child`.`offspringsLitter` AS `childoffspringsLitter`,
IF(`l2`.`en`='',`l2`.`hu`, `l2`.`en`) AS `breedName`,
`c`.`species` AS `breedSpecies`,
`c`.`categorys` AS `breedCategorys`,
`c`.`icon` AS `breedicon`,
`c`.`latin`,
concat('[',SUBSTRING(`child`.`interested`,1,CHAR_LENGTH(`child`.`interested`) - 1),']') AS `interested`,
`treefather`.`id` AS `treefatherId`,
`treefather`.`uid` AS `treefatherUid`,
`treefather`.`data` AS `treefather`,
`treefather`.`public` AS `treefatherPublic`,
`treefather`.`notown` AS `treefatherNotown`,
`treemother`.`id` AS `treemotherId`,
`treemother`.`uid` AS `treemotherUid`,
`treemother`.`data` AS `treemother`,
`treemother`.`public` AS `treemotherPublic`,
`treemother`.`notown` AS `treemotherNotown`,
`child`.`day_last_edit` AS `meday_last_edit`
FROM `animals` AS `child`
LEFT JOIN (`animals` AS `treefather`) ON (`treefather`.`id`=child.father_id)
LEFT JOIN (`animals` AS `treemother`) ON (`treemother`.`id`=child.mother_id)
LEFT JOIN (`category` AS `c`) ON (`c`.`id` = `child`.`cid`)
LEFT JOIN (`lang` AS `l2`) ON (`l2`.`id` = `c`.`name`)
LEFT JOIN (`breed` AS `b`) ON (`b`.`id` = SUBSTRING_INDEX(SUBSTRING_INDEX(`child`.`data`, '"breed":"', -1),'"', 1))
LEFT JOIN (`lang` AS `l`) ON (`l`.`id` = `b`.`name`)
WHERE `child`.`id`=6360SELECT
IF(`l`.`en`='',`l`.`hu`, `l`.`en`) AS `childBreed`,
`child`.`cid` AS `childCid`,
`child`.`uid` AS `childUid`,
`child`.`post_id` AS `childPost`,
`child`.`id` AS `childId`,
`child`.`data` AS `child`,
`child`.`public` AS `childPublic`,
`child`.`notown` AS `childNotown`,
`child`.`offspringsLength` AS `childoffspringsLength`,
`child`.`offspringsLitter` AS `childoffspringsLitter`,
IF(`l2`.`en`='',`l2`.`hu`, `l2`.`en`) AS `breedName`,
`c`.`species` AS `breedSpecies`,
`c`.`categorys` AS `breedCategorys`,
`c`.`icon` AS `breedicon`,
`c`.`latin`,
concat('[',SUBSTRING(`child`.`interested`,1,CHAR_LENGTH(`child`.`interested`) - 1),']') AS `interested`,
`treefather`.`id` AS `treefatherId`,
`treefather`.`uid` AS `treefatherUid`,
`treefather`.`data` AS `treefather`,
`treefather`.`public` AS `treefatherPublic`,
`treefather`.`notown` AS `treefatherNotown`,
`treemother`.`id` AS `treemotherId`,
`treemother`.`uid` AS `treemotherUid`,
`treemother`.`data` AS `treemother`,
`treemother`.`public` AS `treemotherPublic`,
`treemother`.`notown` AS `treemotherNotown`,
`child`.`day_last_edit` AS `meday_last_edit`
FROM `animals` AS `child`
LEFT JOIN (`animals` AS `treefather`) ON (`treefather`.`id`=child.father_id)
LEFT JOIN (`animals` AS `treemother`) ON (`treemother`.`id`=child.mother_id)
LEFT JOIN (`category` AS `c`) ON (`c`.`id` = `child`.`cid`)
LEFT JOIN (`lang` AS `l2`) ON (`l2`.`id` = `c`.`name`)
LEFT JOIN (`breed` AS `b`) ON (`b`.`id` = SUBSTRING_INDEX(SUBSTRING_INDEX(`child`.`data`, '"breed":"', -1),'"', 1))
LEFT JOIN (`lang` AS `l`) ON (`l`.`id` = `b`.`name`)
WHERE `child`.`id`=6410SELECT
IF(`l`.`en`='',`l`.`hu`, `l`.`en`) AS `childBreed`,
`child`.`cid` AS `childCid`,
`child`.`uid` AS `childUid`,
`child`.`post_id` AS `childPost`,
`child`.`id` AS `childId`,
`child`.`data` AS `child`,
`child`.`public` AS `childPublic`,
`child`.`notown` AS `childNotown`,
`child`.`offspringsLength` AS `childoffspringsLength`,
`child`.`offspringsLitter` AS `childoffspringsLitter`,
IF(`l2`.`en`='',`l2`.`hu`, `l2`.`en`) AS `breedName`,
`c`.`species` AS `breedSpecies`,
`c`.`categorys` AS `breedCategorys`,
`c`.`icon` AS `breedicon`,
`c`.`latin`,
concat('[',SUBSTRING(`child`.`interested`,1,CHAR_LENGTH(`child`.`interested`) - 1),']') AS `interested`,
`treefather`.`id` AS `treefatherId`,
`treefather`.`uid` AS `treefatherUid`,
`treefather`.`data` AS `treefather`,
`treefather`.`public` AS `treefatherPublic`,
`treefather`.`notown` AS `treefatherNotown`,
`treemother`.`id` AS `treemotherId`,
`treemother`.`uid` AS `treemotherUid`,
`treemother`.`data` AS `treemother`,
`treemother`.`public` AS `treemotherPublic`,
`treemother`.`notown` AS `treemotherNotown`,
`child`.`day_last_edit` AS `meday_last_edit`
FROM `animals` AS `child`
LEFT JOIN (`animals` AS `treefather`) ON (`treefather`.`id`=child.father_id)
LEFT JOIN (`animals` AS `treemother`) ON (`treemother`.`id`=child.mother_id)
LEFT JOIN (`category` AS `c`) ON (`c`.`id` = `child`.`cid`)
LEFT JOIN (`lang` AS `l2`) ON (`l2`.`id` = `c`.`name`)
LEFT JOIN (`breed` AS `b`) ON (`b`.`id` = SUBSTRING_INDEX(SUBSTRING_INDEX(`child`.`data`, '"breed":"', -1),'"', 1))
LEFT JOIN (`lang` AS `l`) ON (`l`.`id` = `b`.`name`)
WHERE `child`.`id`=6399SELECT
IF(`l`.`en`='',`l`.`hu`, `l`.`en`) AS `childBreed`,
`child`.`cid` AS `childCid`,
`child`.`uid` AS `childUid`,
`child`.`post_id` AS `childPost`,
`child`.`id` AS `childId`,
`child`.`data` AS `child`,
`child`.`public` AS `childPublic`,
`child`.`notown` AS `childNotown`,
`child`.`offspringsLength` AS `childoffspringsLength`,
`child`.`offspringsLitter` AS `childoffspringsLitter`,
IF(`l2`.`en`='',`l2`.`hu`, `l2`.`en`) AS `breedName`,
`c`.`species` AS `breedSpecies`,
`c`.`categorys` AS `breedCategorys`,
`c`.`icon` AS `breedicon`,
`c`.`latin`,
concat('[',SUBSTRING(`child`.`interested`,1,CHAR_LENGTH(`child`.`interested`) - 1),']') AS `interested`,
`treefather`.`id` AS `treefatherId`,
`treefather`.`uid` AS `treefatherUid`,
`treefather`.`data` AS `treefather`,
`treefather`.`public` AS `treefatherPublic`,
`treefather`.`notown` AS `treefatherNotown`,
`treemother`.`id` AS `treemotherId`,
`treemother`.`uid` AS `treemotherUid`,
`treemother`.`data` AS `treemother`,
`treemother`.`public` AS `treemotherPublic`,
`treemother`.`notown` AS `treemotherNotown`,
`child`.`day_last_edit` AS `meday_last_edit`
FROM `animals` AS `child`
LEFT JOIN (`animals` AS `treefather`) ON (`treefather`.`id`=child.father_id)
LEFT JOIN (`animals` AS `treemother`) ON (`treemother`.`id`=child.mother_id)
LEFT JOIN (`category` AS `c`) ON (`c`.`id` = `child`.`cid`)
LEFT JOIN (`lang` AS `l2`) ON (`l2`.`id` = `c`.`name`)
LEFT JOIN (`breed` AS `b`) ON (`b`.`id` = SUBSTRING_INDEX(SUBSTRING_INDEX(`child`.`data`, '"breed":"', -1),'"', 1))
LEFT JOIN (`lang` AS `l`) ON (`l`.`id` = `b`.`name`)
WHERE `child`.`id`=6242SELECT
IF(`l`.`en`='',`l`.`hu`, `l`.`en`) AS `childBreed`,
`child`.`cid` AS `childCid`,
`child`.`uid` AS `childUid`,
`child`.`post_id` AS `childPost`,
`child`.`id` AS `childId`,
`child`.`data` AS `child`,
`child`.`public` AS `childPublic`,
`child`.`notown` AS `childNotown`,
`child`.`offspringsLength` AS `childoffspringsLength`,
`child`.`offspringsLitter` AS `childoffspringsLitter`,
IF(`l2`.`en`='',`l2`.`hu`, `l2`.`en`) AS `breedName`,
`c`.`species` AS `breedSpecies`,
`c`.`categorys` AS `breedCategorys`,
`c`.`icon` AS `breedicon`,
`c`.`latin`,
concat('[',SUBSTRING(`child`.`interested`,1,CHAR_LENGTH(`child`.`interested`) - 1),']') AS `interested`,
`treefather`.`id` AS `treefatherId`,
`treefather`.`uid` AS `treefatherUid`,
`treefather`.`data` AS `treefather`,
`treefather`.`public` AS `treefatherPublic`,
`treefather`.`notown` AS `treefatherNotown`,
`treemother`.`id` AS `treemotherId`,
`treemother`.`uid` AS `treemotherUid`,
`treemother`.`data` AS `treemother`,
`treemother`.`public` AS `treemotherPublic`,
`treemother`.`notown` AS `treemotherNotown`,
`child`.`day_last_edit` AS `meday_last_edit`
FROM `animals` AS `child`
LEFT JOIN (`animals` AS `treefather`) ON (`treefather`.`id`=child.father_id)
LEFT JOIN (`animals` AS `treemother`) ON (`treemother`.`id`=child.mother_id)
LEFT JOIN (`category` AS `c`) ON (`c`.`id` = `child`.`cid`)
LEFT JOIN (`lang` AS `l2`) ON (`l2`.`id` = `c`.`name`)
LEFT JOIN (`breed` AS `b`) ON (`b`.`id` = SUBSTRING_INDEX(SUBSTRING_INDEX(`child`.`data`, '"breed":"', -1),'"', 1))
LEFT JOIN (`lang` AS `l`) ON (`l`.`id` = `b`.`name`)
WHERE `child`.`id`=6390SELECT
IF(`l`.`en`='',`l`.`hu`, `l`.`en`) AS `childBreed`,
`child`.`cid` AS `childCid`,
`child`.`uid` AS `childUid`,
`child`.`post_id` AS `childPost`,
`child`.`id` AS `childId`,
`child`.`data` AS `child`,
`child`.`public` AS `childPublic`,
`child`.`notown` AS `childNotown`,
`child`.`offspringsLength` AS `childoffspringsLength`,
`child`.`offspringsLitter` AS `childoffspringsLitter`,
IF(`l2`.`en`='',`l2`.`hu`, `l2`.`en`) AS `breedName`,
`c`.`species` AS `breedSpecies`,
`c`.`categorys` AS `breedCategorys`,
`c`.`icon` AS `breedicon`,
`c`.`latin`,
concat('[',SUBSTRING(`child`.`interested`,1,CHAR_LENGTH(`child`.`interested`) - 1),']') AS `interested`,
`treefather`.`id` AS `treefatherId`,
`treefather`.`uid` AS `treefatherUid`,
`treefather`.`data` AS `treefather`,
`treefather`.`public` AS `treefatherPublic`,
`treefather`.`notown` AS `treefatherNotown`,
`treemother`.`id` AS `treemotherId`,
`treemother`.`uid` AS `treemotherUid`,
`treemother`.`data` AS `treemother`,
`treemother`.`public` AS `treemotherPublic`,
`treemother`.`notown` AS `treemotherNotown`,
`child`.`day_last_edit` AS `meday_last_edit`
FROM `animals` AS `child`
LEFT JOIN (`animals` AS `treefather`) ON (`treefather`.`id`=child.father_id)
LEFT JOIN (`animals` AS `treemother`) ON (`treemother`.`id`=child.mother_id)
LEFT JOIN (`category` AS `c`) ON (`c`.`id` = `child`.`cid`)
LEFT JOIN (`lang` AS `l2`) ON (`l2`.`id` = `c`.`name`)
LEFT JOIN (`breed` AS `b`) ON (`b`.`id` = SUBSTRING_INDEX(SUBSTRING_INDEX(`child`.`data`, '"breed":"', -1),'"', 1))
LEFT JOIN (`lang` AS `l`) ON (`l`.`id` = `b`.`name`)
WHERE `child`.`id`=6345SELECT
IF(`l`.`en`='',`l`.`hu`, `l`.`en`) AS `childBreed`,
`child`.`cid` AS `childCid`,
`child`.`uid` AS `childUid`,
`child`.`post_id` AS `childPost`,
`child`.`id` AS `childId`,
`child`.`data` AS `child`,
`child`.`public` AS `childPublic`,
`child`.`notown` AS `childNotown`,
`child`.`offspringsLength` AS `childoffspringsLength`,
`child`.`offspringsLitter` AS `childoffspringsLitter`,
IF(`l2`.`en`='',`l2`.`hu`, `l2`.`en`) AS `breedName`,
`c`.`species` AS `breedSpecies`,
`c`.`categorys` AS `breedCategorys`,
`c`.`icon` AS `breedicon`,
`c`.`latin`,
concat('[',SUBSTRING(`child`.`interested`,1,CHAR_LENGTH(`child`.`interested`) - 1),']') AS `interested`,
`treefather`.`id` AS `treefatherId`,
`treefather`.`uid` AS `treefatherUid`,
`treefather`.`data` AS `treefather`,
`treefather`.`public` AS `treefatherPublic`,
`treefather`.`notown` AS `treefatherNotown`,
`treemother`.`id` AS `treemotherId`,
`treemother`.`uid` AS `treemotherUid`,
`treemother`.`data` AS `treemother`,
`treemother`.`public` AS `treemotherPublic`,
`treemother`.`notown` AS `treemotherNotown`,
`child`.`day_last_edit` AS `meday_last_edit`
FROM `animals` AS `child`
LEFT JOIN (`animals` AS `treefather`) ON (`treefather`.`id`=child.father_id)
LEFT JOIN (`animals` AS `treemother`) ON (`treemother`.`id`=child.mother_id)
LEFT JOIN (`category` AS `c`) ON (`c`.`id` = `child`.`cid`)
LEFT JOIN (`lang` AS `l2`) ON (`l2`.`id` = `c`.`name`)
LEFT JOIN (`breed` AS `b`) ON (`b`.`id` = SUBSTRING_INDEX(SUBSTRING_INDEX(`child`.`data`, '"breed":"', -1),'"', 1))
LEFT JOIN (`lang` AS `l`) ON (`l`.`id` = `b`.`name`)
WHERE `child`.`id`=6344SELECT
IF(`l`.`en`='',`l`.`hu`, `l`.`en`) AS `childBreed`,
`child`.`cid` AS `childCid`,
`child`.`uid` AS `childUid`,
`child`.`post_id` AS `childPost`,
`child`.`id` AS `childId`,
`child`.`data` AS `child`,
`child`.`public` AS `childPublic`,
`child`.`notown` AS `childNotown`,
`child`.`offspringsLength` AS `childoffspringsLength`,
`child`.`offspringsLitter` AS `childoffspringsLitter`,
IF(`l2`.`en`='',`l2`.`hu`, `l2`.`en`) AS `breedName`,
`c`.`species` AS `breedSpecies`,
`c`.`categorys` AS `breedCategorys`,
`c`.`icon` AS `breedicon`,
`c`.`latin`,
concat('[',SUBSTRING(`child`.`interested`,1,CHAR_LENGTH(`child`.`interested`) - 1),']') AS `interested`,
`treefather`.`id` AS `treefatherId`,
`treefather`.`uid` AS `treefatherUid`,
`treefather`.`data` AS `treefather`,
`treefather`.`public` AS `treefatherPublic`,
`treefather`.`notown` AS `treefatherNotown`,
`treemother`.`id` AS `treemotherId`,
`treemother`.`uid` AS `treemotherUid`,
`treemother`.`data` AS `treemother`,
`treemother`.`public` AS `treemotherPublic`,
`treemother`.`notown` AS `treemotherNotown`,
`child`.`day_last_edit` AS `meday_last_edit`
FROM `animals` AS `child`
LEFT JOIN (`animals` AS `treefather`) ON (`treefather`.`id`=child.father_id)
LEFT JOIN (`animals` AS `treemother`) ON (`treemother`.`id`=child.mother_id)
LEFT JOIN (`category` AS `c`) ON (`c`.`id` = `child`.`cid`)
LEFT JOIN (`lang` AS `l2`) ON (`l2`.`id` = `c`.`name`)
LEFT JOIN (`breed` AS `b`) ON (`b`.`id` = SUBSTRING_INDEX(SUBSTRING_INDEX(`child`.`data`, '"breed":"', -1),'"', 1))
LEFT JOIN (`lang` AS `l`) ON (`l`.`id` = `b`.`name`)
WHERE `child`.`id`=6339SELECT
IF(`l`.`en`='',`l`.`hu`, `l`.`en`) AS `childBreed`,
`child`.`cid` AS `childCid`,
`child`.`uid` AS `childUid`,
`child`.`post_id` AS `childPost`,
`child`.`id` AS `childId`,
`child`.`data` AS `child`,
`child`.`public` AS `childPublic`,
`child`.`notown` AS `childNotown`,
`child`.`offspringsLength` AS `childoffspringsLength`,
`child`.`offspringsLitter` AS `childoffspringsLitter`,
IF(`l2`.`en`='',`l2`.`hu`, `l2`.`en`) AS `breedName`,
`c`.`species` AS `breedSpecies`,
`c`.`categorys` AS `breedCategorys`,
`c`.`icon` AS `breedicon`,
`c`.`latin`,
concat('[',SUBSTRING(`child`.`interested`,1,CHAR_LENGTH(`child`.`interested`) - 1),']') AS `interested`,
`treefather`.`id` AS `treefatherId`,
`treefather`.`uid` AS `treefatherUid`,
`treefather`.`data` AS `treefather`,
`treefather`.`public` AS `treefatherPublic`,
`treefather`.`notown` AS `treefatherNotown`,
`treemother`.`id` AS `treemotherId`,
`treemother`.`uid` AS `treemotherUid`,
`treemother`.`data` AS `treemother`,
`treemother`.`public` AS `treemotherPublic`,
`treemother`.`notown` AS `treemotherNotown`,
`child`.`day_last_edit` AS `meday_last_edit`
FROM `animals` AS `child`
LEFT JOIN (`animals` AS `treefather`) ON (`treefather`.`id`=child.father_id)
LEFT JOIN (`animals` AS `treemother`) ON (`treemother`.`id`=child.mother_id)
LEFT JOIN (`category` AS `c`) ON (`c`.`id` = `child`.`cid`)
LEFT JOIN (`lang` AS `l2`) ON (`l2`.`id` = `c`.`name`)
LEFT JOIN (`breed` AS `b`) ON (`b`.`id` = SUBSTRING_INDEX(SUBSTRING_INDEX(`child`.`data`, '"breed":"', -1),'"', 1))
LEFT JOIN (`lang` AS `l`) ON (`l`.`id` = `b`.`name`)
WHERE `child`.`id`=6338SELECT
IF(`l`.`en`='',`l`.`hu`, `l`.`en`) AS `childBreed`,
`child`.`cid` AS `childCid`,
`child`.`uid` AS `childUid`,
`child`.`post_id` AS `childPost`,
`child`.`id` AS `childId`,
`child`.`data` AS `child`,
`child`.`public` AS `childPublic`,
`child`.`notown` AS `childNotown`,
`child`.`offspringsLength` AS `childoffspringsLength`,
`child`.`offspringsLitter` AS `childoffspringsLitter`,
IF(`l2`.`en`='',`l2`.`hu`, `l2`.`en`) AS `breedName`,
`c`.`species` AS `breedSpecies`,
`c`.`categorys` AS `breedCategorys`,
`c`.`icon` AS `breedicon`,
`c`.`latin`,
concat('[',SUBSTRING(`child`.`interested`,1,CHAR_LENGTH(`child`.`interested`) - 1),']') AS `interested`,
`treefather`.`id` AS `treefatherId`,
`treefather`.`uid` AS `treefatherUid`,
`treefather`.`data` AS `treefather`,
`treefather`.`public` AS `treefatherPublic`,
`treefather`.`notown` AS `treefatherNotown`,
`treemother`.`id` AS `treemotherId`,
`treemother`.`uid` AS `treemotherUid`,
`treemother`.`data` AS `treemother`,
`treemother`.`public` AS `treemotherPublic`,
`treemother`.`notown` AS `treemotherNotown`,
`child`.`day_last_edit` AS `meday_last_edit`
FROM `animals` AS `child`
LEFT JOIN (`animals` AS `treefather`) ON (`treefather`.`id`=child.father_id)
LEFT JOIN (`animals` AS `treemother`) ON (`treemother`.`id`=child.mother_id)
LEFT JOIN (`category` AS `c`) ON (`c`.`id` = `child`.`cid`)
LEFT JOIN (`lang` AS `l2`) ON (`l2`.`id` = `c`.`name`)
LEFT JOIN (`breed` AS `b`) ON (`b`.`id` = SUBSTRING_INDEX(SUBSTRING_INDEX(`child`.`data`, '"breed":"', -1),'"', 1))
LEFT JOIN (`lang` AS `l`) ON (`l`.`id` = `b`.`name`)
WHERE `child`.`id`=6342SELECT
IF(`l`.`en`='',`l`.`hu`, `l`.`en`) AS `childBreed`,
`child`.`cid` AS `childCid`,
`child`.`uid` AS `childUid`,
`child`.`post_id` AS `childPost`,
`child`.`id` AS `childId`,
`child`.`data` AS `child`,
`child`.`public` AS `childPublic`,
`child`.`notown` AS `childNotown`,
`child`.`offspringsLength` AS `childoffspringsLength`,
`child`.`offspringsLitter` AS `childoffspringsLitter`,
IF(`l2`.`en`='',`l2`.`hu`, `l2`.`en`) AS `breedName`,
`c`.`species` AS `breedSpecies`,
`c`.`categorys` AS `breedCategorys`,
`c`.`icon` AS `breedicon`,
`c`.`latin`,
concat('[',SUBSTRING(`child`.`interested`,1,CHAR_LENGTH(`child`.`interested`) - 1),']') AS `interested`,
`treefather`.`id` AS `treefatherId`,
`treefather`.`uid` AS `treefatherUid`,
`treefather`.`data` AS `treefather`,
`treefather`.`public` AS `treefatherPublic`,
`treefather`.`notown` AS `treefatherNotown`,
`treemother`.`id` AS `treemotherId`,
`treemother`.`uid` AS `treemotherUid`,
`treemother`.`data` AS `treemother`,
`treemother`.`public` AS `treemotherPublic`,
`treemother`.`notown` AS `treemotherNotown`,
`child`.`day_last_edit` AS `meday_last_edit`
FROM `animals` AS `child`
LEFT JOIN (`animals` AS `treefather`) ON (`treefather`.`id`=child.father_id)
LEFT JOIN (`animals` AS `treemother`) ON (`treemother`.`id`=child.mother_id)
LEFT JOIN (`category` AS `c`) ON (`c`.`id` = `child`.`cid`)
LEFT JOIN (`lang` AS `l2`) ON (`l2`.`id` = `c`.`name`)
LEFT JOIN (`breed` AS `b`) ON (`b`.`id` = SUBSTRING_INDEX(SUBSTRING_INDEX(`child`.`data`, '"breed":"', -1),'"', 1))
LEFT JOIN (`lang` AS `l`) ON (`l`.`id` = `b`.`name`)
WHERE `child`.`id`=6341SELECT
IF(`l`.`en`='',`l`.`hu`, `l`.`en`) AS `childBreed`,
`child`.`cid` AS `childCid`,
`child`.`uid` AS `childUid`,
`child`.`post_id` AS `childPost`,
`child`.`id` AS `childId`,
`child`.`data` AS `child`,
`child`.`public` AS `childPublic`,
`child`.`notown` AS `childNotown`,
`child`.`offspringsLength` AS `childoffspringsLength`,
`child`.`offspringsLitter` AS `childoffspringsLitter`,
IF(`l2`.`en`='',`l2`.`hu`, `l2`.`en`) AS `breedName`,
`c`.`species` AS `breedSpecies`,
`c`.`categorys` AS `breedCategorys`,
`c`.`icon` AS `breedicon`,
`c`.`latin`,
concat('[',SUBSTRING(`child`.`interested`,1,CHAR_LENGTH(`child`.`interested`) - 1),']') AS `interested`,
`treefather`.`id` AS `treefatherId`,
`treefather`.`uid` AS `treefatherUid`,
`treefather`.`data` AS `treefather`,
`treefather`.`public` AS `treefatherPublic`,
`treefather`.`notown` AS `treefatherNotown`,
`treemother`.`id` AS `treemotherId`,
`treemother`.`uid` AS `treemotherUid`,
`treemother`.`data` AS `treemother`,
`treemother`.`public` AS `treemotherPublic`,
`treemother`.`notown` AS `treemotherNotown`,
`child`.`day_last_edit` AS `meday_last_edit`
FROM `animals` AS `child`
LEFT JOIN (`animals` AS `treefather`) ON (`treefather`.`id`=child.father_id)
LEFT JOIN (`animals` AS `treemother`) ON (`treemother`.`id`=child.mother_id)
LEFT JOIN (`category` AS `c`) ON (`c`.`id` = `child`.`cid`)
LEFT JOIN (`lang` AS `l2`) ON (`l2`.`id` = `c`.`name`)
LEFT JOIN (`breed` AS `b`) ON (`b`.`id` = SUBSTRING_INDEX(SUBSTRING_INDEX(`child`.`data`, '"breed":"', -1),'"', 1))
LEFT JOIN (`lang` AS `l`) ON (`l`.`id` = `b`.`name`)
WHERE `child`.`id`=6391SELECT
IF(`l`.`en`='',`l`.`hu`, `l`.`en`) AS `childBreed`,
`child`.`cid` AS `childCid`,
`child`.`uid` AS `childUid`,
`child`.`post_id` AS `childPost`,
`child`.`id` AS `childId`,
`child`.`data` AS `child`,
`child`.`public` AS `childPublic`,
`child`.`notown` AS `childNotown`,
`child`.`offspringsLength` AS `childoffspringsLength`,
`child`.`offspringsLitter` AS `childoffspringsLitter`,
IF(`l2`.`en`='',`l2`.`hu`, `l2`.`en`) AS `breedName`,
`c`.`species` AS `breedSpecies`,
`c`.`categorys` AS `breedCategorys`,
`c`.`icon` AS `breedicon`,
`c`.`latin`,
concat('[',SUBSTRING(`child`.`interested`,1,CHAR_LENGTH(`child`.`interested`) - 1),']') AS `interested`,
`treefather`.`id` AS `treefatherId`,
`treefather`.`uid` AS `treefatherUid`,
`treefather`.`data` AS `treefather`,
`treefather`.`public` AS `treefatherPublic`,
`treefather`.`notown` AS `treefatherNotown`,
`treemother`.`id` AS `treemotherId`,
`treemother`.`uid` AS `treemotherUid`,
`treemother`.`data` AS `treemother`,
`treemother`.`public` AS `treemotherPublic`,
`treemother`.`notown` AS `treemotherNotown`,
`child`.`day_last_edit` AS `meday_last_edit`
FROM `animals` AS `child`
LEFT JOIN (`animals` AS `treefather`) ON (`treefather`.`id`=child.father_id)
LEFT JOIN (`animals` AS `treemother`) ON (`treemother`.`id`=child.mother_id)
LEFT JOIN (`category` AS `c`) ON (`c`.`id` = `child`.`cid`)
LEFT JOIN (`lang` AS `l2`) ON (`l2`.`id` = `c`.`name`)
LEFT JOIN (`breed` AS `b`) ON (`b`.`id` = SUBSTRING_INDEX(SUBSTRING_INDEX(`child`.`data`, '"breed":"', -1),'"', 1))
LEFT JOIN (`lang` AS `l`) ON (`l`.`id` = `b`.`name`)
WHERE `child`.`id`=12826SELECT
IF(`l`.`en`='',`l`.`hu`, `l`.`en`) AS `childBreed`,
`child`.`cid` AS `childCid`,
`child`.`uid` AS `childUid`,
`child`.`post_id` AS `childPost`,
`child`.`id` AS `childId`,
`child`.`data` AS `child`,
`child`.`public` AS `childPublic`,
`child`.`notown` AS `childNotown`,
`child`.`offspringsLength` AS `childoffspringsLength`,
`child`.`offspringsLitter` AS `childoffspringsLitter`,
IF(`l2`.`en`='',`l2`.`hu`, `l2`.`en`) AS `breedName`,
`c`.`species` AS `breedSpecies`,
`c`.`categorys` AS `breedCategorys`,
`c`.`icon` AS `breedicon`,
`c`.`latin`,
concat('[',SUBSTRING(`child`.`interested`,1,CHAR_LENGTH(`child`.`interested`) - 1),']') AS `interested`,
`treefather`.`id` AS `treefatherId`,
`treefather`.`uid` AS `treefatherUid`,
`treefather`.`data` AS `treefather`,
`treefather`.`public` AS `treefatherPublic`,
`treefather`.`notown` AS `treefatherNotown`,
`treemother`.`id` AS `treemotherId`,
`treemother`.`uid` AS `treemotherUid`,
`treemother`.`data` AS `treemother`,
`treemother`.`public` AS `treemotherPublic`,
`treemother`.`notown` AS `treemotherNotown`,
`child`.`day_last_edit` AS `meday_last_edit`
FROM `animals` AS `child`
LEFT JOIN (`animals` AS `treefather`) ON (`treefather`.`id`=child.father_id)
LEFT JOIN (`animals` AS `treemother`) ON (`treemother`.`id`=child.mother_id)
LEFT JOIN (`category` AS `c`) ON (`c`.`id` = `child`.`cid`)
LEFT JOIN (`lang` AS `l2`) ON (`l2`.`id` = `c`.`name`)
LEFT JOIN (`breed` AS `b`) ON (`b`.`id` = SUBSTRING_INDEX(SUBSTRING_INDEX(`child`.`data`, '"breed":"', -1),'"', 1))
LEFT JOIN (`lang` AS `l`) ON (`l`.`id` = `b`.`name`)
WHERE `child`.`id`=11407SELECT
IF(`l`.`en`='',`l`.`hu`, `l`.`en`) AS `childBreed`,
`child`.`cid` AS `childCid`,
`child`.`uid` AS `childUid`,
`child`.`post_id` AS `childPost`,
`child`.`id` AS `childId`,
`child`.`data` AS `child`,
`child`.`public` AS `childPublic`,
`child`.`notown` AS `childNotown`,
`child`.`offspringsLength` AS `childoffspringsLength`,
`child`.`offspringsLitter` AS `childoffspringsLitter`,
IF(`l2`.`en`='',`l2`.`hu`, `l2`.`en`) AS `breedName`,
`c`.`species` AS `breedSpecies`,
`c`.`categorys` AS `breedCategorys`,
`c`.`icon` AS `breedicon`,
`c`.`latin`,
concat('[',SUBSTRING(`child`.`interested`,1,CHAR_LENGTH(`child`.`interested`) - 1),']') AS `interested`,
`treefather`.`id` AS `treefatherId`,
`treefather`.`uid` AS `treefatherUid`,
`treefather`.`data` AS `treefather`,
`treefather`.`public` AS `treefatherPublic`,
`treefather`.`notown` AS `treefatherNotown`,
`treemother`.`id` AS `treemotherId`,
`treemother`.`uid` AS `treemotherUid`,
`treemother`.`data` AS `treemother`,
`treemother`.`public` AS `treemotherPublic`,
`treemother`.`notown` AS `treemotherNotown`,
`child`.`day_last_edit` AS `meday_last_edit`
FROM `animals` AS `child`
LEFT JOIN (`animals` AS `treefather`) ON (`treefather`.`id`=child.father_id)
LEFT JOIN (`animals` AS `treemother`) ON (`treemother`.`id`=child.mother_id)
LEFT JOIN (`category` AS `c`) ON (`c`.`id` = `child`.`cid`)
LEFT JOIN (`lang` AS `l2`) ON (`l2`.`id` = `c`.`name`)
LEFT JOIN (`breed` AS `b`) ON (`b`.`id` = SUBSTRING_INDEX(SUBSTRING_INDEX(`child`.`data`, '"breed":"', -1),'"', 1))
LEFT JOIN (`lang` AS `l`) ON (`l`.`id` = `b`.`name`)
WHERE `child`.`id`=7784SELECT
IF(`l`.`en`='',`l`.`hu`, `l`.`en`) AS `childBreed`,
`child`.`cid` AS `childCid`,
`child`.`uid` AS `childUid`,
`child`.`post_id` AS `childPost`,
`child`.`id` AS `childId`,
`child`.`data` AS `child`,
`child`.`public` AS `childPublic`,
`child`.`notown` AS `childNotown`,
`child`.`offspringsLength` AS `childoffspringsLength`,
`child`.`offspringsLitter` AS `childoffspringsLitter`,
IF(`l2`.`en`='',`l2`.`hu`, `l2`.`en`) AS `breedName`,
`c`.`species` AS `breedSpecies`,
`c`.`categorys` AS `breedCategorys`,
`c`.`icon` AS `breedicon`,
`c`.`latin`,
concat('[',SUBSTRING(`child`.`interested`,1,CHAR_LENGTH(`child`.`interested`) - 1),']') AS `interested`,
`treefather`.`id` AS `treefatherId`,
`treefather`.`uid` AS `treefatherUid`,
`treefather`.`data` AS `treefather`,
`treefather`.`public` AS `treefatherPublic`,
`treefather`.`notown` AS `treefatherNotown`,
`treemother`.`id` AS `treemotherId`,
`treemother`.`uid` AS `treemotherUid`,
`treemother`.`data` AS `treemother`,
`treemother`.`public` AS `treemotherPublic`,
`treemother`.`notown` AS `treemotherNotown`,
`child`.`day_last_edit` AS `meday_last_edit`
FROM `animals` AS `child`
LEFT JOIN (`animals` AS `treefather`) ON (`treefather`.`id`=child.father_id)
LEFT JOIN (`animals` AS `treemother`) ON (`treemother`.`id`=child.mother_id)
LEFT JOIN (`category` AS `c`) ON (`c`.`id` = `child`.`cid`)
LEFT JOIN (`lang` AS `l2`) ON (`l2`.`id` = `c`.`name`)
LEFT JOIN (`breed` AS `b`) ON (`b`.`id` = SUBSTRING_INDEX(SUBSTRING_INDEX(`child`.`data`, '"breed":"', -1),'"', 1))
LEFT JOIN (`lang` AS `l`) ON (`l`.`id` = `b`.`name`)
WHERE `child`.`id`=9110SELECT
IF(`l`.`en`='',`l`.`hu`, `l`.`en`) AS `childBreed`,
`child`.`cid` AS `childCid`,
`child`.`uid` AS `childUid`,
`child`.`post_id` AS `childPost`,
`child`.`id` AS `childId`,
`child`.`data` AS `child`,
`child`.`public` AS `childPublic`,
`child`.`notown` AS `childNotown`,
`child`.`offspringsLength` AS `childoffspringsLength`,
`child`.`offspringsLitter` AS `childoffspringsLitter`,
IF(`l2`.`en`='',`l2`.`hu`, `l2`.`en`) AS `breedName`,
`c`.`species` AS `breedSpecies`,
`c`.`categorys` AS `breedCategorys`,
`c`.`icon` AS `breedicon`,
`c`.`latin`,
concat('[',SUBSTRING(`child`.`interested`,1,CHAR_LENGTH(`child`.`interested`) - 1),']') AS `interested`,
`treefather`.`id` AS `treefatherId`,
`treefather`.`uid` AS `treefatherUid`,
`treefather`.`data` AS `treefather`,
`treefather`.`public` AS `treefatherPublic`,
`treefather`.`notown` AS `treefatherNotown`,
`treemother`.`id` AS `treemotherId`,
`treemother`.`uid` AS `treemotherUid`,
`treemother`.`data` AS `treemother`,
`treemother`.`public` AS `treemotherPublic`,
`treemother`.`notown` AS `treemotherNotown`,
`child`.`day_last_edit` AS `meday_last_edit`
FROM `animals` AS `child`
LEFT JOIN (`animals` AS `treefather`) ON (`treefather`.`id`=child.father_id)
LEFT JOIN (`animals` AS `treemother`) ON (`treemother`.`id`=child.mother_id)
LEFT JOIN (`category` AS `c`) ON (`c`.`id` = `child`.`cid`)
LEFT JOIN (`lang` AS `l2`) ON (`l2`.`id` = `c`.`name`)
LEFT JOIN (`breed` AS `b`) ON (`b`.`id` = SUBSTRING_INDEX(SUBSTRING_INDEX(`child`.`data`, '"breed":"', -1),'"', 1))
LEFT JOIN (`lang` AS `l`) ON (`l`.`id` = `b`.`name`)
WHERE `child`.`id`=9111SELECT
IF(`l`.`en`='',`l`.`hu`, `l`.`en`) AS `childBreed`,
`child`.`cid` AS `childCid`,
`child`.`uid` AS `childUid`,
`child`.`post_id` AS `childPost`,
`child`.`id` AS `childId`,
`child`.`data` AS `child`,
`child`.`public` AS `childPublic`,
`child`.`notown` AS `childNotown`,
`child`.`offspringsLength` AS `childoffspringsLength`,
`child`.`offspringsLitter` AS `childoffspringsLitter`,
IF(`l2`.`en`='',`l2`.`hu`, `l2`.`en`) AS `breedName`,
`c`.`species` AS `breedSpecies`,
`c`.`categorys` AS `breedCategorys`,
`c`.`icon` AS `breedicon`,
`c`.`latin`,
concat('[',SUBSTRING(`child`.`interested`,1,CHAR_LENGTH(`child`.`interested`) - 1),']') AS `interested`,
`treefather`.`id` AS `treefatherId`,
`treefather`.`uid` AS `treefatherUid`,
`treefather`.`data` AS `treefather`,
`treefather`.`public` AS `treefatherPublic`,
`treefather`.`notown` AS `treefatherNotown`,
`treemother`.`id` AS `treemotherId`,
`treemother`.`uid` AS `treemotherUid`,
`treemother`.`data` AS `treemother`,
`treemother`.`public` AS `treemotherPublic`,
`treemother`.`notown` AS `treemotherNotown`,
`child`.`day_last_edit` AS `meday_last_edit`
FROM `animals` AS `child`
LEFT JOIN (`animals` AS `treefather`) ON (`treefather`.`id`=child.father_id)
LEFT JOIN (`animals` AS `treemother`) ON (`treemother`.`id`=child.mother_id)
LEFT JOIN (`category` AS `c`) ON (`c`.`id` = `child`.`cid`)
LEFT JOIN (`lang` AS `l2`) ON (`l2`.`id` = `c`.`name`)
LEFT JOIN (`breed` AS `b`) ON (`b`.`id` = SUBSTRING_INDEX(SUBSTRING_INDEX(`child`.`data`, '"breed":"', -1),'"', 1))
LEFT JOIN (`lang` AS `l`) ON (`l`.`id` = `b`.`name`)
WHERE `child`.`id`=9101SELECT
IF(`l`.`en`='',`l`.`hu`, `l`.`en`) AS `childBreed`,
`child`.`cid` AS `childCid`,
`child`.`uid` AS `childUid`,
`child`.`post_id` AS `childPost`,
`child`.`id` AS `childId`,
`child`.`data` AS `child`,
`child`.`public` AS `childPublic`,
`child`.`notown` AS `childNotown`,
`child`.`offspringsLength` AS `childoffspringsLength`,
`child`.`offspringsLitter` AS `childoffspringsLitter`,
IF(`l2`.`en`='',`l2`.`hu`, `l2`.`en`) AS `breedName`,
`c`.`species` AS `breedSpecies`,
`c`.`categorys` AS `breedCategorys`,
`c`.`icon` AS `breedicon`,
`c`.`latin`,
concat('[',SUBSTRING(`child`.`interested`,1,CHAR_LENGTH(`child`.`interested`) - 1),']') AS `interested`,
`treefather`.`id` AS `treefatherId`,
`treefather`.`uid` AS `treefatherUid`,
`treefather`.`data` AS `treefather`,
`treefather`.`public` AS `treefatherPublic`,
`treefather`.`notown` AS `treefatherNotown`,
`treemother`.`id` AS `treemotherId`,
`treemother`.`uid` AS `treemotherUid`,
`treemother`.`data` AS `treemother`,
`treemother`.`public` AS `treemotherPublic`,
`treemother`.`notown` AS `treemotherNotown`,
`child`.`day_last_edit` AS `meday_last_edit`
FROM `animals` AS `child`
LEFT JOIN (`animals` AS `treefather`) ON (`treefather`.`id`=child.father_id)
LEFT JOIN (`animals` AS `treemother`) ON (`treemother`.`id`=child.mother_id)
LEFT JOIN (`category` AS `c`) ON (`c`.`id` = `child`.`cid`)
LEFT JOIN (`lang` AS `l2`) ON (`l2`.`id` = `c`.`name`)
LEFT JOIN (`breed` AS `b`) ON (`b`.`id` = SUBSTRING_INDEX(SUBSTRING_INDEX(`child`.`data`, '"breed":"', -1),'"', 1))
LEFT JOIN (`lang` AS `l`) ON (`l`.`id` = `b`.`name`)
WHERE `child`.`id`=9104SELECT
IF(`l`.`en`='',`l`.`hu`, `l`.`en`) AS `childBreed`,
`child`.`cid` AS `childCid`,
`child`.`uid` AS `childUid`,
`child`.`post_id` AS `childPost`,
`child`.`id` AS `childId`,
`child`.`data` AS `child`,
`child`.`public` AS `childPublic`,
`child`.`notown` AS `childNotown`,
`child`.`offspringsLength` AS `childoffspringsLength`,
`child`.`offspringsLitter` AS `childoffspringsLitter`,
IF(`l2`.`en`='',`l2`.`hu`, `l2`.`en`) AS `breedName`,
`c`.`species` AS `breedSpecies`,
`c`.`categorys` AS `breedCategorys`,
`c`.`icon` AS `breedicon`,
`c`.`latin`,
concat('[',SUBSTRING(`child`.`interested`,1,CHAR_LENGTH(`child`.`interested`) - 1),']') AS `interested`,
`treefather`.`id` AS `treefatherId`,
`treefather`.`uid` AS `treefatherUid`,
`treefather`.`data` AS `treefather`,
`treefather`.`public` AS `treefatherPublic`,
`treefather`.`notown` AS `treefatherNotown`,
`treemother`.`id` AS `treemotherId`,
`treemother`.`uid` AS `treemotherUid`,
`treemother`.`data` AS `treemother`,
`treemother`.`public` AS `treemotherPublic`,
`treemother`.`notown` AS `treemotherNotown`,
`child`.`day_last_edit` AS `meday_last_edit`
FROM `animals` AS `child`
LEFT JOIN (`animals` AS `treefather`) ON (`treefather`.`id`=child.father_id)
LEFT JOIN (`animals` AS `treemother`) ON (`treemother`.`id`=child.mother_id)
LEFT JOIN (`category` AS `c`) ON (`c`.`id` = `child`.`cid`)
LEFT JOIN (`lang` AS `l2`) ON (`l2`.`id` = `c`.`name`)
LEFT JOIN (`breed` AS `b`) ON (`b`.`id` = SUBSTRING_INDEX(SUBSTRING_INDEX(`child`.`data`, '"breed":"', -1),'"', 1))
LEFT JOIN (`lang` AS `l`) ON (`l`.`id` = `b`.`name`)
WHERE `child`.`id`=7915SELECT
IF(`l`.`en`='',`l`.`hu`, `l`.`en`) AS `childBreed`,
`child`.`cid` AS `childCid`,
`child`.`uid` AS `childUid`,
`child`.`post_id` AS `childPost`,
`child`.`id` AS `childId`,
`child`.`data` AS `child`,
`child`.`public` AS `childPublic`,
`child`.`notown` AS `childNotown`,
`child`.`offspringsLength` AS `childoffspringsLength`,
`child`.`offspringsLitter` AS `childoffspringsLitter`,
IF(`l2`.`en`='',`l2`.`hu`, `l2`.`en`) AS `breedName`,
`c`.`species` AS `breedSpecies`,
`c`.`categorys` AS `breedCategorys`,
`c`.`icon` AS `breedicon`,
`c`.`latin`,
concat('[',SUBSTRING(`child`.`interested`,1,CHAR_LENGTH(`child`.`interested`) - 1),']') AS `interested`,
`treefather`.`id` AS `treefatherId`,
`treefather`.`uid` AS `treefatherUid`,
`treefather`.`data` AS `treefather`,
`treefather`.`public` AS `treefatherPublic`,
`treefather`.`notown` AS `treefatherNotown`,
`treemother`.`id` AS `treemotherId`,
`treemother`.`uid` AS `treemotherUid`,
`treemother`.`data` AS `treemother`,
`treemother`.`public` AS `treemotherPublic`,
`treemother`.`notown` AS `treemotherNotown`,
`child`.`day_last_edit` AS `meday_last_edit`
FROM `animals` AS `child`
LEFT JOIN (`animals` AS `treefather`) ON (`treefather`.`id`=child.father_id)
LEFT JOIN (`animals` AS `treemother`) ON (`treemother`.`id`=child.mother_id)
LEFT JOIN (`category` AS `c`) ON (`c`.`id` = `child`.`cid`)
LEFT JOIN (`lang` AS `l2`) ON (`l2`.`id` = `c`.`name`)
LEFT JOIN (`breed` AS `b`) ON (`b`.`id` = SUBSTRING_INDEX(SUBSTRING_INDEX(`child`.`data`, '"breed":"', -1),'"', 1))
LEFT JOIN (`lang` AS `l`) ON (`l`.`id` = `b`.`name`)
WHERE `child`.`id`=9109SELECT
IF(`l`.`en`='',`l`.`hu`, `l`.`en`) AS `childBreed`,
`child`.`cid` AS `childCid`,
`child`.`uid` AS `childUid`,
`child`.`post_id` AS `childPost`,
`child`.`id` AS `childId`,
`child`.`data` AS `child`,
`child`.`public` AS `childPublic`,
`child`.`notown` AS `childNotown`,
`child`.`offspringsLength` AS `childoffspringsLength`,
`child`.`offspringsLitter` AS `childoffspringsLitter`,
IF(`l2`.`en`='',`l2`.`hu`, `l2`.`en`) AS `breedName`,
`c`.`species` AS `breedSpecies`,
`c`.`categorys` AS `breedCategorys`,
`c`.`icon` AS `breedicon`,
`c`.`latin`,
concat('[',SUBSTRING(`child`.`interested`,1,CHAR_LENGTH(`child`.`interested`) - 1),']') AS `interested`,
`treefather`.`id` AS `treefatherId`,
`treefather`.`uid` AS `treefatherUid`,
`treefather`.`data` AS `treefather`,
`treefather`.`public` AS `treefatherPublic`,
`treefather`.`notown` AS `treefatherNotown`,
`treemother`.`id` AS `treemotherId`,
`treemother`.`uid` AS `treemotherUid`,
`treemother`.`data` AS `treemother`,
`treemother`.`public` AS `treemotherPublic`,
`treemother`.`notown` AS `treemotherNotown`,
`child`.`day_last_edit` AS `meday_last_edit`
FROM `animals` AS `child`
LEFT JOIN (`animals` AS `treefather`) ON (`treefather`.`id`=child.father_id)
LEFT JOIN (`animals` AS `treemother`) ON (`treemother`.`id`=child.mother_id)
LEFT JOIN (`category` AS `c`) ON (`c`.`id` = `child`.`cid`)
LEFT JOIN (`lang` AS `l2`) ON (`l2`.`id` = `c`.`name`)
LEFT JOIN (`breed` AS `b`) ON (`b`.`id` = SUBSTRING_INDEX(SUBSTRING_INDEX(`child`.`data`, '"breed":"', -1),'"', 1))
LEFT JOIN (`lang` AS `l`) ON (`l`.`id` = `b`.`name`)
WHERE `child`.`id`=9112SELECT
IF(`l`.`en`='',`l`.`hu`, `l`.`en`) AS `childBreed`,
`child`.`cid` AS `childCid`,
`child`.`uid` AS `childUid`,
`child`.`post_id` AS `childPost`,
`child`.`id` AS `childId`,
`child`.`data` AS `child`,
`child`.`public` AS `childPublic`,
`child`.`notown` AS `childNotown`,
`child`.`offspringsLength` AS `childoffspringsLength`,
`child`.`offspringsLitter` AS `childoffspringsLitter`,
IF(`l2`.`en`='',`l2`.`hu`, `l2`.`en`) AS `breedName`,
`c`.`species` AS `breedSpecies`,
`c`.`categorys` AS `breedCategorys`,
`c`.`icon` AS `breedicon`,
`c`.`latin`,
concat('[',SUBSTRING(`child`.`interested`,1,CHAR_LENGTH(`child`.`interested`) - 1),']') AS `interested`,
`treefather`.`id` AS `treefatherId`,
`treefather`.`uid` AS `treefatherUid`,
`treefather`.`data` AS `treefather`,
`treefather`.`public` AS `treefatherPublic`,
`treefather`.`notown` AS `treefatherNotown`,
`treemother`.`id` AS `treemotherId`,
`treemother`.`uid` AS `treemotherUid`,
`treemother`.`data` AS `treemother`,
`treemother`.`public` AS `treemotherPublic`,
`treemother`.`notown` AS `treemotherNotown`,
`child`.`day_last_edit` AS `meday_last_edit`
FROM `animals` AS `child`
LEFT JOIN (`animals` AS `treefather`) ON (`treefather`.`id`=child.father_id)
LEFT JOIN (`animals` AS `treemother`) ON (`treemother`.`id`=child.mother_id)
LEFT JOIN (`category` AS `c`) ON (`c`.`id` = `child`.`cid`)
LEFT JOIN (`lang` AS `l2`) ON (`l2`.`id` = `c`.`name`)
LEFT JOIN (`breed` AS `b`) ON (`b`.`id` = SUBSTRING_INDEX(SUBSTRING_INDEX(`child`.`data`, '"breed":"', -1),'"', 1))
LEFT JOIN (`lang` AS `l`) ON (`l`.`id` = `b`.`name`)
WHERE `child`.`id`=9113SELECT
IF(`l`.`en`='',`l`.`hu`, `l`.`en`) AS `childBreed`,
`child`.`cid` AS `childCid`,
`child`.`uid` AS `childUid`,
`child`.`post_id` AS `childPost`,
`child`.`id` AS `childId`,
`child`.`data` AS `child`,
`child`.`public` AS `childPublic`,
`child`.`notown` AS `childNotown`,
`child`.`offspringsLength` AS `childoffspringsLength`,
`child`.`offspringsLitter` AS `childoffspringsLitter`,
IF(`l2`.`en`='',`l2`.`hu`, `l2`.`en`) AS `breedName`,
`c`.`species` AS `breedSpecies`,
`c`.`categorys` AS `breedCategorys`,
`c`.`icon` AS `breedicon`,
`c`.`latin`,
concat('[',SUBSTRING(`child`.`interested`,1,CHAR_LENGTH(`child`.`interested`) - 1),']') AS `interested`,
`treefather`.`id` AS `treefatherId`,
`treefather`.`uid` AS `treefatherUid`,
`treefather`.`data` AS `treefather`,
`treefather`.`public` AS `treefatherPublic`,
`treefather`.`notown` AS `treefatherNotown`,
`treemother`.`id` AS `treemotherId`,
`treemother`.`uid` AS `treemotherUid`,
`treemother`.`data` AS `treemother`,
`treemother`.`public` AS `treemotherPublic`,
`treemother`.`notown` AS `treemotherNotown`,
`child`.`day_last_edit` AS `meday_last_edit`
FROM `animals` AS `child`
LEFT JOIN (`animals` AS `treefather`) ON (`treefather`.`id`=child.father_id)
LEFT JOIN (`animals` AS `treemother`) ON (`treemother`.`id`=child.mother_id)
LEFT JOIN (`category` AS `c`) ON (`c`.`id` = `child`.`cid`)
LEFT JOIN (`lang` AS `l2`) ON (`l2`.`id` = `c`.`name`)
LEFT JOIN (`breed` AS `b`) ON (`b`.`id` = SUBSTRING_INDEX(SUBSTRING_INDEX(`child`.`data`, '"breed":"', -1),'"', 1))
LEFT JOIN (`lang` AS `l`) ON (`l`.`id` = `b`.`name`)
WHERE `child`.`id`=9114SELECT
IF(`l`.`en`='',`l`.`hu`, `l`.`en`) AS `childBreed`,
`child`.`cid` AS `childCid`,
`child`.`uid` AS `childUid`,
`child`.`post_id` AS `childPost`,
`child`.`id` AS `childId`,
`child`.`data` AS `child`,
`child`.`public` AS `childPublic`,
`child`.`notown` AS `childNotown`,
`child`.`offspringsLength` AS `childoffspringsLength`,
`child`.`offspringsLitter` AS `childoffspringsLitter`,
IF(`l2`.`en`='',`l2`.`hu`, `l2`.`en`) AS `breedName`,
`c`.`species` AS `breedSpecies`,
`c`.`categorys` AS `breedCategorys`,
`c`.`icon` AS `breedicon`,
`c`.`latin`,
concat('[',SUBSTRING(`child`.`interested`,1,CHAR_LENGTH(`child`.`interested`) - 1),']') AS `interested`,
`treefather`.`id` AS `treefatherId`,
`treefather`.`uid` AS `treefatherUid`,
`treefather`.`data` AS `treefather`,
`treefather`.`public` AS `treefatherPublic`,
`treefather`.`notown` AS `treefatherNotown`,
`treemother`.`id` AS `treemotherId`,
`treemother`.`uid` AS `treemotherUid`,
`treemother`.`data` AS `treemother`,
`treemother`.`public` AS `treemotherPublic`,
`treemother`.`notown` AS `treemotherNotown`,
`child`.`day_last_edit` AS `meday_last_edit`
FROM `animals` AS `child`
LEFT JOIN (`animals` AS `treefather`) ON (`treefather`.`id`=child.father_id)
LEFT JOIN (`animals` AS `treemother`) ON (`treemother`.`id`=child.mother_id)
LEFT JOIN (`category` AS `c`) ON (`c`.`id` = `child`.`cid`)
LEFT JOIN (`lang` AS `l2`) ON (`l2`.`id` = `c`.`name`)
LEFT JOIN (`breed` AS `b`) ON (`b`.`id` = SUBSTRING_INDEX(SUBSTRING_INDEX(`child`.`data`, '"breed":"', -1),'"', 1))
LEFT JOIN (`lang` AS `l`) ON (`l`.`id` = `b`.`name`)
WHERE `child`.`id`=9115SELECT
IF(`l`.`en`='',`l`.`hu`, `l`.`en`) AS `childBreed`,
`child`.`cid` AS `childCid`,
`child`.`uid` AS `childUid`,
`child`.`post_id` AS `childPost`,
`child`.`id` AS `childId`,
`child`.`data` AS `child`,
`child`.`public` AS `childPublic`,
`child`.`notown` AS `childNotown`,
`child`.`offspringsLength` AS `childoffspringsLength`,
`child`.`offspringsLitter` AS `childoffspringsLitter`,
IF(`l2`.`en`='',`l2`.`hu`, `l2`.`en`) AS `breedName`,
`c`.`species` AS `breedSpecies`,
`c`.`categorys` AS `breedCategorys`,
`c`.`icon` AS `breedicon`,
`c`.`latin`,
concat('[',SUBSTRING(`child`.`interested`,1,CHAR_LENGTH(`child`.`interested`) - 1),']') AS `interested`,
`treefather`.`id` AS `treefatherId`,
`treefather`.`uid` AS `treefatherUid`,
`treefather`.`data` AS `treefather`,
`treefather`.`public` AS `treefatherPublic`,
`treefather`.`notown` AS `treefatherNotown`,
`treemother`.`id` AS `treemotherId`,
`treemother`.`uid` AS `treemotherUid`,
`treemother`.`data` AS `treemother`,
`treemother`.`public` AS `treemotherPublic`,
`treemother`.`notown` AS `treemotherNotown`,
`child`.`day_last_edit` AS `meday_last_edit`
FROM `animals` AS `child`
LEFT JOIN (`animals` AS `treefather`) ON (`treefather`.`id`=child.father_id)
LEFT JOIN (`animals` AS `treemother`) ON (`treemother`.`id`=child.mother_id)
LEFT JOIN (`category` AS `c`) ON (`c`.`id` = `child`.`cid`)
LEFT JOIN (`lang` AS `l2`) ON (`l2`.`id` = `c`.`name`)
LEFT JOIN (`breed` AS `b`) ON (`b`.`id` = SUBSTRING_INDEX(SUBSTRING_INDEX(`child`.`data`, '"breed":"', -1),'"', 1))
LEFT JOIN (`lang` AS `l`) ON (`l`.`id` = `b`.`name`)
WHERE `child`.`id`=9098SELECT
IF(`l`.`en`='',`l`.`hu`, `l`.`en`) AS `childBreed`,
`child`.`cid` AS `childCid`,
`child`.`uid` AS `childUid`,
`child`.`post_id` AS `childPost`,
`child`.`id` AS `childId`,
`child`.`data` AS `child`,
`child`.`public` AS `childPublic`,
`child`.`notown` AS `childNotown`,
`child`.`offspringsLength` AS `childoffspringsLength`,
`child`.`offspringsLitter` AS `childoffspringsLitter`,
IF(`l2`.`en`='',`l2`.`hu`, `l2`.`en`) AS `breedName`,
`c`.`species` AS `breedSpecies`,
`c`.`categorys` AS `breedCategorys`,
`c`.`icon` AS `breedicon`,
`c`.`latin`,
concat('[',SUBSTRING(`child`.`interested`,1,CHAR_LENGTH(`child`.`interested`) - 1),']') AS `interested`,
`treefather`.`id` AS `treefatherId`,
`treefather`.`uid` AS `treefatherUid`,
`treefather`.`data` AS `treefather`,
`treefather`.`public` AS `treefatherPublic`,
`treefather`.`notown` AS `treefatherNotown`,
`treemother`.`id` AS `treemotherId`,
`treemother`.`uid` AS `treemotherUid`,
`treemother`.`data` AS `treemother`,
`treemother`.`public` AS `treemotherPublic`,
`treemother`.`notown` AS `treemotherNotown`,
`child`.`day_last_edit` AS `meday_last_edit`
FROM `animals` AS `child`
LEFT JOIN (`animals` AS `treefather`) ON (`treefather`.`id`=child.father_id)
LEFT JOIN (`animals` AS `treemother`) ON (`treemother`.`id`=child.mother_id)
LEFT JOIN (`category` AS `c`) ON (`c`.`id` = `child`.`cid`)
LEFT JOIN (`lang` AS `l2`) ON (`l2`.`id` = `c`.`name`)
LEFT JOIN (`breed` AS `b`) ON (`b`.`id` = SUBSTRING_INDEX(SUBSTRING_INDEX(`child`.`data`, '"breed":"', -1),'"', 1))
LEFT JOIN (`lang` AS `l`) ON (`l`.`id` = `b`.`name`)
WHERE `child`.`id`=9102SELECT
IF(`l`.`en`='',`l`.`hu`, `l`.`en`) AS `childBreed`,
`child`.`cid` AS `childCid`,
`child`.`uid` AS `childUid`,
`child`.`post_id` AS `childPost`,
`child`.`id` AS `childId`,
`child`.`data` AS `child`,
`child`.`public` AS `childPublic`,
`child`.`notown` AS `childNotown`,
`child`.`offspringsLength` AS `childoffspringsLength`,
`child`.`offspringsLitter` AS `childoffspringsLitter`,
IF(`l2`.`en`='',`l2`.`hu`, `l2`.`en`) AS `breedName`,
`c`.`species` AS `breedSpecies`,
`c`.`categorys` AS `breedCategorys`,
`c`.`icon` AS `breedicon`,
`c`.`latin`,
concat('[',SUBSTRING(`child`.`interested`,1,CHAR_LENGTH(`child`.`interested`) - 1),']') AS `interested`,
`treefather`.`id` AS `treefatherId`,
`treefather`.`uid` AS `treefatherUid`,
`treefather`.`data` AS `treefather`,
`treefather`.`public` AS `treefatherPublic`,
`treefather`.`notown` AS `treefatherNotown`,
`treemother`.`id` AS `treemotherId`,
`treemother`.`uid` AS `treemotherUid`,
`treemother`.`data` AS `treemother`,
`treemother`.`public` AS `treemotherPublic`,
`treemother`.`notown` AS `treemotherNotown`,
`child`.`day_last_edit` AS `meday_last_edit`
FROM `animals` AS `child`
LEFT JOIN (`animals` AS `treefather`) ON (`treefather`.`id`=child.father_id)
LEFT JOIN (`animals` AS `treemother`) ON (`treemother`.`id`=child.mother_id)
LEFT JOIN (`category` AS `c`) ON (`c`.`id` = `child`.`cid`)
LEFT JOIN (`lang` AS `l2`) ON (`l2`.`id` = `c`.`name`)
LEFT JOIN (`breed` AS `b`) ON (`b`.`id` = SUBSTRING_INDEX(SUBSTRING_INDEX(`child`.`data`, '"breed":"', -1),'"', 1))
LEFT JOIN (`lang` AS `l`) ON (`l`.`id` = `b`.`name`)
WHERE `child`.`id`=9103SELECT
IF(`l`.`en`='',`l`.`hu`, `l`.`en`) AS `childBreed`,
`child`.`cid` AS `childCid`,
`child`.`uid` AS `childUid`,
`child`.`post_id` AS `childPost`,
`child`.`id` AS `childId`,
`child`.`data` AS `child`,
`child`.`public` AS `childPublic`,
`child`.`notown` AS `childNotown`,
`child`.`offspringsLength` AS `childoffspringsLength`,
`child`.`offspringsLitter` AS `childoffspringsLitter`,
IF(`l2`.`en`='',`l2`.`hu`, `l2`.`en`) AS `breedName`,
`c`.`species` AS `breedSpecies`,
`c`.`categorys` AS `breedCategorys`,
`c`.`icon` AS `breedicon`,
`c`.`latin`,
concat('[',SUBSTRING(`child`.`interested`,1,CHAR_LENGTH(`child`.`interested`) - 1),']') AS `interested`,
`treefather`.`id` AS `treefatherId`,
`treefather`.`uid` AS `treefatherUid`,
`treefather`.`data` AS `treefather`,
`treefather`.`public` AS `treefatherPublic`,
`treefather`.`notown` AS `treefatherNotown`,
`treemother`.`id` AS `treemotherId`,
`treemother`.`uid` AS `treemotherUid`,
`treemother`.`data` AS `treemother`,
`treemother`.`public` AS `treemotherPublic`,
`treemother`.`notown` AS `treemotherNotown`,
`child`.`day_last_edit` AS `meday_last_edit`
FROM `animals` AS `child`
LEFT JOIN (`animals` AS `treefather`) ON (`treefather`.`id`=child.father_id)
LEFT JOIN (`animals` AS `treemother`) ON (`treemother`.`id`=child.mother_id)
LEFT JOIN (`category` AS `c`) ON (`c`.`id` = `child`.`cid`)
LEFT JOIN (`lang` AS `l2`) ON (`l2`.`id` = `c`.`name`)
LEFT JOIN (`breed` AS `b`) ON (`b`.`id` = SUBSTRING_INDEX(SUBSTRING_INDEX(`child`.`data`, '"breed":"', -1),'"', 1))
LEFT JOIN (`lang` AS `l`) ON (`l`.`id` = `b`.`name`)
WHERE `child`.`id`=9105SELECT
IF(`l`.`en`='',`l`.`hu`, `l`.`en`) AS `childBreed`,
`child`.`cid` AS `childCid`,
`child`.`uid` AS `childUid`,
`child`.`post_id` AS `childPost`,
`child`.`id` AS `childId`,
`child`.`data` AS `child`,
`child`.`public` AS `childPublic`,
`child`.`notown` AS `childNotown`,
`child`.`offspringsLength` AS `childoffspringsLength`,
`child`.`offspringsLitter` AS `childoffspringsLitter`,
IF(`l2`.`en`='',`l2`.`hu`, `l2`.`en`) AS `breedName`,
`c`.`species` AS `breedSpecies`,
`c`.`categorys` AS `breedCategorys`,
`c`.`icon` AS `breedicon`,
`c`.`latin`,
concat('[',SUBSTRING(`child`.`interested`,1,CHAR_LENGTH(`child`.`interested`) - 1),']') AS `interested`,
`treefather`.`id` AS `treefatherId`,
`treefather`.`uid` AS `treefatherUid`,
`treefather`.`data` AS `treefather`,
`treefather`.`public` AS `treefatherPublic`,
`treefather`.`notown` AS `treefatherNotown`,
`treemother`.`id` AS `treemotherId`,
`treemother`.`uid` AS `treemotherUid`,
`treemother`.`data` AS `treemother`,
`treemother`.`public` AS `treemotherPublic`,
`treemother`.`notown` AS `treemotherNotown`,
`child`.`day_last_edit` AS `meday_last_edit`
FROM `animals` AS `child`
LEFT JOIN (`animals` AS `treefather`) ON (`treefather`.`id`=child.father_id)
LEFT JOIN (`animals` AS `treemother`) ON (`treemother`.`id`=child.mother_id)
LEFT JOIN (`category` AS `c`) ON (`c`.`id` = `child`.`cid`)
LEFT JOIN (`lang` AS `l2`) ON (`l2`.`id` = `c`.`name`)
LEFT JOIN (`breed` AS `b`) ON (`b`.`id` = SUBSTRING_INDEX(SUBSTRING_INDEX(`child`.`data`, '"breed":"', -1),'"', 1))
LEFT JOIN (`lang` AS `l`) ON (`l`.`id` = `b`.`name`)
WHERE `child`.`id`=9106SELECT
IF(`l`.`en`='',`l`.`hu`, `l`.`en`) AS `childBreed`,
`child`.`cid` AS `childCid`,
`child`.`uid` AS `childUid`,
`child`.`post_id` AS `childPost`,
`child`.`id` AS `childId`,
`child`.`data` AS `child`,
`child`.`public` AS `childPublic`,
`child`.`notown` AS `childNotown`,
`child`.`offspringsLength` AS `childoffspringsLength`,
`child`.`offspringsLitter` AS `childoffspringsLitter`,
IF(`l2`.`en`='',`l2`.`hu`, `l2`.`en`) AS `breedName`,
`c`.`species` AS `breedSpecies`,
`c`.`categorys` AS `breedCategorys`,
`c`.`icon` AS `breedicon`,
`c`.`latin`,
concat('[',SUBSTRING(`child`.`interested`,1,CHAR_LENGTH(`child`.`interested`) - 1),']') AS `interested`,
`treefather`.`id` AS `treefatherId`,
`treefather`.`uid` AS `treefatherUid`,
`treefather`.`data` AS `treefather`,
`treefather`.`public` AS `treefatherPublic`,
`treefather`.`notown` AS `treefatherNotown`,
`treemother`.`id` AS `treemotherId`,
`treemother`.`uid` AS `treemotherUid`,
`treemother`.`data` AS `treemother`,
`treemother`.`public` AS `treemotherPublic`,
`treemother`.`notown` AS `treemotherNotown`,
`child`.`day_last_edit` AS `meday_last_edit`
FROM `animals` AS `child`
LEFT JOIN (`animals` AS `treefather`) ON (`treefather`.`id`=child.father_id)
LEFT JOIN (`animals` AS `treemother`) ON (`treemother`.`id`=child.mother_id)
LEFT JOIN (`category` AS `c`) ON (`c`.`id` = `child`.`cid`)
LEFT JOIN (`lang` AS `l2`) ON (`l2`.`id` = `c`.`name`)
LEFT JOIN (`breed` AS `b`) ON (`b`.`id` = SUBSTRING_INDEX(SUBSTRING_INDEX(`child`.`data`, '"breed":"', -1),'"', 1))
LEFT JOIN (`lang` AS `l`) ON (`l`.`id` = `b`.`name`)
WHERE `child`.`id`=6628SELECT
IF(`l`.`en`='',`l`.`hu`, `l`.`en`) AS `childBreed`,
`child`.`cid` AS `childCid`,
`child`.`uid` AS `childUid`,
`child`.`post_id` AS `childPost`,
`child`.`id` AS `childId`,
`child`.`data` AS `child`,
`child`.`public` AS `childPublic`,
`child`.`notown` AS `childNotown`,
`child`.`offspringsLength` AS `childoffspringsLength`,
`child`.`offspringsLitter` AS `childoffspringsLitter`,
IF(`l2`.`en`='',`l2`.`hu`, `l2`.`en`) AS `breedName`,
`c`.`species` AS `breedSpecies`,
`c`.`categorys` AS `breedCategorys`,
`c`.`icon` AS `breedicon`,
`c`.`latin`,
concat('[',SUBSTRING(`child`.`interested`,1,CHAR_LENGTH(`child`.`interested`) - 1),']') AS `interested`,
`treefather`.`id` AS `treefatherId`,
`treefather`.`uid` AS `treefatherUid`,
`treefather`.`data` AS `treefather`,
`treefather`.`public` AS `treefatherPublic`,
`treefather`.`notown` AS `treefatherNotown`,
`treemother`.`id` AS `treemotherId`,
`treemother`.`uid` AS `treemotherUid`,
`treemother`.`data` AS `treemother`,
`treemother`.`public` AS `treemotherPublic`,
`treemother`.`notown` AS `treemotherNotown`,
`child`.`day_last_edit` AS `meday_last_edit`
FROM `animals` AS `child`
LEFT JOIN (`animals` AS `treefather`) ON (`treefather`.`id`=child.father_id)
LEFT JOIN (`animals` AS `treemother`) ON (`treemother`.`id`=child.mother_id)
LEFT JOIN (`category` AS `c`) ON (`c`.`id` = `child`.`cid`)
LEFT JOIN (`lang` AS `l2`) ON (`l2`.`id` = `c`.`name`)
LEFT JOIN (`breed` AS `b`) ON (`b`.`id` = SUBSTRING_INDEX(SUBSTRING_INDEX(`child`.`data`, '"breed":"', -1),'"', 1))
LEFT JOIN (`lang` AS `l`) ON (`l`.`id` = `b`.`name`)
WHERE `child`.`id`=10378SELECT
IF(`l`.`en`='',`l`.`hu`, `l`.`en`) AS `childBreed`,
`child`.`cid` AS `childCid`,
`child`.`uid` AS `childUid`,
`child`.`post_id` AS `childPost`,
`child`.`id` AS `childId`,
`child`.`data` AS `child`,
`child`.`public` AS `childPublic`,
`child`.`notown` AS `childNotown`,
`child`.`offspringsLength` AS `childoffspringsLength`,
`child`.`offspringsLitter` AS `childoffspringsLitter`,
IF(`l2`.`en`='',`l2`.`hu`, `l2`.`en`) AS `breedName`,
`c`.`species` AS `breedSpecies`,
`c`.`categorys` AS `breedCategorys`,
`c`.`icon` AS `breedicon`,
`c`.`latin`,
concat('[',SUBSTRING(`child`.`interested`,1,CHAR_LENGTH(`child`.`interested`) - 1),']') AS `interested`,
`treefather`.`id` AS `treefatherId`,
`treefather`.`uid` AS `treefatherUid`,
`treefather`.`data` AS `treefather`,
`treefather`.`public` AS `treefatherPublic`,
`treefather`.`notown` AS `treefatherNotown`,
`treemother`.`id` AS `treemotherId`,
`treemother`.`uid` AS `treemotherUid`,
`treemother`.`data` AS `treemother`,
`treemother`.`public` AS `treemotherPublic`,
`treemother`.`notown` AS `treemotherNotown`,
`child`.`day_last_edit` AS `meday_last_edit`
FROM `animals` AS `child`
LEFT JOIN (`animals` AS `treefather`) ON (`treefather`.`id`=child.father_id)
LEFT JOIN (`animals` AS `treemother`) ON (`treemother`.`id`=child.mother_id)
LEFT JOIN (`category` AS `c`) ON (`c`.`id` = `child`.`cid`)
LEFT JOIN (`lang` AS `l2`) ON (`l2`.`id` = `c`.`name`)
LEFT JOIN (`breed` AS `b`) ON (`b`.`id` = SUBSTRING_INDEX(SUBSTRING_INDEX(`child`.`data`, '"breed":"', -1),'"', 1))
LEFT JOIN (`lang` AS `l`) ON (`l`.`id` = `b`.`name`)
WHERE `child`.`id`=10379SELECT
IF(`l`.`en`='',`l`.`hu`, `l`.`en`) AS `childBreed`,
`child`.`cid` AS `childCid`,
`child`.`uid` AS `childUid`,
`child`.`post_id` AS `childPost`,
`child`.`id` AS `childId`,
`child`.`data` AS `child`,
`child`.`public` AS `childPublic`,
`child`.`notown` AS `childNotown`,
`child`.`offspringsLength` AS `childoffspringsLength`,
`child`.`offspringsLitter` AS `childoffspringsLitter`,
IF(`l2`.`en`='',`l2`.`hu`, `l2`.`en`) AS `breedName`,
`c`.`species` AS `breedSpecies`,
`c`.`categorys` AS `breedCategorys`,
`c`.`icon` AS `breedicon`,
`c`.`latin`,
concat('[',SUBSTRING(`child`.`interested`,1,CHAR_LENGTH(`child`.`interested`) - 1),']') AS `interested`,
`treefather`.`id` AS `treefatherId`,
`treefather`.`uid` AS `treefatherUid`,
`treefather`.`data` AS `treefather`,
`treefather`.`public` AS `treefatherPublic`,
`treefather`.`notown` AS `treefatherNotown`,
`treemother`.`id` AS `treemotherId`,
`treemother`.`uid` AS `treemotherUid`,
`treemother`.`data` AS `treemother`,
`treemother`.`public` AS `treemotherPublic`,
`treemother`.`notown` AS `treemotherNotown`,
`child`.`day_last_edit` AS `meday_last_edit`
FROM `animals` AS `child`
LEFT JOIN (`animals` AS `treefather`) ON (`treefather`.`id`=child.father_id)
LEFT JOIN (`animals` AS `treemother`) ON (`treemother`.`id`=child.mother_id)
LEFT JOIN (`category` AS `c`) ON (`c`.`id` = `child`.`cid`)
LEFT JOIN (`lang` AS `l2`) ON (`l2`.`id` = `c`.`name`)
LEFT JOIN (`breed` AS `b`) ON (`b`.`id` = SUBSTRING_INDEX(SUBSTRING_INDEX(`child`.`data`, '"breed":"', -1),'"', 1))
LEFT JOIN (`lang` AS `l`) ON (`l`.`id` = `b`.`name`)
WHERE `child`.`id`=12832SELECT
IF(`l`.`en`='',`l`.`hu`, `l`.`en`) AS `childBreed`,
`child`.`cid` AS `childCid`,
`child`.`uid` AS `childUid`,
`child`.`post_id` AS `childPost`,
`child`.`id` AS `childId`,
`child`.`data` AS `child`,
`child`.`public` AS `childPublic`,
`child`.`notown` AS `childNotown`,
`child`.`offspringsLength` AS `childoffspringsLength`,
`child`.`offspringsLitter` AS `childoffspringsLitter`,
IF(`l2`.`en`='',`l2`.`hu`, `l2`.`en`) AS `breedName`,
`c`.`species` AS `breedSpecies`,
`c`.`categorys` AS `breedCategorys`,
`c`.`icon` AS `breedicon`,
`c`.`latin`,
concat('[',SUBSTRING(`child`.`interested`,1,CHAR_LENGTH(`child`.`interested`) - 1),']') AS `interested`,
`treefather`.`id` AS `treefatherId`,
`treefather`.`uid` AS `treefatherUid`,
`treefather`.`data` AS `treefather`,
`treefather`.`public` AS `treefatherPublic`,
`treefather`.`notown` AS `treefatherNotown`,
`treemother`.`id` AS `treemotherId`,
`treemother`.`uid` AS `treemotherUid`,
`treemother`.`data` AS `treemother`,
`treemother`.`public` AS `treemotherPublic`,
`treemother`.`notown` AS `treemotherNotown`,
`child`.`day_last_edit` AS `meday_last_edit`
FROM `animals` AS `child`
LEFT JOIN (`animals` AS `treefather`) ON (`treefather`.`id`=child.father_id)
LEFT JOIN (`animals` AS `treemother`) ON (`treemother`.`id`=child.mother_id)
LEFT JOIN (`category` AS `c`) ON (`c`.`id` = `child`.`cid`)
LEFT JOIN (`lang` AS `l2`) ON (`l2`.`id` = `c`.`name`)
LEFT JOIN (`breed` AS `b`) ON (`b`.`id` = SUBSTRING_INDEX(SUBSTRING_INDEX(`child`.`data`, '"breed":"', -1),'"', 1))
LEFT JOIN (`lang` AS `l`) ON (`l`.`id` = `b`.`name`)
WHERE `child`.`id`=12833
View it enlarged