/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(28565,28569,28845,15733,15734,15741,15742,15743,15744,17787,17791,17792,17793,17796,17797,21544,21557,21558,21574,21575,21576,21577,21578,21579,21580,21581,21582,21583,21584,21585,21616,21623,21624,21628,21635,21636,22175,22176,22177,22217,22218,22219,22259,22260,22261,22301,22302,22303,22343,22344,22345,22385,22386,22387,22427,22428,22429,22469,22470,22471,22511,22512,22513,22553,22554,22555,22595,22596,22597,22637,22638,22639,22679,22680,22681,22721,22722,22723,22763,22764,22765,22805,22806,22807,22847,22848,22849,22889,22890,22891,22931,22932,22933,22965,22966,22967,22992,22993,22994,23025,23026,23027,23038,23051,23064,23077,23090,23103,23114,23121,23128,23135,23142,23149,23158,23172,23187,23200,23213,23226,23237,23244,23253,23267,23280,23293,23306,23319,23330,23337,23344,23351,23358,23365,23374,23387,23400,23413,23427,23439,23450,23457,23464,23471,23478,23485,23494,23507,23520,23533,23546,23559,23570,23577,23584,23591,23598,23605,23614,23627,23640,23653,23665,23678,23689,23696,23703,23710,23717,23724,23734,23747,23760,23773,23786,23799,23810,23817,23824,23831,23838,23845,23854,23867,23880,23893,23906,23919,23930,23937,23945,23952,23959,23966,23975,23988,24008,24020,24032,24045,24098,24110,24122,24134,24147,24160,24221,24232,24251,24263,24283,24295,24342,24353,24373,24384,24402,24420,24466,24478,24498,24510,24530,24542,24589,24601,24622,24634,24654,24666,24719,24731,24743,24762,24782,24794,24840,24853,24866,24880,24892,24904,24916,24928,24929,24949,24961,24981,24993,25040,25052,25072,25084,25104,25116,25161,25175,25186,25199,25210,25225,25238,25249,25260,25270,25281,25294,25307,25320,25332,25343,25354,25365,25376,25389,25402,25415,25428,25439,25449,25460,25471,25484,25497,25510,25523,25534,25545,25556,25567,25580,25593,25606,25619,25631,25642,25653,25664,25677,25690,25703,25705,25716,25727,25738,25749,25760,25772,25785,25798,25811,25822,25833,25844,25855,25868,25881,25894,25907,25918,25929,25940,26429,26443,26457,26471,26485,26497,26509,26521,26530,26536,26542,26548,26861,26875,26889,26903,26917,26929,26941,26953,26963,26969,26975,26980,26989,27003,27018,27032,27046,27058,27070,27082,27091,27097,27103,27109,27271,27285,27299,27313,27325,27337,27349,27677,27692,27706,27720,27734,27746,27758,27770))
SELECT `id`, `url`, `name_title`, `name_full`, `id_new`, `market`, `tier`, `update_date`, `segment` FROM prints_set WHERE id IN(SELECT DISTINCT set_id FROM prints_set_vector WHERE vector_id IN(28565,28569,28845,15733,15734,15741,15742,15743,15744,17787,17791,17792,17793,17796,17797,21544,21557,21558,21574,21575,21576,21577,21578,21579,21580,21581,21582,21583,21584,21585,21616,21623,21624,21628,21635,21636,22175,22176,22177,22217,22218,22219,22259,22260,22261,22301,22302,22303,22343,22344,22345,22385,22386,22387,22427,22428,22429,22469,22470,22471,22511,22512,22513,22553,22554,22555,22595,22596,22597,22637,22638,22639,22679,22680,22681,22721,22722,22723,22763,22764,22765,22805,22806,22807,22847,22848,22849,22889,22890,22891,22931,22932,22933,22965,22966,22967,22992,22993,22994,23025,23026,23027,23038,23051,23064,23077,23090,23103,23114,23121,23128,23135,23142,23149,23158,23172,23187,23200,23213,23226,23237,23244,23253,23267,23280,23293,23306,23319,23330,23337,23344,23351,23358,23365,23374,23387,23400,23413,23427,23439,23450,23457,23464,23471,23478,23485,23494,23507,23520,23533,23546,23559,23570,23577,23584,23591,23598,23605,23614,23627,23640,23653,23665,23678,23689,23696,23703,23710,23717,23724,23734,23747,23760,23773,23786,23799,23810,23817,23824,23831,23838,23845,23854,23867,23880,23893,23906,23919,23930,23937,23945,23952,23959,23966,23975,23988,24008,24020,24032,24045,24098,24110,24122,24134,24147,24160,24221,24232,24251,24263,24283,24295,24342,24353,24373,24384,24402,24420,24466,24478,24498,24510,24530,24542,24589,24601,24622,24634,24654,24666,24719,24731,24743,24762,24782,24794,24840,24853,24866,24880,24892,24904,24916,24928,24929,24949,24961,24981,24993,25040,25052,25072,25084,25104,25116,25161,25175,25186,25199,25210,25225,25238,25249,25260,25270,25281,25294,25307,25320,25332,25343,25354,25365,25376,25389,25402,25415,25428,25439,25449,25460,25471,25484,25497,25510,25523,25534,25545,25556,25567,25580,25593,25606,25619,25631,25642,25653,25664,25677,25690,25703,25705,25716,25727,25738,25749,25760,25772,25785,25798,25811,25822,25833,25844,25855,25868,25881,25894,25907,25918,25929,25940,26429,26443,26457,26471,26485,26497,26509,26521,26530,26536,26542,26548,26861,26875,26889,26903,26917,26929,26941,26953,26963,26969,26975,26980,26989,27003,27018,27032,27046,27058,27070,27082,27091,27097,27103,27109,27271,27285,27299,27313,27325,27337,27349,27677,27692,27706,27720,27734,27746,27758,27770)) LIMIT 0, 30
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(16537, 18686, 32339, 22622, 24966, 26160, 26952, 28803, 36283) GROUP BY `prints_set`.`id` ORDER BY IF(MAX(`prints_vector`.`preview`) IS NOT NULL AND MAX(`prints_vector`.`preview`) != '', 0, 1), `prints_set`.`name_full`
SELECT COUNT(*) cnt FROM `prints_set_vector` INNER JOIN `prints_vector` ON `prints_vector`.`id` = `prints_set_vector`.`vector_id` WHERE `prints_set_vector`.`set_id` = 16537 AND `prints_set_vector`.`vector_id` IN(28565,28569,28845,15733,15734,15741,15742,15743,15744,17787,17791,17792,17793,17796,17797,21544,21557,21558,21574,21575,21576,21577,21578,21579,21580,21581,21582,21583,21584,21585,21616,21623,21624,21628,21635,21636,22175,22176,22177,22217,22218,22219,22259,22260,22261,22301,22302,22303,22343,22344,22345,22385,22386,22387,22427,22428,22429,22469,22470,22471,22511,22512,22513,22553,22554,22555,22595,22596,22597,22637,22638,22639,22679,22680,22681,22721,22722,22723,22763,22764,22765,22805,22806,22807,22847,22848,22849,22889,22890,22891,22931,22932,22933,22965,22966,22967,22992,22993,22994,23025,23026,23027,23038,23051,23064,23077,23090,23103,23114,23121,23128,23135,23142,23149,23158,23172,23187,23200,23213,23226,23237,23244,23253,23267,23280,23293,23306,23319,23330,23337,23344,23351,23358,23365,23374,23387,23400,23413,23427,23439,23450,23457,23464,23471,23478,23485,23494,23507,23520,23533,23546,23559,23570,23577,23584,23591,23598,23605,23614,23627,23640,23653,23665,23678,23689,23696,23703,23710,23717,23724,23734,23747,23760,23773,23786,23799,23810,23817,23824,23831,23838,23845,23854,23867,23880,23893,23906,23919,23930,23937,23945,23952,23959,23966,23975,23988,24008,24020,24032,24045,24098,24110,24122,24134,24147,24160,24221,24232,24251,24263,24283,24295,24342,24353,24373,24384,24402,24420,24466,24478,24498,24510,24530,24542,24589,24601,24622,24634,24654,24666,24719,24731,24743,24762,24782,24794,24840,24853,24866,24880,24892,24904,24916,24928,24929,24949,24961,24981,24993,25040,25052,25072,25084,25104,25116,25161,25175,25186,25199,25210,25225,25238,25249,25260,25270,25281,25294,25307,25320,25332,25343,25354,25365,25376,25389,25402,25415,25428,25439,25449,25460,25471,25484,25497,25510,25523,25534,25545,25556,25567,25580,25593,25606,25619,25631,25642,25653,25664,25677,25690,25703,25705,25716,25727,25738,25749,25760,25772,25785,25798,25811,25822,25833,25844,25855,25868,25881,25894,25907,25918,25929,25940,26429,26443,26457,26471,26485,26497,26509,26521,26530,26536,26542,26548,26861,26875,26889,26903,26917,26929,26941,26953,26963,26969,26975,26980,26989,27003,27018,27032,27046,27058,27070,27082,27091,27097,27103,27109,27271,27285,27299,27313,27325,27337,27349,27677,27692,27706,27720,27734,27746,27758,27770) AND `prints_vector`.`bundle` = 0
SELECT COUNT(*) cnt FROM `prints_set_vector` INNER JOIN `prints_vector` ON `prints_vector`.`id` = `prints_set_vector`.`vector_id` WHERE `prints_set_vector`.`set_id` = 32339 AND `prints_set_vector`.`vector_id` IN(28565,28569,28845,15733,15734,15741,15742,15743,15744,17787,17791,17792,17793,17796,17797,21544,21557,21558,21574,21575,21576,21577,21578,21579,21580,21581,21582,21583,21584,21585,21616,21623,21624,21628,21635,21636,22175,22176,22177,22217,22218,22219,22259,22260,22261,22301,22302,22303,22343,22344,22345,22385,22386,22387,22427,22428,22429,22469,22470,22471,22511,22512,22513,22553,22554,22555,22595,22596,22597,22637,22638,22639,22679,22680,22681,22721,22722,22723,22763,22764,22765,22805,22806,22807,22847,22848,22849,22889,22890,22891,22931,22932,22933,22965,22966,22967,22992,22993,22994,23025,23026,23027,23038,23051,23064,23077,23090,23103,23114,23121,23128,23135,23142,23149,23158,23172,23187,23200,23213,23226,23237,23244,23253,23267,23280,23293,23306,23319,23330,23337,23344,23351,23358,23365,23374,23387,23400,23413,23427,23439,23450,23457,23464,23471,23478,23485,23494,23507,23520,23533,23546,23559,23570,23577,23584,23591,23598,23605,23614,23627,23640,23653,23665,23678,23689,23696,23703,23710,23717,23724,23734,23747,23760,23773,23786,23799,23810,23817,23824,23831,23838,23845,23854,23867,23880,23893,23906,23919,23930,23937,23945,23952,23959,23966,23975,23988,24008,24020,24032,24045,24098,24110,24122,24134,24147,24160,24221,24232,24251,24263,24283,24295,24342,24353,24373,24384,24402,24420,24466,24478,24498,24510,24530,24542,24589,24601,24622,24634,24654,24666,24719,24731,24743,24762,24782,24794,24840,24853,24866,24880,24892,24904,24916,24928,24929,24949,24961,24981,24993,25040,25052,25072,25084,25104,25116,25161,25175,25186,25199,25210,25225,25238,25249,25260,25270,25281,25294,25307,25320,25332,25343,25354,25365,25376,25389,25402,25415,25428,25439,25449,25460,25471,25484,25497,25510,25523,25534,25545,25556,25567,25580,25593,25606,25619,25631,25642,25653,25664,25677,25690,25703,25705,25716,25727,25738,25749,25760,25772,25785,25798,25811,25822,25833,25844,25855,25868,25881,25894,25907,25918,25929,25940,26429,26443,26457,26471,26485,26497,26509,26521,26530,26536,26542,26548,26861,26875,26889,26903,26917,26929,26941,26953,26963,26969,26975,26980,26989,27003,27018,27032,27046,27058,27070,27082,27091,27097,27103,27109,27271,27285,27299,27313,27325,27337,27349,27677,27692,27706,27720,27734,27746,27758,27770) AND `prints_vector`.`bundle` = 0
SELECT COUNT(*) cnt FROM `prints_set_vector` INNER JOIN `prints_vector` ON `prints_vector`.`id` = `prints_set_vector`.`vector_id` WHERE `prints_set_vector`.`set_id` = 22622 AND `prints_set_vector`.`vector_id` IN(28565,28569,28845,15733,15734,15741,15742,15743,15744,17787,17791,17792,17793,17796,17797,21544,21557,21558,21574,21575,21576,21577,21578,21579,21580,21581,21582,21583,21584,21585,21616,21623,21624,21628,21635,21636,22175,22176,22177,22217,22218,22219,22259,22260,22261,22301,22302,22303,22343,22344,22345,22385,22386,22387,22427,22428,22429,22469,22470,22471,22511,22512,22513,22553,22554,22555,22595,22596,22597,22637,22638,22639,22679,22680,22681,22721,22722,22723,22763,22764,22765,22805,22806,22807,22847,22848,22849,22889,22890,22891,22931,22932,22933,22965,22966,22967,22992,22993,22994,23025,23026,23027,23038,23051,23064,23077,23090,23103,23114,23121,23128,23135,23142,23149,23158,23172,23187,23200,23213,23226,23237,23244,23253,23267,23280,23293,23306,23319,23330,23337,23344,23351,23358,23365,23374,23387,23400,23413,23427,23439,23450,23457,23464,23471,23478,23485,23494,23507,23520,23533,23546,23559,23570,23577,23584,23591,23598,23605,23614,23627,23640,23653,23665,23678,23689,23696,23703,23710,23717,23724,23734,23747,23760,23773,23786,23799,23810,23817,23824,23831,23838,23845,23854,23867,23880,23893,23906,23919,23930,23937,23945,23952,23959,23966,23975,23988,24008,24020,24032,24045,24098,24110,24122,24134,24147,24160,24221,24232,24251,24263,24283,24295,24342,24353,24373,24384,24402,24420,24466,24478,24498,24510,24530,24542,24589,24601,24622,24634,24654,24666,24719,24731,24743,24762,24782,24794,24840,24853,24866,24880,24892,24904,24916,24928,24929,24949,24961,24981,24993,25040,25052,25072,25084,25104,25116,25161,25175,25186,25199,25210,25225,25238,25249,25260,25270,25281,25294,25307,25320,25332,25343,25354,25365,25376,25389,25402,25415,25428,25439,25449,25460,25471,25484,25497,25510,25523,25534,25545,25556,25567,25580,25593,25606,25619,25631,25642,25653,25664,25677,25690,25703,25705,25716,25727,25738,25749,25760,25772,25785,25798,25811,25822,25833,25844,25855,25868,25881,25894,25907,25918,25929,25940,26429,26443,26457,26471,26485,26497,26509,26521,26530,26536,26542,26548,26861,26875,26889,26903,26917,26929,26941,26953,26963,26969,26975,26980,26989,27003,27018,27032,27046,27058,27070,27082,27091,27097,27103,27109,27271,27285,27299,27313,27325,27337,27349,27677,27692,27706,27720,27734,27746,27758,27770) AND `prints_vector`.`bundle` = 0
SELECT COUNT(*) cnt FROM `prints_set_vector` INNER JOIN `prints_vector` ON `prints_vector`.`id` = `prints_set_vector`.`vector_id` WHERE `prints_set_vector`.`set_id` = 36283 AND `prints_set_vector`.`vector_id` IN(28565,28569,28845,15733,15734,15741,15742,15743,15744,17787,17791,17792,17793,17796,17797,21544,21557,21558,21574,21575,21576,21577,21578,21579,21580,21581,21582,21583,21584,21585,21616,21623,21624,21628,21635,21636,22175,22176,22177,22217,22218,22219,22259,22260,22261,22301,22302,22303,22343,22344,22345,22385,22386,22387,22427,22428,22429,22469,22470,22471,22511,22512,22513,22553,22554,22555,22595,22596,22597,22637,22638,22639,22679,22680,22681,22721,22722,22723,22763,22764,22765,22805,22806,22807,22847,22848,22849,22889,22890,22891,22931,22932,22933,22965,22966,22967,22992,22993,22994,23025,23026,23027,23038,23051,23064,23077,23090,23103,23114,23121,23128,23135,23142,23149,23158,23172,23187,23200,23213,23226,23237,23244,23253,23267,23280,23293,23306,23319,23330,23337,23344,23351,23358,23365,23374,23387,23400,23413,23427,23439,23450,23457,23464,23471,23478,23485,23494,23507,23520,23533,23546,23559,23570,23577,23584,23591,23598,23605,23614,23627,23640,23653,23665,23678,23689,23696,23703,23710,23717,23724,23734,23747,23760,23773,23786,23799,23810,23817,23824,23831,23838,23845,23854,23867,23880,23893,23906,23919,23930,23937,23945,23952,23959,23966,23975,23988,24008,24020,24032,24045,24098,24110,24122,24134,24147,24160,24221,24232,24251,24263,24283,24295,24342,24353,24373,24384,24402,24420,24466,24478,24498,24510,24530,24542,24589,24601,24622,24634,24654,24666,24719,24731,24743,24762,24782,24794,24840,24853,24866,24880,24892,24904,24916,24928,24929,24949,24961,24981,24993,25040,25052,25072,25084,25104,25116,25161,25175,25186,25199,25210,25225,25238,25249,25260,25270,25281,25294,25307,25320,25332,25343,25354,25365,25376,25389,25402,25415,25428,25439,25449,25460,25471,25484,25497,25510,25523,25534,25545,25556,25567,25580,25593,25606,25619,25631,25642,25653,25664,25677,25690,25703,25705,25716,25727,25738,25749,25760,25772,25785,25798,25811,25822,25833,25844,25855,25868,25881,25894,25907,25918,25929,25940,26429,26443,26457,26471,26485,26497,26509,26521,26530,26536,26542,26548,26861,26875,26889,26903,26917,26929,26941,26953,26963,26969,26975,26980,26989,27003,27018,27032,27046,27058,27070,27082,27091,27097,27103,27109,27271,27285,27299,27313,27325,27337,27349,27677,27692,27706,27720,27734,27746,27758,27770) AND `prints_vector`.`bundle` = 0
SELECT COUNT(*) cnt FROM `prints_set_vector` INNER JOIN `prints_vector` ON `prints_vector`.`id` = `prints_set_vector`.`vector_id` WHERE `prints_set_vector`.`set_id` = 28803 AND `prints_set_vector`.`vector_id` IN(28565,28569,28845,15733,15734,15741,15742,15743,15744,17787,17791,17792,17793,17796,17797,21544,21557,21558,21574,21575,21576,21577,21578,21579,21580,21581,21582,21583,21584,21585,21616,21623,21624,21628,21635,21636,22175,22176,22177,22217,22218,22219,22259,22260,22261,22301,22302,22303,22343,22344,22345,22385,22386,22387,22427,22428,22429,22469,22470,22471,22511,22512,22513,22553,22554,22555,22595,22596,22597,22637,22638,22639,22679,22680,22681,22721,22722,22723,22763,22764,22765,22805,22806,22807,22847,22848,22849,22889,22890,22891,22931,22932,22933,22965,22966,22967,22992,22993,22994,23025,23026,23027,23038,23051,23064,23077,23090,23103,23114,23121,23128,23135,23142,23149,23158,23172,23187,23200,23213,23226,23237,23244,23253,23267,23280,23293,23306,23319,23330,23337,23344,23351,23358,23365,23374,23387,23400,23413,23427,23439,23450,23457,23464,23471,23478,23485,23494,23507,23520,23533,23546,23559,23570,23577,23584,23591,23598,23605,23614,23627,23640,23653,23665,23678,23689,23696,23703,23710,23717,23724,23734,23747,23760,23773,23786,23799,23810,23817,23824,23831,23838,23845,23854,23867,23880,23893,23906,23919,23930,23937,23945,23952,23959,23966,23975,23988,24008,24020,24032,24045,24098,24110,24122,24134,24147,24160,24221,24232,24251,24263,24283,24295,24342,24353,24373,24384,24402,24420,24466,24478,24498,24510,24530,24542,24589,24601,24622,24634,24654,24666,24719,24731,24743,24762,24782,24794,24840,24853,24866,24880,24892,24904,24916,24928,24929,24949,24961,24981,24993,25040,25052,25072,25084,25104,25116,25161,25175,25186,25199,25210,25225,25238,25249,25260,25270,25281,25294,25307,25320,25332,25343,25354,25365,25376,25389,25402,25415,25428,25439,25449,25460,25471,25484,25497,25510,25523,25534,25545,25556,25567,25580,25593,25606,25619,25631,25642,25653,25664,25677,25690,25703,25705,25716,25727,25738,25749,25760,25772,25785,25798,25811,25822,25833,25844,25855,25868,25881,25894,25907,25918,25929,25940,26429,26443,26457,26471,26485,26497,26509,26521,26530,26536,26542,26548,26861,26875,26889,26903,26917,26929,26941,26953,26963,26969,26975,26980,26989,27003,27018,27032,27046,27058,27070,27082,27091,27097,27103,27109,27271,27285,27299,27313,27325,27337,27349,27677,27692,27706,27720,27734,27746,27758,27770) AND `prints_vector`.`bundle` = 0
SELECT COUNT(*) cnt FROM `prints_set_vector` INNER JOIN `prints_vector` ON `prints_vector`.`id` = `prints_set_vector`.`vector_id` WHERE `prints_set_vector`.`set_id` = 26160 AND `prints_set_vector`.`vector_id` IN(28565,28569,28845,15733,15734,15741,15742,15743,15744,17787,17791,17792,17793,17796,17797,21544,21557,21558,21574,21575,21576,21577,21578,21579,21580,21581,21582,21583,21584,21585,21616,21623,21624,21628,21635,21636,22175,22176,22177,22217,22218,22219,22259,22260,22261,22301,22302,22303,22343,22344,22345,22385,22386,22387,22427,22428,22429,22469,22470,22471,22511,22512,22513,22553,22554,22555,22595,22596,22597,22637,22638,22639,22679,22680,22681,22721,22722,22723,22763,22764,22765,22805,22806,22807,22847,22848,22849,22889,22890,22891,22931,22932,22933,22965,22966,22967,22992,22993,22994,23025,23026,23027,23038,23051,23064,23077,23090,23103,23114,23121,23128,23135,23142,23149,23158,23172,23187,23200,23213,23226,23237,23244,23253,23267,23280,23293,23306,23319,23330,23337,23344,23351,23358,23365,23374,23387,23400,23413,23427,23439,23450,23457,23464,23471,23478,23485,23494,23507,23520,23533,23546,23559,23570,23577,23584,23591,23598,23605,23614,23627,23640,23653,23665,23678,23689,23696,23703,23710,23717,23724,23734,23747,23760,23773,23786,23799,23810,23817,23824,23831,23838,23845,23854,23867,23880,23893,23906,23919,23930,23937,23945,23952,23959,23966,23975,23988,24008,24020,24032,24045,24098,24110,24122,24134,24147,24160,24221,24232,24251,24263,24283,24295,24342,24353,24373,24384,24402,24420,24466,24478,24498,24510,24530,24542,24589,24601,24622,24634,24654,24666,24719,24731,24743,24762,24782,24794,24840,24853,24866,24880,24892,24904,24916,24928,24929,24949,24961,24981,24993,25040,25052,25072,25084,25104,25116,25161,25175,25186,25199,25210,25225,25238,25249,25260,25270,25281,25294,25307,25320,25332,25343,25354,25365,25376,25389,25402,25415,25428,25439,25449,25460,25471,25484,25497,25510,25523,25534,25545,25556,25567,25580,25593,25606,25619,25631,25642,25653,25664,25677,25690,25703,25705,25716,25727,25738,25749,25760,25772,25785,25798,25811,25822,25833,25844,25855,25868,25881,25894,25907,25918,25929,25940,26429,26443,26457,26471,26485,26497,26509,26521,26530,26536,26542,26548,26861,26875,26889,26903,26917,26929,26941,26953,26963,26969,26975,26980,26989,27003,27018,27032,27046,27058,27070,27082,27091,27097,27103,27109,27271,27285,27299,27313,27325,27337,27349,27677,27692,27706,27720,27734,27746,27758,27770) AND `prints_vector`.`bundle` = 0
SELECT COUNT(*) cnt FROM `prints_set_vector` INNER JOIN `prints_vector` ON `prints_vector`.`id` = `prints_set_vector`.`vector_id` WHERE `prints_set_vector`.`set_id` = 26952 AND `prints_set_vector`.`vector_id` IN(28565,28569,28845,15733,15734,15741,15742,15743,15744,17787,17791,17792,17793,17796,17797,21544,21557,21558,21574,21575,21576,21577,21578,21579,21580,21581,21582,21583,21584,21585,21616,21623,21624,21628,21635,21636,22175,22176,22177,22217,22218,22219,22259,22260,22261,22301,22302,22303,22343,22344,22345,22385,22386,22387,22427,22428,22429,22469,22470,22471,22511,22512,22513,22553,22554,22555,22595,22596,22597,22637,22638,22639,22679,22680,22681,22721,22722,22723,22763,22764,22765,22805,22806,22807,22847,22848,22849,22889,22890,22891,22931,22932,22933,22965,22966,22967,22992,22993,22994,23025,23026,23027,23038,23051,23064,23077,23090,23103,23114,23121,23128,23135,23142,23149,23158,23172,23187,23200,23213,23226,23237,23244,23253,23267,23280,23293,23306,23319,23330,23337,23344,23351,23358,23365,23374,23387,23400,23413,23427,23439,23450,23457,23464,23471,23478,23485,23494,23507,23520,23533,23546,23559,23570,23577,23584,23591,23598,23605,23614,23627,23640,23653,23665,23678,23689,23696,23703,23710,23717,23724,23734,23747,23760,23773,23786,23799,23810,23817,23824,23831,23838,23845,23854,23867,23880,23893,23906,23919,23930,23937,23945,23952,23959,23966,23975,23988,24008,24020,24032,24045,24098,24110,24122,24134,24147,24160,24221,24232,24251,24263,24283,24295,24342,24353,24373,24384,24402,24420,24466,24478,24498,24510,24530,24542,24589,24601,24622,24634,24654,24666,24719,24731,24743,24762,24782,24794,24840,24853,24866,24880,24892,24904,24916,24928,24929,24949,24961,24981,24993,25040,25052,25072,25084,25104,25116,25161,25175,25186,25199,25210,25225,25238,25249,25260,25270,25281,25294,25307,25320,25332,25343,25354,25365,25376,25389,25402,25415,25428,25439,25449,25460,25471,25484,25497,25510,25523,25534,25545,25556,25567,25580,25593,25606,25619,25631,25642,25653,25664,25677,25690,25703,25705,25716,25727,25738,25749,25760,25772,25785,25798,25811,25822,25833,25844,25855,25868,25881,25894,25907,25918,25929,25940,26429,26443,26457,26471,26485,26497,26509,26521,26530,26536,26542,26548,26861,26875,26889,26903,26917,26929,26941,26953,26963,26969,26975,26980,26989,27003,27018,27032,27046,27058,27070,27082,27091,27097,27103,27109,27271,27285,27299,27313,27325,27337,27349,27677,27692,27706,27720,27734,27746,27758,27770) AND `prints_vector`.`bundle` = 0
SELECT COUNT(*) cnt FROM `prints_set_vector` INNER JOIN `prints_vector` ON `prints_vector`.`id` = `prints_set_vector`.`vector_id` WHERE `prints_set_vector`.`set_id` = 18686 AND `prints_set_vector`.`vector_id` IN(28565,28569,28845,15733,15734,15741,15742,15743,15744,17787,17791,17792,17793,17796,17797,21544,21557,21558,21574,21575,21576,21577,21578,21579,21580,21581,21582,21583,21584,21585,21616,21623,21624,21628,21635,21636,22175,22176,22177,22217,22218,22219,22259,22260,22261,22301,22302,22303,22343,22344,22345,22385,22386,22387,22427,22428,22429,22469,22470,22471,22511,22512,22513,22553,22554,22555,22595,22596,22597,22637,22638,22639,22679,22680,22681,22721,22722,22723,22763,22764,22765,22805,22806,22807,22847,22848,22849,22889,22890,22891,22931,22932,22933,22965,22966,22967,22992,22993,22994,23025,23026,23027,23038,23051,23064,23077,23090,23103,23114,23121,23128,23135,23142,23149,23158,23172,23187,23200,23213,23226,23237,23244,23253,23267,23280,23293,23306,23319,23330,23337,23344,23351,23358,23365,23374,23387,23400,23413,23427,23439,23450,23457,23464,23471,23478,23485,23494,23507,23520,23533,23546,23559,23570,23577,23584,23591,23598,23605,23614,23627,23640,23653,23665,23678,23689,23696,23703,23710,23717,23724,23734,23747,23760,23773,23786,23799,23810,23817,23824,23831,23838,23845,23854,23867,23880,23893,23906,23919,23930,23937,23945,23952,23959,23966,23975,23988,24008,24020,24032,24045,24098,24110,24122,24134,24147,24160,24221,24232,24251,24263,24283,24295,24342,24353,24373,24384,24402,24420,24466,24478,24498,24510,24530,24542,24589,24601,24622,24634,24654,24666,24719,24731,24743,24762,24782,24794,24840,24853,24866,24880,24892,24904,24916,24928,24929,24949,24961,24981,24993,25040,25052,25072,25084,25104,25116,25161,25175,25186,25199,25210,25225,25238,25249,25260,25270,25281,25294,25307,25320,25332,25343,25354,25365,25376,25389,25402,25415,25428,25439,25449,25460,25471,25484,25497,25510,25523,25534,25545,25556,25567,25580,25593,25606,25619,25631,25642,25653,25664,25677,25690,25703,25705,25716,25727,25738,25749,25760,25772,25785,25798,25811,25822,25833,25844,25855,25868,25881,25894,25907,25918,25929,25940,26429,26443,26457,26471,26485,26497,26509,26521,26530,26536,26542,26548,26861,26875,26889,26903,26917,26929,26941,26953,26963,26969,26975,26980,26989,27003,27018,27032,27046,27058,27070,27082,27091,27097,27103,27109,27271,27285,27299,27313,27325,27337,27349,27677,27692,27706,27720,27734,27746,27758,27770) AND `prints_vector`.`bundle` = 0
SELECT COUNT(*) cnt FROM `prints_set_vector` INNER JOIN `prints_vector` ON `prints_vector`.`id` = `prints_set_vector`.`vector_id` WHERE `prints_set_vector`.`set_id` = 24966 AND `prints_set_vector`.`vector_id` IN(28565,28569,28845,15733,15734,15741,15742,15743,15744,17787,17791,17792,17793,17796,17797,21544,21557,21558,21574,21575,21576,21577,21578,21579,21580,21581,21582,21583,21584,21585,21616,21623,21624,21628,21635,21636,22175,22176,22177,22217,22218,22219,22259,22260,22261,22301,22302,22303,22343,22344,22345,22385,22386,22387,22427,22428,22429,22469,22470,22471,22511,22512,22513,22553,22554,22555,22595,22596,22597,22637,22638,22639,22679,22680,22681,22721,22722,22723,22763,22764,22765,22805,22806,22807,22847,22848,22849,22889,22890,22891,22931,22932,22933,22965,22966,22967,22992,22993,22994,23025,23026,23027,23038,23051,23064,23077,23090,23103,23114,23121,23128,23135,23142,23149,23158,23172,23187,23200,23213,23226,23237,23244,23253,23267,23280,23293,23306,23319,23330,23337,23344,23351,23358,23365,23374,23387,23400,23413,23427,23439,23450,23457,23464,23471,23478,23485,23494,23507,23520,23533,23546,23559,23570,23577,23584,23591,23598,23605,23614,23627,23640,23653,23665,23678,23689,23696,23703,23710,23717,23724,23734,23747,23760,23773,23786,23799,23810,23817,23824,23831,23838,23845,23854,23867,23880,23893,23906,23919,23930,23937,23945,23952,23959,23966,23975,23988,24008,24020,24032,24045,24098,24110,24122,24134,24147,24160,24221,24232,24251,24263,24283,24295,24342,24353,24373,24384,24402,24420,24466,24478,24498,24510,24530,24542,24589,24601,24622,24634,24654,24666,24719,24731,24743,24762,24782,24794,24840,24853,24866,24880,24892,24904,24916,24928,24929,24949,24961,24981,24993,25040,25052,25072,25084,25104,25116,25161,25175,25186,25199,25210,25225,25238,25249,25260,25270,25281,25294,25307,25320,25332,25343,25354,25365,25376,25389,25402,25415,25428,25439,25449,25460,25471,25484,25497,25510,25523,25534,25545,25556,25567,25580,25593,25606,25619,25631,25642,25653,25664,25677,25690,25703,25705,25716,25727,25738,25749,25760,25772,25785,25798,25811,25822,25833,25844,25855,25868,25881,25894,25907,25918,25929,25940,26429,26443,26457,26471,26485,26497,26509,26521,26530,26536,26542,26548,26861,26875,26889,26903,26917,26929,26941,26953,26963,26969,26975,26980,26989,27003,27018,27032,27046,27058,27070,27082,27091,27097,27103,27109,27271,27285,27299,27313,27325,27337,27349,27677,27692,27706,27720,27734,27746,27758,27770) AND `prints_vector`.`bundle` = 0
SELECT `prints_vector`.* FROM `prints_vector` LEFT JOIN `prints_set_vector` ON `prints_vector`.`id` = `prints_set_vector`.`vector_id` WHERE `id` IN(28565,28569,28845,15733,15734,15741,15742,15743,15744,17787,17791,17792,17793,17796,17797,21544,21557,21558,21574,21575,21576,21577,21578,21579,21580,21581,21582,21583,21584,21585,21616,21623,21624,21628,21635,21636,22175,22176,22177,22217,22218,22219,22259,22260,22261,22301,22302,22303,22343,22344,22345,22385,22386,22387,22427,22428,22429,22469,22470,22471,22511,22512,22513,22553,22554,22555,22595,22596,22597,22637,22638,22639,22679,22680,22681,22721,22722,22723,22763,22764,22765,22805,22806,22807,22847,22848,22849,22889,22890,22891,22931,22932,22933,22965,22966,22967,22992,22993,22994,23025,23026,23027,23038,23051,23064,23077,23090,23103,23114,23121,23128,23135,23142,23149,23158,23172,23187,23200,23213,23226,23237,23244,23253,23267,23280,23293,23306,23319,23330,23337,23344,23351,23358,23365,23374,23387,23400,23413,23427,23439,23450,23457,23464,23471,23478,23485,23494,23507,23520,23533,23546,23559,23570,23577,23584,23591,23598,23605,23614,23627,23640,23653,23665,23678,23689,23696,23703,23710,23717,23724,23734,23747,23760,23773,23786,23799,23810,23817,23824,23831,23838,23845,23854,23867,23880,23893,23906,23919,23930,23937,23945,23952,23959,23966,23975,23988,24008,24020,24032,24045,24098,24110,24122,24134,24147,24160,24221,24232,24251,24263,24283,24295,24342,24353,24373,24384,24402,24420,24466,24478,24498,24510,24530,24542,24589,24601,24622,24634,24654,24666,24719,24731,24743,24762,24782,24794,24840,24853,24866,24880,24892,24904,24916,24928,24929,24949,24961,24981,24993,25040,25052,25072,25084,25104,25116,25161,25175,25186,25199,25210,25225,25238,25249,25260,25270,25281,25294,25307,25320,25332,25343,25354,25365,25376,25389,25402,25415,25428,25439,25449,25460,25471,25484,25497,25510,25523,25534,25545,25556,25567,25580,25593,25606,25619,25631,25642,25653,25664,25677,25690,25703,25705,25716,25727,25738,25749,25760,25772,25785,25798,25811,25822,25833,25844,25855,25868,25881,25894,25907,25918,25929,25940,26429,26443,26457,26471,26485,26497,26509,26521,26530,26536,26542,26548,26861,26875,26889,26903,26917,26929,26941,26953,26963,26969,26975,26980,26989,27003,27018,27032,27046,27058,27070,27082,27091,27097,27103,27109,27271,27285,27299,27313,27325,27337,27349,27677,27692,27706,27720,27734,27746,27758,27770) 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 21
?q=5000&page=###page###
398
SELECT `id`, `name`, `type` FROM nox_group