I have a result set of parent categories and subcategories. I want to exclude all parent categories if a subcategory exists in the results. What I would do is using a NOT IN in the query, but that requires a…
I need to adjust the following select statement to effectively filter out 523 records where 'first_date_purchased' is less than 'first_date_watched'. The following select statement returns 20778 records, of which 20255 should remain. SELECT se.student_id, si.date_registered, MIN(se.date_watched) AS first_date_watched, MIN(sp.date_purchased) AS…
I have table towns which is main table. This table contains so many rows and it became so 'dirty' (someone inserted 5 milions rows) that I would like to get rid of unused towns. There are 3 referent table that…
I have this following query that needs to be optimized Select 1 As status, e.entity_id, e.attribute_set_id, e.type_id, e.created_at, e.updated_at, e.sku, e.name, e.short_description, e.image, e.small_image, e.thumbnail, e.url_key, e.free, e.number_of_downloads, e.sentence1, e.url_path From catalog_product_flat_1 As e Inner Join catalog_category_product_index_store1 As cat_index On…