info Config Class Initialized<br />info Hooks Class Initialized<br />debug UTF-8 Support Enabled<br />info Utf8 Class Initialized<br />info URI Class Initialized<br />info Router Class Initialized<br />info Output Class Initialized<br />info Security Class Initialized<br />debug Global POST, GET and COOKIE data sanitized<br />info Input Class Initialized<br />info Language Class Initialized<br />info Loader Class Initialized<br />info Helper loaded: url_helper<br />info Helper loaded: globalfunction_helper<br />info Helper loaded: file_helper<br />info Helper loaded: download_helper<br />info Database Driver Class Initialized<br />info Email Class Initialized<br />debug Session: "sess_save_path" is empty; using "session.save_path" value from php.ini.<br />info Session: Class initialized using 'files' driver.<br />info Controller Class Initialized<br />info Model Class Initialized<br />info Model Class Initialized<br />info Model Class Initialized<br />info Helper loaded: form_helper<br />info Form Validation Class Initialized<br />info User Agent Class Initialized<br />debug Session class already loaded. Second attempt ignored.<br />error Query error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'rows, d.developer_id, p.img_path, p.project_id, p.project_slug, p.address, p.bas' at line 1 - Invalid query: SELECT SQL_CALC_FOUND_ROWS null as rows, d.developer_id, p.img_path, p.project_id, p.project_slug, p.address, p.base_price, p.offer_price, p.property_status, p.posted_by, p.property_type_id, TRIM(d.name) as developerName, l.search_words, l.listing_id, l.bhk as bhk, l.updated_on as updated_on, l.description as listingDescription, l.min_sqft_size as min_sqft_size, l.max_sqft_size as max_sqft_size, TRIM(p.name) as projectName, p.category as category, p.latitude, p.longitude, p.description as devDescription, p.sale_type, p.soldout, TRIM(loc.name) as locName, loc.location_id as locId, c.name as locCity
FROM `projects` `p`
LEFT JOIN `listings` `l` ON `p`.`project_id` = `l`.`project_id`
LEFT JOIN `locations` `loc` ON `p`.`location_id` = `loc`.`location_id`
LEFT JOIN `city` `c` ON `c`.`city_id` = `loc`.`city_id`
LEFT JOIN `developers` `d` ON `p`.`developer_id` = `d`.`developer_id`
LEFT JOIN `refresh` `r` ON `r`.`projectid` = `p`.`project_id`
LEFT JOIN `property_types` `pt` ON `l`.`property_type_id` = `pt`.`property_type_id`
WHERE (`p`.`sale_type` = 1 OR `p`.`sale_type` = 2)
AND `p`.`property_type_id` IN(2)
AND `l`.`project_id` IN('6943', '6943', '4204', '4205', '4206', '4207', '4208', '4209', '4210', '38', '38', '51', '75', '75', '75', '75', '207', '207', '1159', '1159', '1362', '1362', '1442', '1442', '1485', '1485', '1625', '1625', '2947', '2948', '1425', '1425', '1523', '1523', '1523', '2536', '2536', '2536', '3582', '3584', '3587', '3589', '3591', '3592', '117', '117', '292', '292', '292', '697', '697', '1087', '4329', '7646', '22334', '22335', '19728', '18810', '13199', '10761', '10315', '13154', '13154', '21889', '22204', '23575', '23575', '21717', '21717', '21717', '21717', '21724', '21724', '21724', '21724', '21725', '21725', '21728', '21728', '21732', '21732', '21747', '21747', '21747', '21747', '21802', '1133', '1139', '1141', '2511', '2511', '2511', '2531', '2531', '1397', '1397', '1489', '1569', '1570', '1570', '1574', '1575', '1575', '1575', '1576', '1603', '95', '95', '146', '146', '184', '184', '204', '204', '254', '3081', '3285', '3288', '3293', '3297', '3300', '3304', '3309', '3313', '3314', '3318', '3600', '3603', '3607', '3608', '3611', '3612', '3616', '3619', '3623', '3713', '3715', '3718', '3719', '3723', '3726', '3728', '3731', '3734', '3737', '5923', '5923', '5923', '6033', '6089', '4970', '4972', '4976', '4981', '4985', '4989', '4994', '4999', '18834', '19759', '19759', '19908', '19908', '4682', '4684', '8177', '8177', '5131', '5135', '5138', '5141', '5144', '5146', '5150', '5154', '5157', '5161', '5760', '5760', '6085', '7854', '7854', '2393', '2404', '2545', '1013', '1013', '1082', '1082', '1163', '1188', '1794', '1794', '1794', '2035', '2036', '3173', '1370', '1370', '1370', '1372', '1374', '1539', '1541', '1659', '4', '4', '27', '27', '27', '36', '36', '126', '126', '131', '131', '194', '194', '249', '249', '249', '249', '290', '290', '11782', '9354', '9354', '9354', '10326', '10327', '21691', '21691', '23579', '23579', '23579', '23588', '23588', '23588', '23592', '23592', '23592', '23592', '22007', '22007', '21204', '15726', '14257', '18891', '18892', '19623', '19626', '19637', '19150', '19906', '19952', '19952', '19952', '19952', '19985', '10667', '10687', '10687', '10687', '10691', '10691', '10695', '10695', '13594', '13594', '13595', '13595', '13595', '11769', '4166', '4167', '4168', '4169', '4170', '4172', '4174', '4178', '4179', '6043', '5008', '5011', '5016', '5019', '5021', '5023', '5025', '5027', '5029', '5323', '5327', '5336', '5340', '5344', '5347', '5350', '5353', '5363', '5368', '70', '70', '70', '71', '71', '71', '71', '81', '96', '96', '96', '96', '96', '98', '118', '118', '135', '135', '135', '136', '161', '161', '161', '171', '203', '203', '450', '450', '450', '579', '579', '634', '1143', '3372', '3379', '3381', '3383', '3384', '3386', '3391', '3395', '3398', '2400', '2400', '2400', '2547', '2547', '2579', '2579', '2579', '1460', '1460', '1496', '1496', '1531', '1632', '1632', '1632', '2910', '2910', '2915', '2915', '2917', '2919', '2919', '2919', '2921', '2921', '2921', '2925', '3251', '3253', '3254', '21203', '21203', '21267', '21267', '21416', '21808', '21812', '21813', '21848', '21866', '22026', '22091', '22396', '21205', '6104', '3102', '53', '1173', '1473', '1493', '2532', '8', '8', '8', '8', '8', '18', '33', '33', '52', '99', '104', '104', '104', '284', '592', '592', '684', '684', '1458', '1458', '1532', '1532', '1745', '1745', '1088', '1096', '1097', '1177', '23590', '21687', '21687', '21688', '21688', '21738', '21738', '21738', '21738', '8582', '8593', '12458', '12458', '6002', '6002', '6119', '6119', '6119', '5384', '5391', '5398', '5402', '5406', '5409', '5413', '5422', '5426', '5040', '5043', '5046', '5049', '5052', '5055', '5058', '5438', '5439', '5440', '5441', '5442', '5443', '5444', '5445', '5446', '5447', '6096', '4275', '4277', '4280', '4283', '4285', '4287', '4291', '4293', '4295', '4299', '21951', '1099', '1099', '1099', '1504', '1504', '1504', '1571', '1571', '1571', '1573', '76', '76', '143', '147', '147', '147', '591', '591', '591', '591', '591', '681', '681', '681', '13151', '11416', '13968', '13968', '13968', '22981', '5590', '705', '705', '705', '705', '705', '3212', '1413', '1413', '1567', '1174', '1171', '97', '97', '112', '112', '112', '141', '150', '150', '150', '166', '166', '166', '166', '585', '585', '3679', '3681', '3684', '3689', '3692', '3695', '3697', '3701', '3704', '3707', '2571', '2571', '23030', '19756', '19756', '19756', '19845', '19845', '15716', '13209', '13209', '10314', '11667', '11668', '8187', '4763', '4769', '4773', '4776', '4778', '4781', '4784', '4788', '3874', '3943', '3946', '3947', '3950', '3953', '3956', '3959', '3963', '3965', '3968', '3867', '3869', '3870', '3871', '3873', '3876', '3878', '3887', '3889', '113', '113', '160', '160', '160', '163', '163', '590', '590', '590', '20339', '3107', '3108', '607', '607', '1477', '1477', '3595', '2439', '685', '685', '21718', '21718', '19177', '4335', '4335', '4352', '4352', '18860', '79', '79', '138', '138', '138', '139', '139', '1086', '73', '73', '2920', '2920', '2923', '2923', '2923', '2929', '2929', '3166', '5091', '5094', '5097', '5100', '5101', '5104', '5106', '5109', '5111', '5113', '6083', '21722', '21722', '21722', '21722', '13809', '3181', '3182', '973', '974', '975', '3389', '2903', '2905', '4955', '4958', '4960', '4964', '4966', '4969', '4973', '4974', '4977', '4979', '5177', '5180', '5184', '5187', '5193', '5198', '5201', '5206', '5208', '4271', '4272', '1568', '1568', '188', '188', '188', '188', '287', '287', '287', '20159', '20160', '21972', '22409', '21721', '21721', '21730', '21730', '21731', '21731', '21745', '21745', '20900', '4359', '4359', '4765', '4767', '4772', '4777', '4782', '4786', '4789', '4792', '4796', '4800', '4916', '4919', '4923', '4925', '4926', '4928', '4929', '4930', '4932', '4933', '8184', '8270', '6041', '6114', '6117', '19156', '19156', '10909', '140', '259', '2802', '855', '1132', '1134', '1135', '1136', '1137', '1440', '1577', '1578', '1578', '2517', '2537', '2879', '4746', '4748', '5375', '5081', '5756', '5756', '3213', '3213', '31', '31', '31', '57', '57', '74', '85', '85', '175', '258', '580', '601', '601', '628', '718', '720', '720', '728', '728', '728', '3402', '3404', '3407', '3409', '3411', '3412', '3420', '3424', '3428', '3434', '3935', '3942', '3945', '3948', '3951', '3954', '3957', '3961', '3964', '3966', '1420', '1420', '1537', '1704', '1704', '21219', '21219', '21420', '21702', '21702', '21702', '21702', '21702', '21702', '15360', '15360', '17686', '17686', '17686', '10430', '10456', '10456', '10464', '10452', '10452', '10452', '21425', '21425', '21425', '4091', '4092', '4094', '4096', '4099', '1445', '1445', '3214', '3214', '1377', '1377', '1494', '1494', '2523', '144', '144', '687', '687', '3414', '3415', '3416', '3417', '3421', '3425', '3429', '3433', '3437', '3440', '3939', '3941', '3944', '3949', '3952', '3955', '3958', '3960', '3962', '7629', '7629', '13147', '13147', '10316', '3374', '3397', '3413', '3787', '3790', '3793', '3796', '3797', '3799', '3802', '3803', '3804', '3806', '20', '255', '586', '22290', '21785', '21685', '21685', '110', '110', '2528', '2528', '2528', '1676', '1676', '6118', '2468', '22110', '3031', '3032', '4704', '4705', '5582', '6079', '1069', '1069', '42', '42', '42', '627', '22296', '32', '32', '182', '182', '614', '614', '617', '852', '1017', '1098', '1098', '1417', '1579', '2924', '2926', '2926', '2934', '2934', '3095', '3095', '3095', '3211', '1824', '3439', '3443', '3449', '3452', '3455', '3459', '3463', '3467', '3472', '3476', '22995', '22998', '23002', '23003', '23576', '23576', '21719', '21719', '21719', '21719', '21727', '21727', '21727', '21727', '4217', '4219', '4223', '4225', '4227', '4228', '4233', '8183', '5230', '5232', '5234', '5235', '5238', '5240', '5242', '5244', '5246', '5247', '19709', '19709', '19921', '4728', '4730', '989', '196', '196', '58', '58', '3370', '3377', '3392', '3405', '4353', '4353', '6091', '6091', '5069', '5071', '5073', '5075', '5077', '5080', '5082', '5084', '5085', '5088', '1462', '5', '5', '5', '5', '50', '242', '242', '242', '245', '245', '1147', '1147', '3776', '4934', '4939', '4941', '4942', '4943', '4945', '4948', '4950', '4953', '4257', '4259', '4260', '4262', '4264', '4266', '4268', '4269', '4270', '4273', '22006', '22588', '12991', '12992', '21835', '605', '610', '1656', '1656', '2506', '2506', '4112', '4113', '4114', '4116', '4118', '4120', '4122', '4123', '4125', '4126', '4185', '4187', '4188', '4189', '4191', '4192', '4195', '4197', '8180', '8181', '8274', '8276', '8278', '1379', '1379', '1379', '1384', '1384', '1503', '1503', '3694', '3696', '3698', '3699', '3702', '3705', '3708', '3711', '21517', '21517', '21742', '21742', '22157', '19724', '19724', '3805', '3807', '3808', '3810', '3811', '3813', '3815', '3817', '3820', '3823', '1371', '1371', '1385', '1385', '1404', '1404', '1478', '1478', '1491', '1491', '2375', '2375', '1000', '2842', '2842', '2843', '2843', '2844', '2847', '2847', '2849', '2849', '2850', '2850', '2850', '2851', '2851', '2851', '2854', '2854', '2857', '2857', '3019', '4903', '4904', '4905', '4906', '5163', '5165', '5172', '5173', '5174', '5175', '5176', '4636', '4638', '4640', '4642', '4643', '4651', '4652', '4653', '4654', '4656', '21805', '21805', '21289', '21289', '21289', '1692', '1692', '3913', '3916', '3918', '3920', '3923', '3924', '3932', '3934', '3937', '1093', '16160', '16160', '6076', '8264', '4236', '4238', '4240', '4242', '4245', '4247', '4248', '4250', '4252', '4254', '5009', '5012', '5017', '5030', '5031', '5032', '5033', '5034', '5059', '5060', '5063', '5065', '5067', '5070', '5072', '5076', '5079', '1005', '1005', '1005', '1138', '1146', '2927', '2928', '2928', '2930', '2931', '2932', '2933', '2935', '2936', '2937', '2937', '2938', '2938', '77', '77', '3613', '3617', '3620', '3622', '3625', '3628', '3630', '3632', '3633', '3634', '3771', '3772', '3775', '3777', '21190', '21847', '21255', '5277', '5280', '5283', '5286', '5288', '5290', '5292', '5298', '5300', '5303', '6084', '6095', '4289', '4294', '4298', '4301', '4302', '4305', '4309', '4312', '4314', '4317', '7684', '3235', '1522', '111', '2539', '2540', '3055', '3056', '3056', '3056', '3056', '3057', '3058', '4677', '4679', '4889', '4892', '4895', '4898', '4900', '4901', '4908', '4910', '4913', '5757', '8145', '3219', '3427', '3431', '3436', '3442', '3446', '3451', '3454', '3456', '3458', '3462', '3872', '3888', '3891', '3893', '3896', '3899', '3901', '3903', '3906', '3907', '3909', '1142', '1165', '22', '80', '80', '80', '80', '157', '157', '157', '198', '198', '198', '198', '271', '271', '606', '21200', '21200', '21246', '22348', '23591', '23591', '21720', '21720', '21720', '21720', '12', '12', '12', '137', '137', '137', '173', '173', '202', '202', '4035', '2509', '2509', '2509', '2588', '3116', '3117', '3117', '3120', '3124', '3126', '3126', '3128', '3128', '3129', '3129', '3130', '3130', '3132', '3132', '3161', '799', '799', '969', '969', '969', '1643', '1643', '1644', '1644', '1644', '1645', '1645', '1646', '1646', '1646', '1647', '1647', '1648', '1648', '1649', '1649', '11779', '11779', '4037', '4039', '4041', '4042', '4044', '4047', '4049', '4051', '7427', '6069', '6069', '5122', '5123', '5126', '5129', '5132', '5133', '5136', '5137', '5140', '13152', '1381', '1381', '1382', '1382', '1407', '1407', '1409', '1409', '1499', '1499', '1650', '1650', '257', '257', '265', '265', '265', '266', '266', '266', '266', '716', '716', '3586', '3597', '3598', '3601', '3605', '19734', '19901', '6037', '6039', '3376', '3419', '3609', '3610', '3614', '3615', '3618', '3621', '3624', '3626', '3627', '3629', '35', '243', '243', '262', '262', '268', '280', '280', '452', '569', '594', '594', '2338', '2372', '2372', '1387', '1402', '1402', '1500', '19151', '19151', '21779', '21779', '21825', '22518', '22927', '22097', '13148', '13148', '13149', '13149', '13149', '13153', '13153', '13177', '4334', '4336', '4340', '4340', '4347', '4347', '4349', '3114', '3101', '3103', '18916', '19907', '19907', '19925', '15714', '3169', '3171', '3171', '2369', '2369', '2787', '2787', '570', '571', '626', '1401', '1401', '1487', '1487', '1605', '1634', '1634', '1636', '1636', '1637', '1637', '1638', '1638', '1639', '1639', '1640', '1640', '1641', '1641', '1642', '1642', '1642', '860', '1123', '1125', '1152', '22314', '22431', '22435', '21689', '21689', '22958', '4351', '4868', '4870', '4872', '4875', '4882', '4885', '4887', '4890', '4936', '13174', '13180', '13225', '12533', '12533', '21290', '21698', '21698', '21698', '21698', '21846', '14310', '14310', '18813', '19172', '1010', '63', '4053', '4055', '4058', '4059', '4061', '4063', '4067', '4069', '4146', '4149', '4151', '4153', '4155', '4157', '4159', '4160', '4162', '4164', '7279', '7279', '6102', '6449', '4038', '4040', '19161', '19161', '19161', '18521', '10334', '21932', '69', '116', '116', '124', '124', '124', '708', '708', '2478', '2478', '4022', '4024', '4027', '4029', '4031', '4034', '4036', '1129', '1140', '1164', '1529', '1529', '1630', '1630', '2422', '2519', '2778', '65', '65', '83', '83', '156', '206', '234', '282', '310', '593', '3385', '3922', '3926', '3928', '3929', '3931', '3933', '3936', '3938', '3940', '10332', '12546', '5759', '7855', '4935', '4937', '4938', '4940', '4944', '4947', '4949', '4951', '4954', '19711', '19166', '21890', '22262', '3470', '3485', '2363', '2368', '3083', '479', '479', '481', '483', '485', '487', '489', '489', '19149', '19953', '19953', '1198', '1198', '1198', '2888', '22135', '4735', '4738', '11329', '14370', '4869', '4871', '4874', '4876', '4877', '4879', '4881', '4884', '4886', '4888', '226', '21947', '22316', '3637', '3640', '3643', '3645', '3647', '3650', '3654', '3656', '3658', '3662', '4721', '4722', '8172', '1433', '1433', '3188', '3281', '3284', '3286', '3295', '3302', '3306', '1076', '1076', '1076', '19165', '21871', '22173', '21594', '21695', '21695', '22162', '4713', '4714', '6105', '3084', '3022', '3022', '3022', '3022', '123', '123', '210', '210', '2965', '2967', '3113', '3113', '3121', '3121', '3121', '3122', '3122', '3123', '3123', '3125', '3125', '3127', '3127', '3127', '3131', '3131', '3131', '3131', '2412', '2412', '2465', '2465', '710', '710', '737', '737', '22497', '21723', '21723', '21736', '21736', '21736', '21736', '21737', '21737', '21840', '19919', '19919', '18820', '7222', '7222', '7241', '7436', '11114', '11114', '11114', '11166', '11166', '10333', '13207', '12547', '10313', '3', '145', '302', '311', '589', '589', '615', '632', '714', '714', '3533', '3534', '3536', '3540', '3541', '3544', '3545', '3548', '3549', '3551', '984', '1001', '1021', '1026', '1120', '1474', '21777', '22941', '21178', '6093', '6116', '6116', '6120', '4357', '4357', '6467', '6467', '8041', '8041', '8042', '8042', '4833', '4835', '4838', '4840', '4842', '4843', '4844', '4845', '4846', '4847', '4686', '4687', '3006', '3013', '3013', '21693', '21693', '21891', '11119', '11119', '11139', '11139', '11159', '11171', '11171', '3400', '3538', '3539', '2765', '106', '106', '264', '264', '21916', '21874', '22075', '21329', '21414', '22970', '22972', '22982', '23016', '252', '252', '252', '253', '253', '253', '253', '2401', '2401', '2409', '2409', '2410', '2410', '1367', '1367', '1470', '1597', '3186', '3192', '3512', '3516', '3521', '3523', '3526', '3528', '3529', '3530', '3531', '3532', '1116', '1187', '4337', '4337', '4338', '4343', '4343', '4343', '4343', '4878', '6131', '12927', '191', '689', '689', '689', '3967', '3969', '3972', '3975', '3978', '3981', '3985', '3846', '3848', '3849', '3850', '3852', '3854', '3857', '3860', '3875', '3877', '3879', '3880', '1422', '1422', '1423', '2578', '2796', '2798', '2799', '2800', '2800', '276', '278', '2801', '2801', '2803', '2804', '2804', '2805', '2806', '22279', '21330', '8191', '5036', '5038', '5039', '5042', '5045', '5048', '5050', '5053', '5056', '7228', '7228', '1351', '1352', '1354', '1355', '1361', '1361', '1363', '1373', '1373', '1406', '1406', '1084', '1110', '1110', '11193', '11193', '22598', '22138', '23578', '23578', '21697', '21697', '21697', '21697', '1207', '1207', '2913', '61', '61', '62', '178', '178', '260', '260', '625', '625', '625', '625', '693', '693', '1795', '1795', '1795', '1795', '2396', '2396', '2396', '19162', '19162', '19162', '15610', '15610', '4362', '4362', '11835', '11835', '3430', '3432', '3014', '3015', '3034', '2546', '971', '971', '971', '15', '192', '699', '699', '699', '279', '279', '12902', '19955', '64', '64', '64', '103', '103', '1424', '2159', '13868', '22036', '22218', '22231', '6478', '6478', '3147', '3148', '3149', '2890', '2890', '2891', '2891', '4732', '4734', '4274', '4276', '4278', '4279', '4281', '4282', '4284', '4286', '4290', '4292', '3479', '3483', '3486', '3489', '3491', '3493', '3494', '3496', '3499', '3501', '48', '270', '270', '2417', '1063', '1063', '1063', '1108', '1119', '1131', '1131', '1131', '21248', '21248', '21833', '2744', '2745', '1405', '1405', '1405', '5143', '5145', '5148', '5149', '5151', '5153', '5155', '5156', '5159', '5160', '11723', '11032', '21694', '21694', '3393', '16', '16', '212', '212', '802', '1542')
AND `p`.`status` = 'enabled'
AND `l`.`bhk` IN('4')
AND `c`.`city_id` IN(1)
ORDER BY FIELD (loc.location_id, 41, 319, 63, 135, 333, 86, 301, 741, 232, 45, 93, 547, 562, 113, 10, 28, 61, 332, 257, 270, 209, 223, 4, 178, 68, 56, 328, 110, 250, 224, 303, 744, 43, 767, 276, 246, 5, 255, 275, 543, 566, 256, 531, 183, 40, 175, 145, 263, 198, 3, 92, 236, 35, 173, 261, 143, 329, 71, 298, 300, 740, 288, 151, 571, 220, 167, 147, 222, 237, 196, 572, 105, 82, 53, 179, 247, 144, 324, 235, 80, 123, 94, 231, 177, 238, 302, 280, 60, 193, 243, 525, 121, 163, 762, 64, 74) DESC, `r`.`insertdate` DESC, FIELD (loc.location_id, 41, 319, 63, 135, 333, 86, 301, 741, 232, 45, 93, 547, 562, 113, 10, 28, 61, 332, 257, 270, 209, 223, 4, 178, 68, 56, 328, 110, 250, 224, 303, 744, 43, 767, 276, 246, 5, 255, 275, 543, 566, 256, 531, 183, 40, 175, 145, 263, 198, 3, 92, 236, 35, 173, 261, 143, 329, 71, 298, 300, 740, 288, 151, 571, 220, 167, 147, 222, 237, 196, 572, 105, 82, 53, 179, 247, 144, 324, 235, 80, 123, 94, 231, 177, 238, 302, 280, 60, 193, 243, 525, 121, 163, 762, 64, 74) DESC
 LIMIT 15<br />error Severity: error --> Exception: Call to a member function result_array() on bool /var/www/html/application/models/UrlstructureModel.php 3907<br />error Severity: Warning --> Cannot modify header information - headers already sent by (output started at /var/www/html/system/core/Log.php:172) /var/www/html/system/core/Common.php 570<br />