SQLSTATE[42000]: Syntax error or access violation: 1142 SELECT command denied to user 'u468924622_sam'@'localhost' for table `u468924622_lc1`.`subadmin1` (SQL: select `code`, `name` from `subadmin1` where `country_code` = IN order by JSON_UNQUOTE(JSON_EXTRACT(IF(JSON_VALID(name), name, JSON_OBJECT('en', name)), '$.en')) asc)
SQLSTATE[42000]: Syntax error or access violation: 1142 SELECT command denied to user 'u468924622_sam'@'localhost' for table `u468924622_lc1`.`posts` (SQL: select count(*) as aggregate from (select `posts`.`id`, `country_code`, `category_id`, `post_type_id`, `title`, `posts`.`price`, `city_id`, `featured`, `posts`.`created_at`, `reviewed`, `verified_email`, `verified_phone`, `tPackage`.`lft`, (posts.price * 1) AS calculatedPrice from `posts` inner join (select MAX(lp.id) as lpId, `lp`.`post_id` from `payments` as `lp` where `lp`.`active` = 1 group by `lp`.`post_id`) as `tmpLp` on `tmpLp`.`post_id` = `posts`.`id` and `featured` = 1 inner join `payments` as `latestPayment` on `latestPayment`.`id` = `tmpLp`.`lpId` inner join `packages` as `tPackage` on `tPackage`.`id` = `latestPayment`.`package_id` where `country_code` = IN and (`verified_email` = 1 and `verified_phone` = 1) and `archived` = 0 and exists (select * from `categories` where `posts`.`category_id` = `categories`.`id` and `active` = 1) and exists (select * from `cities` where `posts`.`city_id` = `cities`.`id` and `active` = 1) and `verified_email` = 1 and `verified_phone` = 1 group by posts.id) as `aggregate_table`)
SQLSTATE[42000]: Syntax error or access violation: 1142 SELECT command denied to user 'u468924622_sam'@'localhost' for table `u468924622_lc1`.`categories` (SQL: select * from `categories` where (`parent_id` = 0 or `parent_id` is null) and `active` = 1 order by `lft` asc)
SQLSTATE[42000]: Syntax error or access violation: 1142 SELECT command denied to user 'u468924622_sam'@'localhost' for table `u468924622_lc1`.`posts` (SQL: select count(*) as aggregate from (select `posts`.`id`, `country_code`, `category_id`, `post_type_id`, `title`, `posts`.`price`, `city_id`, `featured`, `posts`.`created_at`, `reviewed`, `verified_email`, `verified_phone`, `tPackage`.`lft`, (posts.price * 1) AS calculatedPrice from `posts` left join (select MAX(lp.id) as lpId, `lp`.`post_id` from `payments` as `lp` where `lp`.`active` = 1 group by `lp`.`post_id`) as `tmpLp` on `tmpLp`.`post_id` = `posts`.`id` and `featured` = 1 left join `payments` as `latestPayment` on `latestPayment`.`id` = `tmpLp`.`lpId` left join `packages` as `tPackage` on `tPackage`.`id` = `latestPayment`.`package_id` where `country_code` = IN and (`verified_email` = 1 and `verified_phone` = 1) and `archived` = 0 and exists (select * from `categories` where `posts`.`category_id` = `categories`.`id` and `active` = 1) and exists (select * from `cities` where `posts`.`city_id` = `cities`.`id` and `active` = 1) and `verified_email` = 1 and `verified_phone` = 1 group by posts.id) as `aggregate_table`)
SQLSTATE[42000]: Syntax error or access violation: 1142 SELECT command denied to user 'u468924622_sam'@'localhost' for table `u468924622_lc1`.`posts` (SQL: select count(*) as aggregate from `posts` where `country_code` = IN and `archived` = 0 and `verified_email` = 1 and `verified_phone` = 1)
The Simple Social Renting Formula: Need Something → Find It Nearby → Rent It Monthly → Use It → Return When Done...
Simple, fast and efficient