private function fooBar()
{
$str_0 = '';
$str_1 = '';
$str_2 = '';
$y = 0;
for($x = 1; $x <= 30; $x++) {
if($x % 2 !== 0) {
$str_1 .= $x . ',';
} else {
$str_2 .= $x . ',';
}
$y++;
if($y == 10) {
$str_0 .= $str_2 . $str_1;
$str_1 = '';
$str_2 = '';
$y = 0;
}
}
return $str_0;
}
SELECT p0_.id AS id,
p0_.sku AS sku
FROM product p0_
LEFT JOIN product_color_group p7_ ON p0_.id = p7_.product_id
LEFT JOIN color_group c3_ ON c3_.id = p7_.color_group_id
LEFT JOIN product_color_group p8_ ON p0_.id = p8_.product_id
WHERE c3_.id IN (17, 15) AND p0_.dtype='wallpaper'
GROUP BY p0_.id
HAVING COUNT(p8_.color_group_id) = 1
ORDER BY p0_.id ASC
LIMIT 18;
SELECT p0_.id AS id,
p0_.sku AS sku
FROM product p0_
LEFT JOIN product_color_group p7_ ON p0_.id = p7_.product_id
LEFT JOIN color_group c3_ ON c3_.id = p7_.color_group_id
LEFT JOIN product_color_group p8_ ON p0_.id = p8_.product_id
WHERE c3_.id IN (17, 15) AND p0_.dtype='wallpaper'
GROUP BY p0_.id
HAVING COUNT(p8_.color_group_id) = 1
ORDER BY p0_.id ASC
LIMIT 18;