/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(28826,28859,29713,29716,29719,29722,29724,29726,29736,29738,29744,29746,29763,29766,29769,29775,29778,29792,29794,29795,29797,29876,29878,29881,29884,29887,29890,30036,30038,30041,30044,30047,30050,30108,30111,31338,31341,31916,66,1051,1052,1053,1055,1056,1517,1519,1524,1525,1998,2816,2817,2818,2819,2862,3177,3183,3195,3406,3408,3410,3415,3422,3429,3430,3431,3438,3439,3440,4049,6200,6201,6204,6205,6761,6762,6763,6764,8511,8512,9625,9626,11755,12316,12590,12591,12600,12601,12612,12613,12614,12615,12625,12626,12627,12628,12639,12640,12641,12642,12643,12644,12657,12658,12659,12660,12661,12662,12680,12681,12682,12683,12684,12685,12686,12687,12688,12689,12690,12691,12734,12735,12736,12737,12738,12739,12740,12741,12742,12743,12744,12745,12778,12779,12780,12781,12782,12783,12784,12785,12786,12787,12805,12806,12807,12808,12809,12810,12811,12812,12813,12814,12815,12816,12817,12818,12836,12837,12838,12839,12840,12841,12842,12843,12844,12845,12846,12847,12848,12849,12850,12851,12852,12853,12854,12855,12878,12879,12880,12881,12882,13369,13370,13371,21754,28587,28595,28596,28736,28737,28746,28812,28813,28814,28815,28861,29139,29481,29482,29483,29484,29531,30235,30503,30520,30615,30616,30617,30618,30652,30653,30654,30655,30828,30829,30940,31039,31048,31053,31147,31240,31247,31314,31339,31340,31423,31424,31425,31656,31657,31737,31738,31739,31804,31825,31826,31919))

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(28826,28859,29713,29716,29719,29722,29724,29726,29736,29738,29744,29746,29763,29766,29769,29775,29778,29792,29794,29795,29797,29876,29878,29881,29884,29887,29890,30036,30038,30041,30044,30047,30050,30108,30111,31338,31341,31916,66,1051,1052,1053,1055,1056,1517,1519,1524,1525,1998,2816,2817,2818,2819,2862,3177,3183,3195,3406,3408,3410,3415,3422,3429,3430,3431,3438,3439,3440,4049,6200,6201,6204,6205,6761,6762,6763,6764,8511,8512,9625,9626,11755,12316,12590,12591,12600,12601,12612,12613,12614,12615,12625,12626,12627,12628,12639,12640,12641,12642,12643,12644,12657,12658,12659,12660,12661,12662,12680,12681,12682,12683,12684,12685,12686,12687,12688,12689,12690,12691,12734,12735,12736,12737,12738,12739,12740,12741,12742,12743,12744,12745,12778,12779,12780,12781,12782,12783,12784,12785,12786,12787,12805,12806,12807,12808,12809,12810,12811,12812,12813,12814,12815,12816,12817,12818,12836,12837,12838,12839,12840,12841,12842,12843,12844,12845,12846,12847,12848,12849,12850,12851,12852,12853,12854,12855,12878,12879,12880,12881,12882,13369,13370,13371,21754,28587,28595,28596,28736,28737,28746,28812,28813,28814,28815,28861,29139,29481,29482,29483,29484,29531,30235,30503,30520,30615,30616,30617,30618,30652,30653,30654,30655,30828,30829,30940,31039,31048,31053,31147,31240,31247,31314,31339,31340,31423,31424,31425,31656,31657,31737,31738,31739,31804,31825,31826,31919)) 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(28826,28859,29713,29716,29719,29722,29724,29726,29736,29738,29744,29746,29763,29766,29769,29775,29778,29792,29794,29795,29797,29876,29878,29881,29884,29887,29890,30036,30038,30041,30044,30047,30050,30108,30111,31338,31341,31916,66,1051,1052,1053,1055,1056,1517,1519,1524,1525,1998,2816,2817,2818,2819,2862,3177,3183,3195,3406,3408,3410,3415,3422,3429,3430,3431,3438,3439,3440,4049,6200,6201,6204,6205,6761,6762,6763,6764,8511,8512,9625,9626,11755,12316,12590,12591,12600,12601,12612,12613,12614,12615,12625,12626,12627,12628,12639,12640,12641,12642,12643,12644,12657,12658,12659,12660,12661,12662,12680,12681,12682,12683,12684,12685,12686,12687,12688,12689,12690,12691,12734,12735,12736,12737,12738,12739,12740,12741,12742,12743,12744,12745,12778,12779,12780,12781,12782,12783,12784,12785,12786,12787,12805,12806,12807,12808,12809,12810,12811,12812,12813,12814,12815,12816,12817,12818,12836,12837,12838,12839,12840,12841,12842,12843,12844,12845,12846,12847,12848,12849,12850,12851,12852,12853,12854,12855,12878,12879,12880,12881,12882,13369,13370,13371,21754,28587,28595,28596,28736,28737,28746,28812,28813,28814,28815,28861,29139,29481,29482,29483,29484,29531,30235,30503,30520,30615,30616,30617,30618,30652,30653,30654,30655,30828,30829,30940,31039,31048,31053,31147,31240,31247,31314,31339,31340,31423,31424,31425,31656,31657,31737,31738,31739,31804,31825,31826,31919) 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(28826,28859,29713,29716,29719,29722,29724,29726,29736,29738,29744,29746,29763,29766,29769,29775,29778,29792,29794,29795,29797,29876,29878,29881,29884,29887,29890,30036,30038,30041,30044,30047,30050,30108,30111,31338,31341,31916,66,1051,1052,1053,1055,1056,1517,1519,1524,1525,1998,2816,2817,2818,2819,2862,3177,3183,3195,3406,3408,3410,3415,3422,3429,3430,3431,3438,3439,3440,4049,6200,6201,6204,6205,6761,6762,6763,6764,8511,8512,9625,9626,11755,12316,12590,12591,12600,12601,12612,12613,12614,12615,12625,12626,12627,12628,12639,12640,12641,12642,12643,12644,12657,12658,12659,12660,12661,12662,12680,12681,12682,12683,12684,12685,12686,12687,12688,12689,12690,12691,12734,12735,12736,12737,12738,12739,12740,12741,12742,12743,12744,12745,12778,12779,12780,12781,12782,12783,12784,12785,12786,12787,12805,12806,12807,12808,12809,12810,12811,12812,12813,12814,12815,12816,12817,12818,12836,12837,12838,12839,12840,12841,12842,12843,12844,12845,12846,12847,12848,12849,12850,12851,12852,12853,12854,12855,12878,12879,12880,12881,12882,13369,13370,13371,21754,28587,28595,28596,28736,28737,28746,28812,28813,28814,28815,28861,29139,29481,29482,29483,29484,29531,30235,30503,30520,30615,30616,30617,30618,30652,30653,30654,30655,30828,30829,30940,31039,31048,31053,31147,31240,31247,31314,31339,31340,31423,31424,31425,31656,31657,31737,31738,31739,31804,31825,31826,31919) 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 7

?q=250&page=###page###

499

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