sql

vfranklyn's picture

Problem with SQL statement in Views D7

Hi there, I'm hoping a SQL ninja will find it in his or her heart to provide me with some advice.

I've created a page view which does the following:

  1. Pulls in nodes from two different content types
  2. Filters by two different term references, one for each content type.

It's not working, although in my mind (and limited sql understanding), it should. I think maybe there's an issue with the inner joins, because it seems the sql statement would working if they weren't there.

Anyways, I've attached two images, one of the api and one of the actual sql statement.

Read more
Annie Abraham's picture

Mid-Senior PHP Web Developer | Goldstone Partners

Employment type: 
Full time
Telecommute: 
Not allowed

VisionLink develops web-based applications for non-profits and government organizations that help people in need. VisionLink's technology is behind honorable institutions such as the American Red Cross, the United Way, and a myriad of social service organizations providing services to everyday people that need help from natural disasters to homelessness. Our technology supports 3-1-1- call centers, FEMA and other national, state and local organizations’ mission critical operations.

Read more
sasha.yershov's picture

Technical Account Managers | Acquia

Employment type: 
Full time
Telecommute: 
Allowed

Acquia is looking for Drupal experts and technical advisors to join our technical account management team to help us provide exceptional service to our growing customer base, from Fortune 500 clients to government agencies.

Summary:

Read more
sasha.yershov's picture

Technical Architect / Sr. Technical Architect | Acquia

Employment type: 
Full time
Telecommute: 
Allowed

Acquia is looking for Drupal Architects who have a passion for delivering killer web experiences and wowing their customers.

Summary:

Read more
lross's picture

Developer | MarketVision Research

Employment type: 
Full time
Telecommute: 
Not allowed

MarketVision Research is a full-service marketing research firm based in Cincinnati. The firm conducts proprietary research for clients focusing on strategic marketing issues. Clients are generally Fortune 500 companies with specific industry expertise in the food and beverage, consumer packaged goods, financial services, healthcare, pharmaceutical and retail sectors. MarketVision was founded in 1983, is one of the 50 largest marketing research firms in the United States. Offices are in Cincinnati, Cleveland, Dallas/Ft. Worth, Indianapolis, Los Angeles, New York and Philadelphia.

Read more
dgersten's picture

Senior Web Developer | University of Illinois, College of ACES

Employment type: 
Full time
Telecommute: 
Not allowed

This search has been extended until July 7, 2014

The College of Agricultural, Consumer and Environmental Sciences (ACES) at the University of Illinois at Urbana-Champaign is accepting applications to fill a Senior Web Developer position. The person in this position will provide primary leadership in creating the overall strategic plan for structured programming that enhances and supports our content management system (CMS-currently Drupal) and other legacy applications for the College of ACES' online presence. This is a full-time academic professional position in Information Technology and Communication Services (ITCS). The Senior Web Developer will be a member of the Web Management and Support (WMS) team within ITCS and report to the Team Leader for WMS.

Read more
charlet's picture

Drupal Developer | IT Recruiters LLC

Employment type: 
Contract
Telecommute: 
Allowed

IT Recruiters, LLC has openings for Drupal Programmers/Developers.
THIS IS A REMOTE-ON SITE HYBRID (2 days on site, rest remote -- days are flexible) BASED IN WASHINGTON, DC.

Position: Drupal Developer

Duration: Open

Rate: $55-$70 per hour-contract. We WANT to pay you :)

Location: Remote with 2 days on site (Washington, DC -- days and times are flexible on that).

Read more
workman's picture

Freelance Drupal Developer | Clinical Tools, Inc.

Employment type: 
Contract
Telecommute: 
Allowed

Clinical Tools, Inc. is looking for someone to join our Drupal development team to review and maintain our Drupal 7 code base, as well as provide continual improvements to our internal DLearning module system based on user-feedback.

The preferred applicant will have experience with module development and Drupal 7 programming, as well as a consistent schedule of availability and communication exchange. Must have a background in PHP, XML, HTML, Javascript, CSS, SQL, and website architecture. HTML 5 experience is a plus, but not a necessity.

Read more
Joe McMonagle's picture

Drupal Backend Developer - Central Ohio | Exigo Search

Employment type: 
Full time
Telecommute: 
Not allowed

Exigo Search, the complete search solution, is seeking a Drupal Developer with strength in backend support and development for a contract-to-hire assignment in central Ohio. Hoping a former central Ohioan is looking to return.

Advanced Drupal CMS skills including module development with a focus on best practices and security.

Ideally you should have:

At least 5 years experience with php

At least 5 years experience with MySQL 5, database administration is a bonus.

Experience working in a VPS environment

Read more
Joe McMonagle's picture

Drupal Backend Developer | Exigo Search

Employment type: 
Full time
Employment type: 
Contract
Telecommute: 
Not allowed

Exigo Search, the complete search solution, is seeking a Drupal Developer with strength in backend support and development for a contract-to-hire assignment in central Ohio.

Advanced Drupal CMS skills including module development with a focus on best practices and security.

Ideally you should have:

At least 5 years experience with php

At least 5 years experience with MySQL 5, database administration is a bonus.

Experience working in a VPS environment

At least 3 years experience with Apache 2.2 web server, including configuration, mod_rewrite, and mod_security

Read more
Subscribe with RSS Syndicate content