/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(28457,28458,28459,28460,28712,28827,28860,29714,29717,29720,29723,29725,29727,29728,29729,29730,29731,29732,29733,29734,29735,29737,29739,29740,29741,29742,29743,29745,29747,29761,29762,29764,29767,29770,29776,29779,29780,29781,29782,29783,29786,29787,29788,29789,29790,29791,29793,29796,29875,29877,29879,29882,29885,29888,29891,29892,29894,29896,29898,29900,29947,29948,29949,29996,30002,30003,30004,30005,30006,30037,30039,30042,30045,30048,30051,30052,30053,30109,30110,30112,30113,30114,30115,30189,30190,30191,30192,30246,30247,30248,30249,30250,30264,30505,30774,30775,30776,30778,30780,30782,30784,30786,30788,30789,30809,30834,31260,31262,31342,31343,31624,31625,31681,31686,31689,31692,31695,31724,31736,31917,1302,1483,1518,1526,1527,1528,2001,3387,3407,3409,3411,3416,3417,3418,3423,3424,3425,3432,3433,3434,3441,3442,3443,3473,3474,5672,5673,6784,6785,6786,6787,6788,6789,6790,6791,7623,7627,8266,8267,8268,8269,8270,8271,8272,8273,8274,8275,8276,8277,8278,8279,8280,8281,8282,8283,8284,8285,12592,12593,12602,12603,12616,12617,12618,12619,12629,12630,12631,12632,12645,12646,12647,12648,12649,12650,12663,12664,12665,12666,12667,12668,12692,12693,12694,12695,12696,12697,12698,12699,12700,12701,12702,12703,12704,12705,12706,12707,12708,12709,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,27818,28109,28816,28817,28818,28819,28820,28878,28879,28880,28915,29215,29246,29262,29263,29264,29265,29266,29396,29950,29951,29952,29958,29961,29967,29970,29993,30026,30027,30255,30282,30504,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,30794,30795,30796,30797,30798,30799,30800,30801,30802,30803,30804,30805,30806,30807,30808,30811,30813,30815,30817,30819,30821,30823,30828,30934,31005,31006,31012,31013,31014,31040,31054,31064,31112,31113,31115,31116,31117,31118,31148,31152,31164,31175,31178,31291,31315,31316,31333,31344,31345,31358,31626,31627,31654,31655,31684,31920,31982))

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(28457,28458,28459,28460,28712,28827,28860,29714,29717,29720,29723,29725,29727,29728,29729,29730,29731,29732,29733,29734,29735,29737,29739,29740,29741,29742,29743,29745,29747,29761,29762,29764,29767,29770,29776,29779,29780,29781,29782,29783,29786,29787,29788,29789,29790,29791,29793,29796,29875,29877,29879,29882,29885,29888,29891,29892,29894,29896,29898,29900,29947,29948,29949,29996,30002,30003,30004,30005,30006,30037,30039,30042,30045,30048,30051,30052,30053,30109,30110,30112,30113,30114,30115,30189,30190,30191,30192,30246,30247,30248,30249,30250,30264,30505,30774,30775,30776,30778,30780,30782,30784,30786,30788,30789,30809,30834,31260,31262,31342,31343,31624,31625,31681,31686,31689,31692,31695,31724,31736,31917,1302,1483,1518,1526,1527,1528,2001,3387,3407,3409,3411,3416,3417,3418,3423,3424,3425,3432,3433,3434,3441,3442,3443,3473,3474,5672,5673,6784,6785,6786,6787,6788,6789,6790,6791,7623,7627,8266,8267,8268,8269,8270,8271,8272,8273,8274,8275,8276,8277,8278,8279,8280,8281,8282,8283,8284,8285,12592,12593,12602,12603,12616,12617,12618,12619,12629,12630,12631,12632,12645,12646,12647,12648,12649,12650,12663,12664,12665,12666,12667,12668,12692,12693,12694,12695,12696,12697,12698,12699,12700,12701,12702,12703,12704,12705,12706,12707,12708,12709,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,27818,28109,28816,28817,28818,28819,28820,28878,28879,28880,28915,29215,29246,29262,29263,29264,29265,29266,29396,29950,29951,29952,29958,29961,29967,29970,29993,30026,30027,30255,30282,30504,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,30794,30795,30796,30797,30798,30799,30800,30801,30802,30803,30804,30805,30806,30807,30808,30811,30813,30815,30817,30819,30821,30823,30828,30934,31005,31006,31012,31013,31014,31040,31054,31064,31112,31113,31115,31116,31117,31118,31148,31152,31164,31175,31178,31291,31315,31316,31333,31344,31345,31358,31626,31627,31654,31655,31684,31920,31982)) 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(28457,28458,28459,28460,28712,28827,28860,29714,29717,29720,29723,29725,29727,29728,29729,29730,29731,29732,29733,29734,29735,29737,29739,29740,29741,29742,29743,29745,29747,29761,29762,29764,29767,29770,29776,29779,29780,29781,29782,29783,29786,29787,29788,29789,29790,29791,29793,29796,29875,29877,29879,29882,29885,29888,29891,29892,29894,29896,29898,29900,29947,29948,29949,29996,30002,30003,30004,30005,30006,30037,30039,30042,30045,30048,30051,30052,30053,30109,30110,30112,30113,30114,30115,30189,30190,30191,30192,30246,30247,30248,30249,30250,30264,30505,30774,30775,30776,30778,30780,30782,30784,30786,30788,30789,30809,30834,31260,31262,31342,31343,31624,31625,31681,31686,31689,31692,31695,31724,31736,31917,1302,1483,1518,1526,1527,1528,2001,3387,3407,3409,3411,3416,3417,3418,3423,3424,3425,3432,3433,3434,3441,3442,3443,3473,3474,5672,5673,6784,6785,6786,6787,6788,6789,6790,6791,7623,7627,8266,8267,8268,8269,8270,8271,8272,8273,8274,8275,8276,8277,8278,8279,8280,8281,8282,8283,8284,8285,12592,12593,12602,12603,12616,12617,12618,12619,12629,12630,12631,12632,12645,12646,12647,12648,12649,12650,12663,12664,12665,12666,12667,12668,12692,12693,12694,12695,12696,12697,12698,12699,12700,12701,12702,12703,12704,12705,12706,12707,12708,12709,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,27818,28109,28816,28817,28818,28819,28820,28878,28879,28880,28915,29215,29246,29262,29263,29264,29265,29266,29396,29950,29951,29952,29958,29961,29967,29970,29993,30026,30027,30255,30282,30504,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,30794,30795,30796,30797,30798,30799,30800,30801,30802,30803,30804,30805,30806,30807,30808,30811,30813,30815,30817,30819,30821,30823,30828,30934,31005,31006,31012,31013,31014,31040,31054,31064,31112,31113,31115,31116,31117,31118,31148,31152,31164,31175,31178,31291,31315,31316,31333,31344,31345,31358,31626,31627,31654,31655,31684,31920,31982) 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=350&page=###page###

522

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