o find Former Clients who have not been seen after the date
range - Lapsed Client Report
Don Wieland
d...@pointmade.net
http://www.pointmade.net
https://www.facebook.com/pointmade.band
Hi gang,
Trying to get the correct syntax on this:
ORDER BY
CASE
WHEN tr.Placed = "X" THEN r.Division ASC,
FIELD(tr.Place,"1","2","3","4","5","6","7","8","R","WD","Exc","E","S”),
tr.Score DESC
WHEN tr.Placed != "X" THEN tr.ride_time ASC
END
How does one deal with
Hi gang,
Trying to get the correct syntax on this:
ORDER BY
CASE
WHEN tr.Placed = "X" THEN r.Division ASC,
FIELD(tr.Place,"1","2","3","4","5","6","7","8","R","WD","Exc","E","S”),
tr.Score DESC
WHEN tr.Placed != "X" THEN tr.ride_time ASC
END
How does one deal with
cl_date, "%M %Y") AS mo_label FROM
tl_items_classes ic
LEFT JOIN tl_items i ON ic.item_id = i.item_id
WHERE i.active = 1 AND ic.cl_cancelled IS NULL ORDER BY ic.cl_date ASC;
Any help would be appreciated.
Don Wieland
d...@pointmade.net
http://www.pointmade.net
https://www.facebook.com/pointmade.band
art) >= UNIX_TIMESTAMP(DATE_SUB( NOW(), INTERVAL 24 MONTH))
AND last_appt IS NOT NULL AND count(a.client_id) >= 2;
BUT, how do I add the other “condition b” to the query to get an accurate end
result.
I’d appreciate any help.
Don Wieland
D W D a t a C o n c e p t s
~~
Hey gang,
I need the ability to produce this end result:
condition a) All clients who have had at least 2 appointments in the last 24
months
condition b) of the set of “condition a” rows, which of those have NO
appointments in the last 6 months
I am able to get the clients with >= 2
tried that - actually the SUM I need is on the JOIN relationship -
results should be:
1,Banana,3
2,Orange,5
3,Melon,6
Thanks!
Don Wieland
d...@pointmade.net
http://www.pointmade.net
https://www.facebook.com/pointmade.band
invoice_InvoiceLines i ON p.pk_ProductID = i.fk_ProductID AND
i.fk_InvoiceID IN (1,2,3)
WHERE p.pk_ProductID IN (1,2,3)
GROUP BY i.fk_ProductID;
but it is not working.
Little help please. Thanks!
Don Wieland
d...@pointmade.net
http://www.pointmade.net
https://www.facebook.com/pointmade.band
ransaction_id
WHERE ht.donor_id = 730 AND ht.tr_date BETWEEN "2015-01-01 00:00:00" AND
"2015-12-31 23:59:59"
GROUP BY ht.`transaction_id`
ORDER BY ht.tr_date DESC, ht.rec_code ASC;
Don Wieland
d...@pointmade.net
http://www.pointmade.net
https://www.facebook.com/pointmade.band
showing one row of the “hiv_transactions” table when there are
multiple rows.
On the GROUP_CONCAT I am trying to get a comma delineated list of the child
rec_code with no duplicates
Appreciate any help. Hopefully a small mod ;-)
Don Wieland
D W D a t a
Hey gang,
I need a few hours of support from a LAMP developer to resolve a few issues via
TeamViewer or GoToMeeting. Anyone who is interested, has the skills, and can
offer this to me, please contact me PRIVATELY. Please include your support
hourly rate.
Thanks!
Don Wieland
d
TERMINATED BY ','
ENCLOSED BY '']
Don Wieland
d...@pointmade.net
http://www.pointmade.net
https://www.facebook.com/pointmade.band
asap.
Don Wieland
d...@pointmade.net
http://www.pointmade.net
https://www.facebook.com/pointmade.band
-but-my-user-has-all-access-and-the-fold
Don Wieland
d...@pointmade.net
http://www.pointmade.net
https://www.facebook.com/pointmade.band
!
Don Wieland
d...@pointmade.net
http://www.pointmade.net
https://www.facebook.com/pointmade.band
);
END IF;
INSERT INTO content_asset_statistics (content_asset_id,
statistic_type_code, seq) SELECT NEW.id, statistic_type_code, seq from
content_asset_statistic_types where content_asset_type_code =
NEW.content_asset_type_code;
END;
Appreciate it.
Don Wieland
--
MySQL
= (a := a + 1)
WHERE
document_category = category
ORDER BY
sort_id;
END
//
Don Wieland
d...@pointmade.net
http://www.pointmade.net
https://www.facebook.com/pointmade.band
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
contact me, privately, if you can assist. I am located in California,
USA (PST). Thanks!
Don Wieland
d...@pointmade.net
http://www.pointmade.net
Greetings,
I have a site that I am developing and I am looking to partner/
developer with great php/mySQL skills (for share of potential profits)
to assist me in finishing this site. I am looking for someone who can
invest (like myself) their time and skills to complete the site in
Hi all,
I built a system in PHP/mySQL where a group of users post events, sign-
up for events, change their arrival times, remove thier names from
events, and post related notes on the events. Each time an action is
done, an email is generated to the entire group that their has been a
be earlier
than the start of the date range.
If they have a count of ZERO appts prior to the earliest appt within
the date range, the are a NEW CLIENT else a FORMER CLIENT.
Any assistance would be appreciated. Thanks!
Don Wieland
--
MySQL General Mailing List
For list archives: http
'1321903800'
--- end query 4 ---
Don Wieland
D W D a t a C o n c e p t s
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql
I have got this query that returns the correct rows I want to display,
BUT the columns dr_ther_qty, dr_not_ther_qty, and dr_all_ther_qty are
not calculating correctly:
--- START QUERY ONE ---
SELECT q1.* FROM
(SELECT apt.user_id, apt.client_id, c.last_name, c.first_name,
Hi folks,
I am trying to compile a query that does statistics on appointments
based on specific criteria. Here is my starting query:
SELECT
u.user_id,
c.client_id,
c.first_name,
c.last_name,
a.time_start AS stime,
FROM_UNIXTIME(a.time_start,'%Y-%m-%d') AS formatted
Hello,
I have a client who needs the ability to do statistical reporting on
their mySQL db data. Is there an app that provides an easy UI that
will allow my client to build a line item query, specify fields to be
include in the result of the query, and then design the way the data
will
Appreciate a little guidance here:
Background: I have an invoicing system. Invoices are generated and
(invoice and Invoice Items) and Payments are generated (Payments and
Payment Items). Payment items are amount of the Payment Total
allocated to payoff open invoices. So I may have 3 open
Little help...
In my mySQL query editor, I am trying to return a value of 0 when
there is no related rows from this query:
(select if(count(ip.payment_amount) IS NOT NULL,
count(ip.payment_amount) , 0) FROM tl_trans_pmt_items ip WHERE
t.transaction_id = ip.inv_id GROUP BY ip.inv_id) as
27 matches
Mail list logo