/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(88,89,90,91,92,93,94,95,96,97,98,99,100,106,107,108,109,110,111,112,113,114,115,164,165,166,167,224,225,226,227,228,229,230,231,232,233,245,246,247,248,249,250,495,496,497,498,499,500,501,502,503,504,505,881,882,883,884,2001,2839,2840,3447,3448,4032,27865,27866,28351,28352,28353,28354,28355,28356,28357,28358,28359,28360,28361,28362,28363,28593,28782,28811,28868,28910,28944,29031,29093,29094,29095,29096,29097,29102,29103,29104,29105,29106,29107,29108,29109,29110,29111,29112,29113,29181,29182,29183,29184,29220,29221,29222,29223,29224,29225,29226,29227,29228,29229,29230,29231,29245,29304,29305,29380,29427,29428,29429,29430,29431,29432,29488,29489,29490,29491,29492,29493,29494,29495,29496,29497,29498,29499,29521,29522,29523,29524,29525,29526,29527,29682,29683,29684,29685,29686,29696,29697,29698,29699,29700,29701,29702,29703,29704,29705,29706,29707,29708,29709,29710,29712,29713,29714,29715,29716,29717,29718,29719,29720,29721,29722,29723,29724,29725,29726,29727,29728,29729,29730,29731,29732,29733,29734,29735,29736,29737,29738,29739,29740,29741,29742,29743,29744,29745,29746,29747,29762,29763,29764,29765,29766,29767,29768,29769,29770,29771,29772,29773,29774,29775,29776,29777,29778,29779,29780,29781,29782,29783,29784,29785,29786,29787,29788,29789,29790,29791,29792,29793,29794,29795,29796,29797,29875,29876,29877,29878,29879,29880,29881,29882,29883,29884,29885,29886,29887,29888,29889,29890,29891,29949,29950,29951,30062,30219,30290,30360,30361,30362,30363,30364,30365,30366,30367,30368,30535,30694,30721,30834,31037,31038,31039,31040,31232,31233,31243,31567,31568,31569,31570,31571,31572,31573,31574,31579,31618,31619,31620,31624,31625,31626,31627,31641,31662,31978,31980,28366,31041,31663,31745,31746,31747,31748,31749,31750,31751,31752,31753,28367,29748,29749,29750,29751,29756,29758,30294,31312,31313,31314,31315,31316,29752,29753,29754,29755,29757,29759,31317))

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(SELECT DISTINCT set_id FROM prints_set_vector WHERE vector_id IN(88,89,90,91,92,93,94,95,96,97,98,99,100,106,107,108,109,110,111,112,113,114,115,164,165,166,167,224,225,226,227,228,229,230,231,232,233,245,246,247,248,249,250,495,496,497,498,499,500,501,502,503,504,505,881,882,883,884,2001,2839,2840,3447,3448,4032,27865,27866,28351,28352,28353,28354,28355,28356,28357,28358,28359,28360,28361,28362,28363,28593,28782,28811,28868,28910,28944,29031,29093,29094,29095,29096,29097,29102,29103,29104,29105,29106,29107,29108,29109,29110,29111,29112,29113,29181,29182,29183,29184,29220,29221,29222,29223,29224,29225,29226,29227,29228,29229,29230,29231,29245,29304,29305,29380,29427,29428,29429,29430,29431,29432,29488,29489,29490,29491,29492,29493,29494,29495,29496,29497,29498,29499,29521,29522,29523,29524,29525,29526,29527,29682,29683,29684,29685,29686,29696,29697,29698,29699,29700,29701,29702,29703,29704,29705,29706,29707,29708,29709,29710,29712,29713,29714,29715,29716,29717,29718,29719,29720,29721,29722,29723,29724,29725,29726,29727,29728,29729,29730,29731,29732,29733,29734,29735,29736,29737,29738,29739,29740,29741,29742,29743,29744,29745,29746,29747,29762,29763,29764,29765,29766,29767,29768,29769,29770,29771,29772,29773,29774,29775,29776,29777,29778,29779,29780,29781,29782,29783,29784,29785,29786,29787,29788,29789,29790,29791,29792,29793,29794,29795,29796,29797,29875,29876,29877,29878,29879,29880,29881,29882,29883,29884,29885,29886,29887,29888,29889,29890,29891,29949,29950,29951,30062,30219,30290,30360,30361,30362,30363,30364,30365,30366,30367,30368,30535,30694,30721,30834,31037,31038,31039,31040,31232,31233,31243,31567,31568,31569,31570,31571,31572,31573,31574,31579,31618,31619,31620,31624,31625,31626,31627,31641,31662,31978,31980,28366,31041,31663,31745,31746,31747,31748,31749,31750,31751,31752,31753,28367,29748,29749,29750,29751,29756,29758,30294,31312,31313,31314,31315,31316,29752,29753,29754,29755,29757,29759,31317)) AND EXISTS(SELECT 1 FROM `prints_set_vector` psv2 INNER JOIN `prints_vector` pv2 ON pv2.`id` = psv2.`vector_id` WHERE psv2.`set_id` = `prints_set`.`id` AND psv2.`vector_id` IN(88,89,90,91,92,93,94,95,96,97,98,99,100,106,107,108,109,110,111,112,113,114,115,164,165,166,167,224,225,226,227,228,229,230,231,232,233,245,246,247,248,249,250,495,496,497,498,499,500,501,502,503,504,505,881,882,883,884,2001,2839,2840,3447,3448,4032,27865,27866,28351,28352,28353,28354,28355,28356,28357,28358,28359,28360,28361,28362,28363,28593,28782,28811,28868,28910,28944,29031,29093,29094,29095,29096,29097,29102,29103,29104,29105,29106,29107,29108,29109,29110,29111,29112,29113,29181,29182,29183,29184,29220,29221,29222,29223,29224,29225,29226,29227,29228,29229,29230,29231,29245,29304,29305,29380,29427,29428,29429,29430,29431,29432,29488,29489,29490,29491,29492,29493,29494,29495,29496,29497,29498,29499,29521,29522,29523,29524,29525,29526,29527,29682,29683,29684,29685,29686,29696,29697,29698,29699,29700,29701,29702,29703,29704,29705,29706,29707,29708,29709,29710,29712,29713,29714,29715,29716,29717,29718,29719,29720,29721,29722,29723,29724,29725,29726,29727,29728,29729,29730,29731,29732,29733,29734,29735,29736,29737,29738,29739,29740,29741,29742,29743,29744,29745,29746,29747,29762,29763,29764,29765,29766,29767,29768,29769,29770,29771,29772,29773,29774,29775,29776,29777,29778,29779,29780,29781,29782,29783,29784,29785,29786,29787,29788,29789,29790,29791,29792,29793,29794,29795,29796,29797,29875,29876,29877,29878,29879,29880,29881,29882,29883,29884,29885,29886,29887,29888,29889,29890,29891,29949,29950,29951,30062,30219,30290,30360,30361,30362,30363,30364,30365,30366,30367,30368,30535,30694,30721,30834,31037,31038,31039,31040,31232,31233,31243,31567,31568,31569,31570,31571,31572,31573,31574,31579,31618,31619,31620,31624,31625,31626,31627,31641,31662,31978,31980,28366,31041,31663,31745,31746,31747,31748,31749,31750,31751,31752,31753,28367,29748,29749,29750,29751,29756,29758,30294,31312,31313,31314,31315,31316,29752,29753,29754,29755,29757,29759,31317) AND pv2.`bundle` = 0) GROUP BY `prints_set`.`id` ORDER BY 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, 0, 1), `prints_set`.`name_full` LIMIT 30

