/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(31342,31343,12592,12593,12616,12617,12618,12619,12645,12646,12647,12648,12649,12650,12692,12693,12694,12695,12696,12697,12698,12699,12700,12746,12747,12748,12749,12750,12751,12752,12753,12754,12755,12756,12757,12788,12789,12790,12791,12792,12793,12794,12795,12796,12797,12819,12820,12821,12822,12823,12824,12825,12856,12857,12858,12859,12860,12861,12862,12863,12864,12865,28816,28817,28818,28819,28820,28878,28879,28880,29215,29246,29262,29263,29264,29265,29266,29396,30522,30523,30524,30619,30620,30621,30622,30623,30624,30625,30626,30629,30630,30631,30632,30633,30634,30635,30656,30657,30658,30659,30660,30661,30662,30663,30665,30666,30667,30668,30669,30670,30671,31064,31148,31175,31178,31333,31344,31345,31358,31654,31655,31982))

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(31342,31343,12592,12593,12616,12617,12618,12619,12645,12646,12647,12648,12649,12650,12692,12693,12694,12695,12696,12697,12698,12699,12700,12746,12747,12748,12749,12750,12751,12752,12753,12754,12755,12756,12757,12788,12789,12790,12791,12792,12793,12794,12795,12796,12797,12819,12820,12821,12822,12823,12824,12825,12856,12857,12858,12859,12860,12861,12862,12863,12864,12865,28816,28817,28818,28819,28820,28878,28879,28880,29215,29246,29262,29263,29264,29265,29266,29396,30522,30523,30524,30619,30620,30621,30622,30623,30624,30625,30626,30629,30630,30631,30632,30633,30634,30635,30656,30657,30658,30659,30660,30661,30662,30663,30665,30666,30667,30668,30669,30670,30671,31064,31148,31175,31178,31333,31344,31345,31358,31654,31655,31982)) 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(31342,31343,12592,12593,12616,12617,12618,12619,12645,12646,12647,12648,12649,12650,12692,12693,12694,12695,12696,12697,12698,12699,12700,12746,12747,12748,12749,12750,12751,12752,12753,12754,12755,12756,12757,12788,12789,12790,12791,12792,12793,12794,12795,12796,12797,12819,12820,12821,12822,12823,12824,12825,12856,12857,12858,12859,12860,12861,12862,12863,12864,12865,28816,28817,28818,28819,28820,28878,28879,28880,29215,29246,29262,29263,29264,29265,29266,29396,30522,30523,30524,30619,30620,30621,30622,30623,30624,30625,30626,30629,30630,30631,30632,30633,30634,30635,30656,30657,30658,30659,30660,30661,30662,30663,30665,30666,30667,30668,30669,30670,30671,31064,31148,31175,31178,31333,31344,31345,31358,31654,31655,31982) 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

SELECT `prints_vector`.* FROM `prints_vector` LEFT JOIN `prints_set_vector` ON `prints_vector`.`id` = `prints_set_vector`.`vector_id` WHERE `id` IN(31342,31343,12592,12593,12616,12617,12618,12619,12645,12646,12647,12648,12649,12650,12692,12693,12694,12695,12696,12697,12698,12699,12700,12746,12747,12748,12749,12750,12751,12752,12753,12754,12755,12756,12757,12788,12789,12790,12791,12792,12793,12794,12795,12796,12797,12819,12820,12821,12822,12823,12824,12825,12856,12857,12858,12859,12860,12861,12862,12863,12864,12865,28816,28817,28818,28819,28820,28878,28879,28880,29215,29246,29262,29263,29264,29265,29266,29396,30522,30523,30524,30619,30620,30621,30622,30623,30624,30625,30626,30629,30630,30631,30632,30633,30634,30635,30656,30657,30658,30659,30660,30661,30662,30663,30665,30666,30667,30668,30669,30670,30671,31064,31148,31175,31178,31333,31344,31345,31358,31654,31655,31982) AND `set_id` IS NULL ORDER BY IF(`prints_vector`.`preview` IS NOT NULL AND `prints_vector`.`preview` != '', 0, 1), `prepay`, `prints_vector`.`full_name` LIMIT 28

?q=F-350&page=###page###

155

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