/var/www/html/nox-modules/prints
/lib/action/frontend
/printsBlueprintsSubcategoryAction.action.php
SELECT `id`, `db_table`, `enabled`, `url`, `name`, `name_singular`, `category_image` FROM prints_class WHERE `enabled`='1' AND `url`='car'
SELECT `id`, `class_id`, `country_id`, `url`, `name`, `logo`, `top`, `blueprints_count`, `vectors_count`, `downloads_count`, `purchases_count` FROM prints_make WHERE `url`='lifan' AND `class_id`='1' ORDER BY name
SELECT `id`, `class_id`, `country_id`, `url`, `name`, `logo`, `top`, `blueprints_count`, `vectors_count`, `downloads_count`, `purchases_count` FROM prints_make WHERE class_id = 1 AND ((vectors_count > 0) OR (blueprints_count > 0) OR (id IN (SELECT make_id FROM `prints_request_vector`))) ORDER BY name
SELECT `id`, `make_id`, `year`, `end`, `class`, `body` FROM prints_class_car WHERE `make_id`='170'
SELECT id, url, sort_name, full_name, views FROM prints_blueprint WHERE `item_id` IN('7757','7758','7759','7760','7761','7762','7763','16263','22463','22464','22465','22466','22467','22468','22469','22470','22471','22472','22473','22474','22475','22476','22477','22478','22479','22480','22481','22482','22483','22484','22485','22486','22487','22488','22489','22490','22491','24789','24790','24791','24792','24793','24794','24795','24796','24797','24798','24799','24800','24801') AND `class_id`='1'
SELECT id, url, sort_name, full_name, views, prepay FROM prints_vector WHERE `item_id` IN('7757','7758','7759','7760','7761','7762','7763','16263','22463','22464','22465','22466','22467','22468','22469','22470','22471','22472','22473','22474','22475','22476','22477','22478','22479','22480','22481','22482','22483','22484','22485','22486','22487','22488','22489','22490','22491','24789','24790','24791','24792','24793','24794','24795','24796','24797','24798','24799','24800','24801') AND `class_id`='1'
SELECT name FROM prints_make WHERE `id`='170'
SELECT `id`, `url`, `name_title`, `name_full`, `id_new`, `set_market_mid`, `tier`, `update_date`, `set_segment`, `set_market`, `set_body_segment` FROM prints_set WHERE `name_full` LIKE "Lifan%" ORDER BY name_title
?page=###page###
SELECT COUNT(*) as `count` FROM brv_summary_cache WHERE `make_id`='170'
56
SELECT `id`, `name`, `full_name`, `sort_name`, `make_id`, `url`, `views`, `type` FROM brv_summary_cache WHERE `make_id`='170' ORDER BY `sort_name`, `type` LIMIT 0, 100
SELECT `tag_id`, `category_id` FROM tag_categoryitem WHERE `category_id`='1'
SELECT `id`, `tag` FROM tag WHERE `id` IN('64','65','66','67','68','69','70','71','72','73','74','75','76','77','78','79','80','81','289','290','291')
SELECT `tag_id`, `make_id` FROM tag_make WHERE `make_id`='170'
SELECT `id`, `tag` FROM tag WHERE `id` IN('196')
SELECT DISTINCT `purchase_id` FROM payment WHERE `status`='approved' AND `purchase_id` IN('4532','4533','4534','4535','4536','4537','4538','4539','4540','4541','4542','4543','4544','4545','4546','4547','4548','4549','4550','4551','4552','4553','4554','4555','4556','4557','4558','4559','4560','6861','6862','6863','6864','6865','6866','6867','6868','6869','6870','6871','6872','6873')
SELECT `id`, `class_id`, `item_id`, `name`, `name_version`, `name_spec`, `full_name`, `sort_name`, `url`, `preview`, `filename`, `large_preview`, `detail`, `vector_dwg`, `wrap_template`, `views`, `scale`, `ext`, `copyright_type`, `copyright_url`, `copyright_text`, `added_date`, `update_date`, `updated_by`, `views_count`, `downloads_count`, `add_user_id`, `price`, `prepay`, `prm`, `flag`, `comment`, `bundle`, `bundle_text`, `item_market_mid`, `item_segment`, `tier`, `make_source`, `item_market`, `item_body_segment`, `make_source_id`, `make_source_filename` FROM prints_vector WHERE `prepay`=0 AND `id` IN('4532','4533','4534','4535','4536','4537','4538','4539','4540','4541','4542','4543','4544','4545','4546','4547','4548','4549','4550','4551','4552','4553','4554','4555','4556','4557','4558','4559','4560','6861','6862','6863','6864','6865','6866','6867','6868','6869','6870','6871','6872','6873')
SELECT `id`, `class_id`, `item_id`, `name`, `name_version`, `name_spec`, `full_name`, `sort_name`, `url`, `preview`, `filename`, `large_preview`, `detail`, `vector_dwg`, `wrap_template`, `views`, `scale`, `ext`, `copyright_type`, `copyright_url`, `copyright_text`, `added_date`, `update_date`, `updated_by`, `views_count`, `downloads_count`, `add_user_id`, `price`, `prepay`, `prm`, `flag`, `comment`, `bundle`, `bundle_text`, `item_market_mid`, `item_segment`, `tier`, `make_source`, `item_market`, `item_body_segment`, `make_source_id`, `make_source_filename` FROM prints_vector WHERE `prepay`=1 AND `id` IN('4532','4533','4534','4535','4536','4537','4538','4539','4540','4541','4542','4543','4544','4545','4546','4547','4548','4549','4550','4551','4552','4553','4554','4555','4556','4557','4558','4559','4560','6861','6862','6863','6864','6865','6866','6867','6868','6869','6870','6871','6872','6873')
SELECT set_id FROM prints_set_vector WHERE `vector_id`='6872'
SELECT `id`, `class_id`, `item_id`, `name`, `name_version`, `name_spec`, `full_name`, `sort_name`, `url`, `preview`, `filename`, `large_preview`, `detail`, `vector_dwg`, `wrap_template`, `views`, `scale`, `ext`, `copyright_type`, `copyright_url`, `copyright_text`, `added_date`, `update_date`, `updated_by`, `views_count`, `downloads_count`, `add_user_id`, `price`, `prepay`, `prm`, `flag`, `comment`, `bundle`, `bundle_text`, `item_market_mid`, `item_segment`, `tier`, `make_source`, `item_market`, `item_body_segment`, `make_source_id`, `make_source_filename` FROM prints_vector WHERE `id`='6872'
SELECT `id`, `name_full` FROM `prints_set` WHERE "2014 lifan 530 sedan" LIKE CONCAT(LOWER(`name_full`), "%") ORDER BY CHAR_LENGTH(`name_full`) DESC, `id` ASC LIMIT 1
SELECT `id`, `class_id`, `item_id`, `name`, `name_version`, `name_spec`, `full_name`, `sort_name`, `url`, `preview`, `filename`, `large_preview`, `detail`, `vector_dwg`, `wrap_template`, `views`, `scale`, `ext`, `copyright_type`, `copyright_url`, `copyright_text`, `added_date`, `update_date`, `updated_by`, `views_count`, `downloads_count`, `add_user_id`, `price`, `prepay`, `prm`, `flag`, `comment`, `bundle`, `bundle_text`, `item_market_mid`, `item_segment`, `tier`, `make_source`, `item_market`, `item_body_segment`, `make_source_id`, `make_source_filename` FROM prints_vector WHERE `id`='6872'
SELECT set_id FROM prints_set_vector WHERE `vector_id`='4538'
SELECT `id`, `class_id`, `item_id`, `name`, `name_version`, `name_spec`, `full_name`, `sort_name`, `url`, `preview`, `filename`, `large_preview`, `detail`, `vector_dwg`, `wrap_template`, `views`, `scale`, `ext`, `copyright_type`, `copyright_url`, `copyright_text`, `added_date`, `update_date`, `updated_by`, `views_count`, `downloads_count`, `add_user_id`, `price`, `prepay`, `prm`, `flag`, `comment`, `bundle`, `bundle_text`, `item_market_mid`, `item_segment`, `tier`, `make_source`, `item_market`, `item_body_segment`, `make_source_id`, `make_source_filename` FROM prints_vector WHERE `id`='4538'
SELECT `id`, `name_full` FROM `prints_set` WHERE "2017 lifan 820 sedan" LIKE CONCAT(LOWER(`name_full`), "%") ORDER BY CHAR_LENGTH(`name_full`) DESC, `id` ASC LIMIT 1
SELECT `id`, `class_id`, `item_id`, `name`, `name_version`, `name_spec`, `full_name`, `sort_name`, `url`, `preview`, `filename`, `large_preview`, `detail`, `vector_dwg`, `wrap_template`, `views`, `scale`, `ext`, `copyright_type`, `copyright_url`, `copyright_text`, `added_date`, `update_date`, `updated_by`, `views_count`, `downloads_count`, `add_user_id`, `price`, `prepay`, `prm`, `flag`, `comment`, `bundle`, `bundle_text`, `item_market_mid`, `item_segment`, `tier`, `make_source`, `item_market`, `item_body_segment`, `make_source_id`, `make_source_filename` FROM prints_vector WHERE `id`='4538'
SELECT set_id FROM prints_set_vector WHERE `vector_id`='4535'
SELECT `id`, `url`, `name_title`, `name_full`, `id_new`, `set_market_mid`, `tier`, `update_date`, `set_segment`, `set_market`, `set_body_segment` FROM prints_set WHERE `id`='5269' ORDER BY name_title
SELECT `preview` FROM `prints_vector` WHERE `id` IN(SELECT `vector_id` FROM `prints_set_vector` WHERE `set_id` = 5269) AND `prepay` = 0 AND `bundle` = 0 ORDER BY CAST(JSON_EXTRACT(`prm`, "$.year") AS UNSIGNED) DESC LIMIT 1
SELECT set_id FROM prints_set_vector WHERE `vector_id`='4547'
SELECT `id`, `url`, `name_title`, `name_full`, `id_new`, `set_market_mid`, `tier`, `update_date`, `set_segment`, `set_market`, `set_body_segment` FROM prints_set WHERE `id`='7254' ORDER BY name_title
SELECT `preview` FROM `prints_vector` WHERE `id` IN(SELECT `vector_id` FROM `prints_set_vector` WHERE `set_id` = 7254) AND `prepay` = 0 AND `bundle` = 0 ORDER BY CAST(JSON_EXTRACT(`prm`, "$.year") AS UNSIGNED) DESC LIMIT 1
SELECT set_id FROM prints_set_vector WHERE `vector_id`='4548'
SELECT `id`, `class_id`, `item_id`, `name`, `name_version`, `name_spec`, `full_name`, `sort_name`, `url`, `preview`, `filename`, `large_preview`, `detail`, `vector_dwg`, `wrap_template`, `views`, `scale`, `ext`, `copyright_type`, `copyright_url`, `copyright_text`, `added_date`, `update_date`, `updated_by`, `views_count`, `downloads_count`, `add_user_id`, `price`, `prepay`, `prm`, `flag`, `comment`, `bundle`, `bundle_text`, `item_market_mid`, `item_segment`, `tier`, `make_source`, `item_market`, `item_body_segment`, `make_source_id`, `make_source_filename` FROM prints_vector WHERE `id`='4548'
SELECT `id`, `name_full` FROM `prints_set` WHERE "2015 lifan x50 suv" LIKE CONCAT(LOWER(`name_full`), "%") ORDER BY CHAR_LENGTH(`name_full`) DESC, `id` ASC LIMIT 1
SELECT `id`, `class_id`, `item_id`, `name`, `name_version`, `name_spec`, `full_name`, `sort_name`, `url`, `preview`, `filename`, `large_preview`, `detail`, `vector_dwg`, `wrap_template`, `views`, `scale`, `ext`, `copyright_type`, `copyright_url`, `copyright_text`, `added_date`, `update_date`, `updated_by`, `views_count`, `downloads_count`, `add_user_id`, `price`, `prepay`, `prm`, `flag`, `comment`, `bundle`, `bundle_text`, `item_market_mid`, `item_segment`, `tier`, `make_source`, `item_market`, `item_body_segment`, `make_source_id`, `make_source_filename` FROM prints_vector WHERE `id`='4548'
SELECT set_id FROM prints_set_vector WHERE `vector_id`='4541'
SELECT `id`, `class_id`, `item_id`, `name`, `name_version`, `name_spec`, `full_name`, `sort_name`, `url`, `preview`, `filename`, `large_preview`, `detail`, `vector_dwg`, `wrap_template`, `views`, `scale`, `ext`, `copyright_type`, `copyright_url`, `copyright_text`, `added_date`, `update_date`, `updated_by`, `views_count`, `downloads_count`, `add_user_id`, `price`, `prepay`, `prm`, `flag`, `comment`, `bundle`, `bundle_text`, `item_market_mid`, `item_segment`, `tier`, `make_source`, `item_market`, `item_body_segment`, `make_source_id`, `make_source_filename` FROM prints_vector WHERE `id`='4541'
SELECT `id`, `name_full` FROM `prints_set` WHERE "2017 lifan lotto minivan" LIKE CONCAT(LOWER(`name_full`), "%") ORDER BY CHAR_LENGTH(`name_full`) DESC, `id` ASC LIMIT 1
SELECT `id`, `class_id`, `item_id`, `name`, `name_version`, `name_spec`, `full_name`, `sort_name`, `url`, `preview`, `filename`, `large_preview`, `detail`, `vector_dwg`, `wrap_template`, `views`, `scale`, `ext`, `copyright_type`, `copyright_url`, `copyright_text`, `added_date`, `update_date`, `updated_by`, `views_count`, `downloads_count`, `add_user_id`, `price`, `prepay`, `prm`, `flag`, `comment`, `bundle`, `bundle_text`, `item_market_mid`, `item_segment`, `tier`, `make_source`, `item_market`, `item_body_segment`, `make_source_id`, `make_source_filename` FROM prints_vector WHERE `id`='4541'
SELECT set_id FROM prints_set_vector WHERE `vector_id`='6863'
SELECT `id`, `url`, `name_title`, `name_full`, `id_new`, `set_market_mid`, `tier`, `update_date`, `set_segment`, `set_market`, `set_body_segment` FROM prints_set WHERE `id`='7245' ORDER BY name_title
SELECT `preview` FROM `prints_vector` WHERE `id` IN(SELECT `vector_id` FROM `prints_set_vector` WHERE `set_id` = 7245) AND `prepay` = 0 AND `bundle` = 0 ORDER BY CAST(JSON_EXTRACT(`prm`, "$.year") AS UNSIGNED) DESC LIMIT 1
SELECT set_id FROM prints_set_vector WHERE `vector_id`='4537'
SELECT `id`, `url`, `name_title`, `name_full`, `id_new`, `set_market_mid`, `tier`, `update_date`, `set_segment`, `set_market`, `set_body_segment` FROM prints_set WHERE `id`='7251' ORDER BY name_title
SELECT `preview` FROM `prints_vector` WHERE `id` IN(SELECT `vector_id` FROM `prints_set_vector` WHERE `set_id` = 7251) AND `prepay` = 0 AND `bundle` = 0 ORDER BY CAST(JSON_EXTRACT(`prm`, "$.year") AS UNSIGNED) DESC LIMIT 1
SELECT set_id FROM prints_set_vector WHERE `vector_id`='4557'
SELECT `id`, `url`, `name_title`, `name_full`, `id_new`, `set_market_mid`, `tier`, `update_date`, `set_segment`, `set_market`, `set_body_segment` FROM prints_set WHERE `id`='5285' ORDER BY name_title
SELECT `preview` FROM `prints_vector` WHERE `id` IN(SELECT `vector_id` FROM `prints_set_vector` WHERE `set_id` = 5285) AND `prepay` = 0 AND `bundle` = 0 ORDER BY CAST(JSON_EXTRACT(`prm`, "$.year") AS UNSIGNED) DESC LIMIT 1
SELECT set_id FROM prints_set_vector WHERE `vector_id`='4532'
SELECT `id`, `url`, `name_title`, `name_full`, `id_new`, `set_market_mid`, `tier`, `update_date`, `set_segment`, `set_market`, `set_body_segment` FROM prints_set WHERE `id`='5269' ORDER BY name_title
SELECT `preview` FROM `prints_vector` WHERE `id` IN(SELECT `vector_id` FROM `prints_set_vector` WHERE `set_id` = 5269) AND `prepay` = 0 AND `bundle` = 0 ORDER BY CAST(JSON_EXTRACT(`prm`, "$.year") AS UNSIGNED) DESC LIMIT 1
SELECT set_id FROM prints_set_vector WHERE `vector_id`='4550'
SELECT `id`, `url`, `name_title`, `name_full`, `id_new`, `set_market_mid`, `tier`, `update_date`, `set_segment`, `set_market`, `set_body_segment` FROM prints_set WHERE `id`='5280' ORDER BY name_title
SELECT `preview` FROM `prints_vector` WHERE `id` IN(SELECT `vector_id` FROM `prints_set_vector` WHERE `set_id` = 5280) AND `prepay` = 0 AND `bundle` = 0 ORDER BY CAST(JSON_EXTRACT(`prm`, "$.year") AS UNSIGNED) DESC LIMIT 1
SELECT set_id FROM prints_set_vector WHERE `vector_id`='4554'
SELECT `id`, `url`, `name_title`, `name_full`, `id_new`, `set_market_mid`, `tier`, `update_date`, `set_segment`, `set_market`, `set_body_segment` FROM prints_set WHERE `id`='5280' ORDER BY name_title
SELECT `preview` FROM `prints_vector` WHERE `id` IN(SELECT `vector_id` FROM `prints_set_vector` WHERE `set_id` = 5280) AND `prepay` = 0 AND `bundle` = 0 ORDER BY CAST(JSON_EXTRACT(`prm`, "$.year") AS UNSIGNED) DESC LIMIT 1
SELECT set_id FROM prints_set_vector WHERE `vector_id`='4533'
SELECT `id`, `url`, `name_title`, `name_full`, `id_new`, `set_market_mid`, `tier`, `update_date`, `set_segment`, `set_market`, `set_body_segment` FROM prints_set WHERE `id`='5270' ORDER BY name_title
SELECT `preview` FROM `prints_vector` WHERE `id` IN(SELECT `vector_id` FROM `prints_set_vector` WHERE `set_id` = 5270) AND `prepay` = 0 AND `bundle` = 0 ORDER BY CAST(JSON_EXTRACT(`prm`, "$.year") AS UNSIGNED) DESC LIMIT 1
SELECT set_id FROM prints_set_vector WHERE `vector_id`='4558'
SELECT `id`, `url`, `name_title`, `name_full`, `id_new`, `set_market_mid`, `tier`, `update_date`, `set_segment`, `set_market`, `set_body_segment` FROM prints_set WHERE `id`='5285' ORDER BY name_title
SELECT `preview` FROM `prints_vector` WHERE `id` IN(SELECT `vector_id` FROM `prints_set_vector` WHERE `set_id` = 5285) AND `prepay` = 0 AND `bundle` = 0 ORDER BY CAST(JSON_EXTRACT(`prm`, "$.year") AS UNSIGNED) DESC LIMIT 1
SELECT set_id FROM prints_set_vector WHERE `vector_id`='4534'
SELECT `id`, `url`, `name_title`, `name_full`, `id_new`, `set_market_mid`, `tier`, `update_date`, `set_segment`, `set_market`, `set_body_segment` FROM prints_set WHERE `id`='7251' ORDER BY name_title
SELECT `preview` FROM `prints_vector` WHERE `id` IN(SELECT `vector_id` FROM `prints_set_vector` WHERE `set_id` = 7251) AND `prepay` = 0 AND `bundle` = 0 ORDER BY CAST(JSON_EXTRACT(`prm`, "$.year") AS UNSIGNED) DESC LIMIT 1
SELECT set_id FROM prints_set_vector WHERE `vector_id`='4555'
SELECT `id`, `class_id`, `item_id`, `name`, `name_version`, `name_spec`, `full_name`, `sort_name`, `url`, `preview`, `filename`, `large_preview`, `detail`, `vector_dwg`, `wrap_template`, `views`, `scale`, `ext`, `copyright_type`, `copyright_url`, `copyright_text`, `added_date`, `update_date`, `updated_by`, `views_count`, `downloads_count`, `add_user_id`, `price`, `prepay`, `prm`, `flag`, `comment`, `bundle`, `bundle_text`, `item_market_mid`, `item_segment`, `tier`, `make_source`, `item_market`, `item_body_segment`, `make_source_id`, `make_source_filename` FROM prints_vector WHERE `id`='4555'
SELECT `id`, `name_full` FROM `prints_set` WHERE "2017 lifan x7 suv" LIKE CONCAT(LOWER(`name_full`), "%") ORDER BY CHAR_LENGTH(`name_full`) DESC, `id` ASC LIMIT 1
SELECT `id`, `class_id`, `item_id`, `name`, `name_version`, `name_spec`, `full_name`, `sort_name`, `url`, `preview`, `filename`, `large_preview`, `detail`, `vector_dwg`, `wrap_template`, `views`, `scale`, `ext`, `copyright_type`, `copyright_url`, `copyright_text`, `added_date`, `update_date`, `updated_by`, `views_count`, `downloads_count`, `add_user_id`, `price`, `prepay`, `prm`, `flag`, `comment`, `bundle`, `bundle_text`, `item_market_mid`, `item_segment`, `tier`, `make_source`, `item_market`, `item_body_segment`, `make_source_id`, `make_source_filename` FROM prints_vector WHERE `id`='4555'
SELECT `id`, `name`, `type` FROM nox_group