/var/www/html/nox-modules/prints
/lib/action/frontend
/printsVectorSubcategoryAction.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`='dodge' 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 (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`='42'
SELECT id, url, sort_name, full_name, views, prepay FROM prints_vector WHERE `item_id` IN('2241','2261','2266','2268','2271','2282','2290','2293','2297','2304','2308','2310','2313','2315','2319','2322','2324','2326','2328','2331','2332','2334','2335','2361','2362','2363','2364','2365','2366','2367','2368','2369','2370','2371','2372','2373','2374','2375','2376','2377','2378','2379','2380','2381','2382','2383','2385','2386','2389','2699','2700','2701','2702','2703','2704','2705','2706','2707','2708','2709','2710','2711','2712','2713','2714','2715','2716','2717','2718','2719','2720','2721','2722','2723','2724','2725','2726','2727','2728','2729','2730','2731','2732','2733','2734','2735','2736','2737','2738','2739','2740','2741','2742','2743','2744','2745','2746','2747','2748','2749','2750','2751','2752','2753','2754','2755','2756','2847','2848','2849','2850','2851','2852','2853','2854','2855','2856','2857','2858','2859','2860','2861','2862','2863','2864','2865','2866','2867','2868','2869','2870','2871','2872','2875','2878','2881','2883','2886','2888','2893','2895','2896','2898','2901','2904','2907','2908','2914','2915','2921','2926','2929','2931','2934','2939','2940','2941','2942','2943','2944','2945','2946','2947','2948','2949','2950','2951','2952','2953','2954','2955','2956','2957','2958','2959','2960','2961','2962','2963','2964','2965','2966','2967','2968','2969','2970','2971','2972','2984','2990','2992','2998','3003','3007','8078','8299','8300','8301','8302','8314','8315','8316','8318','8319','8323','8324','8325','8326','8327','8328','8330','8333','8336','8337','8338','8341','8344','8347','8354','8355','8357','8358','8364','8368','8373','8377','8378','8379','8381','8382','8384','8385','8386','8387','8389','8394','8395','8397','8402','8405','8406','8409','8413','8415','8419','8421','8425','8429','8430','8431','8432','8434','8436','8437','8439','8440','8442','8444','8445','8446','8448','8449','8451','8452','8454','8455','8458','8460','8461','8462','8465','8466','8467','8468','8469','8471','8472','8473','8474','8475','8476','8477','8478','8480','8481','8483','8485','8486','8487','8488','8489','8490','8491','8492','8494','8496','8497','8498','8499','8500','8501','8502','8504','8505','8508','8509','8510','8512','8513','8514','8516','8517','8518','8520','8521','8522','8524','8526','8528','8529','8530','8531','8532','8533','8534','8535','8536','8537','8538','8541','8542','8544','8545','8547','8548','8550','8552','8553','8555','8556','8558','8561','8563','8566','8567','8573','8574','8575','8576','8577','8578','8579','8580','8581','8582','8583','8584','8585','8586','8588','8589','8590','12669','12670','12671','12672','12673','12674','12675','12676','12677','12678','12679','12680','12681','13275','13276','13425','13426','13427','13428','13429','13430','13431','13432','13433','13434','13435','13436','13437','13438','13439','13440','13441','13442','13443','13444','13445','13446','13447','13448','13763','13793','13795','13874','13875','13876','16146','16147','16148','16149','16150','16151','16152','17437','17438','17439','17440','17441','17442','17868','17869','17870','17887','17888','18462','18508','18527','19240','19317','19366','19367','19368','19369','19370','19484','19537','19538','19539','19540','19541','19542','19738','19739','19740','19741','19742','19743','19744','19745','19746','19747','19748','19749','19751','19752','19753','19754','19755','19756','19757','19758','19759','19760','19761','19762','19763','19929','20424','20425','20426','20427','20428','20429','20835','20933','20934','20935','20936','20937','20938','20939','20940','20941','22025','22137','22162','23541','23582','23583','23584','23585','23967','24176','24177','24178','24179','24180','24181','24182','24183','24184','24185','24186','24187','24188','24189','24190','24191','24192','24193','24194','24195','24196','24197','24198','24199','24200','24201','24202','24203','24206','24207','24209','24210','24211','24212','24213','24214','24264','24265','24266','24267','24289','24290','24291','24292','25583','25625','25626','25627','25643','25644','25645','25668','25669','25697','25698','25699','25788','26802','26803','26804','26805','29849','29850','29851','29852','29853','29854','29855','29856','29857','29858','29859','29860','30239','30240','30241','30242','30243','30244','30245','30246','30247','30248','30249','30250','30251','30252','30253','30254','30255','30256','30257','30258','30259','30260','30261','30262','30263','30264','30265','30266','30267','30268','30269','30270','30308','30309','30310','30311','30312','30313','30314','30315','30316','30317','30318','30319','30320','30321','30322','30323','30324','30325','30326','30327','30328','30329','30330','30331','30332','30333','30334','30335','30336','30337','30338','30339','30340','30341','30342','30343','30344','30345','30346','30347','30348','30349','30350','30351','30352','30353','30354','30355','30356','30357','30358','30359','30360','30361','30362','30363','30364','30365','32271','32272','32284','32285','32286','32287','32288','32289','32290','32294','32295','32296','32297','32298','32299','32300','32301','32302','32303','32304','32305','32306','32307','32308','32309','32310','32312','32313','32314','32315','32316','32317','32318','32319','32320','32321','32322','32323','32324','32325','32326','32327','32328','32329','32330','32331','32332','32333','32334','32335','32336','32337','32338','32339','32340','32341','32342','32343','32344','32345','32346','32347','32348','32349','32350','32351','32352','32353','32354','32355','32356','32357','32358','32359','32360','32361','32362','32363','32364','32365','32366','32367','32368','32369','32370','32371','32372','32373','32374','32375','32376','32377','32378','32379','32380','32381','32382','32383','32384','32385','32386','32387','32388','32389','32390','32391','32392','32393','32394','32395','32396','32397','32398','32399','32400','32401','32402','32403','32406','32407','32408','32409','32410','32411','32412','32413','32414','32415','32416','32417','32418','32419','32420','32421','32422','32423','32424','32425','32426','32427','32428','32429','32430','32431','32432','32433','32434','32435','32436','32437','32438','32439','32440','32441','32442','32443','32444','32445','32446','32447','32448','32449','32450','32451','32452','32454','32455','32456','32457','32458','32459','32460','32461','32468','32469','32472','32473','32474','32475','33618','33814','45722','45828','45875','46043','46824','46825','46826','47339','47340','47341','47342','47464','47621','47625','47945','48059','48258','48509','48510','48541','49416','49417','49418','49419','49420','49421','49422','49423','49424','49425','49426','49427','49428','49429','49430','49431','49432','49433','49434','49435','49436','49437','49438','49439','49440','49441','49442','49443','49444','49445','49446','49447','49946','49947','49948','49949','49950','49951','49952','49953','49954','49955','49956','49957','49958','49959','49960','49961','49962','49963','49964','49965','49966','49967','49968','49969','49970','49971','49972','49973','49974','49975','49976','49977','49978','49979','49980','49981','49982','49983','49984','50734','50735','51191','52552','52553','52554','52555','52556','52557','52558','52559','52560','52561','52562','52563','52564','52565','52566','52567','52568','52569','52570','52571','52572','52573','52574','52575','52576','56203','56204','56205','56206','56207','56208','56209','56210','56211','56212','56213','56214','56215','56216','56217','56218','56219','56220','56221','56222','56223','56224','56225','56226','56227','56228','56229','56230','56231','56232','56233','56234','56235','56236','56237','56238','56239','56240','56241','56242','56243','56244','56245','56246','56247','56248','56249','56250','56251','56252','56253','56254','56255','56256','56257','56258','56259','56260','56261','56262','56263','56264','56265','56266','56267','56268','56269','56270','56271','56272','56273','56274','56275','56276','56277','56278','56279','56280','56281','56282','56283','56284','56285','56286','56287','56288','56289','56290','56291','56292','56293','56294','56295','56296','56297','56298','56299','56300','56301','56302','56303','56304','56305','56306','56307','56308','56309','56310','56311','56312','56313','56314','56315','56316','56317','56318','56319','56320','56321','56322','56323','56324','56325','56326','56327','56328','56329','56330','56331','56332','56333','56334','56335','56336','56337','56338','56339','56340','56341','56342','56343','56344','56345','56346','56347','56348','61981','61986','61987','61988','61989','61990','61991','61992','61995','61996') AND `class_id`='1'
?page=###page###
SELECT COUNT(*) as `count` FROM brv_summary_cache WHERE `make_id`='42' AND `type` IN('0','1','2')
863
SELECT `id`, `name`, `full_name`, `sort_name`, `make_id`, `url`, `views`, `type` FROM brv_summary_cache WHERE `make_id`='42' AND `type` IN('0','1','2') 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`='1'
SELECT `id`, `tag` FROM tag WHERE `id` IN('91')
SELECT DISTINCT `purchase_id` FROM payment WHERE `status`='approved' AND `purchase_id` IN('549','595','614','1329','1406','1455','1456','1457','1458','1459','1563','1589','1590','1591','1592','1593','1594','1790','1791','1792','1793','1794','1795','1796','1797','1798','1799','1800','1801','1803','1804','1805','1806','1807','1808','1809','1810','1811','1812','1813','1814','1815','1976','2456','2457','2458','2459','2460','2461','2867','2965','2966','2967','2968','2969','2970','2971','2972','2973','4078','4201','4228','5613','5654','5655','5656','5657','6039','6248','6249','6250','6251','6252','6253','6254','6255','6256','6257','6258','6259','6260','6261','6262','6263','6264','6265','6266','6267','6268','6269','6270','6271','6272','6273','6274','6275','6278','6279','6281','6282','6283','6284','6285','6286','6336','6337','6338','6339','6361','6362','6363','6364','7655','7697','7698','7699','7715','7716','7717','7740','7741','7769','7770','7771','7860','8874','8875','8876','8877','11922','11923','11924','11925','11926','11927','11928','11929','11930','11931','11932','11933','12313','12314','12315','12316','12317','12318','12319','12320','12321','12322','12323','12324','12325','12326','12327','12328','12329','12330','12331','12332','12333','12334','12335','12336','12337','12338','12339','12340','12341','12342','12343','12344','12382','12383','12384','12385','12386','12387','12388','12389','12390','12391','12392','12393','12394','12395','12396','12397','12398','12399','12400','12401','12402','12403','12404','12405','12406','12407','12408','12409','12410','12411','12412','12413','12414','12415','12416','12417','12418','12419','12420','12421','12422','12423','12424','12425','12426','12427','12428','12429','12430','12431','12432','12433','12434','12435','12436','12437','12438','12439','14347','14348','14360','14361','14362','14363','14364','14365','14366','14370','14371','14372','14373','14374','14375','14376','14377','14378','14379','14380','14381','14382','14383','14384','14385','14386','14388','14389','14390','14391','14392','14393','14394','14395','14396','14397','14398','14399','14400','14401','14402','14403','14404','14405','14406','14407','14408','14409','14410','14411','14412','14413','14414','14415','14416','14417','14418','14419','14420','14421','14422','14423','14424','14425','14426','14427','14428','14429','14430','14431','14432','14433','14434','14435','14436','14437','14438','14439','14440','14441','14442','14443','14444','14445','14446','14447','14448','14449','14450','14451','14452','14453','14454','14455','14456','14457','14458','14459','14460','14461','14462','14463','14464','14465','14466','14467','14468','14469','14470','14471','14472','14473','14474','14475','14476','14477','14478','14479','14482','14483','14484','14485','14486','14487','14488','14489','14490','14491','14492','14493','14494','14495','14496','14497','14498','14499','14500','14501','14502','14503','14504','14505','14506','14507','14508','14509','14510','14511','14512','14513','14514','14515','14516','14517','14518','14519','14520','14521','14522','14523','14524','14525','14526','14527','14528','14530','14531','14532','14533','14534','14535','14536','14537','14544','14545','14548','14549','14550','14551','15694','15892','27800','27916','27966','28139','28907','28908','28909','29407','29408','29409','29410','29532','29689','29693','29994','30099','30287','30538','30539','30570','31298','31299','31816','31821','31822','31823','31824','31825','31826','31827','31830','31831')
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 = 29408)
SELECT `preview` FROM `prints_vector` WHERE `id` IN(SELECT `vector_id` FROM `prints_set_vector` WHERE `set_id` = 34547) 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`='34547'
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('1406','2867','12385','29407','29408','29409','29410','31827') 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 = 1589)
SELECT `preview` FROM `prints_vector` WHERE `id` IN(SELECT `vector_id` FROM `prints_set_vector` WHERE `set_id` = 28898) 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`='28898'
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('1589','1590','1591','1592','1593','1594','1792','2971','2972','2973','14347','14348') 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 = 6255)
SELECT `preview` FROM `prints_vector` WHERE `id` IN(SELECT `vector_id` FROM `prints_set_vector` WHERE `set_id` = 32639) 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`='32639'
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('1805','1807','1808','6252','6254','6255','29689','29693') 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 = 12385)
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 = 12389)
SELECT `preview` FROM `prints_vector` WHERE `id` IN(SELECT `vector_id` FROM `prints_set_vector` WHERE `set_id` = 34545) 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`='34545'
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('12389','29532') 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 = 2867)
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 = 14383)
SELECT `preview` FROM `prints_vector` WHERE `id` IN(SELECT `vector_id` FROM `prints_set_vector` WHERE `set_id` = 35857) 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`='35857'
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('549','614','1798','1799','1800','1801','1803','14370','14371','14372','14373','14374','14375','14376','14377','14378','14379','14380','14381','14382','14383','14384','14385','14386') ORDER BY price LIMIT 0, 1
SELECT `id`, `name`, `type` FROM nox_group