Here is the query I tried to write and gives an error $users =User::has('subscriptions', function (Builder $q) { $q->whereNotNull('ends_at'); })->get(); Getting this error SQLSTATE[42601]: Syntax error: 7 ERROR: SELECT * with no tables specified is not valid LINE 1: ...sers"."id"…
I have a wallet table like this: // wallet +----+----------+--------+ | id | user_id | amount | +----+----------+--------+ | 1 | 5 | 1000 | | 2 | 5 | -200 | | 3 | 5 | -100 | |…
I have three tables in my database, one for clients, one for products and one for orders, containing both the primary keys of products and clients as a foreign key. I am using SQL and MySQL A query I'm struggling…
I have a very similar problem to this one: Count unique occurrences per each distinct variable in MySQL but with a twist. I'm working with a select statement that shows results much like what the above-mentioned question does. If I…
I'm trying to return 2 columns for a graph on with date and the other with count of jobs for the date. Jobdate is a timestamp however. So although the first query is instant, it will give a new row…
In Service When I use print the keys that output null but print the ids that is correct please tell me why I'm sure the database has data orderBean @EntityListeners(AuditingEntityListener.class) @Entity @Table(name = "`Order`") public class OrderBean { @Id @GeneratedValue(strategy…
MySQL official documentation 8.8.5 Estimating Query Performance offers the way to count disk seeks: log(row_count) / log(index_block_length / 3 * 2 / (index_length + data_pointer_length)) + 1 In MySQL, an index block is usually 1,024 bytes and the data pointer…
I'm running npx sequelize-cli db:migrate to create the table in the database and returns the following message: Sequelize CLI [Node: 18.9.1, CLI: 6.5.1, ORM: 6.20.1] ERROR: Cannot find "/src/db/migrations/config/config.json". Have you run "sequelize init"? ERROR: Cannot read properties of undefined…
I have a query setup for data verification that will join a few tables and auto-convert currencies from non-USD to USD. SELECT c.Id, c.Currency , cr.CPDealId, cr.UnderwriterId, cr.PlacedDate, cr.Fee, cr.FeeDue, cr.AllocatedFeeDue , f.Rate , (CASE WHEN c.Currency <> 'USD' THEN…
I have scenario like below Sign up promo code The sign up promo code, if applicable, is what the member used to create their membership. Our system currently creates a new line for a member each time they make a…