Hello everyone: I have a query that works well, but I'm trying to see if I can clean up my results a little bit. The query pulls the State and Fiber ID fields from my table called fiber_intake. It then pulls all fields from my hvi table where the Fiber ID = GA in the fiber_intake table. Code: SELECT `fiber_intake`.`State`, `fiber_int...
Hi everyone, I'm having an issue with cakePHP pagination, specifically when I do a left join. There are 6 rows returned, and with a pagination limit of 3, it should calculate 2 pages, but it calculates 3 pages, with the last page being blank. Here is the options array I'm passing to paginate: Array ( [fields] => Array ( ...
Hello, Currently this function works : it displays for a specific game, how many jobs there are. The problem : If there is no job, the game does not appear on the list. How to display the game even if there is no job attached ? Thanks public function getWithGames() { $q = $this->createQuery('c') ->leftJoin...
I'm having a heckuva time figuring out how to translate a simple SQL LEFT OUTER JOIN with a two condition where clause into a working Linq-to-Entities query. There are only two tables. I need values for all rows from Table1, regardless of matches in Table2, but the WHERE clause uses fields from Table2. In SQL, the two parameters would...
Hi there, I'm running a query in MYSQL using LEFT JOIN to get users and their user groups. Both tables have columns named id. My result is being returned in an array (PHP) so that I have one array with all field data, but also only one array["id"]. Here's my query so far: SELECT usr.id, usg.id FROM users usr LEFT JOIN (user_gro...
The exact query: SELECT coupon_coupons.code, coupon_coupons.discountType AS 'type', coupon_coupons.discountAmount AS 'amount', coupon_coupons.discountApplied AS 'applied', coupon_coupons.description, group_concat(coupon_targetsku.sku separator ';') AS 'targetsku' FROM coupon_coupons LEFT ...
I'm trying to get some aggregate values from different tables, but my problem is that they're being returned incorrectly, i.e. as multiplications of each other. I've got these tables: Institutes ---------- ID name Conversions ----------- ID institute_id training_id Trainings --------- ID institute_id And I want to do get the Instit...
Im a little puzzled here, can someone just look over this query and tell me am i doing anything wrong? SELECT d.* FROM as_downloads d LEFT JOIN as_categories c ON (d.download_category_id = c.category_id) WHERE d.download_category_id != -1 LIMIT 30 Fetching the rows from the as_downloads table but not joining the categories table.. Th...
I have two tables, jos_eimcart_customers_addresses and jos_eimcart_customers. I want to pull all records from the customers table, and include address information where available from the addresses table. The query does work, but on my localhost machine it took over a minute to run. On localhost, the tables are about 8000 rows each, but ...
Hi, I have been trying to wrap my head around this issue but I am not making much progress. My goal is to do a left join between two tables with criteria for the right table. I would like to see the list of all products and prices for the current day even though there is no pricing row for the current day. Here is an example of the c...
Hi all, I'm trying to write ObjectQuery with few consistent GroupJoin, it means that there should be one main table selection + few additional LEFT JOIN. I'm doing it as following, with SelectMany method, because without it I can't access field RoleID : var routesQuery = entities.Routes.Join( entities.Locales, ...
I've got this query so far: if(!empty($_SESSION['s_property_region'])) { $sqlWHERE .= " AND $wpdb->postmeta.meta_key = 'property_region' AND $wpdb->postmeta.meta_value = '".$_SESSION['s_property_region']."'"; } if(!empty($_SESSION['s_property_bedrooms'])) { $sqlWHERE .= " AND $wpdb->postmeta.meta_key = 'property_bedrooms' AND $...
I have two table like below CREATE TABLE IF NOT EXISTS `countries` ( `id` int(11) NOT NULL AUTO_INCREMENT, `name` varchar(255) DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=196 ; ANd ANother one CREATE TABLE IF NOT EXISTS `students` ( `id` int(11) NOT NULL AUTO_INCREMENT, `admission...