/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(1067,1068,1069,1073,1074,1075,1786,1787,1788,4018,4058,5376,5378,5379,5408,5409,5410,5411,5412,5413,5414,5415,5416,5417,5418,5419,5458,5459,5460,5461,5463,5464,5465,5466,5467,5468,5469,5470,5471,5472,5473,5474,5475,5476,5477,5478,5479,5480,5481,5485,5486,9033,10062,10063,10064,10065,10066,10067,10097,10098,10099,10100,10101,10102,12035,12038,12039,12040,12041,12042,12043,12044,12045,12046,12047,12048,12049,12050,12056,12057,12058,13382,13383,13384,13385,13386,13387,13388,13389,13940,13941,13967,15571,15572,15573,15574,15575,15576,15577,15578,15579,15580,15581,15582,15583,15584,15585,15586,15587,15588,15589,15590,15591,15592,15593,15594,15595,15596,15597,15598,15599,15600,15601,15602,15603,15604,15605,15606,15842,15863,15864,15865,15866,15867,15868,15869,15870,15871,15872))
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(1067,1068,1069,1073,1074,1075,1786,1787,1788,4018,4058,5376,5378,5379,5408,5409,5410,5411,5412,5413,5414,5415,5416,5417,5418,5419,5458,5459,5460,5461,5463,5464,5465,5466,5467,5468,5469,5470,5471,5472,5473,5474,5475,5476,5477,5478,5479,5480,5481,5485,5486,9033,10062,10063,10064,10065,10066,10067,10097,10098,10099,10100,10101,10102,12035,12038,12039,12040,12041,12042,12043,12044,12045,12046,12047,12048,12049,12050,12056,12057,12058,13382,13383,13384,13385,13386,13387,13388,13389,13940,13941,13967,15571,15572,15573,15574,15575,15576,15577,15578,15579,15580,15581,15582,15583,15584,15585,15586,15587,15588,15589,15590,15591,15592,15593,15594,15595,15596,15597,15598,15599,15600,15601,15602,15603,15604,15605,15606,15842,15863,15864,15865,15866,15867,15868,15869,15870,15871,15872)) 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(13725, 13718, 14403, 36045, 6185, 6210, 6215, 6251, 6253, 29609, 9273, 10257, 12157, 12141, 14385, 16373, 16375, 16380, 16397, 16390, 16392, 16394, 16640, 16643, 16644, 16645) 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` = 16375 AND `prints_set_vector`.`vector_id` IN(1067,1068,1069,1073,1074,1075,1786,1787,1788,4018,4058,5376,5378,5379,5408,5409,5410,5411,5412,5413,5414,5415,5416,5417,5418,5419,5458,5459,5460,5461,5463,5464,5465,5466,5467,5468,5469,5470,5471,5472,5473,5474,5475,5476,5477,5478,5479,5480,5481,5485,5486,9033,10062,10063,10064,10065,10066,10067,10097,10098,10099,10100,10101,10102,12035,12038,12039,12040,12041,12042,12043,12044,12045,12046,12047,12048,12049,12050,12056,12057,12058,13382,13383,13384,13385,13386,13387,13388,13389,13940,13941,13967,15571,15572,15573,15574,15575,15576,15577,15578,15579,15580,15581,15582,15583,15584,15585,15586,15587,15588,15589,15590,15591,15592,15593,15594,15595,15596,15597,15598,15599,15600,15601,15602,15603,15604,15605,15606,15842,15863,15864,15865,15866,15867,15868,15869,15870,15871,15872) 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` = 16644 AND `prints_set_vector`.`vector_id` IN(1067,1068,1069,1073,1074,1075,1786,1787,1788,4018,4058,5376,5378,5379,5408,5409,5410,5411,5412,5413,5414,5415,5416,5417,5418,5419,5458,5459,5460,5461,5463,5464,5465,5466,5467,5468,5469,5470,5471,5472,5473,5474,5475,5476,5477,5478,5479,5480,5481,5485,5486,9033,10062,10063,10064,10065,10066,10067,10097,10098,10099,10100,10101,10102,12035,12038,12039,12040,12041,12042,12043,12044,12045,12046,12047,12048,12049,12050,12056,12057,12058,13382,13383,13384,13385,13386,13387,13388,13389,13940,13941,13967,15571,15572,15573,15574,15575,15576,15577,15578,15579,15580,15581,15582,15583,15584,15585,15586,15587,15588,15589,15590,15591,15592,15593,15594,15595,15596,15597,15598,15599,15600,15601,15602,15603,15604,15605,15606,15842,15863,15864,15865,15866,15867,15868,15869,15870,15871,15872) 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` = 16392 AND `prints_set_vector`.`vector_id` IN(1067,1068,1069,1073,1074,1075,1786,1787,1788,4018,4058,5376,5378,5379,5408,5409,5410,5411,5412,5413,5414,5415,5416,5417,5418,5419,5458,5459,5460,5461,5463,5464,5465,5466,5467,5468,5469,5470,5471,5472,5473,5474,5475,5476,5477,5478,5479,5480,5481,5485,5486,9033,10062,10063,10064,10065,10066,10067,10097,10098,10099,10100,10101,10102,12035,12038,12039,12040,12041,12042,12043,12044,12045,12046,12047,12048,12049,12050,12056,12057,12058,13382,13383,13384,13385,13386,13387,13388,13389,13940,13941,13967,15571,15572,15573,15574,15575,15576,15577,15578,15579,15580,15581,15582,15583,15584,15585,15586,15587,15588,15589,15590,15591,15592,15593,15594,15595,15596,15597,15598,15599,15600,15601,15602,15603,15604,15605,15606,15842,15863,15864,15865,15866,15867,15868,15869,15870,15871,15872) 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` = 36045 AND `prints_set_vector`.`vector_id` IN(1067,1068,1069,1073,1074,1075,1786,1787,1788,4018,4058,5376,5378,5379,5408,5409,5410,5411,5412,5413,5414,5415,5416,5417,5418,5419,5458,5459,5460,5461,5463,5464,5465,5466,5467,5468,5469,5470,5471,5472,5473,5474,5475,5476,5477,5478,5479,5480,5481,5485,5486,9033,10062,10063,10064,10065,10066,10067,10097,10098,10099,10100,10101,10102,12035,12038,12039,12040,12041,12042,12043,12044,12045,12046,12047,12048,12049,12050,12056,12057,12058,13382,13383,13384,13385,13386,13387,13388,13389,13940,13941,13967,15571,15572,15573,15574,15575,15576,15577,15578,15579,15580,15581,15582,15583,15584,15585,15586,15587,15588,15589,15590,15591,15592,15593,15594,15595,15596,15597,15598,15599,15600,15601,15602,15603,15604,15605,15606,15842,15863,15864,15865,15866,15867,15868,15869,15870,15871,15872) 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` = 16380 AND `prints_set_vector`.`vector_id` IN(1067,1068,1069,1073,1074,1075,1786,1787,1788,4018,4058,5376,5378,5379,5408,5409,5410,5411,5412,5413,5414,5415,5416,5417,5418,5419,5458,5459,5460,5461,5463,5464,5465,5466,5467,5468,5469,5470,5471,5472,5473,5474,5475,5476,5477,5478,5479,5480,5481,5485,5486,9033,10062,10063,10064,10065,10066,10067,10097,10098,10099,10100,10101,10102,12035,12038,12039,12040,12041,12042,12043,12044,12045,12046,12047,12048,12049,12050,12056,12057,12058,13382,13383,13384,13385,13386,13387,13388,13389,13940,13941,13967,15571,15572,15573,15574,15575,15576,15577,15578,15579,15580,15581,15582,15583,15584,15585,15586,15587,15588,15589,15590,15591,15592,15593,15594,15595,15596,15597,15598,15599,15600,15601,15602,15603,15604,15605,15606,15842,15863,15864,15865,15866,15867,15868,15869,15870,15871,15872) 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` = 13718 AND `prints_set_vector`.`vector_id` IN(1067,1068,1069,1073,1074,1075,1786,1787,1788,4018,4058,5376,5378,5379,5408,5409,5410,5411,5412,5413,5414,5415,5416,5417,5418,5419,5458,5459,5460,5461,5463,5464,5465,5466,5467,5468,5469,5470,5471,5472,5473,5474,5475,5476,5477,5478,5479,5480,5481,5485,5486,9033,10062,10063,10064,10065,10066,10067,10097,10098,10099,10100,10101,10102,12035,12038,12039,12040,12041,12042,12043,12044,12045,12046,12047,12048,12049,12050,12056,12057,12058,13382,13383,13384,13385,13386,13387,13388,13389,13940,13941,13967,15571,15572,15573,15574,15575,15576,15577,15578,15579,15580,15581,15582,15583,15584,15585,15586,15587,15588,15589,15590,15591,15592,15593,15594,15595,15596,15597,15598,15599,15600,15601,15602,15603,15604,15605,15606,15842,15863,15864,15865,15866,15867,15868,15869,15870,15871,15872) 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` = 16394 AND `prints_set_vector`.`vector_id` IN(1067,1068,1069,1073,1074,1075,1786,1787,1788,4018,4058,5376,5378,5379,5408,5409,5410,5411,5412,5413,5414,5415,5416,5417,5418,5419,5458,5459,5460,5461,5463,5464,5465,5466,5467,5468,5469,5470,5471,5472,5473,5474,5475,5476,5477,5478,5479,5480,5481,5485,5486,9033,10062,10063,10064,10065,10066,10067,10097,10098,10099,10100,10101,10102,12035,12038,12039,12040,12041,12042,12043,12044,12045,12046,12047,12048,12049,12050,12056,12057,12058,13382,13383,13384,13385,13386,13387,13388,13389,13940,13941,13967,15571,15572,15573,15574,15575,15576,15577,15578,15579,15580,15581,15582,15583,15584,15585,15586,15587,15588,15589,15590,15591,15592,15593,15594,15595,15596,15597,15598,15599,15600,15601,15602,15603,15604,15605,15606,15842,15863,15864,15865,15866,15867,15868,15869,15870,15871,15872) 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` = 13725 AND `prints_set_vector`.`vector_id` IN(1067,1068,1069,1073,1074,1075,1786,1787,1788,4018,4058,5376,5378,5379,5408,5409,5410,5411,5412,5413,5414,5415,5416,5417,5418,5419,5458,5459,5460,5461,5463,5464,5465,5466,5467,5468,5469,5470,5471,5472,5473,5474,5475,5476,5477,5478,5479,5480,5481,5485,5486,9033,10062,10063,10064,10065,10066,10067,10097,10098,10099,10100,10101,10102,12035,12038,12039,12040,12041,12042,12043,12044,12045,12046,12047,12048,12049,12050,12056,12057,12058,13382,13383,13384,13385,13386,13387,13388,13389,13940,13941,13967,15571,15572,15573,15574,15575,15576,15577,15578,15579,15580,15581,15582,15583,15584,15585,15586,15587,15588,15589,15590,15591,15592,15593,15594,15595,15596,15597,15598,15599,15600,15601,15602,15603,15604,15605,15606,15842,15863,15864,15865,15866,15867,15868,15869,15870,15871,15872) 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` = 16640 AND `prints_set_vector`.`vector_id` IN(1067,1068,1069,1073,1074,1075,1786,1787,1788,4018,4058,5376,5378,5379,5408,5409,5410,5411,5412,5413,5414,5415,5416,5417,5418,5419,5458,5459,5460,5461,5463,5464,5465,5466,5467,5468,5469,5470,5471,5472,5473,5474,5475,5476,5477,5478,5479,5480,5481,5485,5486,9033,10062,10063,10064,10065,10066,10067,10097,10098,10099,10100,10101,10102,12035,12038,12039,12040,12041,12042,12043,12044,12045,12046,12047,12048,12049,12050,12056,12057,12058,13382,13383,13384,13385,13386,13387,13388,13389,13940,13941,13967,15571,15572,15573,15574,15575,15576,15577,15578,15579,15580,15581,15582,15583,15584,15585,15586,15587,15588,15589,15590,15591,15592,15593,15594,15595,15596,15597,15598,15599,15600,15601,15602,15603,15604,15605,15606,15842,15863,15864,15865,15866,15867,15868,15869,15870,15871,15872) 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` = 6215 AND `prints_set_vector`.`vector_id` IN(1067,1068,1069,1073,1074,1075,1786,1787,1788,4018,4058,5376,5378,5379,5408,5409,5410,5411,5412,5413,5414,5415,5416,5417,5418,5419,5458,5459,5460,5461,5463,5464,5465,5466,5467,5468,5469,5470,5471,5472,5473,5474,5475,5476,5477,5478,5479,5480,5481,5485,5486,9033,10062,10063,10064,10065,10066,10067,10097,10098,10099,10100,10101,10102,12035,12038,12039,12040,12041,12042,12043,12044,12045,12046,12047,12048,12049,12050,12056,12057,12058,13382,13383,13384,13385,13386,13387,13388,13389,13940,13941,13967,15571,15572,15573,15574,15575,15576,15577,15578,15579,15580,15581,15582,15583,15584,15585,15586,15587,15588,15589,15590,15591,15592,15593,15594,15595,15596,15597,15598,15599,15600,15601,15602,15603,15604,15605,15606,15842,15863,15864,15865,15866,15867,15868,15869,15870,15871,15872) 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` = 6251 AND `prints_set_vector`.`vector_id` IN(1067,1068,1069,1073,1074,1075,1786,1787,1788,4018,4058,5376,5378,5379,5408,5409,5410,5411,5412,5413,5414,5415,5416,5417,5418,5419,5458,5459,5460,5461,5463,5464,5465,5466,5467,5468,5469,5470,5471,5472,5473,5474,5475,5476,5477,5478,5479,5480,5481,5485,5486,9033,10062,10063,10064,10065,10066,10067,10097,10098,10099,10100,10101,10102,12035,12038,12039,12040,12041,12042,12043,12044,12045,12046,12047,12048,12049,12050,12056,12057,12058,13382,13383,13384,13385,13386,13387,13388,13389,13940,13941,13967,15571,15572,15573,15574,15575,15576,15577,15578,15579,15580,15581,15582,15583,15584,15585,15586,15587,15588,15589,15590,15591,15592,15593,15594,15595,15596,15597,15598,15599,15600,15601,15602,15603,15604,15605,15606,15842,15863,15864,15865,15866,15867,15868,15869,15870,15871,15872) 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` = 16373 AND `prints_set_vector`.`vector_id` IN(1067,1068,1069,1073,1074,1075,1786,1787,1788,4018,4058,5376,5378,5379,5408,5409,5410,5411,5412,5413,5414,5415,5416,5417,5418,5419,5458,5459,5460,5461,5463,5464,5465,5466,5467,5468,5469,5470,5471,5472,5473,5474,5475,5476,5477,5478,5479,5480,5481,5485,5486,9033,10062,10063,10064,10065,10066,10067,10097,10098,10099,10100,10101,10102,12035,12038,12039,12040,12041,12042,12043,12044,12045,12046,12047,12048,12049,12050,12056,12057,12058,13382,13383,13384,13385,13386,13387,13388,13389,13940,13941,13967,15571,15572,15573,15574,15575,15576,15577,15578,15579,15580,15581,15582,15583,15584,15585,15586,15587,15588,15589,15590,15591,15592,15593,15594,15595,15596,15597,15598,15599,15600,15601,15602,15603,15604,15605,15606,15842,15863,15864,15865,15866,15867,15868,15869,15870,15871,15872) 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` = 14385 AND `prints_set_vector`.`vector_id` IN(1067,1068,1069,1073,1074,1075,1786,1787,1788,4018,4058,5376,5378,5379,5408,5409,5410,5411,5412,5413,5414,5415,5416,5417,5418,5419,5458,5459,5460,5461,5463,5464,5465,5466,5467,5468,5469,5470,5471,5472,5473,5474,5475,5476,5477,5478,5479,5480,5481,5485,5486,9033,10062,10063,10064,10065,10066,10067,10097,10098,10099,10100,10101,10102,12035,12038,12039,12040,12041,12042,12043,12044,12045,12046,12047,12048,12049,12050,12056,12057,12058,13382,13383,13384,13385,13386,13387,13388,13389,13940,13941,13967,15571,15572,15573,15574,15575,15576,15577,15578,15579,15580,15581,15582,15583,15584,15585,15586,15587,15588,15589,15590,15591,15592,15593,15594,15595,15596,15597,15598,15599,15600,15601,15602,15603,15604,15605,15606,15842,15863,15864,15865,15866,15867,15868,15869,15870,15871,15872) 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` = 14403 AND `prints_set_vector`.`vector_id` IN(1067,1068,1069,1073,1074,1075,1786,1787,1788,4018,4058,5376,5378,5379,5408,5409,5410,5411,5412,5413,5414,5415,5416,5417,5418,5419,5458,5459,5460,5461,5463,5464,5465,5466,5467,5468,5469,5470,5471,5472,5473,5474,5475,5476,5477,5478,5479,5480,5481,5485,5486,9033,10062,10063,10064,10065,10066,10067,10097,10098,10099,10100,10101,10102,12035,12038,12039,12040,12041,12042,12043,12044,12045,12046,12047,12048,12049,12050,12056,12057,12058,13382,13383,13384,13385,13386,13387,13388,13389,13940,13941,13967,15571,15572,15573,15574,15575,15576,15577,15578,15579,15580,15581,15582,15583,15584,15585,15586,15587,15588,15589,15590,15591,15592,15593,15594,15595,15596,15597,15598,15599,15600,15601,15602,15603,15604,15605,15606,15842,15863,15864,15865,15866,15867,15868,15869,15870,15871,15872) 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` = 29609 AND `prints_set_vector`.`vector_id` IN(1067,1068,1069,1073,1074,1075,1786,1787,1788,4018,4058,5376,5378,5379,5408,5409,5410,5411,5412,5413,5414,5415,5416,5417,5418,5419,5458,5459,5460,5461,5463,5464,5465,5466,5467,5468,5469,5470,5471,5472,5473,5474,5475,5476,5477,5478,5479,5480,5481,5485,5486,9033,10062,10063,10064,10065,10066,10067,10097,10098,10099,10100,10101,10102,12035,12038,12039,12040,12041,12042,12043,12044,12045,12046,12047,12048,12049,12050,12056,12057,12058,13382,13383,13384,13385,13386,13387,13388,13389,13940,13941,13967,15571,15572,15573,15574,15575,15576,15577,15578,15579,15580,15581,15582,15583,15584,15585,15586,15587,15588,15589,15590,15591,15592,15593,15594,15595,15596,15597,15598,15599,15600,15601,15602,15603,15604,15605,15606,15842,15863,15864,15865,15866,15867,15868,15869,15870,15871,15872) 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` = 6210 AND `prints_set_vector`.`vector_id` IN(1067,1068,1069,1073,1074,1075,1786,1787,1788,4018,4058,5376,5378,5379,5408,5409,5410,5411,5412,5413,5414,5415,5416,5417,5418,5419,5458,5459,5460,5461,5463,5464,5465,5466,5467,5468,5469,5470,5471,5472,5473,5474,5475,5476,5477,5478,5479,5480,5481,5485,5486,9033,10062,10063,10064,10065,10066,10067,10097,10098,10099,10100,10101,10102,12035,12038,12039,12040,12041,12042,12043,12044,12045,12046,12047,12048,12049,12050,12056,12057,12058,13382,13383,13384,13385,13386,13387,13388,13389,13940,13941,13967,15571,15572,15573,15574,15575,15576,15577,15578,15579,15580,15581,15582,15583,15584,15585,15586,15587,15588,15589,15590,15591,15592,15593,15594,15595,15596,15597,15598,15599,15600,15601,15602,15603,15604,15605,15606,15842,15863,15864,15865,15866,15867,15868,15869,15870,15871,15872) 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` = 16390 AND `prints_set_vector`.`vector_id` IN(1067,1068,1069,1073,1074,1075,1786,1787,1788,4018,4058,5376,5378,5379,5408,5409,5410,5411,5412,5413,5414,5415,5416,5417,5418,5419,5458,5459,5460,5461,5463,5464,5465,5466,5467,5468,5469,5470,5471,5472,5473,5474,5475,5476,5477,5478,5479,5480,5481,5485,5486,9033,10062,10063,10064,10065,10066,10067,10097,10098,10099,10100,10101,10102,12035,12038,12039,12040,12041,12042,12043,12044,12045,12046,12047,12048,12049,12050,12056,12057,12058,13382,13383,13384,13385,13386,13387,13388,13389,13940,13941,13967,15571,15572,15573,15574,15575,15576,15577,15578,15579,15580,15581,15582,15583,15584,15585,15586,15587,15588,15589,15590,15591,15592,15593,15594,15595,15596,15597,15598,15599,15600,15601,15602,15603,15604,15605,15606,15842,15863,15864,15865,15866,15867,15868,15869,15870,15871,15872) 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` = 16643 AND `prints_set_vector`.`vector_id` IN(1067,1068,1069,1073,1074,1075,1786,1787,1788,4018,4058,5376,5378,5379,5408,5409,5410,5411,5412,5413,5414,5415,5416,5417,5418,5419,5458,5459,5460,5461,5463,5464,5465,5466,5467,5468,5469,5470,5471,5472,5473,5474,5475,5476,5477,5478,5479,5480,5481,5485,5486,9033,10062,10063,10064,10065,10066,10067,10097,10098,10099,10100,10101,10102,12035,12038,12039,12040,12041,12042,12043,12044,12045,12046,12047,12048,12049,12050,12056,12057,12058,13382,13383,13384,13385,13386,13387,13388,13389,13940,13941,13967,15571,15572,15573,15574,15575,15576,15577,15578,15579,15580,15581,15582,15583,15584,15585,15586,15587,15588,15589,15590,15591,15592,15593,15594,15595,15596,15597,15598,15599,15600,15601,15602,15603,15604,15605,15606,15842,15863,15864,15865,15866,15867,15868,15869,15870,15871,15872) 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` = 16397 AND `prints_set_vector`.`vector_id` IN(1067,1068,1069,1073,1074,1075,1786,1787,1788,4018,4058,5376,5378,5379,5408,5409,5410,5411,5412,5413,5414,5415,5416,5417,5418,5419,5458,5459,5460,5461,5463,5464,5465,5466,5467,5468,5469,5470,5471,5472,5473,5474,5475,5476,5477,5478,5479,5480,5481,5485,5486,9033,10062,10063,10064,10065,10066,10067,10097,10098,10099,10100,10101,10102,12035,12038,12039,12040,12041,12042,12043,12044,12045,12046,12047,12048,12049,12050,12056,12057,12058,13382,13383,13384,13385,13386,13387,13388,13389,13940,13941,13967,15571,15572,15573,15574,15575,15576,15577,15578,15579,15580,15581,15582,15583,15584,15585,15586,15587,15588,15589,15590,15591,15592,15593,15594,15595,15596,15597,15598,15599,15600,15601,15602,15603,15604,15605,15606,15842,15863,15864,15865,15866,15867,15868,15869,15870,15871,15872) 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` = 6253 AND `prints_set_vector`.`vector_id` IN(1067,1068,1069,1073,1074,1075,1786,1787,1788,4018,4058,5376,5378,5379,5408,5409,5410,5411,5412,5413,5414,5415,5416,5417,5418,5419,5458,5459,5460,5461,5463,5464,5465,5466,5467,5468,5469,5470,5471,5472,5473,5474,5475,5476,5477,5478,5479,5480,5481,5485,5486,9033,10062,10063,10064,10065,10066,10067,10097,10098,10099,10100,10101,10102,12035,12038,12039,12040,12041,12042,12043,12044,12045,12046,12047,12048,12049,12050,12056,12057,12058,13382,13383,13384,13385,13386,13387,13388,13389,13940,13941,13967,15571,15572,15573,15574,15575,15576,15577,15578,15579,15580,15581,15582,15583,15584,15585,15586,15587,15588,15589,15590,15591,15592,15593,15594,15595,15596,15597,15598,15599,15600,15601,15602,15603,15604,15605,15606,15842,15863,15864,15865,15866,15867,15868,15869,15870,15871,15872) 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` = 12141 AND `prints_set_vector`.`vector_id` IN(1067,1068,1069,1073,1074,1075,1786,1787,1788,4018,4058,5376,5378,5379,5408,5409,5410,5411,5412,5413,5414,5415,5416,5417,5418,5419,5458,5459,5460,5461,5463,5464,5465,5466,5467,5468,5469,5470,5471,5472,5473,5474,5475,5476,5477,5478,5479,5480,5481,5485,5486,9033,10062,10063,10064,10065,10066,10067,10097,10098,10099,10100,10101,10102,12035,12038,12039,12040,12041,12042,12043,12044,12045,12046,12047,12048,12049,12050,12056,12057,12058,13382,13383,13384,13385,13386,13387,13388,13389,13940,13941,13967,15571,15572,15573,15574,15575,15576,15577,15578,15579,15580,15581,15582,15583,15584,15585,15586,15587,15588,15589,15590,15591,15592,15593,15594,15595,15596,15597,15598,15599,15600,15601,15602,15603,15604,15605,15606,15842,15863,15864,15865,15866,15867,15868,15869,15870,15871,15872) 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` = 16645 AND `prints_set_vector`.`vector_id` IN(1067,1068,1069,1073,1074,1075,1786,1787,1788,4018,4058,5376,5378,5379,5408,5409,5410,5411,5412,5413,5414,5415,5416,5417,5418,5419,5458,5459,5460,5461,5463,5464,5465,5466,5467,5468,5469,5470,5471,5472,5473,5474,5475,5476,5477,5478,5479,5480,5481,5485,5486,9033,10062,10063,10064,10065,10066,10067,10097,10098,10099,10100,10101,10102,12035,12038,12039,12040,12041,12042,12043,12044,12045,12046,12047,12048,12049,12050,12056,12057,12058,13382,13383,13384,13385,13386,13387,13388,13389,13940,13941,13967,15571,15572,15573,15574,15575,15576,15577,15578,15579,15580,15581,15582,15583,15584,15585,15586,15587,15588,15589,15590,15591,15592,15593,15594,15595,15596,15597,15598,15599,15600,15601,15602,15603,15604,15605,15606,15842,15863,15864,15865,15866,15867,15868,15869,15870,15871,15872) 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` = 6185 AND `prints_set_vector`.`vector_id` IN(1067,1068,1069,1073,1074,1075,1786,1787,1788,4018,4058,5376,5378,5379,5408,5409,5410,5411,5412,5413,5414,5415,5416,5417,5418,5419,5458,5459,5460,5461,5463,5464,5465,5466,5467,5468,5469,5470,5471,5472,5473,5474,5475,5476,5477,5478,5479,5480,5481,5485,5486,9033,10062,10063,10064,10065,10066,10067,10097,10098,10099,10100,10101,10102,12035,12038,12039,12040,12041,12042,12043,12044,12045,12046,12047,12048,12049,12050,12056,12057,12058,13382,13383,13384,13385,13386,13387,13388,13389,13940,13941,13967,15571,15572,15573,15574,15575,15576,15577,15578,15579,15580,15581,15582,15583,15584,15585,15586,15587,15588,15589,15590,15591,15592,15593,15594,15595,15596,15597,15598,15599,15600,15601,15602,15603,15604,15605,15606,15842,15863,15864,15865,15866,15867,15868,15869,15870,15871,15872) 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` = 12157 AND `prints_set_vector`.`vector_id` IN(1067,1068,1069,1073,1074,1075,1786,1787,1788,4018,4058,5376,5378,5379,5408,5409,5410,5411,5412,5413,5414,5415,5416,5417,5418,5419,5458,5459,5460,5461,5463,5464,5465,5466,5467,5468,5469,5470,5471,5472,5473,5474,5475,5476,5477,5478,5479,5480,5481,5485,5486,9033,10062,10063,10064,10065,10066,10067,10097,10098,10099,10100,10101,10102,12035,12038,12039,12040,12041,12042,12043,12044,12045,12046,12047,12048,12049,12050,12056,12057,12058,13382,13383,13384,13385,13386,13387,13388,13389,13940,13941,13967,15571,15572,15573,15574,15575,15576,15577,15578,15579,15580,15581,15582,15583,15584,15585,15586,15587,15588,15589,15590,15591,15592,15593,15594,15595,15596,15597,15598,15599,15600,15601,15602,15603,15604,15605,15606,15842,15863,15864,15865,15866,15867,15868,15869,15870,15871,15872) 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` = 10257 AND `prints_set_vector`.`vector_id` IN(1067,1068,1069,1073,1074,1075,1786,1787,1788,4018,4058,5376,5378,5379,5408,5409,5410,5411,5412,5413,5414,5415,5416,5417,5418,5419,5458,5459,5460,5461,5463,5464,5465,5466,5467,5468,5469,5470,5471,5472,5473,5474,5475,5476,5477,5478,5479,5480,5481,5485,5486,9033,10062,10063,10064,10065,10066,10067,10097,10098,10099,10100,10101,10102,12035,12038,12039,12040,12041,12042,12043,12044,12045,12046,12047,12048,12049,12050,12056,12057,12058,13382,13383,13384,13385,13386,13387,13388,13389,13940,13941,13967,15571,15572,15573,15574,15575,15576,15577,15578,15579,15580,15581,15582,15583,15584,15585,15586,15587,15588,15589,15590,15591,15592,15593,15594,15595,15596,15597,15598,15599,15600,15601,15602,15603,15604,15605,15606,15842,15863,15864,15865,15866,15867,15868,15869,15870,15871,15872) 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` = 9273 AND `prints_set_vector`.`vector_id` IN(1067,1068,1069,1073,1074,1075,1786,1787,1788,4018,4058,5376,5378,5379,5408,5409,5410,5411,5412,5413,5414,5415,5416,5417,5418,5419,5458,5459,5460,5461,5463,5464,5465,5466,5467,5468,5469,5470,5471,5472,5473,5474,5475,5476,5477,5478,5479,5480,5481,5485,5486,9033,10062,10063,10064,10065,10066,10067,10097,10098,10099,10100,10101,10102,12035,12038,12039,12040,12041,12042,12043,12044,12045,12046,12047,12048,12049,12050,12056,12057,12058,13382,13383,13384,13385,13386,13387,13388,13389,13940,13941,13967,15571,15572,15573,15574,15575,15576,15577,15578,15579,15580,15581,15582,15583,15584,15585,15586,15587,15588,15589,15590,15591,15592,15593,15594,15595,15596,15597,15598,15599,15600,15601,15602,15603,15604,15605,15606,15842,15863,15864,15865,15866,15867,15868,15869,15870,15871,15872) 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(1067,1068,1069,1073,1074,1075,1786,1787,1788,4018,4058,5376,5378,5379,5408,5409,5410,5411,5412,5413,5414,5415,5416,5417,5418,5419,5458,5459,5460,5461,5463,5464,5465,5466,5467,5468,5469,5470,5471,5472,5473,5474,5475,5476,5477,5478,5479,5480,5481,5485,5486,9033,10062,10063,10064,10065,10066,10067,10097,10098,10099,10100,10101,10102,12035,12038,12039,12040,12041,12042,12043,12044,12045,12046,12047,12048,12049,12050,12056,12057,12058,13382,13383,13384,13385,13386,13387,13388,13389,13940,13941,13967,15571,15572,15573,15574,15575,15576,15577,15578,15579,15580,15581,15582,15583,15584,15585,15586,15587,15588,15589,15590,15591,15592,15593,15594,15595,15596,15597,15598,15599,15600,15601,15602,15603,15604,15605,15606,15842,15863,15864,15865,15866,15867,15868,15869,15870,15871,15872) 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 4
?q=Daewoo&page=###page###
242
SELECT `id`, `name`, `type` FROM nox_group