/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(15,70,1330,1437,1687,1692,1789,1923,2811,2812,2813,2814,2815,4118,4163,4255,4256,4257,4258,4259,4260,4979,5168,5169,5192,5249,8157,8158,8159,8160,8161,8162,8438,8439,8485,8486,8523,8524,8525,8574,8575,8576,8577,8578,8579,8580,8581,8582,8583,8584,8585,8586,8610,8628,8629,8630,8631,8632,8633,8634,8635,8636,8675,8676,8677,8678,8679,8680,8681,8682,8683,8684,8739,8740,8741,8742,8743,8744,8745,8746,8839,8840,8841,8842,8843,8844,8845,8846,8878,9248,9249,9250,9251,9252,9253,9254,9257,9258,9938,9939,9940,9941,9942,9943,9944,9945,9946,9947,9948,9949,12576,12578,12581,16361,16362,16363,16364,16365,16366,16367,16368,16369,16370,16371,16372,16373,16374,16375,16376,16377,16378,16618,16619,16620,16621,16622,16623,16624,16625,16626,16627,16628,16629,16630,16631,16632,16633,16634,16635,17607,17608,17609,17619,17620,17621,28232,28278,28541,28612,28614,28623,28624,28625,28626,28638,28641,28642,28650,28651,28652,28653,28654,28655,28656,28832,29355,29529,29552,29760,30246,30247,30248,30251,30252,30255,30763,30774,30856,31259,31260,31525,31688,31689,31690,31902))

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(15,70,1330,1437,1687,1692,1789,1923,2811,2812,2813,2814,2815,4118,4163,4255,4256,4257,4258,4259,4260,4979,5168,5169,5192,5249,8157,8158,8159,8160,8161,8162,8438,8439,8485,8486,8523,8524,8525,8574,8575,8576,8577,8578,8579,8580,8581,8582,8583,8584,8585,8586,8610,8628,8629,8630,8631,8632,8633,8634,8635,8636,8675,8676,8677,8678,8679,8680,8681,8682,8683,8684,8739,8740,8741,8742,8743,8744,8745,8746,8839,8840,8841,8842,8843,8844,8845,8846,8878,9248,9249,9250,9251,9252,9253,9254,9257,9258,9938,9939,9940,9941,9942,9943,9944,9945,9946,9947,9948,9949,12576,12578,12581,16361,16362,16363,16364,16365,16366,16367,16368,16369,16370,16371,16372,16373,16374,16375,16376,16377,16378,16618,16619,16620,16621,16622,16623,16624,16625,16626,16627,16628,16629,16630,16631,16632,16633,16634,16635,17607,17608,17609,17619,17620,17621,28232,28278,28541,28612,28614,28623,28624,28625,28626,28638,28641,28642,28650,28651,28652,28653,28654,28655,28656,28832,29355,29529,29552,29760,30246,30247,30248,30251,30252,30255,30763,30774,30856,31259,31260,31525,31688,31689,31690,31902)) 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(15,70,1330,1437,1687,1692,1789,1923,2811,2812,2813,2814,2815,4118,4163,4255,4256,4257,4258,4259,4260,4979,5168,5169,5192,5249,8157,8158,8159,8160,8161,8162,8438,8439,8485,8486,8523,8524,8525,8574,8575,8576,8577,8578,8579,8580,8581,8582,8583,8584,8585,8586,8610,8628,8629,8630,8631,8632,8633,8634,8635,8636,8675,8676,8677,8678,8679,8680,8681,8682,8683,8684,8739,8740,8741,8742,8743,8744,8745,8746,8839,8840,8841,8842,8843,8844,8845,8846,8878,9248,9249,9250,9251,9252,9253,9254,9257,9258,9938,9939,9940,9941,9942,9943,9944,9945,9946,9947,9948,9949,12576,12578,12581,16361,16362,16363,16364,16365,16366,16367,16368,16369,16370,16371,16372,16373,16374,16375,16376,16377,16378,16618,16619,16620,16621,16622,16623,16624,16625,16626,16627,16628,16629,16630,16631,16632,16633,16634,16635,17607,17608,17609,17619,17620,17621,28232,28278,28541,28612,28614,28623,28624,28625,28626,28638,28641,28642,28650,28651,28652,28653,28654,28655,28656,28832,29355,29529,29552,29760,30246,30247,30248,30251,30252,30255,30763,30774,30856,31259,31260,31525,31688,31689,31690,31902) 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=12&page=###page###

513

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