/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(3558,3559,3560,3561,3562,3563,3564,3565,3566,3567,3568,3569,3570,3571,3572,3573,3574,3575,3576,3577,3578,3579,3580,3581,3582,3583,3584,3585,3586,3587,3588,28141,1289,1290,1303,1516,1517,1518,1521,1524,1527,6453,6455,28366,28836,28910,28944,29102,29104,29105,29108,29109,29112,29183,29521,29522,29525,29526,29697,29698,29699,29700,29701,29702,29703,29712,29713,29714,29715,29716,29717,29718,29719,29720,29721,29722,29723,29724,29725,29726,29727,29728,29748,29749,29750,29751,29752,29753,29754,29755,29762,29763,29764,29765,29766,29767,29768,29769,29770,29771,29772,29773,29774,29775,29776,29777,29778,29779,30028,30030,30036,30037,30040,30041,30042,30360,30361,30364,30365,30694,30734,31037,31038,31039,31040,31041,31232,31233,31312,31313,31314,31315,31316,31317,31641,31978,31980))
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(3558,3559,3560,3561,3562,3563,3564,3565,3566,3567,3568,3569,3570,3571,3572,3573,3574,3575,3576,3577,3578,3579,3580,3581,3582,3583,3584,3585,3586,3587,3588,28141,1289,1290,1303,1516,1517,1518,1521,1524,1527,6453,6455,28366,28836,28910,28944,29102,29104,29105,29108,29109,29112,29183,29521,29522,29525,29526,29697,29698,29699,29700,29701,29702,29703,29712,29713,29714,29715,29716,29717,29718,29719,29720,29721,29722,29723,29724,29725,29726,29727,29728,29748,29749,29750,29751,29752,29753,29754,29755,29762,29763,29764,29765,29766,29767,29768,29769,29770,29771,29772,29773,29774,29775,29776,29777,29778,29779,30028,30030,30036,30037,30040,30041,30042,30360,30361,30364,30365,30694,30734,31037,31038,31039,31040,31041,31232,31233,31312,31313,31314,31315,31316,31317,31641,31978,31980)) 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(35729, 35234, 35220, 35721, 30995, 30997, 33379, 6952, 6956, 36124, 36317, 36334, 35899, 35900, 36328, 36327) 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` = 6952 AND `prints_set_vector`.`vector_id` IN(3558,3559,3560,3561,3562,3563,3564,3565,3566,3567,3568,3569,3570,3571,3572,3573,3574,3575,3576,3577,3578,3579,3580,3581,3582,3583,3584,3585,3586,3587,3588,28141,1289,1290,1303,1516,1517,1518,1521,1524,1527,6453,6455,28366,28836,28910,28944,29102,29104,29105,29108,29109,29112,29183,29521,29522,29525,29526,29697,29698,29699,29700,29701,29702,29703,29712,29713,29714,29715,29716,29717,29718,29719,29720,29721,29722,29723,29724,29725,29726,29727,29728,29748,29749,29750,29751,29752,29753,29754,29755,29762,29763,29764,29765,29766,29767,29768,29769,29770,29771,29772,29773,29774,29775,29776,29777,29778,29779,30028,30030,30036,30037,30040,30041,30042,30360,30361,30364,30365,30694,30734,31037,31038,31039,31040,31041,31232,31233,31312,31313,31314,31315,31316,31317,31641,31978,31980) 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` = 35234 AND `prints_set_vector`.`vector_id` IN(3558,3559,3560,3561,3562,3563,3564,3565,3566,3567,3568,3569,3570,3571,3572,3573,3574,3575,3576,3577,3578,3579,3580,3581,3582,3583,3584,3585,3586,3587,3588,28141,1289,1290,1303,1516,1517,1518,1521,1524,1527,6453,6455,28366,28836,28910,28944,29102,29104,29105,29108,29109,29112,29183,29521,29522,29525,29526,29697,29698,29699,29700,29701,29702,29703,29712,29713,29714,29715,29716,29717,29718,29719,29720,29721,29722,29723,29724,29725,29726,29727,29728,29748,29749,29750,29751,29752,29753,29754,29755,29762,29763,29764,29765,29766,29767,29768,29769,29770,29771,29772,29773,29774,29775,29776,29777,29778,29779,30028,30030,30036,30037,30040,30041,30042,30360,30361,30364,30365,30694,30734,31037,31038,31039,31040,31041,31232,31233,31312,31313,31314,31315,31316,31317,31641,31978,31980) 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` = 35220 AND `prints_set_vector`.`vector_id` IN(3558,3559,3560,3561,3562,3563,3564,3565,3566,3567,3568,3569,3570,3571,3572,3573,3574,3575,3576,3577,3578,3579,3580,3581,3582,3583,3584,3585,3586,3587,3588,28141,1289,1290,1303,1516,1517,1518,1521,1524,1527,6453,6455,28366,28836,28910,28944,29102,29104,29105,29108,29109,29112,29183,29521,29522,29525,29526,29697,29698,29699,29700,29701,29702,29703,29712,29713,29714,29715,29716,29717,29718,29719,29720,29721,29722,29723,29724,29725,29726,29727,29728,29748,29749,29750,29751,29752,29753,29754,29755,29762,29763,29764,29765,29766,29767,29768,29769,29770,29771,29772,29773,29774,29775,29776,29777,29778,29779,30028,30030,30036,30037,30040,30041,30042,30360,30361,30364,30365,30694,30734,31037,31038,31039,31040,31041,31232,31233,31312,31313,31314,31315,31316,31317,31641,31978,31980) 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` = 35721 AND `prints_set_vector`.`vector_id` IN(3558,3559,3560,3561,3562,3563,3564,3565,3566,3567,3568,3569,3570,3571,3572,3573,3574,3575,3576,3577,3578,3579,3580,3581,3582,3583,3584,3585,3586,3587,3588,28141,1289,1290,1303,1516,1517,1518,1521,1524,1527,6453,6455,28366,28836,28910,28944,29102,29104,29105,29108,29109,29112,29183,29521,29522,29525,29526,29697,29698,29699,29700,29701,29702,29703,29712,29713,29714,29715,29716,29717,29718,29719,29720,29721,29722,29723,29724,29725,29726,29727,29728,29748,29749,29750,29751,29752,29753,29754,29755,29762,29763,29764,29765,29766,29767,29768,29769,29770,29771,29772,29773,29774,29775,29776,29777,29778,29779,30028,30030,30036,30037,30040,30041,30042,30360,30361,30364,30365,30694,30734,31037,31038,31039,31040,31041,31232,31233,31312,31313,31314,31315,31316,31317,31641,31978,31980) 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` = 35729 AND `prints_set_vector`.`vector_id` IN(3558,3559,3560,3561,3562,3563,3564,3565,3566,3567,3568,3569,3570,3571,3572,3573,3574,3575,3576,3577,3578,3579,3580,3581,3582,3583,3584,3585,3586,3587,3588,28141,1289,1290,1303,1516,1517,1518,1521,1524,1527,6453,6455,28366,28836,28910,28944,29102,29104,29105,29108,29109,29112,29183,29521,29522,29525,29526,29697,29698,29699,29700,29701,29702,29703,29712,29713,29714,29715,29716,29717,29718,29719,29720,29721,29722,29723,29724,29725,29726,29727,29728,29748,29749,29750,29751,29752,29753,29754,29755,29762,29763,29764,29765,29766,29767,29768,29769,29770,29771,29772,29773,29774,29775,29776,29777,29778,29779,30028,30030,30036,30037,30040,30041,30042,30360,30361,30364,30365,30694,30734,31037,31038,31039,31040,31041,31232,31233,31312,31313,31314,31315,31316,31317,31641,31978,31980) 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` = 36124 AND `prints_set_vector`.`vector_id` IN(3558,3559,3560,3561,3562,3563,3564,3565,3566,3567,3568,3569,3570,3571,3572,3573,3574,3575,3576,3577,3578,3579,3580,3581,3582,3583,3584,3585,3586,3587,3588,28141,1289,1290,1303,1516,1517,1518,1521,1524,1527,6453,6455,28366,28836,28910,28944,29102,29104,29105,29108,29109,29112,29183,29521,29522,29525,29526,29697,29698,29699,29700,29701,29702,29703,29712,29713,29714,29715,29716,29717,29718,29719,29720,29721,29722,29723,29724,29725,29726,29727,29728,29748,29749,29750,29751,29752,29753,29754,29755,29762,29763,29764,29765,29766,29767,29768,29769,29770,29771,29772,29773,29774,29775,29776,29777,29778,29779,30028,30030,30036,30037,30040,30041,30042,30360,30361,30364,30365,30694,30734,31037,31038,31039,31040,31041,31232,31233,31312,31313,31314,31315,31316,31317,31641,31978,31980) 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` = 30995 AND `prints_set_vector`.`vector_id` IN(3558,3559,3560,3561,3562,3563,3564,3565,3566,3567,3568,3569,3570,3571,3572,3573,3574,3575,3576,3577,3578,3579,3580,3581,3582,3583,3584,3585,3586,3587,3588,28141,1289,1290,1303,1516,1517,1518,1521,1524,1527,6453,6455,28366,28836,28910,28944,29102,29104,29105,29108,29109,29112,29183,29521,29522,29525,29526,29697,29698,29699,29700,29701,29702,29703,29712,29713,29714,29715,29716,29717,29718,29719,29720,29721,29722,29723,29724,29725,29726,29727,29728,29748,29749,29750,29751,29752,29753,29754,29755,29762,29763,29764,29765,29766,29767,29768,29769,29770,29771,29772,29773,29774,29775,29776,29777,29778,29779,30028,30030,30036,30037,30040,30041,30042,30360,30361,30364,30365,30694,30734,31037,31038,31039,31040,31041,31232,31233,31312,31313,31314,31315,31316,31317,31641,31978,31980) 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` = 30997 AND `prints_set_vector`.`vector_id` IN(3558,3559,3560,3561,3562,3563,3564,3565,3566,3567,3568,3569,3570,3571,3572,3573,3574,3575,3576,3577,3578,3579,3580,3581,3582,3583,3584,3585,3586,3587,3588,28141,1289,1290,1303,1516,1517,1518,1521,1524,1527,6453,6455,28366,28836,28910,28944,29102,29104,29105,29108,29109,29112,29183,29521,29522,29525,29526,29697,29698,29699,29700,29701,29702,29703,29712,29713,29714,29715,29716,29717,29718,29719,29720,29721,29722,29723,29724,29725,29726,29727,29728,29748,29749,29750,29751,29752,29753,29754,29755,29762,29763,29764,29765,29766,29767,29768,29769,29770,29771,29772,29773,29774,29775,29776,29777,29778,29779,30028,30030,30036,30037,30040,30041,30042,30360,30361,30364,30365,30694,30734,31037,31038,31039,31040,31041,31232,31233,31312,31313,31314,31315,31316,31317,31641,31978,31980) 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` = 33379 AND `prints_set_vector`.`vector_id` IN(3558,3559,3560,3561,3562,3563,3564,3565,3566,3567,3568,3569,3570,3571,3572,3573,3574,3575,3576,3577,3578,3579,3580,3581,3582,3583,3584,3585,3586,3587,3588,28141,1289,1290,1303,1516,1517,1518,1521,1524,1527,6453,6455,28366,28836,28910,28944,29102,29104,29105,29108,29109,29112,29183,29521,29522,29525,29526,29697,29698,29699,29700,29701,29702,29703,29712,29713,29714,29715,29716,29717,29718,29719,29720,29721,29722,29723,29724,29725,29726,29727,29728,29748,29749,29750,29751,29752,29753,29754,29755,29762,29763,29764,29765,29766,29767,29768,29769,29770,29771,29772,29773,29774,29775,29776,29777,29778,29779,30028,30030,30036,30037,30040,30041,30042,30360,30361,30364,30365,30694,30734,31037,31038,31039,31040,31041,31232,31233,31312,31313,31314,31315,31316,31317,31641,31978,31980) 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` = 36317 AND `prints_set_vector`.`vector_id` IN(3558,3559,3560,3561,3562,3563,3564,3565,3566,3567,3568,3569,3570,3571,3572,3573,3574,3575,3576,3577,3578,3579,3580,3581,3582,3583,3584,3585,3586,3587,3588,28141,1289,1290,1303,1516,1517,1518,1521,1524,1527,6453,6455,28366,28836,28910,28944,29102,29104,29105,29108,29109,29112,29183,29521,29522,29525,29526,29697,29698,29699,29700,29701,29702,29703,29712,29713,29714,29715,29716,29717,29718,29719,29720,29721,29722,29723,29724,29725,29726,29727,29728,29748,29749,29750,29751,29752,29753,29754,29755,29762,29763,29764,29765,29766,29767,29768,29769,29770,29771,29772,29773,29774,29775,29776,29777,29778,29779,30028,30030,30036,30037,30040,30041,30042,30360,30361,30364,30365,30694,30734,31037,31038,31039,31040,31041,31232,31233,31312,31313,31314,31315,31316,31317,31641,31978,31980) 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` = 35899 AND `prints_set_vector`.`vector_id` IN(3558,3559,3560,3561,3562,3563,3564,3565,3566,3567,3568,3569,3570,3571,3572,3573,3574,3575,3576,3577,3578,3579,3580,3581,3582,3583,3584,3585,3586,3587,3588,28141,1289,1290,1303,1516,1517,1518,1521,1524,1527,6453,6455,28366,28836,28910,28944,29102,29104,29105,29108,29109,29112,29183,29521,29522,29525,29526,29697,29698,29699,29700,29701,29702,29703,29712,29713,29714,29715,29716,29717,29718,29719,29720,29721,29722,29723,29724,29725,29726,29727,29728,29748,29749,29750,29751,29752,29753,29754,29755,29762,29763,29764,29765,29766,29767,29768,29769,29770,29771,29772,29773,29774,29775,29776,29777,29778,29779,30028,30030,30036,30037,30040,30041,30042,30360,30361,30364,30365,30694,30734,31037,31038,31039,31040,31041,31232,31233,31312,31313,31314,31315,31316,31317,31641,31978,31980) 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` = 35900 AND `prints_set_vector`.`vector_id` IN(3558,3559,3560,3561,3562,3563,3564,3565,3566,3567,3568,3569,3570,3571,3572,3573,3574,3575,3576,3577,3578,3579,3580,3581,3582,3583,3584,3585,3586,3587,3588,28141,1289,1290,1303,1516,1517,1518,1521,1524,1527,6453,6455,28366,28836,28910,28944,29102,29104,29105,29108,29109,29112,29183,29521,29522,29525,29526,29697,29698,29699,29700,29701,29702,29703,29712,29713,29714,29715,29716,29717,29718,29719,29720,29721,29722,29723,29724,29725,29726,29727,29728,29748,29749,29750,29751,29752,29753,29754,29755,29762,29763,29764,29765,29766,29767,29768,29769,29770,29771,29772,29773,29774,29775,29776,29777,29778,29779,30028,30030,30036,30037,30040,30041,30042,30360,30361,30364,30365,30694,30734,31037,31038,31039,31040,31041,31232,31233,31312,31313,31314,31315,31316,31317,31641,31978,31980) 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` = 36328 AND `prints_set_vector`.`vector_id` IN(3558,3559,3560,3561,3562,3563,3564,3565,3566,3567,3568,3569,3570,3571,3572,3573,3574,3575,3576,3577,3578,3579,3580,3581,3582,3583,3584,3585,3586,3587,3588,28141,1289,1290,1303,1516,1517,1518,1521,1524,1527,6453,6455,28366,28836,28910,28944,29102,29104,29105,29108,29109,29112,29183,29521,29522,29525,29526,29697,29698,29699,29700,29701,29702,29703,29712,29713,29714,29715,29716,29717,29718,29719,29720,29721,29722,29723,29724,29725,29726,29727,29728,29748,29749,29750,29751,29752,29753,29754,29755,29762,29763,29764,29765,29766,29767,29768,29769,29770,29771,29772,29773,29774,29775,29776,29777,29778,29779,30028,30030,30036,30037,30040,30041,30042,30360,30361,30364,30365,30694,30734,31037,31038,31039,31040,31041,31232,31233,31312,31313,31314,31315,31316,31317,31641,31978,31980) 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` = 36327 AND `prints_set_vector`.`vector_id` IN(3558,3559,3560,3561,3562,3563,3564,3565,3566,3567,3568,3569,3570,3571,3572,3573,3574,3575,3576,3577,3578,3579,3580,3581,3582,3583,3584,3585,3586,3587,3588,28141,1289,1290,1303,1516,1517,1518,1521,1524,1527,6453,6455,28366,28836,28910,28944,29102,29104,29105,29108,29109,29112,29183,29521,29522,29525,29526,29697,29698,29699,29700,29701,29702,29703,29712,29713,29714,29715,29716,29717,29718,29719,29720,29721,29722,29723,29724,29725,29726,29727,29728,29748,29749,29750,29751,29752,29753,29754,29755,29762,29763,29764,29765,29766,29767,29768,29769,29770,29771,29772,29773,29774,29775,29776,29777,29778,29779,30028,30030,30036,30037,30040,30041,30042,30360,30361,30364,30365,30694,30734,31037,31038,31039,31040,31041,31232,31233,31312,31313,31314,31315,31316,31317,31641,31978,31980) 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` = 36334 AND `prints_set_vector`.`vector_id` IN(3558,3559,3560,3561,3562,3563,3564,3565,3566,3567,3568,3569,3570,3571,3572,3573,3574,3575,3576,3577,3578,3579,3580,3581,3582,3583,3584,3585,3586,3587,3588,28141,1289,1290,1303,1516,1517,1518,1521,1524,1527,6453,6455,28366,28836,28910,28944,29102,29104,29105,29108,29109,29112,29183,29521,29522,29525,29526,29697,29698,29699,29700,29701,29702,29703,29712,29713,29714,29715,29716,29717,29718,29719,29720,29721,29722,29723,29724,29725,29726,29727,29728,29748,29749,29750,29751,29752,29753,29754,29755,29762,29763,29764,29765,29766,29767,29768,29769,29770,29771,29772,29773,29774,29775,29776,29777,29778,29779,30028,30030,30036,30037,30040,30041,30042,30360,30361,30364,30365,30694,30734,31037,31038,31039,31040,31041,31232,31233,31312,31313,31314,31315,31316,31317,31641,31978,31980) 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` = 6956 AND `prints_set_vector`.`vector_id` IN(3558,3559,3560,3561,3562,3563,3564,3565,3566,3567,3568,3569,3570,3571,3572,3573,3574,3575,3576,3577,3578,3579,3580,3581,3582,3583,3584,3585,3586,3587,3588,28141,1289,1290,1303,1516,1517,1518,1521,1524,1527,6453,6455,28366,28836,28910,28944,29102,29104,29105,29108,29109,29112,29183,29521,29522,29525,29526,29697,29698,29699,29700,29701,29702,29703,29712,29713,29714,29715,29716,29717,29718,29719,29720,29721,29722,29723,29724,29725,29726,29727,29728,29748,29749,29750,29751,29752,29753,29754,29755,29762,29763,29764,29765,29766,29767,29768,29769,29770,29771,29772,29773,29774,29775,29776,29777,29778,29779,30028,30030,30036,30037,30040,30041,30042,30360,30361,30364,30365,30694,30734,31037,31038,31039,31040,31041,31232,31233,31312,31313,31314,31315,31316,31317,31641,31978,31980) 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(3558,3559,3560,3561,3562,3563,3564,3565,3566,3567,3568,3569,3570,3571,3572,3573,3574,3575,3576,3577,3578,3579,3580,3581,3582,3583,3584,3585,3586,3587,3588,28141,1289,1290,1303,1516,1517,1518,1521,1524,1527,6453,6455,28366,28836,28910,28944,29102,29104,29105,29108,29109,29112,29183,29521,29522,29525,29526,29697,29698,29699,29700,29701,29702,29703,29712,29713,29714,29715,29716,29717,29718,29719,29720,29721,29722,29723,29724,29725,29726,29727,29728,29748,29749,29750,29751,29752,29753,29754,29755,29762,29763,29764,29765,29766,29767,29768,29769,29770,29771,29772,29773,29774,29775,29776,29777,29778,29779,30028,30030,30036,30037,30040,30041,30042,30360,30361,30364,30365,30694,30734,31037,31038,31039,31040,31041,31232,31233,31312,31313,31314,31315,31316,31317,31641,31978,31980) 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 14
?q=Ford Cargo&page=###page###
252
SELECT `id`, `name`, `type` FROM nox_group