/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(4608,4609,4610,4611,4612,1541,2122,2125,2129,3591,4060,4561,4562,4563,4564,4565,4566,4568,4569,4570,4573,4577,4580,4582,4583,4585,4587,4589,4591,4593,4595,4596,4598,4600,4602,4604,4606,4613,4615,4616,6997,7000,7003,7004,7009,7013,7017,7021,7025,7029,7033,7037,7041,7044,7048,7051,7055,7060,7068,7070,7072,7075,7078,7081,7084,7090,7091,7093,7094,7096,7097,7099,7103,7107,7111,7115,7119,7123,7127,7139,7143,7178,7181,7183,7185,7196,7200,7204,7208,7219,7223,7226,7229,7232,7235,7246,7249,7252,7255,7262,7267,7268,7273,7367,7413,7415,7418,7419,14673,14674,14675,28496,30085,31385,31467,31717,31901))
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(4608,4609,4610,4611,4612,1541,2122,2125,2129,3591,4060,4561,4562,4563,4564,4565,4566,4568,4569,4570,4573,4577,4580,4582,4583,4585,4587,4589,4591,4593,4595,4596,4598,4600,4602,4604,4606,4613,4615,4616,6997,7000,7003,7004,7009,7013,7017,7021,7025,7029,7033,7037,7041,7044,7048,7051,7055,7060,7068,7070,7072,7075,7078,7081,7084,7090,7091,7093,7094,7096,7097,7099,7103,7107,7111,7115,7119,7123,7127,7139,7143,7178,7181,7183,7185,7196,7200,7204,7208,7219,7223,7226,7229,7232,7235,7246,7249,7252,7255,7262,7267,7268,7273,7367,7413,7415,7418,7419,14673,14674,14675,28496,30085,31385,31467,31717,31901)) 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(2376, 35906, 36287, 33588, 5308, 29153, 5330, 7714, 36076, 15320, 7362, 7389, 7371, 7374, 7377, 8510, 7465, 7473, 7427, 7429, 7488, 7588, 7594, 7574, 7615, 7700, 33899, 7747, 15250, 36015) 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` = 15320 AND `prints_set_vector`.`vector_id` IN(4608,4609,4610,4611,4612,1541,2122,2125,2129,3591,4060,4561,4562,4563,4564,4565,4566,4568,4569,4570,4573,4577,4580,4582,4583,4585,4587,4589,4591,4593,4595,4596,4598,4600,4602,4604,4606,4613,4615,4616,6997,7000,7003,7004,7009,7013,7017,7021,7025,7029,7033,7037,7041,7044,7048,7051,7055,7060,7068,7070,7072,7075,7078,7081,7084,7090,7091,7093,7094,7096,7097,7099,7103,7107,7111,7115,7119,7123,7127,7139,7143,7178,7181,7183,7185,7196,7200,7204,7208,7219,7223,7226,7229,7232,7235,7246,7249,7252,7255,7262,7267,7268,7273,7367,7413,7415,7418,7419,14673,14674,14675,28496,30085,31385,31467,31717,31901) 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` = 33588 AND `prints_set_vector`.`vector_id` IN(4608,4609,4610,4611,4612,1541,2122,2125,2129,3591,4060,4561,4562,4563,4564,4565,4566,4568,4569,4570,4573,4577,4580,4582,4583,4585,4587,4589,4591,4593,4595,4596,4598,4600,4602,4604,4606,4613,4615,4616,6997,7000,7003,7004,7009,7013,7017,7021,7025,7029,7033,7037,7041,7044,7048,7051,7055,7060,7068,7070,7072,7075,7078,7081,7084,7090,7091,7093,7094,7096,7097,7099,7103,7107,7111,7115,7119,7123,7127,7139,7143,7178,7181,7183,7185,7196,7200,7204,7208,7219,7223,7226,7229,7232,7235,7246,7249,7252,7255,7262,7267,7268,7273,7367,7413,7415,7418,7419,14673,14674,14675,28496,30085,31385,31467,31717,31901) 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` = 29153 AND `prints_set_vector`.`vector_id` IN(4608,4609,4610,4611,4612,1541,2122,2125,2129,3591,4060,4561,4562,4563,4564,4565,4566,4568,4569,4570,4573,4577,4580,4582,4583,4585,4587,4589,4591,4593,4595,4596,4598,4600,4602,4604,4606,4613,4615,4616,6997,7000,7003,7004,7009,7013,7017,7021,7025,7029,7033,7037,7041,7044,7048,7051,7055,7060,7068,7070,7072,7075,7078,7081,7084,7090,7091,7093,7094,7096,7097,7099,7103,7107,7111,7115,7119,7123,7127,7139,7143,7178,7181,7183,7185,7196,7200,7204,7208,7219,7223,7226,7229,7232,7235,7246,7249,7252,7255,7262,7267,7268,7273,7367,7413,7415,7418,7419,14673,14674,14675,28496,30085,31385,31467,31717,31901) 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` = 36287 AND `prints_set_vector`.`vector_id` IN(4608,4609,4610,4611,4612,1541,2122,2125,2129,3591,4060,4561,4562,4563,4564,4565,4566,4568,4569,4570,4573,4577,4580,4582,4583,4585,4587,4589,4591,4593,4595,4596,4598,4600,4602,4604,4606,4613,4615,4616,6997,7000,7003,7004,7009,7013,7017,7021,7025,7029,7033,7037,7041,7044,7048,7051,7055,7060,7068,7070,7072,7075,7078,7081,7084,7090,7091,7093,7094,7096,7097,7099,7103,7107,7111,7115,7119,7123,7127,7139,7143,7178,7181,7183,7185,7196,7200,7204,7208,7219,7223,7226,7229,7232,7235,7246,7249,7252,7255,7262,7267,7268,7273,7367,7413,7415,7418,7419,14673,14674,14675,28496,30085,31385,31467,31717,31901) 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` = 7714 AND `prints_set_vector`.`vector_id` IN(4608,4609,4610,4611,4612,1541,2122,2125,2129,3591,4060,4561,4562,4563,4564,4565,4566,4568,4569,4570,4573,4577,4580,4582,4583,4585,4587,4589,4591,4593,4595,4596,4598,4600,4602,4604,4606,4613,4615,4616,6997,7000,7003,7004,7009,7013,7017,7021,7025,7029,7033,7037,7041,7044,7048,7051,7055,7060,7068,7070,7072,7075,7078,7081,7084,7090,7091,7093,7094,7096,7097,7099,7103,7107,7111,7115,7119,7123,7127,7139,7143,7178,7181,7183,7185,7196,7200,7204,7208,7219,7223,7226,7229,7232,7235,7246,7249,7252,7255,7262,7267,7268,7273,7367,7413,7415,7418,7419,14673,14674,14675,28496,30085,31385,31467,31717,31901) 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` = 2376 AND `prints_set_vector`.`vector_id` IN(4608,4609,4610,4611,4612,1541,2122,2125,2129,3591,4060,4561,4562,4563,4564,4565,4566,4568,4569,4570,4573,4577,4580,4582,4583,4585,4587,4589,4591,4593,4595,4596,4598,4600,4602,4604,4606,4613,4615,4616,6997,7000,7003,7004,7009,7013,7017,7021,7025,7029,7033,7037,7041,7044,7048,7051,7055,7060,7068,7070,7072,7075,7078,7081,7084,7090,7091,7093,7094,7096,7097,7099,7103,7107,7111,7115,7119,7123,7127,7139,7143,7178,7181,7183,7185,7196,7200,7204,7208,7219,7223,7226,7229,7232,7235,7246,7249,7252,7255,7262,7267,7268,7273,7367,7413,7415,7418,7419,14673,14674,14675,28496,30085,31385,31467,31717,31901) 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` = 7594 AND `prints_set_vector`.`vector_id` IN(4608,4609,4610,4611,4612,1541,2122,2125,2129,3591,4060,4561,4562,4563,4564,4565,4566,4568,4569,4570,4573,4577,4580,4582,4583,4585,4587,4589,4591,4593,4595,4596,4598,4600,4602,4604,4606,4613,4615,4616,6997,7000,7003,7004,7009,7013,7017,7021,7025,7029,7033,7037,7041,7044,7048,7051,7055,7060,7068,7070,7072,7075,7078,7081,7084,7090,7091,7093,7094,7096,7097,7099,7103,7107,7111,7115,7119,7123,7127,7139,7143,7178,7181,7183,7185,7196,7200,7204,7208,7219,7223,7226,7229,7232,7235,7246,7249,7252,7255,7262,7267,7268,7273,7367,7413,7415,7418,7419,14673,14674,14675,28496,30085,31385,31467,31717,31901) 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` = 7473 AND `prints_set_vector`.`vector_id` IN(4608,4609,4610,4611,4612,1541,2122,2125,2129,3591,4060,4561,4562,4563,4564,4565,4566,4568,4569,4570,4573,4577,4580,4582,4583,4585,4587,4589,4591,4593,4595,4596,4598,4600,4602,4604,4606,4613,4615,4616,6997,7000,7003,7004,7009,7013,7017,7021,7025,7029,7033,7037,7041,7044,7048,7051,7055,7060,7068,7070,7072,7075,7078,7081,7084,7090,7091,7093,7094,7096,7097,7099,7103,7107,7111,7115,7119,7123,7127,7139,7143,7178,7181,7183,7185,7196,7200,7204,7208,7219,7223,7226,7229,7232,7235,7246,7249,7252,7255,7262,7267,7268,7273,7367,7413,7415,7418,7419,14673,14674,14675,28496,30085,31385,31467,31717,31901) 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` = 7427 AND `prints_set_vector`.`vector_id` IN(4608,4609,4610,4611,4612,1541,2122,2125,2129,3591,4060,4561,4562,4563,4564,4565,4566,4568,4569,4570,4573,4577,4580,4582,4583,4585,4587,4589,4591,4593,4595,4596,4598,4600,4602,4604,4606,4613,4615,4616,6997,7000,7003,7004,7009,7013,7017,7021,7025,7029,7033,7037,7041,7044,7048,7051,7055,7060,7068,7070,7072,7075,7078,7081,7084,7090,7091,7093,7094,7096,7097,7099,7103,7107,7111,7115,7119,7123,7127,7139,7143,7178,7181,7183,7185,7196,7200,7204,7208,7219,7223,7226,7229,7232,7235,7246,7249,7252,7255,7262,7267,7268,7273,7367,7413,7415,7418,7419,14673,14674,14675,28496,30085,31385,31467,31717,31901) 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` = 7615 AND `prints_set_vector`.`vector_id` IN(4608,4609,4610,4611,4612,1541,2122,2125,2129,3591,4060,4561,4562,4563,4564,4565,4566,4568,4569,4570,4573,4577,4580,4582,4583,4585,4587,4589,4591,4593,4595,4596,4598,4600,4602,4604,4606,4613,4615,4616,6997,7000,7003,7004,7009,7013,7017,7021,7025,7029,7033,7037,7041,7044,7048,7051,7055,7060,7068,7070,7072,7075,7078,7081,7084,7090,7091,7093,7094,7096,7097,7099,7103,7107,7111,7115,7119,7123,7127,7139,7143,7178,7181,7183,7185,7196,7200,7204,7208,7219,7223,7226,7229,7232,7235,7246,7249,7252,7255,7262,7267,7268,7273,7367,7413,7415,7418,7419,14673,14674,14675,28496,30085,31385,31467,31717,31901) 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` = 5330 AND `prints_set_vector`.`vector_id` IN(4608,4609,4610,4611,4612,1541,2122,2125,2129,3591,4060,4561,4562,4563,4564,4565,4566,4568,4569,4570,4573,4577,4580,4582,4583,4585,4587,4589,4591,4593,4595,4596,4598,4600,4602,4604,4606,4613,4615,4616,6997,7000,7003,7004,7009,7013,7017,7021,7025,7029,7033,7037,7041,7044,7048,7051,7055,7060,7068,7070,7072,7075,7078,7081,7084,7090,7091,7093,7094,7096,7097,7099,7103,7107,7111,7115,7119,7123,7127,7139,7143,7178,7181,7183,7185,7196,7200,7204,7208,7219,7223,7226,7229,7232,7235,7246,7249,7252,7255,7262,7267,7268,7273,7367,7413,7415,7418,7419,14673,14674,14675,28496,30085,31385,31467,31717,31901) 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` = 7371 AND `prints_set_vector`.`vector_id` IN(4608,4609,4610,4611,4612,1541,2122,2125,2129,3591,4060,4561,4562,4563,4564,4565,4566,4568,4569,4570,4573,4577,4580,4582,4583,4585,4587,4589,4591,4593,4595,4596,4598,4600,4602,4604,4606,4613,4615,4616,6997,7000,7003,7004,7009,7013,7017,7021,7025,7029,7033,7037,7041,7044,7048,7051,7055,7060,7068,7070,7072,7075,7078,7081,7084,7090,7091,7093,7094,7096,7097,7099,7103,7107,7111,7115,7119,7123,7127,7139,7143,7178,7181,7183,7185,7196,7200,7204,7208,7219,7223,7226,7229,7232,7235,7246,7249,7252,7255,7262,7267,7268,7273,7367,7413,7415,7418,7419,14673,14674,14675,28496,30085,31385,31467,31717,31901) 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` = 7588 AND `prints_set_vector`.`vector_id` IN(4608,4609,4610,4611,4612,1541,2122,2125,2129,3591,4060,4561,4562,4563,4564,4565,4566,4568,4569,4570,4573,4577,4580,4582,4583,4585,4587,4589,4591,4593,4595,4596,4598,4600,4602,4604,4606,4613,4615,4616,6997,7000,7003,7004,7009,7013,7017,7021,7025,7029,7033,7037,7041,7044,7048,7051,7055,7060,7068,7070,7072,7075,7078,7081,7084,7090,7091,7093,7094,7096,7097,7099,7103,7107,7111,7115,7119,7123,7127,7139,7143,7178,7181,7183,7185,7196,7200,7204,7208,7219,7223,7226,7229,7232,7235,7246,7249,7252,7255,7262,7267,7268,7273,7367,7413,7415,7418,7419,14673,14674,14675,28496,30085,31385,31467,31717,31901) 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` = 7574 AND `prints_set_vector`.`vector_id` IN(4608,4609,4610,4611,4612,1541,2122,2125,2129,3591,4060,4561,4562,4563,4564,4565,4566,4568,4569,4570,4573,4577,4580,4582,4583,4585,4587,4589,4591,4593,4595,4596,4598,4600,4602,4604,4606,4613,4615,4616,6997,7000,7003,7004,7009,7013,7017,7021,7025,7029,7033,7037,7041,7044,7048,7051,7055,7060,7068,7070,7072,7075,7078,7081,7084,7090,7091,7093,7094,7096,7097,7099,7103,7107,7111,7115,7119,7123,7127,7139,7143,7178,7181,7183,7185,7196,7200,7204,7208,7219,7223,7226,7229,7232,7235,7246,7249,7252,7255,7262,7267,7268,7273,7367,7413,7415,7418,7419,14673,14674,14675,28496,30085,31385,31467,31717,31901) 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` = 36076 AND `prints_set_vector`.`vector_id` IN(4608,4609,4610,4611,4612,1541,2122,2125,2129,3591,4060,4561,4562,4563,4564,4565,4566,4568,4569,4570,4573,4577,4580,4582,4583,4585,4587,4589,4591,4593,4595,4596,4598,4600,4602,4604,4606,4613,4615,4616,6997,7000,7003,7004,7009,7013,7017,7021,7025,7029,7033,7037,7041,7044,7048,7051,7055,7060,7068,7070,7072,7075,7078,7081,7084,7090,7091,7093,7094,7096,7097,7099,7103,7107,7111,7115,7119,7123,7127,7139,7143,7178,7181,7183,7185,7196,7200,7204,7208,7219,7223,7226,7229,7232,7235,7246,7249,7252,7255,7262,7267,7268,7273,7367,7413,7415,7418,7419,14673,14674,14675,28496,30085,31385,31467,31717,31901) 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` = 5308 AND `prints_set_vector`.`vector_id` IN(4608,4609,4610,4611,4612,1541,2122,2125,2129,3591,4060,4561,4562,4563,4564,4565,4566,4568,4569,4570,4573,4577,4580,4582,4583,4585,4587,4589,4591,4593,4595,4596,4598,4600,4602,4604,4606,4613,4615,4616,6997,7000,7003,7004,7009,7013,7017,7021,7025,7029,7033,7037,7041,7044,7048,7051,7055,7060,7068,7070,7072,7075,7078,7081,7084,7090,7091,7093,7094,7096,7097,7099,7103,7107,7111,7115,7119,7123,7127,7139,7143,7178,7181,7183,7185,7196,7200,7204,7208,7219,7223,7226,7229,7232,7235,7246,7249,7252,7255,7262,7267,7268,7273,7367,7413,7415,7418,7419,14673,14674,14675,28496,30085,31385,31467,31717,31901) 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` = 7429 AND `prints_set_vector`.`vector_id` IN(4608,4609,4610,4611,4612,1541,2122,2125,2129,3591,4060,4561,4562,4563,4564,4565,4566,4568,4569,4570,4573,4577,4580,4582,4583,4585,4587,4589,4591,4593,4595,4596,4598,4600,4602,4604,4606,4613,4615,4616,6997,7000,7003,7004,7009,7013,7017,7021,7025,7029,7033,7037,7041,7044,7048,7051,7055,7060,7068,7070,7072,7075,7078,7081,7084,7090,7091,7093,7094,7096,7097,7099,7103,7107,7111,7115,7119,7123,7127,7139,7143,7178,7181,7183,7185,7196,7200,7204,7208,7219,7223,7226,7229,7232,7235,7246,7249,7252,7255,7262,7267,7268,7273,7367,7413,7415,7418,7419,14673,14674,14675,28496,30085,31385,31467,31717,31901) 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` = 8510 AND `prints_set_vector`.`vector_id` IN(4608,4609,4610,4611,4612,1541,2122,2125,2129,3591,4060,4561,4562,4563,4564,4565,4566,4568,4569,4570,4573,4577,4580,4582,4583,4585,4587,4589,4591,4593,4595,4596,4598,4600,4602,4604,4606,4613,4615,4616,6997,7000,7003,7004,7009,7013,7017,7021,7025,7029,7033,7037,7041,7044,7048,7051,7055,7060,7068,7070,7072,7075,7078,7081,7084,7090,7091,7093,7094,7096,7097,7099,7103,7107,7111,7115,7119,7123,7127,7139,7143,7178,7181,7183,7185,7196,7200,7204,7208,7219,7223,7226,7229,7232,7235,7246,7249,7252,7255,7262,7267,7268,7273,7367,7413,7415,7418,7419,14673,14674,14675,28496,30085,31385,31467,31717,31901) 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` = 7389 AND `prints_set_vector`.`vector_id` IN(4608,4609,4610,4611,4612,1541,2122,2125,2129,3591,4060,4561,4562,4563,4564,4565,4566,4568,4569,4570,4573,4577,4580,4582,4583,4585,4587,4589,4591,4593,4595,4596,4598,4600,4602,4604,4606,4613,4615,4616,6997,7000,7003,7004,7009,7013,7017,7021,7025,7029,7033,7037,7041,7044,7048,7051,7055,7060,7068,7070,7072,7075,7078,7081,7084,7090,7091,7093,7094,7096,7097,7099,7103,7107,7111,7115,7119,7123,7127,7139,7143,7178,7181,7183,7185,7196,7200,7204,7208,7219,7223,7226,7229,7232,7235,7246,7249,7252,7255,7262,7267,7268,7273,7367,7413,7415,7418,7419,14673,14674,14675,28496,30085,31385,31467,31717,31901) 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` = 7488 AND `prints_set_vector`.`vector_id` IN(4608,4609,4610,4611,4612,1541,2122,2125,2129,3591,4060,4561,4562,4563,4564,4565,4566,4568,4569,4570,4573,4577,4580,4582,4583,4585,4587,4589,4591,4593,4595,4596,4598,4600,4602,4604,4606,4613,4615,4616,6997,7000,7003,7004,7009,7013,7017,7021,7025,7029,7033,7037,7041,7044,7048,7051,7055,7060,7068,7070,7072,7075,7078,7081,7084,7090,7091,7093,7094,7096,7097,7099,7103,7107,7111,7115,7119,7123,7127,7139,7143,7178,7181,7183,7185,7196,7200,7204,7208,7219,7223,7226,7229,7232,7235,7246,7249,7252,7255,7262,7267,7268,7273,7367,7413,7415,7418,7419,14673,14674,14675,28496,30085,31385,31467,31717,31901) 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` = 7700 AND `prints_set_vector`.`vector_id` IN(4608,4609,4610,4611,4612,1541,2122,2125,2129,3591,4060,4561,4562,4563,4564,4565,4566,4568,4569,4570,4573,4577,4580,4582,4583,4585,4587,4589,4591,4593,4595,4596,4598,4600,4602,4604,4606,4613,4615,4616,6997,7000,7003,7004,7009,7013,7017,7021,7025,7029,7033,7037,7041,7044,7048,7051,7055,7060,7068,7070,7072,7075,7078,7081,7084,7090,7091,7093,7094,7096,7097,7099,7103,7107,7111,7115,7119,7123,7127,7139,7143,7178,7181,7183,7185,7196,7200,7204,7208,7219,7223,7226,7229,7232,7235,7246,7249,7252,7255,7262,7267,7268,7273,7367,7413,7415,7418,7419,14673,14674,14675,28496,30085,31385,31467,31717,31901) 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` = 7374 AND `prints_set_vector`.`vector_id` IN(4608,4609,4610,4611,4612,1541,2122,2125,2129,3591,4060,4561,4562,4563,4564,4565,4566,4568,4569,4570,4573,4577,4580,4582,4583,4585,4587,4589,4591,4593,4595,4596,4598,4600,4602,4604,4606,4613,4615,4616,6997,7000,7003,7004,7009,7013,7017,7021,7025,7029,7033,7037,7041,7044,7048,7051,7055,7060,7068,7070,7072,7075,7078,7081,7084,7090,7091,7093,7094,7096,7097,7099,7103,7107,7111,7115,7119,7123,7127,7139,7143,7178,7181,7183,7185,7196,7200,7204,7208,7219,7223,7226,7229,7232,7235,7246,7249,7252,7255,7262,7267,7268,7273,7367,7413,7415,7418,7419,14673,14674,14675,28496,30085,31385,31467,31717,31901) 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` = 35906 AND `prints_set_vector`.`vector_id` IN(4608,4609,4610,4611,4612,1541,2122,2125,2129,3591,4060,4561,4562,4563,4564,4565,4566,4568,4569,4570,4573,4577,4580,4582,4583,4585,4587,4589,4591,4593,4595,4596,4598,4600,4602,4604,4606,4613,4615,4616,6997,7000,7003,7004,7009,7013,7017,7021,7025,7029,7033,7037,7041,7044,7048,7051,7055,7060,7068,7070,7072,7075,7078,7081,7084,7090,7091,7093,7094,7096,7097,7099,7103,7107,7111,7115,7119,7123,7127,7139,7143,7178,7181,7183,7185,7196,7200,7204,7208,7219,7223,7226,7229,7232,7235,7246,7249,7252,7255,7262,7267,7268,7273,7367,7413,7415,7418,7419,14673,14674,14675,28496,30085,31385,31467,31717,31901) 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` = 7465 AND `prints_set_vector`.`vector_id` IN(4608,4609,4610,4611,4612,1541,2122,2125,2129,3591,4060,4561,4562,4563,4564,4565,4566,4568,4569,4570,4573,4577,4580,4582,4583,4585,4587,4589,4591,4593,4595,4596,4598,4600,4602,4604,4606,4613,4615,4616,6997,7000,7003,7004,7009,7013,7017,7021,7025,7029,7033,7037,7041,7044,7048,7051,7055,7060,7068,7070,7072,7075,7078,7081,7084,7090,7091,7093,7094,7096,7097,7099,7103,7107,7111,7115,7119,7123,7127,7139,7143,7178,7181,7183,7185,7196,7200,7204,7208,7219,7223,7226,7229,7232,7235,7246,7249,7252,7255,7262,7267,7268,7273,7367,7413,7415,7418,7419,14673,14674,14675,28496,30085,31385,31467,31717,31901) 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` = 15250 AND `prints_set_vector`.`vector_id` IN(4608,4609,4610,4611,4612,1541,2122,2125,2129,3591,4060,4561,4562,4563,4564,4565,4566,4568,4569,4570,4573,4577,4580,4582,4583,4585,4587,4589,4591,4593,4595,4596,4598,4600,4602,4604,4606,4613,4615,4616,6997,7000,7003,7004,7009,7013,7017,7021,7025,7029,7033,7037,7041,7044,7048,7051,7055,7060,7068,7070,7072,7075,7078,7081,7084,7090,7091,7093,7094,7096,7097,7099,7103,7107,7111,7115,7119,7123,7127,7139,7143,7178,7181,7183,7185,7196,7200,7204,7208,7219,7223,7226,7229,7232,7235,7246,7249,7252,7255,7262,7267,7268,7273,7367,7413,7415,7418,7419,14673,14674,14675,28496,30085,31385,31467,31717,31901) 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` = 33899 AND `prints_set_vector`.`vector_id` IN(4608,4609,4610,4611,4612,1541,2122,2125,2129,3591,4060,4561,4562,4563,4564,4565,4566,4568,4569,4570,4573,4577,4580,4582,4583,4585,4587,4589,4591,4593,4595,4596,4598,4600,4602,4604,4606,4613,4615,4616,6997,7000,7003,7004,7009,7013,7017,7021,7025,7029,7033,7037,7041,7044,7048,7051,7055,7060,7068,7070,7072,7075,7078,7081,7084,7090,7091,7093,7094,7096,7097,7099,7103,7107,7111,7115,7119,7123,7127,7139,7143,7178,7181,7183,7185,7196,7200,7204,7208,7219,7223,7226,7229,7232,7235,7246,7249,7252,7255,7262,7267,7268,7273,7367,7413,7415,7418,7419,14673,14674,14675,28496,30085,31385,31467,31717,31901) 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` = 7747 AND `prints_set_vector`.`vector_id` IN(4608,4609,4610,4611,4612,1541,2122,2125,2129,3591,4060,4561,4562,4563,4564,4565,4566,4568,4569,4570,4573,4577,4580,4582,4583,4585,4587,4589,4591,4593,4595,4596,4598,4600,4602,4604,4606,4613,4615,4616,6997,7000,7003,7004,7009,7013,7017,7021,7025,7029,7033,7037,7041,7044,7048,7051,7055,7060,7068,7070,7072,7075,7078,7081,7084,7090,7091,7093,7094,7096,7097,7099,7103,7107,7111,7115,7119,7123,7127,7139,7143,7178,7181,7183,7185,7196,7200,7204,7208,7219,7223,7226,7229,7232,7235,7246,7249,7252,7255,7262,7267,7268,7273,7367,7413,7415,7418,7419,14673,14674,14675,28496,30085,31385,31467,31717,31901) 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` = 7362 AND `prints_set_vector`.`vector_id` IN(4608,4609,4610,4611,4612,1541,2122,2125,2129,3591,4060,4561,4562,4563,4564,4565,4566,4568,4569,4570,4573,4577,4580,4582,4583,4585,4587,4589,4591,4593,4595,4596,4598,4600,4602,4604,4606,4613,4615,4616,6997,7000,7003,7004,7009,7013,7017,7021,7025,7029,7033,7037,7041,7044,7048,7051,7055,7060,7068,7070,7072,7075,7078,7081,7084,7090,7091,7093,7094,7096,7097,7099,7103,7107,7111,7115,7119,7123,7127,7139,7143,7178,7181,7183,7185,7196,7200,7204,7208,7219,7223,7226,7229,7232,7235,7246,7249,7252,7255,7262,7267,7268,7273,7367,7413,7415,7418,7419,14673,14674,14675,28496,30085,31385,31467,31717,31901) 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` = 36015 AND `prints_set_vector`.`vector_id` IN(4608,4609,4610,4611,4612,1541,2122,2125,2129,3591,4060,4561,4562,4563,4564,4565,4566,4568,4569,4570,4573,4577,4580,4582,4583,4585,4587,4589,4591,4593,4595,4596,4598,4600,4602,4604,4606,4613,4615,4616,6997,7000,7003,7004,7009,7013,7017,7021,7025,7029,7033,7037,7041,7044,7048,7051,7055,7060,7068,7070,7072,7075,7078,7081,7084,7090,7091,7093,7094,7096,7097,7099,7103,7107,7111,7115,7119,7123,7127,7139,7143,7178,7181,7183,7185,7196,7200,7204,7208,7219,7223,7226,7229,7232,7235,7246,7249,7252,7255,7262,7267,7268,7273,7367,7413,7415,7418,7419,14673,14674,14675,28496,30085,31385,31467,31717,31901) 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` = 7377 AND `prints_set_vector`.`vector_id` IN(4608,4609,4610,4611,4612,1541,2122,2125,2129,3591,4060,4561,4562,4563,4564,4565,4566,4568,4569,4570,4573,4577,4580,4582,4583,4585,4587,4589,4591,4593,4595,4596,4598,4600,4602,4604,4606,4613,4615,4616,6997,7000,7003,7004,7009,7013,7017,7021,7025,7029,7033,7037,7041,7044,7048,7051,7055,7060,7068,7070,7072,7075,7078,7081,7084,7090,7091,7093,7094,7096,7097,7099,7103,7107,7111,7115,7119,7123,7127,7139,7143,7178,7181,7183,7185,7196,7200,7204,7208,7219,7223,7226,7229,7232,7235,7246,7249,7252,7255,7262,7267,7268,7273,7367,7413,7415,7418,7419,14673,14674,14675,28496,30085,31385,31467,31717,31901) AND `prints_vector`.`bundle` = 0
?q=Mazda 5&page=###page###
190
SELECT `id`, `name`, `type` FROM nox_group