/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 `id`, `url`, `name_title`, `name_full`, `id_new`, `market`, `tier`, `update_date`, `segment` 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)) LIMIT 0, 30
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(35835, 35860, 36301, 35993) GROUP BY `prints_set`.`id` ORDER BY IF(MAX(`prints_vector`.`preview`) IS NOT NULL AND MAX(`prints_vector`.`preview`) != '', 0, 1), `prints_set`.`name_full`
SELECT COUNT(*) cnt FROM `prints_set_vector` INNER JOIN `prints_vector` ON `prints_vector`.`id` = `prints_set_vector`.`vector_id` WHERE `prints_set_vector`.`set_id` = 36301 AND `prints_set_vector`.`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 `prints_vector`.`bundle` = 0
SELECT COUNT(*) cnt FROM `prints_set_vector` INNER JOIN `prints_vector` ON `prints_vector`.`id` = `prints_set_vector`.`vector_id` WHERE `prints_set_vector`.`set_id` = 35835 AND `prints_set_vector`.`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 `prints_vector`.`bundle` = 0
SELECT COUNT(*) cnt FROM `prints_set_vector` INNER JOIN `prints_vector` ON `prints_vector`.`id` = `prints_set_vector`.`vector_id` WHERE `prints_set_vector`.`set_id` = 35860 AND `prints_set_vector`.`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 `prints_vector`.`bundle` = 0
SELECT COUNT(*) cnt FROM `prints_set_vector` INNER JOIN `prints_vector` ON `prints_vector`.`id` = `prints_set_vector`.`vector_id` WHERE `prints_set_vector`.`set_id` = 35993 AND `prints_set_vector`.`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 `prints_vector`.`bundle` = 0
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 26
?q=F-350&page=###page###
155
SELECT `id`, `name`, `type` FROM nox_group
