/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`='chrysler' 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`='28'
SELECT id, url, sort_name, full_name, views FROM prints_blueprint WHERE `item_id` IN('962','963','964','965','966','967','968','969','970','971','972','973','974','975','976','977','978','979','980','981','982','983','984','985','986','987','988','989','990','991','992','993','994','995','996','997','998','999','1000','1001','1002','1003','1004','1005','1006','1007','1008','1009','1010','1011','1012','1013','1014','1015','1016','1017','1018','1019','1020','1021','1022','2248','2255','8039','8040','8041','8043','8151','8152','8153','8154','8155','8156','8157','8158','8159','8160','8161','8162','8163','8164','8165','8166','8167','8168','8169','8170','8171','8172','8173','8174','8175','8176','8177','8178','8179','8180','8181','8182','8183','8184','8185','8186','8187','8188','8189','8190','8191','8192','8193','8194','8195','8196','8197','8198','8199','8200','8201','8202','8203','8204','8205','8206','8207','8208','8209','8210','8211','8212','8213','8214','8215','8216','12945','12946','13270','13861','13862','15747','15748','15749','15750','16136','17381','19934','21973','21974','22118','23953','23954','23957','23958','23959','23960','23961','23963','23964','23965','23968','23969','23970','23971','23972','23973','23974','23975','23976','23977','23978','23979','23980','23981','23982','23983','23984','23985','23986','23987','23988','23989','23990','23991','23992','23993','23994','23995','23996','23997','23998','23999','24000','24001','24002','24003','24004','24006','24007','24008','24009','24010','24011','24012','24013','24014','24015','24016','24017','24018','25628','25629','25630','25634','25635','25636','25637','25638','25639','25640','25641','25642','25664','25665','25666','25667','29736','29737','29738','29739','29740','29741','32190','32191','32192','32193','32194','32195','32196','32197','32198','32199','32200','32201','32202','32203','32204','32205','32206','32207','32208','32209','32210','32211','32212','32213','32214','32215','32216','32217','32218','32219','32220','32221','32222','32223','32224','32225','32226','32227','32228','32229','32230','32231','32232','32233','32234','32235','32236','32237','32238','32239','32240','32241','32242','32243','32244','32245','32246','32247','32248','32249','32250','32251','32252','32253','32254','32255','32256','32257','32258','32259','32260','32261','32262','32263','32264','32265','32266','32267','32268','32270','32280','32281','32453','32462','32463','32464','32465','32470','32471','45876','45877','47303','47381','49935','49936','49937','49938','49939','49940','49941','49942','50790','50942','50943','55706','55707','55708','55709','55710','55711','55712','55713','55714','55715','55716','55717','55718','55719','55720','55721','55722','55723','55724','55725','55726','55727','55728','55729','55730','55731','55732','55733','55734','55735','55736','55737','55738','55739','55740','55741','55742','55743','55744','55745','55746','55747','55748','55749','55750','55751','55752','55753','55754','55755','55756','55757','55758','55759','55760','55761','55762','55763','55764','55765','55766','55767','55768','55769','55770','55771','55772','55773','55774','55775','55776','55777','55778','55779','55780','55781','55782','55783','55784','55785','55786','55787','55788','55789','55790','55791','55792','55793','55794','55795','55796','55797','55798','55799','55800','55801','55802','55803','55804','61997','62017','62018') AND `class_id`='1'
SELECT id, url, sort_name, full_name, views, prepay FROM prints_vector WHERE `item_id` IN('962','963','964','965','966','967','968','969','970','971','972','973','974','975','976','977','978','979','980','981','982','983','984','985','986','987','988','989','990','991','992','993','994','995','996','997','998','999','1000','1001','1002','1003','1004','1005','1006','1007','1008','1009','1010','1011','1012','1013','1014','1015','1016','1017','1018','1019','1020','1021','1022','2248','2255','8039','8040','8041','8043','8151','8152','8153','8154','8155','8156','8157','8158','8159','8160','8161','8162','8163','8164','8165','8166','8167','8168','8169','8170','8171','8172','8173','8174','8175','8176','8177','8178','8179','8180','8181','8182','8183','8184','8185','8186','8187','8188','8189','8190','8191','8192','8193','8194','8195','8196','8197','8198','8199','8200','8201','8202','8203','8204','8205','8206','8207','8208','8209','8210','8211','8212','8213','8214','8215','8216','12945','12946','13270','13861','13862','15747','15748','15749','15750','16136','17381','19934','21973','21974','22118','23953','23954','23957','23958','23959','23960','23961','23963','23964','23965','23968','23969','23970','23971','23972','23973','23974','23975','23976','23977','23978','23979','23980','23981','23982','23983','23984','23985','23986','23987','23988','23989','23990','23991','23992','23993','23994','23995','23996','23997','23998','23999','24000','24001','24002','24003','24004','24006','24007','24008','24009','24010','24011','24012','24013','24014','24015','24016','24017','24018','25628','25629','25630','25634','25635','25636','25637','25638','25639','25640','25641','25642','25664','25665','25666','25667','29736','29737','29738','29739','29740','29741','32190','32191','32192','32193','32194','32195','32196','32197','32198','32199','32200','32201','32202','32203','32204','32205','32206','32207','32208','32209','32210','32211','32212','32213','32214','32215','32216','32217','32218','32219','32220','32221','32222','32223','32224','32225','32226','32227','32228','32229','32230','32231','32232','32233','32234','32235','32236','32237','32238','32239','32240','32241','32242','32243','32244','32245','32246','32247','32248','32249','32250','32251','32252','32253','32254','32255','32256','32257','32258','32259','32260','32261','32262','32263','32264','32265','32266','32267','32268','32270','32280','32281','32453','32462','32463','32464','32465','32470','32471','45876','45877','47303','47381','49935','49936','49937','49938','49939','49940','49941','49942','50790','50942','50943','55706','55707','55708','55709','55710','55711','55712','55713','55714','55715','55716','55717','55718','55719','55720','55721','55722','55723','55724','55725','55726','55727','55728','55729','55730','55731','55732','55733','55734','55735','55736','55737','55738','55739','55740','55741','55742','55743','55744','55745','55746','55747','55748','55749','55750','55751','55752','55753','55754','55755','55756','55757','55758','55759','55760','55761','55762','55763','55764','55765','55766','55767','55768','55769','55770','55771','55772','55773','55774','55775','55776','55777','55778','55779','55780','55781','55782','55783','55784','55785','55786','55787','55788','55789','55790','55791','55792','55793','55794','55795','55796','55797','55798','55799','55800','55801','55802','55803','55804','61997','62017','62018') AND `class_id`='1'
SELECT name FROM prints_make WHERE `id`='28'
SELECT `id`, `url`, `name_title`, `name_full`, `id_new`, `market`, `tier`, `update_date`, `segment` FROM prints_set WHERE `name_full` LIKE "Chrysler%" ORDER BY name_title
?page=###page###
SELECT COUNT(*) as `count` FROM brv_summary_cache WHERE `make_id`='28'
584
SELECT `id`, `name`, `full_name`, `sort_name`, `make_id`, `url`, `views`, `type` FROM brv_summary_cache WHERE `make_id`='28' ORDER BY `sort_name`, `type` LIMIT 100, 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`='28'
SELECT `id`, `tag` FROM tag WHERE `id` IN('518','873','874','875')
SELECT DISTINCT `purchase_id` FROM payment WHERE `status`='approved' AND `purchase_id` IN('1982','4021','4022','4179','6025','6026','6029','6030','6031','6032','6033','6035','6036','6037','6040','6041','6042','6043','6044','6045','6046','6047','6048','6049','6050','6051','6052','6053','6054','6055','6056','6057','6058','6059','6060','6061','6062','6063','6064','6065','6066','6067','6068','6069','6070','6071','6072','6073','6074','6075','6076','6078','6079','6080','6081','6082','6083','6084','6085','6086','6087','6088','6089','6090','7700','7701','7702','7706','7707','7708','7709','7710','7711','7712','7713','7714','7736','7737','7738','7739','11809','11810','11811','11812','11813','11814','14266','14267','14268','14269','14270','14271','14272','14273','14274','14275','14276','14277','14278','14279','14280','14281','14282','14283','14284','14285','14286','14287','14288','14289','14290','14291','14292','14293','14294','14295','14296','14297','14298','14299','14300','14301','14302','14303','14304','14305','14306','14307','14308','14309','14310','14311','14312','14313','14314','14315','14316','14317','14318','14319','14320','14321','14322','14323','14324','14325','14326','14327','14328','14329','14330','14331','14332','14333','14334','14335','14336','14337','14338','14339','14340','14341','14342','14343','14344','14346','14356','14357','14529','14538','14539','14540','14541','14546','14547','27967','27968','29371','29449','31352','31499','31500','31832','31852','31853')
SELECT `id`, `url`, `name_title`, `name_full`, `id_new`, `market`, `tier`, `update_date`, `segment` FROM prints_set WHERE id IN(SELECT set_id FROM prints_set_vector WHERE vector_id = 27967) ORDER BY name_title
SELECT `preview` FROM `prints_vector` WHERE `id` IN(SELECT `vector_id` FROM `prints_set_vector` WHERE `set_id` = 29594) AND `prepay` = 0 AND `bundle` = 0 ORDER BY CAST(JSON_EXTRACT(`prm`, "$.year") AS UNSIGNED) DESC LIMIT 1
SELECT vector_id FROM prints_set_vector WHERE `set_id`='29594'
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`, `market`, `segment`, `tier`, `make_source` FROM prints_vector WHERE `id` IN('14267','14268','14269','14270','14271','14272','14273','14274','14275','14276','14277','14278','14279','14280','14281','14282','14283','14284','14285','14286','14287','14288','14289','14290','14291','14292','14293','14294','14295','14296','14297','14298','14299','14300','14301','14302','14303','14304','14305','14306','14307','14308','14309','14310','14311','14312','14313','14314','14315','14316','14317','14318','14319','14320','14321','14322','14323','14324','14325','14326','14327','14328','14329','14330','14331','14332','14333','14334','14335','14336','14337','14338','14339','14340','14341','14342','14343','27967','27968') ORDER BY price LIMIT 0, 1
SELECT `id`, `url`, `name_title`, `name_full`, `id_new`, `market`, `tier`, `update_date`, `segment` FROM prints_set WHERE id IN(SELECT set_id FROM prints_set_vector WHERE vector_id = 6041) ORDER BY name_title
SELECT `preview` FROM `prints_vector` WHERE `id` IN(SELECT `vector_id` FROM `prints_set_vector` WHERE `set_id` = 6642) AND `prepay` = 0 AND `bundle` = 0 ORDER BY CAST(JSON_EXTRACT(`prm`, "$.year") AS UNSIGNED) DESC LIMIT 1
SELECT `id`, `url`, `name_title`, `name_full`, `id_new`, `market`, `tier`, `update_date`, `segment` FROM prints_set WHERE id IN(SELECT set_id FROM prints_set_vector WHERE vector_id = 14538) ORDER BY name_title
SELECT `preview` FROM `prints_vector` WHERE `id` IN(SELECT `vector_id` FROM `prints_set_vector` WHERE `set_id` = 15042) AND `prepay` = 0 AND `bundle` = 0 ORDER BY CAST(JSON_EXTRACT(`prm`, "$.year") AS UNSIGNED) DESC LIMIT 1
SELECT `id`, `url`, `name_title`, `name_full`, `id_new`, `market`, `tier`, `update_date`, `segment` FROM prints_set WHERE id IN(SELECT set_id FROM prints_set_vector WHERE vector_id = 6055) ORDER BY name_title
SELECT `preview` FROM `prints_vector` WHERE `id` IN(SELECT `vector_id` FROM `prints_set_vector` WHERE `set_id` = 14814) AND `prepay` = 0 AND `bundle` = 0 ORDER BY CAST(JSON_EXTRACT(`prm`, "$.year") AS UNSIGNED) DESC LIMIT 1
SELECT `id`, `url`, `name_title`, `name_full`, `id_new`, `market`, `tier`, `update_date`, `segment` FROM prints_set WHERE id IN(SELECT set_id FROM prints_set_vector WHERE vector_id = 6031) ORDER BY name_title
SELECT `preview` FROM `prints_vector` WHERE `id` IN(SELECT `vector_id` FROM `prints_set_vector` WHERE `set_id` = 28827) AND `prepay` = 0 AND `bundle` = 0 ORDER BY CAST(JSON_EXTRACT(`prm`, "$.year") AS UNSIGNED) DESC LIMIT 1
SELECT vector_id FROM prints_set_vector WHERE `set_id`='28827'
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`, `market`, `segment`, `tier`, `make_source` FROM prints_vector WHERE `id` IN('6030','6031','6032') ORDER BY price LIMIT 0, 1
SELECT `id`, `url`, `name_title`, `name_full`, `id_new`, `market`, `tier`, `update_date`, `segment` FROM prints_set WHERE id IN(SELECT set_id FROM prints_set_vector WHERE vector_id = 6054) ORDER BY name_title
SELECT `preview` FROM `prints_vector` WHERE `id` IN(SELECT `vector_id` FROM `prints_set_vector` WHERE `set_id` = 36027) AND `prepay` = 0 AND `bundle` = 0 ORDER BY CAST(JSON_EXTRACT(`prm`, "$.year") AS UNSIGNED) DESC LIMIT 1
SELECT vector_id FROM prints_set_vector WHERE `set_id`='36027'
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`, `market`, `segment`, `tier`, `make_source` FROM prints_vector WHERE `id` IN('6053','6054','29371','31352','31832') ORDER BY price LIMIT 0, 1
SELECT `id`, `url`, `name_title`, `name_full`, `id_new`, `market`, `tier`, `update_date`, `segment` FROM prints_set WHERE id IN(SELECT set_id FROM prints_set_vector WHERE vector_id = 14274) ORDER BY name_title
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`, `market`, `segment`, `tier`, `make_source` FROM prints_vector WHERE `prepay`=0 AND `id` IN('1982','4021','4022','4179','6025','6026','6029','6030','6032','6033','6035','6036','6037','6040','6042','6043','6044','6045','6046','6047','6048','6049','6050','6051','6052','6053','6056','6057','6058','6059','6060','6061','6062','6063','6064','6065','6066','6067','6068','6069','6070','6071','6072','6073','6074','6075','6076','6078','6079','6080','6081','6082','6083','6084','6085','6086','6087','6088','6089','6090','7700','7701','7702','7706','7707','7708','7709','7710','7711','7712','7713','7714','7736','7737','7738','7739','11809','11810','11811','11812','11813','11814','14266','14267','14268','14269','14270','14271','14272','14273','14275','14276','14277','14278','14279','14280','14281','14282','14283','14284','14285','14286','14287','14288','14289','14290','14291','14292','14293','14294','14295','14296','14297','14298','14299','14300','14301','14302','14303','14304','14305','14306','14307','14308','14309','14310','14311','14312','14313','14314','14315','14316','14317','14318','14319','14320','14321','14322','14323','14324','14325','14326','14327','14328','14329','14330','14331','14332','14333','14334','14335','14336','14337','14338','14339','14340','14341','14342','14343','14344','14346','14356','14357','14529','14539','14540','14541','14546','14547','27968','29371','29449','31352','31499','31500','31832','31852','31853')
SELECT `id`, `url`, `name_title`, `name_full`, `id_new`, `market`, `tier`, `update_date`, `segment` FROM prints_set WHERE id IN(SELECT set_id FROM prints_set_vector WHERE vector_id = 6029) ORDER BY name_title
SELECT `preview` FROM `prints_vector` WHERE `id` IN(SELECT `vector_id` FROM `prints_set_vector` WHERE `set_id` = 6636) AND `prepay` = 0 AND `bundle` = 0 ORDER BY CAST(JSON_EXTRACT(`prm`, "$.year") AS UNSIGNED) DESC LIMIT 1
SELECT vector_id FROM prints_set_vector WHERE `set_id`='6636'
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`, `market`, `segment`, `tier`, `make_source` FROM prints_vector WHERE `id` IN('6025','6026','6029') ORDER BY price LIMIT 0, 1
SELECT `id`, `url`, `name_title`, `name_full`, `id_new`, `market`, `tier`, `update_date`, `segment` FROM prints_set WHERE id IN(SELECT set_id FROM prints_set_vector WHERE vector_id = 31852) ORDER BY name_title
SELECT `preview` FROM `prints_vector` WHERE `id` IN(SELECT `vector_id` FROM `prints_set_vector` WHERE `set_id` = 36349) AND `prepay` = 0 AND `bundle` = 0 ORDER BY CAST(JSON_EXTRACT(`prm`, "$.year") AS UNSIGNED) DESC LIMIT 1
SELECT vector_id FROM prints_set_vector WHERE `set_id`='36349'
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`, `market`, `segment`, `tier`, `make_source` FROM prints_vector WHERE `id` IN('31852','31853') ORDER BY price LIMIT 0, 1
SELECT `id`, `name`, `type` FROM nox_group