I have a query something like SELECT S.product_id, S.link, C.id AS category_id FROM Products P INNER JOIN SEO S ON S.product_id = P.id AND P.product_type = 1 LEFT OUTER JOIN Categories C ON c.product_id = P.id WHERE P.active = 1…
I have database in mysql & have maintain 3 columns i.e. ID , name, slug. Slug column is same as name but here I put combination of name column. Suppose if name is Micky Mehta then in slug I want…
help me understand why i am getting different COUNTS Query 1 SELECT Count(*) FROM `foo` WHERE `status_id` = 2 AND `updated_at` < Date(Now() - INTERVAL 1 day) AND `number` LIKE 'A390%' OR `number` LIKE 'A391%' OR `number` LIKE 'A392%' results…
im making an autocomplete search box that lists different courses, and basically what im trying to do is use a search button next to it to display the results of the selected course on another page using an SQL database.…
In my application (osCommerce) I had to modify a query that look like this: SELECT sql_cache distinct p.products_image, p.products_subimage1, pd.products_name, p.products_quantity, p.products_model, p.products_ordered, p.products_id, p.products_price, p.products_date_added, p.products_weight, p.products_length, p.products_width, p.products_height, p.products_tax_class_id, p.products_status, IF(s.status, s.specials_new_products_price, NULL) AS specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price)…
i want to get records which is present in employees table but not in department i.e (Employees - department) output should be like this Employee(ID,Name), Department(Id,Name) i tried this select * from Employee as e left join Department as d…
Table : Post id user_id group_id Text 1 1 1 AAA 2 2 2 BBB 3 2 2 CCC 4 3 2 DDD 5 2 3 EEE Table : UserMaster user_id username 1 Raj 2 Meet 3 Kishan Table :…
Background: First off I'm using plesk 11.5 which I'm planning to migrate to plesk 12 and a new server. I have a lot of domains on old an server, plenty of subscriptions and customers. What I want to do: I…
I am new to SQL and am practicing on the HR schema available on Oracle 10g XE. This is the question: Write a query to select the name, job, and salary and department number of all employees except Sales Rep…
List the number of Students enrolled for each module code: I am having trouble with this query, what I am looking to do is a select statement for example select count(studID) from student where ModCode = 'C102' The intended output…