/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(137,139,141,144,645,830,833,841,842,847,848,1137,1139,1141,1143,1204,1205,1207,1286,1443,1445,1446,1447,1448,1449,1450,1451,1453,1454,1455,1456,1457,1458,1461,1462,1463,1464,1535,1544,1547,1572,1757,1760,1765,1766,2022,2025,2805,2812,2814,2888,2893,2896,2897,2898,2901,2902,2903,2904,2909,2912,2914,2917,3528,3529,3530,3534,3733,3745,3752,3756,3757,3762,3763,3764,3765,3770,3771,3773,3776,3777,3782,3783,3786,3787,3792,3793,3796,3797,3808,3809,3822,3823,3836,3837,7301,7303,11954,12878,12883,28407,28586,28590,28612,28616,28618,28619,28628,28629,28633,28635,28637,28650,28652,28654,28657,28659,28662,28663,28664,28667,28670,28673,28685,28687,28722,28725,28726,28727,28924,28925,28926,28927,28928,28949,28950,28952,28953,28957,28974,28976,29051,29059,29060,29077,29114,29116,29117,29119,29121,29122,29124,29127,29129,29135,29137,29151,29153,29193,29208,29307,29516,29517,29518,29529,29598,29606,29607,29918,29919,29930,29931,29932,29933,29934,29937,29938,29939,30060,30240,30265,30280,30521,30567,30569,30570,30571,30572,30595,30596,30597,30598,30599,30600,30601,30610,30720,30745,30749,30752,30755,30756,30757,30833,30913,30915,31069,31070,31071,31072,31097,31098,31099,31102,31104,31106,31108,31213,31221,31222,31223,31224,31225,31226,31227,31312,31313,31314,31315,31316,31317,31318,31319,31320,31321,31322,31323,31324,31325,31326,31327,31328,31329,31330,31331,31335,31336,31337,31338,31339,31340,31341,31342,31343,31344,31345,31346,31347,31348,31417,31418,31419,31575,31580,31582,31583,31584,31585,31588,31905,31981))

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(137,139,141,144,645,830,833,841,842,847,848,1137,1139,1141,1143,1204,1205,1207,1286,1443,1445,1446,1447,1448,1449,1450,1451,1453,1454,1455,1456,1457,1458,1461,1462,1463,1464,1535,1544,1547,1572,1757,1760,1765,1766,2022,2025,2805,2812,2814,2888,2893,2896,2897,2898,2901,2902,2903,2904,2909,2912,2914,2917,3528,3529,3530,3534,3733,3745,3752,3756,3757,3762,3763,3764,3765,3770,3771,3773,3776,3777,3782,3783,3786,3787,3792,3793,3796,3797,3808,3809,3822,3823,3836,3837,7301,7303,11954,12878,12883,28407,28586,28590,28612,28616,28618,28619,28628,28629,28633,28635,28637,28650,28652,28654,28657,28659,28662,28663,28664,28667,28670,28673,28685,28687,28722,28725,28726,28727,28924,28925,28926,28927,28928,28949,28950,28952,28953,28957,28974,28976,29051,29059,29060,29077,29114,29116,29117,29119,29121,29122,29124,29127,29129,29135,29137,29151,29153,29193,29208,29307,29516,29517,29518,29529,29598,29606,29607,29918,29919,29930,29931,29932,29933,29934,29937,29938,29939,30060,30240,30265,30280,30521,30567,30569,30570,30571,30572,30595,30596,30597,30598,30599,30600,30601,30610,30720,30745,30749,30752,30755,30756,30757,30833,30913,30915,31069,31070,31071,31072,31097,31098,31099,31102,31104,31106,31108,31213,31221,31222,31223,31224,31225,31226,31227,31312,31313,31314,31315,31316,31317,31318,31319,31320,31321,31322,31323,31324,31325,31326,31327,31328,31329,31330,31331,31335,31336,31337,31338,31339,31340,31341,31342,31343,31344,31345,31346,31347,31348,31417,31418,31419,31575,31580,31582,31583,31584,31585,31588,31905,31981)) 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(137,139,141,144,645,830,833,841,842,847,848,1137,1139,1141,1143,1204,1205,1207,1286,1443,1445,1446,1447,1448,1449,1450,1451,1453,1454,1455,1456,1457,1458,1461,1462,1463,1464,1535,1544,1547,1572,1757,1760,1765,1766,2022,2025,2805,2812,2814,2888,2893,2896,2897,2898,2901,2902,2903,2904,2909,2912,2914,2917,3528,3529,3530,3534,3733,3745,3752,3756,3757,3762,3763,3764,3765,3770,3771,3773,3776,3777,3782,3783,3786,3787,3792,3793,3796,3797,3808,3809,3822,3823,3836,3837,7301,7303,11954,12878,12883,28407,28586,28590,28612,28616,28618,28619,28628,28629,28633,28635,28637,28650,28652,28654,28657,28659,28662,28663,28664,28667,28670,28673,28685,28687,28722,28725,28726,28727,28924,28925,28926,28927,28928,28949,28950,28952,28953,28957,28974,28976,29051,29059,29060,29077,29114,29116,29117,29119,29121,29122,29124,29127,29129,29135,29137,29151,29153,29193,29208,29307,29516,29517,29518,29529,29598,29606,29607,29918,29919,29930,29931,29932,29933,29934,29937,29938,29939,30060,30240,30265,30280,30521,30567,30569,30570,30571,30572,30595,30596,30597,30598,30599,30600,30601,30610,30720,30745,30749,30752,30755,30756,30757,30833,30913,30915,31069,31070,31071,31072,31097,31098,31099,31102,31104,31106,31108,31213,31221,31222,31223,31224,31225,31226,31227,31312,31313,31314,31315,31316,31317,31318,31319,31320,31321,31322,31323,31324,31325,31326,31327,31328,31329,31330,31331,31335,31336,31337,31338,31339,31340,31341,31342,31343,31344,31345,31346,31347,31348,31417,31418,31419,31575,31580,31582,31583,31584,31585,31588,31905,31981) 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=Standard&page=###page###

328

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