/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(16295,16298,16301,21547,21548,21559,21560,21563,21564,21598,21599,21600,22181,22182,22183,22223,22224,22225,22265,22266,22267,22307,22308,22309,22349,22350,22351,22391,22392,22393,22433,22434,22435,22475,22476,22477,22517,22518,22519,22559,22560,22561,22601,22602,22603,22643,22644,22645,22685,22686,22687,22727,22728,22729,22769,22770,22771,22811,22812,22813,22853,22854,22855,22895,22896,22897,22937,22938,22939,22968,22969,22970,22998,22999,23000,23028,23029,23030,23040,23053,23066,23079,23092,23105,23115,23122,23129,23136,23143,23150,23160,23174,23189,23202,23215,23228,23238,23245,23255,23269,23282,23295,23308,23321,23331,23338,23345,23352,23359,23366,23376,23389,23402,23415,23424,23441,23451,23458,23465,23472,23479,23486,23496,23509,23522,23535,23548,23561,23571,23578,23585,23592,23599,23606,23616,23629,23642,23654,23667,23680,23690,23697,23704,23711,23718,23725,23726,23736,23749,23762,23775,23788,23801,23811,23818,23825,23832,23839,23846,23856,23869,23882,23895,23908,23921,23931,23938,23939,23946,23953,23960,23967,24842,24855,24868,24882,24894,24906,25163,25177,25188,25201,25212,25227,25240,25251,25272,25283,25296,25309,25322,25334,25345,25356,25367,25378,25391,25404,25417,25430,25441,25451,25462,25473,25486,25499,25512,25525,25536,25547,25558,25569,25582,25595,25608,25621,25633,25644,25655,25666,25679,25692,25718,25729,25740,25751,25761,25774,25787,25800,25813,25824,25835,25846,25857,25870,25883,25896,25909,25920,25931,25942,26431,26445,26459,26473,26487,26499,26511,26523,26531,26537,26543,26549,26863,26877,26891,26905,26919,26931,26943,26955,26964,26970,26976,26981,26991,27005,27020,27034,27048,27060,27072,27084,27092,27098,27104,27110,27273,27287,27301,27315,27327,27339,27351,27679,27694,27708,27722,27736,27748,27760,27772,28830,29473,29474,29475,29476,29477,29478,29479,29480,30348,30349,30350,30351,30352,30353,30443,30456,30698,30828,30830,31189,31351,31387,31453,31454,31455,31456,31457,31458,31473,31481,31565))
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(16295,16298,16301,21547,21548,21559,21560,21563,21564,21598,21599,21600,22181,22182,22183,22223,22224,22225,22265,22266,22267,22307,22308,22309,22349,22350,22351,22391,22392,22393,22433,22434,22435,22475,22476,22477,22517,22518,22519,22559,22560,22561,22601,22602,22603,22643,22644,22645,22685,22686,22687,22727,22728,22729,22769,22770,22771,22811,22812,22813,22853,22854,22855,22895,22896,22897,22937,22938,22939,22968,22969,22970,22998,22999,23000,23028,23029,23030,23040,23053,23066,23079,23092,23105,23115,23122,23129,23136,23143,23150,23160,23174,23189,23202,23215,23228,23238,23245,23255,23269,23282,23295,23308,23321,23331,23338,23345,23352,23359,23366,23376,23389,23402,23415,23424,23441,23451,23458,23465,23472,23479,23486,23496,23509,23522,23535,23548,23561,23571,23578,23585,23592,23599,23606,23616,23629,23642,23654,23667,23680,23690,23697,23704,23711,23718,23725,23726,23736,23749,23762,23775,23788,23801,23811,23818,23825,23832,23839,23846,23856,23869,23882,23895,23908,23921,23931,23938,23939,23946,23953,23960,23967,24842,24855,24868,24882,24894,24906,25163,25177,25188,25201,25212,25227,25240,25251,25272,25283,25296,25309,25322,25334,25345,25356,25367,25378,25391,25404,25417,25430,25441,25451,25462,25473,25486,25499,25512,25525,25536,25547,25558,25569,25582,25595,25608,25621,25633,25644,25655,25666,25679,25692,25718,25729,25740,25751,25761,25774,25787,25800,25813,25824,25835,25846,25857,25870,25883,25896,25909,25920,25931,25942,26431,26445,26459,26473,26487,26499,26511,26523,26531,26537,26543,26549,26863,26877,26891,26905,26919,26931,26943,26955,26964,26970,26976,26981,26991,27005,27020,27034,27048,27060,27072,27084,27092,27098,27104,27110,27273,27287,27301,27315,27327,27339,27351,27679,27694,27708,27722,27736,27748,27760,27772,28830,29473,29474,29475,29476,29477,29478,29479,29480,30348,30349,30350,30351,30352,30353,30443,30456,30698,30828,30830,31189,31351,31387,31453,31454,31455,31456,31457,31458,31473,31481,31565)) 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(17092, 32339, 24966, 26952, 28803, 36195, 36005, 34202) 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` = 34202 AND `prints_set_vector`.`vector_id` IN(16295,16298,16301,21547,21548,21559,21560,21563,21564,21598,21599,21600,22181,22182,22183,22223,22224,22225,22265,22266,22267,22307,22308,22309,22349,22350,22351,22391,22392,22393,22433,22434,22435,22475,22476,22477,22517,22518,22519,22559,22560,22561,22601,22602,22603,22643,22644,22645,22685,22686,22687,22727,22728,22729,22769,22770,22771,22811,22812,22813,22853,22854,22855,22895,22896,22897,22937,22938,22939,22968,22969,22970,22998,22999,23000,23028,23029,23030,23040,23053,23066,23079,23092,23105,23115,23122,23129,23136,23143,23150,23160,23174,23189,23202,23215,23228,23238,23245,23255,23269,23282,23295,23308,23321,23331,23338,23345,23352,23359,23366,23376,23389,23402,23415,23424,23441,23451,23458,23465,23472,23479,23486,23496,23509,23522,23535,23548,23561,23571,23578,23585,23592,23599,23606,23616,23629,23642,23654,23667,23680,23690,23697,23704,23711,23718,23725,23726,23736,23749,23762,23775,23788,23801,23811,23818,23825,23832,23839,23846,23856,23869,23882,23895,23908,23921,23931,23938,23939,23946,23953,23960,23967,24842,24855,24868,24882,24894,24906,25163,25177,25188,25201,25212,25227,25240,25251,25272,25283,25296,25309,25322,25334,25345,25356,25367,25378,25391,25404,25417,25430,25441,25451,25462,25473,25486,25499,25512,25525,25536,25547,25558,25569,25582,25595,25608,25621,25633,25644,25655,25666,25679,25692,25718,25729,25740,25751,25761,25774,25787,25800,25813,25824,25835,25846,25857,25870,25883,25896,25909,25920,25931,25942,26431,26445,26459,26473,26487,26499,26511,26523,26531,26537,26543,26549,26863,26877,26891,26905,26919,26931,26943,26955,26964,26970,26976,26981,26991,27005,27020,27034,27048,27060,27072,27084,27092,27098,27104,27110,27273,27287,27301,27315,27327,27339,27351,27679,27694,27708,27722,27736,27748,27760,27772,28830,29473,29474,29475,29476,29477,29478,29479,29480,30348,30349,30350,30351,30352,30353,30443,30456,30698,30828,30830,31189,31351,31387,31453,31454,31455,31456,31457,31458,31473,31481,31565) 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` = 36195 AND `prints_set_vector`.`vector_id` IN(16295,16298,16301,21547,21548,21559,21560,21563,21564,21598,21599,21600,22181,22182,22183,22223,22224,22225,22265,22266,22267,22307,22308,22309,22349,22350,22351,22391,22392,22393,22433,22434,22435,22475,22476,22477,22517,22518,22519,22559,22560,22561,22601,22602,22603,22643,22644,22645,22685,22686,22687,22727,22728,22729,22769,22770,22771,22811,22812,22813,22853,22854,22855,22895,22896,22897,22937,22938,22939,22968,22969,22970,22998,22999,23000,23028,23029,23030,23040,23053,23066,23079,23092,23105,23115,23122,23129,23136,23143,23150,23160,23174,23189,23202,23215,23228,23238,23245,23255,23269,23282,23295,23308,23321,23331,23338,23345,23352,23359,23366,23376,23389,23402,23415,23424,23441,23451,23458,23465,23472,23479,23486,23496,23509,23522,23535,23548,23561,23571,23578,23585,23592,23599,23606,23616,23629,23642,23654,23667,23680,23690,23697,23704,23711,23718,23725,23726,23736,23749,23762,23775,23788,23801,23811,23818,23825,23832,23839,23846,23856,23869,23882,23895,23908,23921,23931,23938,23939,23946,23953,23960,23967,24842,24855,24868,24882,24894,24906,25163,25177,25188,25201,25212,25227,25240,25251,25272,25283,25296,25309,25322,25334,25345,25356,25367,25378,25391,25404,25417,25430,25441,25451,25462,25473,25486,25499,25512,25525,25536,25547,25558,25569,25582,25595,25608,25621,25633,25644,25655,25666,25679,25692,25718,25729,25740,25751,25761,25774,25787,25800,25813,25824,25835,25846,25857,25870,25883,25896,25909,25920,25931,25942,26431,26445,26459,26473,26487,26499,26511,26523,26531,26537,26543,26549,26863,26877,26891,26905,26919,26931,26943,26955,26964,26970,26976,26981,26991,27005,27020,27034,27048,27060,27072,27084,27092,27098,27104,27110,27273,27287,27301,27315,27327,27339,27351,27679,27694,27708,27722,27736,27748,27760,27772,28830,29473,29474,29475,29476,29477,29478,29479,29480,30348,30349,30350,30351,30352,30353,30443,30456,30698,30828,30830,31189,31351,31387,31453,31454,31455,31456,31457,31458,31473,31481,31565) 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` = 32339 AND `prints_set_vector`.`vector_id` IN(16295,16298,16301,21547,21548,21559,21560,21563,21564,21598,21599,21600,22181,22182,22183,22223,22224,22225,22265,22266,22267,22307,22308,22309,22349,22350,22351,22391,22392,22393,22433,22434,22435,22475,22476,22477,22517,22518,22519,22559,22560,22561,22601,22602,22603,22643,22644,22645,22685,22686,22687,22727,22728,22729,22769,22770,22771,22811,22812,22813,22853,22854,22855,22895,22896,22897,22937,22938,22939,22968,22969,22970,22998,22999,23000,23028,23029,23030,23040,23053,23066,23079,23092,23105,23115,23122,23129,23136,23143,23150,23160,23174,23189,23202,23215,23228,23238,23245,23255,23269,23282,23295,23308,23321,23331,23338,23345,23352,23359,23366,23376,23389,23402,23415,23424,23441,23451,23458,23465,23472,23479,23486,23496,23509,23522,23535,23548,23561,23571,23578,23585,23592,23599,23606,23616,23629,23642,23654,23667,23680,23690,23697,23704,23711,23718,23725,23726,23736,23749,23762,23775,23788,23801,23811,23818,23825,23832,23839,23846,23856,23869,23882,23895,23908,23921,23931,23938,23939,23946,23953,23960,23967,24842,24855,24868,24882,24894,24906,25163,25177,25188,25201,25212,25227,25240,25251,25272,25283,25296,25309,25322,25334,25345,25356,25367,25378,25391,25404,25417,25430,25441,25451,25462,25473,25486,25499,25512,25525,25536,25547,25558,25569,25582,25595,25608,25621,25633,25644,25655,25666,25679,25692,25718,25729,25740,25751,25761,25774,25787,25800,25813,25824,25835,25846,25857,25870,25883,25896,25909,25920,25931,25942,26431,26445,26459,26473,26487,26499,26511,26523,26531,26537,26543,26549,26863,26877,26891,26905,26919,26931,26943,26955,26964,26970,26976,26981,26991,27005,27020,27034,27048,27060,27072,27084,27092,27098,27104,27110,27273,27287,27301,27315,27327,27339,27351,27679,27694,27708,27722,27736,27748,27760,27772,28830,29473,29474,29475,29476,29477,29478,29479,29480,30348,30349,30350,30351,30352,30353,30443,30456,30698,30828,30830,31189,31351,31387,31453,31454,31455,31456,31457,31458,31473,31481,31565) 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` = 17092 AND `prints_set_vector`.`vector_id` IN(16295,16298,16301,21547,21548,21559,21560,21563,21564,21598,21599,21600,22181,22182,22183,22223,22224,22225,22265,22266,22267,22307,22308,22309,22349,22350,22351,22391,22392,22393,22433,22434,22435,22475,22476,22477,22517,22518,22519,22559,22560,22561,22601,22602,22603,22643,22644,22645,22685,22686,22687,22727,22728,22729,22769,22770,22771,22811,22812,22813,22853,22854,22855,22895,22896,22897,22937,22938,22939,22968,22969,22970,22998,22999,23000,23028,23029,23030,23040,23053,23066,23079,23092,23105,23115,23122,23129,23136,23143,23150,23160,23174,23189,23202,23215,23228,23238,23245,23255,23269,23282,23295,23308,23321,23331,23338,23345,23352,23359,23366,23376,23389,23402,23415,23424,23441,23451,23458,23465,23472,23479,23486,23496,23509,23522,23535,23548,23561,23571,23578,23585,23592,23599,23606,23616,23629,23642,23654,23667,23680,23690,23697,23704,23711,23718,23725,23726,23736,23749,23762,23775,23788,23801,23811,23818,23825,23832,23839,23846,23856,23869,23882,23895,23908,23921,23931,23938,23939,23946,23953,23960,23967,24842,24855,24868,24882,24894,24906,25163,25177,25188,25201,25212,25227,25240,25251,25272,25283,25296,25309,25322,25334,25345,25356,25367,25378,25391,25404,25417,25430,25441,25451,25462,25473,25486,25499,25512,25525,25536,25547,25558,25569,25582,25595,25608,25621,25633,25644,25655,25666,25679,25692,25718,25729,25740,25751,25761,25774,25787,25800,25813,25824,25835,25846,25857,25870,25883,25896,25909,25920,25931,25942,26431,26445,26459,26473,26487,26499,26511,26523,26531,26537,26543,26549,26863,26877,26891,26905,26919,26931,26943,26955,26964,26970,26976,26981,26991,27005,27020,27034,27048,27060,27072,27084,27092,27098,27104,27110,27273,27287,27301,27315,27327,27339,27351,27679,27694,27708,27722,27736,27748,27760,27772,28830,29473,29474,29475,29476,29477,29478,29479,29480,30348,30349,30350,30351,30352,30353,30443,30456,30698,30828,30830,31189,31351,31387,31453,31454,31455,31456,31457,31458,31473,31481,31565) 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` = 36005 AND `prints_set_vector`.`vector_id` IN(16295,16298,16301,21547,21548,21559,21560,21563,21564,21598,21599,21600,22181,22182,22183,22223,22224,22225,22265,22266,22267,22307,22308,22309,22349,22350,22351,22391,22392,22393,22433,22434,22435,22475,22476,22477,22517,22518,22519,22559,22560,22561,22601,22602,22603,22643,22644,22645,22685,22686,22687,22727,22728,22729,22769,22770,22771,22811,22812,22813,22853,22854,22855,22895,22896,22897,22937,22938,22939,22968,22969,22970,22998,22999,23000,23028,23029,23030,23040,23053,23066,23079,23092,23105,23115,23122,23129,23136,23143,23150,23160,23174,23189,23202,23215,23228,23238,23245,23255,23269,23282,23295,23308,23321,23331,23338,23345,23352,23359,23366,23376,23389,23402,23415,23424,23441,23451,23458,23465,23472,23479,23486,23496,23509,23522,23535,23548,23561,23571,23578,23585,23592,23599,23606,23616,23629,23642,23654,23667,23680,23690,23697,23704,23711,23718,23725,23726,23736,23749,23762,23775,23788,23801,23811,23818,23825,23832,23839,23846,23856,23869,23882,23895,23908,23921,23931,23938,23939,23946,23953,23960,23967,24842,24855,24868,24882,24894,24906,25163,25177,25188,25201,25212,25227,25240,25251,25272,25283,25296,25309,25322,25334,25345,25356,25367,25378,25391,25404,25417,25430,25441,25451,25462,25473,25486,25499,25512,25525,25536,25547,25558,25569,25582,25595,25608,25621,25633,25644,25655,25666,25679,25692,25718,25729,25740,25751,25761,25774,25787,25800,25813,25824,25835,25846,25857,25870,25883,25896,25909,25920,25931,25942,26431,26445,26459,26473,26487,26499,26511,26523,26531,26537,26543,26549,26863,26877,26891,26905,26919,26931,26943,26955,26964,26970,26976,26981,26991,27005,27020,27034,27048,27060,27072,27084,27092,27098,27104,27110,27273,27287,27301,27315,27327,27339,27351,27679,27694,27708,27722,27736,27748,27760,27772,28830,29473,29474,29475,29476,29477,29478,29479,29480,30348,30349,30350,30351,30352,30353,30443,30456,30698,30828,30830,31189,31351,31387,31453,31454,31455,31456,31457,31458,31473,31481,31565) 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` = 28803 AND `prints_set_vector`.`vector_id` IN(16295,16298,16301,21547,21548,21559,21560,21563,21564,21598,21599,21600,22181,22182,22183,22223,22224,22225,22265,22266,22267,22307,22308,22309,22349,22350,22351,22391,22392,22393,22433,22434,22435,22475,22476,22477,22517,22518,22519,22559,22560,22561,22601,22602,22603,22643,22644,22645,22685,22686,22687,22727,22728,22729,22769,22770,22771,22811,22812,22813,22853,22854,22855,22895,22896,22897,22937,22938,22939,22968,22969,22970,22998,22999,23000,23028,23029,23030,23040,23053,23066,23079,23092,23105,23115,23122,23129,23136,23143,23150,23160,23174,23189,23202,23215,23228,23238,23245,23255,23269,23282,23295,23308,23321,23331,23338,23345,23352,23359,23366,23376,23389,23402,23415,23424,23441,23451,23458,23465,23472,23479,23486,23496,23509,23522,23535,23548,23561,23571,23578,23585,23592,23599,23606,23616,23629,23642,23654,23667,23680,23690,23697,23704,23711,23718,23725,23726,23736,23749,23762,23775,23788,23801,23811,23818,23825,23832,23839,23846,23856,23869,23882,23895,23908,23921,23931,23938,23939,23946,23953,23960,23967,24842,24855,24868,24882,24894,24906,25163,25177,25188,25201,25212,25227,25240,25251,25272,25283,25296,25309,25322,25334,25345,25356,25367,25378,25391,25404,25417,25430,25441,25451,25462,25473,25486,25499,25512,25525,25536,25547,25558,25569,25582,25595,25608,25621,25633,25644,25655,25666,25679,25692,25718,25729,25740,25751,25761,25774,25787,25800,25813,25824,25835,25846,25857,25870,25883,25896,25909,25920,25931,25942,26431,26445,26459,26473,26487,26499,26511,26523,26531,26537,26543,26549,26863,26877,26891,26905,26919,26931,26943,26955,26964,26970,26976,26981,26991,27005,27020,27034,27048,27060,27072,27084,27092,27098,27104,27110,27273,27287,27301,27315,27327,27339,27351,27679,27694,27708,27722,27736,27748,27760,27772,28830,29473,29474,29475,29476,29477,29478,29479,29480,30348,30349,30350,30351,30352,30353,30443,30456,30698,30828,30830,31189,31351,31387,31453,31454,31455,31456,31457,31458,31473,31481,31565) 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` = 26952 AND `prints_set_vector`.`vector_id` IN(16295,16298,16301,21547,21548,21559,21560,21563,21564,21598,21599,21600,22181,22182,22183,22223,22224,22225,22265,22266,22267,22307,22308,22309,22349,22350,22351,22391,22392,22393,22433,22434,22435,22475,22476,22477,22517,22518,22519,22559,22560,22561,22601,22602,22603,22643,22644,22645,22685,22686,22687,22727,22728,22729,22769,22770,22771,22811,22812,22813,22853,22854,22855,22895,22896,22897,22937,22938,22939,22968,22969,22970,22998,22999,23000,23028,23029,23030,23040,23053,23066,23079,23092,23105,23115,23122,23129,23136,23143,23150,23160,23174,23189,23202,23215,23228,23238,23245,23255,23269,23282,23295,23308,23321,23331,23338,23345,23352,23359,23366,23376,23389,23402,23415,23424,23441,23451,23458,23465,23472,23479,23486,23496,23509,23522,23535,23548,23561,23571,23578,23585,23592,23599,23606,23616,23629,23642,23654,23667,23680,23690,23697,23704,23711,23718,23725,23726,23736,23749,23762,23775,23788,23801,23811,23818,23825,23832,23839,23846,23856,23869,23882,23895,23908,23921,23931,23938,23939,23946,23953,23960,23967,24842,24855,24868,24882,24894,24906,25163,25177,25188,25201,25212,25227,25240,25251,25272,25283,25296,25309,25322,25334,25345,25356,25367,25378,25391,25404,25417,25430,25441,25451,25462,25473,25486,25499,25512,25525,25536,25547,25558,25569,25582,25595,25608,25621,25633,25644,25655,25666,25679,25692,25718,25729,25740,25751,25761,25774,25787,25800,25813,25824,25835,25846,25857,25870,25883,25896,25909,25920,25931,25942,26431,26445,26459,26473,26487,26499,26511,26523,26531,26537,26543,26549,26863,26877,26891,26905,26919,26931,26943,26955,26964,26970,26976,26981,26991,27005,27020,27034,27048,27060,27072,27084,27092,27098,27104,27110,27273,27287,27301,27315,27327,27339,27351,27679,27694,27708,27722,27736,27748,27760,27772,28830,29473,29474,29475,29476,29477,29478,29479,29480,30348,30349,30350,30351,30352,30353,30443,30456,30698,30828,30830,31189,31351,31387,31453,31454,31455,31456,31457,31458,31473,31481,31565) 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` = 24966 AND `prints_set_vector`.`vector_id` IN(16295,16298,16301,21547,21548,21559,21560,21563,21564,21598,21599,21600,22181,22182,22183,22223,22224,22225,22265,22266,22267,22307,22308,22309,22349,22350,22351,22391,22392,22393,22433,22434,22435,22475,22476,22477,22517,22518,22519,22559,22560,22561,22601,22602,22603,22643,22644,22645,22685,22686,22687,22727,22728,22729,22769,22770,22771,22811,22812,22813,22853,22854,22855,22895,22896,22897,22937,22938,22939,22968,22969,22970,22998,22999,23000,23028,23029,23030,23040,23053,23066,23079,23092,23105,23115,23122,23129,23136,23143,23150,23160,23174,23189,23202,23215,23228,23238,23245,23255,23269,23282,23295,23308,23321,23331,23338,23345,23352,23359,23366,23376,23389,23402,23415,23424,23441,23451,23458,23465,23472,23479,23486,23496,23509,23522,23535,23548,23561,23571,23578,23585,23592,23599,23606,23616,23629,23642,23654,23667,23680,23690,23697,23704,23711,23718,23725,23726,23736,23749,23762,23775,23788,23801,23811,23818,23825,23832,23839,23846,23856,23869,23882,23895,23908,23921,23931,23938,23939,23946,23953,23960,23967,24842,24855,24868,24882,24894,24906,25163,25177,25188,25201,25212,25227,25240,25251,25272,25283,25296,25309,25322,25334,25345,25356,25367,25378,25391,25404,25417,25430,25441,25451,25462,25473,25486,25499,25512,25525,25536,25547,25558,25569,25582,25595,25608,25621,25633,25644,25655,25666,25679,25692,25718,25729,25740,25751,25761,25774,25787,25800,25813,25824,25835,25846,25857,25870,25883,25896,25909,25920,25931,25942,26431,26445,26459,26473,26487,26499,26511,26523,26531,26537,26543,26549,26863,26877,26891,26905,26919,26931,26943,26955,26964,26970,26976,26981,26991,27005,27020,27034,27048,27060,27072,27084,27092,27098,27104,27110,27273,27287,27301,27315,27327,27339,27351,27679,27694,27708,27722,27736,27748,27760,27772,28830,29473,29474,29475,29476,29477,29478,29479,29480,30348,30349,30350,30351,30352,30353,30443,30456,30698,30828,30830,31189,31351,31387,31453,31454,31455,31456,31457,31458,31473,31481,31565) 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(16295,16298,16301,21547,21548,21559,21560,21563,21564,21598,21599,21600,22181,22182,22183,22223,22224,22225,22265,22266,22267,22307,22308,22309,22349,22350,22351,22391,22392,22393,22433,22434,22435,22475,22476,22477,22517,22518,22519,22559,22560,22561,22601,22602,22603,22643,22644,22645,22685,22686,22687,22727,22728,22729,22769,22770,22771,22811,22812,22813,22853,22854,22855,22895,22896,22897,22937,22938,22939,22968,22969,22970,22998,22999,23000,23028,23029,23030,23040,23053,23066,23079,23092,23105,23115,23122,23129,23136,23143,23150,23160,23174,23189,23202,23215,23228,23238,23245,23255,23269,23282,23295,23308,23321,23331,23338,23345,23352,23359,23366,23376,23389,23402,23415,23424,23441,23451,23458,23465,23472,23479,23486,23496,23509,23522,23535,23548,23561,23571,23578,23585,23592,23599,23606,23616,23629,23642,23654,23667,23680,23690,23697,23704,23711,23718,23725,23726,23736,23749,23762,23775,23788,23801,23811,23818,23825,23832,23839,23846,23856,23869,23882,23895,23908,23921,23931,23938,23939,23946,23953,23960,23967,24842,24855,24868,24882,24894,24906,25163,25177,25188,25201,25212,25227,25240,25251,25272,25283,25296,25309,25322,25334,25345,25356,25367,25378,25391,25404,25417,25430,25441,25451,25462,25473,25486,25499,25512,25525,25536,25547,25558,25569,25582,25595,25608,25621,25633,25644,25655,25666,25679,25692,25718,25729,25740,25751,25761,25774,25787,25800,25813,25824,25835,25846,25857,25870,25883,25896,25909,25920,25931,25942,26431,26445,26459,26473,26487,26499,26511,26523,26531,26537,26543,26549,26863,26877,26891,26905,26919,26931,26943,26955,26964,26970,26976,26981,26991,27005,27020,27034,27048,27060,27072,27084,27092,27098,27104,27110,27273,27287,27301,27315,27327,27339,27351,27679,27694,27708,27722,27736,27748,27760,27772,28830,29473,29474,29475,29476,29477,29478,29479,29480,30348,30349,30350,30351,30352,30353,30443,30456,30698,30828,30830,31189,31351,31387,31453,31454,31455,31456,31457,31458,31473,31481,31565) 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 22
?q=5500&page=###page###
331
SELECT `id`, `name`, `type` FROM nox_group