SELECT p.*,t2.*,t3.* FROM product AS p,t2,t3
LEFT JOIN t2 ON t2.prid = p.prid
LEFT JOIN t3 ON t3.prid = p.prid

SELECT `p`.*, `pn`.*, `i`.* FROM `product` `p` 
LEFT JOIN `product_namefeat_value` `pn` ON `p`.`prid` = `pn`.`prid`
LEFT JOIN `images` `i` ON `p`.`prid` = `i`.`prid`;

Array
(
    [prid] => 
    [name] => Купон на билет
    [namefeat] => Номер
    [feat] => number
    [featval] => eb80753e24ff80e69928
    [image] => 
)

CREATE TABLE IF NOT EXISTS `images` (
  `prid` int(11) DEFAULT NULL,
  `image` varchar(100) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;


CREATE TABLE IF NOT EXISTS `product` (
  `prid` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(80) NOT NULL,
  PRIMARY KEY (`prid`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=142 ;

INSERT INTO `product` (`prid`, `name`) VALUES
(141, 'Товар');


CREATE TABLE IF NOT EXISTS `product_namefeat_value` (
  `prid` int(11) DEFAULT NULL,
  `namefeat` varchar(300) DEFAULT NULL,
  `feat` varchar(300) DEFAULT NULL,
  `featval` varchar(300) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;



INSERT INTO `product_namefeat_value` (`prid`, `namefeat`, `feat`, `featval`) VALUES
(141, 'Номер', 'number', 'eb80753e24ff80e69928'),
(141, 'Наименование', 'name', 'Купон на билет'),
(141, 'Псевдоним', 'pseudonim', 'kupon_na_bilet'),
(141, 'Количество', 'count', '1'),
(141, 'Категория', 'catid', '21'),
(141, 'Описание', 'description', 'фыв');

select p.*, i.image, pnv.namefeat, pnv.feat, pnv.featval
from product p
left join images i on i.prid = p.prid
left join product_namefeat_value pnv on pnv.prid = p.prid