/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(675,706,707,708,721,722,723,730,909,911,912,941,942,943,973,974,975,978,979,980,981,982,983,988,989,994,995,1049,1050,1054,1148,1149,1150,1154,1155,1156,1402,1768,1787,1963,1964,1965,3940,3941,4151,4152,4495,4496,4497,4873,4874,4875,4885,4976,5384,5385,5386,5387,5388,5389,5390,5391,5392,5393,5394,5395,5396,5397,5398,5399,5400,5401,5402,5403,5404,5405,5406,5407,5408,5409,5410,5411,5412,5413,5414,5415,5416,5417,5418,5419,6025,6026,6029,6109,6110,6111,6112,6113,6114,6126,6127,6128,6129,6130,6164,6165,6166,6167,6168,6169,6170,6171,6172,6173,6174,6175,9610,9611,9612,9613,9614,9615,9616,9617,9618,9619,9620,9621,9622,10587,10628,10629,10630,10631,10632,10633,10876,10998,10999,11271,11272,11273,11274,11275,11276,11277,11278,11279,12243,12244,12548,13368,13372,13962,13963,13964,13965,14498,14499,14500,14501,14502,14503,14504,14505,14512,14513,14515,14516,14517,14518,14522,14523,14524,14525,14526,15694,15729,15739,15740,22026,22027,28108,28376,28377,28378,28379,28380,28381,28382,28383,28384,28385,28386,28387,28388,28389,28390,28391,28501,28729,28730,28783,28784,28785,28786,28883,28884,29144,29145,29216,29217,29218,29235,29236,29237,29437,29536,29565,30061,30079,30080,30081,30092,30432,30438,30447,30536,31202,31203,31204,31205,31207,31208,31211,31212,31517,31542,31543,31544,31545,31546,31547,31548,31550,31551,31552,31553,31554,31727))

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(675,706,707,708,721,722,723,730,909,911,912,941,942,943,973,974,975,978,979,980,981,982,983,988,989,994,995,1049,1050,1054,1148,1149,1150,1154,1155,1156,1402,1768,1787,1963,1964,1965,3940,3941,4151,4152,4495,4496,4497,4873,4874,4875,4885,4976,5384,5385,5386,5387,5388,5389,5390,5391,5392,5393,5394,5395,5396,5397,5398,5399,5400,5401,5402,5403,5404,5405,5406,5407,5408,5409,5410,5411,5412,5413,5414,5415,5416,5417,5418,5419,6025,6026,6029,6109,6110,6111,6112,6113,6114,6126,6127,6128,6129,6130,6164,6165,6166,6167,6168,6169,6170,6171,6172,6173,6174,6175,9610,9611,9612,9613,9614,9615,9616,9617,9618,9619,9620,9621,9622,10587,10628,10629,10630,10631,10632,10633,10876,10998,10999,11271,11272,11273,11274,11275,11276,11277,11278,11279,12243,12244,12548,13368,13372,13962,13963,13964,13965,14498,14499,14500,14501,14502,14503,14504,14505,14512,14513,14515,14516,14517,14518,14522,14523,14524,14525,14526,15694,15729,15739,15740,22026,22027,28108,28376,28377,28378,28379,28380,28381,28382,28383,28384,28385,28386,28387,28388,28389,28390,28391,28501,28729,28730,28783,28784,28785,28786,28883,28884,29144,29145,29216,29217,29218,29235,29236,29237,29437,29536,29565,30061,30079,30080,30081,30092,30432,30438,30447,30536,31202,31203,31204,31205,31207,31208,31211,31212,31517,31542,31543,31544,31545,31546,31547,31548,31550,31551,31552,31553,31554,31727)) 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(675,706,707,708,721,722,723,730,909,911,912,941,942,943,973,974,975,978,979,980,981,982,983,988,989,994,995,1049,1050,1054,1148,1149,1150,1154,1155,1156,1402,1768,1787,1963,1964,1965,3940,3941,4151,4152,4495,4496,4497,4873,4874,4875,4885,4976,5384,5385,5386,5387,5388,5389,5390,5391,5392,5393,5394,5395,5396,5397,5398,5399,5400,5401,5402,5403,5404,5405,5406,5407,5408,5409,5410,5411,5412,5413,5414,5415,5416,5417,5418,5419,6025,6026,6029,6109,6110,6111,6112,6113,6114,6126,6127,6128,6129,6130,6164,6165,6166,6167,6168,6169,6170,6171,6172,6173,6174,6175,9610,9611,9612,9613,9614,9615,9616,9617,9618,9619,9620,9621,9622,10587,10628,10629,10630,10631,10632,10633,10876,10998,10999,11271,11272,11273,11274,11275,11276,11277,11278,11279,12243,12244,12548,13368,13372,13962,13963,13964,13965,14498,14499,14500,14501,14502,14503,14504,14505,14512,14513,14515,14516,14517,14518,14522,14523,14524,14525,14526,15694,15729,15739,15740,22026,22027,28108,28376,28377,28378,28379,28380,28381,28382,28383,28384,28385,28386,28387,28388,28389,28390,28391,28501,28729,28730,28783,28784,28785,28786,28883,28884,29144,29145,29216,29217,29218,29235,29236,29237,29437,29536,29565,30061,30079,30080,30081,30092,30432,30438,30447,30536,31202,31203,31204,31205,31207,31208,31211,31212,31517,31542,31543,31544,31545,31546,31547,31548,31550,31551,31552,31553,31554,31727) 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=200&page=###page###

413

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