/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(4998,30464,30467,30470,12,185,439,454,1019,1115,1579,1580,1581,1582,1583,1584,1585,1678,1914,1915,1999,2090,2091,2092,2093,2094,2399,2615,2720,2721,2722,2765,4038,4109,4141,4444,4445,4474,4475,4476,4477,4485,4486,4487,4488,4523,4524,4525,4526,4953,4954,4955,4983,5016,5018,5020,5052,5053,5054,5056,5057,5149,5150,5151,5152,5153,5154,5155,5159,5185,5668,5669,6097,6290,6296,6537,7812,7813,7814,7815,7816,7817,7818,7819,7820,7821,8180,8286,8287,8288,8313,8314,8315,8316,8317,8318,8365,8366,8380,8381,8382,8383,8397,8398,8404,8405,8406,8407,8408,8409,8410,8411,8453,8508,8888,9914,9915,9916,9917,9918,9919,9920,9921,9922,10144,10145,10154,10155,10156,10157,10158,10159,10160,10161,10273,10274,10275,10276,10277,10283,10284,10285,10286,10287,10293,10294,10295,10296,10297,10303,10304,10305,10306,10307,10313,10314,10315,10316,10317,10323,10324,10325,10326,10327,10333,10334,10335,10336,10337,10343,10344,10345,10346,10347,10353,10355,10356,10357,10358,10442,10443,10493,10494,10495,10496,10497,10529,10530,10537,10553,10554,10559,10560,10561,10562,10635,10644,10665,10667,10668,10669,10670,10671,10672,10673,10674,10675,10676,10677,10678,10679,10680,10906,10907,10908,10909,10910,10911,10942,10943,10944,11058,11071,11101,11102,11103,11104,11105,11106,11107,11108,11109,11110,11111,11112,11115,11116,11117,11118,11157,11158,11159,11160,11161,11162,11163,11164,11304,11305,11306,11307,11308,11309,11345,11346,11347,11348,11386,11387,11388,11389,11390,11391,11715,11716,13575,13580,13593,13594,13595,13600,13601,13602,13607,13608,13609,13614,13615,13616,13700,13701,13702,13703,13712,13713,13714,13715,13724,13725,13726,13727,13736,13737,13738,13739,13746,13749,13750,13751,13760,13761,13762,13763,13889,13890,15819,15820,27983,28364,28505,28506,28545,28546,28992,28993,29042,29050,29960,29977,30403,30425,30427,30510,30513,30799,31009,31013,31023,31127,31128,31145,31162,31165,31166,31279,31284,31434,31664,31665,31666,31702))

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(4998,30464,30467,30470,12,185,439,454,1019,1115,1579,1580,1581,1582,1583,1584,1585,1678,1914,1915,1999,2090,2091,2092,2093,2094,2399,2615,2720,2721,2722,2765,4038,4109,4141,4444,4445,4474,4475,4476,4477,4485,4486,4487,4488,4523,4524,4525,4526,4953,4954,4955,4983,5016,5018,5020,5052,5053,5054,5056,5057,5149,5150,5151,5152,5153,5154,5155,5159,5185,5668,5669,6097,6290,6296,6537,7812,7813,7814,7815,7816,7817,7818,7819,7820,7821,8180,8286,8287,8288,8313,8314,8315,8316,8317,8318,8365,8366,8380,8381,8382,8383,8397,8398,8404,8405,8406,8407,8408,8409,8410,8411,8453,8508,8888,9914,9915,9916,9917,9918,9919,9920,9921,9922,10144,10145,10154,10155,10156,10157,10158,10159,10160,10161,10273,10274,10275,10276,10277,10283,10284,10285,10286,10287,10293,10294,10295,10296,10297,10303,10304,10305,10306,10307,10313,10314,10315,10316,10317,10323,10324,10325,10326,10327,10333,10334,10335,10336,10337,10343,10344,10345,10346,10347,10353,10355,10356,10357,10358,10442,10443,10493,10494,10495,10496,10497,10529,10530,10537,10553,10554,10559,10560,10561,10562,10635,10644,10665,10667,10668,10669,10670,10671,10672,10673,10674,10675,10676,10677,10678,10679,10680,10906,10907,10908,10909,10910,10911,10942,10943,10944,11058,11071,11101,11102,11103,11104,11105,11106,11107,11108,11109,11110,11111,11112,11115,11116,11117,11118,11157,11158,11159,11160,11161,11162,11163,11164,11304,11305,11306,11307,11308,11309,11345,11346,11347,11348,11386,11387,11388,11389,11390,11391,11715,11716,13575,13580,13593,13594,13595,13600,13601,13602,13607,13608,13609,13614,13615,13616,13700,13701,13702,13703,13712,13713,13714,13715,13724,13725,13726,13727,13736,13737,13738,13739,13746,13749,13750,13751,13760,13761,13762,13763,13889,13890,15819,15820,27983,28364,28505,28506,28545,28546,28992,28993,29042,29050,29960,29977,30403,30425,30427,30510,30513,30799,31009,31013,31023,31127,31128,31145,31162,31165,31166,31279,31284,31434,31664,31665,31666,31702)) 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(4998,30464,30467,30470,12,185,439,454,1019,1115,1579,1580,1581,1582,1583,1584,1585,1678,1914,1915,1999,2090,2091,2092,2093,2094,2399,2615,2720,2721,2722,2765,4038,4109,4141,4444,4445,4474,4475,4476,4477,4485,4486,4487,4488,4523,4524,4525,4526,4953,4954,4955,4983,5016,5018,5020,5052,5053,5054,5056,5057,5149,5150,5151,5152,5153,5154,5155,5159,5185,5668,5669,6097,6290,6296,6537,7812,7813,7814,7815,7816,7817,7818,7819,7820,7821,8180,8286,8287,8288,8313,8314,8315,8316,8317,8318,8365,8366,8380,8381,8382,8383,8397,8398,8404,8405,8406,8407,8408,8409,8410,8411,8453,8508,8888,9914,9915,9916,9917,9918,9919,9920,9921,9922,10144,10145,10154,10155,10156,10157,10158,10159,10160,10161,10273,10274,10275,10276,10277,10283,10284,10285,10286,10287,10293,10294,10295,10296,10297,10303,10304,10305,10306,10307,10313,10314,10315,10316,10317,10323,10324,10325,10326,10327,10333,10334,10335,10336,10337,10343,10344,10345,10346,10347,10353,10355,10356,10357,10358,10442,10443,10493,10494,10495,10496,10497,10529,10530,10537,10553,10554,10559,10560,10561,10562,10635,10644,10665,10667,10668,10669,10670,10671,10672,10673,10674,10675,10676,10677,10678,10679,10680,10906,10907,10908,10909,10910,10911,10942,10943,10944,11058,11071,11101,11102,11103,11104,11105,11106,11107,11108,11109,11110,11111,11112,11115,11116,11117,11118,11157,11158,11159,11160,11161,11162,11163,11164,11304,11305,11306,11307,11308,11309,11345,11346,11347,11348,11386,11387,11388,11389,11390,11391,11715,11716,13575,13580,13593,13594,13595,13600,13601,13602,13607,13608,13609,13614,13615,13616,13700,13701,13702,13703,13712,13713,13714,13715,13724,13725,13726,13727,13736,13737,13738,13739,13746,13749,13750,13751,13760,13761,13762,13763,13889,13890,15819,15820,27983,28364,28505,28506,28545,28546,28992,28993,29042,29050,29960,29977,30403,30425,30427,30510,30513,30799,31009,31013,31023,31127,31128,31145,31162,31165,31166,31279,31284,31434,31664,31665,31666,31702) 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=30&page=###page###

596

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