/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(74,101,593,619,620,621,665,666,667,668,812,853,854,855,902,1280,1281,1282,1283,1379,1714,4142,4183,4216,4217,4218,4219,4220,4221,4222,4223,5093,5099,5100,5561,5562,6757,6758,6759,6790,11499,11500,11501,11502,11503,11504,11505,11506,11507,11508,11509,11510,13125,13126,13127,13128,13129,13130,13131,13132,13133,13134,13135,13136,13137,27806,27808,27848,27920,28114,28166,28170,28181,28302,28863,28932,28940,29020,29021,29022,29066,29073,29352,30794,30795,30796,30797,30798,30799,30800,30801,30802,30803,30804,30805,30806,30807,30808,30809,30810,30844,30845,30846,30847,30848,30849,30850,30851,30852,30860,30862,30891,30892,30893,30894,31004,31005,31007,31008,31009,31010,31011,31012,31013,31014,31015,31016,31017,31018,31019,31024,31025,31276,31277,31278,31279,31280,31281,31282,31283,31285,31286,31539,31615,31617,31619,31623,31625,31627,31629,31631,31633,31635,31807,31878))

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(74,101,593,619,620,621,665,666,667,668,812,853,854,855,902,1280,1281,1282,1283,1379,1714,4142,4183,4216,4217,4218,4219,4220,4221,4222,4223,5093,5099,5100,5561,5562,6757,6758,6759,6790,11499,11500,11501,11502,11503,11504,11505,11506,11507,11508,11509,11510,13125,13126,13127,13128,13129,13130,13131,13132,13133,13134,13135,13136,13137,27806,27808,27848,27920,28114,28166,28170,28181,28302,28863,28932,28940,29020,29021,29022,29066,29073,29352,30794,30795,30796,30797,30798,30799,30800,30801,30802,30803,30804,30805,30806,30807,30808,30809,30810,30844,30845,30846,30847,30848,30849,30850,30851,30852,30860,30862,30891,30892,30893,30894,31004,31005,31007,31008,31009,31010,31011,31012,31013,31014,31015,31016,31017,31018,31019,31024,31025,31276,31277,31278,31279,31280,31281,31282,31283,31285,31286,31539,31615,31617,31619,31623,31625,31627,31629,31631,31633,31635,31807,31878)) 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(74,101,593,619,620,621,665,666,667,668,812,853,854,855,902,1280,1281,1282,1283,1379,1714,4142,4183,4216,4217,4218,4219,4220,4221,4222,4223,5093,5099,5100,5561,5562,6757,6758,6759,6790,11499,11500,11501,11502,11503,11504,11505,11506,11507,11508,11509,11510,13125,13126,13127,13128,13129,13130,13131,13132,13133,13134,13135,13136,13137,27806,27808,27848,27920,28114,28166,28170,28181,28302,28863,28932,28940,29020,29021,29022,29066,29073,29352,30794,30795,30796,30797,30798,30799,30800,30801,30802,30803,30804,30805,30806,30807,30808,30809,30810,30844,30845,30846,30847,30848,30849,30850,30851,30852,30860,30862,30891,30892,30893,30894,31004,31005,31007,31008,31009,31010,31011,31012,31013,31014,31015,31016,31017,31018,31019,31024,31025,31276,31277,31278,31279,31280,31281,31282,31283,31285,31286,31539,31615,31617,31619,31623,31625,31627,31629,31631,31633,31635,31807,31878) 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=Type&page=###page###

660

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