/var/www/html/nox-modules/prints
/lib/action/frontend
/printsSearchDefaultAction.action.php
main
SELECT COUNT(*) as `count` FROM prints_set WHERE id IN(SELECT DISTINCT set_id FROM prints_set_vector WHERE vector_id IN(10826,10827,10828,10829,10830,10831,10832,10833,1064,2374,2375,2376,2377,2378,2379,2390,2396,2397,2724,2725,2729,2730,2731,2732,2733,2762,2769,2770,4151,4483,4484,4502,4503,4522,4525,4949,4951,5016,5017,5018,5019,5020,5021,5045,5046,5047,5048,5049,5059,6107,6108,10430,10431,10432,10433,10468,10469,10500,10501,10502,10503,10770,10771,11041,11043,11324,11325,11350,11351,11388,11516,12256,28504,30839,31123,30087))
SELECT `id`, `url`, `name_title`, `name_full`, `id_new`, `market`, `tier`, `update_date`, `segment` FROM prints_set WHERE id IN(SELECT DISTINCT set_id FROM prints_set_vector WHERE vector_id IN(10826,10827,10828,10829,10830,10831,10832,10833,1064,2374,2375,2376,2377,2378,2379,2390,2396,2397,2724,2725,2729,2730,2731,2732,2733,2762,2769,2770,4151,4483,4484,4502,4503,4522,4525,4949,4951,5016,5017,5018,5019,5020,5021,5045,5046,5047,5048,5049,5059,6107,6108,10430,10431,10432,10433,10468,10469,10500,10501,10502,10503,10770,10771,11041,11043,11324,11325,11350,11351,11388,11516,12256,28504,30839,31123,30087)) LIMIT 0, 30
SELECT `prints_set`.`id`, `prints_set`.`url`, `prints_set`.`name_full`, COUNT(`vector_id`) c, MIN(`price`) price, IF((SELECT `preview` FROM `prints_vector` WHERE `id` IN(SELECT `vector_id` FROM `prints_set_vector` WHERE `set_id` = `prints_set`.`id`) AND `prepay` = 0 AND `bundle` = 0 AND `preview` != "" ORDER BY CAST(JSON_EXTRACT(`prm`, "$.year") AS UNSIGNED) DESC LIMIT 1) IS NOT NULL, (SELECT `preview` FROM `prints_vector` WHERE `id` IN(SELECT `vector_id` FROM `prints_set_vector` WHERE `set_id` = `prints_set`.`id`) AND `prepay` = 0 AND `bundle` = 0 AND `preview` != "" ORDER BY CAST(JSON_EXTRACT(`prm`, "$.year") AS UNSIGNED) DESC LIMIT 1), (SELECT `preview` FROM `prints_vector` WHERE `id` IN(SELECT `vector_id` FROM `prints_set_vector` WHERE `set_id` = `prints_set`.`id`) AND `bundle` = 0 AND `preview` != "" ORDER BY CAST(JSON_EXTRACT(`prm`, "$.year") AS UNSIGNED) DESC LIMIT 1)) as preview, IF((SELECT `preview` FROM `prints_vector` WHERE `id` IN(SELECT `vector_id` FROM `prints_set_vector` WHERE `set_id` = `prints_set`.`id`) AND `prepay` = 0 AND `bundle` = 0 AND `preview` != "" ORDER BY CAST(JSON_EXTRACT(`prm`, "$.year") AS UNSIGNED) DESC LIMIT 1) IS NOT NULL, 1, 0) as vector FROM `prints_set` LEFT JOIN `prints_set_vector` ON `prints_set`.`id` = `prints_set_vector`.`set_id` LEFT JOIN `prints_vector` ON `prints_vector`.`id` = `prints_set_vector`.`vector_id` WHERE `prints_set`.`id` IN(34712, 29460, 35976, 33366, 34212, 32390, 34921, 34197, 5231, 5245, 10785, 34924, 5581, 34226, 34228, 34230, 31090, 5676, 6690, 34964, 10581, 10625, 10988, 29339, 33891, 34902, 11501, 11626, 12368) GROUP BY `prints_set`.`id` ORDER BY IF(MAX(`prints_vector`.`preview`) IS NOT NULL AND MAX(`prints_vector`.`preview`) != '', 0, 1), `prints_set`.`name_full`
SELECT COUNT(*) cnt FROM `prints_set_vector` INNER JOIN `prints_vector` ON `prints_vector`.`id` = `prints_set_vector`.`vector_id` WHERE `prints_set_vector`.`set_id` = 10988 AND `prints_set_vector`.`vector_id` IN(10826,10827,10828,10829,10830,10831,10832,10833,1064,2374,2375,2376,2377,2378,2379,2390,2396,2397,2724,2725,2729,2730,2731,2732,2733,2762,2769,2770,4151,4483,4484,4502,4503,4522,4525,4949,4951,5016,5017,5018,5019,5020,5021,5045,5046,5047,5048,5049,5059,6107,6108,10430,10431,10432,10433,10468,10469,10500,10501,10502,10503,10770,10771,11041,11043,11324,11325,11350,11351,11388,11516,12256,28504,30839,31123,30087) AND `prints_vector`.`bundle` = 0
SELECT COUNT(*) cnt FROM `prints_set_vector` INNER JOIN `prints_vector` ON `prints_vector`.`id` = `prints_set_vector`.`vector_id` WHERE `prints_set_vector`.`set_id` = 34964 AND `prints_set_vector`.`vector_id` IN(10826,10827,10828,10829,10830,10831,10832,10833,1064,2374,2375,2376,2377,2378,2379,2390,2396,2397,2724,2725,2729,2730,2731,2732,2733,2762,2769,2770,4151,4483,4484,4502,4503,4522,4525,4949,4951,5016,5017,5018,5019,5020,5021,5045,5046,5047,5048,5049,5059,6107,6108,10430,10431,10432,10433,10468,10469,10500,10501,10502,10503,10770,10771,11041,11043,11324,11325,11350,11351,11388,11516,12256,28504,30839,31123,30087) AND `prints_vector`.`bundle` = 0
SELECT COUNT(*) cnt FROM `prints_set_vector` INNER JOIN `prints_vector` ON `prints_vector`.`id` = `prints_set_vector`.`vector_id` WHERE `prints_set_vector`.`set_id` = 5245 AND `prints_set_vector`.`vector_id` IN(10826,10827,10828,10829,10830,10831,10832,10833,1064,2374,2375,2376,2377,2378,2379,2390,2396,2397,2724,2725,2729,2730,2731,2732,2733,2762,2769,2770,4151,4483,4484,4502,4503,4522,4525,4949,4951,5016,5017,5018,5019,5020,5021,5045,5046,5047,5048,5049,5059,6107,6108,10430,10431,10432,10433,10468,10469,10500,10501,10502,10503,10770,10771,11041,11043,11324,11325,11350,11351,11388,11516,12256,28504,30839,31123,30087) AND `prints_vector`.`bundle` = 0
SELECT COUNT(*) cnt FROM `prints_set_vector` INNER JOIN `prints_vector` ON `prints_vector`.`id` = `prints_set_vector`.`vector_id` WHERE `prints_set_vector`.`set_id` = 34924 AND `prints_set_vector`.`vector_id` IN(10826,10827,10828,10829,10830,10831,10832,10833,1064,2374,2375,2376,2377,2378,2379,2390,2396,2397,2724,2725,2729,2730,2731,2732,2733,2762,2769,2770,4151,4483,4484,4502,4503,4522,4525,4949,4951,5016,5017,5018,5019,5020,5021,5045,5046,5047,5048,5049,5059,6107,6108,10430,10431,10432,10433,10468,10469,10500,10501,10502,10503,10770,10771,11041,11043,11324,11325,11350,11351,11388,11516,12256,28504,30839,31123,30087) AND `prints_vector`.`bundle` = 0
SELECT COUNT(*) cnt FROM `prints_set_vector` INNER JOIN `prints_vector` ON `prints_vector`.`id` = `prints_set_vector`.`vector_id` WHERE `prints_set_vector`.`set_id` = 29460 AND `prints_set_vector`.`vector_id` IN(10826,10827,10828,10829,10830,10831,10832,10833,1064,2374,2375,2376,2377,2378,2379,2390,2396,2397,2724,2725,2729,2730,2731,2732,2733,2762,2769,2770,4151,4483,4484,4502,4503,4522,4525,4949,4951,5016,5017,5018,5019,5020,5021,5045,5046,5047,5048,5049,5059,6107,6108,10430,10431,10432,10433,10468,10469,10500,10501,10502,10503,10770,10771,11041,11043,11324,11325,11350,11351,11388,11516,12256,28504,30839,31123,30087) AND `prints_vector`.`bundle` = 0
SELECT COUNT(*) cnt FROM `prints_set_vector` INNER JOIN `prints_vector` ON `prints_vector`.`id` = `prints_set_vector`.`vector_id` WHERE `prints_set_vector`.`set_id` = 34712 AND `prints_set_vector`.`vector_id` IN(10826,10827,10828,10829,10830,10831,10832,10833,1064,2374,2375,2376,2377,2378,2379,2390,2396,2397,2724,2725,2729,2730,2731,2732,2733,2762,2769,2770,4151,4483,4484,4502,4503,4522,4525,4949,4951,5016,5017,5018,5019,5020,5021,5045,5046,5047,5048,5049,5059,6107,6108,10430,10431,10432,10433,10468,10469,10500,10501,10502,10503,10770,10771,11041,11043,11324,11325,11350,11351,11388,11516,12256,28504,30839,31123,30087) AND `prints_vector`.`bundle` = 0
SELECT COUNT(*) cnt FROM `prints_set_vector` INNER JOIN `prints_vector` ON `prints_vector`.`id` = `prints_set_vector`.`vector_id` WHERE `prints_set_vector`.`set_id` = 10581 AND `prints_set_vector`.`vector_id` IN(10826,10827,10828,10829,10830,10831,10832,10833,1064,2374,2375,2376,2377,2378,2379,2390,2396,2397,2724,2725,2729,2730,2731,2732,2733,2762,2769,2770,4151,4483,4484,4502,4503,4522,4525,4949,4951,5016,5017,5018,5019,5020,5021,5045,5046,5047,5048,5049,5059,6107,6108,10430,10431,10432,10433,10468,10469,10500,10501,10502,10503,10770,10771,11041,11043,11324,11325,11350,11351,11388,11516,12256,28504,30839,31123,30087) AND `prints_vector`.`bundle` = 0
SELECT COUNT(*) cnt FROM `prints_set_vector` INNER JOIN `prints_vector` ON `prints_vector`.`id` = `prints_set_vector`.`vector_id` WHERE `prints_set_vector`.`set_id` = 6690 AND `prints_set_vector`.`vector_id` IN(10826,10827,10828,10829,10830,10831,10832,10833,1064,2374,2375,2376,2377,2378,2379,2390,2396,2397,2724,2725,2729,2730,2731,2732,2733,2762,2769,2770,4151,4483,4484,4502,4503,4522,4525,4949,4951,5016,5017,5018,5019,5020,5021,5045,5046,5047,5048,5049,5059,6107,6108,10430,10431,10432,10433,10468,10469,10500,10501,10502,10503,10770,10771,11041,11043,11324,11325,11350,11351,11388,11516,12256,28504,30839,31123,30087) AND `prints_vector`.`bundle` = 0
SELECT COUNT(*) cnt FROM `prints_set_vector` INNER JOIN `prints_vector` ON `prints_vector`.`id` = `prints_set_vector`.`vector_id` WHERE `prints_set_vector`.`set_id` = 33366 AND `prints_set_vector`.`vector_id` IN(10826,10827,10828,10829,10830,10831,10832,10833,1064,2374,2375,2376,2377,2378,2379,2390,2396,2397,2724,2725,2729,2730,2731,2732,2733,2762,2769,2770,4151,4483,4484,4502,4503,4522,4525,4949,4951,5016,5017,5018,5019,5020,5021,5045,5046,5047,5048,5049,5059,6107,6108,10430,10431,10432,10433,10468,10469,10500,10501,10502,10503,10770,10771,11041,11043,11324,11325,11350,11351,11388,11516,12256,28504,30839,31123,30087) AND `prints_vector`.`bundle` = 0
SELECT COUNT(*) cnt FROM `prints_set_vector` INNER JOIN `prints_vector` ON `prints_vector`.`id` = `prints_set_vector`.`vector_id` WHERE `prints_set_vector`.`set_id` = 10785 AND `prints_set_vector`.`vector_id` IN(10826,10827,10828,10829,10830,10831,10832,10833,1064,2374,2375,2376,2377,2378,2379,2390,2396,2397,2724,2725,2729,2730,2731,2732,2733,2762,2769,2770,4151,4483,4484,4502,4503,4522,4525,4949,4951,5016,5017,5018,5019,5020,5021,5045,5046,5047,5048,5049,5059,6107,6108,10430,10431,10432,10433,10468,10469,10500,10501,10502,10503,10770,10771,11041,11043,11324,11325,11350,11351,11388,11516,12256,28504,30839,31123,30087) AND `prints_vector`.`bundle` = 0
SELECT COUNT(*) cnt FROM `prints_set_vector` INNER JOIN `prints_vector` ON `prints_vector`.`id` = `prints_set_vector`.`vector_id` WHERE `prints_set_vector`.`set_id` = 34212 AND `prints_set_vector`.`vector_id` IN(10826,10827,10828,10829,10830,10831,10832,10833,1064,2374,2375,2376,2377,2378,2379,2390,2396,2397,2724,2725,2729,2730,2731,2732,2733,2762,2769,2770,4151,4483,4484,4502,4503,4522,4525,4949,4951,5016,5017,5018,5019,5020,5021,5045,5046,5047,5048,5049,5059,6107,6108,10430,10431,10432,10433,10468,10469,10500,10501,10502,10503,10770,10771,11041,11043,11324,11325,11350,11351,11388,11516,12256,28504,30839,31123,30087) AND `prints_vector`.`bundle` = 0
SELECT COUNT(*) cnt FROM `prints_set_vector` INNER JOIN `prints_vector` ON `prints_vector`.`id` = `prints_set_vector`.`vector_id` WHERE `prints_set_vector`.`set_id` = 34197 AND `prints_set_vector`.`vector_id` IN(10826,10827,10828,10829,10830,10831,10832,10833,1064,2374,2375,2376,2377,2378,2379,2390,2396,2397,2724,2725,2729,2730,2731,2732,2733,2762,2769,2770,4151,4483,4484,4502,4503,4522,4525,4949,4951,5016,5017,5018,5019,5020,5021,5045,5046,5047,5048,5049,5059,6107,6108,10430,10431,10432,10433,10468,10469,10500,10501,10502,10503,10770,10771,11041,11043,11324,11325,11350,11351,11388,11516,12256,28504,30839,31123,30087) AND `prints_vector`.`bundle` = 0
SELECT COUNT(*) cnt FROM `prints_set_vector` INNER JOIN `prints_vector` ON `prints_vector`.`id` = `prints_set_vector`.`vector_id` WHERE `prints_set_vector`.`set_id` = 34228 AND `prints_set_vector`.`vector_id` IN(10826,10827,10828,10829,10830,10831,10832,10833,1064,2374,2375,2376,2377,2378,2379,2390,2396,2397,2724,2725,2729,2730,2731,2732,2733,2762,2769,2770,4151,4483,4484,4502,4503,4522,4525,4949,4951,5016,5017,5018,5019,5020,5021,5045,5046,5047,5048,5049,5059,6107,6108,10430,10431,10432,10433,10468,10469,10500,10501,10502,10503,10770,10771,11041,11043,11324,11325,11350,11351,11388,11516,12256,28504,30839,31123,30087) AND `prints_vector`.`bundle` = 0
SELECT COUNT(*) cnt FROM `prints_set_vector` INNER JOIN `prints_vector` ON `prints_vector`.`id` = `prints_set_vector`.`vector_id` WHERE `prints_set_vector`.`set_id` = 5231 AND `prints_set_vector`.`vector_id` IN(10826,10827,10828,10829,10830,10831,10832,10833,1064,2374,2375,2376,2377,2378,2379,2390,2396,2397,2724,2725,2729,2730,2731,2732,2733,2762,2769,2770,4151,4483,4484,4502,4503,4522,4525,4949,4951,5016,5017,5018,5019,5020,5021,5045,5046,5047,5048,5049,5059,6107,6108,10430,10431,10432,10433,10468,10469,10500,10501,10502,10503,10770,10771,11041,11043,11324,11325,11350,11351,11388,11516,12256,28504,30839,31123,30087) AND `prints_vector`.`bundle` = 0
SELECT COUNT(*) cnt FROM `prints_set_vector` INNER JOIN `prints_vector` ON `prints_vector`.`id` = `prints_set_vector`.`vector_id` WHERE `prints_set_vector`.`set_id` = 29339 AND `prints_set_vector`.`vector_id` IN(10826,10827,10828,10829,10830,10831,10832,10833,1064,2374,2375,2376,2377,2378,2379,2390,2396,2397,2724,2725,2729,2730,2731,2732,2733,2762,2769,2770,4151,4483,4484,4502,4503,4522,4525,4949,4951,5016,5017,5018,5019,5020,5021,5045,5046,5047,5048,5049,5059,6107,6108,10430,10431,10432,10433,10468,10469,10500,10501,10502,10503,10770,10771,11041,11043,11324,11325,11350,11351,11388,11516,12256,28504,30839,31123,30087) AND `prints_vector`.`bundle` = 0
SELECT COUNT(*) cnt FROM `prints_set_vector` INNER JOIN `prints_vector` ON `prints_vector`.`id` = `prints_set_vector`.`vector_id` WHERE `prints_set_vector`.`set_id` = 33891 AND `prints_set_vector`.`vector_id` IN(10826,10827,10828,10829,10830,10831,10832,10833,1064,2374,2375,2376,2377,2378,2379,2390,2396,2397,2724,2725,2729,2730,2731,2732,2733,2762,2769,2770,4151,4483,4484,4502,4503,4522,4525,4949,4951,5016,5017,5018,5019,5020,5021,5045,5046,5047,5048,5049,5059,6107,6108,10430,10431,10432,10433,10468,10469,10500,10501,10502,10503,10770,10771,11041,11043,11324,11325,11350,11351,11388,11516,12256,28504,30839,31123,30087) AND `prints_vector`.`bundle` = 0
SELECT COUNT(*) cnt FROM `prints_set_vector` INNER JOIN `prints_vector` ON `prints_vector`.`id` = `prints_set_vector`.`vector_id` WHERE `prints_set_vector`.`set_id` = 12368 AND `prints_set_vector`.`vector_id` IN(10826,10827,10828,10829,10830,10831,10832,10833,1064,2374,2375,2376,2377,2378,2379,2390,2396,2397,2724,2725,2729,2730,2731,2732,2733,2762,2769,2770,4151,4483,4484,4502,4503,4522,4525,4949,4951,5016,5017,5018,5019,5020,5021,5045,5046,5047,5048,5049,5059,6107,6108,10430,10431,10432,10433,10468,10469,10500,10501,10502,10503,10770,10771,11041,11043,11324,11325,11350,11351,11388,11516,12256,28504,30839,31123,30087) AND `prints_vector`.`bundle` = 0
SELECT COUNT(*) cnt FROM `prints_set_vector` INNER JOIN `prints_vector` ON `prints_vector`.`id` = `prints_set_vector`.`vector_id` WHERE `prints_set_vector`.`set_id` = 34902 AND `prints_set_vector`.`vector_id` IN(10826,10827,10828,10829,10830,10831,10832,10833,1064,2374,2375,2376,2377,2378,2379,2390,2396,2397,2724,2725,2729,2730,2731,2732,2733,2762,2769,2770,4151,4483,4484,4502,4503,4522,4525,4949,4951,5016,5017,5018,5019,5020,5021,5045,5046,5047,5048,5049,5059,6107,6108,10430,10431,10432,10433,10468,10469,10500,10501,10502,10503,10770,10771,11041,11043,11324,11325,11350,11351,11388,11516,12256,28504,30839,31123,30087) AND `prints_vector`.`bundle` = 0
SELECT COUNT(*) cnt FROM `prints_set_vector` INNER JOIN `prints_vector` ON `prints_vector`.`id` = `prints_set_vector`.`vector_id` WHERE `prints_set_vector`.`set_id` = 34226 AND `prints_set_vector`.`vector_id` IN(10826,10827,10828,10829,10830,10831,10832,10833,1064,2374,2375,2376,2377,2378,2379,2390,2396,2397,2724,2725,2729,2730,2731,2732,2733,2762,2769,2770,4151,4483,4484,4502,4503,4522,4525,4949,4951,5016,5017,5018,5019,5020,5021,5045,5046,5047,5048,5049,5059,6107,6108,10430,10431,10432,10433,10468,10469,10500,10501,10502,10503,10770,10771,11041,11043,11324,11325,11350,11351,11388,11516,12256,28504,30839,31123,30087) AND `prints_vector`.`bundle` = 0
SELECT COUNT(*) cnt FROM `prints_set_vector` INNER JOIN `prints_vector` ON `prints_vector`.`id` = `prints_set_vector`.`vector_id` WHERE `prints_set_vector`.`set_id` = 35976 AND `prints_set_vector`.`vector_id` IN(10826,10827,10828,10829,10830,10831,10832,10833,1064,2374,2375,2376,2377,2378,2379,2390,2396,2397,2724,2725,2729,2730,2731,2732,2733,2762,2769,2770,4151,4483,4484,4502,4503,4522,4525,4949,4951,5016,5017,5018,5019,5020,5021,5045,5046,5047,5048,5049,5059,6107,6108,10430,10431,10432,10433,10468,10469,10500,10501,10502,10503,10770,10771,11041,11043,11324,11325,11350,11351,11388,11516,12256,28504,30839,31123,30087) AND `prints_vector`.`bundle` = 0
SELECT COUNT(*) cnt FROM `prints_set_vector` INNER JOIN `prints_vector` ON `prints_vector`.`id` = `prints_set_vector`.`vector_id` WHERE `prints_set_vector`.`set_id` = 5581 AND `prints_set_vector`.`vector_id` IN(10826,10827,10828,10829,10830,10831,10832,10833,1064,2374,2375,2376,2377,2378,2379,2390,2396,2397,2724,2725,2729,2730,2731,2732,2733,2762,2769,2770,4151,4483,4484,4502,4503,4522,4525,4949,4951,5016,5017,5018,5019,5020,5021,5045,5046,5047,5048,5049,5059,6107,6108,10430,10431,10432,10433,10468,10469,10500,10501,10502,10503,10770,10771,11041,11043,11324,11325,11350,11351,11388,11516,12256,28504,30839,31123,30087) AND `prints_vector`.`bundle` = 0
SELECT COUNT(*) cnt FROM `prints_set_vector` INNER JOIN `prints_vector` ON `prints_vector`.`id` = `prints_set_vector`.`vector_id` WHERE `prints_set_vector`.`set_id` = 31090 AND `prints_set_vector`.`vector_id` IN(10826,10827,10828,10829,10830,10831,10832,10833,1064,2374,2375,2376,2377,2378,2379,2390,2396,2397,2724,2725,2729,2730,2731,2732,2733,2762,2769,2770,4151,4483,4484,4502,4503,4522,4525,4949,4951,5016,5017,5018,5019,5020,5021,5045,5046,5047,5048,5049,5059,6107,6108,10430,10431,10432,10433,10468,10469,10500,10501,10502,10503,10770,10771,11041,11043,11324,11325,11350,11351,11388,11516,12256,28504,30839,31123,30087) AND `prints_vector`.`bundle` = 0
SELECT COUNT(*) cnt FROM `prints_set_vector` INNER JOIN `prints_vector` ON `prints_vector`.`id` = `prints_set_vector`.`vector_id` WHERE `prints_set_vector`.`set_id` = 5676 AND `prints_set_vector`.`vector_id` IN(10826,10827,10828,10829,10830,10831,10832,10833,1064,2374,2375,2376,2377,2378,2379,2390,2396,2397,2724,2725,2729,2730,2731,2732,2733,2762,2769,2770,4151,4483,4484,4502,4503,4522,4525,4949,4951,5016,5017,5018,5019,5020,5021,5045,5046,5047,5048,5049,5059,6107,6108,10430,10431,10432,10433,10468,10469,10500,10501,10502,10503,10770,10771,11041,11043,11324,11325,11350,11351,11388,11516,12256,28504,30839,31123,30087) AND `prints_vector`.`bundle` = 0
SELECT COUNT(*) cnt FROM `prints_set_vector` INNER JOIN `prints_vector` ON `prints_vector`.`id` = `prints_set_vector`.`vector_id` WHERE `prints_set_vector`.`set_id` = 32390 AND `prints_set_vector`.`vector_id` IN(10826,10827,10828,10829,10830,10831,10832,10833,1064,2374,2375,2376,2377,2378,2379,2390,2396,2397,2724,2725,2729,2730,2731,2732,2733,2762,2769,2770,4151,4483,4484,4502,4503,4522,4525,4949,4951,5016,5017,5018,5019,5020,5021,5045,5046,5047,5048,5049,5059,6107,6108,10430,10431,10432,10433,10468,10469,10500,10501,10502,10503,10770,10771,11041,11043,11324,11325,11350,11351,11388,11516,12256,28504,30839,31123,30087) AND `prints_vector`.`bundle` = 0
SELECT COUNT(*) cnt FROM `prints_set_vector` INNER JOIN `prints_vector` ON `prints_vector`.`id` = `prints_set_vector`.`vector_id` WHERE `prints_set_vector`.`set_id` = 11501 AND `prints_set_vector`.`vector_id` IN(10826,10827,10828,10829,10830,10831,10832,10833,1064,2374,2375,2376,2377,2378,2379,2390,2396,2397,2724,2725,2729,2730,2731,2732,2733,2762,2769,2770,4151,4483,4484,4502,4503,4522,4525,4949,4951,5016,5017,5018,5019,5020,5021,5045,5046,5047,5048,5049,5059,6107,6108,10430,10431,10432,10433,10468,10469,10500,10501,10502,10503,10770,10771,11041,11043,11324,11325,11350,11351,11388,11516,12256,28504,30839,31123,30087) AND `prints_vector`.`bundle` = 0
SELECT COUNT(*) cnt FROM `prints_set_vector` INNER JOIN `prints_vector` ON `prints_vector`.`id` = `prints_set_vector`.`vector_id` WHERE `prints_set_vector`.`set_id` = 34921 AND `prints_set_vector`.`vector_id` IN(10826,10827,10828,10829,10830,10831,10832,10833,1064,2374,2375,2376,2377,2378,2379,2390,2396,2397,2724,2725,2729,2730,2731,2732,2733,2762,2769,2770,4151,4483,4484,4502,4503,4522,4525,4949,4951,5016,5017,5018,5019,5020,5021,5045,5046,5047,5048,5049,5059,6107,6108,10430,10431,10432,10433,10468,10469,10500,10501,10502,10503,10770,10771,11041,11043,11324,11325,11350,11351,11388,11516,12256,28504,30839,31123,30087) AND `prints_vector`.`bundle` = 0
SELECT COUNT(*) cnt FROM `prints_set_vector` INNER JOIN `prints_vector` ON `prints_vector`.`id` = `prints_set_vector`.`vector_id` WHERE `prints_set_vector`.`set_id` = 34230 AND `prints_set_vector`.`vector_id` IN(10826,10827,10828,10829,10830,10831,10832,10833,1064,2374,2375,2376,2377,2378,2379,2390,2396,2397,2724,2725,2729,2730,2731,2732,2733,2762,2769,2770,4151,4483,4484,4502,4503,4522,4525,4949,4951,5016,5017,5018,5019,5020,5021,5045,5046,5047,5048,5049,5059,6107,6108,10430,10431,10432,10433,10468,10469,10500,10501,10502,10503,10770,10771,11041,11043,11324,11325,11350,11351,11388,11516,12256,28504,30839,31123,30087) AND `prints_vector`.`bundle` = 0
SELECT COUNT(*) cnt FROM `prints_set_vector` INNER JOIN `prints_vector` ON `prints_vector`.`id` = `prints_set_vector`.`vector_id` WHERE `prints_set_vector`.`set_id` = 10625 AND `prints_set_vector`.`vector_id` IN(10826,10827,10828,10829,10830,10831,10832,10833,1064,2374,2375,2376,2377,2378,2379,2390,2396,2397,2724,2725,2729,2730,2731,2732,2733,2762,2769,2770,4151,4483,4484,4502,4503,4522,4525,4949,4951,5016,5017,5018,5019,5020,5021,5045,5046,5047,5048,5049,5059,6107,6108,10430,10431,10432,10433,10468,10469,10500,10501,10502,10503,10770,10771,11041,11043,11324,11325,11350,11351,11388,11516,12256,28504,30839,31123,30087) AND `prints_vector`.`bundle` = 0
SELECT COUNT(*) cnt FROM `prints_set_vector` INNER JOIN `prints_vector` ON `prints_vector`.`id` = `prints_set_vector`.`vector_id` WHERE `prints_set_vector`.`set_id` = 11626 AND `prints_set_vector`.`vector_id` IN(10826,10827,10828,10829,10830,10831,10832,10833,1064,2374,2375,2376,2377,2378,2379,2390,2396,2397,2724,2725,2729,2730,2731,2732,2733,2762,2769,2770,4151,4483,4484,4502,4503,4522,4525,4949,4951,5016,5017,5018,5019,5020,5021,5045,5046,5047,5048,5049,5059,6107,6108,10430,10431,10432,10433,10468,10469,10500,10501,10502,10503,10770,10771,11041,11043,11324,11325,11350,11351,11388,11516,12256,28504,30839,31123,30087) AND `prints_vector`.`bundle` = 0
SELECT `prints_vector`.* FROM `prints_vector` LEFT JOIN `prints_set_vector` ON `prints_vector`.`id` = `prints_set_vector`.`vector_id` WHERE `id` IN(10826,10827,10828,10829,10830,10831,10832,10833,1064,2374,2375,2376,2377,2378,2379,2390,2396,2397,2724,2725,2729,2730,2731,2732,2733,2762,2769,2770,4151,4483,4484,4502,4503,4522,4525,4949,4951,5016,5017,5018,5019,5020,5021,5045,5046,5047,5048,5049,5059,6107,6108,10430,10431,10432,10433,10468,10469,10500,10501,10502,10503,10770,10771,11041,11043,11324,11325,11350,11351,11388,11516,12256,28504,30839,31123,30087) AND `set_id` IS NULL ORDER BY IF(`prints_vector`.`preview` IS NOT NULL AND `prints_vector`.`preview` != '', 0, 1), `prepay`, `prints_vector`.`full_name` LIMIT 1
?q=Toyota 2000&page=###page###
125
SELECT `id`, `name`, `type` FROM nox_group