/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(2414,2415,2428,2429,2430,2431,2738,2739,2740,2741,2742,2744,2745,2746,2747,2748,4207,4933,5034,5036,5038,7725,7727,7729,7731,7733,7735,7737,7739,7740,7741,8293,8294,8295,8296,8297,8298,8412,8413,8414,8415,8416,8417,10834,10835,10836,10837,10838,10839,10840,10841,10987,10988,10989,10990,10991,11331,11332,11333,11334,11336,12905,12906,12907,16229,16230,16231,16232,16233,16234,16235,16236,16237,16238,16239,16240,17411,17412,17413,17414,17415,17416,17475,17476,17477,17478,17479,17480,17481,17482,17483,17484,17485,17486,28181,29014,29712,29713,29714,29715,29716,29717,29774,29775,29776,29777,29778,29779,29784,29785,29886,29887,29888,29889,29890,29891,30283,30606))
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(2414,2415,2428,2429,2430,2431,2738,2739,2740,2741,2742,2744,2745,2746,2747,2748,4207,4933,5034,5036,5038,7725,7727,7729,7731,7733,7735,7737,7739,7740,7741,8293,8294,8295,8296,8297,8298,8412,8413,8414,8415,8416,8417,10834,10835,10836,10837,10838,10839,10840,10841,10987,10988,10989,10990,10991,11331,11332,11333,11334,11336,12905,12906,12907,16229,16230,16231,16232,16233,16234,16235,16236,16237,16238,16239,16240,17411,17412,17413,17414,17415,17416,17475,17476,17477,17478,17479,17480,17481,17482,17483,17484,17485,17486,28181,29014,29712,29713,29714,29715,29716,29717,29774,29775,29776,29777,29778,29779,29784,29785,29886,29887,29888,29889,29890,29891,30283,30606)) 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(13145, 29754, 34212, 35376, 30024, 5656, 31603, 8029, 8031, 8015, 8016, 8684, 8765, 8758, 8750, 11448, 34094, 11466, 11465, 11467, 18244, 18309, 35899, 35900, 36328, 35953) 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` = 8015 AND `prints_set_vector`.`vector_id` IN(2414,2415,2428,2429,2430,2431,2738,2739,2740,2741,2742,2744,2745,2746,2747,2748,4207,4933,5034,5036,5038,7725,7727,7729,7731,7733,7735,7737,7739,7740,7741,8293,8294,8295,8296,8297,8298,8412,8413,8414,8415,8416,8417,10834,10835,10836,10837,10838,10839,10840,10841,10987,10988,10989,10990,10991,11331,11332,11333,11334,11336,12905,12906,12907,16229,16230,16231,16232,16233,16234,16235,16236,16237,16238,16239,16240,17411,17412,17413,17414,17415,17416,17475,17476,17477,17478,17479,17480,17481,17482,17483,17484,17485,17486,28181,29014,29712,29713,29714,29715,29716,29717,29774,29775,29776,29777,29778,29779,29784,29785,29886,29887,29888,29889,29890,29891,30283,30606) 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` = 8750 AND `prints_set_vector`.`vector_id` IN(2414,2415,2428,2429,2430,2431,2738,2739,2740,2741,2742,2744,2745,2746,2747,2748,4207,4933,5034,5036,5038,7725,7727,7729,7731,7733,7735,7737,7739,7740,7741,8293,8294,8295,8296,8297,8298,8412,8413,8414,8415,8416,8417,10834,10835,10836,10837,10838,10839,10840,10841,10987,10988,10989,10990,10991,11331,11332,11333,11334,11336,12905,12906,12907,16229,16230,16231,16232,16233,16234,16235,16236,16237,16238,16239,16240,17411,17412,17413,17414,17415,17416,17475,17476,17477,17478,17479,17480,17481,17482,17483,17484,17485,17486,28181,29014,29712,29713,29714,29715,29716,29717,29774,29775,29776,29777,29778,29779,29784,29785,29886,29887,29888,29889,29890,29891,30283,30606) 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` = 8758 AND `prints_set_vector`.`vector_id` IN(2414,2415,2428,2429,2430,2431,2738,2739,2740,2741,2742,2744,2745,2746,2747,2748,4207,4933,5034,5036,5038,7725,7727,7729,7731,7733,7735,7737,7739,7740,7741,8293,8294,8295,8296,8297,8298,8412,8413,8414,8415,8416,8417,10834,10835,10836,10837,10838,10839,10840,10841,10987,10988,10989,10990,10991,11331,11332,11333,11334,11336,12905,12906,12907,16229,16230,16231,16232,16233,16234,16235,16236,16237,16238,16239,16240,17411,17412,17413,17414,17415,17416,17475,17476,17477,17478,17479,17480,17481,17482,17483,17484,17485,17486,28181,29014,29712,29713,29714,29715,29716,29717,29774,29775,29776,29777,29778,29779,29784,29785,29886,29887,29888,29889,29890,29891,30283,30606) 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` = 8016 AND `prints_set_vector`.`vector_id` IN(2414,2415,2428,2429,2430,2431,2738,2739,2740,2741,2742,2744,2745,2746,2747,2748,4207,4933,5034,5036,5038,7725,7727,7729,7731,7733,7735,7737,7739,7740,7741,8293,8294,8295,8296,8297,8298,8412,8413,8414,8415,8416,8417,10834,10835,10836,10837,10838,10839,10840,10841,10987,10988,10989,10990,10991,11331,11332,11333,11334,11336,12905,12906,12907,16229,16230,16231,16232,16233,16234,16235,16236,16237,16238,16239,16240,17411,17412,17413,17414,17415,17416,17475,17476,17477,17478,17479,17480,17481,17482,17483,17484,17485,17486,28181,29014,29712,29713,29714,29715,29716,29717,29774,29775,29776,29777,29778,29779,29784,29785,29886,29887,29888,29889,29890,29891,30283,30606) 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` = 35899 AND `prints_set_vector`.`vector_id` IN(2414,2415,2428,2429,2430,2431,2738,2739,2740,2741,2742,2744,2745,2746,2747,2748,4207,4933,5034,5036,5038,7725,7727,7729,7731,7733,7735,7737,7739,7740,7741,8293,8294,8295,8296,8297,8298,8412,8413,8414,8415,8416,8417,10834,10835,10836,10837,10838,10839,10840,10841,10987,10988,10989,10990,10991,11331,11332,11333,11334,11336,12905,12906,12907,16229,16230,16231,16232,16233,16234,16235,16236,16237,16238,16239,16240,17411,17412,17413,17414,17415,17416,17475,17476,17477,17478,17479,17480,17481,17482,17483,17484,17485,17486,28181,29014,29712,29713,29714,29715,29716,29717,29774,29775,29776,29777,29778,29779,29784,29785,29886,29887,29888,29889,29890,29891,30283,30606) 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` = 35900 AND `prints_set_vector`.`vector_id` IN(2414,2415,2428,2429,2430,2431,2738,2739,2740,2741,2742,2744,2745,2746,2747,2748,4207,4933,5034,5036,5038,7725,7727,7729,7731,7733,7735,7737,7739,7740,7741,8293,8294,8295,8296,8297,8298,8412,8413,8414,8415,8416,8417,10834,10835,10836,10837,10838,10839,10840,10841,10987,10988,10989,10990,10991,11331,11332,11333,11334,11336,12905,12906,12907,16229,16230,16231,16232,16233,16234,16235,16236,16237,16238,16239,16240,17411,17412,17413,17414,17415,17416,17475,17476,17477,17478,17479,17480,17481,17482,17483,17484,17485,17486,28181,29014,29712,29713,29714,29715,29716,29717,29774,29775,29776,29777,29778,29779,29784,29785,29886,29887,29888,29889,29890,29891,30283,30606) 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` = 36328 AND `prints_set_vector`.`vector_id` IN(2414,2415,2428,2429,2430,2431,2738,2739,2740,2741,2742,2744,2745,2746,2747,2748,4207,4933,5034,5036,5038,7725,7727,7729,7731,7733,7735,7737,7739,7740,7741,8293,8294,8295,8296,8297,8298,8412,8413,8414,8415,8416,8417,10834,10835,10836,10837,10838,10839,10840,10841,10987,10988,10989,10990,10991,11331,11332,11333,11334,11336,12905,12906,12907,16229,16230,16231,16232,16233,16234,16235,16236,16237,16238,16239,16240,17411,17412,17413,17414,17415,17416,17475,17476,17477,17478,17479,17480,17481,17482,17483,17484,17485,17486,28181,29014,29712,29713,29714,29715,29716,29717,29774,29775,29776,29777,29778,29779,29784,29785,29886,29887,29888,29889,29890,29891,30283,30606) 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` = 18244 AND `prints_set_vector`.`vector_id` IN(2414,2415,2428,2429,2430,2431,2738,2739,2740,2741,2742,2744,2745,2746,2747,2748,4207,4933,5034,5036,5038,7725,7727,7729,7731,7733,7735,7737,7739,7740,7741,8293,8294,8295,8296,8297,8298,8412,8413,8414,8415,8416,8417,10834,10835,10836,10837,10838,10839,10840,10841,10987,10988,10989,10990,10991,11331,11332,11333,11334,11336,12905,12906,12907,16229,16230,16231,16232,16233,16234,16235,16236,16237,16238,16239,16240,17411,17412,17413,17414,17415,17416,17475,17476,17477,17478,17479,17480,17481,17482,17483,17484,17485,17486,28181,29014,29712,29713,29714,29715,29716,29717,29774,29775,29776,29777,29778,29779,29784,29785,29886,29887,29888,29889,29890,29891,30283,30606) 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` = 18309 AND `prints_set_vector`.`vector_id` IN(2414,2415,2428,2429,2430,2431,2738,2739,2740,2741,2742,2744,2745,2746,2747,2748,4207,4933,5034,5036,5038,7725,7727,7729,7731,7733,7735,7737,7739,7740,7741,8293,8294,8295,8296,8297,8298,8412,8413,8414,8415,8416,8417,10834,10835,10836,10837,10838,10839,10840,10841,10987,10988,10989,10990,10991,11331,11332,11333,11334,11336,12905,12906,12907,16229,16230,16231,16232,16233,16234,16235,16236,16237,16238,16239,16240,17411,17412,17413,17414,17415,17416,17475,17476,17477,17478,17479,17480,17481,17482,17483,17484,17485,17486,28181,29014,29712,29713,29714,29715,29716,29717,29774,29775,29776,29777,29778,29779,29784,29785,29886,29887,29888,29889,29890,29891,30283,30606) 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` = 35953 AND `prints_set_vector`.`vector_id` IN(2414,2415,2428,2429,2430,2431,2738,2739,2740,2741,2742,2744,2745,2746,2747,2748,4207,4933,5034,5036,5038,7725,7727,7729,7731,7733,7735,7737,7739,7740,7741,8293,8294,8295,8296,8297,8298,8412,8413,8414,8415,8416,8417,10834,10835,10836,10837,10838,10839,10840,10841,10987,10988,10989,10990,10991,11331,11332,11333,11334,11336,12905,12906,12907,16229,16230,16231,16232,16233,16234,16235,16236,16237,16238,16239,16240,17411,17412,17413,17414,17415,17416,17475,17476,17477,17478,17479,17480,17481,17482,17483,17484,17485,17486,28181,29014,29712,29713,29714,29715,29716,29717,29774,29775,29776,29777,29778,29779,29784,29785,29886,29887,29888,29889,29890,29891,30283,30606) 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` = 31603 AND `prints_set_vector`.`vector_id` IN(2414,2415,2428,2429,2430,2431,2738,2739,2740,2741,2742,2744,2745,2746,2747,2748,4207,4933,5034,5036,5038,7725,7727,7729,7731,7733,7735,7737,7739,7740,7741,8293,8294,8295,8296,8297,8298,8412,8413,8414,8415,8416,8417,10834,10835,10836,10837,10838,10839,10840,10841,10987,10988,10989,10990,10991,11331,11332,11333,11334,11336,12905,12906,12907,16229,16230,16231,16232,16233,16234,16235,16236,16237,16238,16239,16240,17411,17412,17413,17414,17415,17416,17475,17476,17477,17478,17479,17480,17481,17482,17483,17484,17485,17486,28181,29014,29712,29713,29714,29715,29716,29717,29774,29775,29776,29777,29778,29779,29784,29785,29886,29887,29888,29889,29890,29891,30283,30606) 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` = 8031 AND `prints_set_vector`.`vector_id` IN(2414,2415,2428,2429,2430,2431,2738,2739,2740,2741,2742,2744,2745,2746,2747,2748,4207,4933,5034,5036,5038,7725,7727,7729,7731,7733,7735,7737,7739,7740,7741,8293,8294,8295,8296,8297,8298,8412,8413,8414,8415,8416,8417,10834,10835,10836,10837,10838,10839,10840,10841,10987,10988,10989,10990,10991,11331,11332,11333,11334,11336,12905,12906,12907,16229,16230,16231,16232,16233,16234,16235,16236,16237,16238,16239,16240,17411,17412,17413,17414,17415,17416,17475,17476,17477,17478,17479,17480,17481,17482,17483,17484,17485,17486,28181,29014,29712,29713,29714,29715,29716,29717,29774,29775,29776,29777,29778,29779,29784,29785,29886,29887,29888,29889,29890,29891,30283,30606) 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` = 8029 AND `prints_set_vector`.`vector_id` IN(2414,2415,2428,2429,2430,2431,2738,2739,2740,2741,2742,2744,2745,2746,2747,2748,4207,4933,5034,5036,5038,7725,7727,7729,7731,7733,7735,7737,7739,7740,7741,8293,8294,8295,8296,8297,8298,8412,8413,8414,8415,8416,8417,10834,10835,10836,10837,10838,10839,10840,10841,10987,10988,10989,10990,10991,11331,11332,11333,11334,11336,12905,12906,12907,16229,16230,16231,16232,16233,16234,16235,16236,16237,16238,16239,16240,17411,17412,17413,17414,17415,17416,17475,17476,17477,17478,17479,17480,17481,17482,17483,17484,17485,17486,28181,29014,29712,29713,29714,29715,29716,29717,29774,29775,29776,29777,29778,29779,29784,29785,29886,29887,29888,29889,29890,29891,30283,30606) 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` = 8684 AND `prints_set_vector`.`vector_id` IN(2414,2415,2428,2429,2430,2431,2738,2739,2740,2741,2742,2744,2745,2746,2747,2748,4207,4933,5034,5036,5038,7725,7727,7729,7731,7733,7735,7737,7739,7740,7741,8293,8294,8295,8296,8297,8298,8412,8413,8414,8415,8416,8417,10834,10835,10836,10837,10838,10839,10840,10841,10987,10988,10989,10990,10991,11331,11332,11333,11334,11336,12905,12906,12907,16229,16230,16231,16232,16233,16234,16235,16236,16237,16238,16239,16240,17411,17412,17413,17414,17415,17416,17475,17476,17477,17478,17479,17480,17481,17482,17483,17484,17485,17486,28181,29014,29712,29713,29714,29715,29716,29717,29774,29775,29776,29777,29778,29779,29784,29785,29886,29887,29888,29889,29890,29891,30283,30606) 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` = 8765 AND `prints_set_vector`.`vector_id` IN(2414,2415,2428,2429,2430,2431,2738,2739,2740,2741,2742,2744,2745,2746,2747,2748,4207,4933,5034,5036,5038,7725,7727,7729,7731,7733,7735,7737,7739,7740,7741,8293,8294,8295,8296,8297,8298,8412,8413,8414,8415,8416,8417,10834,10835,10836,10837,10838,10839,10840,10841,10987,10988,10989,10990,10991,11331,11332,11333,11334,11336,12905,12906,12907,16229,16230,16231,16232,16233,16234,16235,16236,16237,16238,16239,16240,17411,17412,17413,17414,17415,17416,17475,17476,17477,17478,17479,17480,17481,17482,17483,17484,17485,17486,28181,29014,29712,29713,29714,29715,29716,29717,29774,29775,29776,29777,29778,29779,29784,29785,29886,29887,29888,29889,29890,29891,30283,30606) 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` = 35376 AND `prints_set_vector`.`vector_id` IN(2414,2415,2428,2429,2430,2431,2738,2739,2740,2741,2742,2744,2745,2746,2747,2748,4207,4933,5034,5036,5038,7725,7727,7729,7731,7733,7735,7737,7739,7740,7741,8293,8294,8295,8296,8297,8298,8412,8413,8414,8415,8416,8417,10834,10835,10836,10837,10838,10839,10840,10841,10987,10988,10989,10990,10991,11331,11332,11333,11334,11336,12905,12906,12907,16229,16230,16231,16232,16233,16234,16235,16236,16237,16238,16239,16240,17411,17412,17413,17414,17415,17416,17475,17476,17477,17478,17479,17480,17481,17482,17483,17484,17485,17486,28181,29014,29712,29713,29714,29715,29716,29717,29774,29775,29776,29777,29778,29779,29784,29785,29886,29887,29888,29889,29890,29891,30283,30606) 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(2414,2415,2428,2429,2430,2431,2738,2739,2740,2741,2742,2744,2745,2746,2747,2748,4207,4933,5034,5036,5038,7725,7727,7729,7731,7733,7735,7737,7739,7740,7741,8293,8294,8295,8296,8297,8298,8412,8413,8414,8415,8416,8417,10834,10835,10836,10837,10838,10839,10840,10841,10987,10988,10989,10990,10991,11331,11332,11333,11334,11336,12905,12906,12907,16229,16230,16231,16232,16233,16234,16235,16236,16237,16238,16239,16240,17411,17412,17413,17414,17415,17416,17475,17476,17477,17478,17479,17480,17481,17482,17483,17484,17485,17486,28181,29014,29712,29713,29714,29715,29716,29717,29774,29775,29776,29777,29778,29779,29784,29785,29886,29887,29888,29889,29890,29891,30283,30606) 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` = 11448 AND `prints_set_vector`.`vector_id` IN(2414,2415,2428,2429,2430,2431,2738,2739,2740,2741,2742,2744,2745,2746,2747,2748,4207,4933,5034,5036,5038,7725,7727,7729,7731,7733,7735,7737,7739,7740,7741,8293,8294,8295,8296,8297,8298,8412,8413,8414,8415,8416,8417,10834,10835,10836,10837,10838,10839,10840,10841,10987,10988,10989,10990,10991,11331,11332,11333,11334,11336,12905,12906,12907,16229,16230,16231,16232,16233,16234,16235,16236,16237,16238,16239,16240,17411,17412,17413,17414,17415,17416,17475,17476,17477,17478,17479,17480,17481,17482,17483,17484,17485,17486,28181,29014,29712,29713,29714,29715,29716,29717,29774,29775,29776,29777,29778,29779,29784,29785,29886,29887,29888,29889,29890,29891,30283,30606) 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` = 34094 AND `prints_set_vector`.`vector_id` IN(2414,2415,2428,2429,2430,2431,2738,2739,2740,2741,2742,2744,2745,2746,2747,2748,4207,4933,5034,5036,5038,7725,7727,7729,7731,7733,7735,7737,7739,7740,7741,8293,8294,8295,8296,8297,8298,8412,8413,8414,8415,8416,8417,10834,10835,10836,10837,10838,10839,10840,10841,10987,10988,10989,10990,10991,11331,11332,11333,11334,11336,12905,12906,12907,16229,16230,16231,16232,16233,16234,16235,16236,16237,16238,16239,16240,17411,17412,17413,17414,17415,17416,17475,17476,17477,17478,17479,17480,17481,17482,17483,17484,17485,17486,28181,29014,29712,29713,29714,29715,29716,29717,29774,29775,29776,29777,29778,29779,29784,29785,29886,29887,29888,29889,29890,29891,30283,30606) 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` = 30024 AND `prints_set_vector`.`vector_id` IN(2414,2415,2428,2429,2430,2431,2738,2739,2740,2741,2742,2744,2745,2746,2747,2748,4207,4933,5034,5036,5038,7725,7727,7729,7731,7733,7735,7737,7739,7740,7741,8293,8294,8295,8296,8297,8298,8412,8413,8414,8415,8416,8417,10834,10835,10836,10837,10838,10839,10840,10841,10987,10988,10989,10990,10991,11331,11332,11333,11334,11336,12905,12906,12907,16229,16230,16231,16232,16233,16234,16235,16236,16237,16238,16239,16240,17411,17412,17413,17414,17415,17416,17475,17476,17477,17478,17479,17480,17481,17482,17483,17484,17485,17486,28181,29014,29712,29713,29714,29715,29716,29717,29774,29775,29776,29777,29778,29779,29784,29785,29886,29887,29888,29889,29890,29891,30283,30606) 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` = 5656 AND `prints_set_vector`.`vector_id` IN(2414,2415,2428,2429,2430,2431,2738,2739,2740,2741,2742,2744,2745,2746,2747,2748,4207,4933,5034,5036,5038,7725,7727,7729,7731,7733,7735,7737,7739,7740,7741,8293,8294,8295,8296,8297,8298,8412,8413,8414,8415,8416,8417,10834,10835,10836,10837,10838,10839,10840,10841,10987,10988,10989,10990,10991,11331,11332,11333,11334,11336,12905,12906,12907,16229,16230,16231,16232,16233,16234,16235,16236,16237,16238,16239,16240,17411,17412,17413,17414,17415,17416,17475,17476,17477,17478,17479,17480,17481,17482,17483,17484,17485,17486,28181,29014,29712,29713,29714,29715,29716,29717,29774,29775,29776,29777,29778,29779,29784,29785,29886,29887,29888,29889,29890,29891,30283,30606) 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` = 11466 AND `prints_set_vector`.`vector_id` IN(2414,2415,2428,2429,2430,2431,2738,2739,2740,2741,2742,2744,2745,2746,2747,2748,4207,4933,5034,5036,5038,7725,7727,7729,7731,7733,7735,7737,7739,7740,7741,8293,8294,8295,8296,8297,8298,8412,8413,8414,8415,8416,8417,10834,10835,10836,10837,10838,10839,10840,10841,10987,10988,10989,10990,10991,11331,11332,11333,11334,11336,12905,12906,12907,16229,16230,16231,16232,16233,16234,16235,16236,16237,16238,16239,16240,17411,17412,17413,17414,17415,17416,17475,17476,17477,17478,17479,17480,17481,17482,17483,17484,17485,17486,28181,29014,29712,29713,29714,29715,29716,29717,29774,29775,29776,29777,29778,29779,29784,29785,29886,29887,29888,29889,29890,29891,30283,30606) 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` = 11467 AND `prints_set_vector`.`vector_id` IN(2414,2415,2428,2429,2430,2431,2738,2739,2740,2741,2742,2744,2745,2746,2747,2748,4207,4933,5034,5036,5038,7725,7727,7729,7731,7733,7735,7737,7739,7740,7741,8293,8294,8295,8296,8297,8298,8412,8413,8414,8415,8416,8417,10834,10835,10836,10837,10838,10839,10840,10841,10987,10988,10989,10990,10991,11331,11332,11333,11334,11336,12905,12906,12907,16229,16230,16231,16232,16233,16234,16235,16236,16237,16238,16239,16240,17411,17412,17413,17414,17415,17416,17475,17476,17477,17478,17479,17480,17481,17482,17483,17484,17485,17486,28181,29014,29712,29713,29714,29715,29716,29717,29774,29775,29776,29777,29778,29779,29784,29785,29886,29887,29888,29889,29890,29891,30283,30606) 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` = 11465 AND `prints_set_vector`.`vector_id` IN(2414,2415,2428,2429,2430,2431,2738,2739,2740,2741,2742,2744,2745,2746,2747,2748,4207,4933,5034,5036,5038,7725,7727,7729,7731,7733,7735,7737,7739,7740,7741,8293,8294,8295,8296,8297,8298,8412,8413,8414,8415,8416,8417,10834,10835,10836,10837,10838,10839,10840,10841,10987,10988,10989,10990,10991,11331,11332,11333,11334,11336,12905,12906,12907,16229,16230,16231,16232,16233,16234,16235,16236,16237,16238,16239,16240,17411,17412,17413,17414,17415,17416,17475,17476,17477,17478,17479,17480,17481,17482,17483,17484,17485,17486,28181,29014,29712,29713,29714,29715,29716,29717,29774,29775,29776,29777,29778,29779,29784,29785,29886,29887,29888,29889,29890,29891,30283,30606) 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` = 13145 AND `prints_set_vector`.`vector_id` IN(2414,2415,2428,2429,2430,2431,2738,2739,2740,2741,2742,2744,2745,2746,2747,2748,4207,4933,5034,5036,5038,7725,7727,7729,7731,7733,7735,7737,7739,7740,7741,8293,8294,8295,8296,8297,8298,8412,8413,8414,8415,8416,8417,10834,10835,10836,10837,10838,10839,10840,10841,10987,10988,10989,10990,10991,11331,11332,11333,11334,11336,12905,12906,12907,16229,16230,16231,16232,16233,16234,16235,16236,16237,16238,16239,16240,17411,17412,17413,17414,17415,17416,17475,17476,17477,17478,17479,17480,17481,17482,17483,17484,17485,17486,28181,29014,29712,29713,29714,29715,29716,29717,29774,29775,29776,29777,29778,29779,29784,29785,29886,29887,29888,29889,29890,29891,30283,30606) 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` = 29754 AND `prints_set_vector`.`vector_id` IN(2414,2415,2428,2429,2430,2431,2738,2739,2740,2741,2742,2744,2745,2746,2747,2748,4207,4933,5034,5036,5038,7725,7727,7729,7731,7733,7735,7737,7739,7740,7741,8293,8294,8295,8296,8297,8298,8412,8413,8414,8415,8416,8417,10834,10835,10836,10837,10838,10839,10840,10841,10987,10988,10989,10990,10991,11331,11332,11333,11334,11336,12905,12906,12907,16229,16230,16231,16232,16233,16234,16235,16236,16237,16238,16239,16240,17411,17412,17413,17414,17415,17416,17475,17476,17477,17478,17479,17480,17481,17482,17483,17484,17485,17486,28181,29014,29712,29713,29714,29715,29716,29717,29774,29775,29776,29777,29778,29779,29784,29785,29886,29887,29888,29889,29890,29891,30283,30606) 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(2414,2415,2428,2429,2430,2431,2738,2739,2740,2741,2742,2744,2745,2746,2747,2748,4207,4933,5034,5036,5038,7725,7727,7729,7731,7733,7735,7737,7739,7740,7741,8293,8294,8295,8296,8297,8298,8412,8413,8414,8415,8416,8417,10834,10835,10836,10837,10838,10839,10840,10841,10987,10988,10989,10990,10991,11331,11332,11333,11334,11336,12905,12906,12907,16229,16230,16231,16232,16233,16234,16235,16236,16237,16238,16239,16240,17411,17412,17413,17414,17415,17416,17475,17476,17477,17478,17479,17480,17481,17482,17483,17484,17485,17486,28181,29014,29712,29713,29714,29715,29716,29717,29774,29775,29776,29777,29778,29779,29784,29785,29886,29887,29888,29889,29890,29891,30283,30606) 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 4
?q=130&page=###page###
187
SELECT `id`, `name`, `type` FROM nox_group