Database connection
SET `time_zone` = '+03:00'
SELECT * FROM cms_events WHERE `is_enabled` = 1 ORDER BY ordering ASC
SELECT i.id as `id`, i.is_enabled as `is_enabled`, i.options as `options`, i.name as `name`, i.slug as `slug`
FROM cms_controllers i
LIMIT 1000
UPDATE cms_users i SET `device` = 'desktop' WHERE (i.id = '0')
SELECT i.*, r.name as `rule_name`, r.type as `rule_type`, r.options as `rule_options`
FROM cms_perms_users i
INNER JOIN cms_perms_rules as r FORCE INDEX (PRIMARY ) ON r.id = i.rule_id
WHERE (i.group_id IN ('1'))
LIMIT 1000
SELECT i.*
FROM cms_content_types i
WHERE (i.is_enabled = '1')
ORDER BY i.ordering
LIMIT 1000
SELECT i.*
FROM cms_awards_medals i
LIMIT 1000
SELECT i.*
FROM cms_awards_ranks i
SELECT i.*
FROM cms_widgets_pages i
LIMIT 1000
SELECT i.*, IF(t.id IS NULL AND i.is_approved < 1, 1, NULL) as `is_draft`, t.is_new_item, f.title as `folder_title`, u.nickname as `user_nickname`, u.slug as `user_slug`, u.date_log as `user_date_log`, u.is_deleted as `user_is_deleted`, u.groups as `user_groups`, u.avatar as `user_avatar`, u.privacy_options as `user_privacy_options`
FROM cms_con_market i
LEFT JOIN cms_moderators_tasks as t ON t.item_id = i.id AND t.ctype_name = 'market'
INNER JOIN cms_users as u ON u.id = i.user_id
LEFT JOIN cms_content_folders as f ON f.id = i.folder_id
WHERE (i.slug = '525-hogwarts-legacy-digital-deluxe-edition')
LIMIT 1
SELECT i.*, r.name as `rule_name`, r.type as `rule_type`, r.options as `rule_options`
FROM cms_perms_users i
INNER JOIN cms_perms_rules as r FORCE INDEX (PRIMARY ) ON r.id = i.rule_id
WHERE (r.controller = 'content') AND (r.name = 'view_list') AND (i.subject = 'market')
LIMIT 1000
SELECT i.*, c.title as `child_title`, c.labels as `child_labels`, c.name as `child_ctype_name`
FROM cms_content_relations i
LEFT JOIN cms_content_types as c ON c.id = i.child_ctype_id AND i.target_controller = 'content'
WHERE (i.ctype_id = '13')
ORDER BY i.ordering asc
SELECT i.*, i.values as `default`
FROM cms_con_market_fields i
WHERE (i.is_enabled = '1')
ORDER BY i.ordering
SELECT i.*
FROM cms_fgame_tables i
WHERE (i.ctype_id = '13') AND (i.item_id = '525') AND (i.fname = 'tabl_digital')
ORDER BY i.id asc
LIMIT 1000
SELECT i.*
FROM cms_fgame_lines i
WHERE (i.table_id = '687337154356')
ORDER BY i.ordering asc
SELECT i.*
FROM cms_fgame_lines i
WHERE (i.table_id = '695197044615')
ORDER BY i.ordering asc
SELECT i.*
FROM cms_fgame_lines i
WHERE (i.table_id = '701526413201')
ORDER BY i.ordering asc
SELECT i.*
FROM cms_con_spisok_vladelcev i
WHERE (i.id IS NULL)
LIMIT 1
SELECT i.*
FROM cms_fgame_subscribes i
WHERE (i.table_id = '687337154356') AND (i.user_id = '0')
LIMIT 1
SELECT i.*
FROM cms_fgame_subscribes i
WHERE (i.table_id = '687337154356')
SELECT i.*
FROM cms_fgame_lines i
WHERE (i.table_id = '687337154356')
ORDER BY i.ordering asc
SELECT i.*
FROM cms_con_spisok_vladelcev i
WHERE (i.id IS NULL)
LIMIT 1
SELECT i.*
FROM cms_fgame_subscribes i
WHERE (i.table_id = '695197044615') AND (i.user_id = '0')
LIMIT 1
SELECT i.*
FROM cms_fgame_subscribes i
WHERE (i.table_id = '695197044615')
SELECT i.*
FROM cms_fgame_lines i
WHERE (i.table_id = '695197044615')
ORDER BY i.ordering asc
SELECT i.*
FROM cms_con_spisok_vladelcev i
WHERE (i.id IS NULL)
LIMIT 1
SELECT i.*
FROM cms_fgame_subscribes i
WHERE (i.table_id = '701526413201') AND (i.user_id = '0')
LIMIT 1
SELECT i.*
FROM cms_fgame_subscribes i
WHERE (i.table_id = '701526413201')
SELECT i.*
FROM cms_fgame_lines i
WHERE (i.table_id = '701526413201')
ORDER BY i.ordering asc
SELECT i.*
FROM cms_fgame_autocreate i
WHERE (i.ctype_id = '13') AND (i.item_id = '525') AND (i.fname = 'tabl_digital') AND (i.type = 'fourth')
LIMIT 1
SELECT i.*
FROM cms_fgame_autocreate i
WHERE (i.ctype_id = '13') AND (i.item_id = '525') AND (i.fname = 'tabl_digital') AND (i.type = 'second')
LIMIT 1
SELECT i.*
FROM cms_typograph_presets i
WHERE (i.id = '1')
LIMIT 1
SELECT i.*
FROM cms_fgame_tables i
WHERE (i.ctype_id = '13') AND (i.item_id = '525') AND (i.fname = 'tabl_pod')
ORDER BY i.id asc
LIMIT 1000
SELECT i.id as `id`
FROM cms_users i
WHERE (i.is_admin = '1')
LIMIT 1000
SELECT i.*
FROM cms_users i
WHERE (i.id IN ('1559','4662','5171','5989','1782','1398','807','6239','5225','1526','5982','1374','2699','3949','1372','863','2051','1983','558','4897','4810','5994','1114','1733','1155','1144','4932','6042','1700','2922','5500','1458','5042','1586','3926','4979','1951','5752','1048','815','1582','5528','5637','1193','2836','5893','527','326','1859','1911','1029','1189','5439','1265','1864','1712','2732','1872','2920','1043','2749','5345','5694','4045','4039','1446','90','5499','3742','3292','2406','1643','1642','2449','3683','5414','3110','4388','4778','4312','3806','1589','1388','3327','777','2746','1848','1120','5495','2990','934','4202','3037','4770','4097','117','3205','5032','4844','3402','4067','3160','2319','1647','3326','1157','1124','5442','2252','3147','3024','3655','5685','4644','289','196','4155','2137','5287','4634','4220','4942','1432','21','1991','3777','2367','2543','2192','4251','4391','1960','5043','4725','4577','4811','1379','483','369','1552','59','1359','3649','4076','5247','793','491','4738','1470','4791','4713','679','5308','3730','3379','2073','142','64','4480','3951','3901','1110','5095','4596','2503','3176','665','3802','2534','996','5353','3008','4511','5295','3265','3471','5096','2384','1045','4320','1630','1714','4833','4143','4309','2303','4743','3462','2304','4256','5194','3071','2976','517','2719','4734','100','2139','1883','3324','713','1246','2818','1382','240','3394','5000','1215','1551','5236','2039','4049','1434','2049','3517','4947','3106','2131','4048','1294','4369','2900','4840','3225','1524','1012','1049','800','1270','448','1390','1607','4525','2391','1967','4522','5013','2996','3877','2598','4221','4056','1764','3910','3702','1506','5256','2621','4550','2936','3707','3868','756','3391','2184','723','1631','3975','4982','5276','372','5215','4954','4152','809','2820','1492','4714','4232','4589','742','162','1178','4650','4426','3718','4727','4673','2166','4197','5051','1558','4215','5165','3876','4434','4774','3198','4493','146','4054','4625','1661','4884','4680','557','4944','2415','5184','2428','4631','2486','899','3526','1894','5166','2274','5119','4571','5147','3457','2323','841','2356','3661','5050','3370','5091','3053','4290','4127','4891','2835','69','1380','169','359','985','1208','460','4405','4565','712','5063','5007','2121','3557','4753','2103','4832','3722','4943','4615','4793','2298','3494','1445','4790','4800','5020','1403','4261','5014','3180','3433','4380','336','281','4225','4964','384','4371','4685','541','687','984','3591','4322','3759','2776','4618','4317','4974','4968','4696','2097','4919','1719','26','2969','1936','4490','4923','4955','1548','4949','2868','3890','147','773','1097','2792','3973','4293','4865','1917','4023','1732','3035','4154','4677','1838','468','4580','4521','4664','1593','75','1562','1302','4928','2425','4461','3399','2789','908','4617','3199','2715','2510','4857','2011','4703','4911','4807','256','2823','488','3522','797','579','4432','1934','4812','1750','2383','4649','4108','2964','2117','4854','2527','4756','3728','2005','4710','4609','4273','4726','2402','4879','572','1105','4874','1978','3339','3986','4883','613','4328','1644','3117','4698','1765','2120','3360','1514','2542','4867','4799','1901','4670','3000','4878','450','3355','4863','149','4003','4223','4829','4331','2107','4876','1307','1963','4825','485','3356','585','642','615','617','4872','4553','4871','1692','2416','1989','1152','2906','4868','5','4017','1831','4537','4397','2981','4616','4579','327','750','4386','3337','2065','1986','4296','4569','1452','2673','163','1109','913','4373','667','2412','2812','4206','4780','3950','2041','1672','1852','3322','4313','2520','3096','425','4852','670','2351','1312','1585','4610','4666','936','4794','2785','4460','4362','1200','502','131','3542','833','4851','102','3822','757','3112','708','628','1018','4717','2122','3466','522','655','2730','4479','1815','2052','682','705','4716','4419','2994','2651','1952','7','4441','2233','137','2576','2145','1011','501','377','2680','714','3298','2032','4230','2886','2191','434','3318','4177','2199','381','539','47','4342','3620','383','3279','4111','294','3797','3991','4103','2807','1523','2928','764','4478','2658','4173','1117','509','1542','445','4135','838','4824','1459','783','1456','110','2574','157','1431','2208','2939','4350','1444','2012','4815','1691','4819','1590','2267','586','4817','151','1718','2824','842','1305','2376','1553','3748','4558','4188','4773','3992','8','479','3700','3171','1414','4337','812','4217','4314','515','614','4509','4546','4422','1435','751','1050','4776','4761','4748','2494','1306','2168','1599','2643','4372','1423','4781','4786','2483','1873','4527','2047','2461','3762','2748','4468','1698','2090','731','4117','734','2430','1829','4638','1340','4772','1946','4678','2365','23','1489','3275','1142','3769','1389','2441','1075','4768','1503','824','1939','1760','4349','388','4564','250','3944','4732','3223','1243','1817','4759','451','533','2725','357','4242','1950','1115','624','4601','4749','4254','1674','4365','1666','1098','2641','3693','1940','4651','158','1707','775','2246','626','4033','3346','2060','4592','1993','3653','582','4444','2067','4622','2436','1778','160','3932','4724','297','958','4718','243','2423','2152','4494','563','1022','1371','2569','4619','1429','32','4534','4043','3290','2352','1091','4486','666','4212','1767','3833','2342','3904','1317','1905','4338','1613','4629','4562','3455','3492','1508','1676','4608','1502','4643','3791','1151','184','1971','4496','2154','1163','3369','3945','3938','4235','4286','1269','654','439','4604','4084','897','1037','2560','4267','4308','4452','3852','4095','2419','144','1619','280','1877','2833','1217','1659','1656','4438','4264','4451','1482','608','4345','4416','3446','1473','867','924','4355','553','3754','3400','3720'))
LIMIT 1000
SELECT i.*
FROM cms_awards i
WHERE (i.user_id = '1559')
LIMIT 1000
SELECT i.*
FROM cms_awards i
WHERE (i.user_id = '4662')
LIMIT 1000
SELECT i.*
FROM cms_awards i
WHERE (i.user_id = '5171')
LIMIT 1000
SELECT i.*
FROM cms_awards i
WHERE (i.user_id = '5989')
LIMIT 1000
SELECT i.*
FROM cms_awards i
WHERE (i.user_id = '1782')
LIMIT 1000
SELECT i.*
FROM cms_awards i
WHERE (i.user_id = '1398')
LIMIT 1000
SELECT i.*
FROM cms_awards i
WHERE (i.user_id = '807')
LIMIT 1000
SELECT i.*
FROM cms_awards i
WHERE (i.user_id = '6239')
LIMIT 1000
SELECT i.*
FROM cms_awards i
WHERE (i.user_id = '5225')
LIMIT 1000
SELECT i.*
FROM cms_awards i
WHERE (i.user_id = '1526')
LIMIT 1000
SELECT i.*
FROM cms_con_market i
WHERE (i.is_parent_hidden IS NULL) AND (i.is_approved = '1') AND (i.is_pub = '1') AND (i.is_deleted IS NULL) AND ((i.date_pub < '2022-08-25 23:35:00') OR ((i.date_pub = '2022-08-25 23:35:00') AND (i.id < '525') ) )
ORDER BY i.date_pub desc, i.id desc
LIMIT 1
SELECT i.*
FROM cms_con_market i
WHERE (i.is_parent_hidden IS NULL) AND (i.is_approved = '1') AND (i.is_pub = '1') AND (i.is_deleted IS NULL) AND ((i.date_pub > '2022-08-25 23:35:00') OR ((i.date_pub = '2022-08-25 23:35:00') AND (i.id > '525') ) )
ORDER BY i.date_pub asc, i.id asc
LIMIT 1
SELECT i.*
FROM cms_cart_items i
WHERE (i.user_hash = '9b96e895a6')
LIMIT 1
SELECT i.*
FROM cms_cart_orders i
WHERE (i.user_hash = '9b96e895a6')
LIMIT 1
SELECT i.*
FROM cms_cart_items i
WHERE (i.order_id IS NULL) AND (i.user_hash = '9b96e895a6')
SELECT i.*
FROM cms_fgame_tables i
WHERE (i.ctype_id = '13') AND (i.item_id = '525') AND (i.fname = 'tabl_digital')
ORDER BY i.id asc
LIMIT 1000
SELECT i.*
FROM cms_fgame_lines i
WHERE (i.table_id = '687337154356')
ORDER BY i.ordering asc
SELECT i.*
FROM cms_fgame_lines i
WHERE (i.table_id = '695197044615')
ORDER BY i.ordering asc
SELECT i.*
FROM cms_fgame_lines i
WHERE (i.table_id = '701526413201')
ORDER BY i.ordering asc
SELECT i.*
FROM cms_con_spisok_vladelcev i
WHERE (i.id IS NULL)
LIMIT 1
SELECT i.*
FROM cms_fgame_subscribes i
WHERE (i.table_id = '687337154356') AND (i.user_id = '0')
LIMIT 1
SELECT i.*
FROM cms_fgame_subscribes i
WHERE (i.table_id = '687337154356')
SELECT i.*
FROM cms_fgame_lines i
WHERE (i.table_id = '687337154356')
ORDER BY i.ordering asc
SELECT i.*
FROM cms_con_spisok_vladelcev i
WHERE (i.id IS NULL)
LIMIT 1
SELECT i.*
FROM cms_fgame_subscribes i
WHERE (i.table_id = '695197044615') AND (i.user_id = '0')
LIMIT 1
SELECT i.*
FROM cms_fgame_subscribes i
WHERE (i.table_id = '695197044615')
SELECT i.*
FROM cms_fgame_lines i
WHERE (i.table_id = '695197044615')
ORDER BY i.ordering asc
SELECT i.*
FROM cms_con_spisok_vladelcev i
WHERE (i.id IS NULL)
LIMIT 1
SELECT i.*
FROM cms_fgame_subscribes i
WHERE (i.table_id = '701526413201') AND (i.user_id = '0')
LIMIT 1
SELECT i.*
FROM cms_fgame_subscribes i
WHERE (i.table_id = '701526413201')
SELECT i.*
FROM cms_fgame_lines i
WHERE (i.table_id = '701526413201')
ORDER BY i.ordering asc
SELECT i.*
FROM cms_fgame_autocreate i
WHERE (i.ctype_id = '13') AND (i.item_id = '525') AND (i.fname = 'tabl_digital') AND (i.type = 'fourth')
LIMIT 1
SELECT i.*
FROM cms_fgame_autocreate i
WHERE (i.ctype_id = '13') AND (i.item_id = '525') AND (i.fname = 'tabl_digital') AND (i.type = 'second')
LIMIT 1
SELECT i.*
FROM cms_fgame_tables i
WHERE (i.ctype_id = '13') AND (i.item_id = '525') AND (i.fname = 'tabl_pod')
ORDER BY i.id asc
LIMIT 1000
SELECT i.id as `id`
FROM cms_users i
WHERE (i.is_admin = '1')
LIMIT 1000
SELECT i.*
FROM cms_users i
WHERE (i.id IN ('1559','4662','5171','5989','1782','1398','807','6239','5225','1526','5982','1374','2699','3949','1372','863','2051','1983','558','4897','4810','5994','1114','1733','1155','1144','4932','6042','1700','2922','5500','1458','5042','1586','3926','4979','1951','5752','1048','815','1582','5528','5637','1193','2836','5893','527','326','1859','1911','1029','1189','5439','1265','1864','1712','2732','1872','2920','1043','2749','5345','5694','4045','4039','1446','90','5499','3742','3292','2406','1643','1642','2449','3683','5414','3110','4388','4778','4312','3806','1589','1388','3327','777','2746','1848','1120','5495','2990','934','4202','3037','4770','4097','117','3205','5032','4844','3402','4067','3160','2319','1647','3326','1157','1124','5442','2252','3147','3024','3655','5685','4644','289','196','4155','2137','5287','4634','4220','4942','1432','21','1991','3777','2367','2543','2192','4251','4391','1960','5043','4725','4577','4811','1379','483','369','1552','59','1359','3649','4076','5247','793','491','4738','1470','4791','4713','679','5308','3730','3379','2073','142','64','4480','3951','3901','1110','5095','4596','2503','3176','665','3802','2534','996','5353','3008','4511','5295','3265','3471','5096','2384','1045','4320','1630','1714','4833','4143','4309','2303','4743','3462','2304','4256','5194','3071','2976','517','2719','4734','100','2139','1883','3324','713','1246','2818','1382','240','3394','5000','1215','1551','5236','2039','4049','1434','2049','3517','4947','3106','2131','4048','1294','4369','2900','4840','3225','1524','1012','1049','800','1270','448','1390','1607','4525','2391','1967','4522','5013','2996','3877','2598','4221','4056','1764','3910','3702','1506','5256','2621','4550','2936','3707','3868','756','3391','2184','723','1631','3975','4982','5276','372','5215','4954','4152','809','2820','1492','4714','4232','4589','742','162','1178','4650','4426','3718','4727','4673','2166','4197','5051','1558','4215','5165','3876','4434','4774','3198','4493','146','4054','4625','1661','4884','4680','557','4944','2415','5184','2428','4631','2486','899','3526','1894','5166','2274','5119','4571','5147','3457','2323','841','2356','3661','5050','3370','5091','3053','4290','4127','4891','2835','69','1380','169','359','985','1208','460','4405','4565','712','5063','5007','2121','3557','4753','2103','4832','3722','4943','4615','4793','2298','3494','1445','4790','4800','5020','1403','4261','5014','3180','3433','4380','336','281','4225','4964','384','4371','4685','541','687','984','3591','4322','3759','2776','4618','4317','4974','4968','4696','2097','4919','1719','26','2969','1936','4490','4923','4955','1548','4949','2868','3890','147','773','1097','2792','3973','4293','4865','1917','4023','1732','3035','4154','4677','1838','468','4580','4521','4664','1593','75','1562','1302','4928','2425','4461','3399','2789','908','4617','3199','2715','2510','4857','2011','4703','4911','4807','256','2823','488','3522','797','579','4432','1934','4812','1750','2383','4649','4108','2964','2117','4854','2527','4756','3728','2005','4710','4609','4273','4726','2402','4879','572','1105','4874','1978','3339','3986','4883','613','4328','1644','3117','4698','1765','2120','3360','1514','2542','4867','4799','1901','4670','3000','4878','450','3355','4863','149','4003','4223','4829','4331','2107','4876','1307','1963','4825','485','3356','585','642','615','617','4872','4553','4871','1692','2416','1989','1152','2906','4868','5','4017','1831','4537','4397','2981','4616','4579','327','750','4386','3337','2065','1986','4296','4569','1452','2673','163','1109','913','4373','667','2412','2812','4206','4780','3950','2041','1672','1852','3322','4313','2520','3096','425','4852','670','2351','1312','1585','4610','4666','936','4794','2785','4460','4362','1200','502','131','3542','833','4851','102','3822','757','3112','708','628','1018','4717','2122','3466','522','655','2730','4479','1815','2052','682','705','4716','4419','2994','2651','1952','7','4441','2233','137','2576','2145','1011','501','377','2680','714','3298','2032','4230','2886','2191','434','3318','4177','2199','381','539','47','4342','3620','383','3279','4111','294','3797','3991','4103','2807','1523','2928','764','4478','2658','4173','1117','509','1542','445','4135','838','4824','1459','783','1456','110','2574','157','1431','2208','2939','4350','1444','2012','4815','1691','4819','1590','2267','586','4817','151','1718','2824','842','1305','2376','1553','3748','4558','4188','4773','3992','8','479','3700','3171','1414','4337','812','4217','4314','515','614','4509','4546','4422','1435','751','1050','4776','4761','4748','2494','1306','2168','1599','2643','4372','1423','4781','4786','2483','1873','4527','2047','2461','3762','2748','4468','1698','2090','731','4117','734','2430','1829','4638','1340','4772','1946','4678','2365','23','1489','3275','1142','3769','1389','2441','1075','4768','1503','824','1939','1760','4349','388','4564','250','3944','4732','3223','1243','1817','4759','451','533','2725','357','4242','1950','1115','624','4601','4749','4254','1674','4365','1666','1098','2641','3693','1940','4651','158','1707','775','2246','626','4033','3346','2060','4592','1993','3653','582','4444','2067','4622','2436','1778','160','3932','4724','297','958','4718','243','2423','2152','4494','563','1022','1371','2569','4619','1429','32','4534','4043','3290','2352','1091','4486','666','4212','1767','3833','2342','3904','1317','1905','4338','1613','4629','4562','3455','3492','1508','1676','4608','1502','4643','3791','1151','184','1971','4496','2154','1163','3369','3945','3938','4235','4286','1269','654','439','4604','4084','897','1037','2560','4267','4308','4452','3852','4095','2419','144','1619','280','1877','2833','1217','1659','1656','4438','4264','4451','1482','608','4345','4416','3446','1473','867','924','4355','553','3754','3400','3720'))
LIMIT 1000
SELECT i.*
FROM cms_imini_attaches i
WHERE (i.target_controller = 'content') AND (i.target_subject = 'market') AND (i.target_id = '525')
ORDER BY i.target_controller asc, i.target_subject asc, i.target_id asc, i.target_field asc
LIMIT 1000
SELECT i.*
FROM cms_billing_paid_fields i
WHERE (i.ctype_id = '13')
LIMIT 1000
SELECT i.*
FROM cms_con_market_cats i
WHERE (i.id = '1')
LIMIT 1
SELECT i.*
FROM cms_con_market_cats i
WHERE (i.ns_left <= '1') AND (i.ns_right >= '14') AND (i.ns_level <= '0') AND (i.ns_level > '0')
ORDER BY i.ns_left
SELECT i.*, w.controller as `controller`, w.name as `name`, wb.*, i.id as `id`
FROM cms_widgets_bind_pages i
INNER JOIN cms_widgets_bind as wb ON wb.id = i.bind_id
INNER JOIN cms_widgets as w ON w.id = wb.widget_id
WHERE (i.page_id IN ('0','186','188')) AND (i.template = 'psxclub') AND (i.is_enabled = '1')
ORDER BY i.position, i.ordering
LIMIT 1000
SELECT i.*, menu.name as `menu_name`, COUNT(childs.id) as `childs_count`
FROM cms_menu_items i
LEFT JOIN cms_menu as menu ON menu.id = i.menu_id
LEFT JOIN cms_menu_items as childs ON childs.parent_id = i.id AND childs.is_enabled = 1
WHERE (i.is_enabled = '1')
GROUP BY i.id
ORDER BY i.ordering asc
LIMIT 1000
SELECT COUNT( i.id) as `count`
FROM cms_con_board i
WHERE (i.user_id = '0') AND (i.is_private = '0') AND (i.is_approved = '1') AND (i.is_deleted IS NULL) AND (i.is_pub >= '1')
SELECT i.*
FROM cms_con_board_cats i
WHERE (i.is_hidden IS NULL) AND (i.parent_id > '0')
ORDER BY i.ns_left
LIMIT 1000
SELECT i.*
FROM cms_con_articles_cats i
WHERE (i.is_hidden IS NULL) AND (i.parent_id > '0')
ORDER BY i.ns_left
LIMIT 1000
SELECT i.*, r.nested_position as `nested_position`, r.parent_id as `parent_id`, r.title as `row_title`, r.options as `row_options`, r.class as `row_class`, r.tag as `row_tag`
FROM cms_layout_cols i
INNER JOIN cms_layout_rows as r ON r.id = i.row_id
WHERE (r.template = 'psxclub')
ORDER BY r.ordering asc, i.ordering asc
LIMIT 1000