SELECT `prints_vector`.* FROM `prints_vector` LEFT JOIN `prints_set_vector` ON `prints_vector`.`id` = `prints_set_vector`.`vector_id` WHERE `id` IN(88,89,90,91,92,93,94,95,96,97,98,99,100,106,107,108,109,110,111,112,113,114,115,164,165,166,167,224,225,226,227,228,229,230,231,232,233,245,246,247,248,249,250,495,496,497,498,499,500,501,502,503,504,505,881,882,883,884,2001,2839,2840,3447,3448,4032,27865,27866,28351,28352,28353,28354,28355,28356,28357,28358,28359,28360,28361,28362,28363,28593,28782,28811,28868,28910,28944,29031,29093,29094,29095,29096,29097,29102,29103,29104,29105,29106,29107,29108,29109,29110,29111,29112,29113,29181,29182,29183,29184,29220,29221,29222,29223,29224,29225,29226,29227,29228,29229,29230,29231,29245,29304,29305,29380,29427,29428,29429,29430,29431,29432,29488,29489,29490,29491,29492,29493,29494,29495,29496,29497,29498,29499,29521,29522,29523,29524,29525,29526,29527,29682,29683,29684,29685,29686,29696,29697,29698,29699,29700,29701,29702,29703,29704,29705,29706,29707,29708,29709,29710,29712,29713,29714,29715,29716,29717,29718,29719,29720,29721,29722,29723,29724,29725,29726,29727,29728,29729,29730,29731,29732,29733,29734,29735,29736,29737,29738,29739,29740,29741,29742,29743,29744,29745,29746,29747,29762,29763,29764,29765,29766,29767,29768,29769,29770,29771,29772,29773,29774,29775,29776,29777,29778,29779,29780,29781,29782,29783,29784,29785,29786,29787,29788,29789,29790,29791,29792,29793,29794,29795,29796,29797,29875,29876,29877,29878,29879,29880,29881,29882,29883,29884,29885,29886,29887,29888,29889,29890,29891,29949,29950,29951,30062,30219,30290,30360,30361,30362,30363,30364,30365,30366,30367,30368,30535,30694,30721,30834,31037,31038,31039,31040,31232,31233,31243,31567,31568,31569,31570,31571,31572,31573,31574,31579,31618,31619,31620,31624,31625,31626,31627,31641,31662,31978,31980,28366,31041,31663,31745,31746,31747,31748,31749,31750,31751,31752,31753,28367,29748,29749,29750,29751,29756,29758,30294,31312,31313,31314,31315,31316,29752,29753,29754,29755,29757,29759,31317) 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 20

?q=Ford Transit&page=###page###

504

SELECT `id`, `name`, `type` FROM nox_group