99'
We are trying to 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 CONDITION
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 CONDITION
te, "%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
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 appointmen
(a.time_start) >= 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
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
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
g 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
eath ;oP
Thanks!
Don Wieland
d...@pointmade.net
http://www.pointmade.net
https://www.facebook.com/pointmade.band
+outfile
> http://stackoverflow.com/questions/6091427/mysql-into-outfile-access-denied-but-my-user-has-all-access-and-the-fold
Don Wieland
d...@pointmade.net
http://www.pointmade.net
https://www.facebook.com/pointmade.band
o resolve this issue asap.
Don Wieland
d...@pointmade.net
http://www.pointmade.net
https://www.facebook.com/pointmade.band
rst_name
INTO OUTFILE '/tmp/1_2031305738.csv'
FIELDS TERMINATED BY ','
ENCLOSED BY '"']
Don Wieland
d...@pointmade.net
http://www.pointmade.net
https://www.facebook.com/pointmade.band
EIF NEW.content_asset_type_code = 'VIDEO' THEN
INSERT INTO videos (content_asset_id) VALUES (NEW.id);
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_t
:= 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/mys
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
exchang
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
chan
arlier with ANY user, those appts can 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 Gene
4 ---
SELECT count(*) AS dr_all_ther_qty FROM tl_appt LEFT JOIN tl_rooms r
on r.room_id = tl_appt.room_id WHERE client_id = '254023' AND
r.location_id = '1' AND user_id = '506' AND appt_status_id = '3' AND
time_start > '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,
MIN(apt.time_sta
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
F
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 be
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 in
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 d
27 matches
Mail list logo
