/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(30770,30771,30784,30785,30786,30787,30794,30795,30798,30799,30800,30808,31010,31012,31013,31014,31017,31018,31019,31022,31283,31893,30761,30844,30845,30846,30860,30861,30862,30865,30866,31035,30950,30999,31000,31001,31002,31003,31270,31271,31272,31273,31274,31275,30270,30762,30796,30797,30801,30802,30803,30804,30805,30806,30807,30809,30811,30812,30813,30814,30815,30816,30817,30818,30819,30820,30821,30822,30823,30824,30847,30848,30849,30850,30851,30852,30891,30892,30893,30894,31004,31005,31006,31007,31008,31009,31011,31015,31016,31020,31021,31023,31024,31025,31276,31277,31278,31279,31280,31281,31282,31284,31285,31286,31539,31614,31615,31616,31617,31618,31619,31621,31622,31623,31624,31625,31626,31627,31628,31629,31630,31631,31632,31633,31634,31635,31636,31637,31638,31036,668,11209,11210,14057,14058,14071,14072,14073,14074,28915,30688,30810,31101,31103,31105,31107,31181,31182,31183,31184,31185,31186,31198,31199,31200,31201,188,251,302,303,348,355,368,383,403,442,461,573,607,611,693,741,742,767,940,1062,1120,1121,1122,1123,1124,1125,1160,1186,1188,1330,1331,1977,2958,2960,2962,3090,3091,3092,3093,3957,3958,3962,4155,12345,12346,12347,12348,12349,12350,12351,12352,12353,12354,12355,12356,12357,12358,12359,12360,12361,12362,12576,12577,12578,12579,12580,12581,12582,12583,12927,12928,12929,12930,12931,12932,12933,12934,12935,12936,12937,12938,12939,12940,12941,12942,12943,12944,12945,12946,12947,12948,12949,12950,12951,12952,19288,19289,19290,19291,21540,27853,27875,27898,27909,27989,28119,28129,28131,28157,28171,28186,28201,28294,28338,29035,29045,29078,29079,29247,29306,29349,29450,29451,29452,29552,29654,29695,30088,30232,30540,30585,30853,30854,30855,30856,30864,30872,30873,30874,31110,31517,31518,31519,31534,31639,31965))

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(30770,30771,30784,30785,30786,30787,30794,30795,30798,30799,30800,30808,31010,31012,31013,31014,31017,31018,31019,31022,31283,31893,30761,30844,30845,30846,30860,30861,30862,30865,30866,31035,30950,30999,31000,31001,31002,31003,31270,31271,31272,31273,31274,31275,30270,30762,30796,30797,30801,30802,30803,30804,30805,30806,30807,30809,30811,30812,30813,30814,30815,30816,30817,30818,30819,30820,30821,30822,30823,30824,30847,30848,30849,30850,30851,30852,30891,30892,30893,30894,31004,31005,31006,31007,31008,31009,31011,31015,31016,31020,31021,31023,31024,31025,31276,31277,31278,31279,31280,31281,31282,31284,31285,31286,31539,31614,31615,31616,31617,31618,31619,31621,31622,31623,31624,31625,31626,31627,31628,31629,31630,31631,31632,31633,31634,31635,31636,31637,31638,31036,668,11209,11210,14057,14058,14071,14072,14073,14074,28915,30688,30810,31101,31103,31105,31107,31181,31182,31183,31184,31185,31186,31198,31199,31200,31201,188,251,302,303,348,355,368,383,403,442,461,573,607,611,693,741,742,767,940,1062,1120,1121,1122,1123,1124,1125,1160,1186,1188,1330,1331,1977,2958,2960,2962,3090,3091,3092,3093,3957,3958,3962,4155,12345,12346,12347,12348,12349,12350,12351,12352,12353,12354,12355,12356,12357,12358,12359,12360,12361,12362,12576,12577,12578,12579,12580,12581,12582,12583,12927,12928,12929,12930,12931,12932,12933,12934,12935,12936,12937,12938,12939,12940,12941,12942,12943,12944,12945,12946,12947,12948,12949,12950,12951,12952,19288,19289,19290,19291,21540,27853,27875,27898,27909,27989,28119,28129,28131,28157,28171,28186,28201,28294,28338,29035,29045,29078,29079,29247,29306,29349,29450,29451,29452,29552,29654,29695,30088,30232,30540,30585,30853,30854,30855,30856,30864,30872,30873,30874,31110,31517,31518,31519,31534,31639,31965)) 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(30770,30771,30784,30785,30786,30787,30794,30795,30798,30799,30800,30808,31010,31012,31013,31014,31017,31018,31019,31022,31283,31893,30761,30844,30845,30846,30860,30861,30862,30865,30866,31035,30950,30999,31000,31001,31002,31003,31270,31271,31272,31273,31274,31275,30270,30762,30796,30797,30801,30802,30803,30804,30805,30806,30807,30809,30811,30812,30813,30814,30815,30816,30817,30818,30819,30820,30821,30822,30823,30824,30847,30848,30849,30850,30851,30852,30891,30892,30893,30894,31004,31005,31006,31007,31008,31009,31011,31015,31016,31020,31021,31023,31024,31025,31276,31277,31278,31279,31280,31281,31282,31284,31285,31286,31539,31614,31615,31616,31617,31618,31619,31621,31622,31623,31624,31625,31626,31627,31628,31629,31630,31631,31632,31633,31634,31635,31636,31637,31638,31036,668,11209,11210,14057,14058,14071,14072,14073,14074,28915,30688,30810,31101,31103,31105,31107,31181,31182,31183,31184,31185,31186,31198,31199,31200,31201,188,251,302,303,348,355,368,383,403,442,461,573,607,611,693,741,742,767,940,1062,1120,1121,1122,1123,1124,1125,1160,1186,1188,1330,1331,1977,2958,2960,2962,3090,3091,3092,3093,3957,3958,3962,4155,12345,12346,12347,12348,12349,12350,12351,12352,12353,12354,12355,12356,12357,12358,12359,12360,12361,12362,12576,12577,12578,12579,12580,12581,12582,12583,12927,12928,12929,12930,12931,12932,12933,12934,12935,12936,12937,12938,12939,12940,12941,12942,12943,12944,12945,12946,12947,12948,12949,12950,12951,12952,19288,19289,19290,19291,21540,27853,27875,27898,27909,27989,28119,28129,28131,28157,28171,28186,28201,28294,28338,29035,29045,29078,29079,29247,29306,29349,29450,29451,29452,29552,29654,29695,30088,30232,30540,30585,30853,30854,30855,30856,30864,30872,30873,30874,31110,31517,31518,31519,31534,31639,31965) 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=Bus&page=###page###

1475

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