1570436805
a:2:{s:4:"name";a:739:{s:32:"09933bc3aa8121130dccafbd598f9059";s:22:"`umair_property_mngpk`";s:32:"8b62a3caed6255e54cba5aaf1dac335d";s:16:"`configurations`";s:32:"47eb7bb09414c64f779510914712b6ee";s:7:"`count`";s:32:"bfd1d19ec660fb1e73d5dbc1c5621331";s:20:"`Configuration`.`id`";s:32:"3b8ba43c4c4775c80e3b83ee901b9fdb";s:15:"`Configuration`";s:32:"fc4c528ae40d23f09280dab99194a955";s:6:"`name`";s:32:"46f0616b4de2640a4fc703fd92f5a277";s:13:"`domain_name`";s:32:"d1973a4d4309692bc072cb7a8ef13baf";s:12:"`meta_title`";s:32:"881a057e32cb5778a1919e3473b39464";s:11:"`meta_desc`";s:32:"794a2b1f842007d85813d169d39c6ea8";s:10:"`timezone`";s:32:"739886a6678406cad930b114611aa067";s:19:"`organization_name`";s:32:"ae1bde34794270bb273f407db5974619";s:7:"`email`";s:32:"472551d38e1f8bbc78d7dfd28106166f";s:10:"`modified`";s:32:"8273b4ccb043593ce7997a3e9c96b5dd";s:44:"`umair_property_mngpk`.`configurations`.`id`";s:32:"c071af6ecfb13a59f3164c174f445e8f";s:22:"`Configuration`.`name`";s:32:"0abd15f524993cc99f3c648e4b268f58";s:35:"`Configuration`.`organization_name`";s:32:"7be35016666e80f37a8e8fd3d7d4c6fa";s:29:"`Configuration`.`domain_name`";s:32:"0626c1a58ccee23d772a1c51e4105633";s:23:"`Configuration`.`email`";s:32:"4f718f7b591bb182406e49513e09e75c";s:28:"`Configuration`.`meta_title`";s:32:"3d61fc38da987a7a138c199a13e4ed32";s:27:"`Configuration`.`meta_desc`";s:32:"c741c21be643f78843cae81a3e22acf3";s:26:"`Configuration`.`timezone`";s:32:"e6750f66b1fec212bae6161c5e2b89f0";s:24:"`Configuration`.`author`";s:32:"6b4788c5ac67e6fc07a6db51441bf2ec";s:34:"`Configuration`.`sms_notification`";s:32:"1e47cc37b0e36c0afd89fb6b6d84e9c9";s:36:"`Configuration`.`email_notification`";s:32:"536700d60c6b375eabef54ab3644ff2c";s:29:"`Configuration`.`guest_login`";s:32:"702e8591e3fc64d971b90c6c15f81d0d";s:27:"`Configuration`.`front_end`";s:32:"aafedaac4199903022b2a4abd278f468";s:24:"`Configuration`.`slides`";s:32:"cbefa0c6731c03f73a86f1e11dc08411";s:27:"`Configuration`.`translate`";s:32:"7eea7762a78eaa3f628f09a83746c554";s:25:"`Configuration`.`contact`";s:32:"c9abf79796abfdcfb99c3bf37d681e48";s:23:"`Configuration`.`photo`";s:32:"82a4c8720ec41ab100596328849e2759";s:26:"`Configuration`.`currency`";s:32:"efa5dfb1f96dbe710e8854078c4ff2c7";s:29:"`Configuration`.`date_format`";s:32:"2256154dff65b2869086249530a9cd6c";s:25:"`Configuration`.`address`";s:32:"52ee9245317e8504d60b6745f48f9149";s:33:"`Configuration`.`account_details`";s:32:"9982b005b722c565567ab57de3e15eb5";s:28:"`Configuration`.`short_name`";s:32:"0c4f754f0fffb1cfa8be6831e7164d2b";s:26:"`Configuration`.`due_days`";s:32:"c49a2be3eb069b875f6532d98d0fd59f";s:27:"`Configuration`.`late_fees`";s:32:"d1a7bfe6733cd8e2e46362c826a6ea32";s:26:"`Configuration`.`language`";s:32:"a09044724f19b616b220086fc057e70d";s:26:"`Configuration`.`dir_type`";s:32:"7ba71527df9064af8414d4d31bedd422";s:27:"`Configuration`.`min_limit`";s:32:"0d70a289fccfcaf9c6e5433c36620d34";s:27:"`Configuration`.`max_limit`";s:32:"5883eb07080dfbae254ea72d041c2bc2";s:25:"`Configuration`.`map_key`";s:32:"ffb8cda7eb7add1b423d422664ef506f";s:30:"`Configuration`.`captcha_type`";s:32:"2eac04c3062fc39005047e0fff827226";s:25:"`Configuration`.`created`";s:32:"00302da36baf8c2d307c282a0020983d";s:26:"`Configuration`.`modified`";s:32:"5f0aab60421ad5102305b4f426d33831";s:12:"`currencies`";s:32:"c69d94df7e0d4ead7b74c0a041e481fc";s:15:"`Currency`.`id`";s:32:"24a5756ebc35e0c1ec7b5f0988eda1c0";s:17:"`Currency`.`name`";s:32:"890a8a5a4a339d10fdc45bba66a1b5e9";s:18:"`Currency`.`short`";s:32:"f786552daeda123b8fbf6df9d4e24cf8";s:18:"`Currency`.`photo`";s:32:"a7d5f261f745a0ddd88bd698669a7d4b";s:10:"`Currency`";s:32:"a403eaee4361965f09877b67a15ea08a";s:10:"`contents`";s:32:"93669991e84294fea55d3a83e088f715";s:14:"`Content`.`id`";s:32:"b4c9f6876b1974ccc81a6c4a9da08b92";s:21:"`Content`.`link_name`";s:32:"ce09a0cb5a9f6c33ca260c3f4834bded";s:21:"`Content`.`page_name`";s:32:"92594a1a003cdd6ede1627020b7a7a14";s:21:"`Content`.`page_icon`";s:32:"e6092c1cd4d4703c08fd3faeacb0798d";s:18:"`Content`.`is_url`";s:32:"805c239e7796bbd667f51b3e85057e3a";s:15:"`Content`.`url`";s:32:"612743a43db3b24d27ebcc35a4721697";s:22:"`Content`.`url_target`";s:32:"a79c05340eb5a0fd0bfefa4e0174f2d2";s:24:"`Content`.`main_content`";s:32:"aefa770ee277271c26a46837c04c2635";s:20:"`Content`.`page_url`";s:32:"a47d3a7982cfca1032c492a80d9cd940";s:16:"`Content`.`cols`";s:32:"0a4b4f6c6323aeb086315d839f1de98f";s:20:"`Content`.`ordering`";s:32:"c903830cb95625ae568911e6edc13c76";s:17:"`Content`.`views`";s:32:"df2da9b2812c1c41cb4817d717513955";s:21:"`Content`.`published`";s:32:"97d2df84ebe1b48753989bdd114b4c18";s:19:"`Content`.`created`";s:32:"1ab8711c84d2281547f741d1ae016d3d";s:20:"`Content`.`modified`";s:32:"005370997d3f1238c37e509af6254e79";s:11:"`published`";s:32:"e06e5d74e5c6ba717fd5e5863a0447d3";s:9:"`Content`";s:32:"316db3ebaabf75bc4a6fb0e3ff6ec034";s:10:"`ordering`";s:32:"88f90b87edefbb9795141f554ba538c8";s:15:"`emailsettings`";s:32:"eb27c50b8dea3efda5b182b59bf45bbe";s:19:"`Emailsetting`.`id`";s:32:"e143b4c61cf01cd0ce7e9842e73ff805";s:21:"`Emailsetting`.`type`";s:32:"6b7373b442a5a25e6905ae9e000c8050";s:21:"`Emailsetting`.`host`";s:32:"9e2c040f85a85b0687a240a6943e250e";s:25:"`Emailsetting`.`username`";s:32:"bbceafa0664e0b570c54fbfb7ad8bc68";s:25:"`Emailsetting`.`password`";s:32:"441f2768a8e351fdaf0ffe8caddbe8e4";s:21:"`Emailsetting`.`port`";s:32:"37151fd4504c3b6e217baa5f4b88f3ad";s:14:"`Emailsetting`";s:32:"2a2046a9c7d21e87f132bf2acb37c9a8";s:7:"`pages`";s:32:"fc4c7b2aae9faf05d8b29235d1dfdf02";s:11:"`Page`.`id`";s:32:"18ca3f36fa9fd685c6aae2be5e430381";s:19:"`Page`.`model_name`";s:32:"dcb1865173b4ab1808dc041e19be19bb";s:18:"`Page`.`page_name`";s:32:"3947801cd5b476bec4d921747c649230";s:24:"`Page`.`controller_name`";s:32:"dd1e7cc9177c2dcf2e7a44eed54f2518";s:20:"`Page`.`action_name`";s:32:"6a4ab917ffa55287c100a66f604aad40";s:13:"`Page`.`icon`";s:32:"c6ff6c38de4db091b3bc1112c7d35e61";s:18:"`Page`.`parent_id`";s:32:"84e3ac4704620dfbc5a9c69c3adb3443";s:17:"`Page`.`ordering`";s:32:"60fb0c4eb7be6ec838b855c9c17f225e";s:18:"`Page`.`published`";s:32:"9867d52e8c724c3fa006d3b4c30268cb";s:17:"`Page`.`sel_name`";s:32:"52323ee85fe5c8e3ed4efbc12a850b36";s:11:"`PageRight`";s:32:"deab1c9da54d1104e4c0579ac7d7de60";s:21:"`PageRight`.`page_id`";s:32:"9bdc42ca601a370685faa8fd5501e45d";s:13:"`page_rights`";s:32:"f98d4c4e18023c63de2db080db5e074f";s:23:"`PageRight`.`ugroup_id`";s:32:"a30ee26c6b598614397ab9db3c5106f6";s:11:"`parent_id`";s:32:"cf09c295aaaf051093f9def4cf09b3b4";s:6:"`Page`";s:32:"f94a437fb7858e092079378f93ef2c71";s:7:"`users`";s:32:"3a2d7c0e004aa9f6f278d01135729675";s:8:"`slides`";s:32:"8af3cd68eff2a7f7849a589781f668b8";s:12:"`Slide`.`id`";s:32:"7766f4b10e671b766178e3789bb8cded";s:20:"`Slide`.`slide_name`";s:32:"4a8651d46b3d749b3603453ad7006bd4";s:18:"`Slide`.`ordering`";s:32:"97e0c09b97b485f8198ac40da22a72e1";s:15:"`Slide`.`photo`";s:32:"e9a57a3939a2c71eeea74f92309e0ba3";s:14:"`Slide`.`dirt`";s:32:"eb0ebb96ab72edadac58b4314f0851ba";s:16:"`Slide`.`status`";s:32:"66fb0725e40aff1de113a5e54e17be93";s:17:"`Slide`.`created`";s:32:"c7d200e55df83a12cbc75b2280c067c5";s:18:"`Slide`.`modified`";s:32:"cf9f9fbbb24544659ae4b59937ecb570";s:8:"`status`";s:32:"81d501999a118b74410e99069e0d2de4";s:7:"`Slide`";s:32:"2c2a0b38c8ffc0dc28cb50556016917f";s:10:"`projects`";s:32:"1fa607c591262aad212165a106113bb0";s:14:"`Project`.`id`";s:32:"90a2ec580e7d0d2dc215ccd8a3c5c468";s:16:"`Project`.`name`";s:32:"5dba0f1da4a6491b6373d5070d73b556";s:17:"`Project`.`phone`";s:32:"a35f3557b7d9987ccbec38e02f0c0746";s:18:"`Project`.`mobile`";s:32:"f4f168c7aa5b99115a975dc04f4c512c";s:17:"`Project`.`email`";s:32:"f716662a179db0e57987f5a6e28115dc";s:9:"`Project`";s:32:"66b1a8cfc4c41807b2f9874d43e0a32d";s:12:"`properties`";s:32:"124c502abaae787b323980b2aac156e9";s:15:"`Property`.`id`";s:32:"9552350dda66a42e56e84929cb8eb4f2";s:20:"`Property`.`user_id`";s:32:"10d986ec0242691df69b185205f0fe96";s:20:"`Property`.`uniq_id`";s:32:"e52b7cc59a7691b8d6a0bcaec6fe7fec";s:23:"`Property`.`project_id`";s:32:"4d04cab68fa8e3d2e16b9dbbe68532c3";s:24:"`Property`.`location_id`";s:32:"6f67b5d81bde20810ad139063b888810";s:24:"`Property`.`contract_id`";s:32:"755f64b96f78b150f9d3ad396bd752ac";s:20:"`Property`.`type_id`";s:32:"6db6f758da36a1681fb21af816b62792";s:20:"`Property`.`unit_id`";s:32:"a4ea4499c0a3272652713aecf7267c03";s:17:"`Property`.`name`";s:32:"4e67bea4159083d44f4d73197c1a166a";s:20:"`Property`.`address`";s:32:"b0c1500896ea4fa47e621d560d72d073";s:24:"`Property`.`description`";s:32:"fdf27a06f56afef48d50ea68229c864d";s:17:"`Property`.`area`";s:32:"e4dbd76933cec08a3bec8956746aae5a";s:18:"`Property`.`price`";s:32:"125bfc931881ee98acced5ec0032f29d";s:29:"`Property`.`agent_commission`";s:32:"f1d39f57cb1a70b8402e0b76a38a6bcc";s:28:"`Property`.`commission_type`";s:32:"06dad79a8d83f0b6e768e1d98eb1cc16";s:18:"`Property`.`floor`";s:32:"7527123d685b7780e8acae26f8ac1ca8";s:20:"`Property`.`bedroom`";s:32:"3654027595b41d6e8f8139b96bbfd787";s:21:"`Property`.`bathroom`";s:32:"5377351f384d9f0f706cd387ebe34938";s:19:"`Property`.`rating`";s:32:"b14972b3aa5a88f83f7686796ddb04ab";s:25:"`Property`.`rating_count`";s:32:"f115f10998c403732bf846c5ab609f81";s:25:"`Property`.`rating_users`";s:32:"ca8bddf7781811ac127632248711aa24";s:21:"`Property`.`latitude`";s:32:"cd41f0517915fe45c7bdd14738ac69af";s:22:"`Property`.`longitude`";s:32:"e0d719b2d0cc322186dc772966402338";s:18:"`Property`.`video`";s:32:"a47a2c80a434216c141d89b466d524cc";s:18:"`Property`.`views`";s:32:"e358433e422e8a1a43750adc9a862fd8";s:25:"`Property`.`allow_rating`";s:32:"ae4fadb94c05bb8fcd853769fb216b00";s:26:"`Property`.`allow_comment`";s:32:"db2f8d2d10276b6c082fb03ec1a1f08d";s:19:"`Property`.`status`";s:32:"d9ddcc5ed58eba57b7372fc18c81f3d4";s:21:"`Property`.`featured`";s:32:"2b791a73b08b330c5f7e0aacfc0b58b2";s:22:"`Property`.`published`";s:32:"49b121d1a5461c30f9fc5739c29f547d";s:20:"`Property`.`created`";s:32:"65032a80621cd843559e500c9486df62";s:21:"`Property`.`modified`";s:32:"fd01190a236d541fb1fae116df6d3ea3";s:7:"`types`";s:32:"7cbdff681148fc21c7389a371853b331";s:11:"`Type`.`id`";s:32:"11a801ef21e1eed006021bc29d4428fa";s:13:"`Type`.`name`";s:32:"707aea936ddb75f82133e82ec1db6b5a";s:13:"`Type`.`dirt`";s:32:"2de7d4c42da029f5289c6d1622ab354d";s:14:"`Type`.`photo`";s:32:"acacfe661cc54cd7fe101981e17131d0";s:7:"`units`";s:32:"d174040a27bec1f4174d6d1c75570313";s:11:"`Unit`.`id`";s:32:"274fe64b43eb27faa23d3365158d686e";s:13:"`Unit`.`name`";s:32:"9ffea72c8c5c14d95a6a207e3d5f4fe5";s:11:"`locations`";s:32:"3eeee2d4e8857b3e38b0b151f0caead1";s:15:"`Location`.`id`";s:32:"dbe9ce13180da5d6556c0b56a964076e";s:17:"`Location`.`name`";s:32:"84aed5ca7734df237971a8964bd0217a";s:11:"`User`.`id`";s:32:"f6c4f9ebc219119f4115794b1d2a7aff";s:18:"`User`.`ugroup_id`";s:32:"be2651ce3dedb04135c2a406f28e83aa";s:19:"`User`.`project_id`";s:32:"1f06979ea22fa5bc09a9135aa1976278";s:20:"`User`.`location_id`";s:32:"d02461939758c2308d7bd7a6b9f8a411";s:13:"`User`.`name`";s:32:"441e6eaad1b5f34da125c63e3ecd7702";s:17:"`User`.`username`";s:32:"46bea0d8cb0ffa1c5c7f63ad1e39035b";s:17:"`User`.`password`";s:32:"0c567abda59d33188ef6d3c071242e70";s:14:"`User`.`phone`";s:32:"1668c72bbb9a98367463c1d84ac644e9";s:15:"`User`.`mobile`";s:32:"989e23b18d03d50108b9729a4e28e847";s:16:"`User`.`address`";s:32:"97c268dcd8412cd254419ed9b5f0d32e";s:14:"`User`.`email`";s:32:"979e1118ea29e0416bb10e4df67f5cea";s:14:"`User`.`skype`";s:32:"94137641a15af941b54902391b694bc3";s:17:"`User`.`facebook`";s:32:"7462a9b4199963280350abc6f4d8a5fc";s:16:"`User`.`twitter`";s:32:"aad0b0866faec884ecd96fb5c9584036";s:17:"`User`.`linkedin`";s:32:"c80f3a457d54acb1cf2b831fe3e29d07";s:20:"`User`.`description`";s:32:"3781543da4fda7f95d3b652760faaafe";s:12:"`User`.`dir`";s:32:"b2283850780d4041a514e45a63879284";s:14:"`User`.`photo`";s:32:"c3166f52a27d4d42189834333694a26c";s:15:"`User`.`status`";s:32:"1ae21cfe98ec79f0d436bc81903a5c07";s:19:"`User`.`presetcode`";s:32:"6918a1ecfa7aad41e68ffe6354696cf3";s:16:"`User`.`deleted`";s:32:"655616af09a4d136eca1b18964f0e43c";s:16:"`User`.`created`";s:32:"99bf0d2ad6325fefe617717ec0f141d9";s:17:"`User`.`modified`";s:32:"f1db9af8371a459c347d030209ea588d";s:11:"`contracts`";s:32:"09a718093074b0741faf61cb36642bce";s:15:"`Contract`.`id`";s:32:"4054aae62b6d9106dcc88a79025901bf";s:17:"`Contract`.`name`";s:32:"ecd2c751939202adba38e2b68c9f8776";s:19:"`properties_photos`";s:32:"eca92c7cd3f9042bf07ee6bb2945b5d9";s:22:"`PropertiesPhoto`.`id`";s:32:"03c17824f9cd979ee01ca9a988bd7a9b";s:31:"`PropertiesPhoto`.`property_id`";s:32:"49493eb62d06a8b43ad20e0659c517b7";s:25:"`PropertiesPhoto`.`photo`";s:32:"0511e5fda19087824ba108c655b487ec";s:23:"`PropertiesPhoto`.`dir`";s:32:"4c74550ed9a6ad697e89b8aeaef15731";s:24:"`PropertiesPhoto`.`home`";s:32:"71e05aae6796ccaf16a3889e26ede9a5";s:17:"`PropertiesPhoto`";s:32:"bea7324ea2ba07d70472f7669f02bfe0";s:22:"`properties_documents`";s:32:"fb58729dfa0b18b6cdd09a03e1468785";s:25:"`PropertiesDocument`.`id`";s:32:"72ec3875ad1642b5e936cdb906880abe";s:34:"`PropertiesDocument`.`property_id`";s:32:"94759ba9198f5788e2e048a4d4364433";s:28:"`PropertiesDocument`.`photo`";s:32:"f981224041ef2325da864491fc6d1902";s:26:"`PropertiesDocument`.`dir`";s:32:"6d5387396d99d20f8421011c39fd984b";s:20:"`PropertiesDocument`";s:32:"b4128161259a269d99bf6c7d70d76df7";s:23:"`properties_floorplans`";s:32:"a553c2b46a0d86ff52a428fa4c065837";s:26:"`PropertiesFloorplan`.`id`";s:32:"b5c7808bac9ac41eba3221c315cfa940";s:35:"`PropertiesFloorplan`.`property_id`";s:32:"163403266de55840116c59ba803fe2d4";s:29:"`PropertiesFloorplan`.`photo`";s:32:"1bbff2dec2c509bd06dffcf69afacfca";s:27:"`PropertiesFloorplan`.`dir`";s:32:"e689a887cf92b765235680aa82fcddf0";s:21:"`PropertiesFloorplan`";s:32:"883e5ee58fcff55b813ff95b82e53765";s:6:"`Type`";s:32:"326a3b1652cc635fed6b3ffba8b3e3f1";s:6:"`Unit`";s:32:"29229326100657d04e3cfba466f09344";s:10:"`Location`";s:32:"eb9b37fa6fe3e5c49f921ddcd721b306";s:6:"`User`";s:32:"8fda23c1479cfb9020f3acdea9c60b33";s:10:"`Contract`";s:32:"da668b5e20a16cdda91161ec6b65396b";s:10:"`Property`";s:32:"20edc4e4d5e73b4cc816449db0515ca7";s:7:"`views`";s:32:"fc9d6fd2d8db223be4a7484a8619f26b";s:0:"";s:32:"4be5d7bae896ec0d44f843e8b87e548b";s:6:"rand()";s:32:"cd743840cb3ed25de208aab82d8fe3c7";s:8:"`Type`.*";s:32:"df4c7d6ca0a58240797bae102d26b16b";s:19:"`Type__total_count`";s:32:"d2c23d1b4feeec456d72cdc94cc44595";s:4:"`id`";s:32:"c8062e0f2c8ab4399652cbb061e4de41";s:12:"`favourites`";s:32:"1abe9aea329950ba2ff56512309d6479";s:16:"`Favourite`.`id`";s:32:"a8efb39a9af801366c2b2c8b8b5e5427";s:23:"`Favourite`.`client_id`";s:32:"ed24324ba889e05a3bd4edba600d2481";s:24:"`Favourite`.`session_id`";s:32:"101739ef335c37c8926fdb6d09c28e19";s:25:"`Favourite`.`property_id`";s:32:"90f677477289d3d66ea4c59907ef86ad";s:21:"`Favourite`.`created`";s:32:"96c01d84531bf06ea5834fc9effd0fc7";s:11:"`Favourite`";s:32:"11c4ffea91be2b45a0003abd84cf3bbe";s:9:"`ugroups`";s:32:"84c0f4b4529bab3f482bd63e8ad40bfd";s:13:"`Ugroup`.`id`";s:32:"1067fd762c66e241bb036ca0d8591e7c";s:15:"`Ugroup`.`name`";s:32:"96588ab01b3a1a9a4ce2003ea56ab685";s:15:"`Ugroup`.`type`";s:32:"30af2da6613b472a90bb25391cbbdee7";s:18:"`Ugroup`.`created`";s:32:"02d7c6725d94fd521f2f0a373017d186";s:19:"`Ugroup`.`modified`";s:32:"b4221858979ef5fe707ecc8191bc1a04";s:8:"`Ugroup`";s:32:"7e26ed36866b983767662dfb7fcd5160";s:11:"`client_id`";s:32:"d20e7bceeb0135a07432718f0d5096d7";s:9:"`created`";s:32:"5f43e426f20c6983ff7461e70ec2109d";s:14:"`DealsPayment`";s:32:"b252854deeb44d8a3309f585975b1877";s:14:"`total_amount`";s:32:"fb2ce0272dbc6de3b671a723f300e944";s:16:"`deals_payments`";s:32:"aaf8c8658a557a36522bf16015730e1f";s:28:"`DealsPayment`.`property_id`";s:32:"b0cec17c2c43e88a50e6e8dc38631c5d";s:29:"`DealsPayment`.`payment_date`";s:32:"de45f5c6cea1372cfcc1820bf77bec05";s:17:"`ExpensesPayment`";s:32:"db198ca0c6a4165474cc4a02b49ab3ea";s:8:"`amount`";s:32:"07e34d9fe21a11615c87bf2bb8f7743f";s:19:"`expenses_payments`";s:32:"d952fa62671ef2de17f921e6c0aed21b";s:9:"`Expense`";s:32:"2c689052ac71a2dc27b6e3e34e6c63db";s:14:"`Expense`.`id`";s:32:"cdf9f59c0402d7c686981a0b570ddd48";s:30:"`ExpensesPayment`.`expense_id`";s:32:"939307e89be5bd78483f6b1461dd6e8f";s:10:"`expenses`";s:32:"d1c0f08458d642257b9072ef2c45f535";s:18:"`PurchasesPayment`";s:32:"b24562411eb13df35625c6814552211f";s:20:"`purchases_payments`";s:32:"11a5c3bf4094328b3edac62a7aabe7c6";s:10:"`Purchase`";s:32:"e550a0be958d02e0077415787edeb3ff";s:15:"`Purchase`.`id`";s:32:"2b4b51a766bde8f6aaaad89f7ef57036";s:32:"`PurchasesPayment`.`purchase_id`";s:32:"056b1aeac0820bc2bcce877a1fd6402b";s:11:"`purchases`";s:32:"d0817349c3107b09f3d3539008750d30";s:11:"`calendars`";s:32:"f56dc2841f9a26de790c5d41c3be8131";s:15:"`Calendar`.`id`";s:32:"c7e24b23e35288b2deaf19e9b297fdb0";s:20:"`Calendar`.`user_id`";s:32:"d1c630e141b9267ff0640f297aa2a49d";s:25:"`Calendar`.`message_type`";s:32:"c01e0e644cecac3516c01c090108f602";s:23:"`Calendar`.`start_date`";s:32:"754cd90c68fa6cffe3723381b720a66c";s:21:"`Calendar`.`end_date`";s:32:"e9b47045e037fa1f1307082392f2cbcc";s:18:"`Calendar`.`color`";s:32:"a2be22fa50442626f58281deb3d9077e";s:21:"`Calendar`.`comments`";s:32:"4febad1d48b5e7918f203bbed355d6f5";s:22:"`Calendar`.`is_repeat`";s:32:"5a42ba7b7cb2b42f9805db6fde3df3ec";s:24:"`Calendar`.`repeat_type`";s:32:"9c82910a6fe1d04edd00c418c443eb10";s:22:"`Calendar`.`repeat_no`";s:32:"10c273fba43c4c9e1b8db4b408e71243";s:12:"`start_date`";s:32:"360bd4e6873405f5f1e5da46948e3718";s:10:"`Calendar`";s:32:"b940d6df96d8285c0f33afd23b62dfcb";s:15:"`Client`.`name`";s:32:"4b82db4a57b6fe0621b0ce8dcf08a168";s:8:"`Lead`.*";s:32:"5118a87e7e062a3a0430d0f3b4d31128";s:10:"`Status`.*";s:32:"09fb0194ed8656d97f2f63365d7def2a";s:7:"`leads`";s:32:"887027b18bc43bba9d9c7932932e6a48";s:8:"`Client`";s:32:"6f1879e7e6303b0a8b3b1046849b17d1";s:18:"`Lead`.`client_id`";s:32:"ece1f59cce83175769ed20f0b8edf57d";s:13:"`Client`.`id`";s:32:"0b56e967fca2b40dba5709f5a0a03fd1";s:9:"`clients`";s:32:"cdc8a52509b4dae8e00c2aa2320363f8";s:8:"`Status`";s:32:"d5986312f48220872a3602aff185ebcc";s:18:"`Lead`.`status_id`";s:32:"253209e0eef0589d2d30429864895f60";s:13:"`Status`.`id`";s:32:"aa610d3b4cab53a0a481f7e4b75df8ef";s:10:"`statuses`";s:32:"a779857b8aa61a84d519244f36534c81";s:11:"`follow_up`";s:32:"bd15325aeb273e706e3d89d7e707e728";s:6:"`Lead`";s:32:"03d48e4c98d0639e46b366894523b7ec";s:14:"`Weblogo`.`id`";s:32:"bc6855b3f30a782e78cac4151c00347b";s:16:"`Weblogo`.`name`";s:32:"e512b2ea3f9f9a6ee15d6f0e9c7fb90d";s:29:"`Weblogo`.`organization_name`";s:32:"35725268446ad01168f3d88a55e69dfe";s:23:"`Weblogo`.`domain_name`";s:32:"b582dd5db0806427e12f58476a785fb9";s:17:"`Weblogo`.`email`";s:32:"0f5b14b19ea9a7f46a9a9f4160a291c1";s:22:"`Weblogo`.`meta_title`";s:32:"513ea4b2d8bb3b26228fbbc0e9d16ef1";s:21:"`Weblogo`.`meta_desc`";s:32:"ee0c5ef09870fb81553855d5f289cbcf";s:20:"`Weblogo`.`timezone`";s:32:"b4f2d3ec586ec1e80c6b21393da531e6";s:18:"`Weblogo`.`author`";s:32:"5ea0c003bebd761f4678e199d0231b11";s:28:"`Weblogo`.`sms_notification`";s:32:"2c508b5734a50325958bfa75e89576b3";s:30:"`Weblogo`.`email_notification`";s:32:"d38ed2b5c45d687537b100d95cd77046";s:23:"`Weblogo`.`guest_login`";s:32:"8fc984e7c8c14a34fc3b64db47418a2a";s:21:"`Weblogo`.`front_end`";s:32:"81796e1b1a7267dc62880f13ec1c463c";s:18:"`Weblogo`.`slides`";s:32:"84da580ba92092808ffb4e03d2c61f08";s:21:"`Weblogo`.`translate`";s:32:"016a284821aab05ed88f045159bb7d5f";s:19:"`Weblogo`.`contact`";s:32:"8c3d88fbe712550576b1f16edd119a22";s:17:"`Weblogo`.`photo`";s:32:"6da91f6494c3a11879f9ed3c5f16a52b";s:20:"`Weblogo`.`currency`";s:32:"d717f9ce27b7f7726a95589926f2a5b2";s:23:"`Weblogo`.`date_format`";s:32:"2b394935dd8a38332d3f79b810958afb";s:19:"`Weblogo`.`address`";s:32:"9a776bdd6a85c48d2ef681882710d880";s:27:"`Weblogo`.`account_details`";s:32:"45e13f6704cb79923696d3561ac15b97";s:22:"`Weblogo`.`short_name`";s:32:"9b3643d44d0c6daeb4838e34be32693c";s:20:"`Weblogo`.`due_days`";s:32:"7659c64bfba85f76037001c9c3e745e0";s:21:"`Weblogo`.`late_fees`";s:32:"0dfea8ed04e0a9f51c8f7a861e7064d4";s:20:"`Weblogo`.`language`";s:32:"0a66df309c656760ce474fe92c86f0a4";s:20:"`Weblogo`.`dir_type`";s:32:"fdf1d91121f5bc43fafb5d5b8c6be48f";s:21:"`Weblogo`.`min_limit`";s:32:"bcd1ed0113efc1198f18922ae595b1fd";s:21:"`Weblogo`.`max_limit`";s:32:"0fac64fe916923ae5ac48e7b4906fb70";s:19:"`Weblogo`.`map_key`";s:32:"3c9d976baf730c42160c0f8f684bb231";s:24:"`Weblogo`.`captcha_type`";s:32:"82806ac05e1d5143374a25b82b662506";s:19:"`Weblogo`.`created`";s:32:"4c7bca3c0e90605911cc6665fc2f53d2";s:20:"`Weblogo`.`modified`";s:32:"a8a2544b013ea05123f558d944ade287";s:9:"`Weblogo`";s:32:"2c1a056a75b8e3aa50b58f578b797b4f";s:7:"`photo`";s:32:"7c65885f84c61b87ba3dcb267e53cc0d";s:9:"`address`";s:32:"b7e99beffa1dff0f921947fdf354e04c";s:17:"`account_details`";s:32:"5b3a13b3da8d54eca1826e418b96dbd3";s:10:"`currency`";s:32:"600f831989a08b27c943912bd409b7a9";s:10:"`language`";s:32:"5f89b6c474a38e1359667d94caa78e2c";s:11:"`min_limit`";s:32:"e691dfbd28f2679532e46b2875cd2b87";s:11:"`max_limit`";s:32:"e6ed8017588c40807f4c3221b8eb659c";s:13:"`date_format`";s:32:"8458601441abb85a643b0a526925cafe";s:9:"`map_key`";s:32:"49f64bb7a39b20d5f6ede6d55ea64396";s:14:"`captcha_type`";s:32:"6d3c04b2f6548a673c04781c54565076";s:10:"`dir_type`";s:32:"e0eeb28d0c105fbc0b94a015465d8b6f";s:12:"`short_name`";s:32:"9fc167f6bcdc5abf9ceca73fc23e3a6d";s:9:"`contact`";s:32:"03add407a5721eb0032fdd93bc743f5d";s:10:"`due_days`";s:32:"88353f226bd92b65a5c3825e3d8db8f9";s:11:"`late_fees`";s:32:"77f27ed2471450a9e6072e8c0ebffc3c";s:20:"`email_notification`";s:32:"0302d6b279da11cf6212f439c8640c91";s:18:"`sms_notification`";s:32:"111bb26614662c5c5ebca6a55df96df6";s:11:"`translate`";s:32:"1fef8b9396ffbd374852bf30798be8cc";s:11:"`front_end`";s:32:"f5cef457c26969d6344f14fdbd073657";s:38:"`umair_property_mngpk`.`contents`.`id`";s:32:"69fb260303ded8f5b211f5e2855c82c4";s:9:"`Agent`.*";s:32:"220e8b11066e82da82176d8ddaa66b6b";s:20:"`Agent__total_count`";s:32:"0066d94f40207bebf7737e092ad9a630";s:19:"`Agent`.`ugroup_id`";s:32:"1676b4a62ba78f5bb74c1c24b6ee8b8c";s:12:"`Agent`.`id`";s:32:"df9cfeef9515b770e809910343770d57";s:7:"`Agent`";s:32:"89377b805733e03f8a3f14f1770d44ef";s:14:"`Agent`.`name`";s:32:"2b06887491ec830d4c2be553068478a0";s:10:"`Projects`";s:32:"4eb65c718d187cd425177aa9a83f813a";s:40:"`umair_property_mngpk`.`properties`.`id`";s:32:"82fe03f7273712547d2c31f93ee271e6";s:16:"`Feature`.`name`";s:32:"91967340439e493c33bc21e8590b9194";s:21:"`properties_features`";s:32:"b976cba887479623e9a45416d09c794a";s:9:"`Feature`";s:32:"ecd1a819938f33a5394b5b8be4a2754f";s:14:"`Feature`.`id`";s:32:"8e11cf814b2aba6e16f7817430ef0c2c";s:32:"`PropertiesFeature`.`feature_id`";s:32:"9b1acf92108be93042969ae0cd15c662";s:10:"`features`";s:32:"227f8791de3181fad0fa782e5638b5b9";s:33:"`PropertiesFeature`.`property_id`";s:32:"64bb2a752de063c026d5039b966825e6";s:19:"`PropertiesFeature`";s:32:"2c0539fceb7a6dcc7ce2bca41ffe9d39";s:20:"`Agent`.`project_id`";s:32:"288436fbfd278986d44f1fc25ca130e9";s:21:"`Agent`.`location_id`";s:32:"969c7bb2d55e1284e4c33b831f15af29";s:18:"`Agent`.`username`";s:32:"0c6d426076217e26f17356f71cb03949";s:18:"`Agent`.`password`";s:32:"aba0152501db58ecc7024496ef4aaee4";s:15:"`Agent`.`phone`";s:32:"1ae01111aa53ac6d08ec19c56d7e30ec";s:16:"`Agent`.`mobile`";s:32:"404ff746020b67b6cc409a54836585b0";s:17:"`Agent`.`address`";s:32:"24381cb066de544b9f94ba5df96994cc";s:15:"`Agent`.`email`";s:32:"41164bfb958b962f069397ecbb9b18cd";s:15:"`Agent`.`skype`";s:32:"e39f9cfe96aad95a4a6999957f1574f6";s:18:"`Agent`.`facebook`";s:32:"edcabd34c0d9d81d774b39498e880187";s:17:"`Agent`.`twitter`";s:32:"e44e7c767d5e6e3312be9565f5507d35";s:18:"`Agent`.`linkedin`";s:32:"b2a162ea98137a3fa2a3eac032398e42";s:21:"`Agent`.`description`";s:32:"6c9d7fab7515abb8770a9236b30ec0a8";s:13:"`Agent`.`dir`";s:32:"90c1ee122e73ef2b08c058ac5761430a";s:15:"`Agent`.`photo`";s:32:"a683f00e0f450b022eee863003bfac8b";s:16:"`Agent`.`status`";s:32:"4e18b096119ea96ac9da87b59eeab455";s:20:"`Agent`.`presetcode`";s:32:"727987be538b415cd7dfd48994d132a4";s:17:"`Agent`.`deleted`";s:32:"a2c70136e3ce6139fc9b09a013806575";s:17:"`Agent`.`created`";s:32:"01914de87b5fb8f1d2f931b1ec3ff249";s:18:"`Agent`.`modified`";s:32:"9508fa65a384cfae35fed861bb9c74cb";s:10:"`awallets`";s:32:"8d5c462ff0ef2de28385db657e4de3a7";s:14:"`Awallet`.`id`";s:32:"20d27025511af1cd2a8c463e54edd0a4";s:19:"`Awallet`.`user_id`";s:32:"7a76518a908e49f6840acbde37e20f43";s:22:"`Awallet`.`project_id`";s:32:"c09f7490ef34e74aba81d3fa8dcfc5e5";s:17:"`Awallet`.`debit`";s:32:"b8efb813f2ec9dd46e6341bd70ef7a9f";s:18:"`Awallet`.`credit`";s:32:"f425fb70428f3bfc721c305acab2bc75";s:19:"`Awallet`.`balance`";s:32:"d2871f0ba55cf229c8e6f9ea38f391a1";s:9:"`Awallet`";s:32:"9a25e8dc101137f0c7d7985e66cd8cac";s:11:"`ugroup_id`";s:32:"57ed50ee0468622064dd76228977c96b";s:12:"`project_id`";s:32:"6d77646a2fd9ab65f8e3344d7dce661a";s:10:"`username`";s:32:"f2bde608b110001183014095843d7e4e";s:13:"`location_id`";s:32:"599e20dedd4bde7e7be4c8ade32e6908";s:7:"`phone`";s:32:"1357ce098513d50a27833713864aa67c";s:8:"`mobile`";s:32:"d8c470ff22f2e0bb226bbef5495d16f6";s:7:"`skype`";s:32:"42898f73af1d9fac0c541a731ab74ad5";s:9:"`twitter`";s:32:"df78a8ac3c935ee13dc9dc7325fcd580";s:10:"`facebook`";s:32:"a94ff5cf11e207982393f9b0970d7954";s:10:"`linkedin`";s:32:"831669deb653fd69299f4826920d7f17";s:13:"`description`";s:32:"af23beeb9b10aa9cfae1694de55a6a33";s:35:"`umair_property_mngpk`.`users`.`id`";s:32:"9e072b774f5258d40b715ffde6c8d48a";s:38:"`umair_property_mngpk`.`projects`.`id`";s:32:"35c327a6a1a61c5a9c2714981a61806e";s:12:"`session_id`";s:32:"440787fecaa463de67e6521b1463091a";s:13:"`property_id`";s:32:"c1cb671f273af05d7c48e6fa5a34d827";s:24:"`PropertiesFeature`.`id`";s:32:"469f0eca4934529a8ebe3db2dddf24e6";s:12:"`categories`";s:32:"eb70110d19c376647f122ba6a9a6296b";s:15:"`Category`.`id`";s:32:"5bea7b19e535d658896259ecb5046648";s:17:"`Category`.`name`";s:32:"895ec6f91cf00656056af226532e8e27";s:10:"`Category`";s:32:"7ff9aa8bbf72e198f1c1044ab26dab26";s:14:"`Contact`.`id`";s:32:"c1ddba9d042432855ce4e152c2d1b35b";s:23:"`Contact`.`category_id`";s:32:"7b82fad9aae6a95ca6e2bdef9e25b31d";s:19:"`Contact`.`user_id`";s:32:"17e611c746b66e519f8f67ca822df3c1";s:22:"`Contact`.`project_id`";s:32:"8f5c2d25dfaca516ab53a249a5749286";s:17:"`Contact`.`email`";s:32:"e2a74cb9660006ae743ac40f167df3f4";s:20:"`Contact`.`password`";s:32:"96cd1efc65734939ef4e42b662a39126";s:18:"`Contact`.`mobile`";s:32:"0fb422ae9474c7b6d1cb71d23ab03834";s:17:"`Contact`.`phone`";s:32:"157b512dd158afef67f0a1d64c1a7e8f";s:16:"`Contact`.`name`";s:32:"0c54da4e838f3c36dfad5a549dfe4051";s:19:"`Contact`.`address`";s:32:"6eafc5be6f666a74fb939fbc8561e861";s:20:"`Contact`.`district`";s:32:"0edb2c12c3da1397f859ec080627eff4";s:17:"`Contact`.`state`";s:32:"704cf48037c337691741dbabdd53d65a";s:19:"`Contact`.`pincode`";s:32:"e49c80f04ec979a49e1129f10dfe8020";s:18:"`Contact`.`status`";s:32:"eb136b7d33550208995cf3d9d2375e59";s:22:"`Contact`.`last_login`";s:32:"34a95d67c8b4393af17c1cfa6223a2a3";s:16:"`Contact`.`dirt`";s:32:"b79669691e588642eac30a46a11161a9";s:17:"`Contact`.`photo`";s:32:"58d25bb00b4ba00faa76d17d2044fdb3";s:20:"`Contact`.`reg_code`";s:32:"8c7dbbd6c507ca1681f26ff09fda5cec";s:22:"`Contact`.`reg_status`";s:32:"3a7762b838f2264a5bf8036aee7b191f";s:22:"`Contact`.`presetcode`";s:32:"b3e76a0f61507f17507c9cf0558028de";s:19:"`Contact`.`created`";s:32:"867c1986ec287a45b9b6c9e9ee5cb678";s:20:"`Contact`.`modified`";s:32:"82ab5c00231d073942cb1017b756e444";s:17:"`Category`.`type`";s:32:"d48f57f5ff6486b97c9389c6a3560f20";s:9:"`Contact`";s:32:"b52ef56c2f364cbe37666a2db07d6e85";s:39:"`umair_property_mngpk`.`locations`.`id`";s:32:"c27900e4afab26bd176b751cc318e5e9";s:35:"`umair_property_mngpk`.`units`.`id`";s:32:"c18a6dc8941ae195877c78d91a4678b7";s:35:"`umair_property_mngpk`.`types`.`id`";s:32:"09a1e4e26a6e2921be9edd7faf74ead6";s:7:"`taxes`";s:32:"bb5723b38d4f593ab0ab83b74a02db99";s:10:"`Tax`.`id`";s:32:"ae05eb8a0e3f1220a4215c0928b3cc6b";s:12:"`Tax`.`name`";s:32:"4c8421bbe7e6c6ae09bbd77ad5c828f1";s:15:"`Tax`.`percent`";s:32:"2baedf8a39092e2ba1541a6f4a97e76e";s:5:"`Tax`";s:32:"bdbb62c8986de5037ab1311b9c003174";s:9:"`percent`";s:32:"afe22ab555d6a7ad7d62f17352d9fb38";s:35:"`umair_property_mngpk`.`taxes`.`id`";s:32:"8e0351027faf3b95bbb02816db1ae0e6";s:7:"`plans`";s:32:"264a3f14f3ae486d548e580677357497";s:11:"`Plan`.`id`";s:32:"0dedb4f4f9255cccbf4b64ba3c7071eb";s:13:"`Plan`.`name`";s:32:"ebddbc686e5defa8a64496b7c7fda9f8";s:20:"`Plan`.`installment`";s:32:"774d8b1d31247a37458225cbb184d48a";s:15:"`Plan`.`status`";s:32:"8921e88ed19228361f8af02688a1eb0a";s:6:"`Plan`";s:32:"01bdb5da96c951e6144fc8ba74591bb2";s:14:"`paymenttypes`";s:32:"b9c4b85d0f900b9da561a2b8d9932457";s:18:"`Paymenttype`.`id`";s:32:"b13365e91e95afa150c113c053af9556";s:20:"`Paymenttype`.`name`";s:32:"e71c227408a5c51008866f4d837fd01a";s:13:"`Paymenttype`";s:32:"420721d4d0a3f88421b9d4ad08f55269";s:11:"`templates`";s:32:"c42624f73397d885e4c1797aefedb37e";s:15:"`Template`.`id`";s:32:"1c69d1c491e8f2060cf0dc5095f420c1";s:17:"`Template`.`name`";s:32:"3cd267d8ae3a669e693fa96e436f3f2f";s:24:"`Template`.`description`";s:32:"a1b86c8f91804f3b672dcedbbabdf5d5";s:17:"`Template`.`type`";s:32:"1c170f2a656ebbd14ea5e7374394e9fd";s:19:"`Template`.`status`";s:32:"b5d7aee1575548f26004e9834441f275";s:19:"`Template`.`is_new`";s:32:"fb3baa7f0e9b4927e6462b0a38550ec9";s:10:"`Template`";s:32:"f9c528881cb31d93b0624c8fe942ef75";s:7:"`deals`";s:32:"ee6a1801292e9413ed6aa0d5f702df27";s:11:"`Deal`.`id`";s:32:"95380e21942b109079a6c7ff964fc727";s:16:"`Deal`.`user_id`";s:32:"2b18f90bd755e531cf9b4a03548b32a9";s:18:"`Deal`.`client_id`";s:32:"ee83388b971f00e753348fc3bbb5fcb4";s:20:"`Deal`.`property_id`";s:32:"bc19e4e5b3fa0267acc5884cb0109755";s:27:"`Deal`.`properties_flat_id`";s:32:"7e3b51fea8a245146b731c759a79742d";s:16:"`Deal`.`plan_id`";s:32:"bad5dcd024fcd1b434c2b81af58b08bd";s:19:"`Deal`.`invoice_no`";s:32:"5c986206f86c6167c374e5f5a2ffc994";s:13:"`Deal`.`date`";s:32:"7847fe452c629fc6f212dd4abb54393f";s:21:"`Deal`.`evocate_date`";s:32:"1a7f5f9204341f6a8fb97ab40225e69d";s:18:"`Deal`.`recurring`";s:32:"e34842151e40545d6529655cdbdb2d86";s:23:"`Deal`.`booking_amount`";s:32:"77474b9e05c897df4d27fe135c9af849";s:17:"`Deal`.`discount`";s:32:"9626e89dcda09ed7b1999c03befc56c6";s:21:"`Deal`.`total_amount`";s:32:"9e06e4978245aa91cd797a87e0707bf6";s:16:"`Deal`.`remarks`";s:32:"a850cac977d1f54d76faafc7f46ed558";s:16:"`Deal`.`created`";s:32:"b59787f566075239a7b260b0fa42b3f3";s:17:"`Deal`.`modified`";s:32:"9ae3438995657511159ac5183dd56992";s:15:"`Deal__payment`";s:32:"c8f94ad75351aa37d7abc363999be7d8";s:19:"`DealPayment`.`emi`";s:32:"1b0a71acf351661fd33d408ae404f103";s:23:"`DealPayment`.`deal_id`";s:32:"42251016ff89602d5bd504f11d4c58f0";s:15:"`contract`.`id`";s:32:"cfbccc5656b6f98b45de95db1fb00a6b";s:22:"`Client`.`category_id`";s:32:"6a1e17a22ae589ae23072a60d3001e8a";s:18:"`Client`.`user_id`";s:32:"b575efebe8dde8a854251f46d268aed9";s:21:"`Client`.`project_id`";s:32:"86e702689bf30de735385ee97362a2c5";s:16:"`Client`.`email`";s:32:"eb78d79b5d7880102376a0648f6e2072";s:19:"`Client`.`password`";s:32:"70680856c1f08800176c0710c2b2e11d";s:17:"`Client`.`mobile`";s:32:"a410e0114e64aba48a1565b8c85f4f64";s:16:"`Client`.`phone`";s:32:"5a05aab72ecf8c65c0d514e84e8df8d2";s:18:"`Client`.`address`";s:32:"9b3d40441d992fb073565b5d795cac2a";s:19:"`Client`.`district`";s:32:"9649e4a9dbddd526a5f970aa7f85d8ea";s:16:"`Client`.`state`";s:32:"11ffd58b58748e17214d35d976dac9ac";s:18:"`Client`.`pincode`";s:32:"2582d4c659d9c8d048e94ccbdf230e2d";s:17:"`Client`.`status`";s:32:"bf036d554126b91b7f35504f4d87dd4a";s:21:"`Client`.`last_login`";s:32:"3f8686381b8379501281c22dd3e766d8";s:15:"`Client`.`dirt`";s:32:"676635b1e4dfbf013ea41619d5f62c8b";s:16:"`Client`.`photo`";s:32:"27a3ac42f4887ac3753612d1e1c45702";s:19:"`Client`.`reg_code`";s:32:"811b357bbda28a46de04525582373fba";s:21:"`Client`.`reg_status`";s:32:"560c9a07ea40145475e2c07308fdd48e";s:21:"`Client`.`presetcode`";s:32:"61e8d3210f09017c0c5796a679d2b6a4";s:18:"`Client`.`created`";s:32:"653c34f4141a3da5cedf696ebb6ab8db";s:19:"`Client`.`modified`";s:32:"6e4a3664c8d004ad85230afda5aa2ada";s:6:"`Deal`";s:32:"9c847a0aa58cf597c9eafa7cb7a6c670";s:30:"`Purchasereport`.`purchase_id`";s:32:"baced22389aa92c037480fc26e9a417e";s:23:"`Purchasereport`.`date`";s:32:"1b3d42cabfe6fb3e8db7eb5767eedd47";s:16:"`Purchasereport`";s:32:"1915c7370aa286ad85b68c045f9aca49";s:27:"`Salesreport`.`property_id`";s:32:"8cf0ab89839519cf8d181ea53e189c5e";s:20:"`Salesreport`.`date`";s:32:"1c44dcb389f503b916df90d53c1161a1";s:13:"`Salesreport`";s:32:"34904a7c603859f05739ccab22aa1c28";s:18:"`Salesreport`.`id`";s:32:"900bcfa87fa2f73612cdf61e326ea919";s:24:"`DealsPayment`.`deal_id`";s:32:"14d3e6f28f179f3ebd00fcef63bc8ae5";s:11:"`Lead`.`id`";s:32:"f73fd170c80b53d9f8c2f44e5c986b24";s:16:"`Lead`.`user_id`";s:32:"0e6bf96aa17d6886aeaa59c25d4344e1";s:19:"`Lead`.`project_id`";s:32:"9a7d3ed1596e35dd7df7cea6f7354584";s:20:"`Lead`.`property_id`";s:32:"0a8a25ce29ee0479db39dccec0bdff37";s:18:"`Lead`.`follow_up`";s:32:"39365463b42aec2c76fb2875ac533c01";s:16:"`Lead`.`remarks`";s:32:"50be081de92a8a192d88700a1880dae7";s:15:"`Status`.`name`";s:32:"ad42dcc385afd4e8c1ab9b58fe3d8402";s:16:"`Status`.`color`";s:32:"60ea156a09108c2d41f261bb911439ef";s:15:"`Status`.`type`";s:32:"415ce7b551e9decd6aac5fb465bd367b";s:6:"`type`";s:32:"a5cdc02be362ce7a332e377aa7e560ec";s:23:"`Purchase`.`project_id`";s:32:"3ef966a6bd89e99f6ad16e46f89c3fbf";s:17:"`Purchase`.`name`";s:32:"d51e4535bf234ab39b9a3064dd565786";s:20:"`Purchase`.`address`";s:32:"69ce74bfd4c9f83cf9cb35676abdd786";s:19:"`Purchase`.`mobile`";s:32:"114a16b86e5831b5daa7c24bd097d96b";s:26:"`Purchase`.`property_name`";s:32:"6653d6ba2f07fd143b0592edaf9352e9";s:24:"`Purchase`.`description`";s:32:"701892168cc11030a9dc60db9ad88529";s:17:"`Purchase`.`area`";s:32:"b1ddd10be15d26a36e00fef0055de05a";s:20:"`Purchase`.`unit_id`";s:32:"0658e45ddc00a76b64166ae739e710e0";s:19:"`Purchase`.`amount`";s:32:"3cea61205ce551e9f53ac52bd87020a8";s:20:"`Purchase`.`remarks`";s:32:"ee999414b30a1ca0f08bcbe2f8dd3404";s:19:"`Purchase__payment`";s:32:"49f698019c9f174e346cb75e02a2eb11";s:27:"`PurchasesPayment`.`amount`";s:32:"3cc5b8f19e95ced6ab2f349d1bc74db9";s:27:"`Smstemplate`.`description`";s:32:"3d5e57a283450692c6a10efbbf49b090";s:20:"`Smstemplate`.`name`";s:32:"8993092c13093f8abfc8b38b311ef0ff";s:14:"`smstemplates`";s:32:"02cb99f03be68e6f807ff962e6dec096";s:13:"`Smstemplate`";s:32:"242388ac3840a541d7470397ebf02e8e";s:13:"`smssettings`";s:32:"590556eff7c07ebb0ac29ee7ededb249";s:17:"`Smssetting`.`id`";s:32:"bb42558a716bf85a3b2f2843cc27459a";s:18:"`Smssetting`.`api`";s:32:"59af9df6871c18330bb317d67bb454cb";s:23:"`Smssetting`.`username`";s:32:"1eeaec6ffc8e90a671ca07ce30dd4f59";s:23:"`Smssetting`.`password`";s:32:"db6cff295b88f805b69878315c742299";s:23:"`Smssetting`.`senderid`";s:32:"61bd72e30df108cb94e23107ab8b5fcc";s:24:"`Smssetting`.`husername`";s:32:"7e4ab9d5a9f599b12acdec1671e9b494";s:24:"`Smssetting`.`hpassword`";s:32:"e7dbfc92dcbd90d25d965bc2be18eaa9";s:24:"`Smssetting`.`hsenderid`";s:32:"60d0a11af3a9717389f09a74314af6fc";s:22:"`Smssetting`.`hmobile`";s:32:"f08a7bfe067a85757c63910ee376f092";s:23:"`Smssetting`.`hmessage`";s:32:"0a2383412bfcfcab54065f636ce78970";s:19:"`Smssetting`.`type`";s:32:"eb4addcb2bd9fefbe4211bad714953b9";s:12:"`Smssetting`";s:32:"7b50420026cda5d6c7041b25aff54121";s:29:"`Emailtemplate`.`description`";s:32:"404fb5268dbc872080fd828debf3ef79";s:22:"`Emailtemplate`.`name`";s:32:"08ff21e83888f86ae2b70405a177d636";s:16:"`emailtemplates`";s:32:"cf8898ae0979562ae0b9a50cc6ef4eb6";s:15:"`Emailtemplate`";s:32:"2dbff3ef2fc1600545c44b1cb8331412";s:18:"`Register`.`email`";s:32:"a6cd106ccb7501e634c2dfe536d0349b";s:10:"`Register`";s:32:"6aa91a7fbb8c9edcf4aa5f9411aec19c";s:10:"`password`";s:32:"4d7c503a0d8801a88417cd081d648c7f";s:10:"`reg_code`";s:32:"13bf5e309220c45eb94a8ffcaa474e67";s:12:"`reg_status`";s:32:"a2e9d6908cb4955f8695d334e27e1c6a";s:13:"`category_id`";s:32:"8c503a89e07a0c5c5de7051953af0b74";s:20:"`Emailtemplate`.`id`";s:32:"b2cd3a9c99c6186ccb66ece4fcc266dd";s:24:"`Emailtemplate`.`status`";s:32:"f7247684f03ca8a657c96d001b5171b0";s:22:"`Emailtemplate`.`type`";s:32:"9ea7b0c2b18272f0f5b7b83ba6a49676";s:37:"`umair_property_mngpk`.`clients`.`id`";s:32:"a30acf6721a6b5102fee3898dc610a76";s:12:"`last_login`";s:32:"04564a14a922f1b48a39f474944ca556";s:16:"`DealsPayment`.*";s:32:"10357c84bf900ab80dbf2f0c2227c7c1";s:31:"`DealsPayment`.`paymenttype_id`";s:32:"de2739186dd014eb2a43fec7f675bbcc";s:20:"`expense_categories`";s:32:"89020ecd7dc3662a93fb69d166635e98";s:22:"`ExpenseCategory`.`id`";s:32:"3bf1abd644afc4a91c49da2afdae7255";s:24:"`ExpenseCategory`.`name`";s:32:"1accceecbda56039428ebc97f0222dd8";s:26:"`ExpenseCategory`.`status`";s:32:"d48e0ed7c0fc9082ed32d7d25ac3c42e";s:17:"`ExpenseCategory`";s:32:"367f49926ed5a28b0c6f291f810cca63";s:9:"`vendors`";s:32:"58be17fcfe23f19aa9143b23166f5709";s:13:"`Vendor`.`id`";s:32:"f43efe18d90e3e1f90c760ba92467844";s:15:"`Vendor`.`name`";s:32:"332083d7ee58a78fa8040b14a35e8c79";s:18:"`Vendor`.`address`";s:32:"dbc92d1506641ca67c1b8364d6cbe199";s:18:"`Vendor`.`contact`";s:32:"0bb1ae2ea8ef7c140fe9489779abeaca";s:21:"`Vendor`.`licence_no`";s:32:"e21fcd6b343eb4531bd918a7afa4c47f";s:21:"`Vendor`.`project_id`";s:32:"c0f819370f9ee992f8ff3f329d33c2fc";s:8:"`Vendor`";s:32:"301ab3e3557ede5c7011c65a3f7fb1d2";s:13:"`inventories`";s:32:"efacf32b820b0b8b14de2422f0283d4f";s:16:"`Inventory`.`id`";s:32:"6bdb5cf26ca6fae2521c512322123af0";s:24:"`Inventory`.`project_id`";s:32:"65b50a26215b74d7a3349331564d5e32";s:33:"`Inventory`.`expense_category_id`";s:32:"e862998f72bfd1dade8bbba04b86f6bf";s:23:"`Inventory`.`vendor_id`";s:32:"f665b5e8b9f1c5eeac68c63552344329";s:24:"`Inventory`.`invoice_no`";s:32:"13b7f2d5c814074c62d87c596624856e";s:26:"`Inventory`.`invoice_date`";s:32:"a8d5ade1688fb63836bc7c87bc0c14a6";s:25:"`Inventory`.`invoice_qty`";s:32:"01dc975028350d5689c411e8eac9fa11";s:21:"`Inventory`.`remarks`";s:32:"36d8f2fcdfe1b1a24594e96c9fee9d9a";s:16:"`Inventory__qty`";s:32:"932219d8d7cba9c3a8d09d103b80a6f9";s:26:"`InventoriesBalance`.`qty`";s:32:"79d9ccb77804d4ab47a295ef49b9f8be";s:35:"`InventoriesBalance`.`inventory_id`";s:32:"68d2faec406430b13674a09221973087";s:11:"`Inventory`";s:32:"df0a3c17c412058506937adebc321497";s:22:"`Expense`.`project_id`";s:32:"f28ba15a4a8f9e8b24b5e17a308802ec";s:31:"`Expense`.`expense_category_id`";s:32:"2a8834bf57cc7d307c0f4b6c283e3a5a";s:21:"`Expense`.`vendor_id`";s:32:"b628210090af5d66c4293a42bdd23951";s:22:"`Expense`.`invoice_no`";s:32:"609e14955befe20155e4fa39c74a9020";s:24:"`Expense`.`invoice_date`";s:32:"fc6dcfa24e2823ebfa541aa9913a0e5e";s:26:"`Expense`.`invoice_amount`";s:32:"cae8571af260b06bd850773121d55497";s:19:"`Expense`.`remarks`";s:32:"07676aac69d09c2efea57fedfc13e39a";s:18:"`Expense__payment`";s:32:"498ada76b8233d8904111667cce4bf92";s:26:"`ExpensesPayment`.`amount`";s:32:"8396404a257111d522d17bf9e2b9949f";s:28:"`Expensereport`.`expense_id`";s:32:"1ba53c677c7e3c33aae0b9ea1193edf3";s:22:"`Expensereport`.`date`";s:32:"cc39e9727ec46e6fdab755aa3c387072";s:15:"`Expensereport`";s:32:"1971785f6e8f04145ef7218978934f5b";s:29:"`DealsPayment`.`total_amount`";s:32:"303afb8bed32e0f08d3678421c9dce71";s:14:"`Profitreport`";s:32:"2980e0d88140ed4cf40418818c0ee958";s:27:"`Profitreport`.`expense_id`";s:32:"8366ba4e88acc8cbb6f6100d3fe782b0";s:18:"`search_histories`";s:32:"9b3370a3836fe21ca90dd1319eb4d7f0";s:20:"`Searchhistory`.`id`";s:32:"4baeba523cc3dc296bc9c4390caf02ad";s:22:"`Searchhistory`.`name`";s:32:"7fa40e00ace6b90b125adeaad0bead4b";s:22:"`Searchhistory`.`link`";s:32:"e6b198c0c8c3fe4f0e78d490b1badf24";s:24:"`Searchhistory`.`search`";s:32:"0789817783a0142cde488e225f13e84a";s:28:"`Searchhistory`.`ip_address`";s:32:"61f331994f90f8a13f5b0fc2713778ef";s:25:"`Searchhistory`.`created`";s:32:"c01179924dd2e81e652d0cd1ccf2b6bd";s:15:"`Searchhistory`";s:32:"322115c6be8b9535c3319bd4f238f540";s:9:"`user_id`";s:32:"9c98703325e97260ce7432402bedb687";s:11:"`status_id`";s:32:"3f646d6511c40e275b9c07bb783a775b";s:9:"`remarks`";s:32:"552bf7b316b440936a43632721210963";s:13:"`MyDeal`.`id`";s:32:"b9167a28518a621a1046973e9609a76d";s:18:"`MyDeal`.`user_id`";s:32:"e81557280948c0964a07e7f575afe0e7";s:20:"`MyDeal`.`client_id`";s:32:"e9a1f59a3ea104573c4cd75ae3496a0b";s:22:"`MyDeal`.`property_id`";s:32:"1848aec7f4611fa1a866f3896195c0bc";s:29:"`MyDeal`.`properties_flat_id`";s:32:"9a2f09c85efb9e9a1064af9704945482";s:18:"`MyDeal`.`plan_id`";s:32:"0f6a512cb335419fcd0c174657e09300";s:21:"`MyDeal`.`invoice_no`";s:32:"e83cf6404690ae0c60cd3166c45d377b";s:15:"`MyDeal`.`date`";s:32:"b9d7a037be1b37eeb6a31a51a05d1964";s:23:"`MyDeal`.`evocate_date`";s:32:"30ace5a3d7823c7cbd8f7ef463758b12";s:20:"`MyDeal`.`recurring`";s:32:"a3f8827b7db1b721042e3f479340ac99";s:25:"`MyDeal`.`booking_amount`";s:32:"8ee22429340e13f0a42e6c693c936a61";s:19:"`MyDeal`.`discount`";s:32:"a6c1d137847496dabe95105cfaae2d8b";s:23:"`MyDeal`.`total_amount`";s:32:"cb25aeee0d1ad5eab10d12850021064d";s:18:"`MyDeal`.`remarks`";s:32:"a0ef91aad682de3ec6cde44319d145f8";s:18:"`MyDeal`.`created`";s:32:"be8ea4a9061f27bc2dc96af0f2ba1392";s:19:"`MyDeal`.`modified`";s:32:"1c05290dcddca4166e8e7d7f401d8963";s:8:"`MyDeal`";s:32:"b13ab688917e245d86a9601058e3f6f2";s:13:"`Agency`.`id`";s:32:"9c66126706986b645016b96c23458996";s:15:"`Agency`.`name`";s:32:"deeded127c52db3d5e622ba07790a2c3";s:16:"`Agency`.`phone`";s:32:"b3911d8d2fffa84ab58723c5095c548a";s:17:"`Agency`.`mobile`";s:32:"25f000584d815db26f68d508c80f057f";s:16:"`Agency`.`email`";s:32:"b0c5d7e52d862e6596883ec8651195d5";s:8:"`Agency`";s:32:"191a865ff41e66ada37d6b1e272ee1c2";s:8:"`Page`.*";s:32:"df56eedda5970c9f24be672553fbd5dc";s:13:"`PageRight`.*";s:32:"302e208bf83f6626ad5aa5658ed4a509";s:18:"`Smstemplate`.`id`";s:32:"e34668f47de177d9eb9044f70301f88e";s:22:"`Smstemplate`.`status`";s:32:"5e6777a708f1eadfedd4dfd27740dc4a";s:20:"`Smstemplate`.`type`";s:32:"1991d45ce8747189288ea86901f18339";s:17:"`Awallet__credit`";s:32:"38d22dd26b910ff7583a54d782d6172d";s:16:"`Awallet__debit`";s:32:"e055999aaabb1f6b699b784357b000ef";s:18:"`Awallet__balance`";s:32:"df855e09de13346126f62dd863db142f";s:19:"`awallet_histories`";s:32:"f48e18fea071510de87060a4c63dbafe";s:21:"`AwalletHistory`.`id`";s:32:"72332aadfa289ffaf2d2c555070357b8";s:26:"`AwalletHistory`.`user_id`";s:32:"d5ef8e7d519d8ee782563f37c203e9d6";s:29:"`AwalletHistory`.`project_id`";s:32:"8e791b501abcf4a8d920a539db4f739c";s:35:"`AwalletHistory`.`deals_payment_id`";s:32:"71d9696ed0f969544a916e12c167f458";s:25:"`AwalletHistory`.`amount`";s:32:"acc546f0975d2fa06573133647b89c49";s:23:"`AwalletHistory`.`type`";s:32:"8e3d69997f0fb8b1d9f4ffedb6b37a71";s:23:"`AwalletHistory`.`date`";s:32:"9b303bfdf362bfb76f1ff7a765acfa6a";s:26:"`AwalletHistory`.`remarks`";s:32:"e5dd5151686b528b89a72fbc0b39a21e";s:16:"`AwalletHistory`";s:32:"7543c0c3209716d5ebc263fe3b9e245c";s:9:"`type_id`";s:32:"33d654fc9267150022f07f5e4002dde3";s:10:"`latitude`";s:32:"c856c23dc3e0025119073afac3f50fea";s:11:"`longitude`";s:32:"e5bd9b3159d5131e72df1fdc02092801";s:7:"`price`";s:32:"8b2662c3388a2d318d86e7637d941003";s:13:"`contract_id`";s:32:"13d8d88173beb4aea77f2b852f0c25aa";s:6:"`area`";s:32:"a31c1317cecc7f70db0667306326b8dc";s:9:"`unit_id`";s:32:"476c0c9b82645dbe0d7a261c0652eb11";s:7:"`floor`";s:32:"d96f58a7db00b0f268c30aaffd154936";s:9:"`bedroom`";s:32:"20961c3210e138e41de506141c6ec77d";s:10:"`bathroom`";s:32:"4113e315633d5e8b28e781ef266a1413";s:17:"`commission_type`";s:32:"0f846ff51789e5735ee140ce7a5c7f54";s:18:"`agent_commission`";s:32:"472adacd92cd2706e33b6c1dc6b7a014";s:14:"`allow_rating`";s:32:"294a5603d3d85eef174c565ef9f4f057";s:15:"`allow_comment`";s:32:"b00ef3411e8493249b7ac1f9fcb29aa0";s:7:"`video`";s:32:"3e55a6417d7db241d53a5a406d7f4600";s:12:"`feature_id`";s:32:"f357ca78b96ef66d12d77c480f8ca733";s:23:"`PurchasesPayment`.`id`";s:32:"7df50b095cf5e6c5f82bc7ba7b8cbc53";s:35:"`PurchasesPayment`.`paymenttype_id`";s:32:"e0968b7afdf10a05c7747d15035f01ba";s:25:"`PurchasesPayment`.`date`";s:32:"89c3bffc797d393e4ee230513b2d3158";s:28:"`PurchasesPayment`.`remarks`";s:32:"9146059edc16aa81f97ab1a1f14bd15d";s:40:"`umair_property_mngpk`.`categories`.`id`";s:32:"e03bc3a6be8b9aa7000130138a073f9f";s:10:"`district`";s:32:"01e67269f053fa497a470b13c81ac40c";s:7:"`state`";s:32:"efd7358009e0556e505654109ce8a9f3";s:9:"`pincode`";s:32:"bdbc6c2107fcf02aef40c8efa06c4ce1";s:12:"`licence_no`";s:32:"c73e6c1da61dd7fd4bb3d54960c28d81";s:37:"`umair_property_mngpk`.`vendors`.`id`";s:32:"88a628b636064a6ee2b66bb0b46e7b9b";s:21:"`expense_category_id`";s:32:"df2f66f9390083b4baf7fd5720da7b97";s:11:"`vendor_id`";s:32:"4f6cf8baea1a4e18f506418273172419";s:12:"`invoice_no`";s:32:"c89e5a5af92fc77f07f2db4591518276";s:14:"`invoice_date`";s:32:"2ecd02c6b62c728f11ac5b74e0678a79";s:16:"`invoice_amount`";s:32:"e21e18f9e712169b69ef3cb49fc13adc";s:16:"`paymenttype_id`";s:32:"0dbad5b96349237116f63f0f389bd7f4";s:6:"`date`";s:32:"9b2d2815d3fa1fba52e21edcfe1ddb14";s:12:"`expense_id`";s:32:"c80100460933ddacfb64e96c7dc8d71e";s:38:"`umair_property_mngpk`.`expenses`.`id`";s:32:"0a6ecb7219e8f517349fc7b3eb613b27";s:22:"`ExpensesPayment`.`id`";s:32:"b45594c5ef0c1ed05b72faac9ef748e6";s:34:"`ExpensesPayment`.`paymenttype_id`";s:32:"315d1425f5b6cb835cf5249ab664fc07";s:24:"`ExpensesPayment`.`date`";s:32:"7a6f9fb40b155bcfb91d6f07bbfd922a";s:27:"`ExpensesPayment`.`remarks`";s:32:"3685ea1c0803124bc8fe95fb012e1843";s:13:"`invoice_qty`";s:32:"64f4f21c4659733f21c00860c47dfe3c";s:22:"`inventories_balances`";s:32:"d5faf2fcbc1eb37881cfb3b4c2d7be61";s:25:"`InventoriesBalance`.`id`";s:32:"35d30c9856590111d9e6a1a83152c2a0";s:27:"`InventoriesBalance`.`date`";s:32:"4817857eff02881b5c3c7177f8bc8765";s:30:"`InventoriesBalance`.`remarks`";s:32:"878615ccefe42884b23dd8761141c43a";s:20:"`InventoriesBalance`";s:32:"e353681b96bcbfb713cdb5abe93e6fcc";s:17:"`Invpastdue`.`id`";s:32:"67038cb35b4a8fa6bcf5004fc6545f01";s:19:"`Invpastdue`.`name`";s:32:"bef8e1b5de65fe22c9ae85a4f127fe26";s:19:"`Invpastdue`.`date`";s:32:"b75d8fa956a7c0c5804c3108432e5582";s:21:"`Invpastdue`.`amount`";s:32:"92b5f16495a26ba30cc03d345d47b883";s:22:"`Invpastdue`.`deal_id`";s:32:"004e01a5e2b420ef370deb51266cb8e9";s:33:"`DealsPayment`.`plans_payment_id`";s:32:"a5d297a366b140dba3d3855adb253eb3";s:16:"`plans_payments`";s:32:"44775aa249597be2309e0e0b36100990";s:19:"`DealsPayment`.`id`";s:32:"68b7b72b91501041be8298c4bacb8c62";s:12:"`Invpastdue`";s:32:"8f1586a6fd64005c7ccc68d8bc009f7e";s:10:"`featured`";s:32:"208a8ea5156b95f85beac65657660291";s:47:"`umair_property_mngpk`.`expenses_payments`.`id`";s:32:"7a77f99868a0e53e474f4e75dd034ee2";s:9:"`uniq_id`";s:32:"5b6b1d843acd82aedb2135d9ddc21e5c";s:22:"`Invpaid`.`invoice_no`";s:32:"0fa3444f0b1cf22fb42810f7bf1dd43e";s:27:"`DealsPayment`.`tax_amount`";s:32:"9420d0b7d06af186fddb3bfced755c46";s:23:"`DealsPayment`.`amount`";s:32:"052f23d081285b0b14e463d0250f23dd";s:21:"`PlansPayment`.`name`";s:32:"c65f3d85818ee11e8f0d272f40cfe512";s:14:"`Invpaid`.`id`";s:32:"d37a22a56b3e18df4a032a375686cd43";s:19:"`PlansPayment`.`id`";s:32:"6394e7c9d3a57568e1f4b6a202c9c396";s:21:"`Invpaid`.`client_id`";s:32:"70e2aaf9ea63de17bdc58e38fcdc91df";s:23:"`Invpaid`.`property_id`";s:32:"e182272ab92330b61f2a98ebde73a297";s:14:"`PlansPayment`";s:32:"d2b34725e411aca69b1d32956a48d019";s:9:"`Invpaid`";s:32:"43b23a2b3d0d0af33bebf68fd7393a3a";s:8:"`Deal`.*";s:32:"f98b217960e177664dc412f3ebe9c371";s:10:"`Client`.*";s:32:"b3c6fa89586dc0cd61a5c26502da09c7";s:12:"`Property`.*";s:32:"3267e88394aec5eece1819e1473f7892";s:8:"`Unit`.*";s:32:"a6585e709a461e78decb56fa6a2b5de0";s:8:"`Plan`.*";s:32:"5014d2b1512e8400e388a5cdaa62a830";s:16:"`PlansPayment`.*";s:32:"df4624eda5ec33d21449c876d1386071";s:15:"`Paymenttype`.*";s:32:"99bd8753bb60f1f01fd48ca42a5727fd";s:14:"`evocate_date`";s:32:"9d286b857891123dc0b5262846bd3d92";s:16:"`booking_amount`";s:32:"c7915774f51e6bccb1bda3d3886508a8";s:10:"`discount`";s:32:"627055ddd0db940e7b1cafcabb5b2b27";s:9:"`plan_id`";s:32:"212d2afc2a74d11899c8639e1c7cd4df";s:11:"`recurring`";s:32:"302c5b438be69c6795d7cb7a5b8a4ab8";s:9:"`deal_id`";s:32:"e9ff0a3fa7d615d7141b1192d6d618e1";s:23:"`PlansPayment`.`amount`";s:32:"009bba20d03e7bfa7ad9297192f9b38a";s:21:"`PlansPayment`.`date`";s:32:"4d3f08479a1e49aecd1d6deb05e97d0b";s:24:"`PlansPayment`.`deal_id`";s:32:"12614ba555efa8c62d7cf581db515c7b";s:5:"`emi`";s:32:"ccb9d03212b033e89f24456d39a91a7f";s:15:"`extra_payment`";s:32:"024755e84437588d041f5ea6b48fc8e7";s:12:"`tax_amount`";s:32:"71fed0ace50a451217ef4433dc6bf236";s:14:"`payment_date`";s:32:"5b11787ba7a55d23e7e6b580e9704f70";s:18:"`plans_payment_id`";s:32:"9575552e0d8f392b0c0c93ad8a2624ae";s:12:"`receipt_no`";s:32:"59235edc711847556f281828e40f2a34";s:13:"`purchase_id`";s:32:"9cffd865a8874214253b08ef2d3812db";s:15:"`property_name`";s:32:"cb364185b06bd829bab61270a614e469";s:39:"`umair_property_mngpk`.`purchases`.`id`";s:32:"f40362373c1bbe823a0530283aea8417";s:6:"`link`";s:32:"c41c0c24f0968cc90f2255c6412874f9";s:12:"`ip_address`";s:32:"8398e2948c4308eeedcaa02d2cb23890";s:8:"`search`";}s:6:"fields";a:198:{s:32:"72f45cfc36f100319158236f6143e0e5";a:1:{i:0;s:19:"COUNT(*) AS `count`";}s:32:"cb5d599c44bc8d3b93938d44efc97831";a:32:{i:0;s:20:"`Configuration`.`id`";i:1;s:22:"`Configuration`.`name`";i:2;s:35:"`Configuration`.`organization_name`";i:3;s:29:"`Configuration`.`domain_name`";i:4;s:23:"`Configuration`.`email`";i:5;s:28:"`Configuration`.`meta_title`";i:6;s:27:"`Configuration`.`meta_desc`";i:7;s:26:"`Configuration`.`timezone`";i:8;s:24:"`Configuration`.`author`";i:9;s:34:"`Configuration`.`sms_notification`";i:10;s:36:"`Configuration`.`email_notification`";i:11;s:29:"`Configuration`.`guest_login`";i:12;s:27:"`Configuration`.`front_end`";i:13;s:24:"`Configuration`.`slides`";i:14;s:27:"`Configuration`.`translate`";i:15;s:25:"`Configuration`.`contact`";i:16;s:23:"`Configuration`.`photo`";i:17;s:26:"`Configuration`.`currency`";i:18;s:29:"`Configuration`.`date_format`";i:19;s:25:"`Configuration`.`address`";i:20;s:33:"`Configuration`.`account_details`";i:21;s:28:"`Configuration`.`short_name`";i:22;s:26:"`Configuration`.`due_days`";i:23;s:27:"`Configuration`.`late_fees`";i:24;s:26:"`Configuration`.`language`";i:25;s:26:"`Configuration`.`dir_type`";i:26;s:27:"`Configuration`.`min_limit`";i:27;s:27:"`Configuration`.`max_limit`";i:28;s:25:"`Configuration`.`map_key`";i:29;s:30:"`Configuration`.`captcha_type`";i:30;s:25:"`Configuration`.`created`";i:31;s:26:"`Configuration`.`modified`";}s:32:"efbbf05213c4814ca296ac062483eb0a";a:4:{i:0;s:15:"`Currency`.`id`";i:1;s:17:"`Currency`.`name`";i:2;s:18:"`Currency`.`short`";i:3;s:18:"`Currency`.`photo`";}s:32:"22886fc1033bc6e4790562de2657bcde";a:15:{i:0;s:14:"`Content`.`id`";i:1;s:21:"`Content`.`link_name`";i:2;s:21:"`Content`.`page_name`";i:3;s:21:"`Content`.`page_icon`";i:4;s:18:"`Content`.`is_url`";i:5;s:15:"`Content`.`url`";i:6;s:22:"`Content`.`url_target`";i:7;s:24:"`Content`.`main_content`";i:8;s:20:"`Content`.`page_url`";i:9;s:16:"`Content`.`cols`";i:10;s:20:"`Content`.`ordering`";i:11;s:17:"`Content`.`views`";i:12;s:21:"`Content`.`published`";i:13;s:19:"`Content`.`created`";i:14;s:20:"`Content`.`modified`";}s:32:"c7bfeeb1cda774031311371a9e1e24fa";a:6:{i:0;s:19:"`Emailsetting`.`id`";i:1;s:21:"`Emailsetting`.`type`";i:2;s:21:"`Emailsetting`.`host`";i:3;s:25:"`Emailsetting`.`username`";i:4;s:25:"`Emailsetting`.`password`";i:5;s:21:"`Emailsetting`.`port`";}s:32:"b155ae5fdebb9f24fbe2f3546c1cf717";a:10:{i:0;s:11:"`Page`.`id`";i:1;s:19:"`Page`.`model_name`";i:2;s:18:"`Page`.`page_name`";i:3;s:24:"`Page`.`controller_name`";i:4;s:20:"`Page`.`action_name`";i:5;s:13:"`Page`.`icon`";i:6;s:18:"`Page`.`parent_id`";i:7;s:17:"`Page`.`ordering`";i:8;s:18:"`Page`.`published`";i:9;s:17:"`Page`.`sel_name`";}s:32:"c7a1df25f4fbc7931569ae2498d0cd65";a:8:{i:0;s:12:"`Slide`.`id`";i:1;s:20:"`Slide`.`slide_name`";i:2;s:18:"`Slide`.`ordering`";i:3;s:15:"`Slide`.`photo`";i:4;s:14:"`Slide`.`dirt`";i:5;s:16:"`Slide`.`status`";i:6;s:17:"`Slide`.`created`";i:7;s:18:"`Slide`.`modified`";}s:32:"04c2125f3ce0e4b11b905eb3b34e1216";a:5:{i:0;s:14:"`Project`.`id`";i:1;s:16:"`Project`.`name`";i:2;s:17:"`Project`.`phone`";i:3;s:18:"`Project`.`mobile`";i:4;s:17:"`Project`.`email`";}s:32:"15c85993f0ecf3c7bb204499c7b2f2c1";a:32:{i:0;s:15:"`Property`.`id`";i:1;s:20:"`Property`.`user_id`";i:2;s:20:"`Property`.`uniq_id`";i:3;s:23:"`Property`.`project_id`";i:4;s:24:"`Property`.`location_id`";i:5;s:24:"`Property`.`contract_id`";i:6;s:20:"`Property`.`type_id`";i:7;s:20:"`Property`.`unit_id`";i:8;s:17:"`Property`.`name`";i:9;s:20:"`Property`.`address`";i:10;s:24:"`Property`.`description`";i:11;s:17:"`Property`.`area`";i:12;s:18:"`Property`.`price`";i:13;s:29:"`Property`.`agent_commission`";i:14;s:28:"`Property`.`commission_type`";i:15;s:18:"`Property`.`floor`";i:16;s:20:"`Property`.`bedroom`";i:17;s:21:"`Property`.`bathroom`";i:18;s:19:"`Property`.`rating`";i:19;s:25:"`Property`.`rating_count`";i:20;s:25:"`Property`.`rating_users`";i:21;s:21:"`Property`.`latitude`";i:22;s:22:"`Property`.`longitude`";i:23;s:18:"`Property`.`video`";i:24;s:18:"`Property`.`views`";i:25;s:25:"`Property`.`allow_rating`";i:26;s:26:"`Property`.`allow_comment`";i:27;s:19:"`Property`.`status`";i:28;s:21:"`Property`.`featured`";i:29;s:22:"`Property`.`published`";i:30;s:20:"`Property`.`created`";i:31;s:21:"`Property`.`modified`";}s:32:"eb7857ac19f3dfabb8274f2ac728e0ec";a:1:{i:0;s:15:"`Property`.`id`";}s:32:"e693e7dbf1fd8104e321e66f64cd6a61";a:4:{i:0;s:11:"`Type`.`id`";i:1;s:13:"`Type`.`name`";i:2;s:13:"`Type`.`dirt`";i:3;s:14:"`Type`.`photo`";}s:32:"456e5691124b2050ba45330921289b59";a:5:{i:0;s:14:"`Project`.`id`";i:1;s:16:"`Project`.`name`";i:2;s:17:"`Project`.`phone`";i:3;s:18:"`Project`.`mobile`";i:4;s:17:"`Project`.`email`";}s:32:"ba35d62d827cc5e9475e378e45cc6938";a:2:{i:0;s:11:"`Unit`.`id`";i:1;s:13:"`Unit`.`name`";}s:32:"96a50f96016cc09e492cbb67b9699bea";a:2:{i:0;s:15:"`Location`.`id`";i:1;s:17:"`Location`.`name`";}s:32:"0a4a1b87c0975aee3366e83567e8e6bc";a:23:{i:0;s:11:"`User`.`id`";i:1;s:18:"`User`.`ugroup_id`";i:2;s:19:"`User`.`project_id`";i:3;s:20:"`User`.`location_id`";i:4;s:13:"`User`.`name`";i:5;s:17:"`User`.`username`";i:6;s:17:"`User`.`password`";i:7;s:14:"`User`.`phone`";i:8;s:15:"`User`.`mobile`";i:9;s:16:"`User`.`address`";i:10;s:14:"`User`.`email`";i:11;s:14:"`User`.`skype`";i:12;s:17:"`User`.`facebook`";i:13;s:16:"`User`.`twitter`";i:14;s:17:"`User`.`linkedin`";i:15;s:20:"`User`.`description`";i:16;s:12:"`User`.`dir`";i:17;s:14:"`User`.`photo`";i:18;s:15:"`User`.`status`";i:19;s:19:"`User`.`presetcode`";i:20;s:16:"`User`.`deleted`";i:21;s:16:"`User`.`created`";i:22;s:17:"`User`.`modified`";}s:32:"004fd9bc4d2fa728f32ce44b8a48ef72";a:2:{i:0;s:15:"`Contract`.`id`";i:1;s:17:"`Contract`.`name`";}s:32:"5787ca3bc8645254f06dba24e7208341";a:5:{i:0;s:22:"`PropertiesPhoto`.`id`";i:1;s:31:"`PropertiesPhoto`.`property_id`";i:2;s:25:"`PropertiesPhoto`.`photo`";i:3;s:23:"`PropertiesPhoto`.`dir`";i:4;s:24:"`PropertiesPhoto`.`home`";}s:32:"aa42f909e68b38b710f0b60cebe4293e";a:1:{i:0;s:31:"`PropertiesPhoto`.`property_id`";}s:32:"6df8288c73d539bdf714b7cb53e09ae7";a:4:{i:0;s:25:"`PropertiesDocument`.`id`";i:1;s:34:"`PropertiesDocument`.`property_id`";i:2;s:28:"`PropertiesDocument`.`photo`";i:3;s:26:"`PropertiesDocument`.`dir`";}s:32:"68db2b0160b3bb226909f1d968975b28";a:1:{i:0;s:34:"`PropertiesDocument`.`property_id`";}s:32:"7ba066426cd4cc7a6a415351842edb11";a:4:{i:0;s:26:"`PropertiesFloorplan`.`id`";i:1;s:35:"`PropertiesFloorplan`.`property_id`";i:2;s:29:"`PropertiesFloorplan`.`photo`";i:3;s:27:"`PropertiesFloorplan`.`dir`";}s:32:"12f044de97bec5fb82a86b43ec6e624f";a:1:{i:0;s:35:"`PropertiesFloorplan`.`property_id`";}s:32:"bcfa3dff003ef6ffee296f0c9565f6a0";a:2:{i:0;s:8:"`Type`.*";i:1;s:48:"(Count(`Property`.`id`)) AS  `Type__total_count`";}s:32:"080ede514bbb4804e315711f813b39eb";a:5:{i:0;s:16:"`Favourite`.`id`";i:1;s:23:"`Favourite`.`client_id`";i:2;s:24:"`Favourite`.`session_id`";i:3;s:25:"`Favourite`.`property_id`";i:4;s:21:"`Favourite`.`created`";}s:32:"b438be1718b8252ed26a7edf8ea47398";a:23:{i:0;s:11:"`User`.`id`";i:1;s:18:"`User`.`ugroup_id`";i:2;s:19:"`User`.`project_id`";i:3;s:20:"`User`.`location_id`";i:4;s:13:"`User`.`name`";i:5;s:17:"`User`.`username`";i:6;s:17:"`User`.`password`";i:7;s:14:"`User`.`phone`";i:8;s:15:"`User`.`mobile`";i:9;s:16:"`User`.`address`";i:10;s:14:"`User`.`email`";i:11;s:14:"`User`.`skype`";i:12;s:17:"`User`.`facebook`";i:13;s:16:"`User`.`twitter`";i:14;s:17:"`User`.`linkedin`";i:15;s:20:"`User`.`description`";i:16;s:12:"`User`.`dir`";i:17;s:14:"`User`.`photo`";i:18;s:15:"`User`.`status`";i:19;s:19:"`User`.`presetcode`";i:20;s:16:"`User`.`deleted`";i:21;s:16:"`User`.`created`";i:22;s:17:"`User`.`modified`";}s:32:"fc290477da7746640e7bb43839704775";a:5:{i:0;s:13:"`Ugroup`.`id`";i:1;s:15:"`Ugroup`.`name`";i:2;s:15:"`Ugroup`.`type`";i:3;s:18:"`Ugroup`.`created`";i:4;s:19:"`Ugroup`.`modified`";}s:32:"91976c4971b76d0d4d28c60b6e72bb81";a:1:{i:0;s:25:"DISTINCT `Favourite`.`id`";}s:32:"abfae4d96c0ca0c81ac240056b24011a";a:1:{i:0;s:45:"SUM(`DealsPayment`.`total_amount`) AS earning";}s:32:"8d3ed8365826246deebddf926dd7e1eb";a:1:{i:0;s:42:"SUM(`ExpensesPayment`.`amount`) AS expense";}s:32:"bf9fbec70ecc31f8094de12d0705c885";a:1:{i:0;s:44:"SUM(`PurchasesPayment`.`amount`) AS purchase";}s:32:"3f40cd76d53145fe405f4c31ad090a22";a:10:{i:0;s:15:"`Calendar`.`id`";i:1;s:20:"`Calendar`.`user_id`";i:2;s:25:"`Calendar`.`message_type`";i:3;s:23:"`Calendar`.`start_date`";i:4;s:21:"`Calendar`.`end_date`";i:5;s:18:"`Calendar`.`color`";i:6;s:21:"`Calendar`.`comments`";i:7;s:22:"`Calendar`.`is_repeat`";i:8;s:24:"`Calendar`.`repeat_type`";i:9;s:22:"`Calendar`.`repeat_no`";}s:32:"a12e6f26a9f1e7fab4a87f6cea63b18b";a:3:{i:0;s:15:"`Client`.`name`";i:1;s:8:"`Lead`.*";i:2;s:10:"`Status`.*";}s:32:"e7c54cffa9a9f46cac575e452b84d9b9";a:32:{i:0;s:14:"`Weblogo`.`id`";i:1;s:16:"`Weblogo`.`name`";i:2;s:29:"`Weblogo`.`organization_name`";i:3;s:23:"`Weblogo`.`domain_name`";i:4;s:17:"`Weblogo`.`email`";i:5;s:22:"`Weblogo`.`meta_title`";i:6;s:21:"`Weblogo`.`meta_desc`";i:7;s:20:"`Weblogo`.`timezone`";i:8;s:18:"`Weblogo`.`author`";i:9;s:28:"`Weblogo`.`sms_notification`";i:10;s:30:"`Weblogo`.`email_notification`";i:11;s:23:"`Weblogo`.`guest_login`";i:12;s:21:"`Weblogo`.`front_end`";i:13;s:18:"`Weblogo`.`slides`";i:14;s:21:"`Weblogo`.`translate`";i:15;s:19:"`Weblogo`.`contact`";i:16;s:17:"`Weblogo`.`photo`";i:17;s:20:"`Weblogo`.`currency`";i:18;s:23:"`Weblogo`.`date_format`";i:19;s:19:"`Weblogo`.`address`";i:20;s:27:"`Weblogo`.`account_details`";i:21;s:22:"`Weblogo`.`short_name`";i:22;s:20:"`Weblogo`.`due_days`";i:23;s:21:"`Weblogo`.`late_fees`";i:24;s:20:"`Weblogo`.`language`";i:25;s:20:"`Weblogo`.`dir_type`";i:26;s:21:"`Weblogo`.`min_limit`";i:27;s:21:"`Weblogo`.`max_limit`";i:28;s:19:"`Weblogo`.`map_key`";i:29;s:24:"`Weblogo`.`captcha_type`";i:30;s:19:"`Weblogo`.`created`";i:31;s:20:"`Weblogo`.`modified`";}s:32:"f7e374704cd62d1601eff1af960f1438";a:1:{i:0;s:19:"COUNT(*) AS `count`";}s:32:"25d95afeff2ac24b44eb5ff9232c8faf";a:32:{i:0;s:20:"`Configuration`.`id`";i:1;s:22:"`Configuration`.`name`";i:2;s:35:"`Configuration`.`organization_name`";i:3;s:29:"`Configuration`.`domain_name`";i:4;s:23:"`Configuration`.`email`";i:5;s:28:"`Configuration`.`meta_title`";i:6;s:27:"`Configuration`.`meta_desc`";i:7;s:26:"`Configuration`.`timezone`";i:8;s:24:"`Configuration`.`author`";i:9;s:34:"`Configuration`.`sms_notification`";i:10;s:36:"`Configuration`.`email_notification`";i:11;s:29:"`Configuration`.`guest_login`";i:12;s:27:"`Configuration`.`front_end`";i:13;s:24:"`Configuration`.`slides`";i:14;s:27:"`Configuration`.`translate`";i:15;s:25:"`Configuration`.`contact`";i:16;s:23:"`Configuration`.`photo`";i:17;s:26:"`Configuration`.`currency`";i:18;s:29:"`Configuration`.`date_format`";i:19;s:25:"`Configuration`.`address`";i:20;s:33:"`Configuration`.`account_details`";i:21;s:28:"`Configuration`.`short_name`";i:22;s:26:"`Configuration`.`due_days`";i:23;s:27:"`Configuration`.`late_fees`";i:24;s:26:"`Configuration`.`language`";i:25;s:26:"`Configuration`.`dir_type`";i:26;s:27:"`Configuration`.`min_limit`";i:27;s:27:"`Configuration`.`max_limit`";i:28;s:25:"`Configuration`.`map_key`";i:29;s:30:"`Configuration`.`captcha_type`";i:30;s:25:"`Configuration`.`created`";i:31;s:26:"`Configuration`.`modified`";}s:32:"31eb2b7202519acf4cb9895323db05e2";a:2:{i:0;s:15:"`Currency`.`id`";i:1;s:17:"`Currency`.`name`";}s:32:"478b0afcf841cd882c2c138bf0b29ffd";a:1:{i:0;s:19:"COUNT(*) AS `count`";}s:32:"c58d3387850d45b6c0e4397974b0bf2d";a:1:{i:0;s:19:"COUNT(*) AS `count`";}s:32:"e1b88334093381dd1adb5c92acbb15a3";a:5:{i:0;s:22:"`PropertiesPhoto`.`id`";i:1;s:31:"`PropertiesPhoto`.`property_id`";i:2;s:25:"`PropertiesPhoto`.`photo`";i:3;s:23:"`PropertiesPhoto`.`dir`";i:4;s:24:"`PropertiesPhoto`.`home`";}s:32:"f9ecd02b76356af461988643b9fb2452";a:4:{i:0;s:25:"`PropertiesDocument`.`id`";i:1;s:34:"`PropertiesDocument`.`property_id`";i:2;s:28:"`PropertiesDocument`.`photo`";i:3;s:26:"`PropertiesDocument`.`dir`";}s:32:"9c52f53124130388081c9f2385f76243";a:4:{i:0;s:26:"`PropertiesFloorplan`.`id`";i:1;s:35:"`PropertiesFloorplan`.`property_id`";i:2;s:29:"`PropertiesFloorplan`.`photo`";i:3;s:27:"`PropertiesFloorplan`.`dir`";}s:32:"e5a21ce6a6645c5e43d2387cbd093c18";a:2:{i:0;s:11:"`Type`.`id`";i:1;s:13:"`Type`.`name`";}s:32:"fba35a8b52ecb4dec154af8bb2872711";a:2:{i:0;s:15:"`Contract`.`id`";i:1;s:17:"`Contract`.`name`";}s:32:"fd79e06e1bc8f8e37f9374ba9a0e8383";a:2:{i:0;s:15:"`Location`.`id`";i:1;s:17:"`Location`.`name`";}s:32:"efa5b994f149d0cefa758a0346768633";a:1:{i:0;s:19:"COUNT(*) AS `count`";}s:32:"0227c4421fc1be4168891448ddff0ace";a:2:{i:0;s:9:"`Agent`.*";i:1;s:49:"(Count(`Property`.`id`)) AS  `Agent__total_count`";}s:32:"da55d1e8d81fa9429cade97b858da200";a:1:{i:0;s:19:"COUNT(*) AS `count`";}s:32:"22411e3f49bc63517a5289adb1e97a37";a:1:{i:0;s:16:"`Feature`.`name`";}s:32:"969bfb344156261412437018b1b7cb0e";a:23:{i:0;s:12:"`Agent`.`id`";i:1;s:19:"`Agent`.`ugroup_id`";i:2;s:20:"`Agent`.`project_id`";i:3;s:21:"`Agent`.`location_id`";i:4;s:14:"`Agent`.`name`";i:5;s:18:"`Agent`.`username`";i:6;s:18:"`Agent`.`password`";i:7;s:15:"`Agent`.`phone`";i:8;s:16:"`Agent`.`mobile`";i:9;s:17:"`Agent`.`address`";i:10;s:15:"`Agent`.`email`";i:11;s:15:"`Agent`.`skype`";i:12;s:18:"`Agent`.`facebook`";i:13;s:17:"`Agent`.`twitter`";i:14;s:18:"`Agent`.`linkedin`";i:15;s:21:"`Agent`.`description`";i:16;s:13:"`Agent`.`dir`";i:17;s:15:"`Agent`.`photo`";i:18;s:16:"`Agent`.`status`";i:19;s:20:"`Agent`.`presetcode`";i:20;s:17:"`Agent`.`deleted`";i:21;s:17:"`Agent`.`created`";i:22;s:18:"`Agent`.`modified`";}s:32:"28d6fc726f797b8b9830eef2f7c062a1";a:6:{i:0;s:14:"`Awallet`.`id`";i:1;s:19:"`Awallet`.`user_id`";i:2;s:22:"`Awallet`.`project_id`";i:3;s:17:"`Awallet`.`debit`";i:4;s:18:"`Awallet`.`credit`";i:5;s:19:"`Awallet`.`balance`";}s:32:"74838417cacd704db141c564dfa9d32c";a:1:{i:0;s:19:"COUNT(*) AS `count`";}s:32:"5c22a4124f7a2da589bfea177a39c5db";a:2:{i:0;s:13:"`Ugroup`.`id`";i:1;s:15:"`Ugroup`.`name`";}s:32:"ba9ce998c03b3150bdc1a023e6b26aee";a:2:{i:0;s:14:"`Project`.`id`";i:1;s:16:"`Project`.`name`";}s:32:"a2c5a3ed982443ef8ffcb897fa4626fe";a:1:{i:0;s:19:"COUNT(*) AS `count`";}s:32:"27868af55ec09bded4b931c5ba88a81a";a:1:{i:0;s:19:"COUNT(*) AS `count`";}s:32:"7adc35c501458d90f38345bc8054319f";a:2:{i:0;s:14:"`Feature`.`id`";i:1;s:16:"`Feature`.`name`";}s:32:"ebd2c5664a2dd046487091017f2a7031";a:3:{i:0;s:24:"`PropertiesFeature`.`id`";i:1;s:33:"`PropertiesFeature`.`property_id`";i:2;s:32:"`PropertiesFeature`.`feature_id`";}s:32:"de83fff416133e5c750865099ba871e0";a:2:{i:0;s:15:"`Category`.`id`";i:1;s:17:"`Category`.`name`";}s:32:"281bb9d9e9c08802a9b245d633d95356";a:22:{i:0;s:14:"`Contact`.`id`";i:1;s:23:"`Contact`.`category_id`";i:2;s:19:"`Contact`.`user_id`";i:3;s:22:"`Contact`.`project_id`";i:4;s:17:"`Contact`.`email`";i:5;s:20:"`Contact`.`password`";i:6;s:18:"`Contact`.`mobile`";i:7;s:17:"`Contact`.`phone`";i:8;s:16:"`Contact`.`name`";i:9;s:19:"`Contact`.`address`";i:10;s:20:"`Contact`.`district`";i:11;s:17:"`Contact`.`state`";i:12;s:19:"`Contact`.`pincode`";i:13;s:18:"`Contact`.`status`";i:14;s:22:"`Contact`.`last_login`";i:15;s:16:"`Contact`.`dirt`";i:16;s:17:"`Contact`.`photo`";i:17;s:20:"`Contact`.`reg_code`";i:18;s:22:"`Contact`.`reg_status`";i:19;s:22:"`Contact`.`presetcode`";i:20;s:19:"`Contact`.`created`";i:21;s:20:"`Contact`.`modified`";}s:32:"8fec5a1233485317aaae652ad18b136b";a:3:{i:0;s:15:"`Category`.`id`";i:1;s:17:"`Category`.`name`";i:2;s:17:"`Category`.`type`";}s:32:"6d9932fcdf7f8512c09ecba2034e7555";a:1:{i:0;s:19:"COUNT(*) AS `count`";}s:32:"b36c4a7c9c1352adf13ab0191985dc6f";a:3:{i:0;s:15:"`Category`.`id`";i:1;s:17:"`Category`.`name`";i:2;s:17:"`Category`.`type`";}s:32:"8583878039e0197d8e6d9464526a6717";a:1:{i:0;s:19:"COUNT(*) AS `count`";}s:32:"474047e0a68d86f872c7ca67b838d5cc";a:2:{i:0;s:11:"`Unit`.`id`";i:1;s:13:"`Unit`.`name`";}s:32:"3e8b985421b9bbd917089fffde8b2192";a:1:{i:0;s:19:"COUNT(*) AS `count`";}s:32:"0fa215007e54b5f5a5158dd02d34eeb5";a:3:{i:0;s:24:"`PropertiesFeature`.`id`";i:1;s:33:"`PropertiesFeature`.`property_id`";i:2;s:32:"`PropertiesFeature`.`feature_id`";}s:32:"f21c095560e99a3311b5e229e7274a55";a:2:{i:0;s:14:"`Feature`.`id`";i:1;s:16:"`Feature`.`name`";}s:32:"8d787e372f4b84e0830a30d8dca46b5e";a:2:{i:0;s:14:"`Feature`.`id`";i:1;s:16:"`Feature`.`name`";}s:32:"92c7b9e5720fa61111b6a5ed1383d2e1";a:2:{i:0;s:14:"`Feature`.`id`";i:1;s:16:"`Feature`.`name`";}s:32:"ca967b3f01693dedb555ebcf7d5a59cc";a:2:{i:0;s:11:"`Unit`.`id`";i:1;s:13:"`Unit`.`name`";}s:32:"a081d6e0248986d9302959ba184702c4";a:2:{i:0;s:11:"`User`.`id`";i:1;s:13:"`User`.`name`";}s:32:"dc487f38b415e7f3db54fec80e7aadc3";a:5:{i:0;s:22:"`PropertiesPhoto`.`id`";i:1;s:31:"`PropertiesPhoto`.`property_id`";i:2;s:25:"`PropertiesPhoto`.`photo`";i:3;s:23:"`PropertiesPhoto`.`dir`";i:4;s:24:"`PropertiesPhoto`.`home`";}s:32:"e531487445b4f2aed45154d9f065d3c5";a:2:{i:0;s:15:"`Location`.`id`";i:1;s:17:"`Location`.`name`";}s:32:"0da10801ca76b49eab47a49c719f2055";a:1:{i:0;s:19:"COUNT(*) AS `count`";}s:32:"38183cdbccfe915c22d5e875db1dc5a6";a:4:{i:0;s:15:"`Currency`.`id`";i:1;s:17:"`Currency`.`name`";i:2;s:18:"`Currency`.`short`";i:3;s:18:"`Currency`.`photo`";}s:32:"e30e3f5d855ea1da37f9d8251081d903";a:1:{i:0;s:19:"COUNT(*) AS `count`";}s:32:"f064150923c8597fdab1130e201f8fe7";a:4:{i:0;s:11:"`Type`.`id`";i:1;s:13:"`Type`.`name`";i:2;s:13:"`Type`.`dirt`";i:3;s:14:"`Type`.`photo`";}s:32:"396182293a8548feebd68d5bee7271e1";a:1:{i:0;s:19:"COUNT(*) AS `count`";}s:32:"2bb77c9ca92510c01bec200b7cf9a493";a:3:{i:0;s:10:"`Tax`.`id`";i:1;s:12:"`Tax`.`name`";i:2;s:15:"`Tax`.`percent`";}s:32:"444b4e4e6804579cdb494a94dd224caa";a:1:{i:0;s:19:"COUNT(*) AS `count`";}s:32:"f6fb740bb5028cd1518d97f820611254";a:4:{i:0;s:11:"`Plan`.`id`";i:1;s:13:"`Plan`.`name`";i:2;s:20:"`Plan`.`installment`";i:3;s:15:"`Plan`.`status`";}s:32:"f2f96ee2aae31aecf1bd36cc6971c37c";a:1:{i:0;s:19:"COUNT(*) AS `count`";}s:32:"0a34750df639223d6a131aaf2581fa91";a:2:{i:0;s:18:"`Paymenttype`.`id`";i:1;s:20:"`Paymenttype`.`name`";}s:32:"d7889d62a88dba847b1e4a7a97af97ab";a:1:{i:0;s:19:"COUNT(*) AS `count`";}s:32:"87fa748512a8b87b834abf612785a827";a:5:{i:0;s:13:"`Ugroup`.`id`";i:1;s:15:"`Ugroup`.`name`";i:2;s:15:"`Ugroup`.`type`";i:3;s:18:"`Ugroup`.`created`";i:4;s:19:"`Ugroup`.`modified`";}s:32:"fbb43537d99160479bd62378ce7cbbda";a:2:{i:0;s:14:"`Feature`.`id`";i:1;s:16:"`Feature`.`name`";}s:32:"70577aeda6bdf037de5265db0849d0c8";a:1:{i:0;s:19:"COUNT(*) AS `count`";}s:32:"319ee044f3c72a01bfc633847cb77947";a:2:{i:0;s:15:"`Contract`.`id`";i:1;s:17:"`Contract`.`name`";}s:32:"b14ce68ad4065191dd3fd2ddfa7114d3";a:1:{i:0;s:19:"COUNT(*) AS `count`";}s:32:"472456f8d3fde42db2b855482b77b9e8";a:6:{i:0;s:15:"`Template`.`id`";i:1;s:17:"`Template`.`name`";i:2;s:24:"`Template`.`description`";i:3;s:17:"`Template`.`type`";i:4;s:19:"`Template`.`status`";i:5;s:19:"`Template`.`is_new`";}s:32:"3e8502edae77ec60c5e7e067d525ea27";a:1:{i:0;s:19:"COUNT(*) AS `count`";}s:32:"0e94e18a37b7c7464029c0e0b7708df8";a:15:{i:0;s:14:"`Content`.`id`";i:1;s:21:"`Content`.`link_name`";i:2;s:21:"`Content`.`page_name`";i:3;s:21:"`Content`.`page_icon`";i:4;s:18:"`Content`.`is_url`";i:5;s:15:"`Content`.`url`";i:6;s:22:"`Content`.`url_target`";i:7;s:24:"`Content`.`main_content`";i:8;s:20:"`Content`.`page_url`";i:9;s:16:"`Content`.`cols`";i:10;s:20:"`Content`.`ordering`";i:11;s:17:"`Content`.`views`";i:12;s:21:"`Content`.`published`";i:13;s:19:"`Content`.`created`";i:14;s:20:"`Content`.`modified`";}s:32:"fa8ffb3edf1700817a11ccdc82ee7937";a:1:{i:0;s:19:"COUNT(*) AS `count`";}s:32:"6b77311a2fd6580589992dd254b707e1";a:17:{i:0;s:11:"`Deal`.`id`";i:1;s:16:"`Deal`.`user_id`";i:2;s:18:"`Deal`.`client_id`";i:3;s:20:"`Deal`.`property_id`";i:4;s:27:"`Deal`.`properties_flat_id`";i:5;s:16:"`Deal`.`plan_id`";i:6;s:19:"`Deal`.`invoice_no`";i:7;s:13:"`Deal`.`date`";i:8;s:21:"`Deal`.`evocate_date`";i:9;s:18:"`Deal`.`recurring`";i:10;s:23:"`Deal`.`booking_amount`";i:11;s:17:"`Deal`.`discount`";i:12;s:21:"`Deal`.`total_amount`";i:13;s:16:"`Deal`.`remarks`";i:14;s:16:"`Deal`.`created`";i:15;s:17:"`Deal`.`modified`";i:16;s:147:"(SELECT SUM(`DealPayment`.`emi`) as Deal__payment FROM deals_payments as DealPayment WHERE `DealPayment`.`deal_id`=`Deal`.`id`) AS  `Deal__payment`";}s:32:"6e8b1604d8442803ad7b0690db67f604";a:32:{i:0;s:15:"`Property`.`id`";i:1;s:20:"`Property`.`user_id`";i:2;s:20:"`Property`.`uniq_id`";i:3;s:23:"`Property`.`project_id`";i:4;s:24:"`Property`.`location_id`";i:5;s:24:"`Property`.`contract_id`";i:6;s:20:"`Property`.`type_id`";i:7;s:20:"`Property`.`unit_id`";i:8;s:17:"`Property`.`name`";i:9;s:20:"`Property`.`address`";i:10;s:24:"`Property`.`description`";i:11;s:17:"`Property`.`area`";i:12;s:18:"`Property`.`price`";i:13;s:29:"`Property`.`agent_commission`";i:14;s:28:"`Property`.`commission_type`";i:15;s:18:"`Property`.`floor`";i:16;s:20:"`Property`.`bedroom`";i:17;s:21:"`Property`.`bathroom`";i:18;s:19:"`Property`.`rating`";i:19;s:25:"`Property`.`rating_count`";i:20;s:25:"`Property`.`rating_users`";i:21;s:21:"`Property`.`latitude`";i:22;s:22:"`Property`.`longitude`";i:23;s:18:"`Property`.`video`";i:24;s:18:"`Property`.`views`";i:25;s:25:"`Property`.`allow_rating`";i:26;s:26:"`Property`.`allow_comment`";i:27;s:19:"`Property`.`status`";i:28;s:21:"`Property`.`featured`";i:29;s:22:"`Property`.`published`";i:30;s:20:"`Property`.`created`";i:31;s:21:"`Property`.`modified`";}s:32:"6f2cede44605d390fed5af3883da57d8";a:22:{i:0;s:13:"`Client`.`id`";i:1;s:22:"`Client`.`category_id`";i:2;s:18:"`Client`.`user_id`";i:3;s:21:"`Client`.`project_id`";i:4;s:16:"`Client`.`email`";i:5;s:19:"`Client`.`password`";i:6;s:17:"`Client`.`mobile`";i:7;s:16:"`Client`.`phone`";i:8;s:15:"`Client`.`name`";i:9;s:18:"`Client`.`address`";i:10;s:19:"`Client`.`district`";i:11;s:16:"`Client`.`state`";i:12;s:18:"`Client`.`pincode`";i:13;s:17:"`Client`.`status`";i:14;s:21:"`Client`.`last_login`";i:15;s:15:"`Client`.`dirt`";i:16;s:16:"`Client`.`photo`";i:17;s:19:"`Client`.`reg_code`";i:18;s:21:"`Client`.`reg_status`";i:19;s:21:"`Client`.`presetcode`";i:20;s:18:"`Client`.`created`";i:21;s:19:"`Client`.`modified`";}s:32:"58be97e4b1b81856e8c1430cdaca9b97";a:4:{i:0;s:11:"`Plan`.`id`";i:1;s:13:"`Plan`.`name`";i:2;s:20:"`Plan`.`installment`";i:3;s:15:"`Plan`.`status`";}s:32:"0d4e6c8bbd727952e94c96e1444c079b";a:1:{i:0;s:19:"COUNT(*) AS `count`";}s:32:"0787ea03b8fb36d49f23c0670de41a06";a:1:{i:0;s:42:"SUM(`Purchasereport`.`amount`) AS purchase";}s:32:"11fb8a10fcfe7bfcfd7343ebd817b39e";a:1:{i:0;s:19:"COUNT(*) AS `count`";}s:32:"f4b96f83d1340a50087aa9ebbd99a6be";a:1:{i:0;s:19:"COUNT(*) AS `count`";}s:32:"d7b128e3f56f88c114975fcadcd4e741";a:1:{i:0;s:18:"Page.*,PageRight.*";}s:32:"bff350501295fb6b3305743319dd2b58";a:8:{i:0;s:11:"`Lead`.`id`";i:1;s:16:"`Lead`.`user_id`";i:2;s:19:"`Lead`.`project_id`";i:3;s:20:"`Lead`.`property_id`";i:4;s:18:"`Lead`.`client_id`";i:5;s:18:"`Lead`.`status_id`";i:6;s:18:"`Lead`.`follow_up`";i:7;s:16:"`Lead`.`remarks`";}s:32:"8f17989b9fed03bc6abcd383bc7dfe6f";a:4:{i:0;s:13:"`Status`.`id`";i:1;s:15:"`Status`.`name`";i:2;s:16:"`Status`.`color`";i:3;s:15:"`Status`.`type`";}s:32:"ad51bb94dbccb5127f02c3e4fdbce759";a:1:{i:0;s:19:"COUNT(*) AS `count`";}s:32:"6318c68ff0a1670420c256ddff241ac6";a:12:{i:0;s:15:"`Purchase`.`id`";i:1;s:23:"`Purchase`.`project_id`";i:2;s:17:"`Purchase`.`name`";i:3;s:20:"`Purchase`.`address`";i:4;s:19:"`Purchase`.`mobile`";i:5;s:26:"`Purchase`.`property_name`";i:6;s:24:"`Purchase`.`description`";i:7;s:17:"`Purchase`.`area`";i:8;s:20:"`Purchase`.`unit_id`";i:9;s:19:"`Purchase`.`amount`";i:10;s:20:"`Purchase`.`remarks`";i:11;s:186:"(SELECT SUM(`PurchasesPayment`.`amount`) as Purchases__payment FROM purchases_payments as PurchasesPayment WHERE `PurchasesPayment`.`purchase_id`=`Purchase`.`id`) AS  `Purchase__payment`";}s:32:"a5ec862e28bdabb3cf0cf65013e96cc4";a:1:{i:0;s:19:"COUNT(*) AS `count`";}s:32:"98506e47ba9d0318c26dd5d2c6ebfeaf";a:2:{i:0;s:27:"`Smstemplate`.`description`";i:1;s:20:"`Smstemplate`.`name`";}s:32:"89a1675048a1c0e435f2d240a9320a94";a:11:{i:0;s:17:"`Smssetting`.`id`";i:1;s:18:"`Smssetting`.`api`";i:2;s:23:"`Smssetting`.`username`";i:3;s:23:"`Smssetting`.`password`";i:4;s:23:"`Smssetting`.`senderid`";i:5;s:24:"`Smssetting`.`husername`";i:6;s:24:"`Smssetting`.`hpassword`";i:7;s:24:"`Smssetting`.`hsenderid`";i:8;s:22:"`Smssetting`.`hmobile`";i:9;s:23:"`Smssetting`.`hmessage`";i:10;s:19:"`Smssetting`.`type`";}s:32:"0b45769bb0e47cbf82b50ac0716d273b";a:2:{i:0;s:29:"`Emailtemplate`.`description`";i:1;s:22:"`Emailtemplate`.`name`";}s:32:"222a6ac7925c50b089c66caf3ac97db4";a:1:{i:0;s:19:"COUNT(*) AS `count`";}s:32:"7ccca47b7ad4d3d6e79b0c9b0e18b818";a:5:{i:0;s:20:"`Emailtemplate`.`id`";i:1;s:22:"`Emailtemplate`.`name`";i:2;s:29:"`Emailtemplate`.`description`";i:3;s:24:"`Emailtemplate`.`status`";i:4;s:22:"`Emailtemplate`.`type`";}s:32:"a18002c5aa4186ae624db692d53dcef9";a:22:{i:0;s:13:"`Client`.`id`";i:1;s:22:"`Client`.`category_id`";i:2;s:18:"`Client`.`user_id`";i:3;s:21:"`Client`.`project_id`";i:4;s:16:"`Client`.`email`";i:5;s:19:"`Client`.`password`";i:6;s:17:"`Client`.`mobile`";i:7;s:16:"`Client`.`phone`";i:8;s:15:"`Client`.`name`";i:9;s:18:"`Client`.`address`";i:10;s:19:"`Client`.`district`";i:11;s:16:"`Client`.`state`";i:12;s:18:"`Client`.`pincode`";i:13;s:17:"`Client`.`status`";i:14;s:21:"`Client`.`last_login`";i:15;s:15:"`Client`.`dirt`";i:16;s:16:"`Client`.`photo`";i:17;s:19:"`Client`.`reg_code`";i:18;s:21:"`Client`.`reg_status`";i:19;s:21:"`Client`.`presetcode`";i:20;s:18:"`Client`.`created`";i:21;s:19:"`Client`.`modified`";}s:32:"112056739d9b7386063660a50f1ae6a8";a:1:{i:0;s:19:"COUNT(*) AS `count`";}s:32:"aae3f6544389785aeda3aca4c93a3275";a:2:{i:0;s:16:"`DealsPayment`.*";i:1;s:20:"`Paymenttype`.`name`";}s:32:"3e06448508aeefde5e2da9d41a0a836f";a:2:{i:0;s:18:"`Paymenttype`.`id`";i:1;s:20:"`Paymenttype`.`name`";}s:32:"2153181731c7172fab1c12436279d370";a:3:{i:0;s:22:"`ExpenseCategory`.`id`";i:1;s:24:"`ExpenseCategory`.`name`";i:2;s:26:"`ExpenseCategory`.`status`";}s:32:"2e62993062990e7f5730d8a742df1806";a:1:{i:0;s:19:"COUNT(*) AS `count`";}s:32:"fd71e1887c22540706d2a26bb33e7e18";a:6:{i:0;s:13:"`Vendor`.`id`";i:1;s:15:"`Vendor`.`name`";i:2;s:18:"`Vendor`.`address`";i:3;s:18:"`Vendor`.`contact`";i:4;s:21:"`Vendor`.`licence_no`";i:5;s:21:"`Vendor`.`project_id`";}s:32:"de27a51da319c2db95f5bd560d6291d6";a:1:{i:0;s:19:"COUNT(*) AS `count`";}s:32:"0f48288c224275f25d19929a86d160f8";a:9:{i:0;s:16:"`Inventory`.`id`";i:1;s:24:"`Inventory`.`project_id`";i:2;s:33:"`Inventory`.`expense_category_id`";i:3;s:23:"`Inventory`.`vendor_id`";i:4;s:24:"`Inventory`.`invoice_no`";i:5;s:26:"`Inventory`.`invoice_date`";i:6;s:25:"`Inventory`.`invoice_qty`";i:7;s:21:"`Inventory`.`remarks`";i:8;s:188:"(SELECT SUM(`InventoriesBalance`.`qty`) as Inventories__qty FROM inventories_balances as InventoriesBalance WHERE `InventoriesBalance`.`inventory_id`=`Inventory`.`id`) AS  `Inventory__qty`";}s:32:"540fd7538a754708ceef56207d2f4ccd";a:3:{i:0;s:22:"`ExpenseCategory`.`id`";i:1;s:24:"`ExpenseCategory`.`name`";i:2;s:26:"`ExpenseCategory`.`status`";}s:32:"7b01b1b069bcd70456e0ede3b6c73d3a";a:6:{i:0;s:13:"`Vendor`.`id`";i:1;s:15:"`Vendor`.`name`";i:2;s:18:"`Vendor`.`address`";i:3;s:18:"`Vendor`.`contact`";i:4;s:21:"`Vendor`.`licence_no`";i:5;s:21:"`Vendor`.`project_id`";}s:32:"dea0ec65a8f6af597b0232b2c292666e";a:1:{i:0;s:19:"COUNT(*) AS `count`";}s:32:"177079c012f381cf27c11cb318089f49";a:9:{i:0;s:14:"`Expense`.`id`";i:1;s:22:"`Expense`.`project_id`";i:2;s:31:"`Expense`.`expense_category_id`";i:3;s:21:"`Expense`.`vendor_id`";i:4;s:22:"`Expense`.`invoice_no`";i:5;s:24:"`Expense`.`invoice_date`";i:6;s:26:"`Expense`.`invoice_amount`";i:7;s:19:"`Expense`.`remarks`";i:8;s:178:"(SELECT SUM(`ExpensesPayment`.`amount`) as Expenses__payment FROM expenses_payments as ExpensesPayment WHERE `ExpensesPayment`.`expense_id`=`Expense`.`id`) AS  `Expense__payment`";}s:32:"983f78de9557796a885c6441e513e4a4";a:1:{i:0;s:19:"COUNT(*) AS `count`";}s:32:"2c0295ad7b49bbd463ee775df602bdc7";a:2:{i:0;s:13:"`Vendor`.`id`";i:1;s:15:"`Vendor`.`name`";}s:32:"85bbf6a64ca5cd4fc132c898234158e8";a:2:{i:0;s:22:"`ExpenseCategory`.`id`";i:1;s:24:"`ExpenseCategory`.`name`";}s:32:"0d3054890750f38a2d8362699bcf5596";a:2:{i:0;s:13:"`Status`.`id`";i:1;s:15:"`Status`.`name`";}s:32:"fb5853e23918c5d16a8a45f5f3962840";a:1:{i:0;s:19:"COUNT(*) AS `count`";}s:32:"d6dedc4a2f7ac1cf2384adefea96727b";a:1:{i:0;s:40:"SUM(`Expensereport`.`amount`) AS expense";}s:32:"deb5ab85a00ec03cf45b317ddfc287ef";a:1:{i:0;s:28:"SUM(total_amount) AS earning";}s:32:"176b93dfec041f12cfafd04ee180b444";a:1:{i:0;s:39:"SUM(`Profitreport`.`amount`) AS expense";}s:32:"e1e1485648f5a17e41d6ad0abe0c9930";a:6:{i:0;s:20:"`Searchhistory`.`id`";i:1;s:22:"`Searchhistory`.`name`";i:2;s:22:"`Searchhistory`.`link`";i:3;s:24:"`Searchhistory`.`search`";i:4;s:28:"`Searchhistory`.`ip_address`";i:5;s:25:"`Searchhistory`.`created`";}s:32:"b1d3b16139394d6b62dae7a951ceac4d";a:8:{i:0;s:12:"`Slide`.`id`";i:1;s:20:"`Slide`.`slide_name`";i:2;s:18:"`Slide`.`ordering`";i:3;s:15:"`Slide`.`photo`";i:4;s:14:"`Slide`.`dirt`";i:5;s:16:"`Slide`.`status`";i:6;s:17:"`Slide`.`created`";i:7;s:18:"`Slide`.`modified`";}s:32:"d63031fac3a520da0ca7e63201f69932";a:1:{i:0;s:19:"COUNT(*) AS `count`";}s:32:"7954fb8186caa08de62a8601092b8b09";a:6:{i:0;s:15:"`Template`.`id`";i:1;s:17:"`Template`.`name`";i:2;s:24:"`Template`.`description`";i:3;s:17:"`Template`.`type`";i:4;s:19:"`Template`.`status`";i:5;s:19:"`Template`.`is_new`";}s:32:"747da07e60996cf369e7ee03ec88ddd4";a:16:{i:0;s:13:"`MyDeal`.`id`";i:1;s:18:"`MyDeal`.`user_id`";i:2;s:20:"`MyDeal`.`client_id`";i:3;s:22:"`MyDeal`.`property_id`";i:4;s:29:"`MyDeal`.`properties_flat_id`";i:5;s:18:"`MyDeal`.`plan_id`";i:6;s:21:"`MyDeal`.`invoice_no`";i:7;s:15:"`MyDeal`.`date`";i:8;s:23:"`MyDeal`.`evocate_date`";i:9;s:20:"`MyDeal`.`recurring`";i:10;s:25:"`MyDeal`.`booking_amount`";i:11;s:19:"`MyDeal`.`discount`";i:12;s:23:"`MyDeal`.`total_amount`";i:13;s:18:"`MyDeal`.`remarks`";i:14;s:18:"`MyDeal`.`created`";i:15;s:19:"`MyDeal`.`modified`";}s:32:"114cb3ad68b6d4f9dab34a41f5e7b3bd";a:1:{i:0;s:19:"COUNT(*) AS `count`";}s:32:"d22e8219bb0a9ad1169130703b8b0d0c";a:5:{i:0;s:13:"`Agency`.`id`";i:1;s:15:"`Agency`.`name`";i:2;s:16:"`Agency`.`phone`";i:3;s:17:"`Agency`.`mobile`";i:4;s:16:"`Agency`.`email`";}s:32:"e47660374c4f9eeb28d78c1d6757bb95";a:1:{i:0;s:19:"COUNT(*) AS `count`";}s:32:"a36b416a73a0d27b8b6b386a77ba9ec0";a:2:{i:0;s:8:"`Page`.*";i:1;s:13:"`PageRight`.*";}s:32:"0be3b1ecb556fa7c7d7860e394250474";a:6:{i:0;s:19:"`Emailsetting`.`id`";i:1;s:21:"`Emailsetting`.`type`";i:2;s:21:"`Emailsetting`.`host`";i:3;s:25:"`Emailsetting`.`username`";i:4;s:25:"`Emailsetting`.`password`";i:5;s:21:"`Emailsetting`.`port`";}s:32:"dd2ff351a156195cba29cb60c2df7116";a:5:{i:0;s:18:"`Smstemplate`.`id`";i:1;s:20:"`Smstemplate`.`name`";i:2;s:27:"`Smstemplate`.`description`";i:3;s:22:"`Smstemplate`.`status`";i:4;s:20:"`Smstemplate`.`type`";}s:32:"64d53fa8e7ee8ee09f4928d5dcc11897";a:1:{i:0;s:19:"COUNT(*) AS `count`";}s:32:"30b14b35d4deda61ab1470faa38ee30d";a:5:{i:0;s:20:"`Emailtemplate`.`id`";i:1;s:22:"`Emailtemplate`.`name`";i:2;s:29:"`Emailtemplate`.`description`";i:3;s:24:"`Emailtemplate`.`status`";i:4;s:22:"`Emailtemplate`.`type`";}s:32:"bfc80a1819ed27981afe022bbc47549a";a:1:{i:0;s:19:"COUNT(*) AS `count`";}s:32:"20bf121059b6766268b0a7b59c9d115b";a:16:{i:0;s:11:"`Deal`.`id`";i:1;s:16:"`Deal`.`user_id`";i:2;s:18:"`Deal`.`client_id`";i:3;s:20:"`Deal`.`property_id`";i:4;s:27:"`Deal`.`properties_flat_id`";i:5;s:16:"`Deal`.`plan_id`";i:6;s:19:"`Deal`.`invoice_no`";i:7;s:13:"`Deal`.`date`";i:8;s:21:"`Deal`.`evocate_date`";i:9;s:18:"`Deal`.`recurring`";i:10;s:23:"`Deal`.`booking_amount`";i:11;s:17:"`Deal`.`discount`";i:12;s:21:"`Deal`.`total_amount`";i:13;s:16:"`Deal`.`remarks`";i:14;s:16:"`Deal`.`created`";i:15;s:17:"`Deal`.`modified`";}s:32:"a4e5ae5088ba96c7b42b66cc789c5088";a:6:{i:0;s:14:"`Awallet`.`id`";i:1;s:19:"`Awallet`.`user_id`";i:2;s:22:"`Awallet`.`project_id`";i:3;s:35:"(SUM(credit)) AS  `Awallet__credit`";i:4;s:33:"(SUM(debit)) AS  `Awallet__debit`";i:5;s:37:"(SUM(balance)) AS  `Awallet__balance`";}s:32:"b46dca3c89ed02bc93e7a58f33d9d96b";a:8:{i:0;s:21:"`AwalletHistory`.`id`";i:1;s:26:"`AwalletHistory`.`user_id`";i:2;s:29:"`AwalletHistory`.`project_id`";i:3;s:35:"`AwalletHistory`.`deals_payment_id`";i:4;s:25:"`AwalletHistory`.`amount`";i:5;s:23:"`AwalletHistory`.`type`";i:6;s:23:"`AwalletHistory`.`date`";i:7;s:26:"`AwalletHistory`.`remarks`";}s:32:"b39f86fbcc8784788fd3efc72d9b2d97";a:1:{i:0;s:33:"DISTINCT `PropertiesFeature`.`id`";}s:32:"27de901a86e848e1545ecdac7cd0c93b";a:2:{i:0;s:13:"`Client`.`id`";i:1;s:15:"`Client`.`name`";}s:32:"877a7e0327a7d1d33bf487bd70da0e88";a:2:{i:0;s:15:"`Property`.`id`";i:1;s:17:"`Property`.`name`";}s:32:"7ae72f4246aa29ecff947e8a67e3465a";a:2:{i:0;s:11:"`Plan`.`id`";i:1;s:13:"`Plan`.`name`";}s:32:"cf735fc5518ed2cebe0307d9df0af23d";a:1:{i:0;s:11:"`Deal`.`id`";}s:32:"91f21c8101ed3a06f47e13bcdee8a192";a:32:{i:0;s:20:"`Configuration`.`id`";i:1;s:22:"`Configuration`.`name`";i:2;s:35:"`Configuration`.`organization_name`";i:3;s:29:"`Configuration`.`domain_name`";i:4;s:23:"`Configuration`.`email`";i:5;s:28:"`Configuration`.`meta_title`";i:6;s:27:"`Configuration`.`meta_desc`";i:7;s:26:"`Configuration`.`timezone`";i:8;s:24:"`Configuration`.`author`";i:9;s:34:"`Configuration`.`sms_notification`";i:10;s:36:"`Configuration`.`email_notification`";i:11;s:29:"`Configuration`.`guest_login`";i:12;s:27:"`Configuration`.`front_end`";i:13;s:24:"`Configuration`.`slides`";i:14;s:27:"`Configuration`.`translate`";i:15;s:25:"`Configuration`.`contact`";i:16;s:23:"`Configuration`.`photo`";i:17;s:26:"`Configuration`.`currency`";i:18;s:29:"`Configuration`.`date_format`";i:19;s:25:"`Configuration`.`address`";i:20;s:33:"`Configuration`.`account_details`";i:21;s:28:"`Configuration`.`short_name`";i:22;s:26:"`Configuration`.`due_days`";i:23;s:27:"`Configuration`.`late_fees`";i:24;s:26:"`Configuration`.`language`";i:25;s:26:"`Configuration`.`dir_type`";i:26;s:27:"`Configuration`.`min_limit`";i:27;s:27:"`Configuration`.`max_limit`";i:28;s:25:"`Configuration`.`map_key`";i:29;s:30:"`Configuration`.`captcha_type`";i:30;s:25:"`Configuration`.`created`";i:31;s:26:"`Configuration`.`modified`";}s:32:"efee0e6ceb91260f411d820bb196e629";a:11:{i:0;s:17:"`Smssetting`.`id`";i:1;s:18:"`Smssetting`.`api`";i:2;s:23:"`Smssetting`.`username`";i:3;s:23:"`Smssetting`.`password`";i:4;s:23:"`Smssetting`.`senderid`";i:5;s:24:"`Smssetting`.`husername`";i:6;s:24:"`Smssetting`.`hpassword`";i:7;s:24:"`Smssetting`.`hsenderid`";i:8;s:22:"`Smssetting`.`hmobile`";i:9;s:23:"`Smssetting`.`hmessage`";i:10;s:19:"`Smssetting`.`type`";}s:32:"a403a1a2c0ee22e4494d2f2137189929";a:11:{i:0;s:15:"`Purchase`.`id`";i:1;s:23:"`Purchase`.`project_id`";i:2;s:17:"`Purchase`.`name`";i:3;s:20:"`Purchase`.`address`";i:4;s:19:"`Purchase`.`mobile`";i:5;s:26:"`Purchase`.`property_name`";i:6;s:24:"`Purchase`.`description`";i:7;s:17:"`Purchase`.`area`";i:8;s:20:"`Purchase`.`unit_id`";i:9;s:19:"`Purchase`.`amount`";i:10;s:20:"`Purchase`.`remarks`";}s:32:"1603b5dc582e969befd01095ea69704b";a:6:{i:0;s:23:"`PurchasesPayment`.`id`";i:1;s:32:"`PurchasesPayment`.`purchase_id`";i:2;s:35:"`PurchasesPayment`.`paymenttype_id`";i:3;s:27:"`PurchasesPayment`.`amount`";i:4;s:25:"`PurchasesPayment`.`date`";i:5;s:28:"`PurchasesPayment`.`remarks`";}s:32:"fcb77c4e36f9bd6f53cbcdc960f6d938";a:11:{i:0;s:15:"`Purchase`.`id`";i:1;s:23:"`Purchase`.`project_id`";i:2;s:17:"`Purchase`.`name`";i:3;s:20:"`Purchase`.`address`";i:4;s:19:"`Purchase`.`mobile`";i:5;s:26:"`Purchase`.`property_name`";i:6;s:24:"`Purchase`.`description`";i:7;s:17:"`Purchase`.`area`";i:8;s:20:"`Purchase`.`unit_id`";i:9;s:19:"`Purchase`.`amount`";i:10;s:20:"`Purchase`.`remarks`";}s:32:"24de88743e91e8fee5dd7fb6d27c684c";a:2:{i:0;s:18:"`Paymenttype`.`id`";i:1;s:20:"`Paymenttype`.`name`";}s:32:"b667a27b90c2ac6be24cd9eee38b8b68";a:1:{i:0;s:24:"DISTINCT `Category`.`id`";}s:32:"236dcfaba03885159f691ef1c28dcfc6";a:4:{i:0;s:13:"`Status`.`id`";i:1;s:15:"`Status`.`name`";i:2;s:16:"`Status`.`color`";i:3;s:15:"`Status`.`type`";}s:32:"36d8c378d3a13dbcfbea9241632bd1a9";a:1:{i:0;s:19:"COUNT(*) AS `count`";}s:32:"44620b23163001f7268613467bf8eaf4";a:1:{i:0;s:19:"COUNT(*) AS `count`";}s:32:"5348d368eddec9caec1e45adde465b62";a:8:{i:0;s:14:"`Expense`.`id`";i:1;s:22:"`Expense`.`project_id`";i:2;s:31:"`Expense`.`expense_category_id`";i:3;s:21:"`Expense`.`vendor_id`";i:4;s:22:"`Expense`.`invoice_no`";i:5;s:24:"`Expense`.`invoice_date`";i:6;s:26:"`Expense`.`invoice_amount`";i:7;s:19:"`Expense`.`remarks`";}s:32:"98272579a40070328e6d7c1e561dee46";a:1:{i:0;s:19:"COUNT(*) AS `count`";}s:32:"6f3e67acb7ab9245d7d01f36dcbe7a58";a:4:{i:0;s:15:"`Vendor`.`name`";i:1;s:22:"`Expense`.`invoice_no`";i:2;s:24:"`Expense`.`invoice_date`";i:3;s:26:"`Expense`.`invoice_amount`";}s:32:"dae22283e3075bc65ae452c7cfb580ad";a:6:{i:0;s:22:"`ExpensesPayment`.`id`";i:1;s:30:"`ExpensesPayment`.`expense_id`";i:2;s:34:"`ExpensesPayment`.`paymenttype_id`";i:3;s:26:"`ExpensesPayment`.`amount`";i:4;s:24:"`ExpensesPayment`.`date`";i:5;s:27:"`ExpensesPayment`.`remarks`";}s:32:"2aeaecb7349cef6e0e84072de7207bd8";a:8:{i:0;s:14:"`Expense`.`id`";i:1;s:22:"`Expense`.`project_id`";i:2;s:31:"`Expense`.`expense_category_id`";i:3;s:21:"`Expense`.`vendor_id`";i:4;s:22:"`Expense`.`invoice_no`";i:5;s:24:"`Expense`.`invoice_date`";i:6;s:26:"`Expense`.`invoice_amount`";i:7;s:19:"`Expense`.`remarks`";}s:32:"9ccfbade974b75bb2cbb3b97ce062e3f";a:4:{i:0;s:15:"`Vendor`.`name`";i:1;s:24:"`Inventory`.`invoice_no`";i:2;s:26:"`Inventory`.`invoice_date`";i:3;s:25:"`Inventory`.`invoice_qty`";}s:32:"97de69f977906453b0b5a5c3d799b5e5";a:5:{i:0;s:25:"`InventoriesBalance`.`id`";i:1;s:35:"`InventoriesBalance`.`inventory_id`";i:2;s:26:"`InventoriesBalance`.`qty`";i:3;s:27:"`InventoriesBalance`.`date`";i:4;s:30:"`InventoriesBalance`.`remarks`";}s:32:"e392c2c087bf944750bb364db98ba5a3";a:8:{i:0;s:16:"`Inventory`.`id`";i:1;s:24:"`Inventory`.`project_id`";i:2;s:33:"`Inventory`.`expense_category_id`";i:3;s:23:"`Inventory`.`vendor_id`";i:4;s:24:"`Inventory`.`invoice_no`";i:5;s:26:"`Inventory`.`invoice_date`";i:6;s:25:"`Inventory`.`invoice_qty`";i:7;s:21:"`Inventory`.`remarks`";}s:32:"9c65d4153232c39f58472ffec712b654";a:17:{i:0;s:13:"`Type`.`name`";i:1;s:13:"`Client`.`id`";i:2;s:15:"`Client`.`name`";i:3;s:16:"`Client`.`phone`";i:4;s:18:"`Client`.`address`";i:5;s:16:"`Client`.`email`";i:6;s:17:"`Property`.`name`";i:7;s:20:"`Property`.`address`";i:8;s:16:"`Project`.`name`";i:9;s:11:"`Deal`.`id`";i:10;s:16:"`Deal`.`plan_id`";i:11;s:19:"`Deal`.`invoice_no`";i:12;s:17:"`Invpastdue`.`id`";i:13;s:19:"`Invpastdue`.`name`";i:14;s:19:"`Invpastdue`.`date`";i:15;s:21:"`Deal`.`total_amount`";i:16;s:21:"`Invpastdue`.`amount`";}s:32:"23f8957e0db1e9ec3ec5283b266d7cf4";a:1:{i:0;s:19:"COUNT(*) AS `count`";}s:32:"b5c3cb9b1466d48c0f7409f74781006d";a:1:{i:0;s:19:"COUNT(*) AS `count`";}s:32:"b11e17c90c58cfa6e27e3faad6f8c9ee";a:5:{i:0;s:18:"`Smstemplate`.`id`";i:1;s:20:"`Smstemplate`.`name`";i:2;s:27:"`Smstemplate`.`description`";i:3;s:22:"`Smstemplate`.`status`";i:4;s:20:"`Smstemplate`.`type`";}s:32:"08cc77bbb14da542afc90e9798ed79d6";a:9:{i:0;s:15:"`Client`.`name`";i:1;s:16:"`Client`.`phone`";i:2;s:17:"`Property`.`name`";i:3;s:22:"`Invpaid`.`invoice_no`";i:4;s:29:"`DealsPayment`.`total_amount`";i:5;s:29:"`DealsPayment`.`payment_date`";i:6;s:27:"`DealsPayment`.`tax_amount`";i:7;s:23:"`DealsPayment`.`amount`";i:8;s:21:"`PlansPayment`.`name`";}s:32:"7f874cc884e6065cfc97678d5846ba16";a:8:{i:0;s:16:"`DealsPayment`.*";i:1;s:8:"`Deal`.*";i:2;s:10:"`Client`.*";i:3;s:12:"`Property`.*";i:4;s:8:"`Unit`.*";i:5;s:8:"`Plan`.*";i:6;s:16:"`PlansPayment`.*";i:7;s:15:"`Paymenttype`.*";}s:32:"8cd272962eb801aef2349dc8f1e72d8c";a:5:{i:0;s:17:"`Property`.`area`";i:1;s:18:"`Property`.`price`";i:2;s:13:"`Unit`.`name`";i:3;s:24:"`Property`.`contract_id`";i:4;s:23:"`Property`.`project_id`";}s:32:"e28094193de614de1d85b0c79c530298";a:2:{i:0;s:15:"`Contract`.`id`";i:1;s:17:"`Contract`.`name`";}s:32:"538ee0bafc399d81de10e751c916c813";a:1:{i:0;s:19:"COUNT(*) AS `count`";}s:32:"aa387180f69eb573b365e247c4ec3eae";a:5:{i:0;s:20:"`Plan`.`installment`";i:1;s:21:"`Deal`.`total_amount`";i:2;s:18:"`Deal`.`recurring`";i:3;s:13:"`Deal`.`date`";i:4;s:23:"`Deal`.`booking_amount`";}s:32:"aefb3bc5f3017ce07540da8a1d0c413d";a:11:{i:0;s:15:"`Purchase`.`id`";i:1;s:23:"`Purchase`.`project_id`";i:2;s:17:"`Purchase`.`name`";i:3;s:20:"`Purchase`.`address`";i:4;s:19:"`Purchase`.`mobile`";i:5;s:26:"`Purchase`.`property_name`";i:6;s:24:"`Purchase`.`description`";i:7;s:17:"`Purchase`.`area`";i:8;s:20:"`Purchase`.`unit_id`";i:9;s:19:"`Purchase`.`amount`";i:10;s:20:"`Purchase`.`remarks`";}s:32:"8d6dc5db778d205c91c1a4065104e8a9";a:3:{i:0;s:10:"`Tax`.`id`";i:1;s:15:"`Tax`.`percent`";i:2;s:12:"`Tax`.`name`";}s:32:"4c1d5383336866bbbb4529018cddf996";a:1:{i:0;s:19:"COUNT(*) AS `count`";}s:32:"c884404e72f41e604984d88ecd4d28f5";a:8:{i:0;s:19:"`PlansPayment`.`id`";i:1;s:20:"`Deal`.`property_id`";i:2;s:21:"`Deal`.`total_amount`";i:3;s:16:"`Deal`.`user_id`";i:4;s:19:"`Deal`.`invoice_no`";i:5;s:21:"`PlansPayment`.`name`";i:6;s:23:"`PlansPayment`.`amount`";i:7;s:21:"`PlansPayment`.`date`";}s:32:"808c26ab98ca823b67d1378027af6a9f";a:3:{i:0;s:10:"`Tax`.`id`";i:1;s:12:"`Tax`.`name`";i:2;s:15:"`Tax`.`percent`";}s:32:"d3416fa8fd4d128c2a84e15a33fb3de6";a:1:{i:0;s:19:"`DealsPayment`.`id`";}s:32:"b7ea15b53316fc4d18feca20aa7e637b";a:16:{i:0;s:11:"`Deal`.`id`";i:1;s:16:"`Deal`.`user_id`";i:2;s:18:"`Deal`.`client_id`";i:3;s:20:"`Deal`.`property_id`";i:4;s:27:"`Deal`.`properties_flat_id`";i:5;s:16:"`Deal`.`plan_id`";i:6;s:19:"`Deal`.`invoice_no`";i:7;s:13:"`Deal`.`date`";i:8;s:21:"`Deal`.`evocate_date`";i:9;s:18:"`Deal`.`recurring`";i:10;s:23:"`Deal`.`booking_amount`";i:11;s:17:"`Deal`.`discount`";i:12;s:21:"`Deal`.`total_amount`";i:13;s:16:"`Deal`.`remarks`";i:14;s:16:"`Deal`.`created`";i:15;s:17:"`Deal`.`modified`";}s:32:"568412593e6981e6a04536915c26f2db";a:1:{i:0;s:19:"COUNT(*) AS `count`";}s:32:"6bce022a64bc0bbd5357bbaf52929fb1";a:5:{i:0;s:19:"`PlansPayment`.`id`";i:1;s:24:"`PlansPayment`.`deal_id`";i:2;s:21:"`PlansPayment`.`name`";i:3;s:23:"`PlansPayment`.`amount`";i:4;s:21:"`PlansPayment`.`date`";}s:32:"ff94a8654c596b8cec7d2b39929656eb";a:16:{i:0;s:11:"`Deal`.`id`";i:1;s:16:"`Deal`.`user_id`";i:2;s:18:"`Deal`.`client_id`";i:3;s:20:"`Deal`.`property_id`";i:4;s:27:"`Deal`.`properties_flat_id`";i:5;s:16:"`Deal`.`plan_id`";i:6;s:19:"`Deal`.`invoice_no`";i:7;s:13:"`Deal`.`date`";i:8;s:21:"`Deal`.`evocate_date`";i:9;s:18:"`Deal`.`recurring`";i:10;s:23:"`Deal`.`booking_amount`";i:11;s:17:"`Deal`.`discount`";i:12;s:21:"`Deal`.`total_amount`";i:13;s:16:"`Deal`.`remarks`";i:14;s:16:"`Deal`.`created`";i:15;s:17:"`Deal`.`modified`";}s:32:"a1aba5c0d9c063de80427797c2c23a2b";a:1:{i:0;s:19:"COUNT(*) AS `count`";}s:32:"468ba9e9b6d91ff99b6a74a94758d9c7";a:10:{i:0;s:15:"`Calendar`.`id`";i:1;s:20:"`Calendar`.`user_id`";i:2;s:25:"`Calendar`.`message_type`";i:3;s:23:"`Calendar`.`start_date`";i:4;s:21:"`Calendar`.`end_date`";i:5;s:18:"`Calendar`.`color`";i:6;s:21:"`Calendar`.`comments`";i:7;s:22:"`Calendar`.`is_repeat`";i:8;s:24:"`Calendar`.`repeat_type`";i:9;s:22:"`Calendar`.`repeat_no`";}s:32:"ba0d7204776a81c7c0d43b36137afc63";a:1:{i:0;s:19:"COUNT(*) AS `count`";}s:32:"c17a523fa78fdaeb8a6f34bb8a6c862a";a:1:{i:0;s:19:"COUNT(*) AS `count`";}s:32:"51e629d1a7b1c0b29edcb9545565a9fd";a:4:{i:0;s:11:"`Type`.`id`";i:1;s:13:"`Type`.`name`";i:2;s:13:"`Type`.`dirt`";i:3;s:14:"`Type`.`photo`";}}}
