/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(9633,9634,12759,12761,12764,12766,12768,12770,12773,12775,12778,12780,12783,12785,12788,12790,12793,12795,12798,12801,12803,12805,12808,12810,12812,12815,12817,12819,12822,12824,12826,12828,12831,12832,12834,12836,12838,12840,12842,12844,12846,12848,12850,12852,12854,12856,12858,12860,12862,12864,12866,12868,12870,12872,12874,15813,15814,15940,15941,15942,15943,15944,15945,15946,15947,15948,15949,15950,15951,15952,15953,15954,15955,15956,15957,15958,15959,15960,15961,15962,15963,15997,15998,15999,16000,16001,16002,16003,16004,16005,16006,16007,16008,16009,16010,16011,16012,16013,16014,16015,16016,16017,16018,16019,16020,16021,16022,16023,16024,16025,16026,16027,16028,16029,16030,16031,16032,16161,16162,16163,16164,16165,16166,16167,16168,16169,16170,16171,16172,17278,17279,17280,17281,17282,17283,17284,17285,17286,17287,17288,17289,17354,17355,17356,17357,17358,17359,17368,17369,17370,17371,17372,17373,18432,18433,18434,18435,18436,18437,18438,18439,18440,18441,18442,18443,18444,18445,18446,18447,18448,18449,18450,18451,18452,18453,18454,18455,19622,28587,28736,28737,28746,28814,28817,28820,29531,30523,30524,30617,30619,30622,30654,30657,30659,30829,31240,31247))
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(9633,9634,12759,12761,12764,12766,12768,12770,12773,12775,12778,12780,12783,12785,12788,12790,12793,12795,12798,12801,12803,12805,12808,12810,12812,12815,12817,12819,12822,12824,12826,12828,12831,12832,12834,12836,12838,12840,12842,12844,12846,12848,12850,12852,12854,12856,12858,12860,12862,12864,12866,12868,12870,12872,12874,15813,15814,15940,15941,15942,15943,15944,15945,15946,15947,15948,15949,15950,15951,15952,15953,15954,15955,15956,15957,15958,15959,15960,15961,15962,15963,15997,15998,15999,16000,16001,16002,16003,16004,16005,16006,16007,16008,16009,16010,16011,16012,16013,16014,16015,16016,16017,16018,16019,16020,16021,16022,16023,16024,16025,16026,16027,16028,16029,16030,16031,16032,16161,16162,16163,16164,16165,16166,16167,16168,16169,16170,16171,16172,17278,17279,17280,17281,17282,17283,17284,17285,17286,17287,17288,17289,17354,17355,17356,17357,17358,17359,17368,17369,17370,17371,17372,17373,18432,18433,18434,18435,18436,18437,18438,18439,18440,18441,18442,18443,18444,18445,18446,18447,18448,18449,18450,18451,18452,18453,18454,18455,19622,28587,28736,28737,28746,28814,28817,28820,29531,30523,30524,30617,30619,30622,30654,30657,30659,30829,31240,31247)) 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(9840, 12960, 35823, 35833, 35835, 31096, 16595, 16824, 18198, 18118, 18184, 19333, 20557, 35831, 35860) 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` = 16595 AND `prints_set_vector`.`vector_id` IN(9633,9634,12759,12761,12764,12766,12768,12770,12773,12775,12778,12780,12783,12785,12788,12790,12793,12795,12798,12801,12803,12805,12808,12810,12812,12815,12817,12819,12822,12824,12826,12828,12831,12832,12834,12836,12838,12840,12842,12844,12846,12848,12850,12852,12854,12856,12858,12860,12862,12864,12866,12868,12870,12872,12874,15813,15814,15940,15941,15942,15943,15944,15945,15946,15947,15948,15949,15950,15951,15952,15953,15954,15955,15956,15957,15958,15959,15960,15961,15962,15963,15997,15998,15999,16000,16001,16002,16003,16004,16005,16006,16007,16008,16009,16010,16011,16012,16013,16014,16015,16016,16017,16018,16019,16020,16021,16022,16023,16024,16025,16026,16027,16028,16029,16030,16031,16032,16161,16162,16163,16164,16165,16166,16167,16168,16169,16170,16171,16172,17278,17279,17280,17281,17282,17283,17284,17285,17286,17287,17288,17289,17354,17355,17356,17357,17358,17359,17368,17369,17370,17371,17372,17373,18432,18433,18434,18435,18436,18437,18438,18439,18440,18441,18442,18443,18444,18445,18446,18447,18448,18449,18450,18451,18452,18453,18454,18455,19622,28587,28736,28737,28746,28814,28817,28820,29531,30523,30524,30617,30619,30622,30654,30657,30659,30829,31240,31247) 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` = 16824 AND `prints_set_vector`.`vector_id` IN(9633,9634,12759,12761,12764,12766,12768,12770,12773,12775,12778,12780,12783,12785,12788,12790,12793,12795,12798,12801,12803,12805,12808,12810,12812,12815,12817,12819,12822,12824,12826,12828,12831,12832,12834,12836,12838,12840,12842,12844,12846,12848,12850,12852,12854,12856,12858,12860,12862,12864,12866,12868,12870,12872,12874,15813,15814,15940,15941,15942,15943,15944,15945,15946,15947,15948,15949,15950,15951,15952,15953,15954,15955,15956,15957,15958,15959,15960,15961,15962,15963,15997,15998,15999,16000,16001,16002,16003,16004,16005,16006,16007,16008,16009,16010,16011,16012,16013,16014,16015,16016,16017,16018,16019,16020,16021,16022,16023,16024,16025,16026,16027,16028,16029,16030,16031,16032,16161,16162,16163,16164,16165,16166,16167,16168,16169,16170,16171,16172,17278,17279,17280,17281,17282,17283,17284,17285,17286,17287,17288,17289,17354,17355,17356,17357,17358,17359,17368,17369,17370,17371,17372,17373,18432,18433,18434,18435,18436,18437,18438,18439,18440,18441,18442,18443,18444,18445,18446,18447,18448,18449,18450,18451,18452,18453,18454,18455,19622,28587,28736,28737,28746,28814,28817,28820,29531,30523,30524,30617,30619,30622,30654,30657,30659,30829,31240,31247) 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` = 18118 AND `prints_set_vector`.`vector_id` IN(9633,9634,12759,12761,12764,12766,12768,12770,12773,12775,12778,12780,12783,12785,12788,12790,12793,12795,12798,12801,12803,12805,12808,12810,12812,12815,12817,12819,12822,12824,12826,12828,12831,12832,12834,12836,12838,12840,12842,12844,12846,12848,12850,12852,12854,12856,12858,12860,12862,12864,12866,12868,12870,12872,12874,15813,15814,15940,15941,15942,15943,15944,15945,15946,15947,15948,15949,15950,15951,15952,15953,15954,15955,15956,15957,15958,15959,15960,15961,15962,15963,15997,15998,15999,16000,16001,16002,16003,16004,16005,16006,16007,16008,16009,16010,16011,16012,16013,16014,16015,16016,16017,16018,16019,16020,16021,16022,16023,16024,16025,16026,16027,16028,16029,16030,16031,16032,16161,16162,16163,16164,16165,16166,16167,16168,16169,16170,16171,16172,17278,17279,17280,17281,17282,17283,17284,17285,17286,17287,17288,17289,17354,17355,17356,17357,17358,17359,17368,17369,17370,17371,17372,17373,18432,18433,18434,18435,18436,18437,18438,18439,18440,18441,18442,18443,18444,18445,18446,18447,18448,18449,18450,18451,18452,18453,18454,18455,19622,28587,28736,28737,28746,28814,28817,28820,29531,30523,30524,30617,30619,30622,30654,30657,30659,30829,31240,31247) 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` = 19333 AND `prints_set_vector`.`vector_id` IN(9633,9634,12759,12761,12764,12766,12768,12770,12773,12775,12778,12780,12783,12785,12788,12790,12793,12795,12798,12801,12803,12805,12808,12810,12812,12815,12817,12819,12822,12824,12826,12828,12831,12832,12834,12836,12838,12840,12842,12844,12846,12848,12850,12852,12854,12856,12858,12860,12862,12864,12866,12868,12870,12872,12874,15813,15814,15940,15941,15942,15943,15944,15945,15946,15947,15948,15949,15950,15951,15952,15953,15954,15955,15956,15957,15958,15959,15960,15961,15962,15963,15997,15998,15999,16000,16001,16002,16003,16004,16005,16006,16007,16008,16009,16010,16011,16012,16013,16014,16015,16016,16017,16018,16019,16020,16021,16022,16023,16024,16025,16026,16027,16028,16029,16030,16031,16032,16161,16162,16163,16164,16165,16166,16167,16168,16169,16170,16171,16172,17278,17279,17280,17281,17282,17283,17284,17285,17286,17287,17288,17289,17354,17355,17356,17357,17358,17359,17368,17369,17370,17371,17372,17373,18432,18433,18434,18435,18436,18437,18438,18439,18440,18441,18442,18443,18444,18445,18446,18447,18448,18449,18450,18451,18452,18453,18454,18455,19622,28587,28736,28737,28746,28814,28817,28820,29531,30523,30524,30617,30619,30622,30654,30657,30659,30829,31240,31247) 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` = 12960 AND `prints_set_vector`.`vector_id` IN(9633,9634,12759,12761,12764,12766,12768,12770,12773,12775,12778,12780,12783,12785,12788,12790,12793,12795,12798,12801,12803,12805,12808,12810,12812,12815,12817,12819,12822,12824,12826,12828,12831,12832,12834,12836,12838,12840,12842,12844,12846,12848,12850,12852,12854,12856,12858,12860,12862,12864,12866,12868,12870,12872,12874,15813,15814,15940,15941,15942,15943,15944,15945,15946,15947,15948,15949,15950,15951,15952,15953,15954,15955,15956,15957,15958,15959,15960,15961,15962,15963,15997,15998,15999,16000,16001,16002,16003,16004,16005,16006,16007,16008,16009,16010,16011,16012,16013,16014,16015,16016,16017,16018,16019,16020,16021,16022,16023,16024,16025,16026,16027,16028,16029,16030,16031,16032,16161,16162,16163,16164,16165,16166,16167,16168,16169,16170,16171,16172,17278,17279,17280,17281,17282,17283,17284,17285,17286,17287,17288,17289,17354,17355,17356,17357,17358,17359,17368,17369,17370,17371,17372,17373,18432,18433,18434,18435,18436,18437,18438,18439,18440,18441,18442,18443,18444,18445,18446,18447,18448,18449,18450,18451,18452,18453,18454,18455,19622,28587,28736,28737,28746,28814,28817,28820,29531,30523,30524,30617,30619,30622,30654,30657,30659,30829,31240,31247) 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` = 35823 AND `prints_set_vector`.`vector_id` IN(9633,9634,12759,12761,12764,12766,12768,12770,12773,12775,12778,12780,12783,12785,12788,12790,12793,12795,12798,12801,12803,12805,12808,12810,12812,12815,12817,12819,12822,12824,12826,12828,12831,12832,12834,12836,12838,12840,12842,12844,12846,12848,12850,12852,12854,12856,12858,12860,12862,12864,12866,12868,12870,12872,12874,15813,15814,15940,15941,15942,15943,15944,15945,15946,15947,15948,15949,15950,15951,15952,15953,15954,15955,15956,15957,15958,15959,15960,15961,15962,15963,15997,15998,15999,16000,16001,16002,16003,16004,16005,16006,16007,16008,16009,16010,16011,16012,16013,16014,16015,16016,16017,16018,16019,16020,16021,16022,16023,16024,16025,16026,16027,16028,16029,16030,16031,16032,16161,16162,16163,16164,16165,16166,16167,16168,16169,16170,16171,16172,17278,17279,17280,17281,17282,17283,17284,17285,17286,17287,17288,17289,17354,17355,17356,17357,17358,17359,17368,17369,17370,17371,17372,17373,18432,18433,18434,18435,18436,18437,18438,18439,18440,18441,18442,18443,18444,18445,18446,18447,18448,18449,18450,18451,18452,18453,18454,18455,19622,28587,28736,28737,28746,28814,28817,28820,29531,30523,30524,30617,30619,30622,30654,30657,30659,30829,31240,31247) 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` = 35833 AND `prints_set_vector`.`vector_id` IN(9633,9634,12759,12761,12764,12766,12768,12770,12773,12775,12778,12780,12783,12785,12788,12790,12793,12795,12798,12801,12803,12805,12808,12810,12812,12815,12817,12819,12822,12824,12826,12828,12831,12832,12834,12836,12838,12840,12842,12844,12846,12848,12850,12852,12854,12856,12858,12860,12862,12864,12866,12868,12870,12872,12874,15813,15814,15940,15941,15942,15943,15944,15945,15946,15947,15948,15949,15950,15951,15952,15953,15954,15955,15956,15957,15958,15959,15960,15961,15962,15963,15997,15998,15999,16000,16001,16002,16003,16004,16005,16006,16007,16008,16009,16010,16011,16012,16013,16014,16015,16016,16017,16018,16019,16020,16021,16022,16023,16024,16025,16026,16027,16028,16029,16030,16031,16032,16161,16162,16163,16164,16165,16166,16167,16168,16169,16170,16171,16172,17278,17279,17280,17281,17282,17283,17284,17285,17286,17287,17288,17289,17354,17355,17356,17357,17358,17359,17368,17369,17370,17371,17372,17373,18432,18433,18434,18435,18436,18437,18438,18439,18440,18441,18442,18443,18444,18445,18446,18447,18448,18449,18450,18451,18452,18453,18454,18455,19622,28587,28736,28737,28746,28814,28817,28820,29531,30523,30524,30617,30619,30622,30654,30657,30659,30829,31240,31247) 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` = 35831 AND `prints_set_vector`.`vector_id` IN(9633,9634,12759,12761,12764,12766,12768,12770,12773,12775,12778,12780,12783,12785,12788,12790,12793,12795,12798,12801,12803,12805,12808,12810,12812,12815,12817,12819,12822,12824,12826,12828,12831,12832,12834,12836,12838,12840,12842,12844,12846,12848,12850,12852,12854,12856,12858,12860,12862,12864,12866,12868,12870,12872,12874,15813,15814,15940,15941,15942,15943,15944,15945,15946,15947,15948,15949,15950,15951,15952,15953,15954,15955,15956,15957,15958,15959,15960,15961,15962,15963,15997,15998,15999,16000,16001,16002,16003,16004,16005,16006,16007,16008,16009,16010,16011,16012,16013,16014,16015,16016,16017,16018,16019,16020,16021,16022,16023,16024,16025,16026,16027,16028,16029,16030,16031,16032,16161,16162,16163,16164,16165,16166,16167,16168,16169,16170,16171,16172,17278,17279,17280,17281,17282,17283,17284,17285,17286,17287,17288,17289,17354,17355,17356,17357,17358,17359,17368,17369,17370,17371,17372,17373,18432,18433,18434,18435,18436,18437,18438,18439,18440,18441,18442,18443,18444,18445,18446,18447,18448,18449,18450,18451,18452,18453,18454,18455,19622,28587,28736,28737,28746,28814,28817,28820,29531,30523,30524,30617,30619,30622,30654,30657,30659,30829,31240,31247) 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` = 35835 AND `prints_set_vector`.`vector_id` IN(9633,9634,12759,12761,12764,12766,12768,12770,12773,12775,12778,12780,12783,12785,12788,12790,12793,12795,12798,12801,12803,12805,12808,12810,12812,12815,12817,12819,12822,12824,12826,12828,12831,12832,12834,12836,12838,12840,12842,12844,12846,12848,12850,12852,12854,12856,12858,12860,12862,12864,12866,12868,12870,12872,12874,15813,15814,15940,15941,15942,15943,15944,15945,15946,15947,15948,15949,15950,15951,15952,15953,15954,15955,15956,15957,15958,15959,15960,15961,15962,15963,15997,15998,15999,16000,16001,16002,16003,16004,16005,16006,16007,16008,16009,16010,16011,16012,16013,16014,16015,16016,16017,16018,16019,16020,16021,16022,16023,16024,16025,16026,16027,16028,16029,16030,16031,16032,16161,16162,16163,16164,16165,16166,16167,16168,16169,16170,16171,16172,17278,17279,17280,17281,17282,17283,17284,17285,17286,17287,17288,17289,17354,17355,17356,17357,17358,17359,17368,17369,17370,17371,17372,17373,18432,18433,18434,18435,18436,18437,18438,18439,18440,18441,18442,18443,18444,18445,18446,18447,18448,18449,18450,18451,18452,18453,18454,18455,19622,28587,28736,28737,28746,28814,28817,28820,29531,30523,30524,30617,30619,30622,30654,30657,30659,30829,31240,31247) 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` = 35860 AND `prints_set_vector`.`vector_id` IN(9633,9634,12759,12761,12764,12766,12768,12770,12773,12775,12778,12780,12783,12785,12788,12790,12793,12795,12798,12801,12803,12805,12808,12810,12812,12815,12817,12819,12822,12824,12826,12828,12831,12832,12834,12836,12838,12840,12842,12844,12846,12848,12850,12852,12854,12856,12858,12860,12862,12864,12866,12868,12870,12872,12874,15813,15814,15940,15941,15942,15943,15944,15945,15946,15947,15948,15949,15950,15951,15952,15953,15954,15955,15956,15957,15958,15959,15960,15961,15962,15963,15997,15998,15999,16000,16001,16002,16003,16004,16005,16006,16007,16008,16009,16010,16011,16012,16013,16014,16015,16016,16017,16018,16019,16020,16021,16022,16023,16024,16025,16026,16027,16028,16029,16030,16031,16032,16161,16162,16163,16164,16165,16166,16167,16168,16169,16170,16171,16172,17278,17279,17280,17281,17282,17283,17284,17285,17286,17287,17288,17289,17354,17355,17356,17357,17358,17359,17368,17369,17370,17371,17372,17373,18432,18433,18434,18435,18436,18437,18438,18439,18440,18441,18442,18443,18444,18445,18446,18447,18448,18449,18450,18451,18452,18453,18454,18455,19622,28587,28736,28737,28746,28814,28817,28820,29531,30523,30524,30617,30619,30622,30654,30657,30659,30829,31240,31247) 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` = 31096 AND `prints_set_vector`.`vector_id` IN(9633,9634,12759,12761,12764,12766,12768,12770,12773,12775,12778,12780,12783,12785,12788,12790,12793,12795,12798,12801,12803,12805,12808,12810,12812,12815,12817,12819,12822,12824,12826,12828,12831,12832,12834,12836,12838,12840,12842,12844,12846,12848,12850,12852,12854,12856,12858,12860,12862,12864,12866,12868,12870,12872,12874,15813,15814,15940,15941,15942,15943,15944,15945,15946,15947,15948,15949,15950,15951,15952,15953,15954,15955,15956,15957,15958,15959,15960,15961,15962,15963,15997,15998,15999,16000,16001,16002,16003,16004,16005,16006,16007,16008,16009,16010,16011,16012,16013,16014,16015,16016,16017,16018,16019,16020,16021,16022,16023,16024,16025,16026,16027,16028,16029,16030,16031,16032,16161,16162,16163,16164,16165,16166,16167,16168,16169,16170,16171,16172,17278,17279,17280,17281,17282,17283,17284,17285,17286,17287,17288,17289,17354,17355,17356,17357,17358,17359,17368,17369,17370,17371,17372,17373,18432,18433,18434,18435,18436,18437,18438,18439,18440,18441,18442,18443,18444,18445,18446,18447,18448,18449,18450,18451,18452,18453,18454,18455,19622,28587,28736,28737,28746,28814,28817,28820,29531,30523,30524,30617,30619,30622,30654,30657,30659,30829,31240,31247) 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` = 18198 AND `prints_set_vector`.`vector_id` IN(9633,9634,12759,12761,12764,12766,12768,12770,12773,12775,12778,12780,12783,12785,12788,12790,12793,12795,12798,12801,12803,12805,12808,12810,12812,12815,12817,12819,12822,12824,12826,12828,12831,12832,12834,12836,12838,12840,12842,12844,12846,12848,12850,12852,12854,12856,12858,12860,12862,12864,12866,12868,12870,12872,12874,15813,15814,15940,15941,15942,15943,15944,15945,15946,15947,15948,15949,15950,15951,15952,15953,15954,15955,15956,15957,15958,15959,15960,15961,15962,15963,15997,15998,15999,16000,16001,16002,16003,16004,16005,16006,16007,16008,16009,16010,16011,16012,16013,16014,16015,16016,16017,16018,16019,16020,16021,16022,16023,16024,16025,16026,16027,16028,16029,16030,16031,16032,16161,16162,16163,16164,16165,16166,16167,16168,16169,16170,16171,16172,17278,17279,17280,17281,17282,17283,17284,17285,17286,17287,17288,17289,17354,17355,17356,17357,17358,17359,17368,17369,17370,17371,17372,17373,18432,18433,18434,18435,18436,18437,18438,18439,18440,18441,18442,18443,18444,18445,18446,18447,18448,18449,18450,18451,18452,18453,18454,18455,19622,28587,28736,28737,28746,28814,28817,28820,29531,30523,30524,30617,30619,30622,30654,30657,30659,30829,31240,31247) 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` = 18184 AND `prints_set_vector`.`vector_id` IN(9633,9634,12759,12761,12764,12766,12768,12770,12773,12775,12778,12780,12783,12785,12788,12790,12793,12795,12798,12801,12803,12805,12808,12810,12812,12815,12817,12819,12822,12824,12826,12828,12831,12832,12834,12836,12838,12840,12842,12844,12846,12848,12850,12852,12854,12856,12858,12860,12862,12864,12866,12868,12870,12872,12874,15813,15814,15940,15941,15942,15943,15944,15945,15946,15947,15948,15949,15950,15951,15952,15953,15954,15955,15956,15957,15958,15959,15960,15961,15962,15963,15997,15998,15999,16000,16001,16002,16003,16004,16005,16006,16007,16008,16009,16010,16011,16012,16013,16014,16015,16016,16017,16018,16019,16020,16021,16022,16023,16024,16025,16026,16027,16028,16029,16030,16031,16032,16161,16162,16163,16164,16165,16166,16167,16168,16169,16170,16171,16172,17278,17279,17280,17281,17282,17283,17284,17285,17286,17287,17288,17289,17354,17355,17356,17357,17358,17359,17368,17369,17370,17371,17372,17373,18432,18433,18434,18435,18436,18437,18438,18439,18440,18441,18442,18443,18444,18445,18446,18447,18448,18449,18450,18451,18452,18453,18454,18455,19622,28587,28736,28737,28746,28814,28817,28820,29531,30523,30524,30617,30619,30622,30654,30657,30659,30829,31240,31247) 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` = 20557 AND `prints_set_vector`.`vector_id` IN(9633,9634,12759,12761,12764,12766,12768,12770,12773,12775,12778,12780,12783,12785,12788,12790,12793,12795,12798,12801,12803,12805,12808,12810,12812,12815,12817,12819,12822,12824,12826,12828,12831,12832,12834,12836,12838,12840,12842,12844,12846,12848,12850,12852,12854,12856,12858,12860,12862,12864,12866,12868,12870,12872,12874,15813,15814,15940,15941,15942,15943,15944,15945,15946,15947,15948,15949,15950,15951,15952,15953,15954,15955,15956,15957,15958,15959,15960,15961,15962,15963,15997,15998,15999,16000,16001,16002,16003,16004,16005,16006,16007,16008,16009,16010,16011,16012,16013,16014,16015,16016,16017,16018,16019,16020,16021,16022,16023,16024,16025,16026,16027,16028,16029,16030,16031,16032,16161,16162,16163,16164,16165,16166,16167,16168,16169,16170,16171,16172,17278,17279,17280,17281,17282,17283,17284,17285,17286,17287,17288,17289,17354,17355,17356,17357,17358,17359,17368,17369,17370,17371,17372,17373,18432,18433,18434,18435,18436,18437,18438,18439,18440,18441,18442,18443,18444,18445,18446,18447,18448,18449,18450,18451,18452,18453,18454,18455,19622,28587,28736,28737,28746,28814,28817,28820,29531,30523,30524,30617,30619,30622,30654,30657,30659,30829,31240,31247) 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` = 9840 AND `prints_set_vector`.`vector_id` IN(9633,9634,12759,12761,12764,12766,12768,12770,12773,12775,12778,12780,12783,12785,12788,12790,12793,12795,12798,12801,12803,12805,12808,12810,12812,12815,12817,12819,12822,12824,12826,12828,12831,12832,12834,12836,12838,12840,12842,12844,12846,12848,12850,12852,12854,12856,12858,12860,12862,12864,12866,12868,12870,12872,12874,15813,15814,15940,15941,15942,15943,15944,15945,15946,15947,15948,15949,15950,15951,15952,15953,15954,15955,15956,15957,15958,15959,15960,15961,15962,15963,15997,15998,15999,16000,16001,16002,16003,16004,16005,16006,16007,16008,16009,16010,16011,16012,16013,16014,16015,16016,16017,16018,16019,16020,16021,16022,16023,16024,16025,16026,16027,16028,16029,16030,16031,16032,16161,16162,16163,16164,16165,16166,16167,16168,16169,16170,16171,16172,17278,17279,17280,17281,17282,17283,17284,17285,17286,17287,17288,17289,17354,17355,17356,17357,17358,17359,17368,17369,17370,17371,17372,17373,18432,18433,18434,18435,18436,18437,18438,18439,18440,18441,18442,18443,18444,18445,18446,18447,18448,18449,18450,18451,18452,18453,18454,18455,19622,28587,28736,28737,28746,28814,28817,28820,29531,30523,30524,30617,30619,30622,30654,30657,30659,30829,31240,31247) 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(9633,9634,12759,12761,12764,12766,12768,12770,12773,12775,12778,12780,12783,12785,12788,12790,12793,12795,12798,12801,12803,12805,12808,12810,12812,12815,12817,12819,12822,12824,12826,12828,12831,12832,12834,12836,12838,12840,12842,12844,12846,12848,12850,12852,12854,12856,12858,12860,12862,12864,12866,12868,12870,12872,12874,15813,15814,15940,15941,15942,15943,15944,15945,15946,15947,15948,15949,15950,15951,15952,15953,15954,15955,15956,15957,15958,15959,15960,15961,15962,15963,15997,15998,15999,16000,16001,16002,16003,16004,16005,16006,16007,16008,16009,16010,16011,16012,16013,16014,16015,16016,16017,16018,16019,16020,16021,16022,16023,16024,16025,16026,16027,16028,16029,16030,16031,16032,16161,16162,16163,16164,16165,16166,16167,16168,16169,16170,16171,16172,17278,17279,17280,17281,17282,17283,17284,17285,17286,17287,17288,17289,17354,17355,17356,17357,17358,17359,17368,17369,17370,17371,17372,17373,18432,18433,18434,18435,18436,18437,18438,18439,18440,18441,18442,18443,18444,18445,18446,18447,18448,18449,18450,18451,18452,18453,18454,18455,19622,28587,28736,28737,28746,28814,28817,28820,29531,30523,30524,30617,30619,30622,30654,30657,30659,30829,31240,31247) 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 15
?q=75&page=###page###
264
SELECT `id`, `name`, `type` FROM nox_group