CREATE TABLE `par` (
`id` TINYINT AUTO_INCREMENT,
`titl` TINYTEXT,
PRIMARY KEY (id)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251;
CREATE TABLE `chil` (
`id` SMALLINT AUTO_INCREMENT,
`par_id` TINYINT,
`txt` TINYTEXT,
PRIMARY KEY (id)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251;
INSERT INTO par VALUES
(NULL, "раз"),
(NULL, "два"),
(NULL, "три"),
(NULL, "четыре");
INSERT INTO chil VALUES
(NULL, 1, "1_раз"),
(NULL, 1, "2_раз"),
(NULL, 2, "1_два"),
(NULL, 2, "2_два"),
(NULL, 2, "3_два"),
(NULL, 2, "4_два"),
(NULL, 3, "1_три"),
(NULL, 5, "1_пять"),
(NULL, 5, "2_пять"),
(NULL, 1, "3_раз");
SELECT a.id, a.titl, b.txt
FROM chil b LEFT JOIN par a
ON a.id = b.par_id
WHERE a.id
GROUP BY a.id, b.id
HAVING
IFNULL(@x, @x := a.id) AND IFNULL(@z, @z := 1) AND
IF(@x = a.id
, ((@z := (1+@z)) AND @z < 4)
, ((@x := a.id) AND @z := 1));
DROP TABLE par;
DROP TABLE chil;
|