/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(6993,6994,6995,6996,6997,6998,6999,7000,7001,7003,7004,7005,7006,7007,7008,7009,7010,7011,11857,11858,11859,11860,11861,11862,11863,11864,14676,14677,14678,14679,20021,20022,20023,20026,20027,20030,20031,20034,20035,20039,20040,20041,20045,20046,20047,20051,20052,20053,20057,20058,20059,20063,20064,20065,20069,20070,20071,20075,20076,20077,20081,20082,20083,20087,20088,20089,20093,20094,20095,20099,20100,20101,20105,20106,20107,20111,20112,20113,20117,20118,20119,20123,20124,20125,20129,20130,20131,20135,20136,20137,20141,20142,20143,20147,20148,20149,20153,20154,20155,20159,20160,20161,20165,20166,20167,20171,20172,20173,20177,20178,20179,20183,20184,20185,20189,20190,20191,20195,20196,20197,20201,20202,20203,20207,20208,20209,20213,20214,20215,20219,20220,20221,20225,20226,20227,20231,20232,20233,20237,20238,20239,20243,20244,20245,20249,20250,20251,20255,20256,20257,20261,20262,20263,20267,20268,20269,20273,20274,20275,20279,20280,20281,20285,20286,20287,20291,20292,20293,20297,20298,20299,20303,20304,20305,20309,20310,20311,20315,20316,20317,20321,20322,20323,20327,20328,20329,20333,20334,20335,20339,20340,20341,20345,20346,20347,20351,20352,20353,20357,20358,20359,20363,20364,20365,20369,20370,20371,20374,20376,20377,20381,20382,20383,20387,20388,20389,20393,20394,20395,20396,20398,20400,20401,20405,20406,20407,20411,20412,20413,20417,20418,20419,20423,20424,20425,20429,20430,20431,20435,20436,20437,20441,20442,20443,20447,20448,20449,20453,20454,20455,20459,20460,20461,20465,20466,20467,20471,20472,20473,20477,20478,20479,20483,20484,20485,20489,20490,20491,20495,20496,20497,20501,20502,20503,20507,20508,20509,20510,20514,20515,20516,20520,20521,20522,20526,20527,20528,20532,20533,20534,20538,20539,20540,20544,20545,20546,20550,20551,20552,20556,20557,20558,27878,28324))
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(6993,6994,6995,6996,6997,6998,6999,7000,7001,7003,7004,7005,7006,7007,7008,7009,7010,7011,11857,11858,11859,11860,11861,11862,11863,11864,14676,14677,14678,14679,20021,20022,20023,20026,20027,20030,20031,20034,20035,20039,20040,20041,20045,20046,20047,20051,20052,20053,20057,20058,20059,20063,20064,20065,20069,20070,20071,20075,20076,20077,20081,20082,20083,20087,20088,20089,20093,20094,20095,20099,20100,20101,20105,20106,20107,20111,20112,20113,20117,20118,20119,20123,20124,20125,20129,20130,20131,20135,20136,20137,20141,20142,20143,20147,20148,20149,20153,20154,20155,20159,20160,20161,20165,20166,20167,20171,20172,20173,20177,20178,20179,20183,20184,20185,20189,20190,20191,20195,20196,20197,20201,20202,20203,20207,20208,20209,20213,20214,20215,20219,20220,20221,20225,20226,20227,20231,20232,20233,20237,20238,20239,20243,20244,20245,20249,20250,20251,20255,20256,20257,20261,20262,20263,20267,20268,20269,20273,20274,20275,20279,20280,20281,20285,20286,20287,20291,20292,20293,20297,20298,20299,20303,20304,20305,20309,20310,20311,20315,20316,20317,20321,20322,20323,20327,20328,20329,20333,20334,20335,20339,20340,20341,20345,20346,20347,20351,20352,20353,20357,20358,20359,20363,20364,20365,20369,20370,20371,20374,20376,20377,20381,20382,20383,20387,20388,20389,20393,20394,20395,20396,20398,20400,20401,20405,20406,20407,20411,20412,20413,20417,20418,20419,20423,20424,20425,20429,20430,20431,20435,20436,20437,20441,20442,20443,20447,20448,20449,20453,20454,20455,20459,20460,20461,20465,20466,20467,20471,20472,20473,20477,20478,20479,20483,20484,20485,20489,20490,20491,20495,20496,20497,20501,20502,20503,20507,20508,20509,20510,20514,20515,20516,20520,20521,20522,20526,20527,20528,20532,20533,20534,20538,20539,20540,20544,20545,20546,20550,20551,20552,20556,20557,20558,27878,28324)) 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(15320, 36173, 11940, 34654, 29303) 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(6993,6994,6995,6996,6997,6998,6999,7000,7001,7003,7004,7005,7006,7007,7008,7009,7010,7011,11857,11858,11859,11860,11861,11862,11863,11864,14676,14677,14678,14679,20021,20022,20023,20026,20027,20030,20031,20034,20035,20039,20040,20041,20045,20046,20047,20051,20052,20053,20057,20058,20059,20063,20064,20065,20069,20070,20071,20075,20076,20077,20081,20082,20083,20087,20088,20089,20093,20094,20095,20099,20100,20101,20105,20106,20107,20111,20112,20113,20117,20118,20119,20123,20124,20125,20129,20130,20131,20135,20136,20137,20141,20142,20143,20147,20148,20149,20153,20154,20155,20159,20160,20161,20165,20166,20167,20171,20172,20173,20177,20178,20179,20183,20184,20185,20189,20190,20191,20195,20196,20197,20201,20202,20203,20207,20208,20209,20213,20214,20215,20219,20220,20221,20225,20226,20227,20231,20232,20233,20237,20238,20239,20243,20244,20245,20249,20250,20251,20255,20256,20257,20261,20262,20263,20267,20268,20269,20273,20274,20275,20279,20280,20281,20285,20286,20287,20291,20292,20293,20297,20298,20299,20303,20304,20305,20309,20310,20311,20315,20316,20317,20321,20322,20323,20327,20328,20329,20333,20334,20335,20339,20340,20341,20345,20346,20347,20351,20352,20353,20357,20358,20359,20363,20364,20365,20369,20370,20371,20374,20376,20377,20381,20382,20383,20387,20388,20389,20393,20394,20395,20396,20398,20400,20401,20405,20406,20407,20411,20412,20413,20417,20418,20419,20423,20424,20425,20429,20430,20431,20435,20436,20437,20441,20442,20443,20447,20448,20449,20453,20454,20455,20459,20460,20461,20465,20466,20467,20471,20472,20473,20477,20478,20479,20483,20484,20485,20489,20490,20491,20495,20496,20497,20501,20502,20503,20507,20508,20509,20510,20514,20515,20516,20520,20521,20522,20526,20527,20528,20532,20533,20534,20538,20539,20540,20544,20545,20546,20550,20551,20552,20556,20557,20558,27878,28324) 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` = 29303 AND `prints_set_vector`.`vector_id` IN(6993,6994,6995,6996,6997,6998,6999,7000,7001,7003,7004,7005,7006,7007,7008,7009,7010,7011,11857,11858,11859,11860,11861,11862,11863,11864,14676,14677,14678,14679,20021,20022,20023,20026,20027,20030,20031,20034,20035,20039,20040,20041,20045,20046,20047,20051,20052,20053,20057,20058,20059,20063,20064,20065,20069,20070,20071,20075,20076,20077,20081,20082,20083,20087,20088,20089,20093,20094,20095,20099,20100,20101,20105,20106,20107,20111,20112,20113,20117,20118,20119,20123,20124,20125,20129,20130,20131,20135,20136,20137,20141,20142,20143,20147,20148,20149,20153,20154,20155,20159,20160,20161,20165,20166,20167,20171,20172,20173,20177,20178,20179,20183,20184,20185,20189,20190,20191,20195,20196,20197,20201,20202,20203,20207,20208,20209,20213,20214,20215,20219,20220,20221,20225,20226,20227,20231,20232,20233,20237,20238,20239,20243,20244,20245,20249,20250,20251,20255,20256,20257,20261,20262,20263,20267,20268,20269,20273,20274,20275,20279,20280,20281,20285,20286,20287,20291,20292,20293,20297,20298,20299,20303,20304,20305,20309,20310,20311,20315,20316,20317,20321,20322,20323,20327,20328,20329,20333,20334,20335,20339,20340,20341,20345,20346,20347,20351,20352,20353,20357,20358,20359,20363,20364,20365,20369,20370,20371,20374,20376,20377,20381,20382,20383,20387,20388,20389,20393,20394,20395,20396,20398,20400,20401,20405,20406,20407,20411,20412,20413,20417,20418,20419,20423,20424,20425,20429,20430,20431,20435,20436,20437,20441,20442,20443,20447,20448,20449,20453,20454,20455,20459,20460,20461,20465,20466,20467,20471,20472,20473,20477,20478,20479,20483,20484,20485,20489,20490,20491,20495,20496,20497,20501,20502,20503,20507,20508,20509,20510,20514,20515,20516,20520,20521,20522,20526,20527,20528,20532,20533,20534,20538,20539,20540,20544,20545,20546,20550,20551,20552,20556,20557,20558,27878,28324) 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` = 11940 AND `prints_set_vector`.`vector_id` IN(6993,6994,6995,6996,6997,6998,6999,7000,7001,7003,7004,7005,7006,7007,7008,7009,7010,7011,11857,11858,11859,11860,11861,11862,11863,11864,14676,14677,14678,14679,20021,20022,20023,20026,20027,20030,20031,20034,20035,20039,20040,20041,20045,20046,20047,20051,20052,20053,20057,20058,20059,20063,20064,20065,20069,20070,20071,20075,20076,20077,20081,20082,20083,20087,20088,20089,20093,20094,20095,20099,20100,20101,20105,20106,20107,20111,20112,20113,20117,20118,20119,20123,20124,20125,20129,20130,20131,20135,20136,20137,20141,20142,20143,20147,20148,20149,20153,20154,20155,20159,20160,20161,20165,20166,20167,20171,20172,20173,20177,20178,20179,20183,20184,20185,20189,20190,20191,20195,20196,20197,20201,20202,20203,20207,20208,20209,20213,20214,20215,20219,20220,20221,20225,20226,20227,20231,20232,20233,20237,20238,20239,20243,20244,20245,20249,20250,20251,20255,20256,20257,20261,20262,20263,20267,20268,20269,20273,20274,20275,20279,20280,20281,20285,20286,20287,20291,20292,20293,20297,20298,20299,20303,20304,20305,20309,20310,20311,20315,20316,20317,20321,20322,20323,20327,20328,20329,20333,20334,20335,20339,20340,20341,20345,20346,20347,20351,20352,20353,20357,20358,20359,20363,20364,20365,20369,20370,20371,20374,20376,20377,20381,20382,20383,20387,20388,20389,20393,20394,20395,20396,20398,20400,20401,20405,20406,20407,20411,20412,20413,20417,20418,20419,20423,20424,20425,20429,20430,20431,20435,20436,20437,20441,20442,20443,20447,20448,20449,20453,20454,20455,20459,20460,20461,20465,20466,20467,20471,20472,20473,20477,20478,20479,20483,20484,20485,20489,20490,20491,20495,20496,20497,20501,20502,20503,20507,20508,20509,20510,20514,20515,20516,20520,20521,20522,20526,20527,20528,20532,20533,20534,20538,20539,20540,20544,20545,20546,20550,20551,20552,20556,20557,20558,27878,28324) 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` = 36173 AND `prints_set_vector`.`vector_id` IN(6993,6994,6995,6996,6997,6998,6999,7000,7001,7003,7004,7005,7006,7007,7008,7009,7010,7011,11857,11858,11859,11860,11861,11862,11863,11864,14676,14677,14678,14679,20021,20022,20023,20026,20027,20030,20031,20034,20035,20039,20040,20041,20045,20046,20047,20051,20052,20053,20057,20058,20059,20063,20064,20065,20069,20070,20071,20075,20076,20077,20081,20082,20083,20087,20088,20089,20093,20094,20095,20099,20100,20101,20105,20106,20107,20111,20112,20113,20117,20118,20119,20123,20124,20125,20129,20130,20131,20135,20136,20137,20141,20142,20143,20147,20148,20149,20153,20154,20155,20159,20160,20161,20165,20166,20167,20171,20172,20173,20177,20178,20179,20183,20184,20185,20189,20190,20191,20195,20196,20197,20201,20202,20203,20207,20208,20209,20213,20214,20215,20219,20220,20221,20225,20226,20227,20231,20232,20233,20237,20238,20239,20243,20244,20245,20249,20250,20251,20255,20256,20257,20261,20262,20263,20267,20268,20269,20273,20274,20275,20279,20280,20281,20285,20286,20287,20291,20292,20293,20297,20298,20299,20303,20304,20305,20309,20310,20311,20315,20316,20317,20321,20322,20323,20327,20328,20329,20333,20334,20335,20339,20340,20341,20345,20346,20347,20351,20352,20353,20357,20358,20359,20363,20364,20365,20369,20370,20371,20374,20376,20377,20381,20382,20383,20387,20388,20389,20393,20394,20395,20396,20398,20400,20401,20405,20406,20407,20411,20412,20413,20417,20418,20419,20423,20424,20425,20429,20430,20431,20435,20436,20437,20441,20442,20443,20447,20448,20449,20453,20454,20455,20459,20460,20461,20465,20466,20467,20471,20472,20473,20477,20478,20479,20483,20484,20485,20489,20490,20491,20495,20496,20497,20501,20502,20503,20507,20508,20509,20510,20514,20515,20516,20520,20521,20522,20526,20527,20528,20532,20533,20534,20538,20539,20540,20544,20545,20546,20550,20551,20552,20556,20557,20558,27878,28324) 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` = 34654 AND `prints_set_vector`.`vector_id` IN(6993,6994,6995,6996,6997,6998,6999,7000,7001,7003,7004,7005,7006,7007,7008,7009,7010,7011,11857,11858,11859,11860,11861,11862,11863,11864,14676,14677,14678,14679,20021,20022,20023,20026,20027,20030,20031,20034,20035,20039,20040,20041,20045,20046,20047,20051,20052,20053,20057,20058,20059,20063,20064,20065,20069,20070,20071,20075,20076,20077,20081,20082,20083,20087,20088,20089,20093,20094,20095,20099,20100,20101,20105,20106,20107,20111,20112,20113,20117,20118,20119,20123,20124,20125,20129,20130,20131,20135,20136,20137,20141,20142,20143,20147,20148,20149,20153,20154,20155,20159,20160,20161,20165,20166,20167,20171,20172,20173,20177,20178,20179,20183,20184,20185,20189,20190,20191,20195,20196,20197,20201,20202,20203,20207,20208,20209,20213,20214,20215,20219,20220,20221,20225,20226,20227,20231,20232,20233,20237,20238,20239,20243,20244,20245,20249,20250,20251,20255,20256,20257,20261,20262,20263,20267,20268,20269,20273,20274,20275,20279,20280,20281,20285,20286,20287,20291,20292,20293,20297,20298,20299,20303,20304,20305,20309,20310,20311,20315,20316,20317,20321,20322,20323,20327,20328,20329,20333,20334,20335,20339,20340,20341,20345,20346,20347,20351,20352,20353,20357,20358,20359,20363,20364,20365,20369,20370,20371,20374,20376,20377,20381,20382,20383,20387,20388,20389,20393,20394,20395,20396,20398,20400,20401,20405,20406,20407,20411,20412,20413,20417,20418,20419,20423,20424,20425,20429,20430,20431,20435,20436,20437,20441,20442,20443,20447,20448,20449,20453,20454,20455,20459,20460,20461,20465,20466,20467,20471,20472,20473,20477,20478,20479,20483,20484,20485,20489,20490,20491,20495,20496,20497,20501,20502,20503,20507,20508,20509,20510,20514,20515,20516,20520,20521,20522,20526,20527,20528,20532,20533,20534,20538,20539,20540,20544,20545,20546,20550,20551,20552,20556,20557,20558,27878,28324) 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(6993,6994,6995,6996,6997,6998,6999,7000,7001,7003,7004,7005,7006,7007,7008,7009,7010,7011,11857,11858,11859,11860,11861,11862,11863,11864,14676,14677,14678,14679,20021,20022,20023,20026,20027,20030,20031,20034,20035,20039,20040,20041,20045,20046,20047,20051,20052,20053,20057,20058,20059,20063,20064,20065,20069,20070,20071,20075,20076,20077,20081,20082,20083,20087,20088,20089,20093,20094,20095,20099,20100,20101,20105,20106,20107,20111,20112,20113,20117,20118,20119,20123,20124,20125,20129,20130,20131,20135,20136,20137,20141,20142,20143,20147,20148,20149,20153,20154,20155,20159,20160,20161,20165,20166,20167,20171,20172,20173,20177,20178,20179,20183,20184,20185,20189,20190,20191,20195,20196,20197,20201,20202,20203,20207,20208,20209,20213,20214,20215,20219,20220,20221,20225,20226,20227,20231,20232,20233,20237,20238,20239,20243,20244,20245,20249,20250,20251,20255,20256,20257,20261,20262,20263,20267,20268,20269,20273,20274,20275,20279,20280,20281,20285,20286,20287,20291,20292,20293,20297,20298,20299,20303,20304,20305,20309,20310,20311,20315,20316,20317,20321,20322,20323,20327,20328,20329,20333,20334,20335,20339,20340,20341,20345,20346,20347,20351,20352,20353,20357,20358,20359,20363,20364,20365,20369,20370,20371,20374,20376,20377,20381,20382,20383,20387,20388,20389,20393,20394,20395,20396,20398,20400,20401,20405,20406,20407,20411,20412,20413,20417,20418,20419,20423,20424,20425,20429,20430,20431,20435,20436,20437,20441,20442,20443,20447,20448,20449,20453,20454,20455,20459,20460,20461,20465,20466,20467,20471,20472,20473,20477,20478,20479,20483,20484,20485,20489,20490,20491,20495,20496,20497,20501,20502,20503,20507,20508,20509,20510,20514,20515,20516,20520,20521,20522,20526,20527,20528,20532,20533,20534,20538,20539,20540,20544,20545,20546,20550,20551,20552,20556,20557,20558,27878,28324) 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 25
?q=121&page=###page###
333
SELECT `id`, `name`, `type` FROM nox_group