/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(4584,4585,4586,4587,4588,4589,4590,4591,4592,4593,4594,4595,4206,4563,4564,4571,4576,6996,6999,7005,7008,7012,7016,7020,7024,7028,7032,7036,7040,7043,7047,7050,7054,7059,7067,7069,7071,7074,7077,7080,7083,7089,7092,7095,7098,7102,7106,7110,7114,7118,7122,7126,7138,7142,7355,7356,7357,7358,7359,7360,7361,7362,7363,7366,7408,7411,7420,14685,14686,14687,14692,14693,14694,14697,14698,14699,30243,30245,31026,31208))
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(4584,4585,4586,4587,4588,4589,4590,4591,4592,4593,4594,4595,4206,4563,4564,4571,4576,6996,6999,7005,7008,7012,7016,7020,7024,7028,7032,7036,7040,7043,7047,7050,7054,7059,7067,7069,7071,7074,7077,7080,7083,7089,7092,7095,7098,7102,7106,7110,7114,7118,7122,7126,7138,7142,7355,7356,7357,7358,7359,7360,7361,7362,7363,7366,7408,7411,7420,14685,14686,14687,14692,14693,14694,14697,14698,14699,30243,30245,31026,31208)) 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(33899, 35906, 33588, 5308, 29153, 15320, 7362, 36287, 7389, 7371, 7374, 7377, 8510, 7465, 7473, 7427, 7429, 7488, 10110, 7692, 7700, 7747, 15302, 15310, 15263, 35157, 35517) 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(4584,4585,4586,4587,4588,4589,4590,4591,4592,4593,4594,4595,4206,4563,4564,4571,4576,6996,6999,7005,7008,7012,7016,7020,7024,7028,7032,7036,7040,7043,7047,7050,7054,7059,7067,7069,7071,7074,7077,7080,7083,7089,7092,7095,7098,7102,7106,7110,7114,7118,7122,7126,7138,7142,7355,7356,7357,7358,7359,7360,7361,7362,7363,7366,7408,7411,7420,14685,14686,14687,14692,14693,14694,14697,14698,14699,30243,30245,31026,31208) 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(4584,4585,4586,4587,4588,4589,4590,4591,4592,4593,4594,4595,4206,4563,4564,4571,4576,6996,6999,7005,7008,7012,7016,7020,7024,7028,7032,7036,7040,7043,7047,7050,7054,7059,7067,7069,7071,7074,7077,7080,7083,7089,7092,7095,7098,7102,7106,7110,7114,7118,7122,7126,7138,7142,7355,7356,7357,7358,7359,7360,7361,7362,7363,7366,7408,7411,7420,14685,14686,14687,14692,14693,14694,14697,14698,14699,30243,30245,31026,31208) 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(4584,4585,4586,4587,4588,4589,4590,4591,4592,4593,4594,4595,4206,4563,4564,4571,4576,6996,6999,7005,7008,7012,7016,7020,7024,7028,7032,7036,7040,7043,7047,7050,7054,7059,7067,7069,7071,7074,7077,7080,7083,7089,7092,7095,7098,7102,7106,7110,7114,7118,7122,7126,7138,7142,7355,7356,7357,7358,7359,7360,7361,7362,7363,7366,7408,7411,7420,14685,14686,14687,14692,14693,14694,14697,14698,14699,30243,30245,31026,31208) 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(4584,4585,4586,4587,4588,4589,4590,4591,4592,4593,4594,4595,4206,4563,4564,4571,4576,6996,6999,7005,7008,7012,7016,7020,7024,7028,7032,7036,7040,7043,7047,7050,7054,7059,7067,7069,7071,7074,7077,7080,7083,7089,7092,7095,7098,7102,7106,7110,7114,7118,7122,7126,7138,7142,7355,7356,7357,7358,7359,7360,7361,7362,7363,7366,7408,7411,7420,14685,14686,14687,14692,14693,14694,14697,14698,14699,30243,30245,31026,31208) 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` = 15310 AND `prints_set_vector`.`vector_id` IN(4584,4585,4586,4587,4588,4589,4590,4591,4592,4593,4594,4595,4206,4563,4564,4571,4576,6996,6999,7005,7008,7012,7016,7020,7024,7028,7032,7036,7040,7043,7047,7050,7054,7059,7067,7069,7071,7074,7077,7080,7083,7089,7092,7095,7098,7102,7106,7110,7114,7118,7122,7126,7138,7142,7355,7356,7357,7358,7359,7360,7361,7362,7363,7366,7408,7411,7420,14685,14686,14687,14692,14693,14694,14697,14698,14699,30243,30245,31026,31208) 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(4584,4585,4586,4587,4588,4589,4590,4591,4592,4593,4594,4595,4206,4563,4564,4571,4576,6996,6999,7005,7008,7012,7016,7020,7024,7028,7032,7036,7040,7043,7047,7050,7054,7059,7067,7069,7071,7074,7077,7080,7083,7089,7092,7095,7098,7102,7106,7110,7114,7118,7122,7126,7138,7142,7355,7356,7357,7358,7359,7360,7361,7362,7363,7366,7408,7411,7420,14685,14686,14687,14692,14693,14694,14697,14698,14699,30243,30245,31026,31208) 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(4584,4585,4586,4587,4588,4589,4590,4591,4592,4593,4594,4595,4206,4563,4564,4571,4576,6996,6999,7005,7008,7012,7016,7020,7024,7028,7032,7036,7040,7043,7047,7050,7054,7059,7067,7069,7071,7074,7077,7080,7083,7089,7092,7095,7098,7102,7106,7110,7114,7118,7122,7126,7138,7142,7355,7356,7357,7358,7359,7360,7361,7362,7363,7366,7408,7411,7420,14685,14686,14687,14692,14693,14694,14697,14698,14699,30243,30245,31026,31208) 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(4584,4585,4586,4587,4588,4589,4590,4591,4592,4593,4594,4595,4206,4563,4564,4571,4576,6996,6999,7005,7008,7012,7016,7020,7024,7028,7032,7036,7040,7043,7047,7050,7054,7059,7067,7069,7071,7074,7077,7080,7083,7089,7092,7095,7098,7102,7106,7110,7114,7118,7122,7126,7138,7142,7355,7356,7357,7358,7359,7360,7361,7362,7363,7366,7408,7411,7420,14685,14686,14687,14692,14693,14694,14697,14698,14699,30243,30245,31026,31208) 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` = 35517 AND `prints_set_vector`.`vector_id` IN(4584,4585,4586,4587,4588,4589,4590,4591,4592,4593,4594,4595,4206,4563,4564,4571,4576,6996,6999,7005,7008,7012,7016,7020,7024,7028,7032,7036,7040,7043,7047,7050,7054,7059,7067,7069,7071,7074,7077,7080,7083,7089,7092,7095,7098,7102,7106,7110,7114,7118,7122,7126,7138,7142,7355,7356,7357,7358,7359,7360,7361,7362,7363,7366,7408,7411,7420,14685,14686,14687,14692,14693,14694,14697,14698,14699,30243,30245,31026,31208) 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` = 35157 AND `prints_set_vector`.`vector_id` IN(4584,4585,4586,4587,4588,4589,4590,4591,4592,4593,4594,4595,4206,4563,4564,4571,4576,6996,6999,7005,7008,7012,7016,7020,7024,7028,7032,7036,7040,7043,7047,7050,7054,7059,7067,7069,7071,7074,7077,7080,7083,7089,7092,7095,7098,7102,7106,7110,7114,7118,7122,7126,7138,7142,7355,7356,7357,7358,7359,7360,7361,7362,7363,7366,7408,7411,7420,14685,14686,14687,14692,14693,14694,14697,14698,14699,30243,30245,31026,31208) 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` = 10110 AND `prints_set_vector`.`vector_id` IN(4584,4585,4586,4587,4588,4589,4590,4591,4592,4593,4594,4595,4206,4563,4564,4571,4576,6996,6999,7005,7008,7012,7016,7020,7024,7028,7032,7036,7040,7043,7047,7050,7054,7059,7067,7069,7071,7074,7077,7080,7083,7089,7092,7095,7098,7102,7106,7110,7114,7118,7122,7126,7138,7142,7355,7356,7357,7358,7359,7360,7361,7362,7363,7366,7408,7411,7420,14685,14686,14687,14692,14693,14694,14697,14698,14699,30243,30245,31026,31208) 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` = 7692 AND `prints_set_vector`.`vector_id` IN(4584,4585,4586,4587,4588,4589,4590,4591,4592,4593,4594,4595,4206,4563,4564,4571,4576,6996,6999,7005,7008,7012,7016,7020,7024,7028,7032,7036,7040,7043,7047,7050,7054,7059,7067,7069,7071,7074,7077,7080,7083,7089,7092,7095,7098,7102,7106,7110,7114,7118,7122,7126,7138,7142,7355,7356,7357,7358,7359,7360,7361,7362,7363,7366,7408,7411,7420,14685,14686,14687,14692,14693,14694,14697,14698,14699,30243,30245,31026,31208) 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(4584,4585,4586,4587,4588,4589,4590,4591,4592,4593,4594,4595,4206,4563,4564,4571,4576,6996,6999,7005,7008,7012,7016,7020,7024,7028,7032,7036,7040,7043,7047,7050,7054,7059,7067,7069,7071,7074,7077,7080,7083,7089,7092,7095,7098,7102,7106,7110,7114,7118,7122,7126,7138,7142,7355,7356,7357,7358,7359,7360,7361,7362,7363,7366,7408,7411,7420,14685,14686,14687,14692,14693,14694,14697,14698,14699,30243,30245,31026,31208) 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(4584,4585,4586,4587,4588,4589,4590,4591,4592,4593,4594,4595,4206,4563,4564,4571,4576,6996,6999,7005,7008,7012,7016,7020,7024,7028,7032,7036,7040,7043,7047,7050,7054,7059,7067,7069,7071,7074,7077,7080,7083,7089,7092,7095,7098,7102,7106,7110,7114,7118,7122,7126,7138,7142,7355,7356,7357,7358,7359,7360,7361,7362,7363,7366,7408,7411,7420,14685,14686,14687,14692,14693,14694,14697,14698,14699,30243,30245,31026,31208) 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(4584,4585,4586,4587,4588,4589,4590,4591,4592,4593,4594,4595,4206,4563,4564,4571,4576,6996,6999,7005,7008,7012,7016,7020,7024,7028,7032,7036,7040,7043,7047,7050,7054,7059,7067,7069,7071,7074,7077,7080,7083,7089,7092,7095,7098,7102,7106,7110,7114,7118,7122,7126,7138,7142,7355,7356,7357,7358,7359,7360,7361,7362,7363,7366,7408,7411,7420,14685,14686,14687,14692,14693,14694,14697,14698,14699,30243,30245,31026,31208) 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(4584,4585,4586,4587,4588,4589,4590,4591,4592,4593,4594,4595,4206,4563,4564,4571,4576,6996,6999,7005,7008,7012,7016,7020,7024,7028,7032,7036,7040,7043,7047,7050,7054,7059,7067,7069,7071,7074,7077,7080,7083,7089,7092,7095,7098,7102,7106,7110,7114,7118,7122,7126,7138,7142,7355,7356,7357,7358,7359,7360,7361,7362,7363,7366,7408,7411,7420,14685,14686,14687,14692,14693,14694,14697,14698,14699,30243,30245,31026,31208) 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(4584,4585,4586,4587,4588,4589,4590,4591,4592,4593,4594,4595,4206,4563,4564,4571,4576,6996,6999,7005,7008,7012,7016,7020,7024,7028,7032,7036,7040,7043,7047,7050,7054,7059,7067,7069,7071,7074,7077,7080,7083,7089,7092,7095,7098,7102,7106,7110,7114,7118,7122,7126,7138,7142,7355,7356,7357,7358,7359,7360,7361,7362,7363,7366,7408,7411,7420,14685,14686,14687,14692,14693,14694,14697,14698,14699,30243,30245,31026,31208) 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(4584,4585,4586,4587,4588,4589,4590,4591,4592,4593,4594,4595,4206,4563,4564,4571,4576,6996,6999,7005,7008,7012,7016,7020,7024,7028,7032,7036,7040,7043,7047,7050,7054,7059,7067,7069,7071,7074,7077,7080,7083,7089,7092,7095,7098,7102,7106,7110,7114,7118,7122,7126,7138,7142,7355,7356,7357,7358,7359,7360,7361,7362,7363,7366,7408,7411,7420,14685,14686,14687,14692,14693,14694,14697,14698,14699,30243,30245,31026,31208) 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` = 15302 AND `prints_set_vector`.`vector_id` IN(4584,4585,4586,4587,4588,4589,4590,4591,4592,4593,4594,4595,4206,4563,4564,4571,4576,6996,6999,7005,7008,7012,7016,7020,7024,7028,7032,7036,7040,7043,7047,7050,7054,7059,7067,7069,7071,7074,7077,7080,7083,7089,7092,7095,7098,7102,7106,7110,7114,7118,7122,7126,7138,7142,7355,7356,7357,7358,7359,7360,7361,7362,7363,7366,7408,7411,7420,14685,14686,14687,14692,14693,14694,14697,14698,14699,30243,30245,31026,31208) 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(4584,4585,4586,4587,4588,4589,4590,4591,4592,4593,4594,4595,4206,4563,4564,4571,4576,6996,6999,7005,7008,7012,7016,7020,7024,7028,7032,7036,7040,7043,7047,7050,7054,7059,7067,7069,7071,7074,7077,7080,7083,7089,7092,7095,7098,7102,7106,7110,7114,7118,7122,7126,7138,7142,7355,7356,7357,7358,7359,7360,7361,7362,7363,7366,7408,7411,7420,14685,14686,14687,14692,14693,14694,14697,14698,14699,30243,30245,31026,31208) 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(4584,4585,4586,4587,4588,4589,4590,4591,4592,4593,4594,4595,4206,4563,4564,4571,4576,6996,6999,7005,7008,7012,7016,7020,7024,7028,7032,7036,7040,7043,7047,7050,7054,7059,7067,7069,7071,7074,7077,7080,7083,7089,7092,7095,7098,7102,7106,7110,7114,7118,7122,7126,7138,7142,7355,7356,7357,7358,7359,7360,7361,7362,7363,7366,7408,7411,7420,14685,14686,14687,14692,14693,14694,14697,14698,14699,30243,30245,31026,31208) 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(4584,4585,4586,4587,4588,4589,4590,4591,4592,4593,4594,4595,4206,4563,4564,4571,4576,6996,6999,7005,7008,7012,7016,7020,7024,7028,7032,7036,7040,7043,7047,7050,7054,7059,7067,7069,7071,7074,7077,7080,7083,7089,7092,7095,7098,7102,7106,7110,7114,7118,7122,7126,7138,7142,7355,7356,7357,7358,7359,7360,7361,7362,7363,7366,7408,7411,7420,14685,14686,14687,14692,14693,14694,14697,14698,14699,30243,30245,31026,31208) 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` = 15263 AND `prints_set_vector`.`vector_id` IN(4584,4585,4586,4587,4588,4589,4590,4591,4592,4593,4594,4595,4206,4563,4564,4571,4576,6996,6999,7005,7008,7012,7016,7020,7024,7028,7032,7036,7040,7043,7047,7050,7054,7059,7067,7069,7071,7074,7077,7080,7083,7089,7092,7095,7098,7102,7106,7110,7114,7118,7122,7126,7138,7142,7355,7356,7357,7358,7359,7360,7361,7362,7363,7366,7408,7411,7420,14685,14686,14687,14692,14693,14694,14697,14698,14699,30243,30245,31026,31208) 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(4584,4585,4586,4587,4588,4589,4590,4591,4592,4593,4594,4595,4206,4563,4564,4571,4576,6996,6999,7005,7008,7012,7016,7020,7024,7028,7032,7036,7040,7043,7047,7050,7054,7059,7067,7069,7071,7074,7077,7080,7083,7089,7092,7095,7098,7102,7106,7110,7114,7118,7122,7126,7138,7142,7355,7356,7357,7358,7359,7360,7361,7362,7363,7366,7408,7411,7420,14685,14686,14687,14692,14693,14694,14697,14698,14699,30243,30245,31026,31208) 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(4584,4585,4586,4587,4588,4589,4590,4591,4592,4593,4594,4595,4206,4563,4564,4571,4576,6996,6999,7005,7008,7012,7016,7020,7024,7028,7032,7036,7040,7043,7047,7050,7054,7059,7067,7069,7071,7074,7077,7080,7083,7089,7092,7095,7098,7102,7106,7110,7114,7118,7122,7126,7138,7142,7355,7356,7357,7358,7359,7360,7361,7362,7363,7366,7408,7411,7420,14685,14686,14687,14692,14693,14694,14697,14698,14699,30243,30245,31026,31208) 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(4584,4585,4586,4587,4588,4589,4590,4591,4592,4593,4594,4595,4206,4563,4564,4571,4576,6996,6999,7005,7008,7012,7016,7020,7024,7028,7032,7036,7040,7043,7047,7050,7054,7059,7067,7069,7071,7074,7077,7080,7083,7089,7092,7095,7098,7102,7106,7110,7114,7118,7122,7126,7138,7142,7355,7356,7357,7358,7359,7360,7361,7362,7363,7366,7408,7411,7420,14685,14686,14687,14692,14693,14694,14697,14698,14699,30243,30245,31026,31208) 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(4584,4585,4586,4587,4588,4589,4590,4591,4592,4593,4594,4595,4206,4563,4564,4571,4576,6996,6999,7005,7008,7012,7016,7020,7024,7028,7032,7036,7040,7043,7047,7050,7054,7059,7067,7069,7071,7074,7077,7080,7083,7089,7092,7095,7098,7102,7106,7110,7114,7118,7122,7126,7138,7142,7355,7356,7357,7358,7359,7360,7361,7362,7363,7366,7408,7411,7420,14685,14686,14687,14692,14693,14694,14697,14698,14699,30243,30245,31026,31208) 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(4584,4585,4586,4587,4588,4589,4590,4591,4592,4593,4594,4595,4206,4563,4564,4571,4576,6996,6999,7005,7008,7012,7016,7020,7024,7028,7032,7036,7040,7043,7047,7050,7054,7059,7067,7069,7071,7074,7077,7080,7083,7089,7092,7095,7098,7102,7106,7110,7114,7118,7122,7126,7138,7142,7355,7356,7357,7358,7359,7360,7361,7362,7363,7366,7408,7411,7420,14685,14686,14687,14692,14693,14694,14697,14698,14699,30243,30245,31026,31208) 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 3
?q=Mazda 3&page=###page###
130
SELECT `id`, `name`, `type` FROM nox_group