/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(6721,6722,6723,31514,1554,1595,1596,1597,1598,1599,1600,1601,1602,1603,2548,2550,2552,3709,6658,6659,6660,6661,6662,6663,6670,6671,6672,6673,6674,6675,6676,6677,6678,6679,6680,6681,6682,6683,6684,6685,6694,6695,6696,6697,6698,6699,6700,6701,6702,6703,6704,6705,6706,6707,6708,6709,6710,6711,6712,6713,6714,6715,6716,6717,6718,6719,6720,6724,6725,6726,6727,6728,6729,6730,6731,6732,8225,8227,8228,8230,8232,8234,11838,11839,11843,11844,13647,13648,13649,14028,14029,14030,28588,28720,29659,31511,31512,31513))
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(6721,6722,6723,31514,1554,1595,1596,1597,1598,1599,1600,1601,1602,1603,2548,2550,2552,3709,6658,6659,6660,6661,6662,6663,6670,6671,6672,6673,6674,6675,6676,6677,6678,6679,6680,6681,6682,6683,6684,6685,6694,6695,6696,6697,6698,6699,6700,6701,6702,6703,6704,6705,6706,6707,6708,6709,6710,6711,6712,6713,6714,6715,6716,6717,6718,6719,6720,6724,6725,6726,6727,6728,6729,6730,6731,6732,8225,8227,8228,8230,8232,8234,11838,11839,11843,11844,13647,13648,13649,14028,14029,14030,28588,28720,29659,31511,31512,31513)) 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(36058, 3274, 7124, 36059, 7130, 7127, 7132, 7134, 7136, 7138, 7140, 36061, 7147, 7149, 7151, 8595, 8578, 8581, 11921, 14057, 14475) 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` = 11921 AND `prints_set_vector`.`vector_id` IN(6721,6722,6723,31514,1554,1595,1596,1597,1598,1599,1600,1601,1602,1603,2548,2550,2552,3709,6658,6659,6660,6661,6662,6663,6670,6671,6672,6673,6674,6675,6676,6677,6678,6679,6680,6681,6682,6683,6684,6685,6694,6695,6696,6697,6698,6699,6700,6701,6702,6703,6704,6705,6706,6707,6708,6709,6710,6711,6712,6713,6714,6715,6716,6717,6718,6719,6720,6724,6725,6726,6727,6728,6729,6730,6731,6732,8225,8227,8228,8230,8232,8234,11838,11839,11843,11844,13647,13648,13649,14028,14029,14030,28588,28720,29659,31511,31512,31513) 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` = 36058 AND `prints_set_vector`.`vector_id` IN(6721,6722,6723,31514,1554,1595,1596,1597,1598,1599,1600,1601,1602,1603,2548,2550,2552,3709,6658,6659,6660,6661,6662,6663,6670,6671,6672,6673,6674,6675,6676,6677,6678,6679,6680,6681,6682,6683,6684,6685,6694,6695,6696,6697,6698,6699,6700,6701,6702,6703,6704,6705,6706,6707,6708,6709,6710,6711,6712,6713,6714,6715,6716,6717,6718,6719,6720,6724,6725,6726,6727,6728,6729,6730,6731,6732,8225,8227,8228,8230,8232,8234,11838,11839,11843,11844,13647,13648,13649,14028,14029,14030,28588,28720,29659,31511,31512,31513) 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` = 7132 AND `prints_set_vector`.`vector_id` IN(6721,6722,6723,31514,1554,1595,1596,1597,1598,1599,1600,1601,1602,1603,2548,2550,2552,3709,6658,6659,6660,6661,6662,6663,6670,6671,6672,6673,6674,6675,6676,6677,6678,6679,6680,6681,6682,6683,6684,6685,6694,6695,6696,6697,6698,6699,6700,6701,6702,6703,6704,6705,6706,6707,6708,6709,6710,6711,6712,6713,6714,6715,6716,6717,6718,6719,6720,6724,6725,6726,6727,6728,6729,6730,6731,6732,8225,8227,8228,8230,8232,8234,11838,11839,11843,11844,13647,13648,13649,14028,14029,14030,28588,28720,29659,31511,31512,31513) 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` = 7134 AND `prints_set_vector`.`vector_id` IN(6721,6722,6723,31514,1554,1595,1596,1597,1598,1599,1600,1601,1602,1603,2548,2550,2552,3709,6658,6659,6660,6661,6662,6663,6670,6671,6672,6673,6674,6675,6676,6677,6678,6679,6680,6681,6682,6683,6684,6685,6694,6695,6696,6697,6698,6699,6700,6701,6702,6703,6704,6705,6706,6707,6708,6709,6710,6711,6712,6713,6714,6715,6716,6717,6718,6719,6720,6724,6725,6726,6727,6728,6729,6730,6731,6732,8225,8227,8228,8230,8232,8234,11838,11839,11843,11844,13647,13648,13649,14028,14029,14030,28588,28720,29659,31511,31512,31513) 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` = 8595 AND `prints_set_vector`.`vector_id` IN(6721,6722,6723,31514,1554,1595,1596,1597,1598,1599,1600,1601,1602,1603,2548,2550,2552,3709,6658,6659,6660,6661,6662,6663,6670,6671,6672,6673,6674,6675,6676,6677,6678,6679,6680,6681,6682,6683,6684,6685,6694,6695,6696,6697,6698,6699,6700,6701,6702,6703,6704,6705,6706,6707,6708,6709,6710,6711,6712,6713,6714,6715,6716,6717,6718,6719,6720,6724,6725,6726,6727,6728,6729,6730,6731,6732,8225,8227,8228,8230,8232,8234,11838,11839,11843,11844,13647,13648,13649,14028,14029,14030,28588,28720,29659,31511,31512,31513) 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` = 7124 AND `prints_set_vector`.`vector_id` IN(6721,6722,6723,31514,1554,1595,1596,1597,1598,1599,1600,1601,1602,1603,2548,2550,2552,3709,6658,6659,6660,6661,6662,6663,6670,6671,6672,6673,6674,6675,6676,6677,6678,6679,6680,6681,6682,6683,6684,6685,6694,6695,6696,6697,6698,6699,6700,6701,6702,6703,6704,6705,6706,6707,6708,6709,6710,6711,6712,6713,6714,6715,6716,6717,6718,6719,6720,6724,6725,6726,6727,6728,6729,6730,6731,6732,8225,8227,8228,8230,8232,8234,11838,11839,11843,11844,13647,13648,13649,14028,14029,14030,28588,28720,29659,31511,31512,31513) 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` = 7130 AND `prints_set_vector`.`vector_id` IN(6721,6722,6723,31514,1554,1595,1596,1597,1598,1599,1600,1601,1602,1603,2548,2550,2552,3709,6658,6659,6660,6661,6662,6663,6670,6671,6672,6673,6674,6675,6676,6677,6678,6679,6680,6681,6682,6683,6684,6685,6694,6695,6696,6697,6698,6699,6700,6701,6702,6703,6704,6705,6706,6707,6708,6709,6710,6711,6712,6713,6714,6715,6716,6717,6718,6719,6720,6724,6725,6726,6727,6728,6729,6730,6731,6732,8225,8227,8228,8230,8232,8234,11838,11839,11843,11844,13647,13648,13649,14028,14029,14030,28588,28720,29659,31511,31512,31513) 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` = 7136 AND `prints_set_vector`.`vector_id` IN(6721,6722,6723,31514,1554,1595,1596,1597,1598,1599,1600,1601,1602,1603,2548,2550,2552,3709,6658,6659,6660,6661,6662,6663,6670,6671,6672,6673,6674,6675,6676,6677,6678,6679,6680,6681,6682,6683,6684,6685,6694,6695,6696,6697,6698,6699,6700,6701,6702,6703,6704,6705,6706,6707,6708,6709,6710,6711,6712,6713,6714,6715,6716,6717,6718,6719,6720,6724,6725,6726,6727,6728,6729,6730,6731,6732,8225,8227,8228,8230,8232,8234,11838,11839,11843,11844,13647,13648,13649,14028,14029,14030,28588,28720,29659,31511,31512,31513) 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` = 14475 AND `prints_set_vector`.`vector_id` IN(6721,6722,6723,31514,1554,1595,1596,1597,1598,1599,1600,1601,1602,1603,2548,2550,2552,3709,6658,6659,6660,6661,6662,6663,6670,6671,6672,6673,6674,6675,6676,6677,6678,6679,6680,6681,6682,6683,6684,6685,6694,6695,6696,6697,6698,6699,6700,6701,6702,6703,6704,6705,6706,6707,6708,6709,6710,6711,6712,6713,6714,6715,6716,6717,6718,6719,6720,6724,6725,6726,6727,6728,6729,6730,6731,6732,8225,8227,8228,8230,8232,8234,11838,11839,11843,11844,13647,13648,13649,14028,14029,14030,28588,28720,29659,31511,31512,31513) 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` = 14057 AND `prints_set_vector`.`vector_id` IN(6721,6722,6723,31514,1554,1595,1596,1597,1598,1599,1600,1601,1602,1603,2548,2550,2552,3709,6658,6659,6660,6661,6662,6663,6670,6671,6672,6673,6674,6675,6676,6677,6678,6679,6680,6681,6682,6683,6684,6685,6694,6695,6696,6697,6698,6699,6700,6701,6702,6703,6704,6705,6706,6707,6708,6709,6710,6711,6712,6713,6714,6715,6716,6717,6718,6719,6720,6724,6725,6726,6727,6728,6729,6730,6731,6732,8225,8227,8228,8230,8232,8234,11838,11839,11843,11844,13647,13648,13649,14028,14029,14030,28588,28720,29659,31511,31512,31513) 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` = 7138 AND `prints_set_vector`.`vector_id` IN(6721,6722,6723,31514,1554,1595,1596,1597,1598,1599,1600,1601,1602,1603,2548,2550,2552,3709,6658,6659,6660,6661,6662,6663,6670,6671,6672,6673,6674,6675,6676,6677,6678,6679,6680,6681,6682,6683,6684,6685,6694,6695,6696,6697,6698,6699,6700,6701,6702,6703,6704,6705,6706,6707,6708,6709,6710,6711,6712,6713,6714,6715,6716,6717,6718,6719,6720,6724,6725,6726,6727,6728,6729,6730,6731,6732,8225,8227,8228,8230,8232,8234,11838,11839,11843,11844,13647,13648,13649,14028,14029,14030,28588,28720,29659,31511,31512,31513) 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` = 7140 AND `prints_set_vector`.`vector_id` IN(6721,6722,6723,31514,1554,1595,1596,1597,1598,1599,1600,1601,1602,1603,2548,2550,2552,3709,6658,6659,6660,6661,6662,6663,6670,6671,6672,6673,6674,6675,6676,6677,6678,6679,6680,6681,6682,6683,6684,6685,6694,6695,6696,6697,6698,6699,6700,6701,6702,6703,6704,6705,6706,6707,6708,6709,6710,6711,6712,6713,6714,6715,6716,6717,6718,6719,6720,6724,6725,6726,6727,6728,6729,6730,6731,6732,8225,8227,8228,8230,8232,8234,11838,11839,11843,11844,13647,13648,13649,14028,14029,14030,28588,28720,29659,31511,31512,31513) 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` = 36059 AND `prints_set_vector`.`vector_id` IN(6721,6722,6723,31514,1554,1595,1596,1597,1598,1599,1600,1601,1602,1603,2548,2550,2552,3709,6658,6659,6660,6661,6662,6663,6670,6671,6672,6673,6674,6675,6676,6677,6678,6679,6680,6681,6682,6683,6684,6685,6694,6695,6696,6697,6698,6699,6700,6701,6702,6703,6704,6705,6706,6707,6708,6709,6710,6711,6712,6713,6714,6715,6716,6717,6718,6719,6720,6724,6725,6726,6727,6728,6729,6730,6731,6732,8225,8227,8228,8230,8232,8234,11838,11839,11843,11844,13647,13648,13649,14028,14029,14030,28588,28720,29659,31511,31512,31513) 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` = 8578 AND `prints_set_vector`.`vector_id` IN(6721,6722,6723,31514,1554,1595,1596,1597,1598,1599,1600,1601,1602,1603,2548,2550,2552,3709,6658,6659,6660,6661,6662,6663,6670,6671,6672,6673,6674,6675,6676,6677,6678,6679,6680,6681,6682,6683,6684,6685,6694,6695,6696,6697,6698,6699,6700,6701,6702,6703,6704,6705,6706,6707,6708,6709,6710,6711,6712,6713,6714,6715,6716,6717,6718,6719,6720,6724,6725,6726,6727,6728,6729,6730,6731,6732,8225,8227,8228,8230,8232,8234,11838,11839,11843,11844,13647,13648,13649,14028,14029,14030,28588,28720,29659,31511,31512,31513) 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` = 3274 AND `prints_set_vector`.`vector_id` IN(6721,6722,6723,31514,1554,1595,1596,1597,1598,1599,1600,1601,1602,1603,2548,2550,2552,3709,6658,6659,6660,6661,6662,6663,6670,6671,6672,6673,6674,6675,6676,6677,6678,6679,6680,6681,6682,6683,6684,6685,6694,6695,6696,6697,6698,6699,6700,6701,6702,6703,6704,6705,6706,6707,6708,6709,6710,6711,6712,6713,6714,6715,6716,6717,6718,6719,6720,6724,6725,6726,6727,6728,6729,6730,6731,6732,8225,8227,8228,8230,8232,8234,11838,11839,11843,11844,13647,13648,13649,14028,14029,14030,28588,28720,29659,31511,31512,31513) 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` = 36061 AND `prints_set_vector`.`vector_id` IN(6721,6722,6723,31514,1554,1595,1596,1597,1598,1599,1600,1601,1602,1603,2548,2550,2552,3709,6658,6659,6660,6661,6662,6663,6670,6671,6672,6673,6674,6675,6676,6677,6678,6679,6680,6681,6682,6683,6684,6685,6694,6695,6696,6697,6698,6699,6700,6701,6702,6703,6704,6705,6706,6707,6708,6709,6710,6711,6712,6713,6714,6715,6716,6717,6718,6719,6720,6724,6725,6726,6727,6728,6729,6730,6731,6732,8225,8227,8228,8230,8232,8234,11838,11839,11843,11844,13647,13648,13649,14028,14029,14030,28588,28720,29659,31511,31512,31513) 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` = 7127 AND `prints_set_vector`.`vector_id` IN(6721,6722,6723,31514,1554,1595,1596,1597,1598,1599,1600,1601,1602,1603,2548,2550,2552,3709,6658,6659,6660,6661,6662,6663,6670,6671,6672,6673,6674,6675,6676,6677,6678,6679,6680,6681,6682,6683,6684,6685,6694,6695,6696,6697,6698,6699,6700,6701,6702,6703,6704,6705,6706,6707,6708,6709,6710,6711,6712,6713,6714,6715,6716,6717,6718,6719,6720,6724,6725,6726,6727,6728,6729,6730,6731,6732,8225,8227,8228,8230,8232,8234,11838,11839,11843,11844,13647,13648,13649,14028,14029,14030,28588,28720,29659,31511,31512,31513) 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` = 7147 AND `prints_set_vector`.`vector_id` IN(6721,6722,6723,31514,1554,1595,1596,1597,1598,1599,1600,1601,1602,1603,2548,2550,2552,3709,6658,6659,6660,6661,6662,6663,6670,6671,6672,6673,6674,6675,6676,6677,6678,6679,6680,6681,6682,6683,6684,6685,6694,6695,6696,6697,6698,6699,6700,6701,6702,6703,6704,6705,6706,6707,6708,6709,6710,6711,6712,6713,6714,6715,6716,6717,6718,6719,6720,6724,6725,6726,6727,6728,6729,6730,6731,6732,8225,8227,8228,8230,8232,8234,11838,11839,11843,11844,13647,13648,13649,14028,14029,14030,28588,28720,29659,31511,31512,31513) 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` = 7149 AND `prints_set_vector`.`vector_id` IN(6721,6722,6723,31514,1554,1595,1596,1597,1598,1599,1600,1601,1602,1603,2548,2550,2552,3709,6658,6659,6660,6661,6662,6663,6670,6671,6672,6673,6674,6675,6676,6677,6678,6679,6680,6681,6682,6683,6684,6685,6694,6695,6696,6697,6698,6699,6700,6701,6702,6703,6704,6705,6706,6707,6708,6709,6710,6711,6712,6713,6714,6715,6716,6717,6718,6719,6720,6724,6725,6726,6727,6728,6729,6730,6731,6732,8225,8227,8228,8230,8232,8234,11838,11839,11843,11844,13647,13648,13649,14028,14029,14030,28588,28720,29659,31511,31512,31513) 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` = 7151 AND `prints_set_vector`.`vector_id` IN(6721,6722,6723,31514,1554,1595,1596,1597,1598,1599,1600,1601,1602,1603,2548,2550,2552,3709,6658,6659,6660,6661,6662,6663,6670,6671,6672,6673,6674,6675,6676,6677,6678,6679,6680,6681,6682,6683,6684,6685,6694,6695,6696,6697,6698,6699,6700,6701,6702,6703,6704,6705,6706,6707,6708,6709,6710,6711,6712,6713,6714,6715,6716,6717,6718,6719,6720,6724,6725,6726,6727,6728,6729,6730,6731,6732,8225,8227,8228,8230,8232,8234,11838,11839,11843,11844,13647,13648,13649,14028,14029,14030,28588,28720,29659,31511,31512,31513) 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` = 8581 AND `prints_set_vector`.`vector_id` IN(6721,6722,6723,31514,1554,1595,1596,1597,1598,1599,1600,1601,1602,1603,2548,2550,2552,3709,6658,6659,6660,6661,6662,6663,6670,6671,6672,6673,6674,6675,6676,6677,6678,6679,6680,6681,6682,6683,6684,6685,6694,6695,6696,6697,6698,6699,6700,6701,6702,6703,6704,6705,6706,6707,6708,6709,6710,6711,6712,6713,6714,6715,6716,6717,6718,6719,6720,6724,6725,6726,6727,6728,6729,6730,6731,6732,8225,8227,8228,8230,8232,8234,11838,11839,11843,11844,13647,13648,13649,14028,14029,14030,28588,28720,29659,31511,31512,31513) 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(6721,6722,6723,31514,1554,1595,1596,1597,1598,1599,1600,1601,1602,1603,2548,2550,2552,3709,6658,6659,6660,6661,6662,6663,6670,6671,6672,6673,6674,6675,6676,6677,6678,6679,6680,6681,6682,6683,6684,6685,6694,6695,6696,6697,6698,6699,6700,6701,6702,6703,6704,6705,6706,6707,6708,6709,6710,6711,6712,6713,6714,6715,6716,6717,6718,6719,6720,6724,6725,6726,6727,6728,6729,6730,6731,6732,8225,8227,8228,8230,8232,8234,11838,11839,11843,11844,13647,13648,13649,14028,14029,14030,28588,28720,29659,31511,31512,31513) 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 9
?q=Isuzu Pickup&page=###page###
115
SELECT `id`, `name`, `type` FROM nox_group