/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(6389,6390,6392,6394,6398,6403,6404,6405,6452,6456,6457,6459,7599,7600,7601,7602,7603,7604,7605,7606,7607,7608,7609,7610,7611,7612,7613,7614,7615,7616,7619,12185,12186,12187,12188,12189,12190,12191,12192,12194,12195,12196,12197,12198,12199,12200,12201,12202,12203,12204,12448,12449,12450,12598,12599,12600,12601,12602,12603,12604,12605,12606,12607,12621,12622,12623,12624,12625,12626,12627,12628,12629,12630,12631,12632,12651,12652,12653,12654,12655,12656,12657,12658,12659,12660,12661,12662,12663,12664,12665,12666,12667,12668,12674,12675,12676,12677,12678,12679,12686,12687,12688,12689,12690,12691,12701,12702,12703,12704,12705,12706,12707,12708,12709,14773,14774,14799,14800,14801,14802,14803,14867,14868,14869,14874,14875,14876,14879,14880,14881,14882,14883,14884,14885,14886,14887,14888,14889,14890,14891,14892,14893,14894,14895,14896,14897,14898,14899,14900,14901,14902,14903,14904,14905,14906,14907,14908,14909,14910,14911,14912,14928,14929,14930,14931,14932,14933,14934,14935,14936,14937,14938,14939,14940,14941,14942,14943,14944,14945,14946,14947,14948,28276,30276))
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(6389,6390,6392,6394,6398,6403,6404,6405,6452,6456,6457,6459,7599,7600,7601,7602,7603,7604,7605,7606,7607,7608,7609,7610,7611,7612,7613,7614,7615,7616,7619,12185,12186,12187,12188,12189,12190,12191,12192,12194,12195,12196,12197,12198,12199,12200,12201,12202,12203,12204,12448,12449,12450,12598,12599,12600,12601,12602,12603,12604,12605,12606,12607,12621,12622,12623,12624,12625,12626,12627,12628,12629,12630,12631,12632,12651,12652,12653,12654,12655,12656,12657,12658,12659,12660,12661,12662,12663,12664,12665,12666,12667,12668,12674,12675,12676,12677,12678,12679,12686,12687,12688,12689,12690,12691,12701,12702,12703,12704,12705,12706,12707,12708,12709,14773,14774,14799,14800,14801,14802,14803,14867,14868,14869,14874,14875,14876,14879,14880,14881,14882,14883,14884,14885,14886,14887,14888,14889,14890,14891,14892,14893,14894,14895,14896,14897,14898,14899,14900,14901,14902,14903,14904,14905,14906,14907,14908,14909,14910,14911,14912,14928,14929,14930,14931,14932,14933,14934,14935,14936,14937,14938,14939,14940,14941,14942,14943,14944,14945,14946,14947,14948,28276,30276)) 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(6900, 34211, 29093, 29697, 6959, 15199, 15545, 7913, 31609, 7924, 33569, 12314, 15071, 12870, 12884, 12902, 12789, 12790, 15547, 15472, 15546, 15553) 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` = 15472 AND `prints_set_vector`.`vector_id` IN(6389,6390,6392,6394,6398,6403,6404,6405,6452,6456,6457,6459,7599,7600,7601,7602,7603,7604,7605,7606,7607,7608,7609,7610,7611,7612,7613,7614,7615,7616,7619,12185,12186,12187,12188,12189,12190,12191,12192,12194,12195,12196,12197,12198,12199,12200,12201,12202,12203,12204,12448,12449,12450,12598,12599,12600,12601,12602,12603,12604,12605,12606,12607,12621,12622,12623,12624,12625,12626,12627,12628,12629,12630,12631,12632,12651,12652,12653,12654,12655,12656,12657,12658,12659,12660,12661,12662,12663,12664,12665,12666,12667,12668,12674,12675,12676,12677,12678,12679,12686,12687,12688,12689,12690,12691,12701,12702,12703,12704,12705,12706,12707,12708,12709,14773,14774,14799,14800,14801,14802,14803,14867,14868,14869,14874,14875,14876,14879,14880,14881,14882,14883,14884,14885,14886,14887,14888,14889,14890,14891,14892,14893,14894,14895,14896,14897,14898,14899,14900,14901,14902,14903,14904,14905,14906,14907,14908,14909,14910,14911,14912,14928,14929,14930,14931,14932,14933,14934,14935,14936,14937,14938,14939,14940,14941,14942,14943,14944,14945,14946,14947,14948,28276,30276) 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` = 33569 AND `prints_set_vector`.`vector_id` IN(6389,6390,6392,6394,6398,6403,6404,6405,6452,6456,6457,6459,7599,7600,7601,7602,7603,7604,7605,7606,7607,7608,7609,7610,7611,7612,7613,7614,7615,7616,7619,12185,12186,12187,12188,12189,12190,12191,12192,12194,12195,12196,12197,12198,12199,12200,12201,12202,12203,12204,12448,12449,12450,12598,12599,12600,12601,12602,12603,12604,12605,12606,12607,12621,12622,12623,12624,12625,12626,12627,12628,12629,12630,12631,12632,12651,12652,12653,12654,12655,12656,12657,12658,12659,12660,12661,12662,12663,12664,12665,12666,12667,12668,12674,12675,12676,12677,12678,12679,12686,12687,12688,12689,12690,12691,12701,12702,12703,12704,12705,12706,12707,12708,12709,14773,14774,14799,14800,14801,14802,14803,14867,14868,14869,14874,14875,14876,14879,14880,14881,14882,14883,14884,14885,14886,14887,14888,14889,14890,14891,14892,14893,14894,14895,14896,14897,14898,14899,14900,14901,14902,14903,14904,14905,14906,14907,14908,14909,14910,14911,14912,14928,14929,14930,14931,14932,14933,14934,14935,14936,14937,14938,14939,14940,14941,14942,14943,14944,14945,14946,14947,14948,28276,30276) 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` = 34211 AND `prints_set_vector`.`vector_id` IN(6389,6390,6392,6394,6398,6403,6404,6405,6452,6456,6457,6459,7599,7600,7601,7602,7603,7604,7605,7606,7607,7608,7609,7610,7611,7612,7613,7614,7615,7616,7619,12185,12186,12187,12188,12189,12190,12191,12192,12194,12195,12196,12197,12198,12199,12200,12201,12202,12203,12204,12448,12449,12450,12598,12599,12600,12601,12602,12603,12604,12605,12606,12607,12621,12622,12623,12624,12625,12626,12627,12628,12629,12630,12631,12632,12651,12652,12653,12654,12655,12656,12657,12658,12659,12660,12661,12662,12663,12664,12665,12666,12667,12668,12674,12675,12676,12677,12678,12679,12686,12687,12688,12689,12690,12691,12701,12702,12703,12704,12705,12706,12707,12708,12709,14773,14774,14799,14800,14801,14802,14803,14867,14868,14869,14874,14875,14876,14879,14880,14881,14882,14883,14884,14885,14886,14887,14888,14889,14890,14891,14892,14893,14894,14895,14896,14897,14898,14899,14900,14901,14902,14903,14904,14905,14906,14907,14908,14909,14910,14911,14912,14928,14929,14930,14931,14932,14933,14934,14935,14936,14937,14938,14939,14940,14941,14942,14943,14944,14945,14946,14947,14948,28276,30276) 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` = 12314 AND `prints_set_vector`.`vector_id` IN(6389,6390,6392,6394,6398,6403,6404,6405,6452,6456,6457,6459,7599,7600,7601,7602,7603,7604,7605,7606,7607,7608,7609,7610,7611,7612,7613,7614,7615,7616,7619,12185,12186,12187,12188,12189,12190,12191,12192,12194,12195,12196,12197,12198,12199,12200,12201,12202,12203,12204,12448,12449,12450,12598,12599,12600,12601,12602,12603,12604,12605,12606,12607,12621,12622,12623,12624,12625,12626,12627,12628,12629,12630,12631,12632,12651,12652,12653,12654,12655,12656,12657,12658,12659,12660,12661,12662,12663,12664,12665,12666,12667,12668,12674,12675,12676,12677,12678,12679,12686,12687,12688,12689,12690,12691,12701,12702,12703,12704,12705,12706,12707,12708,12709,14773,14774,14799,14800,14801,14802,14803,14867,14868,14869,14874,14875,14876,14879,14880,14881,14882,14883,14884,14885,14886,14887,14888,14889,14890,14891,14892,14893,14894,14895,14896,14897,14898,14899,14900,14901,14902,14903,14904,14905,14906,14907,14908,14909,14910,14911,14912,14928,14929,14930,14931,14932,14933,14934,14935,14936,14937,14938,14939,14940,14941,14942,14943,14944,14945,14946,14947,14948,28276,30276) 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` = 15071 AND `prints_set_vector`.`vector_id` IN(6389,6390,6392,6394,6398,6403,6404,6405,6452,6456,6457,6459,7599,7600,7601,7602,7603,7604,7605,7606,7607,7608,7609,7610,7611,7612,7613,7614,7615,7616,7619,12185,12186,12187,12188,12189,12190,12191,12192,12194,12195,12196,12197,12198,12199,12200,12201,12202,12203,12204,12448,12449,12450,12598,12599,12600,12601,12602,12603,12604,12605,12606,12607,12621,12622,12623,12624,12625,12626,12627,12628,12629,12630,12631,12632,12651,12652,12653,12654,12655,12656,12657,12658,12659,12660,12661,12662,12663,12664,12665,12666,12667,12668,12674,12675,12676,12677,12678,12679,12686,12687,12688,12689,12690,12691,12701,12702,12703,12704,12705,12706,12707,12708,12709,14773,14774,14799,14800,14801,14802,14803,14867,14868,14869,14874,14875,14876,14879,14880,14881,14882,14883,14884,14885,14886,14887,14888,14889,14890,14891,14892,14893,14894,14895,14896,14897,14898,14899,14900,14901,14902,14903,14904,14905,14906,14907,14908,14909,14910,14911,14912,14928,14929,14930,14931,14932,14933,14934,14935,14936,14937,14938,14939,14940,14941,14942,14943,14944,14945,14946,14947,14948,28276,30276) 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` = 29093 AND `prints_set_vector`.`vector_id` IN(6389,6390,6392,6394,6398,6403,6404,6405,6452,6456,6457,6459,7599,7600,7601,7602,7603,7604,7605,7606,7607,7608,7609,7610,7611,7612,7613,7614,7615,7616,7619,12185,12186,12187,12188,12189,12190,12191,12192,12194,12195,12196,12197,12198,12199,12200,12201,12202,12203,12204,12448,12449,12450,12598,12599,12600,12601,12602,12603,12604,12605,12606,12607,12621,12622,12623,12624,12625,12626,12627,12628,12629,12630,12631,12632,12651,12652,12653,12654,12655,12656,12657,12658,12659,12660,12661,12662,12663,12664,12665,12666,12667,12668,12674,12675,12676,12677,12678,12679,12686,12687,12688,12689,12690,12691,12701,12702,12703,12704,12705,12706,12707,12708,12709,14773,14774,14799,14800,14801,14802,14803,14867,14868,14869,14874,14875,14876,14879,14880,14881,14882,14883,14884,14885,14886,14887,14888,14889,14890,14891,14892,14893,14894,14895,14896,14897,14898,14899,14900,14901,14902,14903,14904,14905,14906,14907,14908,14909,14910,14911,14912,14928,14929,14930,14931,14932,14933,14934,14935,14936,14937,14938,14939,14940,14941,14942,14943,14944,14945,14946,14947,14948,28276,30276) 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` = 12870 AND `prints_set_vector`.`vector_id` IN(6389,6390,6392,6394,6398,6403,6404,6405,6452,6456,6457,6459,7599,7600,7601,7602,7603,7604,7605,7606,7607,7608,7609,7610,7611,7612,7613,7614,7615,7616,7619,12185,12186,12187,12188,12189,12190,12191,12192,12194,12195,12196,12197,12198,12199,12200,12201,12202,12203,12204,12448,12449,12450,12598,12599,12600,12601,12602,12603,12604,12605,12606,12607,12621,12622,12623,12624,12625,12626,12627,12628,12629,12630,12631,12632,12651,12652,12653,12654,12655,12656,12657,12658,12659,12660,12661,12662,12663,12664,12665,12666,12667,12668,12674,12675,12676,12677,12678,12679,12686,12687,12688,12689,12690,12691,12701,12702,12703,12704,12705,12706,12707,12708,12709,14773,14774,14799,14800,14801,14802,14803,14867,14868,14869,14874,14875,14876,14879,14880,14881,14882,14883,14884,14885,14886,14887,14888,14889,14890,14891,14892,14893,14894,14895,14896,14897,14898,14899,14900,14901,14902,14903,14904,14905,14906,14907,14908,14909,14910,14911,14912,14928,14929,14930,14931,14932,14933,14934,14935,14936,14937,14938,14939,14940,14941,14942,14943,14944,14945,14946,14947,14948,28276,30276) 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` = 12884 AND `prints_set_vector`.`vector_id` IN(6389,6390,6392,6394,6398,6403,6404,6405,6452,6456,6457,6459,7599,7600,7601,7602,7603,7604,7605,7606,7607,7608,7609,7610,7611,7612,7613,7614,7615,7616,7619,12185,12186,12187,12188,12189,12190,12191,12192,12194,12195,12196,12197,12198,12199,12200,12201,12202,12203,12204,12448,12449,12450,12598,12599,12600,12601,12602,12603,12604,12605,12606,12607,12621,12622,12623,12624,12625,12626,12627,12628,12629,12630,12631,12632,12651,12652,12653,12654,12655,12656,12657,12658,12659,12660,12661,12662,12663,12664,12665,12666,12667,12668,12674,12675,12676,12677,12678,12679,12686,12687,12688,12689,12690,12691,12701,12702,12703,12704,12705,12706,12707,12708,12709,14773,14774,14799,14800,14801,14802,14803,14867,14868,14869,14874,14875,14876,14879,14880,14881,14882,14883,14884,14885,14886,14887,14888,14889,14890,14891,14892,14893,14894,14895,14896,14897,14898,14899,14900,14901,14902,14903,14904,14905,14906,14907,14908,14909,14910,14911,14912,14928,14929,14930,14931,14932,14933,14934,14935,14936,14937,14938,14939,14940,14941,14942,14943,14944,14945,14946,14947,14948,28276,30276) 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` = 12902 AND `prints_set_vector`.`vector_id` IN(6389,6390,6392,6394,6398,6403,6404,6405,6452,6456,6457,6459,7599,7600,7601,7602,7603,7604,7605,7606,7607,7608,7609,7610,7611,7612,7613,7614,7615,7616,7619,12185,12186,12187,12188,12189,12190,12191,12192,12194,12195,12196,12197,12198,12199,12200,12201,12202,12203,12204,12448,12449,12450,12598,12599,12600,12601,12602,12603,12604,12605,12606,12607,12621,12622,12623,12624,12625,12626,12627,12628,12629,12630,12631,12632,12651,12652,12653,12654,12655,12656,12657,12658,12659,12660,12661,12662,12663,12664,12665,12666,12667,12668,12674,12675,12676,12677,12678,12679,12686,12687,12688,12689,12690,12691,12701,12702,12703,12704,12705,12706,12707,12708,12709,14773,14774,14799,14800,14801,14802,14803,14867,14868,14869,14874,14875,14876,14879,14880,14881,14882,14883,14884,14885,14886,14887,14888,14889,14890,14891,14892,14893,14894,14895,14896,14897,14898,14899,14900,14901,14902,14903,14904,14905,14906,14907,14908,14909,14910,14911,14912,14928,14929,14930,14931,14932,14933,14934,14935,14936,14937,14938,14939,14940,14941,14942,14943,14944,14945,14946,14947,14948,28276,30276) 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` = 12789 AND `prints_set_vector`.`vector_id` IN(6389,6390,6392,6394,6398,6403,6404,6405,6452,6456,6457,6459,7599,7600,7601,7602,7603,7604,7605,7606,7607,7608,7609,7610,7611,7612,7613,7614,7615,7616,7619,12185,12186,12187,12188,12189,12190,12191,12192,12194,12195,12196,12197,12198,12199,12200,12201,12202,12203,12204,12448,12449,12450,12598,12599,12600,12601,12602,12603,12604,12605,12606,12607,12621,12622,12623,12624,12625,12626,12627,12628,12629,12630,12631,12632,12651,12652,12653,12654,12655,12656,12657,12658,12659,12660,12661,12662,12663,12664,12665,12666,12667,12668,12674,12675,12676,12677,12678,12679,12686,12687,12688,12689,12690,12691,12701,12702,12703,12704,12705,12706,12707,12708,12709,14773,14774,14799,14800,14801,14802,14803,14867,14868,14869,14874,14875,14876,14879,14880,14881,14882,14883,14884,14885,14886,14887,14888,14889,14890,14891,14892,14893,14894,14895,14896,14897,14898,14899,14900,14901,14902,14903,14904,14905,14906,14907,14908,14909,14910,14911,14912,14928,14929,14930,14931,14932,14933,14934,14935,14936,14937,14938,14939,14940,14941,14942,14943,14944,14945,14946,14947,14948,28276,30276) 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` = 12790 AND `prints_set_vector`.`vector_id` IN(6389,6390,6392,6394,6398,6403,6404,6405,6452,6456,6457,6459,7599,7600,7601,7602,7603,7604,7605,7606,7607,7608,7609,7610,7611,7612,7613,7614,7615,7616,7619,12185,12186,12187,12188,12189,12190,12191,12192,12194,12195,12196,12197,12198,12199,12200,12201,12202,12203,12204,12448,12449,12450,12598,12599,12600,12601,12602,12603,12604,12605,12606,12607,12621,12622,12623,12624,12625,12626,12627,12628,12629,12630,12631,12632,12651,12652,12653,12654,12655,12656,12657,12658,12659,12660,12661,12662,12663,12664,12665,12666,12667,12668,12674,12675,12676,12677,12678,12679,12686,12687,12688,12689,12690,12691,12701,12702,12703,12704,12705,12706,12707,12708,12709,14773,14774,14799,14800,14801,14802,14803,14867,14868,14869,14874,14875,14876,14879,14880,14881,14882,14883,14884,14885,14886,14887,14888,14889,14890,14891,14892,14893,14894,14895,14896,14897,14898,14899,14900,14901,14902,14903,14904,14905,14906,14907,14908,14909,14910,14911,14912,14928,14929,14930,14931,14932,14933,14934,14935,14936,14937,14938,14939,14940,14941,14942,14943,14944,14945,14946,14947,14948,28276,30276) 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` = 29697 AND `prints_set_vector`.`vector_id` IN(6389,6390,6392,6394,6398,6403,6404,6405,6452,6456,6457,6459,7599,7600,7601,7602,7603,7604,7605,7606,7607,7608,7609,7610,7611,7612,7613,7614,7615,7616,7619,12185,12186,12187,12188,12189,12190,12191,12192,12194,12195,12196,12197,12198,12199,12200,12201,12202,12203,12204,12448,12449,12450,12598,12599,12600,12601,12602,12603,12604,12605,12606,12607,12621,12622,12623,12624,12625,12626,12627,12628,12629,12630,12631,12632,12651,12652,12653,12654,12655,12656,12657,12658,12659,12660,12661,12662,12663,12664,12665,12666,12667,12668,12674,12675,12676,12677,12678,12679,12686,12687,12688,12689,12690,12691,12701,12702,12703,12704,12705,12706,12707,12708,12709,14773,14774,14799,14800,14801,14802,14803,14867,14868,14869,14874,14875,14876,14879,14880,14881,14882,14883,14884,14885,14886,14887,14888,14889,14890,14891,14892,14893,14894,14895,14896,14897,14898,14899,14900,14901,14902,14903,14904,14905,14906,14907,14908,14909,14910,14911,14912,14928,14929,14930,14931,14932,14933,14934,14935,14936,14937,14938,14939,14940,14941,14942,14943,14944,14945,14946,14947,14948,28276,30276) 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` = 15199 AND `prints_set_vector`.`vector_id` IN(6389,6390,6392,6394,6398,6403,6404,6405,6452,6456,6457,6459,7599,7600,7601,7602,7603,7604,7605,7606,7607,7608,7609,7610,7611,7612,7613,7614,7615,7616,7619,12185,12186,12187,12188,12189,12190,12191,12192,12194,12195,12196,12197,12198,12199,12200,12201,12202,12203,12204,12448,12449,12450,12598,12599,12600,12601,12602,12603,12604,12605,12606,12607,12621,12622,12623,12624,12625,12626,12627,12628,12629,12630,12631,12632,12651,12652,12653,12654,12655,12656,12657,12658,12659,12660,12661,12662,12663,12664,12665,12666,12667,12668,12674,12675,12676,12677,12678,12679,12686,12687,12688,12689,12690,12691,12701,12702,12703,12704,12705,12706,12707,12708,12709,14773,14774,14799,14800,14801,14802,14803,14867,14868,14869,14874,14875,14876,14879,14880,14881,14882,14883,14884,14885,14886,14887,14888,14889,14890,14891,14892,14893,14894,14895,14896,14897,14898,14899,14900,14901,14902,14903,14904,14905,14906,14907,14908,14909,14910,14911,14912,14928,14929,14930,14931,14932,14933,14934,14935,14936,14937,14938,14939,14940,14941,14942,14943,14944,14945,14946,14947,14948,28276,30276) 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` = 6900 AND `prints_set_vector`.`vector_id` IN(6389,6390,6392,6394,6398,6403,6404,6405,6452,6456,6457,6459,7599,7600,7601,7602,7603,7604,7605,7606,7607,7608,7609,7610,7611,7612,7613,7614,7615,7616,7619,12185,12186,12187,12188,12189,12190,12191,12192,12194,12195,12196,12197,12198,12199,12200,12201,12202,12203,12204,12448,12449,12450,12598,12599,12600,12601,12602,12603,12604,12605,12606,12607,12621,12622,12623,12624,12625,12626,12627,12628,12629,12630,12631,12632,12651,12652,12653,12654,12655,12656,12657,12658,12659,12660,12661,12662,12663,12664,12665,12666,12667,12668,12674,12675,12676,12677,12678,12679,12686,12687,12688,12689,12690,12691,12701,12702,12703,12704,12705,12706,12707,12708,12709,14773,14774,14799,14800,14801,14802,14803,14867,14868,14869,14874,14875,14876,14879,14880,14881,14882,14883,14884,14885,14886,14887,14888,14889,14890,14891,14892,14893,14894,14895,14896,14897,14898,14899,14900,14901,14902,14903,14904,14905,14906,14907,14908,14909,14910,14911,14912,14928,14929,14930,14931,14932,14933,14934,14935,14936,14937,14938,14939,14940,14941,14942,14943,14944,14945,14946,14947,14948,28276,30276) 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` = 15545 AND `prints_set_vector`.`vector_id` IN(6389,6390,6392,6394,6398,6403,6404,6405,6452,6456,6457,6459,7599,7600,7601,7602,7603,7604,7605,7606,7607,7608,7609,7610,7611,7612,7613,7614,7615,7616,7619,12185,12186,12187,12188,12189,12190,12191,12192,12194,12195,12196,12197,12198,12199,12200,12201,12202,12203,12204,12448,12449,12450,12598,12599,12600,12601,12602,12603,12604,12605,12606,12607,12621,12622,12623,12624,12625,12626,12627,12628,12629,12630,12631,12632,12651,12652,12653,12654,12655,12656,12657,12658,12659,12660,12661,12662,12663,12664,12665,12666,12667,12668,12674,12675,12676,12677,12678,12679,12686,12687,12688,12689,12690,12691,12701,12702,12703,12704,12705,12706,12707,12708,12709,14773,14774,14799,14800,14801,14802,14803,14867,14868,14869,14874,14875,14876,14879,14880,14881,14882,14883,14884,14885,14886,14887,14888,14889,14890,14891,14892,14893,14894,14895,14896,14897,14898,14899,14900,14901,14902,14903,14904,14905,14906,14907,14908,14909,14910,14911,14912,14928,14929,14930,14931,14932,14933,14934,14935,14936,14937,14938,14939,14940,14941,14942,14943,14944,14945,14946,14947,14948,28276,30276) 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` = 6959 AND `prints_set_vector`.`vector_id` IN(6389,6390,6392,6394,6398,6403,6404,6405,6452,6456,6457,6459,7599,7600,7601,7602,7603,7604,7605,7606,7607,7608,7609,7610,7611,7612,7613,7614,7615,7616,7619,12185,12186,12187,12188,12189,12190,12191,12192,12194,12195,12196,12197,12198,12199,12200,12201,12202,12203,12204,12448,12449,12450,12598,12599,12600,12601,12602,12603,12604,12605,12606,12607,12621,12622,12623,12624,12625,12626,12627,12628,12629,12630,12631,12632,12651,12652,12653,12654,12655,12656,12657,12658,12659,12660,12661,12662,12663,12664,12665,12666,12667,12668,12674,12675,12676,12677,12678,12679,12686,12687,12688,12689,12690,12691,12701,12702,12703,12704,12705,12706,12707,12708,12709,14773,14774,14799,14800,14801,14802,14803,14867,14868,14869,14874,14875,14876,14879,14880,14881,14882,14883,14884,14885,14886,14887,14888,14889,14890,14891,14892,14893,14894,14895,14896,14897,14898,14899,14900,14901,14902,14903,14904,14905,14906,14907,14908,14909,14910,14911,14912,14928,14929,14930,14931,14932,14933,14934,14935,14936,14937,14938,14939,14940,14941,14942,14943,14944,14945,14946,14947,14948,28276,30276) 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` = 7913 AND `prints_set_vector`.`vector_id` IN(6389,6390,6392,6394,6398,6403,6404,6405,6452,6456,6457,6459,7599,7600,7601,7602,7603,7604,7605,7606,7607,7608,7609,7610,7611,7612,7613,7614,7615,7616,7619,12185,12186,12187,12188,12189,12190,12191,12192,12194,12195,12196,12197,12198,12199,12200,12201,12202,12203,12204,12448,12449,12450,12598,12599,12600,12601,12602,12603,12604,12605,12606,12607,12621,12622,12623,12624,12625,12626,12627,12628,12629,12630,12631,12632,12651,12652,12653,12654,12655,12656,12657,12658,12659,12660,12661,12662,12663,12664,12665,12666,12667,12668,12674,12675,12676,12677,12678,12679,12686,12687,12688,12689,12690,12691,12701,12702,12703,12704,12705,12706,12707,12708,12709,14773,14774,14799,14800,14801,14802,14803,14867,14868,14869,14874,14875,14876,14879,14880,14881,14882,14883,14884,14885,14886,14887,14888,14889,14890,14891,14892,14893,14894,14895,14896,14897,14898,14899,14900,14901,14902,14903,14904,14905,14906,14907,14908,14909,14910,14911,14912,14928,14929,14930,14931,14932,14933,14934,14935,14936,14937,14938,14939,14940,14941,14942,14943,14944,14945,14946,14947,14948,28276,30276) 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` = 15546 AND `prints_set_vector`.`vector_id` IN(6389,6390,6392,6394,6398,6403,6404,6405,6452,6456,6457,6459,7599,7600,7601,7602,7603,7604,7605,7606,7607,7608,7609,7610,7611,7612,7613,7614,7615,7616,7619,12185,12186,12187,12188,12189,12190,12191,12192,12194,12195,12196,12197,12198,12199,12200,12201,12202,12203,12204,12448,12449,12450,12598,12599,12600,12601,12602,12603,12604,12605,12606,12607,12621,12622,12623,12624,12625,12626,12627,12628,12629,12630,12631,12632,12651,12652,12653,12654,12655,12656,12657,12658,12659,12660,12661,12662,12663,12664,12665,12666,12667,12668,12674,12675,12676,12677,12678,12679,12686,12687,12688,12689,12690,12691,12701,12702,12703,12704,12705,12706,12707,12708,12709,14773,14774,14799,14800,14801,14802,14803,14867,14868,14869,14874,14875,14876,14879,14880,14881,14882,14883,14884,14885,14886,14887,14888,14889,14890,14891,14892,14893,14894,14895,14896,14897,14898,14899,14900,14901,14902,14903,14904,14905,14906,14907,14908,14909,14910,14911,14912,14928,14929,14930,14931,14932,14933,14934,14935,14936,14937,14938,14939,14940,14941,14942,14943,14944,14945,14946,14947,14948,28276,30276) 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` = 31609 AND `prints_set_vector`.`vector_id` IN(6389,6390,6392,6394,6398,6403,6404,6405,6452,6456,6457,6459,7599,7600,7601,7602,7603,7604,7605,7606,7607,7608,7609,7610,7611,7612,7613,7614,7615,7616,7619,12185,12186,12187,12188,12189,12190,12191,12192,12194,12195,12196,12197,12198,12199,12200,12201,12202,12203,12204,12448,12449,12450,12598,12599,12600,12601,12602,12603,12604,12605,12606,12607,12621,12622,12623,12624,12625,12626,12627,12628,12629,12630,12631,12632,12651,12652,12653,12654,12655,12656,12657,12658,12659,12660,12661,12662,12663,12664,12665,12666,12667,12668,12674,12675,12676,12677,12678,12679,12686,12687,12688,12689,12690,12691,12701,12702,12703,12704,12705,12706,12707,12708,12709,14773,14774,14799,14800,14801,14802,14803,14867,14868,14869,14874,14875,14876,14879,14880,14881,14882,14883,14884,14885,14886,14887,14888,14889,14890,14891,14892,14893,14894,14895,14896,14897,14898,14899,14900,14901,14902,14903,14904,14905,14906,14907,14908,14909,14910,14911,14912,14928,14929,14930,14931,14932,14933,14934,14935,14936,14937,14938,14939,14940,14941,14942,14943,14944,14945,14946,14947,14948,28276,30276) 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` = 15547 AND `prints_set_vector`.`vector_id` IN(6389,6390,6392,6394,6398,6403,6404,6405,6452,6456,6457,6459,7599,7600,7601,7602,7603,7604,7605,7606,7607,7608,7609,7610,7611,7612,7613,7614,7615,7616,7619,12185,12186,12187,12188,12189,12190,12191,12192,12194,12195,12196,12197,12198,12199,12200,12201,12202,12203,12204,12448,12449,12450,12598,12599,12600,12601,12602,12603,12604,12605,12606,12607,12621,12622,12623,12624,12625,12626,12627,12628,12629,12630,12631,12632,12651,12652,12653,12654,12655,12656,12657,12658,12659,12660,12661,12662,12663,12664,12665,12666,12667,12668,12674,12675,12676,12677,12678,12679,12686,12687,12688,12689,12690,12691,12701,12702,12703,12704,12705,12706,12707,12708,12709,14773,14774,14799,14800,14801,14802,14803,14867,14868,14869,14874,14875,14876,14879,14880,14881,14882,14883,14884,14885,14886,14887,14888,14889,14890,14891,14892,14893,14894,14895,14896,14897,14898,14899,14900,14901,14902,14903,14904,14905,14906,14907,14908,14909,14910,14911,14912,14928,14929,14930,14931,14932,14933,14934,14935,14936,14937,14938,14939,14940,14941,14942,14943,14944,14945,14946,14947,14948,28276,30276) 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` = 15553 AND `prints_set_vector`.`vector_id` IN(6389,6390,6392,6394,6398,6403,6404,6405,6452,6456,6457,6459,7599,7600,7601,7602,7603,7604,7605,7606,7607,7608,7609,7610,7611,7612,7613,7614,7615,7616,7619,12185,12186,12187,12188,12189,12190,12191,12192,12194,12195,12196,12197,12198,12199,12200,12201,12202,12203,12204,12448,12449,12450,12598,12599,12600,12601,12602,12603,12604,12605,12606,12607,12621,12622,12623,12624,12625,12626,12627,12628,12629,12630,12631,12632,12651,12652,12653,12654,12655,12656,12657,12658,12659,12660,12661,12662,12663,12664,12665,12666,12667,12668,12674,12675,12676,12677,12678,12679,12686,12687,12688,12689,12690,12691,12701,12702,12703,12704,12705,12706,12707,12708,12709,14773,14774,14799,14800,14801,14802,14803,14867,14868,14869,14874,14875,14876,14879,14880,14881,14882,14883,14884,14885,14886,14887,14888,14889,14890,14891,14892,14893,14894,14895,14896,14897,14898,14899,14900,14901,14902,14903,14904,14905,14906,14907,14908,14909,14910,14911,14912,14928,14929,14930,14931,14932,14933,14934,14935,14936,14937,14938,14939,14940,14941,14942,14943,14944,14945,14946,14947,14948,28276,30276) 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` = 7924 AND `prints_set_vector`.`vector_id` IN(6389,6390,6392,6394,6398,6403,6404,6405,6452,6456,6457,6459,7599,7600,7601,7602,7603,7604,7605,7606,7607,7608,7609,7610,7611,7612,7613,7614,7615,7616,7619,12185,12186,12187,12188,12189,12190,12191,12192,12194,12195,12196,12197,12198,12199,12200,12201,12202,12203,12204,12448,12449,12450,12598,12599,12600,12601,12602,12603,12604,12605,12606,12607,12621,12622,12623,12624,12625,12626,12627,12628,12629,12630,12631,12632,12651,12652,12653,12654,12655,12656,12657,12658,12659,12660,12661,12662,12663,12664,12665,12666,12667,12668,12674,12675,12676,12677,12678,12679,12686,12687,12688,12689,12690,12691,12701,12702,12703,12704,12705,12706,12707,12708,12709,14773,14774,14799,14800,14801,14802,14803,14867,14868,14869,14874,14875,14876,14879,14880,14881,14882,14883,14884,14885,14886,14887,14888,14889,14890,14891,14892,14893,14894,14895,14896,14897,14898,14899,14900,14901,14902,14903,14904,14905,14906,14907,14908,14909,14910,14911,14912,14928,14929,14930,14931,14932,14933,14934,14935,14936,14937,14938,14939,14940,14941,14942,14943,14944,14945,14946,14947,14948,28276,30276) 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(6389,6390,6392,6394,6398,6403,6404,6405,6452,6456,6457,6459,7599,7600,7601,7602,7603,7604,7605,7606,7607,7608,7609,7610,7611,7612,7613,7614,7615,7616,7619,12185,12186,12187,12188,12189,12190,12191,12192,12194,12195,12196,12197,12198,12199,12200,12201,12202,12203,12204,12448,12449,12450,12598,12599,12600,12601,12602,12603,12604,12605,12606,12607,12621,12622,12623,12624,12625,12626,12627,12628,12629,12630,12631,12632,12651,12652,12653,12654,12655,12656,12657,12658,12659,12660,12661,12662,12663,12664,12665,12666,12667,12668,12674,12675,12676,12677,12678,12679,12686,12687,12688,12689,12690,12691,12701,12702,12703,12704,12705,12706,12707,12708,12709,14773,14774,14799,14800,14801,14802,14803,14867,14868,14869,14874,14875,14876,14879,14880,14881,14882,14883,14884,14885,14886,14887,14888,14889,14890,14891,14892,14893,14894,14895,14896,14897,14898,14899,14900,14901,14902,14903,14904,14905,14906,14907,14908,14909,14910,14911,14912,14928,14929,14930,14931,14932,14933,14934,14935,14936,14937,14938,14939,14940,14941,14942,14943,14944,14945,14946,14947,14948,28276,30276) 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 8
?q=Mercury&page=###page###
431
SELECT `id`, `name`, `type` FROM nox_group