/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(1998,29481,30369,31178,31179,31180,31737,31738,53,134,135,142,147,148,151,159,635,636,831,834,843,844,849,850,973,1035,1411,1414,1430,1438,1440,2018,2809,2816,2817,2818,2819,2890,2892,2899,2906,2910,2915,3406,3407,3408,3409,3410,3411,3412,3413,3414,3415,3416,3417,3418,3419,3420,3421,3422,3423,3424,3425,3426,3427,3428,3429,3430,3431,3432,3433,3434,3435,3436,3437,3438,3439,3440,3441,3442,3443,3444,3445,3446,4161,6783,6789,6791,6796,7886,7887,7888,7889,7890,7891,10168,10189,11752,11756,12760,12761,12765,12766,12770,12771,12775,12776,12780,12781,12785,12786,12790,12791,12795,12796,12803,12804,12810,12811,12817,12818,12824,12825,12828,12829,12834,12835,12838,12839,12844,12845,12848,12849,12854,12855,12858,12859,12864,12865,12868,12869,12874,12875,12880,12885,12965,12969,12970,12971,14650,14653,15871,15872,15994,15995,15996,16086,16088,16090,16092,16132,16134,17317,17319,17347,17349,18483,18485,18490,18491,18500,18501,18502,18503,18522,18523,18524,18525,18526,18527,18528,18529,18530,18531,18532,18533,18534,18575,18578,18581,18584,18586,18588,18617,18620,18623,18626,18628,18630,21284,21287,21290,21293,21295,27838,28214,28294,28382,28587,28736,28737,28746,28812,28813,28814,28815,28816,28817,28818,28819,28820,28861,28878,28879,28880,28881,28882,28965,28966,28967,28968,29033,29215,29246,29262,29263,29264,29265,29266,29267,29268,29269,29270,29271,29272,29273,29274,29275,29276,29277,29278,29279,29280,29281,29282,29283,29284,29285,29286,29287,29288,29289,29290,29291,29292,29293,29294,29295,29396,29482,29483,29484,29519,29520,29531,29935,29936,30058,30235,30282,30289,30371,30461,30519,30520,30522,30523,30524,30539,30615,30616,30617,30618,30619,30620,30621,30622,30623,30624,30625,30626,30627,30628,30629,30630,30631,30632,30633,30634,30635,30636,30637,30638,30639,30640,30641,30642,30643,30644,30645,30646,30647,30648,30649,30650,30651,30652,30653,30654,30655,30656,30657,30658,30659,30660,30661,30662,30663,30664,30665,30666,30667,30668,30669,30670,30671,30672,30673,30674,30675,30676,30677,30678,30679,30680,30681,30682,30683,30684,30685,30686,30687,30699,30700,30733,30829,30831,31008,31024,31147,31148,31149,31175,31176,31177,31240,31247,31278,31285,31333,31338,31342,31346,31358,31413,31654,31655,31656,31657,31739,31785,31786,31874,31982,196))

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(1998,29481,30369,31178,31179,31180,31737,31738,53,134,135,142,147,148,151,159,635,636,831,834,843,844,849,850,973,1035,1411,1414,1430,1438,1440,2018,2809,2816,2817,2818,2819,2890,2892,2899,2906,2910,2915,3406,3407,3408,3409,3410,3411,3412,3413,3414,3415,3416,3417,3418,3419,3420,3421,3422,3423,3424,3425,3426,3427,3428,3429,3430,3431,3432,3433,3434,3435,3436,3437,3438,3439,3440,3441,3442,3443,3444,3445,3446,4161,6783,6789,6791,6796,7886,7887,7888,7889,7890,7891,10168,10189,11752,11756,12760,12761,12765,12766,12770,12771,12775,12776,12780,12781,12785,12786,12790,12791,12795,12796,12803,12804,12810,12811,12817,12818,12824,12825,12828,12829,12834,12835,12838,12839,12844,12845,12848,12849,12854,12855,12858,12859,12864,12865,12868,12869,12874,12875,12880,12885,12965,12969,12970,12971,14650,14653,15871,15872,15994,15995,15996,16086,16088,16090,16092,16132,16134,17317,17319,17347,17349,18483,18485,18490,18491,18500,18501,18502,18503,18522,18523,18524,18525,18526,18527,18528,18529,18530,18531,18532,18533,18534,18575,18578,18581,18584,18586,18588,18617,18620,18623,18626,18628,18630,21284,21287,21290,21293,21295,27838,28214,28294,28382,28587,28736,28737,28746,28812,28813,28814,28815,28816,28817,28818,28819,28820,28861,28878,28879,28880,28881,28882,28965,28966,28967,28968,29033,29215,29246,29262,29263,29264,29265,29266,29267,29268,29269,29270,29271,29272,29273,29274,29275,29276,29277,29278,29279,29280,29281,29282,29283,29284,29285,29286,29287,29288,29289,29290,29291,29292,29293,29294,29295,29396,29482,29483,29484,29519,29520,29531,29935,29936,30058,30235,30282,30289,30371,30461,30519,30520,30522,30523,30524,30539,30615,30616,30617,30618,30619,30620,30621,30622,30623,30624,30625,30626,30627,30628,30629,30630,30631,30632,30633,30634,30635,30636,30637,30638,30639,30640,30641,30642,30643,30644,30645,30646,30647,30648,30649,30650,30651,30652,30653,30654,30655,30656,30657,30658,30659,30660,30661,30662,30663,30664,30665,30666,30667,30668,30669,30670,30671,30672,30673,30674,30675,30676,30677,30678,30679,30680,30681,30682,30683,30684,30685,30686,30687,30699,30700,30733,30829,30831,31008,31024,31147,31148,31149,31175,31176,31177,31240,31247,31278,31285,31333,31338,31342,31346,31358,31413,31654,31655,31656,31657,31739,31785,31786,31874,31982,196)) 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(1998,29481,30369,31178,31179,31180,31737,31738,53,134,135,142,147,148,151,159,635,636,831,834,843,844,849,850,973,1035,1411,1414,1430,1438,1440,2018,2809,2816,2817,2818,2819,2890,2892,2899,2906,2910,2915,3406,3407,3408,3409,3410,3411,3412,3413,3414,3415,3416,3417,3418,3419,3420,3421,3422,3423,3424,3425,3426,3427,3428,3429,3430,3431,3432,3433,3434,3435,3436,3437,3438,3439,3440,3441,3442,3443,3444,3445,3446,4161,6783,6789,6791,6796,7886,7887,7888,7889,7890,7891,10168,10189,11752,11756,12760,12761,12765,12766,12770,12771,12775,12776,12780,12781,12785,12786,12790,12791,12795,12796,12803,12804,12810,12811,12817,12818,12824,12825,12828,12829,12834,12835,12838,12839,12844,12845,12848,12849,12854,12855,12858,12859,12864,12865,12868,12869,12874,12875,12880,12885,12965,12969,12970,12971,14650,14653,15871,15872,15994,15995,15996,16086,16088,16090,16092,16132,16134,17317,17319,17347,17349,18483,18485,18490,18491,18500,18501,18502,18503,18522,18523,18524,18525,18526,18527,18528,18529,18530,18531,18532,18533,18534,18575,18578,18581,18584,18586,18588,18617,18620,18623,18626,18628,18630,21284,21287,21290,21293,21295,27838,28214,28294,28382,28587,28736,28737,28746,28812,28813,28814,28815,28816,28817,28818,28819,28820,28861,28878,28879,28880,28881,28882,28965,28966,28967,28968,29033,29215,29246,29262,29263,29264,29265,29266,29267,29268,29269,29270,29271,29272,29273,29274,29275,29276,29277,29278,29279,29280,29281,29282,29283,29284,29285,29286,29287,29288,29289,29290,29291,29292,29293,29294,29295,29396,29482,29483,29484,29519,29520,29531,29935,29936,30058,30235,30282,30289,30371,30461,30519,30520,30522,30523,30524,30539,30615,30616,30617,30618,30619,30620,30621,30622,30623,30624,30625,30626,30627,30628,30629,30630,30631,30632,30633,30634,30635,30636,30637,30638,30639,30640,30641,30642,30643,30644,30645,30646,30647,30648,30649,30650,30651,30652,30653,30654,30655,30656,30657,30658,30659,30660,30661,30662,30663,30664,30665,30666,30667,30668,30669,30670,30671,30672,30673,30674,30675,30676,30677,30678,30679,30680,30681,30682,30683,30684,30685,30686,30687,30699,30700,30733,30829,30831,31008,31024,31147,31148,31149,31175,31176,31177,31240,31247,31278,31285,31333,31338,31342,31346,31358,31413,31654,31655,31656,31657,31739,31785,31786,31874,31982,196) 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=Super&page=###page###

707

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