/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(3269,3666,3668,3672,3673,4700,4703,4781,4782,4785,4994,6575,6581,6672,6677,6681,6685,6688,6692,6695,6698,6702,6705,6708,6711,6714,6717,6720,6723,6726,6729,6732,6734,6737,6740,6743,6746,6749,7658,7662,7666,7681,7682,7919,7920,11141,11142,11143,11144,11357,11948,11949,11950,11951,11952,15920,15921,15926,15927,15932,15933,15938,15939,15944,15945,15950,15951,15956,15957,15962,15963,15968,15969,15973,15975,15979,15981,15985,15987,15991,15992,15993,15994,15995,15996,16003,16004,16005,16012,16013,16014,16018,16019,16020,16030,16031,16032,16038,16040,16042,16044,16045,16046,16047,16048,16062,16064,16066,16068,16069,16070,16071,16072,16085,16086,16087,16088,16089,16090,16091,16092,16097,16099,16101,16102,16103,16104,16115,16117,16119,16120,16121,16122,16131,16132,16133,16134,16288,16289,16290,16291,16292,16293,16312,16313,16314,16315,16316,16317,17280,17283,17286,17289,17294,17295,17299,17302,17305,17308,17311,17313,17316,17317,17318,17319,17323,17326,17329,17332,17335,17338,17341,17343,17346,17347,17348,17349,18435,18438,18441,18444,18447,18450,18453,18455,18459,18462,18465,18468,18471,18473,18474,18477,18479,18482,18483,18484,18485,18488,18489,18490,18491,18496,18497,18498,18499,18500,18501,18502,18503,18513,18514,18515,18516,18517,18518,18519,18520,18521,18522,18523,18524,18525,18526,18527,18528,18529,18530,18531,18532,18533,18534,18539,18542,18545,18548,18551,18553,18554,18557,18560,18563,18566,18568,18570,18574,18575,18577,18578,18580,18581,18583,18584,18585,18586,18587,18588,18594,18595,18598,18601,18603,18604,18607,18610,18612,18616,18617,18619,18620,18622,18623,18625,18626,18627,18628,18629,18630,18649,18650,18651,18652,18653,18654,18676,18677,18678,18679,18680,18681,29007,29008,29212,29213,29214))

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(SELECT DISTINCT set_id FROM prints_set_vector WHERE vector_id IN(3269,3666,3668,3672,3673,4700,4703,4781,4782,4785,4994,6575,6581,6672,6677,6681,6685,6688,6692,6695,6698,6702,6705,6708,6711,6714,6717,6720,6723,6726,6729,6732,6734,6737,6740,6743,6746,6749,7658,7662,7666,7681,7682,7919,7920,11141,11142,11143,11144,11357,11948,11949,11950,11951,11952,15920,15921,15926,15927,15932,15933,15938,15939,15944,15945,15950,15951,15956,15957,15962,15963,15968,15969,15973,15975,15979,15981,15985,15987,15991,15992,15993,15994,15995,15996,16003,16004,16005,16012,16013,16014,16018,16019,16020,16030,16031,16032,16038,16040,16042,16044,16045,16046,16047,16048,16062,16064,16066,16068,16069,16070,16071,16072,16085,16086,16087,16088,16089,16090,16091,16092,16097,16099,16101,16102,16103,16104,16115,16117,16119,16120,16121,16122,16131,16132,16133,16134,16288,16289,16290,16291,16292,16293,16312,16313,16314,16315,16316,16317,17280,17283,17286,17289,17294,17295,17299,17302,17305,17308,17311,17313,17316,17317,17318,17319,17323,17326,17329,17332,17335,17338,17341,17343,17346,17347,17348,17349,18435,18438,18441,18444,18447,18450,18453,18455,18459,18462,18465,18468,18471,18473,18474,18477,18479,18482,18483,18484,18485,18488,18489,18490,18491,18496,18497,18498,18499,18500,18501,18502,18503,18513,18514,18515,18516,18517,18518,18519,18520,18521,18522,18523,18524,18525,18526,18527,18528,18529,18530,18531,18532,18533,18534,18539,18542,18545,18548,18551,18553,18554,18557,18560,18563,18566,18568,18570,18574,18575,18577,18578,18580,18581,18583,18584,18585,18586,18587,18588,18594,18595,18598,18601,18603,18604,18607,18610,18612,18616,18617,18619,18620,18622,18623,18625,18626,18627,18628,18629,18630,18649,18650,18651,18652,18653,18654,18676,18677,18678,18679,18680,18681,29007,29008,29212,29213,29214)) AND EXISTS(SELECT 1 FROM `prints_set_vector` psv2 INNER JOIN `prints_vector` pv2 ON pv2.`id` = psv2.`vector_id` WHERE psv2.`set_id` = `prints_set`.`id` AND psv2.`vector_id` IN(3269,3666,3668,3672,3673,4700,4703,4781,4782,4785,4994,6575,6581,6672,6677,6681,6685,6688,6692,6695,6698,6702,6705,6708,6711,6714,6717,6720,6723,6726,6729,6732,6734,6737,6740,6743,6746,6749,7658,7662,7666,7681,7682,7919,7920,11141,11142,11143,11144,11357,11948,11949,11950,11951,11952,15920,15921,15926,15927,15932,15933,15938,15939,15944,15945,15950,15951,15956,15957,15962,15963,15968,15969,15973,15975,15979,15981,15985,15987,15991,15992,15993,15994,15995,15996,16003,16004,16005,16012,16013,16014,16018,16019,16020,16030,16031,16032,16038,16040,16042,16044,16045,16046,16047,16048,16062,16064,16066,16068,16069,16070,16071,16072,16085,16086,16087,16088,16089,16090,16091,16092,16097,16099,16101,16102,16103,16104,16115,16117,16119,16120,16121,16122,16131,16132,16133,16134,16288,16289,16290,16291,16292,16293,16312,16313,16314,16315,16316,16317,17280,17283,17286,17289,17294,17295,17299,17302,17305,17308,17311,17313,17316,17317,17318,17319,17323,17326,17329,17332,17335,17338,17341,17343,17346,17347,17348,17349,18435,18438,18441,18444,18447,18450,18453,18455,18459,18462,18465,18468,18471,18473,18474,18477,18479,18482,18483,18484,18485,18488,18489,18490,18491,18496,18497,18498,18499,18500,18501,18502,18503,18513,18514,18515,18516,18517,18518,18519,18520,18521,18522,18523,18524,18525,18526,18527,18528,18529,18530,18531,18532,18533,18534,18539,18542,18545,18548,18551,18553,18554,18557,18560,18563,18566,18568,18570,18574,18575,18577,18578,18580,18581,18583,18584,18585,18586,18587,18588,18594,18595,18598,18601,18603,18604,18607,18610,18612,18616,18617,18619,18620,18622,18623,18625,18626,18627,18628,18629,18630,18649,18650,18651,18652,18653,18654,18676,18677,18678,18679,18680,18681,29007,29008,29212,29213,29214) AND pv2.`bundle` = 0) GROUP BY `prints_set`.`id` ORDER BY 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, 0, 1), `prints_set`.`name_full` LIMIT 30

?q=Space&page=###page###

327

SELECT `id`, `name`, `type` FROM nox_group