/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(1747,1748,3153,3174,3191,3192,3194,3203,3205,3206,3210,3687,3951,3952,3953,3954,3955,3956,3957,3958,3959,3960,3961,3962,3963,3964,3965,3966,3967,3968,3969,3970,3971,3972,3973,3974,3975,3976,3977,4784,6001,6002,6269,6503,9492,9493,9494,9495,9496,9497,9498,9499,9627,9628,9629,9630,11185,11186,11187,11188,11189,11190,11389,11390,11391,11943,11944,11945,11946,11947,13994,13995,13996,13997,13998,14037,14038,14039,14040,14041,15784,15785,21702,21703,21704,21705,21706,21707,21708,21709,21726,21727,21728,21729,21730,21731,21732,21733,21849,21857,21858,21859,21860,21861,21862,21863,21872,21873,21874,21875,21876,21877,21878,21879,21888,21889,21890,21891,21892,21893,21894,21895,21904,21905,21906,21907,21908,21909,21910,21911,21920,21921,21922,21923,21924,21925,21926,21927,21938,21939,21940,21941,21942,21943,21944,21945,21946,21947,21958,21959,21960,21961,21962,21963,21964,21965,21966,21967,21978,21979,21980,21981,21982,21983,21984,21985,21986,21987,21998,21999,22000,22001,22002,22003,22004,22005,22006,22017,22018,22019,22020,22021,22022,22023,22024,22025,28563,28564,28568,28570,28572,28573,28574,28576,28779,28901,29056,29984,29989,29990,29991,30794,30873,31375,31860,31861))

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(1747,1748,3153,3174,3191,3192,3194,3203,3205,3206,3210,3687,3951,3952,3953,3954,3955,3956,3957,3958,3959,3960,3961,3962,3963,3964,3965,3966,3967,3968,3969,3970,3971,3972,3973,3974,3975,3976,3977,4784,6001,6002,6269,6503,9492,9493,9494,9495,9496,9497,9498,9499,9627,9628,9629,9630,11185,11186,11187,11188,11189,11190,11389,11390,11391,11943,11944,11945,11946,11947,13994,13995,13996,13997,13998,14037,14038,14039,14040,14041,15784,15785,21702,21703,21704,21705,21706,21707,21708,21709,21726,21727,21728,21729,21730,21731,21732,21733,21849,21857,21858,21859,21860,21861,21862,21863,21872,21873,21874,21875,21876,21877,21878,21879,21888,21889,21890,21891,21892,21893,21894,21895,21904,21905,21906,21907,21908,21909,21910,21911,21920,21921,21922,21923,21924,21925,21926,21927,21938,21939,21940,21941,21942,21943,21944,21945,21946,21947,21958,21959,21960,21961,21962,21963,21964,21965,21966,21967,21978,21979,21980,21981,21982,21983,21984,21985,21986,21987,21998,21999,22000,22001,22002,22003,22004,22005,22006,22017,22018,22019,22020,22021,22022,22023,22024,22025,28563,28564,28568,28570,28572,28573,28574,28576,28779,28901,29056,29984,29989,29990,29991,30794,30873,31375,31860,31861)) 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(1747,1748,3153,3174,3191,3192,3194,3203,3205,3206,3210,3687,3951,3952,3953,3954,3955,3956,3957,3958,3959,3960,3961,3962,3963,3964,3965,3966,3967,3968,3969,3970,3971,3972,3973,3974,3975,3976,3977,4784,6001,6002,6269,6503,9492,9493,9494,9495,9496,9497,9498,9499,9627,9628,9629,9630,11185,11186,11187,11188,11189,11190,11389,11390,11391,11943,11944,11945,11946,11947,13994,13995,13996,13997,13998,14037,14038,14039,14040,14041,15784,15785,21702,21703,21704,21705,21706,21707,21708,21709,21726,21727,21728,21729,21730,21731,21732,21733,21849,21857,21858,21859,21860,21861,21862,21863,21872,21873,21874,21875,21876,21877,21878,21879,21888,21889,21890,21891,21892,21893,21894,21895,21904,21905,21906,21907,21908,21909,21910,21911,21920,21921,21922,21923,21924,21925,21926,21927,21938,21939,21940,21941,21942,21943,21944,21945,21946,21947,21958,21959,21960,21961,21962,21963,21964,21965,21966,21967,21978,21979,21980,21981,21982,21983,21984,21985,21986,21987,21998,21999,22000,22001,22002,22003,22004,22005,22006,22017,22018,22019,22020,22021,22022,22023,22024,22025,28563,28564,28568,28570,28572,28573,28574,28576,28779,28901,29056,29984,29989,29990,29991,30794,30873,31375,31860,31861) 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(1747,1748,3153,3174,3191,3192,3194,3203,3205,3206,3210,3687,3951,3952,3953,3954,3955,3956,3957,3958,3959,3960,3961,3962,3963,3964,3965,3966,3967,3968,3969,3970,3971,3972,3973,3974,3975,3976,3977,4784,6001,6002,6269,6503,9492,9493,9494,9495,9496,9497,9498,9499,9627,9628,9629,9630,11185,11186,11187,11188,11189,11190,11389,11390,11391,11943,11944,11945,11946,11947,13994,13995,13996,13997,13998,14037,14038,14039,14040,14041,15784,15785,21702,21703,21704,21705,21706,21707,21708,21709,21726,21727,21728,21729,21730,21731,21732,21733,21849,21857,21858,21859,21860,21861,21862,21863,21872,21873,21874,21875,21876,21877,21878,21879,21888,21889,21890,21891,21892,21893,21894,21895,21904,21905,21906,21907,21908,21909,21910,21911,21920,21921,21922,21923,21924,21925,21926,21927,21938,21939,21940,21941,21942,21943,21944,21945,21946,21947,21958,21959,21960,21961,21962,21963,21964,21965,21966,21967,21978,21979,21980,21981,21982,21983,21984,21985,21986,21987,21998,21999,22000,22001,22002,22003,22004,22005,22006,22017,22018,22019,22020,22021,22022,22023,22024,22025,28563,28564,28568,28570,28572,28573,28574,28576,28779,28901,29056,29984,29989,29990,29991,30794,30873,31375,31860,31861) 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 2

?q=400&page=###page###

301

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