/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(17858,17861,17862,17863,17864,17865,17881,17886,17890,17891,17892,17893,17894,17895,17896,17897,17898,17899,17906,17907,17908,17932,17936,17940,17944,17945,17946,17947,17948,17949,17950,17951,17952,17953,17954,17968,17972,17973,17974,17975,17976,17977,17978,18002,18006,18010,18014,18015,18016,18017,18018,18019,18020,18021,18022,18023,18024,18025,18026,4149,4252,17848,17849,17850,17851,17852,17853,17854,17855,17856,17857,17859,17860,17866,17867,17868,17869,17870,17871,17872,17873,17874,17875,17876,17877,17878,17879,17880,17882,17883,17884,17885,17887,17888,17889,17900,17901,17902,17903,17904,17905,17909,17910,17911,17912,17913,17914,17915,17916,17917,17918,17919,17920,17921,17922,17923,17924,17925,17926,17927,17928,17929,17930,17931,17933,17934,17935,17937,17938,17939,17941,17942,17943,17955,17956,17957,17958,17959,17960,17961,17962,17963,17964,17965,17966,17967,17969,17970,17971,17979,17980,17981,17982,17983,17984,17985,17986,17988,17989,17990,17991,17992,17993,17994,17995,17996,17997,17998,17999,18000,18001,18003,18004,18005,18007,18008,18009,18011,18012,18013,4371,17987,30709))
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(17858,17861,17862,17863,17864,17865,17881,17886,17890,17891,17892,17893,17894,17895,17896,17897,17898,17899,17906,17907,17908,17932,17936,17940,17944,17945,17946,17947,17948,17949,17950,17951,17952,17953,17954,17968,17972,17973,17974,17975,17976,17977,17978,18002,18006,18010,18014,18015,18016,18017,18018,18019,18020,18021,18022,18023,18024,18025,18026,4149,4252,17848,17849,17850,17851,17852,17853,17854,17855,17856,17857,17859,17860,17866,17867,17868,17869,17870,17871,17872,17873,17874,17875,17876,17877,17878,17879,17880,17882,17883,17884,17885,17887,17888,17889,17900,17901,17902,17903,17904,17905,17909,17910,17911,17912,17913,17914,17915,17916,17917,17918,17919,17920,17921,17922,17923,17924,17925,17926,17927,17928,17929,17930,17931,17933,17934,17935,17937,17938,17939,17941,17942,17943,17955,17956,17957,17958,17959,17960,17961,17962,17963,17964,17965,17966,17967,17969,17970,17971,17979,17980,17981,17982,17983,17984,17985,17986,17988,17989,17990,17991,17992,17993,17994,17995,17996,17997,17998,17999,18000,18001,18003,18004,18005,18007,18008,18009,18011,18012,18013,4371,17987,30709)) 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(29563, 34661) 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` = 34661 AND `prints_set_vector`.`vector_id` IN(17858,17861,17862,17863,17864,17865,17881,17886,17890,17891,17892,17893,17894,17895,17896,17897,17898,17899,17906,17907,17908,17932,17936,17940,17944,17945,17946,17947,17948,17949,17950,17951,17952,17953,17954,17968,17972,17973,17974,17975,17976,17977,17978,18002,18006,18010,18014,18015,18016,18017,18018,18019,18020,18021,18022,18023,18024,18025,18026,4149,4252,17848,17849,17850,17851,17852,17853,17854,17855,17856,17857,17859,17860,17866,17867,17868,17869,17870,17871,17872,17873,17874,17875,17876,17877,17878,17879,17880,17882,17883,17884,17885,17887,17888,17889,17900,17901,17902,17903,17904,17905,17909,17910,17911,17912,17913,17914,17915,17916,17917,17918,17919,17920,17921,17922,17923,17924,17925,17926,17927,17928,17929,17930,17931,17933,17934,17935,17937,17938,17939,17941,17942,17943,17955,17956,17957,17958,17959,17960,17961,17962,17963,17964,17965,17966,17967,17969,17970,17971,17979,17980,17981,17982,17983,17984,17985,17986,17988,17989,17990,17991,17992,17993,17994,17995,17996,17997,17998,17999,18000,18001,18003,18004,18005,18007,18008,18009,18011,18012,18013,4371,17987,30709) 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` = 29563 AND `prints_set_vector`.`vector_id` IN(17858,17861,17862,17863,17864,17865,17881,17886,17890,17891,17892,17893,17894,17895,17896,17897,17898,17899,17906,17907,17908,17932,17936,17940,17944,17945,17946,17947,17948,17949,17950,17951,17952,17953,17954,17968,17972,17973,17974,17975,17976,17977,17978,18002,18006,18010,18014,18015,18016,18017,18018,18019,18020,18021,18022,18023,18024,18025,18026,4149,4252,17848,17849,17850,17851,17852,17853,17854,17855,17856,17857,17859,17860,17866,17867,17868,17869,17870,17871,17872,17873,17874,17875,17876,17877,17878,17879,17880,17882,17883,17884,17885,17887,17888,17889,17900,17901,17902,17903,17904,17905,17909,17910,17911,17912,17913,17914,17915,17916,17917,17918,17919,17920,17921,17922,17923,17924,17925,17926,17927,17928,17929,17930,17931,17933,17934,17935,17937,17938,17939,17941,17942,17943,17955,17956,17957,17958,17959,17960,17961,17962,17963,17964,17965,17966,17967,17969,17970,17971,17979,17980,17981,17982,17983,17984,17985,17986,17988,17989,17990,17991,17992,17993,17994,17995,17996,17997,17998,17999,18000,18001,18003,18004,18005,18007,18008,18009,18011,18012,18013,4371,17987,30709) 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(17858,17861,17862,17863,17864,17865,17881,17886,17890,17891,17892,17893,17894,17895,17896,17897,17898,17899,17906,17907,17908,17932,17936,17940,17944,17945,17946,17947,17948,17949,17950,17951,17952,17953,17954,17968,17972,17973,17974,17975,17976,17977,17978,18002,18006,18010,18014,18015,18016,18017,18018,18019,18020,18021,18022,18023,18024,18025,18026,4149,4252,17848,17849,17850,17851,17852,17853,17854,17855,17856,17857,17859,17860,17866,17867,17868,17869,17870,17871,17872,17873,17874,17875,17876,17877,17878,17879,17880,17882,17883,17884,17885,17887,17888,17889,17900,17901,17902,17903,17904,17905,17909,17910,17911,17912,17913,17914,17915,17916,17917,17918,17919,17920,17921,17922,17923,17924,17925,17926,17927,17928,17929,17930,17931,17933,17934,17935,17937,17938,17939,17941,17942,17943,17955,17956,17957,17958,17959,17960,17961,17962,17963,17964,17965,17966,17967,17969,17970,17971,17979,17980,17981,17982,17983,17984,17985,17986,17988,17989,17990,17991,17992,17993,17994,17995,17996,17997,17998,17999,18000,18001,18003,18004,18005,18007,18008,18009,18011,18012,18013,4371,17987,30709) 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 28
?q=Scania R-Series - Chassi&page=###page###
184
SELECT `id`, `name`, `type` FROM nox_group