omd | OMD - Open Monitoring Distribution Labs Edition | Continuous Deployment library

You can't operate integer with datetimes. Here you are trying to do that twice:

The problem is that your axios.get("https://www.omdbapi.com/ calls all happen in parallel, and there's no guarantee they will complete in the order in which you start them.

You can either fire them sequentially (one by one), or you can add the element to the HTML before firing the get call, and then update the element when you get a response.

Something like this:

It doesn't seem like you're fetching OmdPractices records in Admin::OdPracticesController#index. Try this.

Derived is a temporary table created possibly for your inline views in the query thats created, here derived10 is referring to id =10 calculations and derived2 is referring to id=2 Derived tables in explain plan output, if you see the 'table' in explain plan output awb (derived2) air_way_bills in first inline view and awb9 (derived10) again the air_way_bills in later part of query, you have to check the inline views in your query which are referencing this tables and fine tune it.

quick tip:- seeing your explain plan there are lot of full table scan going on you should design the index properly for the same and avoid not needed clause or unwanted conversions or unwanted sorting in the query, first step is to remove not wanted elements in the query and create index on the columns in where clause and see if it improves your query performance.

Here im adding the link to reference for in dept details

https://dev.mysql.com/doc/refman/8.0/en/derived-table-optimization.html

your query is almost correct you were missing on alias instead of p you should use 'product' in second query, it would work

I think your problem is with the first sub-query. Your column is not called "quantity" but "sum(omd.quantity)". You have to give an alias to the columns in the subquery like so:

Do not add ORDER BY after GROUP BY WITH ROLLUP. Convert your query to subquery (or CTE if its version is 8+) and sort its output in outer query storing rollup result last:

I'm not sure if I understand the question correctly, but maybe the problem is because of the absolute positioning of those ul-s. You cannot expect elements with position: absolute to push the elements around them as they grow. Try with position: relative.

The easiest way would be to use the mp4 of that video instead of the gif, like so: