SELECT c.* FROM yew.product_categories c2 LEFT JOIN yew.ipSites ip ON ip.catid = c2.catid LEFT JOIN yew.product_categories c ON c2.lft < c.lft AND c2.rgt > c.rgt WHERE c.filename LIKE 'mens-driver%' AND ip.siteid = " 2 " LIMIT 3 Array ( [0] => Array ( [catid] => 125 [type] => Mens Driver [parent] => 1557 [lft] => 890 [rgt] => 891 [description] => [descriptionMore] => [filename] => mens-drivers [category] => Drivers [standAloneName] => Men's Drivers [keywords] => [popular] => 0 [amazon] => [shopcart] => 0 [valid] => Y [specials] => N [aliasOf] => 0 [metaid] => 475 [nsName] => 125 dgw/golfequipment/golf-clubs/mens-golf-equipment/mens-drivers [nsRecordId] => 314 ) )